Relational Modeling

Tables (11)

Untitled (participant)

  • Key (p_id) — BIGINT — Primary key — NOT NULL — 출연제작진번호
  • Field (p_name) — VARCHAR(20) — NOT NULL — 이름
  • Field2 (major_work) — VARCHAR(20) — NOT NULL — 배역

Untitled (customer)

  • Key (c_id) — BIGINT — Primary key — NOT NULL — 고객번호
  • Field (c_name) — VARCHAR(20) — NOT NULL — 고객이름
  • Field2 (email) — VARCHAR(40) — NOT NULL — 고객이메일
  • Field3 (pwd) — VARCHAR(20) — NOT NULL — 비밀번호
  • Field (gender) — VARCHAR(10) — 성별(선택안함있음)
  • Field2 (phone) — VARCHAR(20) — NOT NULL — 고객전화번호

Untitled (participate)

  • Key (participate_id) — BIGINT — Primary key — NOT NULL — 참여번호
  • Field (role) — VARCHAR(20) — NOT NULL — 배역명칭
  • Field2 (character) — VARCHAR(20) — NOT NULL — 역할

Untitled (watch)

  • Key (watch_id) — BIGINT — Primary key — NOT NULL — 시청기록번호
  • Field (watch_date) — TIMESTAMP — NOT NULL — 시청일
  • Field2 (stop_time) — TIME — NOT NULL — 시청종료시간
  • Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화제목
  • Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호

Untitled (comment_to)

  • Key (comment_id) — BIGINT — Primary key — NOT NULL — 코멘트번호
  • Field (rating) — VARCHAR(200) — NOT NULL — 평점
  • Field2 (comment) — VARCHAR(200) — NOT NULL — 코멘트
  • Field3 (w_date) — TIMESTAMP — NOT NULL — 코멘트작성날짜
  • Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화번호
  • Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호

Untitled (like)

  • Key (like_id) — BIGINT — Primary key — NOT NULL — 선호장르번호
  • Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호
  • Key3 (g_id) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호1
  • Field (genre1) — VARCHAR(20) — NOT NULL — 선호장르1
  • Key3 (g_id2) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호2
  • Field2 (genre2) — VARCHAR(20) — NOT NULL — 선호장르2
  • Key3 (g_id3) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호3
  • Field (genre3) — VARCHAR(20) — NOT NULL — 선호장르3

Untitled (classify)

  • Key (cf_id) — Primary key — NOT NULL — 분류번호
  • Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화번호
  • Key3 (g_id) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호

Untitled (work)

  • Key (work_id) — BIGINT — Primary key — NOT NULL — 작업번호

Untitled2 (profession)

  • Key (pr_id) — BIGINT — Primary key — NOT NULL — 직업번호
  • Field4 (pr_name) — VARCHAR(20) — NOT NULL — 직업이름

Untitled3 (movie)

  • Key (m_id) — BIGINT — Primary key — NOT NULL — 영화번호
  • Field (m_type) — VARCHAR(20) — NOT NULL — 영화유형
  • Field2 (m_name) — VARCHAR(20) — NOT NULL — 영화제목
  • Field3 (start_year) — TIMESTAMP — NOT NULL — 상영일
  • Field4 (end_year) — TIMESTAMP — 상영종료일
  • Field5 (runtimes) — TIME — NOT NULL — 상영시간
  • Field6 (is_adult) — INT — NOT NULL — 성인영화여부
  • Field7 (rating) — INT — 평점
  • Field8 (votes) — INT — 추천수

Untitled4 (genre)

  • Key3 (g_id) — BIGINT — Primary key — NOT NULL — 장르번호
  • Field5 (genre) — VARCHAR(20) — NOT NULL — 장르