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