movie_DBMS

Tables (10)

Untitled (MOVIE)

  • Key3 (m_id) — SERIAL — Primary key — NOT NULL — 고유 영화 ID
  • Field (m_type) — VARCHAR(50) — NOT NULL — 영화타입
  • Field (m_name) — VARCHAR(255) — NOT NULL — 영화이름
  • Field (start_year) — DATE — NOT NULL — 개봉연도
  • Field2 (end_year) — DATE — 종료연도
  • Field3 (runtimes) — INT — 러닝타임
  • Field4 (is_adult) — BOOLEAN — NOT NULL — 성인영화여부
  • Field5 (m_rating) — INT — 평점(1~10)
  • Field6 (votes) — INT — 투표수

Untitled (CUSTOMER)

  • Key (c_id) — SERIAL — Primary key — NOT NULL — 고유값
  • Field (c_name) — VARCHAR(100) — NOT NULL — 고객이름
  • Field2 (email) — VARCHAR(255) — 중복불가
  • Field3 (pwd) — VARCHAR(100) — NOT NULL
  • Field4 (gender) — VARCHAR(10)
  • Field5 (phone) — INT

Untitled (GENRE)

  • Key (g_id) — SERIAL — Primary key — NOT NULL — KEY
  • Field (g_name) — VARCHAR(50) — NOT NULL

Untitled (PARTICIPANT)

  • Key (p_id) — SERIAL — Primary key — NOT NULL — 고유 영화 참여자 ID
  • Field (p_name) — VARCHAR(100) — NOT NULL — 영화참여자 이름
  • Field (major_work) — VARCHAR(255) — 대표작
  • Key — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유 직업 id

Untitled (PROFESSION)

  • Key — SERIAL — Primary key — NOT NULL — 고유 직업 id
  • Field (pr_name) — VARCHAR(100) — 직업명

Untitled (Watch)

  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
  • Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
  • Field (pause_time) — TIMESTAMP — NOT NULL — 재생시간
  • Field (watch_time) — DATE — NOT NULL — 시청일자

Untitled (Comment_to)

  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
  • Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
  • Field (rating) — INT — NOT NULL — 평점(1,10)
  • Field2 (comment) — VARCHAR(500) — 유저코멘트 글
  • Field3 (write_date) — DATE — NOT NULL

Untitled (Participate)

  • Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
  • Key (p_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유 영화 참여자 ID
  • Field (role) — VARCHAR(50) — NOT NULL — role of participant
  • Field2 (casting) — VARCHAR(255) — 배역정보

Untitled (PREFERENCES_GENRE)

  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
  • Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — KEY
  • Field (pg_name) — VARCHAR(50) — NOT NULL — 장르 이름

Untitled (MOVIE_GENRE)

  • Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
  • Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — KEY