DB2

Tables (11)

Untitled (MOVIE)

  • Key (m_id) — int — Primary key — NOT NULL — user identifier
  • Field (m_type) — varchar(60) — NOT NULL — movie type
  • Field (m_name) — varchar(60) — NOT NULL — movie name
  • Field (start_year) — date — NOT NULL — start year
  • Field (end_year) — date — end year
  • Field (runtimes) — interval — NOT NULL — runtime
  • Field (is_adult) — boolean — NOT NULL — 18+
  • Field (m_rating) — int — rating
  • Field (votes) — int — rating votes

Untitled (Participate)

  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — user identifier
  • Key (p_id) — int — Foreign key → Untitled.Key — NOT NULL — participant idnetifier
  • Field (role) — varchar(60) — NOT NULL — role of participant
  • Field (casting) — varcahr(60) — NOT NULL — casting

Untitled (PARTICIPANT)

  • Key (p_id) — int — Primary key — NOT NULL — participant idnetifier
  • Field (p_name) — varchar(60) — NOT NULL — name of participant
  • Field (major_work) — varchar(60) — NOT NULL — major work

Untitled (Watch)

  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — user identifier
  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — customer identifier
  • Field (watch_date) — date — watch date
  • Field (pause_time) — interval — pause time

Untitled (CUSTOMER)

  • Key (c_id) — int — Primary key — NOT NULL — customer identifier
  • Field (c_name) — varchar(60) — NOT NULL — customer name
  • Field (email) — varchar(60) — NOT NULL — email
  • Field (pwd) — int — NOT NULL — password
  • Field (gender) — varchar(20) — gender
  • Field (phone) — varchar(20) — NOT NULL — phone number

Untitled (Comment_to)

  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — user identifier
  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — customer identifier
  • Field (rating) — int — rating
  • Field (comment) — varchar(100) — comment
  • Field (write_date) — date — write date

Untitled (Classify)

  • Key (m_id) — int — Foreign key → Untitled.Key — NOT NULL — user identifier
  • Key (g_id) — int — Foreign key → Untitled.Key — NOT NULL — genre identifier

Untitled (Work)

  • Key (p_id) — int — Foreign key → Untitled.Key — NOT NULL — participant idnetifier
  • Key (pr_id) — int — Foreign key → Untitled.Key — NOT NULL — profession identifier

Untitled (PROFESSION)

  • Key (pr_id) — int — Primary key — NOT NULL — profession identifier
  • Field (pr_name) — varchar(60) — NOT NULL — profession name

Untitled (GENRE)

  • Key (g_id) — int — Primary key — NOT NULL — genre identifier
  • Field (g_name) — varchar(60) — NOT NULL — genre name

Untitled2 (Prefer)

  • Key (g_id) — int — Foreign key → Untitled.Key — NOT NULL — genre identifier
  • Key (c_id) — int — Foreign key → Untitled.Key — NOT NULL — customer identifier