movie pedia

Tables (7)

comments (Untitled5)

  • pk (id) — bigint — Primary key — NOT NULL
  • Field
  • pk (users_id) — bigint — Foreign key → users.pk — NOT NULL — auto_increment
  • pk (films_id) — bigint — Foreign key → films.pk — NOT NULL
  • score (별점) — float
  • content (내용) — varchar(100)
  • created_at (생성일) — datetime

films (영화)

  • pk (films_id) — bigint — Primary key — NOT NULL
  • movie_id (영화id) — bigint
  • title (제목) — varchar(50)
  • release_date (개봉일자) — date
  • origin_country (제작국가) — varchar(20)
  • poster_path (포스터 이미지) — varchar(100)
  • original_title (제작 언어) — varchar(20)
  • overview (줄거리) — varchar(200)
  • backdrop_path (배경 이미지) — varchar(100)
  • runtime (런타임) — int

films_genres (Untitled)

  • pk (films_genres_id) — bigint — Primary key — NOT NULL
  • pk (films_id) — bigint — Foreign key → films.pk — NOT NULL
  • pk (genres_id) — bigint — Foreign key → genres.pk — NOT NULL

films_images (Untitled3)

  • pk (id) — bigint — Primary key — NOT NULL
  • image_url (이미지 주소) — varchar(100)
  • pk (films_id) — bigint — Foreign key → films.pk — NOT NULL

films_videos (Untitled4)

  • pk (id) — bigint — Primary key — NOT NULL
  • video_url (비디오 주소) — varchar(100)
  • pk (films_id) — bigint — Foreign key → films.pk — NOT NULL

genres (Untitled2)

  • pk (genres_id) — bigint — Primary key — NOT NULL
  • code (장르 코드) — int
  • name (장르 이름) — varchar(20)

users (사용자)

  • pk (users_id) — bigint — Primary key — NOT NULL — auto_increment
  • name (닉네임) — varchar(20)
  • email (이메일) — varchar(50)
  • password (비밀번호) — varchar(50)
  • follower_count (팔로워수) — int
  • following_count (팔로잉수) — int
  • ratings_count (평가수) — int
  • comments_count (코멘트수) — int
  • collections_count (컬렉션수) — int
  • created_at (생성일) — datetime