Assignment2
Tables (10)
Untitled (CUSTOMER)
- Key (c_id) — SERIAL — Primary key — NOT NULL — Primary Key
- Field (c_name) — VARCHAR(100) — NOT NULL — 고객 이름
- Field (email) — VARCHAR(100) — NOT NULL — 고객 이메일
- Field (pwd) — VARCHAR(255) — NOT NULL — 고객 비밀번호
- Field (gender) — VARCHAR(10) — 고객 성별
- Field (phone) — VARCHAR(20) — 고객 전화번호
Untitled (MOVIE)
- Key (m_id) — SERIAL — Primary key — NOT NULL — Primary Key
- Field (m_type) — VARCHAR(50) — 영화 타입
- Field (m_name) — VARCHAR — NOT NULL — 영화 제목
- Field (start_year) — INT — 영화 시작 연도
- Field (end_year) — INT — 영화 종료 연도
- Field (runtimes) — INT — 상영 시간
- Field (is_adult) — BOOLEAN — 성인 영화 여부
- Field (rating) — DECIMAL(3,1) — 영화 평점
- Field (votes) — INT — 평점 수
Untitled (GENRE)
- Key (g_id) — SERIAL — Primary key — NOT NULL — Primary Key
- Field (genre) — VARCHAR(50) — NOT NULL — 영화 장르
Untitled (PARTICIPANT)
- Key (p__id) — SERIAL — Primary key — NOT NULL — Primary Key..
- Field (p_name) — VARCHAR(100) — NOT NULL — 참여자 이름
- Field (major_work) — VARCHAR(255) — 대표 작품
Untitled (PROFESSION)
- Key (pr_id) — SERIAL — Primary key — NOT NULL — 직업 id
- Field (pr_name) — VARCHAR(100) — NOT NULL — 직업명
- Field
Untitled (WATCH)
- Field (watch_date) — DATE — NOT NULL — 영화 시청 날짜
- Field (stop_time) — TIME — 시청 중지 시간
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
- Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
Untitled (LIKE)
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
- Key (g_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
Untitled (PARTICIPATE)
- Field (role) — VARCHAR(100) — 역할
- Field (charactor) — VARCHAR(100) — 캐릭터 이름
- Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
- Key (p__id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key..
Untitled (WORK)
- Key (p__id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key..
- Key (pr_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — 직업 id
Untitled (COMMENT)
- Field (rating) — DECIMAL(2,1) — 평점
- Field (comment) — TEXT — 댓글
- Field (w_date) — DATE — NOT NULL — 댓글 작성 날짜
- Key (c_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key
- Key (m_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL — Primary Key