asd
Tables (4)
EXPENSE (지출)
- KEY (id) — INT — Primary key — NOT NULL
- user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
- method_id (method) — INT — Foreign key → PAYMENT_METHOD.user_id — NOT NULL
- (category) — ENUM
- (amount) — INT
- (contents) — VARCHAR
- (created_at) — DATETIME
INCOME (수입)
- KEY (id) — INT — Primary key — NOT NULL
- user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
- (category) — ENUM
- (amount) — INT
- (source) — VARCHAR
- (created_at) — DATETIME
PAYMENT_METHOD (결제수단)
- KEY (id) — INT — Primary key — NOT NULL
- user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
- (method) — VARCHAR — NOT NULL
USER (사용자)
- KEY (id) — VARCHAR — Primary key — NOT NULL
- (name) — VARCHAR
- (password) — VARCHAR
- (salt) — VARCHAR