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)