Introduction to the northwind database

Author: Take me away

① Categories:

Category Table
Field:
Categoryid: Type ID;
Categoryname: type name;
Description: type description;
Picture: product sample

② Customercustomerdemo: customer type table 1
Field:
Customerid: Customer ID;
Customertypeid: customer type ID

③ Customerdemographics: customer type table 2
Field:
Customertypeid: customer type ID;
Customerdesc: Customer description

④ MERs: Customer table
Field:
Customerid: Customer ID;
CompanyName: company name;
Contactname: customer name;
Contacttitle: Customer title;
Address: contact address;
City: City;
Region: Region;
Postalcode: Zip code;
Country: Country
Phone: phone number;
Fax: Fax

⑤ Employees: employee table
Field:
Employeeid: employee code;
Lastname + firstname: employee name;
Title: title;
Titleofcourtesy: title;
Birthdate: date of birth;
Hiredate: employment date;
Address: home address;
City: City;
Region: Region;
Postalcode: Zip code;
Country: for national use;
Homephone: homephone;
Extension: extension;
Photo: mobile phone;
Notes: photo;
Reportsto: superior;
Photopath: Photo

⑥ Employeeterritories: employee Department table
Field:
Employee ID: employee ID;
Territoryid: department code

7. Order details: Order List
Field:
Orderid: Order Number;
Productid: product number;
Unitprice: unit price;
Quantity: quantity of orders;
Discount: discount

Orders orders: Order table
Field:
Orderid: Order Number;
Customerid: Customer ID;
Employee ID: employee ID;
Orderdate: The order date;
Requireddate: the expected date of arrival;
Shippeddate: date of delivery;
Shipvia: freight forwarder;
Freight: freight;
Shipname: the name of the owner;
Shipaddress: owner address
Shipcity: the city where the cargo owner is located;
Shipregion: the region where the cargo owner is located;
Shippostalcode: the owner's zip code;
Shipcountry: country of the cargo owner

Products: Product table
Field:
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 region: Region table
Field:
Regionid: Region ID;
Regiondescription: Region description

Shippers
Field:
Shipperid: Shipping provider ID;
CompanyName: company name;
Phone: contact number

Supplier suppliers: Supplier table
Field:
Shipperid: Supplier ID;
CompanyName: Supplier name;
Phone number

Regionterritories: Region table
Field:
Territoryid: Region ID;
Territorydescription: Region description;
Regionid: Region ID