db기말

테이블 (4)

Data

  • movie_id (movie_id2) — INT — 외래 키 → Movie.movie_id — NOT NULL
  • user_id (User_id) — INT — 외래 키 → User.user_id — NOT NULL
  • rating — INT
  • timestamp — TIMESTAMP

Genre

  • movie_id — INT — 외래 키 → Movie.movie_id — NOT NULL
  • genre — varchar(12)

Movie

  • movie_id — INT — 기본 키 — NOT NULL
  • title (titile) — VARCHAR(50)
  • release_date (releaseDate) — DATE
  • url (URL) — CARCHAR(50)

User

  • user_id (User_id) — INT — 기본 키 — NOT NULL
  • age (Field2) — INT
  • gender — CHAR(1)
  • region_code (Field) — CHAR(5)
  • occupation (Field3) — VARCHAR(20)