movie_ver2.0
Tables (26)
OTT_code (Untitled3)
- code — number(3) — Primary key — NOT NULL
- OTT_name — varchar(20)
icon (Untitled)
- icon_num — number(2) — Primary key — NOT NULL
- img_url — varchar(70) — NOT NULL
member
- member_id — varchar(100) — Primary key — NOT NULL
- icon_num (icon_num2) — number(2) — Foreign key → icon.icon_num — NOT NULL
- member_pw — varchar(80)
- member_name — varchar(20)
- provider — varchar(10)
- provider_id — varchar(30)
- roles — varchar(15)
- friend_list — JSON
- OTT_list — JSON
- post_list — JSON
- reply_list — JSON
member_search_list
- no — int — Primary key — NOT NULL
- member_id — varchar(20) — Foreign key → member.member_id — NOT NULL
- search_word — varchar(20)
- search_time — date
movie_genres (Untitled6)
- num — int — Primary key — NOT NULL
- movies_id — INT(11) — Foreign key → movies.id — NOT NULL
- genres_id — int — Foreign key → movie_genres_list.genres_id — NOT NULL
movie_genres_list (Untitled5)
- genres_id — int — Primary key — NOT NULL
- genres — varchar(20)
movie_keywords (Untitled8)
- num — int — Primary key — NOT NULL
- movies_id — INT(11) — Foreign key → movies.id — NOT NULL
- keywords_id — int — Foreign key → movie_keywords_list.keywords_id — NOT NULL
movie_keywords_list (Untitled7)
- keywords_id — int — Primary key — NOT NULL
- keywords — varchar(20)
movie_viewlist (member_viewlist)
- no — int — Primary key — NOT NULL
- member_id — varchar(20) — Foreign key → member.member_id — NOT NULL
- movies_id — INT(11) — Foreign key → movies.id — NOT NULL
movie_wishlist (movie_wish)
- no — int — Primary key — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- movies_id — INT(11) — Foreign key → movies.id — NOT NULL
movies
- id — INT(11) — Primary key — NOT NULL
- imdb_id (imdb_id2) — varchar(20) — Foreign key → titles_adult.tconst — NOT NULL
- imdb_id (imdb_id3) — VARCHAR(20) — Foreign key → ratings.tconst — NOT NULL
- title — VARCHAR(255)
- runtime — INT(11)
- backdrop_path — TEXT
- original_language — VARCHAR(10)
- original_title — VARCHAR(255)
- overview — TEXT
- poster_path — TEXT
- tagline — TEXT
- release_date — DATE — NOT NULL
- korean_title — varchar(255)
post
- no — int — Primary key
- member_id — varchar(20) — Foreign key → member.member_id — NOT NULL
- title — varchar(50)
- indate — timestamp
- contents — TEXT(5000)
- count — number(10)
- like — number(5)
- category — varchar(10)
post_attach
- attach_no — int — Primary key — NOT NULL
- no — int — Foreign key → post.no
- file_url — varchar(70)
post_like (Untitled9)
- no — int — Primary key — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- post_no — int — Foreign key → post.no
ratings (Untitled4)
- tconst — VARCHAR(20) — Primary key — NOT NULL
- averagerating — float
- numVotes — int(11)
reply
- reply_num — number(10) — Primary key — NOT NULL
- no — int — Foreign key → post.no
- member_id — varchar(20) — Foreign key → member.member_id — NOT NULL
- indate — timestamp
- contents — text(1000)
- like — number(5)
reply_like (Untitled10)
- no — int — Primary key — NOT NULL
- reply_num — number(10) — Foreign key → reply.reply_num — NOT NULL
- member_id (member_id2) — varchar(100) — Foreign key → member.member_id — NOT NULL
search_list
- search_word — varchar(20) — Primary key — NOT NULL
- page — number(4) — Primary key
- search_time — date
- result_list — JSON
titles_adult (Untitled2)
- tconst — varchar(20) — Primary key — NOT NULL
- is_adult — tinyint(1)
tv_genres (CopyOfUntitled6)
- num — int — Primary key — NOT NULL
- tv_shows_id — INT(11) — Foreign key → tv_shows.id — NOT NULL
- genres_id — int — Foreign key → tv_genres_list.genres_id — NOT NULL
tv_genres_list (CopyOfUntitled5)
- genres_id — int — Primary key — NOT NULL
- genres — varchar(20)
tv_keywords (CopyOfUntitled8)
- num — int — Primary key — NOT NULL
- tv_shows_id — INT(11) — Foreign key → tv_shows.id — NOT NULL
- keywords_id — int — Foreign key → tv_keywords_list.keywords_id — NOT NULL
tv_keywords_list (CopyOfUntitled7)
- keywords_id — int — Primary key — NOT NULL
- keywords — varchar(20)
tv_member_viewlist (CopyOfmember_viewlist)
- no — int — Primary key — NOT NULL
- member_id — varchar(20) — Foreign key → member.member_id — NOT NULL
- tv_shows_id — INT(11) — Foreign key → tv_shows.id — NOT NULL
- indate — DATE
tv_shows
- id — INT(11) — Primary key — NOT NULL
- adult — BIT(1)
- backdrop_path — VARCHAR(255)
- created_by — TEXT
- episode_run_time — VARCHAR(255)
- first_air_date — DATE
- genres — TEXT
- keywords — TEXT
- korean_name — VARCHAR(255)
- languages — VARCHAR(255)
- last_air_date — DATE
- name — VARCHAR(255)
- number_of_episodes — INT(11)
- number_of_seasons — INT(11)
- origin_country — VARCHAR(255)
- original_language — VARCHAR(255)
- original_name — VARCHAR(255)
- overview — TEXT
- popularity — FLOAT
- poster_path — VARCHAR(255)
- seasons_id — INT(11)
- status — VARCHAR(255)
- tagline — VARCHAR(255)
- type — VARCHAR(255)
- vote_average — FLOAT
- vote_count — INT(11)
tv_wish (CopyOfmovie_wish)
- no — int — Primary key — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- tv_shows_id — INT(11) — Foreign key → tv_shows.id — NOT NULL
- indate — DATE