과제 예제5_임미숙
테이블 (7)
CUSTOMER (Untitled7)
- customerCode (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — int
- buyingType (Field4) — text
DEPARTMENT (Untitled2)
- departmentId (Key) — char(5) — 기본 키 — NOT NULL
- supplierCode (Key2) — char(5) — 외래 키 → SUPPLIER.supplierCode — NOT NULL
- stocks (Field) — char(10)
- productCode (Field2) — char(5)
- employee (Field3) — char(5)
- supplier (Field4) — char(10)
EMPLOYEE (Untitled3)
- employeeId (Key) — char(10) — 기본 키 — NOT NULL
- departmentId (Key2) — char(5) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
- supplierCode (Key22) — char(5) — 외래 키 → DEPARTMENT.supplierCode — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — int
- salary (Field4) — int
PURCHASE (Untitled6)
- productCode (Key2) — char(5) — 외래 키 → SHOES.productCode — NOT NULL
- departmentId (Key22) — char(5) — 외래 키 → SHOES.departmentId — NOT NULL
- customerCode (Key3) — char(5) — 외래 키 → CUSTOMER.customerCode — NOT NULL
- supplierCode (Key222) — char(5) — 외래 키 → SHOES.supplierCode — NOT NULL
- purchaseDate (Field) — date
- purchaseQuantity (Field2) — int
SALES (Untitled4)
- employeeId (Key) — char(10) — 외래 키 → EMPLOYEE.employeeId — NOT NULL
- departmentId (Key2) — char(5) — 외래 키 → EMPLOYEE.departmentId — NOT NULL
- supplierCode (Key22) — char(5) — 외래 키 → EMPLOYEE.supplierCode — NOT NULL
- productCode (Field) — char(5)
- salesQuota (Field2) — int
SHOES (Untitled)
- productCode (Key) — char(5) — 기본 키 — NOT NULL
- departmentId (Key2) — char(5) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
- supplierCode (Key22) — char(5) — 외래 키 → DEPARTMENT.supplierCode — NOT NULL
- department (Field) — char(5)
- supplier (Field2) — char(10)
- price (Field3) — int
SUPPLIER (Untitled5)
- supplierCode (Key) — char(5) — 기본 키 — NOT NULL
- manager (Field) — char(10)
- phone (Field2) — int
- email (Field3) — char(20)