DBDemos - table columns

All table columns

parent	column	definition
animals	NAME	Char NULL
animals	SIZE	Int NULL
animals	WEIGHT	Int NULL
animals	AREA	Char NULL
animals	BMP	Image NULL
biolife	Species_No	Float NOT NULL
biolife	Category	Char NULL
biolife	Common_Name	Char NULL
biolife	Species_Name	Char NULL
biolife	Length__cm_	Float NULL
biolife	Length_In	Float NULL
biolife	Notes	NText NULL
biolife	Graphic	Image NULL
clients	LAST_NAME	Char NULL
clients	FIRST_NAME	Char NULL
clients	ACCT_NBR	Float NULL
clients	ADDRESS_1	Char NULL
clients	CITY	Char NULL
clients	STATE	Char NULL
clients	ZIP	Char NULL
clients	TELEPHONE	Char NULL
clients	DATE_OPEN	SmallDateTime NULL
clients	SS_NUMBER	Float NULL
clients	PICTURE	Char NULL
clients	BIRTH_DATE	SmallDateTime NULL
clients	RISK_LEVEL	Char NULL
clients	OCCUPATION	Char NULL
clients	OBJECTIVES	Char NULL
clients	INTERESTS	VarChar NULL
clients	IMAGE	Image NULL
country	Name	Char NOT NULL
country	Capital	Char NULL
country	Continent	Char NULL
country	Area	Float NULL
country	Population	Float NULL
custoly	CustNo	Int NOT NULL
custoly	Last_Name	Char NULL
custoly	First_Name	Char NULL
custoly	VIP_Status	Char NULL
custoly	Address1	Char NULL
custoly	Address2	Char NULL
custoly	City	Char NULL
custoly	State_Prov	Char NULL
custoly	Post_Code	Char NULL
custoly	Country	Char NULL
custoly	Phone	Char NULL
custoly	Fax	Char NULL
custoly	EMail	Char NULL
custoly	Remarks	NText NULL
customer	CustNo	Float NOT NULL
customer	Company	Char NULL
customer	Addr1	Char NULL
customer	Addr2	Char NULL
customer	City	Char NULL
customer	State	Char NULL
customer	Zip	Char NULL
customer	Country	Char NULL
customer	Phone	Char NULL
customer	FAX	Char NULL
customer	TaxRate	Float NULL
customer	Contact	Char NULL
customer	LastInvoiceDate	DateTime NULL
employee	EmpNo	Int NOT NULL
employee	LastName	Char NULL
employee	FirstName	Char NULL
employee	PhoneExt	Char NULL
employee	HireDate	DateTime NULL
employee	Salary	Float NULL
events	EventNo	Int NOT NULL
events	VenueNo	Int NULL
events	Event_Name	Char NULL
events	Event_Date	SmallDateTime NULL
events	Event_Time	DateTime NULL
events	Event_Description	NText NULL
events	Ticket_price	Money NULL
events	Event_Photo	Image NULL
holdings	ACCT_NBR	Float NULL
holdings	SYMBOL	Char NULL
holdings	SHARES	Float NULL
holdings	PUR_PRICE	Float NULL
holdings	PUR_DATE	SmallDateTime NULL
industry	IND_CODE	Int NULL
industry	IND_NAME	Char NULL
industry	LONG_NAME	Char NULL
items	OrderNo	Float NOT NULL
items	ItemNo	Float NOT NULL
items	PartNo	Float NULL
items	Qty	Int NULL
items	Discount	Float NULL
master	SYMBOL	Char NULL
master	CO_NAME	Char NULL
master	EXCHANGE	Char NULL
master	CUR_PRICE	Float NULL
master	YRL_HIGH	Float NULL
master	YRL_LOW	Float NULL
master	P_E_RATIO	Float NULL
master	BETA	Float NULL
master	PROJ_GRTH	Float NULL
master	INDUSTRY	Int NULL
master	PRICE_CHG	Int NULL
master	SAFETY	Int NULL
master	RATING	Char NULL
master	RANK	Float NULL
master	OUTLOOK	Int NULL
master	RCMNDATION	Char NULL
master	RISK	Char NULL
nextcust	NewCust	Float NULL
nextitem	NewKey	Float NULL
nextord	NewKey	Float NULL
orders	OrderNo	Float NOT NULL
orders	CustNo	Float NOT NULL
orders	SaleDate	DateTime NULL
orders	ShipDate	DateTime NULL
orders	EmpNo	Int NOT NULL
orders	ShipToContact	Char NULL
orders	ShipToAddr1	Char NULL
orders	ShipToAddr2	Char NULL
orders	ShipToCity	Char NULL
orders	ShipToState	Char NULL
orders	ShipToZip	Char NULL
orders	ShipToCountry	Char NULL
orders	ShipToPhone	Char NULL
orders	ShipVIA	Char NULL
orders	PO	Char NULL
orders	Terms	Char NULL
orders	PaymentMethod	Char NULL
orders	ItemsTotal	Money NULL
orders	TaxRate	Float NULL
orders	Freight	Money NULL
orders	AmountPaid	Money NULL
parts	PartNo	Float NOT NULL
parts	VendorNo	Float NULL
parts	Description	Char NULL
parts	OnHand	Float NULL
parts	OnOrder	Float NULL
parts	Cost	Money NULL
parts	ListPrice	Money NULL
reservat	ResNo	Int NOT NULL
reservat	EventNo	Int NULL
reservat	CustNo	Int NULL
reservat	NumTickets	Int NULL
reservat	Amt_Paid	Money NULL
reservat	Pay_Method	Char NULL
reservat	Card_No	Char NULL
reservat	Card_Exp	SmallDateTime NULL
reservat	Pay_Notes	NText NULL
reservat	Purge_Date	SmallDateTime NULL
reservat	Paid	Bit NULL
vendors	VendorNo	Float NOT NULL
vendors	VendorName	Char NULL
vendors	Address1	Char NULL
vendors	Address2	Char NULL
vendors	City	Char NULL
vendors	State	Char NULL
vendors	Zip	Char NULL
vendors	Country	Char NULL
vendors	Phone	Char NULL
vendors	FAX	Char NULL
vendors	Preferred	Bit NULL
venues	VenueNo	Int NOT NULL
venues	Venue	Char NULL
venues	Capacity	Int NULL
venues	Venue_Map	Image NULL
venues	Remarks	NText NULL