Physical name  Suppliers   
Logical nameSuppliers
Attributes12
Description 

PKPhysical nameDatatypeFK Ref.
SupplierIDINT 
 CompanyNameNVARCHAR (40) 
 ContactNameNVARCHAR (30) 
 ContactTitleNVARCHAR (30) 
 AddressNVARCHAR (60) 
 CityNVARCHAR (15) 
 RegionNVARCHAR (15) 
 PostalCodeNVARCHAR (10) 
 CountryNVARCHAR (15) 
 PhoneNVARCHAR (24) 
 FaxNVARCHAR (24) 
 HomePageNTEXT 

Indexes
CompanyName CompanyNameASC
PostalCode PostalCodeASC
xPostalCodeCity PostalCodeASC
CityASC
xpkSupplierIDUNIQUE  SupplierIDASC

ReferencesReferenced by
  Product [FK_Products_Suppliers]