EX3 준사서A 2022911006
테이블 (9)
Untitled (ORGANIZATION)
- Key (orID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (matchingP) — char(20)
Untitled (SERVICE)
- Key (serviceID) — char(10) — 기본 키 — NOT NULL
- Field (s-name) — char(30)
- Field (year) — integer(4)
- Field (month) — integer(2)
- Field (description) — text
- Key (orID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE_Time)
- Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (timeID) — dhar(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(30)
Untitled (Time)
- Key (timeID) — dhar(20) — 기본 키 — NOT NULL
- Field (time) — integer(20)
Untitled (LECTURER)
- Key (lecturerID) — char(10) — 기본 키 — NOT NULL
- Field (workplace) — char(20)
- Field (name) — char(20)
- Field (address) — char(30)
- Field2 (phone) — char(11)
- Field (description) — text
Untitled (LECTURER_S)
- Key (lecturerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (service) — char(20)
- Field (time) — char(6)
Untitled (MATCHING_P)
- Key (orID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- wcID (ssn) — char(13) — 외래 키 → WOMEN_CRIENT.wcID — NOT NULL
- Field (s-name) — char(30)
Untitled3 (FAMILY)
- Key (ssn) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (age) — char(3)
- wcID (ssn2) — char(13) — 외래 키 → WOMEN_CRIENT.wcID — NOT NULL
WOMEN_CRIENT
- wcID (ssn) — char(13) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — char(11)