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)