Relational Modeling

Tables (11)

Untitled (MOVIE)

  • Key (m_id) — int — Primary key — NOT NULL — 영화식별자
  • Field (m_name) — varchar(100) — NOT NULL — 영화제목
  • Field2 (m_type) — int — 타입
  • Field3 (start_year) — int — NOT NULL — 개봉연도
  • Field4 (end_year) — int — NOT NULL — 종료연도
  • Field (runtimes) — int — NOT NULL — 영화러닝타임
  • Field (is_adult) — bool — NOT NULL — 성인영화 여부
  • Field (rating) — float — NOT NULL — 영화평점(평균)
  • Field (votes) — int — NOT NULL — 평점에 대한 투표수

Untitled (CUSTOMER)

  • Key (c_id) — int — Primary key — NOT NULL — 관중식별자
  • Field (c_name) — char — NOT NULL — 관중이름
  • Field2 (email) — varchar(100) — 관중이메일
  • Field3 (pwd) — varchar(40) — NOT NULL — 비밀번호
  • Field (gender) — boolean — NOT NULL — 성별(false는 남성,true는 여성)
  • Field (phone) — int — 전화번호

Untitled (PROFESSION)

  • Key (pr_id) — int — Primary key — NOT NULL — 직업식별자
  • Field (pr_name) — char — NOT NULL — 직업이름

Untitled (GENRE)

  • Key (g_id) — int — Primary key — NOT NULL — 장르식별자
  • Field (genre) — varchar(20) — NOT NULL — 장르이름

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(20) — NOT NULL — 직함
  • Field2 (casting) — varchar(20) — 배역

Untitled (Watch)

  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — 관중식별자
  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — 영화식별자
  • Field (watch_date) — timestamp — NOT NULL — 시청날짜
  • Field (pause_time) — timestamp — NOT NULL — 중단날짜

Untitled (Comment_to)

  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — 관중식별자
  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — 영화식별자
  • Field (rating) — int — NOT NULL — 평점
  • Field (comment) — text — 평가
  • Field (w_date) — timestamp — NOT NULL — 평가날짜

Untitled (Classify)

  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — 영화식별자
  • Key (g_id) — int — Foreign key → Untitled.Key — NOT NULL — 장르식별자

Untitled (Work)

  • Key (p_id) — int — Foreign key → Untitled.Key — NOT NULL — 참여자식별자
  • Key (pr_id) — int — Foreign key → Untitled.Key — NOT NULL — 직업식별자

Untitled (PARTICIPANT)

  • Key (p_id) — int — Primary key — NOT NULL — 참여자식별자
  • Field (p_name) — varchar(40) — NOT NULL — 참여자이름
  • Field2 (major_work) — varchar(100) — NOT NULL — 대표작

Untitled (Prefer)

  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — 관중식별자
  • Key (g_id) — int — Foreign key → Untitled.Key — NOT NULL — 장르식별자