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