예5
테이블 (5)
Untitled (Client)
- Key (Ccode) — int — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (Address) — text
- Field — char(14)
- Field2 (pType) — char(20)
- Field2 (pDate) — char(10)
- Field2 (pAmount) — char(20)
Untitled (Provider)
- Key (pCode) — int — 기본 키 — NOT NULL
- Field (product) — char(10)
Untitled (Department)
- Key (dCode) — int — 기본 키 — NOT NULL
- Field (dName) — char(50)
Untitled (Employee)
- Key (ID) — int — 기본 키 — NOT NULL
- Key (dCode) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(20
Untitled (Purchase)
- Key (Ccode) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (sCode) — char(10) — 외래 키 — NOT NULL
- Key (Ccode2) — int — 외래 키 → Untitled.Key — NOT NULL