주문db

테이블 (8)

고객 (tb_Customers)

  • CustomerID (customer_id) — int(11) — 기본 키 — NOT NULL
  • ContactName (contact_name) — VARCHAR(255)
  • Address (address) — VARCHAR(255)
  • City (city) — VARCHAR(255)
  • PostalCode (postal_code) — VARCHAR(255)
  • Country (country) — VARCHAR(255)
  • Field
  • CustomerName (customer_name) — VARCHAR(255)

공급업체 (tb_suppliers)

  • SupplierID (supplier_id) — int(11) — 기본 키 — NOT NULL
  • SupplierName (supplier_name) — VARCHAR(255)
  • ContactName (contact_name) — VARCHAR(255)
  • Address (address) — VARCHAR(255)
  • City (city) — VARCHAR(255)
  • PostalCode (postal_code) — VARCHAR(255)
  • Country (country) — VARCHAR(255)
  • Phone (phone) — it(11)
  • Field

배송업체 (tb_shippers)

  • ShipperID (shipper_id) — int(11) — 기본 키 — NOT NULL
  • ShipperName (shipper_name) — VARCHAR(255)
  • phone — smallint
  • Field

제품 (tb_products)

  • ProductID (product_id) — int(11) — 기본 키 — NOT NULL
  • ProductName (product_name) — VARCHAR(255)
  • SupplierID (supplier_id) — int(11)
  • CategoryID (category_id) — int(11)
  • Unit (unit) — VARCHAR(255)
  • Price (price) — FLOAT
  • Field

주문 (tb_Orders)

  • OrderID (Key) — int(11) — 기본 키 — NOT NULL
  • CustomerID (Key2) — int(11) — 외래 키 → 고객.CustomerID — NOT NULL
  • EmployeeID (employee_id) — int(11) — 외래 키 → 직원.EmployeeID — NOT NULL
  • ShipperID (shipper_id) — int(11) — 외래 키 → 배송업체.ShipperID — NOT NULL

주문세부정보 (tb_orderdetails)

  • OrderDetailID (orderdetaill_id) — int(11) — 기본 키 — NOT NULL
  • SupplierID (supplier_id) — int(11) — 외래 키 → 공급업체.SupplierID — NOT NULL
  • CategoryID (category_id) — int(11) — 외래 키 → 카테고리.CategoryID — NOT NULL
  • ProductID (product_id) — int(11) — 외래 키 → 제품.ProductID — NOT NULL
  • OrderID (Key) — int(11) — 외래 키 → 주문.OrderID — NOT NULL

직원 (tb_employees)

  • EmployeeID (employee_id) — int(11) — 기본 키 — NOT NULL
  • LastName (last_name) — VARCHAR(255)
  • BirthDate (birth_date) — date
  • Photo (photo) — BLOB(65535)
  • Notes (notes) — VARCHAR(255)
  • Field
  • FirstName (first_name) — VARCHAR(255)

카테고리 (tb_categories)

  • CategoryID (category_id) — int(11) — 기본 키 — NOT NULL
  • CategoryName (category_name) — VARCHAR(255)
  • Description (description) — VARCHAR(255)
  • (Field)