Assignment2

Tables (10)

Untitled (CUSTOMER)

  • Key (c_id) — SERIAL — Primary key — NOT NULL — Primary Key
  • Field (c_name) — VARCHAR(100) — NOT NULL — 고객 이름
  • Field (email) — VARCHAR(100) — NOT NULL — 고객 이메일
  • Field (pwd) — VARCHAR(255) — NOT NULL — 고객 비밀번호
  • Field (gender) — VARCHAR(10) — 고객 성별
  • Field (phone) — VARCHAR(20) — 고객 전화번호

Untitled (MOVIE)

  • Key (m_id) — SERIAL — Primary key — NOT NULL — Primary Key
  • Field (m_type) — VARCHAR(50) — 영화 타입
  • Field (m_name) — VARCHAR — NOT NULL — 영화 제목
  • Field (start_year) — INT — 영화 시작 연도
  • Field (end_year) — INT — 영화 종료 연도
  • Field (runtimes) — INT — 상영 시간
  • Field (is_adult) — BOOLEAN — 성인 영화 여부
  • Field (rating) — DECIMAL(3,1) — 영화 평점
  • Field (votes) — INT — 평점 수

Untitled (GENRE)

  • Key (g_id) — SERIAL — Primary key — NOT NULL — Primary Key
  • Field (genre) — VARCHAR(50) — NOT NULL — 영화 장르

Untitled (PARTICIPANT)

  • Key (p__id) — SERIAL — Primary key — NOT NULL — Primary Key..
  • Field (p_name) — VARCHAR(100) — NOT NULL — 참여자 이름
  • Field (major_work) — VARCHAR(255) — 대표 작품

Untitled (PROFESSION)

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

Untitled (WATCH)

  • Field (watch_date) — DATE — NOT NULL — 영화 시청 날짜
  • Field (stop_time) — TIME — 시청 중지 시간
  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
  • Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key

Untitled (LIKE)

  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
  • Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key

Untitled (PARTICIPATE)

  • Field (role) — VARCHAR(100) — 역할
  • Field (charactor) — VARCHAR(100) — 캐릭터 이름
  • Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
  • Key (p__id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key..

Untitled (WORK)

  • Key (p__id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key..
  • Key (pr_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 직업 id

Untitled (COMMENT)

  • Field (rating) — DECIMAL(2,1) — 평점
  • Field (comment) — TEXT — 댓글
  • Field (w_date) — DATE — NOT NULL — 댓글 작성 날짜
  • Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
  • Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key