E3-GOVER
Tables (8)
Untitled (ORGANIZATION)
- Key (organID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (SERVICE)
- Key (serCode) — char(2) — Primary key — NOT NULL
- Field (description) — text
- Key (agentID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (WOMEN_CRIENT)
- Key (ssn) — char(13) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (add) — char(50)
- Field (phone) — char(11)
- Key (organID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (ssnD) — char(13) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (age) — char(2)
- Key (ssnWC) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (ORG_AGENT)
- Key (agentID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (add) — char(50)
- Field (phone) — char(11)
- Key (organID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (SURVICE_PERIOD)
- Key — Primary key — NOT NULL
- Key (period) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (serCode) — char(2) — Foreign key → Untitled.Key — NOT NULL
Untitled (PERIOD)
- Key (period) — integer — Primary key — NOT NULL
Untitled (ENROLL)
- Key (serCode) — char(2) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn) — char(13) — Foreign key → Untitled.Key — NOT NULL