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