DBS_hw2

Tables (11)

Copy Of Untitled (Participate)

  • Key (p_id) — INT — Foreign key → Untitled.Key — NOT NULL — "참여자 아이디"
  • Key (m_id) — INT — Foreign key → Untitled.Key — NOT NULL — "영화 아이디"
  • Field (role) — VARCHAR(255) — NOT NULL — "영화 내 직함"
  • Field (casting) — VARCHAR(255) — "영화 내 배역"

Untitled (PARTICIPANT)

  • Key (p_id) — INT — Primary key — NOT NULL — "참여자 아이디"
  • Field (p_name) — VARCHAR(255) — NOT NULL — "참여자 이름"
  • Field2 (major_work) — VARCHAR(255) — "참여자 대표작"

Untitled (Work)

  • Key (p_id) — INT — Foreign key → Untitled.Key — NOT NULL — "참여자 아이디"
  • Key (pr_id) — INT — Foreign key → Untitled.Key — NOT NULL — "직업 아이디"

Untitled (PROFESSION)

  • Key (pr_id) — INT — Primary key — NOT NULL — "직업 아이디"
  • Field (pr_name) — VARCHAR(255) — NOT NULL — "직업 이름"

Untitled (MOVIE)

  • Key (m_id) — INT — Primary key — NOT NULL — "영화 아이디"
  • Field (m_type) — VARCHAR(255) — NOT NULL — "영화 유형"
  • Field2 (m_name) — VARCHAR(255) — NOT NULL — "영화 이름"
  • Field3 (start_year) — INT — "영화 출시연도"
  • Field4 (end_year) — INT — "영화 종료연도"
  • Field5 (runtimes) — INT — NOT NULL — "영화 러닝타임"
  • Field (is_adult) — BOOLEAN — NOT NULL — "성인영화 여부"
  • Field (m_rating) — FLOAT — "영화 평점"
  • Field (votes) — INT — "영화 투표수"

Untitled (Classify)

  • Key (m_id) — INT — Foreign key → Untitled.Key — NOT NULL — "영화 아이디"
  • Key (g_id) — INT — Foreign key → Untitled.Key — NOT NULL — "장르 아이디"

Untitled (GENRE)

  • Key (g_id) — INT — Primary key — NOT NULL — "장르 아이디"
  • Field (g_name) — VARCHAR(255) — NOT NULL — "장르 이름"

Untitled (Watch)

  • Key (m_id) — INT — Foreign key → Untitled.Key — NOT NULL — "영화 아이디"
  • Key (c_id) — INT — Foreign key → Untitled.Key — NOT NULL — "사용자 아이디"
  • Field (watch_date) — TIMESTAMP — NOT NULL — "시청 날짜"
  • Field (pause_time) — VARCHAR(255) — "시청 중단시간"

Untitled (CUSTOMER)

  • Key (c_id) — INT — Primary key — NOT NULL — "사용자 아이디"
  • Field (c_name) — VARCHAR(255) — NOT NULL — "사용자 이름"
  • Field (email) — VARCHAR(255) — NOT NULL — "사용자 이메일"
  • Field (pwd) — VARCHAR(255) — NOT NULL — "사용자 비밀번호"
  • Field (gender) — CHAR(1) — NOT NULL — "사용자 성별"
  • Field (phone) — VARCHAR(11) — NOT NULL — "사용자 전화번호"
  • Field (genre1) — VARCHAR(255) — NOT NULL — "사용자 선호장르1"
  • Field2 (genre2) — VARCHAR(255) — NOT NULL — "사용자 선호장르2"
  • Field (genre3) — VARCHAR(255) — NOT NULL — "사용자 선호장르3"

Untitled (Comment_to)

  • Key (m_id) — INT — Foreign key → Untitled.Key — NOT NULL — "영화 아이디"
  • Key (c_id) — INT — Foreign key → Untitled.Key — NOT NULL — "사용자 아이디"
  • Field (rating) — FLOAT — NOT NULL — "유저 평점"
  • Field (comment) — VARCHAR(255) — "코멘트"
  • Field (write_date) — DATE — NOT NULL — "평가 날짜"

Untitled (Prefer)

  • Key (c_id) — INT — Foreign key → Untitled.Key — NOT NULL — "사용자 아이디"
  • Key (g_id) — INT — Foreign key → Untitled.Key — NOT NULL — "장르 아이디"