주문 DB

테이블 (8)

Categories (목록)

  • CategoryID (category_id) — INT — 기본 키 — NOT NULL
  • CategoryName (category_name) — VARCHAR(50)
  • Description (description) — VARCHAR(255)

Customers (고객)

  • CustomerID (costomer_id) — INT — 기본 키 — NOT NULL
  • CustomName (custom_name) — VARCHAR(255)
  • ContactName (contact_name) — VARCHAR(255)
  • Adress (adress) — VARCHAR(255)
  • City (city) — VARCHAR(255)
  • FostalCode (fostal_code) — VARCHAR(10)
  • Country (country) — VARCHAR(50)

Employees (직원)

  • EmployeeID (employee_id) — INT — 기본 키 — NOT NULL
  • LastName (last_name) — VARCHAR(50)
  • FirstName (first_name) — VARCHAR(50)
  • BirthDate (birth_data) — 0000-00-00
  • Photo (photo) — VARCHAR(50)
  • Notes (notes) — VARCHAR(255)

OrderDetails (주문상세)

  • OrderDetailID (orderdetail_id) — INT — 기본 키 — NOT NULL
  • OrderID (order_id2) — INT — 외래 키 → Orders.OrderID — NOT NULL
  • ProductID (product_id) — INT — 외래 키 → Products.ProductID — NOT NULL
  • Quantity (quantity) — INT

Orders (주문)

  • OrderID (order_id) — INT — 기본 키 — NOT NULL
  • CustomerID (costomer_id) — INT — 외래 키 → Customers.CustomerID — NOT NULL
  • EmployeeID (employee_id) — INT — 외래 키 → Employees.EmployeeID — NOT NULL
  • ShipperID (shipper_id) — INT — 외래 키 → Shippers.ShipperID — NOT NULL

Products (상품)

  • ProductID (product_id) — INT — 기본 키 — NOT NULL
  • ProductName (Field) — VARCHAR(255)
  • SupplierID (supplier_id) — INT — 외래 키 → Suppliers.SupplierID — NOT NULL
  • CategoryID (category_id) — INT — 외래 키 → Categories.CategoryID — NOT NULL
  • Unit (unit) — VARCHAR(255)
  • Price (price) — INT

Shippers (배송업체)

  • ShipperID (shipper_id) — INT — 기본 키 — NOT NULL
  • ShipperName (shipper_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)

Suppliers (공급자)

  • SupplierID (supplier_id) — INT — 기본 키 — NOT NULL
  • SupplierName (supplier_name) — VARCHAR(255)
  • ContactName (contact_name) — VARCHAR(255)
  • Address (address) — VARCHAR(255)
  • City (city) — VARCHAR(50)
  • PostalCode (postal_code) — VARCHAR(10)
  • Country (country) — VARCHAR(50)
  • Phone (phone) — (***)****-****