ex.3
Tables (4)
Locserv. (Untitled2)
- Family (Key) — char(4) — Primary key — NOT NULL
- Family2 (Key2) — char(4) — Primary key — NOT NULL
- SSN (Key3) — char(13) — Primary key — NOT NULL
Staterepr. (Untitled3)
- SSN (Key) — char(13) — Primary key — NOT NULL
- jobtraining (Field) — char(20)
- serv.exp (Field2) — char(50)
- SSN (Key2) — char(13) — Foreign key → customer.SSN — NOT NULL
- Family (Key3) — char(4) — Foreign key → Locserv..Family — NOT NULL
- Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
- SSN (Key32) — char(13) — Foreign key → Locserv..SSN — NOT NULL
customer (Untitled)
- SSN (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(4)
- age (Field2) — int(3)
- Family2 (Field3) — char(4)
- Family (Field4) — char(4)
- Family (Key2) — char(4) — Foreign key → Locserv..Family — NOT NULL
- Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
- SSN (Key3) — char(13) — Foreign key → Locserv..SSN — NOT NULL
priv.serv. (Untitled4)
- SSN (Key) — char(13) — Primary key — NOT NULL
- jobtraining (Field) — char(20)
- serv.exp (Field2) — char(50)
- SSN (Key2) — char(13) — Foreign key → customer.SSN — NOT NULL
- Family (Key3) — char(4) — Foreign key → Locserv..Family — NOT NULL
- Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
- SSN (Key32) — char(13) — Foreign key → Locserv..SSN — NOT NULL