boost_accountbook
Tables (5)
Untitled (category)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- Field (type) — enum('Income', 'expense')
Untitled (pay_type)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
Untitled (user_pay_type)
- Key (user_id) — int — Foreign key → un.Key — NOT NULL
- Key (pay_type_id) — int — Foreign key → Untitled.Key — NOT NULL
house-hold (account)
- Key (id) — int — Primary key — NOT NULL
- Field (type) — enum('Income', 'expense') — NOT NULL
- Field (date) — datetime — NOT NULL
- Field (amount) — int — NOT NULL
- Field (content) — varchar(100) — NOT NULL
- Key (user_id) — int — Foreign key → un.Key — NOT NULL
- Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (pay_type_id) — int — Foreign key → Untitled.Key — NOT NULL
un (user)
- Key (id) — int — Primary key — NOT NULL
- Field (user_id) — varchar(20) — NOT NULL
- Field (password) — varchar(200) — NOT NULL
- Field (name) — varchar(20) — NOT NULL