Introduction to the Northwind database

Introduction to the Northwind database

----------------------------------------------------------------------

①categories:

Type table
corresponding fields:
CategoryID: Type ID;
CategoryName: type name;
Description: type description;
Picture: Product Sample

②customercustomerdemo: Customer Type Table 1
corresponding fields:
CustomerID: Customer ID;
Customertypeid: Customer Type ID

③customerdemographics: Customer Type Table 2
corresponding fields:
Customertypeid: Customer type ID;
Customerdesc: Customer Description

④customers: Customer table
corresponding fields:
CustomerID: Customer ID;
CompanyName: Name of the company in which it resides;
ContactName: Customer name;
ContactTitle: Customer title;
Address: contact addresses;
City: Location;
Region: location;
PostalCode: Zip code;
Country: Country
Phone: telephone;
传真: Fax

⑤employees: Employee table
corresponding fields:
EmployeeID: Employee code;
LastName + FirstName: Employee name;
Title: titles;
TitleOfCourtesy: honorific;
BirthDate: Date of birth;
HireDate: Date of employment;
Address: Home addresses;
City: Location;
Region: location;
PostalCode: Zip code;
Country: national use;
HomePhone: Home electricity;
Extension: extension;
Photo: Mobile phone;
NOTES: photos;
ReportsTo: Superior;
Photopath: Photos

⑥employeeterritories: Employee Department table
corresponding fields:
EmployeeID: Employee number;
TerritoryID: Department Code

⑦order Details: Order Schedule
corresponding fields:
OrderID: Order number;
ProductID: Product number;
UnitPrice: Unit Price;
Quantity: Order quantity;
Discount: Discount

⑧orders: Order Form
corresponding fields:
OrderID: Order number;
CustomerID: Customer number;
EmployeeID: Employee number;
OrderDate: Order date;
RequiredDate: expected arrival date;
ShippedDate: delivery date;
ShipVia: Freight forwarders;
Freight: Freight;
ShipName: Name of the owner;
ShipAddress: Shipper's address
ShipCity: The city where the owner is located;
ShipRegion: The area where the shipper is located;
Shippostalcode: Shipper postcode;
ShipCountry: The country where the shipper is located

⑨products: Product Table
corresponding fields:
ProductID: Product ID;
ProductName: Product name;
SupplierID: Supplier ID;
CategoryID: Type ID;
QuantityPerUnit: quantity;
UnitPrice: Unit Price;
UnitsInStock: Inventory quantity;
UnitsOnOrder: Order quantity;
ReorderLevel: Re-order quantity;
Discontinued: Abort

⑩region: Regional Table
corresponding fields:
RegionID: Region ID;
RegionDescription: Region description

? Shippers: Freight Forwarders
corresponding fields:
ShipperID: Freight forwarder ID;
CompanyName: Company name;
Phone: Contact number

? Suppliers: Supplier table
corresponding fields:
ShipperID: Supplier ID;
CompanyName: Name of supplier;
Phone, contact number

? Territories: Regional Table
corresponding fields:
TerritoryID: Territory number;
Territorydescription: Geographical description;
RegionID: Area number

--------------------------------------------------------

Introduction to the Northwind database