pubs2 - table columns

All table columns

parent	column	definition
au_pix	au_id	char(11)
au_pix	pic	image
au_pix	format_type	char(11)
au_pix	bytesize	int
au_pix	pixwidth_hor	char(14)
au_pix	pixwidth_vert	char(14)
authors	au_id	id
authors	au_lname	varchar(40)
authors	au_fname	varchar(20)
authors	phone	char(12) = "UNKNOWN"
authors	address	varchar(40)
authors	city	varchar(20)
authors	state	char(2)
authors	country	varchar(12)
authors	postalcode	char(10)
blurbs	au_id	id
blurbs	copy	text
discounts	discounttype	varchar(40)
discounts	stor_id	char(4)
discounts	lowqty	smallint
discounts	highqty	smallint
discounts	discount	float
publishers	pub_id	char(4)
publishers	pub_name	varchar(40)
publishers	city	varchar(20)
publishers	state	char(2)
roysched	title_id	tid
roysched	lorange	int
roysched	hirange	int
roysched	royalty	int
sales	stor_id	char(4)
sales	ord_num	varchar(20)
sales	date	datetime
salesdetail	stor_id	char(4)
salesdetail	ord_num	varchar(20)
salesdetail	title_id	tid
salesdetail	qty	smallint
salesdetail	discount	float
stores	stor_id	char(4)
stores	stor_name	varchar(40)
stores	stor_address	varchar(40)
stores	city	varchar(20)
stores	state	char(2)
stores	country	varchar(12)
stores	postalcode	char(10)
stores	payterms	varchar(12)
titleauthor	au_id	id
titleauthor	title_id	tid
titleauthor	au_ord	tinyint
titleauthor	royaltyper	int
titles	title_id	tid
titles	title	varchar(80)
titles	type	char(12) = "UNDECIDED"
titles	pub_id	char(4)
titles	price	money
titles	advance	money
titles	total_sales	int
titles	notes	varchar(200)
titles	pubdate	datetime = getdate()
titles	contract	bit
sysquerymetrics	uid	int
sysquerymetrics	gid	int
sysquerymetrics	hashkey	int
sysquerymetrics	id	int
sysquerymetrics	sequence	smallint
sysquerymetrics	exec_min	int
sysquerymetrics	exec_max	int
sysquerymetrics	exec_avg	int
sysquerymetrics	elap_min	int
sysquerymetrics	elap_max	int
sysquerymetrics	elap_avg	int
sysquerymetrics	lio_min	int
sysquerymetrics	lio_max	int
sysquerymetrics	lio_avg	int
sysquerymetrics	pio_min	int
sysquerymetrics	pio_max	int
sysquerymetrics	pio_avg	int
sysquerymetrics	cnt	int
sysquerymetrics	abort_cnt	int
sysquerymetrics	qtext	varchar(255)
titleview	title	varchar(80)
titleview	au_ord	tinyint
titleview	au_lname	varchar(40)
titleview	price	money
titleview	total_sales	int
titleview	pub_id	char(4)