zooqini_checkin_dev contains 246 columns - click on heading to sort:

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