OrderDB
Tables (8)
Categoris (tb_Categoris)
- CategoryID (PK) — INT — Primary key — NOT NULL
- CategoryName (Field) — VARCHAR(64)
- Description (Field2) — VARCHAR(64)
Customers (tb_Customers)
- CustomerID (PK) — INT — Primary key — NOT NULL
- CustomerName (Field) — VARCHAR(64)
- ConcatName (Field2) — VARCHAR(64)
- Address (Field3) — VARCHAR(64)
- City (Field4) — VARCHAR(64)
- PostalCode (Field5) — INT
- Country (Field6) — VARCHAR(64)
Employees (tb_Employees)
- EmployeeID (PK) — INT — Primary key — NOT NULL
- LastName (Field) — VARCHAR(64)
- FirstName (Field2) — VARCHAR(64)
- BirthDate (Field3) — VARCHAR(64)
- Photo (Field4) — VARCHAR(64)
- Notes (Field5) — VARCHAR(64)
OrderDetails (tb_OrderDetails)
- OrderDetailID (PK) — INT — Primary key — NOT NULL
- OrderID (PK2) — INT — Foreign key → Orders.OrderID — NOT NULL
- ProductID (PK3) — INT — Foreign key → Products.ProductID — NOT NULL
- Quantity (Field) — INT
Orders (tb_Orders)
- OrderID (PK) — INT — Primary key — NOT NULL
- CustomerID (PK2) — INT — Foreign key → Customers.CustomerID — NOT NULL
- EmployeeID (PK3) — INT — Foreign key → Employees.EmployeeID — NOT NULL
- orderDate (Field3) — VARCHAR(64)
- ShipperID (PK4) — INT — Foreign key → Shippers.ShipperID — NOT NULL
Products (tb_products)
- ProductID (PK) — INT — Primary key — NOT NULL
- ProductName (Field) — VARCHAR(64)
- SupplierID (Key) — Foreign key → Suppliers.SupplierID — NOT NULL
- CategoryID (PK2) — INT — Foreign key → Categoris.CategoryID — NOT NULL
- Unit (Field2) — VARCHAR(64)
- Price (Field3) — INT
Shippers (tb_Shippers)
- ShipperID (PK) — INT — Primary key — NOT NULL
- ShipperName (Field) — VARCHAR(64)
- Phone (Field2) — VARCHAR(64)
Suppliers (tb_suppliers)
- SupplierID (Key) — Primary key — NOT NULL
- SupllilerName (Field) — VARCHAR(64)
- ContactName (Field2) — VARCHAR(64)
- Address (Field3) — VARCHAR(64)
- City (Field4) — VARCHAR(64)
- PostalCode (Field5) — VARCHAR(64)
- Country (Field6) — VARCHAR(64)
- Phone (Field7) — VARCHAR(64)