ㅅㄷ

Tables (11)

Classify

  • m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
  • g_id — SERIAL — Foreign key → Genre.g_id — NOT NULL — 장르

Comment_to

  • c_id — INTEGER — Foreign key → Customer.c_id — NOT NULL — 고객
  • m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
  • comment — TEXT — 댓글
  • rating — FLOAT — 평점
  • write_date — TIMESTAMP — 댓글

Customer

  • c_id — INTEGER — Primary key — NOT NULL — 고객
  • c_name — VARCHAR(255) — NOT NULL — 고객
  • email — VARCHAR(255) — NOT NULL — 이메일
  • pwd — VARCHAR(255) — NOT NULL — 비밀번호
  • gender — CHAR(1) — 성별
  • phone — VARCHAR(20) — 전화번호

Genre

  • g_id — SERIAL — Primary key — NOT NULL — 장르
  • g_name — VARCHAR(100) — NOT NULL — 장르

Movie

  • m_id — INTEGER — Primary key — NOT NULL — 영화
  • m_type — VARCHAR(50) — NOT NULL — 영화
  • m_name — VARCHAR(255) — NOT NULL — 영화
  • start_year — DATE — NOT NULL — 상영
  • end_year — DATE — 상영
  • runtimes — INTEGER — NOT NULL — 상영
  • is_adult — BOOLEAN — NOT NULL — 성인
  • m_rating — DOUBLE — 영화
  • votes — INTEGER — 영화

Participant

  • p_id — INTEGER — Primary key — NOT NULL — 참여자
  • p_name — VARCHAR(255) — NOT NULL — 참여자
  • major_work — VARCHAR(255) — 대표작

Participate

  • pa_id — INTEGER — Primary key — NOT NULL — 영화
  • p_id — INTEGER — Foreign key → Participant.p_id — NOT NULL — 참여자
  • m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
  • role — VARCHAR(50) — 영화
  • casting — VARCHAR(50) — 영화

Prefer

  • g_id — INTEGER — Foreign key → Genre.g_id — NOT NULL — 장르
  • c_id — INTEGER — Foreign key → Customer.c_id — NOT NULL — 고객

Profession

  • pr_id — INTEGER — Primary key — NOT NULL — 영화관련직종
  • pr_name — VARCHAR(100) — NOT NULL — 영화관련직종

Watch

  • c_id — INTEGER — Foreign key → Customer.c_id — NOT NULL — 고객
  • m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
  • watch_date — DATE — 시청
  • pause_time — TIMESTAMP — 정지

Work

  • p_id — INTEGER — Foreign key → Participant.p_id — NOT NULL — 참여자
  • pr_id — INTEGER — Foreign key → Profession.pr_id — NOT NULL — 영화관련자