거꾸로 가계부
테이블 (5)
Daily_Consumption (Untitled)
- date — NOT NULL — 기본 키 — NOT NULL
- history_id — NOT NULL — 외래 키 → History.history_id — NOT NULL
- user_id — NOT NULL — 외래 키 → History.user_id — NOT NULL
- records — NOT NULL
Goal (GOAL)
- icon_id — NOT NULL — 기본 키 — NOT NULL
- user_id — NOT NULL — 외래 키 → User.user_id — NOT NULL
- target amount (target amout) — NOT NULL
- target period start — NOT NULL
- target period end — NOT NULL
- memo (goal_memo) — NOT NULL
- monthly income — NOT NULL
- essential spending — NOT NULL
History
- history_id — NOT NULL — 기본 키 — NOT NULL
- user_id — NOT NULL — 외래 키 → User.user_id — NOT NULL
Record (RECORD)
- Key (record_id) — NOT NULL — 기본 키 — NOT NULL
- date — NOT NULL — 외래 키 → Daily_Consumption.date — NOT NULL
- history_id — NOT NULL — 외래 키 → Daily_Consumption.history_id — NOT NULL
- user_id — NOT NULL — 외래 키 → Daily_Consumption.user_id — NOT NULL
- content — NOT NULL
- cost — NOT NULL
- record_memo — NOT NULL
User (USER)
- user_id — NOT NULL — 기본 키 — NOT NULL