Code: Select all
business_id int(11) Yes NULL auto_increment Change Drop Primary Index Unique Fulltext
name varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
owner varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
contact_name varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
contact_title varchar(25) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
address1 varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
address2 varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
city varchar(25) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
state varchar(2) latin1_swedish_ci Yes CA Change Drop Primary Index Unique Fulltext
zip int(9) Yes Change Drop Primary Index Unique Fulltext
phone int(10) Yes Change Drop Primary Index Unique Fulltext
alt_phone int(10) Yes Change Drop Primary Index Unique Fulltext
fax int(10) Yes Change Drop Primary Index Unique Fulltext
email varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
website varchar(100) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
description_short tinytext latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
description text latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
season varchar(30) latin1_swedish_ci Yes NULL Change Drop Primary Index Unique Fulltext
hours varchar(100) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
directions varchar(255) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
created varchar(15) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
modified varchar(15) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
suspended varchar(15) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
county varchar(10) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
corridor_id tinyint(4) Yes Change Drop Primary Index Unique Fulltext
type varchar(50) latin1_swedish_ci Yes Change Drop Primary Index Unique Fulltext
interests