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