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