Relational Modeling
Tables (11)
Untitled (participant)
- Key (p_id) — BIGINT — Primary key — NOT NULL — 출연제작진번호
- Field (p_name) — VARCHAR(20) — NOT NULL — 이름
- Field2 (major_work) — VARCHAR(20) — NOT NULL — 배역
Untitled (customer)
- Key (c_id) — BIGINT — Primary key — NOT NULL — 고객번호
- Field (c_name) — VARCHAR(20) — NOT NULL — 고객이름
- Field2 (email) — VARCHAR(40) — NOT NULL — 고객이메일
- Field3 (pwd) — VARCHAR(20) — NOT NULL — 비밀번호
- Field (gender) — VARCHAR(10) — 성별(선택안함있음)
- Field2 (phone) — VARCHAR(20) — NOT NULL — 고객전화번호
Untitled (participate)
- Key (participate_id) — BIGINT — Primary key — NOT NULL — 참여번호
- Field (role) — VARCHAR(20) — NOT NULL — 배역명칭
- Field2 (character) — VARCHAR(20) — NOT NULL — 역할
Untitled (watch)
- Key (watch_id) — BIGINT — Primary key — NOT NULL — 시청기록번호
- Field (watch_date) — TIMESTAMP — NOT NULL — 시청일
- Field2 (stop_time) — TIME — NOT NULL — 시청종료시간
- Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화제목
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호
Untitled (comment_to)
- Key (comment_id) — BIGINT — Primary key — NOT NULL — 코멘트번호
- Field (rating) — VARCHAR(200) — NOT NULL — 평점
- Field2 (comment) — VARCHAR(200) — NOT NULL — 코멘트
- Field3 (w_date) — TIMESTAMP — NOT NULL — 코멘트작성날짜
- Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화번호
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호
Untitled (like)
- Key (like_id) — BIGINT — Primary key — NOT NULL — 선호장르번호
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — 고객번호
- Key3 (g_id) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호1
- Field (genre1) — VARCHAR(20) — NOT NULL — 선호장르1
- Key3 (g_id2) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호2
- Field2 (genre2) — VARCHAR(20) — NOT NULL — 선호장르2
- Key3 (g_id3) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호3
- Field (genre3) — VARCHAR(20) — NOT NULL — 선호장르3
Untitled (classify)
- Key (cf_id) — Primary key — NOT NULL — 분류번호
- Key (m_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — 영화번호
- Key3 (g_id) — BIGINT — Foreign key → Untitled4.Key3 — NOT NULL — 장르번호
Untitled (work)
- Key (work_id) — BIGINT — Primary key — NOT NULL — 작업번호
Untitled2 (profession)
- Key (pr_id) — BIGINT — Primary key — NOT NULL — 직업번호
- Field4 (pr_name) — VARCHAR(20) — NOT NULL — 직업이름
Untitled3 (movie)
- Key (m_id) — BIGINT — Primary key — NOT NULL — 영화번호
- Field (m_type) — VARCHAR(20) — NOT NULL — 영화유형
- Field2 (m_name) — VARCHAR(20) — NOT NULL — 영화제목
- Field3 (start_year) — TIMESTAMP — NOT NULL — 상영일
- Field4 (end_year) — TIMESTAMP — 상영종료일
- Field5 (runtimes) — TIME — NOT NULL — 상영시간
- Field6 (is_adult) — INT — NOT NULL — 성인영화여부
- Field7 (rating) — INT — 평점
- Field8 (votes) — INT — 추천수
Untitled4 (genre)
- Key3 (g_id) — BIGINT — Primary key — NOT NULL — 장르번호
- Field5 (genre) — VARCHAR(20) — NOT NULL — 장르