주문db
테이블 (8)
고객 (tb_Customers)
- CustomerID (customer_id) — int(11) — 기본 키 — NOT NULL
- ContactName (contact_name) — VARCHAR(255)
- Address (address) — VARCHAR(255)
- City (city) — VARCHAR(255)
- PostalCode (postal_code) — VARCHAR(255)
- Country (country) — VARCHAR(255)
- Field
- CustomerName (customer_name) — VARCHAR(255)
공급업체 (tb_suppliers)
- SupplierID (supplier_id) — int(11) — 기본 키 — NOT NULL
- SupplierName (supplier_name) — VARCHAR(255)
- ContactName (contact_name) — VARCHAR(255)
- Address (address) — VARCHAR(255)
- City (city) — VARCHAR(255)
- PostalCode (postal_code) — VARCHAR(255)
- Country (country) — VARCHAR(255)
- Phone (phone) — it(11)
- Field
배송업체 (tb_shippers)
- ShipperID (shipper_id) — int(11) — 기본 키 — NOT NULL
- ShipperName (shipper_name) — VARCHAR(255)
- phone — smallint
- Field
제품 (tb_products)
- ProductID (product_id) — int(11) — 기본 키 — NOT NULL
- ProductName (product_name) — VARCHAR(255)
- SupplierID (supplier_id) — int(11)
- CategoryID (category_id) — int(11)
- Unit (unit) — VARCHAR(255)
- Price (price) — FLOAT
- Field
주문 (tb_Orders)
- OrderID (Key) — int(11) — 기본 키 — NOT NULL
- CustomerID (Key2) — int(11) — 외래 키 → 고객.CustomerID — NOT NULL
- EmployeeID (employee_id) — int(11) — 외래 키 → 직원.EmployeeID — NOT NULL
- ShipperID (shipper_id) — int(11) — 외래 키 → 배송업체.ShipperID — NOT NULL
주문세부정보 (tb_orderdetails)
- OrderDetailID (orderdetaill_id) — int(11) — 기본 키 — NOT NULL
- SupplierID (supplier_id) — int(11) — 외래 키 → 공급업체.SupplierID — NOT NULL
- CategoryID (category_id) — int(11) — 외래 키 → 카테고리.CategoryID — NOT NULL
- ProductID (product_id) — int(11) — 외래 키 → 제품.ProductID — NOT NULL
- OrderID (Key) — int(11) — 외래 키 → 주문.OrderID — NOT NULL
직원 (tb_employees)
- EmployeeID (employee_id) — int(11) — 기본 키 — NOT NULL
- LastName (last_name) — VARCHAR(255)
- BirthDate (birth_date) — date
- Photo (photo) — BLOB(65535)
- Notes (notes) — VARCHAR(255)
- Field
- FirstName (first_name) — VARCHAR(255)
카테고리 (tb_categories)
- CategoryID (category_id) — int(11) — 기본 키 — NOT NULL
- CategoryName (category_name) — VARCHAR(255)
- Description (description) — VARCHAR(255)
- (Field)