OrderDB

Tables (8)

Categories (분류)

  • CategoryID (Field)
  • CategoryName (Field2)
  • Description (Field3)

Customers (고객)

  • CustomerID (Field) — INT
  • CustomerName (Field2) — VARCHARD(255)
  • ContactName (Field3) — VARCHARD(255)
  • Address (Field4) — VARCHARD(255)
  • City (Field5) — VARCHARD(255)
  • PostalCode (Field6) — INT
  • Country (Field7) — VARCHARD(255)

Employees (직원)

  • LastName (Field2)
  • FirstName (Field3)
  • BirthDate (Field4)
  • Photo (Field5)
  • Notes (Field6)
  • Key — Foreign key → Orders.Key — NOT NULL

OrderDetails (주문상쇄)

  • OrderDetailID (Field)
  • OrderID (Field2)
  • ProductID (Field3)
  • Quantity (Field4)

Orders (주문)

  • Key — Primary key — NOT NULL
  • OrderID (Field) — INT
  • CustomerID (Field2) — INT
  • EmployeeID (KEY) — INT
  • OrderDate (Field4)
  • ShipperID (Field5) — INT
  • Field6

Products (상품)

  • ProductID (Field) — INT
  • ProductName (Field2) — VARCHARD(255)
  • SupplierID (Field3) — INT
  • CategoryID (Field4) — INT
  • Unit (Field5) — VARCHARD(255)
  • Price (Field6) — INT
  • Field7

Shippers (해운사)

  • ShipperID (Field)
  • ShipperName (Field2)
  • Phone (Field3)

Suppliers (공급사)

  • SupplierID (Field)
  • SupplierName (Field2)
  • ContactName (Field3)
  • Address (Field4)
  • City (Field5)
  • PostalCode (Field6)
  • Country (Field7)