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 ...