주문DB
테이블 (8)
고객 (tb_customers)
- CustomerID (customer_id) — int(11) — 기본 키 — NOT NULL
- CustomerName (customer_name) — VARCHAR(30)
- ContactName (contact_name) — VARCHAR(30)
- Address (address) — VARCHAR(30)
- City (city) — VARCHAR(30)
- PostalCode (postal_code) — VARCHAR(20)
- Country (country) — VARCHAR(30)
공급자 (tb_suppliers)
- SupplierID (supplier_id) — int(11) — 기본 키 — NOT NULL
- SupplierName (supplier_name) — VARCHAR(30)
- ContactName (contact_name) — VARCHAR(30)
- Address (address) — VARCHAR(30)
- City (city) — VARCHAR(30)
- PostalCode (postal_code) — VARCHAR(20)
- Country (country) — VARCHAR(30)
- Phone (phone) — VARCHAR(30)
배달 (tb_shippers)
- ShipperID (shipper_id) — int(11) — 기본 키 — NOT NULL
- ShipperName (shipper_name) — VARCHAR(30)
- Phone (phone) — VARCHAR(30)
분류 (tb_categories)
- CategoryID (category_id) — int(11) — 기본 키 — NOT NULL
- CategoryName (category_name) — VARCHAR(30)
- Description (description) — VARCHAR(256)
상품 (tb_products)
- ProductID (product_id) — int(11) — 기본 키 — NOT NULL
- ProductName (product_name) — VARCHAR(30)
- SupplierID (supplier_id) — int(11) — 외래 키 → 공급자.SupplierID — NOT NULL
- CategoryID (category_id) — int(11) — 외래 키 → 분류.CategoryID — NOT NULL
- Unit (unit) — VARCHAR(30)
- Price (price) — float(20)
주문 (tb_orders)
- OrderID (order_id) — int(11) — 기본 키 — NOT NULL
- CustomerID (customer_id) — int(11) — 외래 키 → 고객.CustomerID — NOT NULL
- EmployeeID (employee_id) — int(11) — 외래 키 → 직원.EmployeeID — NOT NULL
- ShipperID (shipper_id) — int(11) — 외래 키 → 배달.ShipperID — NOT NULL
주문상세 (tb_orderdetails)
- OrderDetailID (orderDetail_id) — int(11) — 기본 키 — NOT NULL
- Quantity (quantity) — float(20)
- ProductID (product_id) — int(11) — 외래 키 → 상품.ProductID — NOT NULL
- OrderID (order_id) — int(11) — 외래 키 → 주문.OrderID — NOT NULL
직원 (tb_employees)
- EmployeeID (employee_id) — int(11) — 기본 키 — NOT NULL
- LastName (last_name) — VARCHAR(30)
- FirstName (first_name) — VARCHAR(30)
- BirthDate (birth_date) — date
- Photo (photo) — VARCHAR(30)
- Notes (notes) — VARCHAR(30)