SOCIAL SERVICE
Tables (5)
AGENT (Untitled4)
- a_# (Key) — INT(20) — Primary key — NOT NULL
- a_name (Field) — VARCHAR(30)
- a_address (Field2) — VARCHAR(100)
- a_ph (Field3) — INT(11)
CUSTOMER (Untitled2)
- c_id (Key) — INT(13) — Primary key — NOT NULL
- c_name (Field) — VARCHAR(30)
- c_address (Field2) — VARCHAR(100)
- c_ph (Field3) — INT(11)
DEPENDENT (Untitled3)
- d_id (Key) — INT(13) — Primary key — NOT NULL
- d_name (Field) — VARCHAR(30)
- d_age (Field2) — INT(3)
- c_id (Key2) — INT(13) — Foreign key → CUSTOMER.c_id — NOT NULL
ENROLL-SERVICE (Untitled)
- c_id (Key) — INT(13) — Primary key — NOT NULL
- s_code (Key2) — CHAR(30) — Primary key — NOT NULL
- c_id (Key3) — INT(13) — Foreign key → CUSTOMER.c_id — NOT NULL
SERVICE (Untitled5)
- s_code (Key) — CHAR(20) — Primary key — NOT NULL
- exp (Field) — VARCHAR(100)
- s_date (Field2) — DATETIME