2023_사서교육원_준사서C반_김종우_예제3
테이블 (4)
Untitled (Supplier)
- Key (SupNo) — int — 기본 키 — NOT NULL
- Field (supName) — char(30)
- Field (supAddress) — char(30)
- Field (supPhoneNumber) — char(11)
- Field (belonging) — char(30)
Untitled (Service)
- Key (serviceCode) — char(30) — 기본 키 — NOT NULL
- Field (serviceExplanation) — char(30)
- Field (suppliedDate) — date
- Key (SupNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (customerSsn) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Customer)
- Key (customerSsn) — char(30) — 기본 키 — NOT NULL
- Field (customerName) — char(30)
- Field (customerAddress) — char(30)
- Field (customerPhoneNumber) — char(11)
- Field (customerAge) — int
- Field (Job) — char(30)
- Field (Income) — int
Untitled (Family)
- Key (famillySsn) — char(30) — 기본 키 — NOT NULL
- Field (familyName) — char(30)
- Field (familyAge) — int
- Field (familyGender) — char(30)
- Field (familyAddress) — char(30)
- Field (Relationship) — char(30)
- Key (customerSsn) — int — 외래 키 → Untitled.Key — NOT NULL