주문 DB
테이블 (8)
Categories (목록)
- CategoryID (category_id) — INT — 기본 키 — NOT NULL
- CategoryName (category_name) — VARCHAR(50)
- Description (description) — VARCHAR(255)
Customers (고객)
- CustomerID (costomer_id) — INT — 기본 키 — NOT NULL
- CustomName (custom_name) — VARCHAR(255)
- ContactName (contact_name) — VARCHAR(255)
- Adress (adress) — VARCHAR(255)
- City (city) — VARCHAR(255)
- FostalCode (fostal_code) — VARCHAR(10)
- Country (country) — VARCHAR(50)
Employees (직원)
- EmployeeID (employee_id) — INT — 기본 키 — NOT NULL
- LastName (last_name) — VARCHAR(50)
- FirstName (first_name) — VARCHAR(50)
- BirthDate (birth_data) — 0000-00-00
- Photo (photo) — VARCHAR(50)
- Notes (notes) — VARCHAR(255)
OrderDetails (주문상세)
- OrderDetailID (orderdetail_id) — INT — 기본 키 — NOT NULL
- OrderID (order_id2) — INT — 외래 키 → Orders.OrderID — NOT NULL
- ProductID (product_id) — INT — 외래 키 → Products.ProductID — NOT NULL
- Quantity (quantity) — INT
Orders (주문)
- OrderID (order_id) — INT — 기본 키 — NOT NULL
- CustomerID (costomer_id) — INT — 외래 키 → Customers.CustomerID — NOT NULL
- EmployeeID (employee_id) — INT — 외래 키 → Employees.EmployeeID — NOT NULL
- ShipperID (shipper_id) — INT — 외래 키 → Shippers.ShipperID — NOT NULL
Products (상품)
- ProductID (product_id) — INT — 기본 키 — NOT NULL
- ProductName (Field) — VARCHAR(255)
- SupplierID (supplier_id) — INT — 외래 키 → Suppliers.SupplierID — NOT NULL
- CategoryID (category_id) — INT — 외래 키 → Categories.CategoryID — NOT NULL
- Unit (unit) — VARCHAR(255)
- Price (price) — INT
Shippers (배송업체)
- ShipperID (shipper_id) — INT — 기본 키 — NOT NULL
- ShipperName (shipper_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
Suppliers (공급자)
- SupplierID (supplier_id) — INT — 기본 키 — NOT NULL
- SupplierName (supplier_name) — VARCHAR(255)
- ContactName (contact_name) — VARCHAR(255)
- Address (address) — VARCHAR(255)
- City (city) — VARCHAR(50)
- PostalCode (postal_code) — VARCHAR(10)
- Country (country) — VARCHAR(50)
- Phone (phone) — (***)****-****