OrderDB
Tables (8)
Categories (분류)
- CategoryID (Field)
- CategoryName (Field2)
- Description (Field3)
Customers (고객)
- CustomerID (Field) — INT
- CustomerName (Field2) — VARCHARD(255)
- ContactName (Field3) — VARCHARD(255)
- Address (Field4) — VARCHARD(255)
- City (Field5) — VARCHARD(255)
- PostalCode (Field6) — INT
- Country (Field7) — VARCHARD(255)
Employees (직원)
- LastName (Field2)
- FirstName (Field3)
- BirthDate (Field4)
- Photo (Field5)
- Notes (Field6)
- Key — Foreign key → Orders.Key — NOT NULL
OrderDetails (주문상쇄)
- OrderDetailID (Field)
- OrderID (Field2)
- ProductID (Field3)
- Quantity (Field4)
Orders (주문)
- Key — Primary key — NOT NULL
- OrderID (Field) — INT
- CustomerID (Field2) — INT
- EmployeeID (KEY) — INT
- OrderDate (Field4)
- ShipperID (Field5) — INT
- Field6
Products (상품)
- ProductID (Field) — INT
- ProductName (Field2) — VARCHARD(255)
- SupplierID (Field3) — INT
- CategoryID (Field4) — INT
- Unit (Field5) — VARCHARD(255)
- Price (Field6) — INT
- Field7
Shippers (해운사)
- ShipperID (Field)
- ShipperName (Field2)
- Phone (Field3)
Suppliers (공급사)
- SupplierID (Field)
- SupplierName (Field2)
- ContactName (Field3)
- Address (Field4)
- City (Field5)
- PostalCode (Field6)
- Country (Field7)