sql study
Tables (8)
Categories (Untitled)
- CategoryID (Key) — int — Primary key — NOT NULL
- CateogryName (Field)
- Description (Field2)
Customers
- CustomerId (Key) — int — Primary key — NOT NULL
- CustomerName (Field)
- contactName (Field2)
- Address (Field3)
- City (Field4)
- PstalCode (Field5)
- Country (Field6)
Employees (Untitled2)
- EmployeeId (Key) — Primary key — NOT NULL
- LastName (Field)
- FirstName (Field2)
- BirthDate (Field3)
- Photo (Field4)
- Notes (Field5)
OrderDetails (Untitled4)
- OrderDetailID (Key) — Primary key — NOT NULL
- ProductID (Key3) — Foreign key → Products.ProductID — NOT NULL
- OrderID (Key2) — Foreign key → Orders.OrderID — NOT NULL
- Quantity (Field)
Orders (Untitled3)
- OrderID (Key) — Primary key — NOT NULL
- CustomerId (Key2) — int — Foreign key → Customers.CustomerId — NOT NULL
- ShipperID (Key4) — Foreign key → Shippers.ShipperID — NOT NULL
- EmployeeId (Key3) — Foreign key → Employees.EmployeeId — NOT NULL
- OrderDate (Field)
Products (Untitled7)
- ProductID (Key) — Primary key — NOT NULL
- SupplierID (Key2) — Foreign key → Suppliers.SupplierID
- CategoryID (Key3) — int — Foreign key → Categories.CategoryID — NOT NULL
- ProductName (Field)
- Unit (Field2)
- Price (Field3)
Shippers (Untitled5)
- ShipperID (Key) — Primary key — NOT NULL
- ShipperName (Field)
- Phone (Field2)
Suppliers (Untitled6)
- SupplierID (Key) — Primary key — NOT NULL
- SupplierName (Field)
- ContactName (Field2)
- Address (Field3)
- City (Field4)
- PostalCode (Field5)
- Country (Field6)
- Phone (Field7)