수락상
테이블 (10)
Users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- profile_image_url — VARCHAR(255) — S3, uri만 명명, UUID 추가
chart
- id — BIGINT — 기본 키 — NOT NULL
- music_id — BIGINT — 외래 키 → music.id — NOT NULL
- sequence — INT — NOT NULL
- lyrics — VARCHAR(50) — NOT NULL
- started_at — TIME — NOT NULL
- ended_at — TIME — NOT NULL
chart_answer
- id — BIGINT — 기본 키 — NOT NULL
- chart_id — BIGINT — 외래 키 → chart.id — NOT NULL
- started_at — TIME — NOT NULL
- ended_at — TIME — NOT NULL
- started_index — TINYINT — NOT NULL
- ended_index — TINYINT — NOT NULL
daily
- id — BIGINT — 기본 키 — NOT NULL
- day — INT — NOT NULL
- sentence — VARCHAR(255)
daily_vocabulary
- id — BIGINT — 기본 키 — NOT NULL
- daily_id — BIGINT — 외래 키 → daily.id — NOT NULL
- vocabulary_id — BIGINT — 외래 키 → vocabulary.id — NOT NULL
music
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- singer — VARCHAR(50) — NOT NULL
- song_time — TIME — NOT NULL
- album_image_url — VARCHAR(63)
music_vocabulary
- id — BIGINT — 기본 키 — NOT NULL
- music_id — BIGINT — 외래 키 → music.id — NOT NULL
- vocabulary_id — BIGINT — 외래 키 → vocabulary.id — NOT NULL
rank
- id — BIGINT — 기본 키 — NOT NULL
- music_id — BIGINT — 외래 키 → music.id — NOT NULL
- user_id — BIGINT — NOT NULL
- score — INT — NOT NULL
- record_time — TIMESTAMP — NOT NULL
user_daily_vocabulary
- id — VARCHAR(255) — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → Users.id — NOT NULL
- daily_id — BIGINT — 외래 키 → daily.id — NOT NULL
- completed — BOOLEAN — NOT NULL
- quiz_score — INT
vocabulary
- id — BIGINT — 기본 키 — NOT NULL
- word — VARCHAR(50) — NOT NULL
- description — TEXT — NOT NULL
- video_url — VARCHAR(255) — NOT NULL