temp
Tables (11)
Classify
- classify_id — INTEGER — Primary key — NOT NULL — 분류
- g_id — INTEGER — Foreign key → Genre.g_id — NOT NULL — 장르
- m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
Comment_to
- comment_id — SERIAL — Primary key — NOT NULL — 댓글
- c_id — SERIAL — Foreign key → Customer.c_id — NOT NULL — 고객
- m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
- comment — TEXT — 댓글
- rating — FLOAT — 평점
- write_date — TIMESTAMP — 댓글
Customer
- c_id — INTEGER — Primary key — NOT NULL — 고객
- c_name — VARCHAR(255) — NOT NULL — 고객
- email — VARCHAR(255) — NOT NULL — 이메일
- pwd — VARCHAR(255) — NOT NULL — 비밀번호
- gender — CHAR(1) — 성별
- phone — VARCHAR(20) — 전화번호
Genre
- g_id — SERIAL — Primary key — NOT NULL — 장르
- g_name — VARCHAR(100) — NOT NULL — 장르
Movie
- m_id — INTEGER — Primary key — NOT NULL — 영화
- m_type — VARCHAR(50) — NOT NULL — 영화
- m_name — VARCHAR(255) — NOT NULL — 영화
- start_year — DATE — NOT NULL — 상영
- end_year — DATE — 상영
- runtimes — INTERVAL — NOT NULL — 상영
- is_adult — BOOLEAN — NOT NULL — 성인
- m_rating — FLOAT — 영화
- votes — INTEGER — 영화
Participant
- p_id — INTEGER — Primary key — NOT NULL — 참여자
- p_name — VARCHAR(255) — NOT NULL — 참여자
- major_work — VARCHAR(255) — 대표작
Participate
- pa_id — INTEGER — Primary key — NOT NULL — 영화
- p_id — INTEGER — Foreign key → Participant.p_id — NOT NULL — 참여자
- m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
- role — VARCHAR(50) — 영화
- casting — VARCHAR(50) — 영화
Prefer
- prefer_id — INTEGER — Primary key — NOT NULL — 선호장르
- c_id — INTEGER — Foreign key → Customer.c_id — NOT NULL — 고객
- g_id — INTEGER — Foreign key → Genre.g_id — NOT NULL — 장르
Profession
- pr_id — INTEGER — Primary key — NOT NULL — 영화관련자
- pr_name — VARCHAR(100) — NOT NULL — 영화관련자
Watch
- w_id — INTEGER — Primary key — NOT NULL — 시청
- c_id — INTEGER — Foreign key → Customer.c_id — NOT NULL — 고객
- m_id — INTEGER — Foreign key → Movie.m_id — NOT NULL — 영화
- watch_date — TIMESTAMP — 시청
- pause_time — TIME — 정지
Work
- work_id — INTEGER — Primary key — NOT NULL — 영화관련자
- p_id — INTEGER — Foreign key → Participant.p_id — NOT NULL — 참여자
- pr_id — INTEGER — Foreign key → Profession.pr_id — NOT NULL — 영화관련자