주문 DB
테이블 (8)
고객 (tb_customers)
- CustomerID (customer_id) — INT(11) — 기본 키 — NOT NULL
- CategoryName (category_name) — VARCHAR(255)
- ContactName (Field) — VARCHAR(255)
- Address (Field2) — VARCHAR(255)
- City (Field3) — VARCHAR(255)
- PostalCode (Field4) — VARCHAR(255)
- Country (Field5) — VARCHAR(255)
공급자 (tb_suppliers)
- SupplierID (supplier_id) — INT(11) — 기본 키 — NOT NULL
- SupplierName (Field) — VARCHAR(255)
- ContactName (Field2) — VARCHAR(255)
- Address (Field3) — VARCHAR(255)
- City (Field4) — VARCHAR(255)
- PostalCode (Field5) — VARCHAR(255)
- Country (Field6) — VARCHAR(255)
- Phone (Field7) — VARCHAR(255)
- Field8
배송업체 (tb_shippers)
- ShipperID (shipper_id) — INT(11) — 기본 키 — NOT NULL
- ShipperName (Field) — VARCHAR(255)
- Phone (Field2) — VARCHAR(255)
상품 (tb_products)
- ProductID (product_id) — INT(11) — 기본 키 — NOT NULL
- SupplierID (supplier_id) — INT(11) — 외래 키 → 공급자.SupplierID — NOT NULL
- CategoryID (category_id) — INT(11) — 외래 키 → 카테고리.CategoryID — NOT NULL
- ProductName (Field) — VARCHAR(255)
- Unit (Field2) — VARCHAR(255)
- Price (Field3) — INT(11)
주문 (tb_orders)
- OrderID (order_id) — INT(11) — 기본 키 — NOT NULL
- CustomerID (customer_id) — INT(11) — 외래 키 → 고객.CustomerID — NOT NULL
- ShipperID (shipper_id) — INT(11) — 외래 키 → 배송업체.ShipperID — NOT NULL
- EmployeeID (employee_id) — INT(11) — 외래 키 → 직원.EmployeeID — NOT NULL
- OrderDate (Field)
주문상세 (tb_orderdetails)
- OrderDetailID (order_detail_id) — INT(11) — 기본 키 — NOT NULL
- ProductID (product_id) — INT(11) — 외래 키 → 상품.ProductID — NOT NULL
- Quantity (Field)
- OrderID (order_id) — INT(11) — 외래 키 → 주문.OrderID — NOT NULL
직원 (tb_employees)
- EmployeeID (employee_id) — INT(11) — 기본 키 — NOT NULL
- LastName (Field) — VARCHAR(255)
- FirstName (Field2) — VARCHAR(255)
- BirthDate (Field3)
- Photo (Field4) — VARCHAR(255)
- Notes (Field5) — VARCHAR(255)
카테고리 (tb_categories)
- CategoryID (category_id) — INT(11) — 기본 키 — NOT NULL
- CategoryName (Field) — VARCHAR(255)
- Description (Field2) — VARCHAR(255)