test
Tables (10)
Untitled (Customer)
- c_id — INT — Primary key — NOT NULL
- Field (c_name) — VARCHAR(100)
- (email) — VARCHAR(100) — NOT NULL
- pwd — VARCHAR(100) — NOT NULL
- Field (gender) — VARCHAR(10)
- Field (phone) — VARCHAR(15)
Untitled (Movie)
- Key — Primary key — NOT NULL
- Field (m_name) — VARCHAR(200)
- Field (m_type) — VARCHAR(50)
- Field (start_year) — INT
- Field2 (end_year) — INT
- Field3 (runtime)
- Field4 (is_adult)
- Field5 (votes)
Untitled (Genre)
- Key (g_id) — Primary key — NOT NULL
- Field (g_name)
Untitled (Participant)
- Key (p_id) — Primary key — NOT NULL
- Field (p_name)
- Field2 (major_work)
Untitled (Comment)
- Key (comment_id) — Primary key — NOT NULL
- c_id — INT — Foreign key → Untitled.c_id — NOT NULL
- Field (m_id)
- Field2 (rating)
- Field3 (commnet_text)
- Field4 (comment_date)
Untitled (Cutomer_Genre)
- Key (c_id) — Primary key — NOT NULL
- Key (g_id) — Primary key — NOT NULL
Untitled (Watch)
- Key (c_id) — Primary key — NOT NULL
- Key2 (g_id) — Primary key — NOT NULL
- Field (watch_date)
- Field2 (stop_time)
Untitled (Classify)
- Key (m_id) — Primary key — NOT NULL
- Key2 (g_id) — Primary key — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Key (g_id2) — Foreign key → Untitled.Key — NOT NULL
Untitled (Participate)
- Key (m_id) — Primary key — NOT NULL
- Key2 (p_id) — Primary key — NOT NULL
- Key3 (pf_id) — Primary key — NOT NULL
- Field (role)
- Field2 (character)
Untitled (Profession)
- Key (pf_id) — Primary key — NOT NULL
- Field (pf_name)