커플
테이블 (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