Northwind
| Table Name: | Customers |
| Primary Keys: | CustomerID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| CustomerID | nchar (5) | None | No |
| CompanyName | nvarchar (40) | None | No |
| ContactName | nvarchar (30) | None | Yes |
| ContactTitle | nvarchar (30) | None | Yes |
| Address | nvarchar (60) | None | Yes |
| City | nvarchar (15) | None | Yes |
| Region | nvarchar (15) | None | Yes |
| PostalCode | nvarchar (10) | None | Yes |
| Country | nvarchar (15) | None | Yes |
| Phone | nvarchar (24) | None | Yes |
| Fax | nvarchar (24) | None | Yes |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Customers | Yes | Yes | CustomerID |
| City | No | No | City |
| CompanyName | No | No | CompanyName |
| PostalCode | No | No | PostalCode |
| Region | No | No | Region |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_CustomerCustomerDemo_Customers | CustomerCustomerDemo | CustomerID |
| FK_Orders_Customers | Orders | CustomerID |