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