Excercise5_0930

Tables (5)

CONTENT

  • FK (Service Code) — INT(20) — Primary key — NOT NULL
  • FK (Producer Num) — INT(20) — Primary key — NOT NULL
  • PK (Service Code) — INT(20) — Foreign key → SERVICE.PK — NOT NULL
  • PK (Customer ID) — INT(20) — Foreign key → SERVICE.PK — NOT NULL
  • FK (Rating) — INT(20)
  • FK (Price) — INT(30)

CUSTOMER

  • PK (Customer ID) — INT(20) — Primary key — NOT NULL
  • Field (Customer Name) — CHAR(100)
  • Field (Address) — CHAR(200)
  • Field (phone) — INT(20)
  • Field (age) — INT(20)

FAMILY

  • PK (Family ID) — INT(20) — Primary key — NOT NULL
  • PK (Customer ID) — INT(20) — Foreign key → CUSTOMER.PK — NOT NULL
  • Field (Family Name) — CHAR(100)
  • Field (Relationship) — CHAR(100)
  • Field (Family Address) — CHAR(200)
  • Field (Family phone) — INT(20)
  • Field (Family age) — INT(20)

PRODUCER

  • PK (Producer Num) — INT(20) — Primary key — NOT NULL
  • FK (Service Code) — INT(20) — Foreign key → CONTENT.FK — NOT NULL
  • FK (Producer Num2) — INT(20) — Foreign key → CONTENT.FK — NOT NULL
  • PK (Service Code) — INT(20) — Foreign key → CONTENT.PK — NOT NULL
  • PK (Customer ID) — INT(20) — Foreign key → CONTENT.PK — NOT NULL
  • Field (Producer Name) — CHAR(100)
  • Field (Producer Address) — CHAR(200)
  • Field (Producer Phone) — INT(20)

SERVICE

  • PK (Service Code) — INT(20) — Primary key — NOT NULL
  • PK (Customer ID) — INT(20) — Foreign key → CUSTOMER.PK — NOT NULL
  • Field (Description) — CHAR(100)
  • Field (Start Date) — INT(100)
  • Field2 (End Date) — INT(100)