cbnuott

Tables (19)

actors

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(32) — NOT NULL

admin

  • id — VARCHAR(32) — Primary key — NOT NULL
  • passwd — VARCHAR(32) — NOT NULL
  • nickname — VARCHAR(32) — NOT NULL

comment

  • id — INT — Primary key — NOT NULL
  • commented_at — TIMESTAMP
  • rating — float — NOT NULL
  • contents — VARCHAR(512) — NOT NULL
  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL

ddabong

  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (comment_id) — INT — Foreign key → comment.id — NOT NULL
  • jjim_date — DATE — NOT NULL
  • ddabonged — CHAR(1) — NOT NULL
  • not_ddabonged — CHAR(1) — NOT NULL

genre

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(32) — NOT NULL

jjim

  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL
  • jjim_date — DATE — NOT NULL

movie

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(128) — NOT NULL
  • thumbnail_address — VARCHAR(500) — NOT NULL
  • video_address — VARCHAR(500) — NOT NULL
  • length — TIME — NOT NULL
  • upload_date — DATE
  • upscreen_date — DATE — NOT NULL
  • able_age — TINYINT — NOT NULL
  • description — VARCHAR(500) — NOT NULL
  • id (tv_or_movie_id) — INT — Foreign key → tv_or_movie.id — NOT NULL
  • id (production_company_id) — INT — Foreign key → production_company.id — NOT NULL

movie_actors

  • id (actors_id) — INT — Foreign key → actors.id — NOT NULL
  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL

movie_genre

  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL
  • id (genre_id) — INT — Foreign key → genre.id — NOT NULL

movie_special_series

  • id (special_series_id) — INT — Foreign key → special_series.id — NOT NULL
  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL

payment_method

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • method_inform — VARCHAR(500) — NOT NULL

production_company

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(32) — NOT NULL
  • image_address — VARCHAR(500) — NOT NULL

special_series

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(32) — NOT NULL

tv_or_movie

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(32) — NOT NULL

users

  • id — VARCHAR(32) — Primary key — NOT NULL
  • passwd — VARCHAR(32) — NOT NULL
  • age — TINYINT — NOT NULL
  • name — VARCHAR(32) — NOT NULL
  • nickname — VARCHAR(32) — NOT NULL
  • create_date — DATE
  • email — VARCHAR(32) — NOT NULL
  • is_subscribe — CHAR(1) — NOT NULL

users_payment_method

  • id — INT — Primary key — NOT NULL
  • user_paymet_method_inform — VARCHAR(500) — NOT NULL
  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (payment_method_id) — INT — Foreign key → payment_method.id — NOT NULL

users_subscription

  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • start_date — DATE — NOT NULL
  • latest_payment_date — DATE — NOT NULL
  • next_payment_date — DATE — NOT NULL

users_subscription_logs

  • id — INT — Primary key — NOT NULL
  • date — DATE
  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (users_payment_method_id) — INT — Foreign key → users_payment_method.id — NOT NULL

watched_logs

  • id (users_id) — VARCHAR(32) — Foreign key → users.id — NOT NULL
  • id (movie_id) — INT — Foreign key → movie.id — NOT NULL
  • title — VARCHAR(128) — NOT NULL
  • thumbnail_address — VARCHAR(500) — NOT NULL
  • time_bookmark — TIME — NOT NULL
  • watched_date — DATE — NOT NULL