couplesync

Tables (7)

anniversaries

  • anniversary_id — BIGINT
  • couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • anniversary_date — DATE — NOT NULL
  • type — VARCHAR(50)
  • is_auto_created — BOOLEAN

couple_members

  • couple_member_id — BIGINT
  • couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • joined_at — DATETIME

couples

  • couple_id — BIGINT
  • invite_code — VARCHAR(20) — NOT NULL
  • start_date — DATE
  • created_at — DATETIME

schedule_details

  • detail_id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.schedule_id — NOT NULL
  • detail_time — TIME
  • content — VARCHAR(255) — NOT NULL
  • sort_order — INT

schedules

  • schedule_id — BIGINT
  • couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
  • writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • location — VARCHAR(255)
  • start_datetime — DATETIME — NOT NULL
  • end_datetime — DATETIME
  • category — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

todos

  • todo_id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.schedule_id — NOT NULL
  • assigned_user_id — BIGINT — Foreign key → users.user_id
  • content — VARCHAR(255) — NOT NULL
  • is_done — BOOLEAN
  • created_at — DATETIME

users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME