cho
Tables (12)
BUCKET_LIST
- bucket_id — INT
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- couple_id — INT — Foreign key → COUPLE.couple_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- category — ENUM('PLACE', 'ACTIVITY', 'FOOD') — NOT NULL
- content — TEXT
- status — ENUM('PLANNED', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CALENDAR
- calendar_id — INT
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- couple_id — INT — Foreign key → COUPLE.couple_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- visibility — ENUM('private', 'shared', 'partner_private') — NOT NULL
- created_at — DATETIME — NOT NULL
COUPLE
- couple_id — INT
- user1_id — INT — Foreign key → USER.user_id — NOT NULL
- user2_id — INT — Foreign key → USER.user_id — NOT NULL
- connected_at — DATETIME — NOT NULL
- is_active — BOOLEAN
- anniversary_date — DATE
- last_daily_question_at — DATETIME
COUPLE_QUESTION_STATUS
- couple_id — INT — Foreign key → COUPLE.couple_id — NOT NULL
- question_id — INT — Foreign key → DAILY_QUESTION.question_id — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- answered — BOOLEAN
- answered_at — DATETIME
DAILY_ANSWER
- answer_id — INT
- question_id — INT — Foreign key → DAILY_QUESTION.question_id — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- content — TEXT — NOT NULL
- emoji — VARCHAR(20)
- reply — TEXT
- created_at — DATETIME — NOT NULL
DAILY_QUESTION
- question_id — INT
- question_text — TEXT — NOT NULL
- question_date — DATE — NOT NULL
- is_active — BOOLEAN
DIARY
- diary_id — INT
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- couple_id — INT — Foreign key → COUPLE.couple_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- emotion — VARCHAR(50)
- weather — VARCHAR(50)
- photos — JSON
- is_shared — BOOLEAN
- created_at — DATETIME — NOT NULL
EVENT
- event_id — INT
- calendar_id — INT — Foreign key → CALENDAR.calendar_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- emoji — VARCHAR(20)
- location — VARCHAR(255)
- is_anniversary — BOOLEAN
- is_holiday — BOOLEAN
GAME
- game_id — INT
- type — ENUM('QUIZ', 'BALANCE') — NOT NULL
- question — TEXT — NOT NULL
- options — JSON — NOT NULL
- correct_answer — VARCHAR(255)
- is_active — BOOLEAN
- created_at — DATETIME — NOT NULL
HOLIDAY
- holiday_id — INT
- name — VARCHAR(255) — NOT NULL
- date — DATE — NOT NULL
- is_lunar — BOOLEAN
- is_repeat_yearly — BOOLEAN
RECOMMENDATION
- recommendation_id — INT
- content — TEXT — NOT NULL
- location — VARCHAR(255)
- price_range — INT
- is_date_course — BOOLEAN
- is_restaurant — BOOLEAN
- is_activity — BOOLEAN
- is_gift — BOOLEAN
- is_indoor — BOOLEAN
- is_outdoor — BOOLEAN
- like_count — INT
- created_at — DATETIME — NOT NULL
- is_active — BOOLEAN
USER
- user_id — INT
- nickname — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- is_active — BOOLEAN
- profile_image — VARCHAR(255)