Shinhan
Tables (5)
budget
- primary_key (budget_id) — INT — Primary key — NOT NULL
- foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
- int_field (daily_budget) — INT
- int_field (expected_cost) — INT
- int_field (remains) — INT
- bool_field (over_budget) — BOOL
- char_field (sticker_sort) — VARCHAR(100)
calendar
- primary_key (calendar_id) — INT — Primary key — NOT NULL
- foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
- date_feild (date) — DATE
schedule
- primary_key (schedule_id) — int — Primary key — NOT NULL
- foreign_key (calendar_id) — INT — Foreign key → calendar.primary_key — NOT NULL
- foreign_key (user_id) — INT — Foreign key → calendar.foreign_key — NOT NULL
- char_field (personal_schedule) — VARCHAR(300)
- int_field (cost_limit) — INT
- char_field (category) — VARCHAR(100)
- int_field (expected_cost) — INT
- int_field (daily_budget) — INT
user
- primary_key (user_id) — INT — Primary key — NOT NULL
- char_field (name) — VARCHAR(50)
- int_field (age) — INT
- char_field (gender) — VARCHAR(50)
- int_field (interval) — INT
withdraw
- primary_key (withdraw_id) — INT — Primary key — NOT NULL
- foreign_key (schedule_id) — int — Foreign key → schedule.primary_key — NOT NULL
- foreign_key (calendar_id) — INT — Foreign key → schedule.foreign_key — NOT NULL
- foreign_key (user_id) — INT — Foreign key → user.primary_key — NOT NULL
- int_field (amount) — INT
- date_time_field (time) — DATETIME
- char_field (category) — VARCHAR(100)