ㄴ

Tables (11)

CUSTOMER

  • c_id — int — Primary key — NOT NULL — customer
  • c_name — varchar(60) — NOT NULL — customer
  • email — varchar(60) — NOT NULL — email
  • pwd — int — NOT NULL — password
  • gender — varchar(20) — gender
  • phone — varchar(20) — NOT NULL — phone

Classify

  • m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
  • g_id — int — Foreign key → GENRE.g_id — NOT NULL — genre

Comment_to

  • m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
  • c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer
  • rating — int — rating
  • comment — varchar(100) — comment
  • write_date — date — write

GENRE

  • g_id — int — Primary key — NOT NULL — genre
  • g_name — varchar(60) — NOT NULL — genre

MOVIE

  • m_id — int — Primary key — NOT NULL — user
  • m_type — varchar(60) — NOT NULL — movie
  • m_name — varchar(60) — NOT NULL — movie
  • start_year — date — NOT NULL — start
  • end_year — date — end
  • runtimes — interval — NOT NULL — runtime
  • is_adult — boolean — NOT NULL — 18+
  • m_rating — int — rating
  • votes — int — rating

PARTICIPANT

  • p_id — int — Primary key — NOT NULL — participant
  • p_name — varchar(60) — NOT NULL — name
  • major_work — varchar(60) — NOT NULL — major

PROFESSION

  • pr_id — int — Primary key — NOT NULL — profession
  • pr_name — varchar(60) — NOT NULL — profession

Participate

  • m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
  • p_id — int — Foreign key → PARTICIPANT.p_id — NOT NULL — participant
  • role — varchar(60) — NOT NULL — role
  • casting — varcahr(60) — NOT NULL — casting

Prefer

  • g_id — int — Foreign key → GENRE.g_id — NOT NULL — genre
  • c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer

Watch

  • m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
  • c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer
  • watch_date — date — watch
  • pause_time — interval — pause

Work

  • p_id — int — Foreign key → PARTICIPANT.p_id — NOT NULL — participant
  • pr_id — int — Foreign key → PROFESSION.pr_id — NOT NULL — profession