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 — 장르식별자