exercise3

Tables (5)

CUSTOMER (Untitled)

  • ID (Key) — int(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)
  • phone (Field3) — int(11)

FAMILY (Untitled2)

  • ID (Key) — int(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — int(11)

PROVIDER (Untitled4)

  • ssn (Key) — int(8) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)
  • phone (Field3) — int(11)
  • code (Key2) — int(10) — Foreign key → SERVICE.code — NOT NULL

SERVICE (Untitled3)

  • code (Key) — int(10) — Primary key — NOT NULL
  • explanation (Field) — char(50)
  • ID (Key2) — int(13) — Foreign key → CUSTOMER.ID — NOT NULL
  • serviceDate (Field2) — date

has (Untitled5)