mission-course-1

테이블 (5)

Keyword

  • PK (id) — INT — 기본 키 — NOT NULL
  • (category) — VARCHAR — NOT NULL
  • (keyword) — VARCHAR — NOT NULL

Song (song)

  • PK (id) — INT — 기본 키 — NOT NULL
  • title — VARCHAR — NOT NULL
  • artist — VARCHAR — NOT NULL
  • url (youtube_url) — VARCHAR — NOT NULL
  • made_date — DATE — NOT NULL

Song_keyword

  • PK (song_id) — INT — 외래 키 → Song.PK — NOT NULL
  • PK (keyword_id) — INT — 외래 키 → Keyword.PK — NOT NULL

회원정보 (members)

  • PK (member_id) — INT — 기본 키 — NOT NULL
  • (name) — VARCHAR — NOT NULL
  • (email) — VARCHAR — NOT NULL — UNIQUE
  • (birth) — DATE
  • (join_date) — DATE — NOT NULL

회원정보 (member)

  • Key — 기본 키 — NOT NULL
  • Field