Introduction to the Northwind database

①categories:

categoryid: type ID;
CategoryName: type name;
Description: type description;
Picture: Product Sample

②customercustomerdemo: Customer Type table 1
customerid: Customer ID;
Customertypeid: Customer type ID

③customerdemographics: Customer Type Table 2
customertypeid: Customer type ID;
Customerdesc: Customer description

④customers: Customer table
customerid: Customer ID;
CompanyName: Company name;
ContactName: Customer name;
ContactTitle: Customer title;
Address: contact;
City: Location;
Region: location;
PostalCode: Postal code;
Country: Country
Phone: telephone;
传真: fax

⑤employees: Employee table
employeeid: Employee code;
LastName + FirstName: Employee name;
Title: title;
TitleOfCourtesy: honorific;
BirthDate: Date of birth;
HireDate: Date of employment;
Address: Home location;
City: location;
Region: location;
PostalCode: Postal code;
Country: National use;
HomePhone: Home power;
Extension: extension;
Photo: Mobile;
Notes: photos;
ReportsTo: Superiors;
Photopath: Photo

⑥employeeterritories: Employee Department table
employeeid: Employee number;
TerritoryID: Department code

⑦order Details: Order schedule
orderid: Order number;
ProductID: Product number;
UnitPrice: Unit price;
Quantity: Order quantity;
Discount: Discount

⑧orders: Order form
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: Shipper's name;
ShipAddress: Shipper's address
ShipCity: The city where the shipper is located;
ShipRegion: The area where the shipper is located;
Shippostalcode: Shipper postcode;
ShipCountry: Shipper Country

⑨products: Product table
productid: Product ID;
ProductName: Product name;
SupplierID: Vendor ID;
CategoryID: Type ID;
QuantityPerUnit: quantity;
UnitPrice: Unit Price;
UnitsInStock: Inventory quantity;
UnitsOnOrder: Order quantity;
ReorderLevel: Reorder quantity;
Discontinued: Abort

⑩region: Region table
regionid: Region ID;
RegionDescription: Region description

shipperid: Freight forwarder ID;
CompanyName: Company name;
Phone: Contact telephone

shipperid: Supplier ID;
CompanyName: supplier name;
Phone; Contact phone

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

Introduction to the Northwind database