.

Generated using SQL Data Dictionary demo version.

	Column	Data Type	Identity	Nullable	Default
PK	VendorId	int	X
UK	VendorName	nvarchar(50)
	Street	nvarchar(50)		X
	City	nvarchar(50)		X
	Region	nvarchar(50)		X
	Country	nvarchar(50)		X
	PostalCode	nvarchar(50)		X
	Telephone	nvarchar(50)		X
UK , FK	PortalId	int		X
	Fax	nvarchar(50)		X
	Email	nvarchar(50)		X
	Website	nvarchar(100)		X
	ClickThroughs	int			0
	Views	int			0
	CreatedByUser	nvarchar(100)		X
	CreatedDate	datetime		X
	LogoFile	nvarchar(100)		X
	KeyWords	ntext		X
	Unit	nvarchar(50)		X
	Authorized	bit			1
	FirstName	nvarchar(50)		X
	LastName	nvarchar(50)		X
	Cell	varchar(50)		X