retro

Tables (5)

Likes (Untitled3)

  • movie_id (Key2) — Foreign key → Movies.movie_id — NOT NULL
  • user_id (Key22) — Foreign key → User.user_id — NOT NULL

Movies (Untitled2)

  • movie_id (Key) — Primary key — NOT NULL
  • Title (Field) — char
  • openDt (Field2) — date
  • Clip (Field3) — char
  • Star (Field4) — float
  • genre (Field5) — int

Review (Untitled4)

  • movie_id (Key2) — Foreign key → Movies.movie_id — NOT NULL
  • Star (Field6) — float
  • Content (Field) — char
  • Created_date (Field2) — date
  • Modified_date (Field3) — date
  • generation (Field4) — int
  • Gender (Field5) — int

User (Untitled)

  • user_id (Key2) — Primary key — NOT NULL
  • Username (Field) — char
  • Password (Field2) — char
  • Birthday (Field3) — date
  • Gender (Field4) — int
  • Nickname (Field5) — char
  • Email (Field6) — char

Views (Untitled5)

  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • movie_id (Key) — Foreign key → Movies.movie_id — NOT NULL
  • genre (장르)