DBSM_Movie
Tables (12)
MOVIE
- Key (m_id) — BIGINT — Primary key — NOT NULL
- Field (m_type) — VARCHAR(20) — NOT NULL
- Field (m_name) — VARCHAR(40) — NOT NULL
- Field (start_year) — DATE — NOT NULL
- Field (end_year) — DATE
- Field (runtimes) — TIME — NOT NULL
- Field (is_adult) — BOOLEAN — NOT NULL
- Field (rating) — DECIMAL(3,2)
- Field (votes) — INTEGER
PARTICIPANT
- Key (p_id) — BIGINT — Primary key — NOT NULL
- Field (p_name) — VARCHAR(20) — NOT NULL
- Field (major_work) — VARCHAR(20)
Untitled (Participate)
- Key (p_id) — BIGINT — Foreign key → PARTICIPANT.Key — NOT NULL
- Key (m_id) — BIGINT — Foreign key → MOVIE.Key — NOT NULL
- Field (role) — VARCHAR(255) — NOT NULL
- Field (character) — VARCHAR(255) — NOT NULL
Untitled (CUSTOMER)
- Key (c_id) — BIGINT — Primary key — NOT NULL
- Field (c_name) — VARCHAR(20) — NOT NULL
- Field (email) — VARCHAR(50) — NOT NULL
- Field (pwd) — VARCHAR(50) — NOT NULL
- Field (gender) — VARCHAR(10) — NOT NULL
- Field (phone) — VARCHAR(20) — NOT NULL
Untitled (GENRE)
- Key (g_id) — BIGINT — Primary key — NOT NULL
- Field (genre) — VARCHAR(20) — NOT NULL
Untitled (PROFESSION)
- Key (pr_id) — BIGINT — Primary key — NOT NULL
- Field (pr_name) — VARCHAR(20) — NOT NULL
Untitled (Classify)
- Key (g_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (m_id) — BIGINT — Foreign key → MOVIE.Key — NOT NULL
Untitled (Comment_to)
- Key (m_id) — BIGINT — Foreign key → MOVIE.Key — NOT NULL
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (rating) — INTEGER — NOT NULL
- Field (comment) — TEXT — NOT NULL
- Field (w_date) — TIMESTAMP — NOT NULL
Untitled (Like)
- Key (g_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (Work)
- Key (p_id) — BIGINT — Foreign key → PARTICIPANT.Key — NOT NULL
- Key (pr_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (user_map_info)
- Key — bigint — Primary key — NOT NULL
- Field (meet_id) — bigint
- Field (user_id) — bigint
- Field2 (map_info) — text
Untitled3 (Watch)
- Key (c_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (m_id) — BIGINT — Foreign key → MOVIE.Key — NOT NULL
- Field (watch_date) — DATE — NOT NULL
- Field (stop_time) — DATE