TECHUP learncheck

Tables (6)

genre

  • genre_id (id) — SMALLINT — Primary key — NOT NULL
  • name (장르명) — VARCHAR(255) — NOT NULL

movie

  • movie_id (id) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(255) — NOT NULL
  • releaseYear (개봉연도) — VARCHAR(255) — NOT NULL
  • plot (줄거리) — DATETIME
  • genre (장르) — DATETIME — NOT NULL

movie-genre

  • movie_id — BIGINT — Foreign key → movie.movie_id — NOT NULL
  • genre_id — SMALLINT — Foreign key → genre.genre_id — NOT NULL

role

  • role_id (id) — SMALLINT — Primary key — NOT NULL — Role id. ex) 1000=USER, 2000=ADMIN, 2100=MOVIE_ADMIN ...
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

user

  • user_id (id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_role

  • created_at — DATETIME — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • role_id (rold_id) — SMALLINT — Foreign key → role.role_id — NOT NULL — Role id. ex) 1000=USER, 2000=ADMIN, 2100=MOVIE_ADMIN ...