ERD Exercise5(여영규)
테이블 (10)
BUY (Untitled3)
- buyinfoID (Key) — char(10) — 기본 키 — NOT NULL
- method (Field) — char(4(
- date (Field2) — date
- Field3
- customersId (Key2) — char(10) — 외래 키 → CUSTOMER.customersId — NOT NULL
- empID — char(10) — 외래 키 → EMPLOYEE.empID — NOT NULL
COLOR
- colorID (Key) — char(50 — 기본 키 — NOT NULL
- color (Field) — char(30)
- RGB (Field2) — char(9)
- description (Field3) — text
- Field4
CUSTOMER (고객)
- customersId (Key) — char(10) — 기본 키 — NOT NULL
- customersName (Field) — char(10)
- customersAddress (Field2) — char(30)
- customersPhone (Field3) — char(10)
- VIP (Field4) — char(1)
EMPLOYEE (Untitled4)
- empID — char(10) — 기본 키 — NOT NULL
- name — char(19)
- phone (Field) — char(10)
GOAL (Untitled5)
- goalID (Key) — char(10) — 기본 키 — NOT NULL
- year (Field) — date
- month (Field2) — date
- qty (Field3) — int
- description (Field4) — text
- empID — char(10) — 외래 키 → EMPLOYEE.empID — NOT NULL
SALES (Untitled2)
- salesID (Key) — char(10) — 기본 키 — NOT NULL
- qty (Field) — int
- shoesCid (Key3) — char(10) — 외래 키 → SHOES.shoesCid — NOT NULL
- buyinfoID (Key2) — char(10) — 외래 키 → BUY.buyinfoID — NOT NULL
SHOES (Untitled)
- shoesCid (Key) — char(10) — 기본 키 — NOT NULL
- Quantity (Field) — int
- styleID (Key2) — char(5) — 외래 키 → STYLLE.styleID — NOT NULL
- sizeID (Key3) — char(5) — 외래 키 → SIZE.sizeID — NOT NULL
- colorID (Key4) — char(50 — 외래 키 → COLOR.colorID — NOT NULL
- supID (Key5) — char(10) — 외래 키 → SUPPLIER.supID — NOT NULL
SIZE
- sizeID (Key) — char(5) — 기본 키 — NOT NULL
- size (Field) — float
- USsize (Field2) — float
- Field3
STYLLE (STYLE)
- styleID (Key) — char(5) — 기본 키 — NOT NULL
- Field
SUPPLIER (공급자)
- supID (Key) — char(10) — 기본 키 — NOT NULL
- supName (Field) — char(d10)
- phone (Field2) — char(14)
- email (Field3) — char(d30)