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)