MOVIES
Tables (6)
User_tb (유저)
- id (Key) — Primary key — NOT NULL
- user_id (PK) — int
- role_id (FK) — int
- username (Field) — varchar(255)
- password (Field2) — varchar(255)
- email (Field3) — varchar(255)
- phoneNumber (Field4) — int
- nickname (Field5) — varchar(255)
feed_id (피드)
- id (Key) — Primary key — NOT NULL
- user_id (FK) — int — Foreign key → User_tb.id — NOT NULL
- feed_id (PK) — int
- content (Field) — LONGTEXT
movie_genre_tb (장르)
- id (Key) — Primary key — NOT NULL
- movie_genre_id (pk) — int
- movie_genre_name (Field) — varchar(255)
movie_tb (영화)
- id (Key) — Primary key — NOT NULL
- movie_id (PK) — int
- movie_genre_id (FK) — int — Foreign key → movie_genre_tb.id — NOT NULL
- movie_name (Field) — varchar(255)
- country_of_manufacture (Field2) — varchar(255)
- director (Field3) — varchar(255)
- MPAA (Field5) — varchar(255)
- release_date (Field6) — date
role_tb (권한)
- Key — Primary key — NOT NULL
- user_role_id (FK) — int — Foreign key → user_role_tb.id — NOT NULL
- role_id (Fk) — int
- admin (Field) — int
- user (Field2) — int
user_role_tb (유저권한)
- id (Key) — Primary key — NOT NULL
- role_id (PK) — int
- user_id (Key2) — int — Foreign key → User_tb.id — NOT NULL