Community service organization
Tables (10)
Untitled (COSTOMER)
- Key (ID) — char(30) — Primary key — NOT NULL
- Field (cname) — char(30)
- Field (address) — char(30)
- Field (cphone) — char(12)
Untitled (DEPENDANT)
- Key (dID) — char(30) — Primary key — NOT NULL
- Field (dname) — char(30)
- Field (age) — char(30)
- Key (ID2) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE SUPPLIER)
- Key (SID) — char(30) — Primary key — NOT NULL
- Field (sname) — char(30)
- Field (saddress) — char(30)
- Field (sphone) — char(12)
Untitled (SERVICEINFORMATION)
- Key (service code) — char(30) — Primary key — NOT NULL
- Field (description) — text
Untitled (COSTOMER-SERVICE SUPPLIER)
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (SID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (COSTOMER-SERVICEINFORMATION)
- Key (date) — char(30) — Primary key — NOT NULL
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (service code) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTUAKSERVICEPROVIDER)
- Key (stateagent) — char(30) — Primary key — NOT NULL
- Key (SID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (vocationaleducation) — chat(30) — Primary key — NOT NULL
Untitled (COSTOMER_ACTUAKSERVICEPROVIDER)
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (stateagent) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (SID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (COSTOMER-SERVICE)
- Key (date) — char(30) — Primary key — NOT NULL
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (vocationaleducation) — chat(30) — Foreign key → Untitled.Key — NOT NULL