study

테이블 (8)

고객 (tb_Customers)

  • CustomerID — INT — 기본 키 — NOT NULL
  • CustomerName — VARCHAR(255)
  • ContactName — VARCHAR(255)
  • Address — VARCHAR(255)
  • City — VARCHAR(255)
  • PostalCode — VARCHAR(255)
  • Country — VARCHAR(255)

공급처 (tb_Suppliers)

  • SupplierID — INT — 기본 키 — NOT NULL
  • Field (SupplierName) — VARCHAR(255)
  • Field (ContactName) — VARCHAR(255)
  • Field (Address) — VARCHAR(255)
  • Field (City) — VARCHAR(255)
  • Field (PostalCode) — VARCHAR(255)
  • Field (Country) — VARCHAR(255)
  • Field (Phone) — VARCHAR(255)

배송 (tb_Shippers)

  • ShipperID (shipperID) — INT — 기본 키 — NOT NULL
  • shipperName (ShipperName) — VARCHAR(255)
  • Phone (contactNumber) — VARCHAR(255)

상품 (tb_products)

  • ProductID — INT — 기본 키 — NOT NULL
  • Field (ProductName) — VARCHAR(255)
  • SupplierID — INT — 외래 키 → 공급처.SupplierID — NOT NULL
  • CategoryID — INT — 외래 키 → 카테고리.CategoryID — NOT NULL
  • Field (Unit) — VARCHAR(255)
  • Field (Price) — VARCHAR(255)

주문 (tb_Oders)

  • OrderID — INT — 기본 키 — NOT NULL
  • 고객ID (CustomerID) — INT — 외래 키 → 고객.CustomerID — NOT NULL
  • 직원ID (EmployeeID) — INT — 외래 키 → 직원.EmployeeID — NOT NULL
  • 배송ID (shipperID) — INT — 외래 키 → 배송.ShipperID — NOT NULL
  • OrderDate — VARCHAR(255)

주문정보 (tb_Orderdetails)

  • Key (OrderdetailID) — INT — 기본 키 — NOT NULL
  • 주문ID (OrderID) — INT — 외래 키 → 주문.OrderID — NOT NULL
  • Field (Quantity) — INT
  • ProductID — INT — 외래 키 → 상품.ProductID — NOT NULL

직원 (tb_Employees)

  • EmployeeID — INT — 기본 키 — NOT NULL
  • LastName (Lastname) — VARCHAR(255)
  • FirstName — VARCHAR(255)
  • BirthDate (DateofBirth) — date
  • Photo — VARCHAR(255)
  • Notes — VARCHAR(255)

카테고리 (tb_categories)

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