커플

테이블 (7)

anniversary

  • anniversary_id — BIGINT — 기본 키 — NOT NULL
  • couple_id — BIGINT — 외래 키 → couple.couple_id — NOT NULL
  • category_id — BIGINT — 외래 키 → anniversary_category.category_id — NOT NULL
  • title — VARCHAR(255)
  • date — DATE
  • range — ENUM('공통', '본인', '상대방')
  • is_all_day — BOOLEAN
  • alarm_start — TIME
  • alarm_end — TIME
  • repeatability — BOOLEAN
  • memo — VARCHAR(500)

anniversary_category

  • category_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255)

couple

  • couple_id — BIGINT — 기본 키 — NOT NULL
  • user1_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • user2_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • breaks_up (breaks up) — int

couple_comment

  • comment_id — BIGINT — 기본 키 — NOT NULL
  • couple_media_id — BIGINT — 외래 키 → couple_media.couple_media_id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • contents — VARCHAR(500)
  • created_at — DATETIME

couple_media

  • couple_media_id — BIGINT — 기본 키 — NOT NULL
  • couple_id — BIGINT — 외래 키 → couple.couple_id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • upload_date — DATETIME
  • star — INT
  • show_together — ENUM('혼자보기', '같이보기')

message

  • message_id — BIGINT — 기본 키 — NOT NULL
  • couple_id — BIGINT — 외래 키 → couple.couple_id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • contents — VARCHAR(500)
  • created_at — DATETIME
  • deleted_at — DATETIME
  • is_deleted — BOOLEAN

user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(13)
  • birthday — DATE
  • sex — ENUM('남', '여')
  • nickname — VARCHAR(10)
  • is_alarm — BOOLEAN
  • status_message — VARCHAR(255)
  • profile_picture — VARCHAR(500)
  • background_picture — VARCHAR(255)
  • couple_id — BIGINT — 외래 키 → couple.couple_id — NOT NULL