relationmodel
Tables (11)
classify
- m_id — int — Foreign key → movie.m_id — NOT NULL — 영화식별
- p_id — int — Foreign key → movie.p_id — NOT NULL — 참가자식별
comment_info
- p_id — int — Foreign key → watch.p_id — NOT NULL — 참가자식별
- comment — string — 커맨트
- rating — float — 레이팅
- w_date — date — 날짜
customer
- p_id (c_id) — int — Foreign key → comment_info.p_id — NOT NULL — 고객식별
- c_name — string — 고객이름
- eamil (email) — string — 이메일
- pwd — string — 비밀번호
- gender — string — 성별
- phone — string — 폰
genre
- g_id — int — Primary key — NOT NULL — 장르식별
- m_id — int — Foreign key → classify.m_id — NOT NULL — 영화식별
- p_id — int — Foreign key → classify.p_id — NOT NULL — 참가자식별
- genre — 장르
like
- g_id — int — Foreign key → genre.g_id — NOT NULL — 장르식별
- m_id — int — Foreign key — NOT NULL — 영화식별
- m_id (p_id) — int — Foreign key → genre.m_id — NOT NULL — 참가자식별
- p_id (c_id) — int — Foreign key → customer.p_id — NOT NULL — 고객식별
movie
- m_id (my_id) — int — Primary key — NOT NULL — 영화식별
- p_id — int — Foreign key → participate.p_id — NOT NULL — 참가자식별
- m_type — string — 사용자타입
- m_name — string — 사용자이름
- start_year — int — 시작년도
- end_year — int — 종료년도
- runtimes — string — 런타임
- rating — float — 레이팅
- votes — 투표
participant
- p_id — int — Primary key — NOT NULL — 참가자식별
- p_name — string — 참가자이름
- major_work — string — 주요하는일
participate
- p_id (m_id) — int — Primary key — NOT NULL — 영화식별
- p_id — int — Foreign key → participant.p_id — NOT NULL — 참가자식별
- role — string — 캐릭터
profession
- pr_name (pr_id) — int — Primary key — pr식별
- p_id — int — Foreign key → work.p_id — NOT NULL — 참가자식별
- Field (pr_name) — string — pr이름
watch
- p_id — int — Foreign key → movie.p_id — NOT NULL — 참가지식별
- watch_date — date — 시청날짜
- stop_watch — time — 종료날짜
work
- p_id — int — Foreign key → participant.p_id — NOT NULL — 참가자식별