Exercise5(배미연)
테이블 (6)
Customer (Untitled6)
- CustomerCode (Key) — char(5) — 기본 키 — NOT NULL
- CustomerName (Field) — char(10)
- CustomerAddress (Field2) — char(30)
- CustomerPhone (Field3) — char(11)
- CustomerStyle (Field4) — type
- CustomerTransaction (Field5) — type
- EmployeeNumber (Key2) — char(5) — 외래 키 → Enroll.SalespersonCode — NOT NULL
Department (Untitled2)
- DepartmentCode (Key) — char(5) — 기본 키 — NOT NULL
- DepartmentName (Field) — char(10)
- SalespersonCode (Field2) — char(5)
Enroll (Untitled5)
- SalespersonCode (Key) — char(5) — 기본 키 — NOT NULL
- SalesCommission (Field) — integer
- SalesQuota (Field2) — integer
- Code (Key2) — char(6) — 외래 키 → Shoe.Code — NOT NULL
Shoe (Untitled)
- Code (Key) — char(6) — 기본 키 — NOT NULL
- ShoeName (Field) — char(10)
- DepartmentCode (Key2) — char(5) — 외래 키 → Department.DepartmentCode — NOT NULL
- SupplierCode (Key3) — char(5) — 외래 키 → Supplier.SupplierCode — NOT NULL
Shoecode (Untitled3)
- Style (Key) — type — 기본 키 — NOT NULL
- Code (Key2) — char(6) — 외래 키 → Shoe.Code — NOT NULL
- Size (Field) — type
- Color (Field2) — type
Supplier (Untitled4)
- SupplierCode (Key) — char(5) — 기본 키 — NOT NULL
- Shoe (Field)