주문 DB

테이블 (8)

고객 (tb_customers)

  • CustomerID (customer_id) — INT(11) — 기본 키 — NOT NULL
  • CategoryName (category_name) — VARCHAR(255)
  • ContactName (Field) — VARCHAR(255)
  • Address (Field2) — VARCHAR(255)
  • City (Field3) — VARCHAR(255)
  • PostalCode (Field4) — VARCHAR(255)
  • Country (Field5) — VARCHAR(255)

공급자 (tb_suppliers)

  • SupplierID (supplier_id) — INT(11) — 기본 키 — NOT NULL
  • SupplierName (Field) — VARCHAR(255)
  • ContactName (Field2) — VARCHAR(255)
  • Address (Field3) — VARCHAR(255)
  • City (Field4) — VARCHAR(255)
  • PostalCode (Field5) — VARCHAR(255)
  • Country (Field6) — VARCHAR(255)
  • Phone (Field7) — VARCHAR(255)
  • Field8

배송업체 (tb_shippers)

  • ShipperID (shipper_id) — INT(11) — 기본 키 — NOT NULL
  • ShipperName (Field) — VARCHAR(255)
  • Phone (Field2) — VARCHAR(255)

상품 (tb_products)

  • ProductID (product_id) — INT(11) — 기본 키 — NOT NULL
  • SupplierID (supplier_id) — INT(11) — 외래 키 → 공급자.SupplierID — NOT NULL
  • CategoryID (category_id) — INT(11) — 외래 키 → 카테고리.CategoryID — NOT NULL
  • ProductName (Field) — VARCHAR(255)
  • Unit (Field2) — VARCHAR(255)
  • Price (Field3) — INT(11)

주문 (tb_orders)

  • OrderID (order_id) — INT(11) — 기본 키 — NOT NULL
  • CustomerID (customer_id) — INT(11) — 외래 키 → 고객.CustomerID — NOT NULL
  • ShipperID (shipper_id) — INT(11) — 외래 키 → 배송업체.ShipperID — NOT NULL
  • EmployeeID (employee_id) — INT(11) — 외래 키 → 직원.EmployeeID — NOT NULL
  • OrderDate (Field)

주문상세 (tb_orderdetails)

  • OrderDetailID (order_detail_id) — INT(11) — 기본 키 — NOT NULL
  • ProductID (product_id) — INT(11) — 외래 키 → 상품.ProductID — NOT NULL
  • Quantity (Field)
  • OrderID (order_id) — INT(11) — 외래 키 → 주문.OrderID — NOT NULL

직원 (tb_employees)

  • EmployeeID (employee_id) — INT(11) — 기본 키 — NOT NULL
  • LastName (Field) — VARCHAR(255)
  • FirstName (Field2) — VARCHAR(255)
  • BirthDate (Field3)
  • Photo (Field4) — VARCHAR(255)
  • Notes (Field5) — VARCHAR(255)

카테고리 (tb_categories)

  • CategoryID (category_id) — INT(11) — 기본 키 — NOT NULL
  • CategoryName (Field) — VARCHAR(255)
  • Description (Field2) — VARCHAR(255)