연습_KJW
테이블 (8)
Categories (tb_categories)
- CategoryID (PK) — INT — 기본 키 — NOT NULL
- CategoryName (Field) — VARCHAR(255)
- Description (Field2) — VARCHAR(255)
Customers (tb_customers)
- CustomerID (PK) — INT — 기본 키 — NOT NULL
- CustomerName (Field) — VARCHAR(255)
- ContactName (Field2) — VARCHAR(255)
- Address (Field3) — VARCHAR(255)
- City (Field4) — VARCHAR(255)
- PostalCode (Field5) — VARCHAR(255)
- Country (Field6)
Employees (tb_employees)
- EmployeeID (PK) — INT — 기본 키 — NOT NULL
- LastName (Field) — VARCHAR(255)
- FirstName (Field2) — VARCHAR(255)
- BirthDate (Field3) — VARCHAR(255)
- Photo (Field4) — VARCHAR(255)
- Notes (Field5) — VARCHAR(255)
OrderDetails (tb_orderdetails)
- OrderDetailID (PK) — INT — 기본 키 — NOT NULL
- ProductID (Field2) — INT
- Quantity (Field3) — INT
- OrderID (Field1) — INT — 외래 키 → Orders.OrderID — NOT NULL
Orders (tb_orders)
- OrderID (Field1) — INT — 기본 키 — NOT NULL
- OrderDate (Field3) — VARCHAR(255)
- CustomerID (PK) — INT — 외래 키 → Customers.CustomerID — NOT NULL
- EmployeeID (PK2) — INT — 외래 키 → Employees.EmployeeID — NOT NULL
- ShipperID (PK3) — INT — 외래 키 → Shippers.ShipperID — NOT NULL
Products (tb_products)
- ProductID (PK) — INT — 기본 키 — NOT NULL
- ProductName (Field) — VARCHAR(64)
- Unit (Field4) — VARCHAR(255)
- Price (Field3) — INT
- CategoryID (PK2) — INT — 외래 키 → Categories.CategoryID — NOT NULL
- SupplierID (Key2) — INT — 외래 키 → Suppliers.SupplierID — NOT NULL
Shippers (tb_shippers)
- ShipperID (PK) — INT — 기본 키 — NOT NULL
- ShipperName (Field) — VARCHAR(255)
- Phone (Field2) — VARCHAR(255)
Suppliers (tb_suppliers)
- SupplierID (Key) — INT — 기본 키 — NOT NULL
- SupplierName (Field) — VARCHAR(255)
- ContactName (Field2) — VARCHAR(255)
- Address (Field3) — VARCHAR(255)
- City (Field4) — VARCHAR(64)
- PostalCode (Field5) — VARCHAR(64)
- Country (Field6) — VARCHAR(64)
- Phone (Field7) — VARCHAR(64)