연습5
테이블 (5)
customer (Untitled3)
- cusID (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)
producer (Untitled2)
- proID (Key) — 기본 키 — NOT NULL
- address (Field)
- phone (Field2)
- name (Field3)
sale (Untitled5)
- shoID (Key) — 외래 키 → shoes.shoID — NOT NULL
- employeeNo (Key3) — 외래 키 → salesperson.employeeNo — NOT NULL
- cusID (Key2) — 외래 키 → customer.cusID — NOT NULL
- purchaseDATE (Field)
- quantity (Field2)
- paymentTYPE (Field3)
salesperson (Untitled4)
- employeeNo (Key) — 기본 키 — NOT NULL
- sales rate (Field)
shoes (Untitled)
- shoID (Key) — 기본 키 — NOT NULL
- style (Field)
- size (Field2)
- color (Field3)
- proID (Key2) — 외래 키 → producer.proID — NOT NULL
- stock (Field4)