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