relationmodel

Tables (11)

classify

  • m_id — int — Foreign key → movie.m_id — NOT NULL — 영화식별
  • p_id — int — Foreign key → movie.p_id — NOT NULL — 참가자식별

comment_info

  • p_id — int — Foreign key → watch.p_id — NOT NULL — 참가자식별
  • comment — string — 커맨트
  • rating — float — 레이팅
  • w_date — date — 날짜

customer

  • p_id (c_id) — int — Foreign key → comment_info.p_id — NOT NULL — 고객식별
  • c_name — string — 고객이름
  • eamil (email) — string — 이메일
  • pwd — string — 비밀번호
  • gender — string — 성별
  • phone — string — 폰

genre

  • g_id — int — Primary key — NOT NULL — 장르식별
  • m_id — int — Foreign key → classify.m_id — NOT NULL — 영화식별
  • p_id — int — Foreign key → classify.p_id — NOT NULL — 참가자식별
  • genre — 장르

like

  • g_id — int — Foreign key → genre.g_id — NOT NULL — 장르식별
  • m_id — int — Foreign key — NOT NULL — 영화식별
  • m_id (p_id) — int — Foreign key → genre.m_id — NOT NULL — 참가자식별
  • p_id (c_id) — int — Foreign key → customer.p_id — NOT NULL — 고객식별

movie

  • m_id (my_id) — int — Primary key — NOT NULL — 영화식별
  • p_id — int — Foreign key → participate.p_id — NOT NULL — 참가자식별
  • m_type — string — 사용자타입
  • m_name — string — 사용자이름
  • start_year — int — 시작년도
  • end_year — int — 종료년도
  • runtimes — string — 런타임
  • rating — float — 레이팅
  • votes — 투표

participant

  • p_id — int — Primary key — NOT NULL — 참가자식별
  • p_name — string — 참가자이름
  • major_work — string — 주요하는일

participate

  • p_id (m_id) — int — Primary key — NOT NULL — 영화식별
  • p_id — int — Foreign key → participant.p_id — NOT NULL — 참가자식별
  • role — string — 캐릭터

profession

  • pr_name (pr_id) — int — Primary key — pr식별
  • p_id — int — Foreign key → work.p_id — NOT NULL — 참가자식별
  • Field (pr_name) — string — pr이름

watch

  • p_id — int — Foreign key → movie.p_id — NOT NULL — 참가지식별
  • watch_date — date — 시청날짜
  • stop_watch — time — 종료날짜

work

  • p_id — int — Foreign key → participant.p_id — NOT NULL — 참가자식별