2026-ECC-2-
테이블 (9)
대표곡 (rep_music)
- rep_music_id (Key) — LONG — 기본 키
- id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- music_id (Key3) — LONG — 외래 키 → 음악.music_id — NOT NULL — Auto Increment
- rep_music_created_at (Field) — TIMESTAMP — NOT NULL
- rep_music_updated_at (Field2) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
반응 (reactions)
- reaction_id (Key) — LONG — 기본 키 — NOT NULL
- bottle_id (Key2) — LONG — 외래 키 → 유리병.bottle_id — NOT NULL — Auto Increment
- reactor_id (Key3) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- reaction_created_at (Field) — TIME STAMP — NOT NULL
- reaction_updated_at (Field2) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
북마크 (bookmarks)
- bookmark_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- bottleId (Key3) — LONG — 외래 키 → 유리병.bottle_id — NOT NULL — Auto Increment
- bookmark_created_at (Field) — TIMESTAMP — NOT NULL
- bookmark_expires_at (Field2) — TIMESTAMP — NOT NULL
- bookmark_updated_at (Field3) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
사용자 (users)
- id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- user_id (Field) — VARCHAR(20) — NOT NULL — UNIQUE
- email (Field2) — VARCHAR(100) — NOT NULL — UNIQUE
- password (Field3) — VARCHAR(255) — NOT NULL
- nickname (Field4) — VARCHAR(10) — NOT NULL
- profileImage (Field5) — VARCHAR(500)
- bio (Field6) — VARCHAR(50)
- created_at (Field9) — TIMESTAMP — NOT NULL
- updated_at (Field10) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
오늘의 질문 (today_quests)
- question_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- question_text (Field) — TEXT — NOT NULL
- date (Field2) — DATE — NOT NULL — UNIQUE
- question_created_at (Field3) — TIMESTAMP — NOT NULL
- question_updated_at (Field4) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
유리병 (bottles)
- bottle_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- question_id (Key3) — LONG — 외래 키 → 오늘의 질문.question_id — NOT NULL — Auto Increment
- music_id (Key4) — LONG — 외래 키 → 음악.music_id — NOT NULL — Auto Increment
- memo (Field) — VARCHAR(200)
- is_shared (Field2) — BOOLEAN — NOT NULL
- total_count (Field3) — INT — NOT NULL
- bottle_created_at (Field4) — TIMESTAMP — NOT NULL
- bottle_updated_at (Field5) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
음악 (musics)
- music_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- track_name (Field) — VARCHAR(200) — NOT NULL
- artist_name (Field2) — VARCHAR(200) — NOT NULL
- album_cover_url (Field3) — VARCHAR(500)
- itunes_track_id (Field4) — VARCHAR(200) — NOT NULL — UNIQUE
- music_created_at (Field5) — TIMESTAMP — NOT NULL
- music_updates_at (Field6) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
음악 플랫폼 (platforms)
- platform_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- platform_name (Field) — NOT NULL
- platform_nickname (Field2)
- platform_created_at (Field3) — NOT NULL
- platform_updated_at (Field4) — ON UPDATE CURRENT_TIMESTAMP
친구 (friendships)
- friend_request_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
- friendship_status (Field) — VARCHAR(20) — NOT NULL
- requested_at (Field3) — TIMESTAMP
- unfriend_at (Field5) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
- updated_at (Field4) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
- requester_id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
- receiverId (Key3) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment