efeef
Tables (5)
Budget (Untitled3)
- PK — INT — Primary key — NOT NULL
- FK — INT — Foreign key → User.PK — NOT NULL
- Field (goal_price) — INT
- Field (alarm_percent) — DOUBLE
Category (Untitled4)
- PK — INT — Primary key — NOT NULL
- FK — INT(NULLABLE) — Primary key — NOT NULL
- Field (name) — String
- Field (iconpath) — String
- Field (is_default) — boolean
- Field (TYPE) — ENUM(INCOME/EXPENSE)
Statistics (Untitled5)
- PK — INT — Primary key — NOT NULL
- Field
Transaction (Untitled2)
- PK — INT — Primary key — NOT NULL
- fk (FK) — INT — Foreign key → Category.PK — NOT NULL
- Key — Foreign key → Category.FK — NOT NULL
- fk — INT — Foreign key → User.PK — NOT NULL
- Field (price) — INT
- Field (memo) — String
- Field (createdAt) — Date
- Field (modifiedAt) — Date
- Field (is_mark) — boolean
- Field (is_fixed) — boolean
User (Untitled)
- PK — INT — Primary key — NOT NULL
- Field (email) — String
- Field (password) — Stinrg
- Field (nickname) — String
- Field (birth) — Date
- Field (imagepath) — String