수락상

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