과제 예제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)