DBMS
Tables (11)
Untitled (CUSTOMER)
- m_id (c_id) — integer — Primary key — NOT NULL
- Field (c_name) — varchar(100)
- Field2 (email) — varchar(100)
- Field3 (pwd) — varchar(100)
- Field (gender) — varchar(100)
- Field (phone) — varchar(100)
Untitled (Watch)
- c_id (m_id) — integer — Foreign key → Untitled.c_id — NOT NULL
- m_id (c_id) — integer — Foreign key → Untitled.m_id — NOT NULL
- watch_date — timestamp
- stp_time (pause_time) — interval
Untitled (GENRE)
- Key (g_id) — integer — Primary key — NOT NULL
- Field (g_name) — varchar(100)
Untitled (Comment_to)
- m_id (c_id) — integer — Foreign key → Untitled.m_id — NOT NULL
- c_id (m_id) — integer — Foreign key → Untitled.c_id — NOT NULL
- Field (rating) — real
- Field (comment) — varchar(100)
- Field (write_date) — date
Untitled (MOVIE)
- c_id (m_id) — integer — Primary key — NOT NULL
- Field (m_type) — varchar(100)
- Field2 (m_name) — varchar(100)
- Field3 (start_year) — integer
- Field (end_year) — integer
- Field (runtimes) — interval
- Field (is_adult) — boolean
- Field (m_rating) — real
- Field (votes) — integer
Untitled (classify)
- c_id (m_id) — integer — Foreign key → Untitled.c_id — NOT NULL
- Key (g_id) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (PARTICIPANT)
- Key (p_id) — integer — Primary key — NOT NULL
- Field (p_name) — varchar(100)
- Field (major_work) — varchar(100)
Untitled (Participate)
- Key (p_id) — integer — Foreign key → Untitled.Key — NOT NULL
- c_id (m_id) — integer — Foreign key → Untitled.c_id — NOT NULL
- Field (role) — varchar(100)
- Field (casting) — varchar(100)
Untitled (PROFESSION)
- Key (pr_id) — integer — Primary key — NOT NULL
- Field (pr_name) — varchar(100)
Untitled (Work)
- Key (p_id) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (pr_id) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (Prefer)
- m_id (c_id) — integer — Foreign key → Untitled.m_id — NOT NULL
- Key (g_id) — integer — Foreign key → Untitled.Key — NOT NULL