2025-10-12-ex3

Tables (6)

CUSTOMER (Untitled)

  • custID (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • address (Field2) — varchar(100)
  • phone (Field3) — varchar(15)

DEPENDENT (Untitled2)

  • depID (Key) — char(13) — Primary key — NOT NULL
  • custID (Key2) — char(13) — Foreign key → CUSTOMER.custID — NOT NULL
  • name (Field) — varchar(30)
  • age (Field2) — int

PROVIDER (Untitled4)

  • provID (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • address (Field2) — varchar(100)
  • contact (Field3) — varchar(15)

PROVIDER_SUPPORTS_SERVICE (Untitled5)

  • provID (Key) — int — Foreign key → PROVIDER.provID — NOT NULL
  • svcCode (Key2) — char(10) — Foreign key → SERVICE.svcCode — NOT NULL

SERVICE (Untitled3)

  • svcCode (Key) — char(10) — Primary key — NOT NULL
  • description (Field) — text

UTILIZATION (Untitled6)

  • serviceDate (Key2) — date — Primary key — NOT NULL
  • custID (Key) — char(13) — Foreign key → CUSTOMER.custID — NOT NULL