ㄴ
Tables (11)
CUSTOMER
- c_id — int — Primary key — NOT NULL — customer
- c_name — varchar(60) — NOT NULL — customer
- email — varchar(60) — NOT NULL — email
- pwd — int — NOT NULL — password
- gender — varchar(20) — gender
- phone — varchar(20) — NOT NULL — phone
Classify
- m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
- g_id — int — Foreign key → GENRE.g_id — NOT NULL — genre
Comment_to
- m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
- c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer
- rating — int — rating
- comment — varchar(100) — comment
- write_date — date — write
GENRE
- g_id — int — Primary key — NOT NULL — genre
- g_name — varchar(60) — NOT NULL — genre
MOVIE
- m_id — int — Primary key — NOT NULL — user
- m_type — varchar(60) — NOT NULL — movie
- m_name — varchar(60) — NOT NULL — movie
- start_year — date — NOT NULL — start
- end_year — date — end
- runtimes — interval — NOT NULL — runtime
- is_adult — boolean — NOT NULL — 18+
- m_rating — int — rating
- votes — int — rating
PARTICIPANT
- p_id — int — Primary key — NOT NULL — participant
- p_name — varchar(60) — NOT NULL — name
- major_work — varchar(60) — NOT NULL — major
PROFESSION
- pr_id — int — Primary key — NOT NULL — profession
- pr_name — varchar(60) — NOT NULL — profession
Participate
- m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
- p_id — int — Foreign key → PARTICIPANT.p_id — NOT NULL — participant
- role — varchar(60) — NOT NULL — role
- casting — varcahr(60) — NOT NULL — casting
Prefer
- g_id — int — Foreign key → GENRE.g_id — NOT NULL — genre
- c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer
Watch
- m_id — int — Foreign key → MOVIE.m_id — NOT NULL — user
- c_id — int — Foreign key → CUSTOMER.c_id — NOT NULL — customer
- watch_date — date — watch
- pause_time — interval — pause
Work
- p_id — int — Foreign key → PARTICIPANT.p_id — NOT NULL — participant
- pr_id — int — Foreign key → PROFESSION.pr_id — NOT NULL — profession