웹DB_문제3
테이블 (6)
Untitled (ORGANIZATION)
- Key (oID) — char(30) — 기본 키 — NOT NULL
- Field (oName) — char(30)
- Field (oLocation) — char(30)
- Field (oStartdate) — date
Untitled (CLIENT)
- Key (ssn) — char(14) — 기본 키 — NOT NULL
- Field (cName) — char(20)
- Field (cAddress) — char(30)
- Field (cPhonenum) — char(11)
- Field (cAge) — int(3)
- Key (oID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (ssn) — char(14) — 기본 키 — NOT NULL
- Field (dName) — char(20)
- Field (dBday) — date
- Field (dGender) — char(1)
- Field (dRelationship) — char(10)
- Key (cssn) — int(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (sCode) — char(30) — 기본 키 — NOT NULL
- Field (sName) — char(30)
- Field (description) — text
- Field (sStartdate) — date
- Key (oID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE_PROVIDER)
- Key (ssn) — char(14) — 기본 키 — NOT NULL
- Field (pName) — char(20)
- Field (pAddress) — char(30)
- Field (pPhonenum) — char(11)
- Key (sCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE_CLIENT)
- Key (sCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (ssn) — char(14) — 외래 키 → Untitled.Key — NOT NULL
- Field (date) — date