index — walletdrain @ 53ad629d62fde3314998255f50bb7464d93cedf9

Little app to track my spendings, for the time being only for music

features.md (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
- [ ] wishlist
    - [ ] name
    - [ ] price
    - [ ] link
    - [ ] store name
- [ ] bought items
    - [ ] same from wishlist
    - [ ] possibly receit
    - [ ] purchase date
- [ ] budget

---
### db schema
```sql
CREATE TABLE music (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        external_ids TEXT,
        name TEXT NOT NULL,
        price FLOAT,
        currency TEXT,
        returned_price FLOAT,
        returned_currency TEXT,
        category TEXT,
        seller TEXT,
        note TEXT,
        purchase_date TEXT);
```

### struct
```go
struct musicItem {
    id int,
    external_ids string,
    name string,
    price float,
    currency string,
    seller string,
    note string,
    purchase_date string,
}
```