Field Name | Type and Size |
---|---|
CustomerID | int NOT NULL |
Title | nvarchar(8) NULL |
FirstName | Name NOT NULL |
MiddleName | Name NULL |
LastName | Name NOT NULL |
Suffix | nvarchar(10) NULL |
Phone | Phone NULL |
EmailAddress | nvarchar(50) NULL |
EmailPromotion | int NOT NULL |
AddressType | Name NOT NULL |
AddressLine1 | nvarchar(60) NOT NULL |
AddressLine2 | nvarchar(60) NULL |
City | nvarchar(30) NOT NULL |
StateProvinceName | Name NOT NULL |
PostalCode | nvarchar(15) NOT NULL |
CountryRegionName | Name NOT NULL |
Demographics | xml NULL |