movie_DBMS
Tables (10)
Untitled (MOVIE)
- Key3 (m_id) — SERIAL — Primary key — NOT NULL — 고유 영화 ID
- Field (m_type) — VARCHAR(50) — NOT NULL — 영화타입
- Field (m_name) — VARCHAR(255) — NOT NULL — 영화이름
- Field (start_year) — DATE — NOT NULL — 개봉연도
- Field2 (end_year) — DATE — 종료연도
- Field3 (runtimes) — INT — 러닝타임
- Field4 (is_adult) — BOOLEAN — NOT NULL — 성인영화여부
- Field5 (m_rating) — INT — 평점(1~10)
- Field6 (votes) — INT — 투표수
Untitled (CUSTOMER)
- Key (c_id) — SERIAL — Primary key — NOT NULL — 고유값
- Field (c_name) — VARCHAR(100) — NOT NULL — 고객이름
- Field2 (email) — VARCHAR(255) — 중복불가
- Field3 (pwd) — VARCHAR(100) — NOT NULL
- Field4 (gender) — VARCHAR(10)
- Field5 (phone) — INT
Untitled (GENRE)
- Key (g_id) — SERIAL — Primary key — NOT NULL — KEY
- Field (g_name) — VARCHAR(50) — NOT NULL
Untitled (PARTICIPANT)
- Key (p_id) — SERIAL — Primary key — NOT NULL — 고유 영화 참여자 ID
- Field (p_name) — VARCHAR(100) — NOT NULL — 영화참여자 이름
- Field (major_work) — VARCHAR(255) — 대표작
- Key — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유 직업 id
Untitled (PROFESSION)
- Key — SERIAL — Primary key — NOT NULL — 고유 직업 id
- Field (pr_name) — VARCHAR(100) — 직업명
Untitled (Watch)
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
- Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
- Field (pause_time) — TIMESTAMP — NOT NULL — 재생시간
- Field (watch_time) — DATE — NOT NULL — 시청일자
Untitled (Comment_to)
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
- Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
- Field (rating) — INT — NOT NULL — 평점(1,10)
- Field2 (comment) — VARCHAR(500) — 유저코멘트 글
- Field3 (write_date) — DATE — NOT NULL
Untitled (Participate)
- Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
- Key (p_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유 영화 참여자 ID
- Field (role) — VARCHAR(50) — NOT NULL — role of participant
- Field2 (casting) — VARCHAR(255) — 배역정보
Untitled (PREFERENCES_GENRE)
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 고유값
- Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — KEY
- Field (pg_name) — VARCHAR(50) — NOT NULL — 장르 이름
Untitled (MOVIE_GENRE)
- Key3 (m_id) — SERIAL — Foreign key → Untitled.Key3 — NOT NULL — 고유 영화 ID
- Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — KEY