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