zooqini_checkin_dev contains 246 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
account_activation_request	key	varchar	64
account_activation_request	timestamp	timestamp	19			CURRENT_TIMESTAMP
account_activation_request	type	enum	6			web
account_activation_request	uid	int	10
account_activation_request	valid	enum	2			Y
activities	aid	int	10		√
activities	eid	int	10
activities	end_date	date	10
activities	end_time	datetime	19
activities	start_date	date	10
activities	start_time	datetime	19
activity_members	aid	int	10
activity_members	checkin_time	timestamp	19			CURRENT_TIMESTAMP
activity_members	uid	int	10
activity_types	aid	int	10		√
activity_types	aname	varchar	64
addresses	address1	varchar	255
addresses	address2	varchar	255	√		null
addresses	aid	int	10		√
addresses	city	varchar	255
addresses	country	varchar	255	√		null
addresses	latitude	float	10,6
addresses	longitude	float	10,6
addresses	state	varchar	2
addresses	zipcode	varchar	255
authority	auth	enum	6
authority	id	int	10
authority	type	enum	8
authority	uid	int	10
barcode	code	int	10
barcode	id	int	10
barcode	type	enum	9
barcode	uid	int	10
business	active	enum	2			Y
business	address_id	int	10
business	bid	int	10		√
business	bname	text	65535
business	description	text	65535
business	interest	varchar	255
business	logo	int	10
business	owner	int	10
business	phone	varchar	14
business	timestamp	timestamp	19			CURRENT_TIMESTAMP
business_images	bid	int	10
business_images	image	int	10
business_payment	bid	int	10
business_payment	info	varchar	255
business_urls	bid	int	10
business_urls	type	enum	8			url
business_urls	url	text	65535
calendar_event	c_e_id	int	10		√
calendar_event	eid	int	10
calendar_event	event_date	date	10
event_frequency	d_week	varchar	255
event_frequency	eid	int	10
event_frequency	o_type	enum	5
event_images	eid	int	10
event_images	image	int	10
event_members	c_e_id	int	10
event_members	checkin_time	datetime	19	√		null
event_members	checkout_time	datetime	19	√		null
event_members	idx	int	10		√
event_members	uid	int	10
events	active	enum	2			N
events	address_id	int	10
events	days	varchar	255	√		null
events	detail	text	65535
events	eid	int	10		√
events	ename	varchar	255
events	end_date	date	10	√		null
events	end_time	time	8	√		null
events	faq	text	65535	√		null
events	frequency	enum	14
events	gid	int	10
events	logo	int	10
events	start_date	date	10
events	start_time	time	8			00:00:00
fr_group_type	fid	int	10
fr_group_type	fr_g_type_id	int	10		√
fr_group_type	name	varchar	255
fr_groups	fid	int	10
fr_groups	fr_g_type	int	10
fr_groups	frgid	int	10
fr_groups	name	varchar	255
franchises	address_id	int	10
franchises	fid	int	10		√
franchises	fname	text	65535
franchises	logo	int	10
franchises	owner	int	10
franchises	phone	varchar	14
franchises	timestamp	timestamp	19			CURRENT_TIMESTAMP
franchises	url	text	65535
group_images	gid	int	10
group_images	image	int	10
group_mapping	gid	int	10
group_mapping	id	int	10
group_mapping	type	enum	6
group_members	gid	int	10
group_members	join_date	datetime	19
group_members	note	varchar	255	√		null
group_members	paid	enum	2			N
group_members	timestamp	timestamp	19			CURRENT_TIMESTAMP
group_members	type	enum	6
group_members	uid	int	10
group_members	waiver_timestamp	datetime	19
group_required	gid	int	10
group_required	required	text	65535
group_types	bid	int	10
group_types	gt_id	int	10		√
group_types	type_name	varchar	255
group_waiver	content	text	65535
group_waiver	gid	int	10
group_waiver	timestamp	timestamp	19			CURRENT_TIMESTAMP
group_waiver	type	enum	7
group_waiver	userid	int	10
groups	active	enum	2			Y
groups	address_id	int	10
groups	address_info	text	65535
groups	address_type	enum	9			group
groups	contact	varchar	255
groups	contact_email	varchar	255
groups	cost	decimal	10
groups	dead_line	varchar	10
groups	description	text	65535
groups	gid	int	10		√
groups	gname	varchar	255
groups	group_type	varchar	255
groups	interest	varchar	255
groups	logo	int	10
groups	max_member	int	10
groups	owner	int	10
groups	subscription	enum	11			Open
groups	timestamp	timestamp	19			CURRENT_TIMESTAMP
images	filename	varchar	255
images	mid	int	10		√
images	uid	int	10
images	upload_time	timestamp	19			CURRENT_TIMESTAMP
logs	prams	longtext	2147483647
milestones	checkinsrequired	smallint unsigned	5			0
milestones	groupid	int unsigned	10
milestones	id	int unsigned	10		√
milestones	name	varchar	255
milestones_rewards	id	int unsigned	10		√
milestones_rewards	milestoneid	int unsigned	10
milestones_rewards	rewardid	int unsigned	10
offline_checkin	bid	int	10
offline_checkin	date	varchar	10
offline_checkin	json	longtext	2147483647
offline_checkin	timestamp	timestamp	19			CURRENT_TIMESTAMP
pd_reset_request	email	text	65535
pd_reset_request	key	varchar	255
pd_reset_request	timestamp	timestamp	19			CURRENT_TIMESTAMP
pd_reset_request	userid	int	10
Points	description	varchar	200	√		null
Points	location	point	0
Points	name	varchar	20
recess_tools_classes	docComment	text	65535	√		null
recess_tools_classes	file	text	65535	√		null
recess_tools_classes	id	int	10		√
recess_tools_classes	name	varchar	255	√		null
recess_tools_classes	packageId	int	10	√		null
recess_tools_classes	parentId	int	10	√		null
recess_tools_packages	id	int	10		√
recess_tools_packages	name	varchar	255	√		null
recess_tools_packages	parentId	int	10	√		null
rest_test	id	int	10		√
rest_test	name	varchar	255	√		null
rewards	groupid	int unsigned	10
rewards	id	int unsigned	10		√
rewards	name	varchar	255
signup	email	varchar	255
signup	timestamp	timestamp	19			CURRENT_TIMESTAMP
sponser_logo	id	int	10
sponser_logo	idx	int	10		√
sponser_logo	mid	int	10
sponser_logo	type	enum	9
sponser_logo	url	varchar	255
store_mapping	bid	int	10
store_mapping	id	int	10
store_mapping	type	enum	9
training_types	tid	int	10		√
training_types	tname	varchar	65
user_emergency_contacts	name	varchar	255
user_emergency_contacts	phone	varchar	14
user_emergency_contacts	relationship	varchar	64
user_emergency_contacts	timestamp	timestamp	19			CURRENT_TIMESTAMP
user_emergency_contacts	userid	int	10
user_follow	id	int	10
user_follow	type	enum	6
user_follow	uid	int	10
user_images	image	int	10
user_images	uid	int	10
user_journals	aid	int	10
user_journals	avg_hb	int	10
user_journals	checkin	int	10
user_journals	date	date	10
user_journals	distance	int	10
user_journals	distance_type	enum	9
user_journals	end_time	time	8
user_journals	jid	int	10		√
user_journals	note	text	65535
user_journals	start_time	time	8
user_journals	timestamp	timestamp	19			CURRENT_TIMESTAMP
user_journals	userid	int	10
user_profile	dob	varchar	10
user_profile	interest	varchar	255
user_profile	n_email	enum	2			0
user_profile	n_phone	enum	2			0
user_profile	n_sms	enum	2			0
user_profile	phone	varchar	14
user_profile	profile	text	65535
user_profile	range	enum	5			all
user_profile	size	varchar	6
user_profile	userid	int	10
users	18year	enum	2
users	activited	enum	2			N
users	activited_timestamp	datetime	19
users	address_id	int	10
users	agree	enum	2
users	email	varchar	255
users	email_md5	varchar	32
users	first_name	varchar	255
users	last_name	varchar	255
users	logo	int	10
users	passwd_md5	varchar	32
users	sex	enum	2
users	timestamp	timestamp	19			CURRENT_TIMESTAMP
users	userid	int	10		√
users	zip	int	10
weather_cache	timestamp	timestamp	19			CURRENT_TIMESTAMP
weather_cache	xml	text	65535
weather_cache	zipcode	int	10
zip_code	area_code	varchar	3	√		null
zip_code	city	varchar	50	√		null
zip_code	county	varchar	50	√		null
zip_code	id	int unsigned	10		√
zip_code	lat	float	12
zip_code	location	point	0
zip_code	lon	float	12
zip_code	state_name	varchar	50	√		null
zip_code	state_prefix	varchar	2	√		null
zip_code	time_zone	varchar	50	√		null
zip_code	zip_code	varchar	5
zipcodes	city	varchar	64	√		null
zipcodes	state	char	2	√		null
zipcodes	zip	char	5