ceospace
member_data
member_orders
members
pdf_cat
pdf_list
person_ass_survey
products
ceospace
ceoid int(255) unsigned NO PRI auto_increment
firstname text NO
lastname text NO
chbox1 varchar(2) NO
chbox2 varchar(2) NO
chbox3 varchar(2) NO
email text NO
member_data
id int(7) NO PRI
first_name varchar(255) NO
last_name varchar(255) NO
phone_number varchar(255) NO
email varchar(255) NO
address varchar(255) NO
city varchar(255) NO
state varchar(2) NO
zip varchar(5) NO
signup date NO
referral int(7) NO
referral_stat int(1) NO 0
member_orders
order varchar(255) NO PRI
prod_1 int(3) NO
prod_2 int(3) NO
prod_3 int(3) NO
price varchar(255) NO
user_id int(7) NO
first_name varchar(255) NO
last_name varchar(255) NO
credit_type varchar(255) NO
credit_num varchar(255) NO
exp varchar(255) NO
bill_add varchar(255) NO
bill_city varchar(255) NO
bill_state varchar(255) NO
bill_zip varchar(255) NO
ship_add varchar(255) NO
ship_city varchar(255) NO
ship_state varchar(255) NO
ship_zip varchar(255) NO
phone varchar(255) NO
email varchar(255) NO
processed int(1) NO 0
members
id int(7) NO PRI auto_increment
username varchar(255) NO
password varchar(255) NO
last_login datetime NO
newsletter varchar(3) NO no
person_ass varchar(3) NO no
pdf_cat
id int(3) NO PRI auto_increment
category varchar(255) NO
pdf_list
id int(4) NO PRI auto_increment
filetitle varchar(255) NO UNI
filename varchar(255) NO
filedesc varchar(255) NO
filecat int(4) NO
person_ass_survey
id int(11) NO PRI auto_increment
survey_username varchar(255) NO
survey_address varchar(255) NO
survey_city varchar(255) NO
survey_state varchar(2) NO
survey_zip int(5) NO
survey_wk_phn varchar(12) NO
survey_mo_phn varchar(12) NO
survey_hm_phn varchar(12) NO
survey_email varchar(255) NO
gender varchar(7) NO
mm int(2) NO
dd int(2) NO
yyyy int(4) NO
height_feet int(1) NO
height_inch int(2) NO
weight int(3) NO
gym_member varchar(3) NO
fit_lvl varchar(10) NO
weight_trn int(1) NO
cardio int(1) NO
yoga int(1) NO
pilates int(1) NO
comfort int(1) NO
know int(1) NO
motivate int(1) NO
useWBV varchar(3) NO
injury varchar(3) NO
pregnant varchar(3) NO
pacemaker varchar(3) NO
trainer_id int(7) NO
user_id int(7) NO
products
id int(3) NO PRI auto_increment
prod_name varchar(255) NO
prod_price varchar(255) NO
prod_desc mediumtext NO
quantity tinyint(3) unsigned NO 1