marinedb contains 1937 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
abalone_count_sizes	abalone_nn_code	varchar	11
abalone_count_sizes	abalone_size_bin	varchar	3
abalone_count_sizes	abalone_size_count	int unsigned	10
abalone_count_sizes	count_qualifier_code	varchar	6
abalone_count_sizes	create_date	date	10
abalone_count_sizes	group_code	varchar	8
abalone_count_sizes	method_code	varchar	6
abalone_count_sizes	modify_date	timestamp	19			current_timestamp()
abalone_count_sizes	plot_code	varchar	6
abalone_count_sizes	site_code	char	6
abalone_count_sizes	size_qualifier_code	varchar	6
abalone_count_sizes	species_code	char	6
abalone_count_sizes	survey_date	date	10
abalone_count_sizes	target_assemblage	varchar	20
abalone_count_sizes_active	abalone_nn_code	varchar	11
abalone_count_sizes_active	abalone_size_bin	varchar	3
abalone_count_sizes_active	abalone_size_count	int unsigned	10
abalone_count_sizes_active	count_qualifier_code	varchar	6
abalone_count_sizes_active	create_date	date	10
abalone_count_sizes_active	group_code	varchar	8
abalone_count_sizes_active	method_code	varchar	6
abalone_count_sizes_active	modify_date	timestamp	19			current_timestamp()
abalone_count_sizes_active	plot_code	varchar	6
abalone_count_sizes_active	site_code	char	6
abalone_count_sizes_active	size_qualifier_code	varchar	6
abalone_count_sizes_active	species_code	char	6
abalone_count_sizes_active	survey_date	date	10
abalone_count_sizes_active	target_assemblage	varchar	20
abalone_empty_shells	abalone_shell_code	varchar	11
abalone_empty_shells	abalone_shell_count	int unsigned	10
abalone_empty_shells	abalone_size_bin	varchar	3
abalone_empty_shells	count_qualifier_code	varchar	6
abalone_empty_shells	create_date	date	10
abalone_empty_shells	group_code	varchar	8
abalone_empty_shells	method_code	varchar	6
abalone_empty_shells	modify_date	timestamp	19			current_timestamp()
abalone_empty_shells	plot_code	varchar	6
abalone_empty_shells	site_code	char	6
abalone_empty_shells	size_qualifier_code	varchar	6
abalone_empty_shells	species_code	char	6
abalone_empty_shells	survey_date	date	10
abalone_empty_shells	survey_type_code	varchar	30
abalone_empty_shells	target_assemblage	varchar	20
abalone_empty_shells_active	abalone_shell_code	varchar	11
abalone_empty_shells_active	abalone_shell_count	int unsigned	10
abalone_empty_shells_active	abalone_size_bin	varchar	3
abalone_empty_shells_active	count_qualifier_code	varchar	6
abalone_empty_shells_active	create_date	date	10
abalone_empty_shells_active	group_code	varchar	8
abalone_empty_shells_active	method_code	varchar	6
abalone_empty_shells_active	modify_date	timestamp	19			current_timestamp()
abalone_empty_shells_active	plot_code	varchar	6
abalone_empty_shells_active	site_code	char	6
abalone_empty_shells_active	size_qualifier_code	varchar	6
abalone_empty_shells_active	species_code	char	6
abalone_empty_shells_active	survey_date	date	10
abalone_empty_shells_active	survey_type_code	varchar	30
abalone_empty_shells_active	target_assemblage	varchar	20
abalone_group_site_species	active_status	enum	8
abalone_group_site_species	create_date	date	10
abalone_group_site_species	group_code	varchar	8
abalone_group_site_species	modify_date	timestamp	19			current_timestamp()
abalone_group_site_species	site_code	char	6
abalone_group_site_species	species_code	char	6
abalone_group_site_species_active	group_code	varchar	8
abalone_group_site_species_active	site_code	char	6
abalone_group_site_species_active	species_code	char	6
abalone_habitat_sites	comments	varchar	100	√		null
abalone_habitat_sites	create_date	date	10
abalone_habitat_sites	established_date	date	10
abalone_habitat_sites	site_code	char	6
abalone_nn_codes	abalone_nn_code	varchar	11
abalone_nn_codes	abalone_nn_description	varchar	150
abalone_nn_codes	create_date	date	10
abalone_notes	abalone_note	text	65535	√		null
abalone_notes	create_date	date	10
abalone_notes	group_code	varchar	8
abalone_notes	modify_date	timestamp	19			current_timestamp()
abalone_notes	plot_code	varchar	6
abalone_notes	site_code	char	6
abalone_notes	survey_date	date	10
abalone_notes	target_assemblage	varchar	20
abalone_notes_active	abalone_note	text	65535	√		null
abalone_notes_active	create_date	date	10
abalone_notes_active	group_code	varchar	8
abalone_notes_active	modify_date	timestamp	19			current_timestamp()
abalone_notes_active	plot_code	varchar	6
abalone_notes_active	site_code	char	6
abalone_notes_active	survey_date	date	10
abalone_notes_active	target_assemblage	varchar	20
abalone_plot_info	active_status	enum	8
abalone_plot_info	comments	varchar	100	√		null
abalone_plot_info	create_date	date	10
abalone_plot_info	end_date	date	10	√		null
abalone_plot_info	established_date	date	10
abalone_plot_info	modify_date	timestamp	19			current_timestamp()
abalone_plot_info	plot_code	varchar	6
abalone_plot_info	site_code	char	6
abalone_plot_info	target_assemblage	varchar	20
abalone_plot_info_active	plot_code	varchar	6
abalone_plot_info_active	site_code	char	6
abalone_plot_info_active	target_assemblage	varchar	20
abalone_shell_codes	abalone_shell_code	varchar	11
abalone_shell_codes	abalone_shell_description	varchar	150
abalone_shell_codes	create_date	date	10
abalone_size_bins	abalone_bin_max	varchar	5
abalone_size_bins	abalone_bin_min	varchar	5
abalone_size_bins	abalone_size_bin	varchar	3
abalone_size_bins	abalone_size_bin_description	varchar	100
abalone_size_bins	abalone_sort_order	int	10
abalone_size_bins	create_date	date	10
abhab_habitat_codes	abalone_habitat_code	varchar	2
abhab_habitat_codes	abalone_habitat_description	varchar	150
abhab_habitat_codes	create_date	date	10
abhab_not_sampled	create_date	date	10
abhab_not_sampled	group_code	varchar	8
abhab_not_sampled	modify_date	timestamp	19			current_timestamp()
abhab_not_sampled	segment_id	varchar	8
abhab_not_sampled	site_code	char	6
abhab_not_sampled	survey_date	date	10
abhab_not_sampled	survey_type_code	varchar	30
abhab_not_sampled	target_assemblage	varchar	20
abhab_not_sampled_active	create_date	date	10
abhab_not_sampled_active	group_code	varchar	8
abhab_not_sampled_active	modify_date	timestamp	19			current_timestamp()
abhab_not_sampled_active	segment_id	varchar	8
abhab_not_sampled_active	site_code	char	6
abhab_not_sampled_active	survey_date	date	10
abhab_not_sampled_active	survey_type_code	varchar	30
abhab_not_sampled_active	target_assemblage	varchar	20
abhab_notes	abhab_note	text	65535	√		null
abhab_notes	create_date	date	10
abhab_notes	group_code	varchar	8
abhab_notes	modify_date	timestamp	19			current_timestamp()
abhab_notes	plot_code	varchar	6
abhab_notes	site_code	char	6
abhab_notes	survey_date	date	10
abhab_notes	target_assemblage	varchar	20
abhab_notes_active	abhab_note	text	65535	√		null
abhab_notes_active	create_date	date	10
abhab_notes_active	group_code	varchar	8
abhab_notes_active	modify_date	timestamp	19			current_timestamp()
abhab_notes_active	plot_code	varchar	6
abhab_notes_active	site_code	char	6
abhab_notes_active	survey_date	date	10
abhab_notes_active	target_assemblage	varchar	20
abhab_plot_habitat_info	adjusted_area_m2	int	10
abhab_plot_habitat_info	area_m2	int	10
abhab_plot_habitat_info	create_date	date	10
abhab_plot_habitat_info	end_time	time	8
abhab_plot_habitat_info	group_code	varchar	8
abhab_plot_habitat_info	modify_date	timestamp	19			current_timestamp()
abhab_plot_habitat_info	mussel_encroachment	varchar	3
abhab_plot_habitat_info	percent_abs_removable	varchar	3			NA
abhab_plot_habitat_info	percent_good	int	10
abhab_plot_habitat_info	percent_good_nobio	varchar	3			NA
abhab_plot_habitat_info	percent_moderate	int	10
abhab_plot_habitat_info	percent_moderate_nobio	varchar	3			NA
abhab_plot_habitat_info	percent_poor	int	10
abhab_plot_habitat_info	percent_poor_nobio	varchar	3			NA
abhab_plot_habitat_info	plot_code	varchar	6
abhab_plot_habitat_info	site_code	char	6
abhab_plot_habitat_info	start_time	time	8
abhab_plot_habitat_info	survey_date	date	10
abhab_plot_habitat_info	target_assemblage	varchar	8
abhab_plot_habitat_info_active	adjusted_area_m2	int	10
abhab_plot_habitat_info_active	area_m2	int	10
abhab_plot_habitat_info_active	create_date	date	10
abhab_plot_habitat_info_active	end_time	time	8
abhab_plot_habitat_info_active	group_code	varchar	8
abhab_plot_habitat_info_active	modify_date	timestamp	19			current_timestamp()
abhab_plot_habitat_info_active	mussel_encroachment	varchar	3
abhab_plot_habitat_info_active	percent_abs_removable	varchar	3			NA
abhab_plot_habitat_info_active	percent_good	int	10
abhab_plot_habitat_info_active	percent_good_nobio	varchar	3			NA
abhab_plot_habitat_info_active	percent_moderate	int	10
abhab_plot_habitat_info_active	percent_moderate_nobio	varchar	3			NA
abhab_plot_habitat_info_active	percent_poor	int	10
abhab_plot_habitat_info_active	percent_poor_nobio	varchar	3			NA
abhab_plot_habitat_info_active	plot_code	varchar	6
abhab_plot_habitat_info_active	site_code	char	6
abhab_plot_habitat_info_active	start_time	time	8
abhab_plot_habitat_info_active	survey_date	date	10
abhab_plot_habitat_info_active	target_assemblage	varchar	8
abhab_plot_physical_info	create_date	date	10
abhab_plot_physical_info	exposure	enum	8			ND
abhab_plot_physical_info	modify_date	timestamp	19			current_timestamp()
abhab_plot_physical_info	plot_code	varchar	6
abhab_plot_physical_info	relief	enum	8			ND
abhab_plot_physical_info	rock_type	varchar	20
abhab_plot_physical_info	sediment_influence	enum	8			ND
abhab_plot_physical_info	site_code	char	6
abhab_plot_physical_info	substrate_code	varchar	40
abhab_plot_physical_info	target_assemblage	varchar	8
abhab_plot_physical_info_active	create_date	date	10
abhab_plot_physical_info_active	exposure	enum	8			ND
abhab_plot_physical_info_active	modify_date	timestamp	19			current_timestamp()
abhab_plot_physical_info_active	plot_code	varchar	6
abhab_plot_physical_info_active	relief	enum	8			ND
abhab_plot_physical_info_active	rock_type	varchar	20
abhab_plot_physical_info_active	sediment_influence	enum	8			ND
abhab_plot_physical_info_active	site_code	char	6
abhab_plot_physical_info_active	substrate_code	varchar	40
abhab_plot_physical_info_active	target_assemblage	varchar	8
abhab_plots_count_sizes	abalone_habitat_code	varchar	2
abhab_plots_count_sizes	abalone_nn_code	varchar	11
abhab_plots_count_sizes	abalone_size_bin	varchar	3
abhab_plots_count_sizes	abalone_size_count	int unsigned	10
abhab_plots_count_sizes	count_qualifier_code	varchar	6
abhab_plots_count_sizes	create_date	date	10
abhab_plots_count_sizes	group_code	varchar	8
abhab_plots_count_sizes	method_code	varchar	6
abhab_plots_count_sizes	modify_date	timestamp	19			current_timestamp()
abhab_plots_count_sizes	plot_code	varchar	6
abhab_plots_count_sizes	site_code	char	6
abhab_plots_count_sizes	size_qualifier_code	varchar	6
abhab_plots_count_sizes	species_code	char	6
abhab_plots_count_sizes	survey_date	date	10
abhab_plots_count_sizes	target_assemblage	varchar	20
abhab_plots_count_sizes_active	abalone_habitat_code	varchar	2
abhab_plots_count_sizes_active	abalone_nn_code	varchar	11
abhab_plots_count_sizes_active	abalone_size_bin	varchar	3
abhab_plots_count_sizes_active	abalone_size_count	int unsigned	10
abhab_plots_count_sizes_active	count_qualifier_code	varchar	6
abhab_plots_count_sizes_active	create_date	date	10
abhab_plots_count_sizes_active	group_code	varchar	8
abhab_plots_count_sizes_active	method_code	varchar	6
abhab_plots_count_sizes_active	modify_date	timestamp	19			current_timestamp()
abhab_plots_count_sizes_active	plot_code	varchar	6
abhab_plots_count_sizes_active	site_code	char	6
abhab_plots_count_sizes_active	size_qualifier_code	varchar	6
abhab_plots_count_sizes_active	species_code	char	6
abhab_plots_count_sizes_active	survey_date	date	10
abhab_plots_count_sizes_active	target_assemblage	varchar	20
abhab_plots_not_sampled	create_date	date	10
abhab_plots_not_sampled	group_code	varchar	8
abhab_plots_not_sampled	modify_date	timestamp	19			current_timestamp()
abhab_plots_not_sampled	quatraplot_code	varchar	6
abhab_plots_not_sampled	site_code	char	6
abhab_plots_not_sampled	survey_date	date	10
abhab_plots_not_sampled	survey_type_code	varchar	30
abhab_plots_not_sampled	target_assemblage	varchar	20
abhab_plots_not_sampled_active	create_date	date	10
abhab_plots_not_sampled_active	group_code	varchar	8
abhab_plots_not_sampled_active	modify_date	timestamp	19			current_timestamp()
abhab_plots_not_sampled_active	quatraplot_code	varchar	6
abhab_plots_not_sampled_active	site_code	char	6
abhab_plots_not_sampled_active	survey_date	date	10
abhab_plots_not_sampled_active	survey_type_code	varchar	30
abhab_plots_not_sampled_active	target_assemblage	varchar	20
abhab_plots_sampled	create_date	date	10
abhab_plots_sampled	group_code	varchar	8
abhab_plots_sampled	modify_date	timestamp	19			current_timestamp()
abhab_plots_sampled	quatraplot_code	varchar	6
abhab_plots_sampled	site_code	char	6
abhab_plots_sampled	survey_date	date	10
abhab_plots_sampled	survey_type_code	varchar	30
abhab_plots_sampled	target_assemblage	varchar	20
abhab_plots_sampled_active	create_date	date	10
abhab_plots_sampled_active	group_code	varchar	8
abhab_plots_sampled_active	modify_date	timestamp	19			current_timestamp()
abhab_plots_sampled_active	quatraplot_code	varchar	6
abhab_plots_sampled_active	site_code	char	6
abhab_plots_sampled_active	survey_date	date	10
abhab_plots_sampled_active	survey_type_code	varchar	30
abhab_plots_sampled_active	target_assemblage	varchar	20
abhab_rock_type_codes	create_date	date	10
abhab_rock_type_codes	rock_type_code	varchar	20
abhab_rock_type_codes	rock_type_description	varchar	150
abhab_sampled	create_date	date	10
abhab_sampled	group_code	varchar	8
abhab_sampled	modify_date	timestamp	19			current_timestamp()
abhab_sampled	segment_id	varchar	8
abhab_sampled	site_code	char	6
abhab_sampled	survey_date	date	10
abhab_sampled	survey_type_code	varchar	30
abhab_sampled	target_assemblage	varchar	20
abhab_sampled_active	create_date	date	10
abhab_sampled_active	group_code	varchar	8
abhab_sampled_active	modify_date	timestamp	19			current_timestamp()
abhab_sampled_active	segment_id	varchar	8
abhab_sampled_active	site_code	char	6
abhab_sampled_active	survey_date	date	10
abhab_sampled_active	survey_type_code	varchar	30
abhab_sampled_active	target_assemblage	varchar	20
abhab_segment_boundaries	create_date	date	10
abhab_segment_boundaries	datum	enum	6			WGS84
abhab_segment_boundaries	gps_boundary_code	varchar	30
abhab_segment_boundaries	group_code	varchar	8
abhab_segment_boundaries	latitude	decimal	15,13
abhab_segment_boundaries	longitude	decimal	16,13
abhab_segment_boundaries	modify_date	timestamp	19			current_timestamp()
abhab_segment_boundaries	segment_id	varchar	8
abhab_segment_boundaries	site_code	char	6
abhab_segment_boundaries	survey_date	date	10
abhab_segment_boundaries_active	create_date	date	10
abhab_segment_boundaries_active	datum	enum	6			WGS84
abhab_segment_boundaries_active	gps_boundary_code	varchar	30
abhab_segment_boundaries_active	group_code	varchar	8
abhab_segment_boundaries_active	latitude	decimal	15,13
abhab_segment_boundaries_active	longitude	decimal	16,13
abhab_segment_boundaries_active	modify_date	timestamp	19			current_timestamp()
abhab_segment_boundaries_active	segment_id	varchar	8
abhab_segment_boundaries_active	site_code	char	6
abhab_segment_boundaries_active	survey_date	date	10
abhab_segment_ids	create_date	date	10
abhab_segment_ids	segment_id	varchar	8
abhab_segment_ids	sort_order	int	10
abhab_segment_info	adjusted_area_m2	int	10
abhab_segment_info	area_m2	int	10
abhab_segment_info	create_date	date	10
abhab_segment_info	end_time	time	8
abhab_segment_info	exposure	enum	8			ND
abhab_segment_info	group_code	varchar	8
abhab_segment_info	modify_date	timestamp	19			current_timestamp()
abhab_segment_info	percent_abs_removable	varchar	3			NA
abhab_segment_info	percent_good	int	10
abhab_segment_info	percent_good_nobio	varchar	3			NA
abhab_segment_info	percent_moderate	int	10
abhab_segment_info	percent_moderate_nobio	varchar	3			NA
abhab_segment_info	percent_poor	int	10
abhab_segment_info	percent_poor_nobio	varchar	3			NA
abhab_segment_info	relief	enum	8			ND
abhab_segment_info	rock_type	varchar	20
abhab_segment_info	sediment_influence	enum	8			ND
abhab_segment_info	segment_id	varchar	8
abhab_segment_info	segment_type	enum	12			full_sample
abhab_segment_info	shoreline_length_m	int	10
abhab_segment_info	site_code	char	6
abhab_segment_info	start_time	time	8
abhab_segment_info	sub_of_segment_id	varchar	8			NA
abhab_segment_info	substrate_code	varchar	40
abhab_segment_info	survey_date	date	10
abhab_segment_info	target_assemblage	varchar	8
abhab_segment_info_active	adjusted_area_m2	int	10
abhab_segment_info_active	area_m2	int	10
abhab_segment_info_active	create_date	date	10
abhab_segment_info_active	end_time	time	8
abhab_segment_info_active	exposure	enum	8			ND
abhab_segment_info_active	group_code	varchar	8
abhab_segment_info_active	modify_date	timestamp	19			current_timestamp()
abhab_segment_info_active	percent_abs_removable	varchar	3			NA
abhab_segment_info_active	percent_good	int	10
abhab_segment_info_active	percent_good_nobio	varchar	3			NA
abhab_segment_info_active	percent_moderate	int	10
abhab_segment_info_active	percent_moderate_nobio	varchar	3			NA
abhab_segment_info_active	percent_poor	int	10
abhab_segment_info_active	percent_poor_nobio	varchar	3			NA
abhab_segment_info_active	relief	enum	8			ND
abhab_segment_info_active	rock_type	varchar	20
abhab_segment_info_active	sediment_influence	enum	8			ND
abhab_segment_info_active	segment_id	varchar	8
abhab_segment_info_active	segment_type	enum	12			full_sample
abhab_segment_info_active	shoreline_length_m	int	10
abhab_segment_info_active	site_code	char	6
abhab_segment_info_active	start_time	time	8
abhab_segment_info_active	sub_of_segment_id	varchar	8			NA
abhab_segment_info_active	substrate_code	varchar	40
abhab_segment_info_active	survey_date	date	10
abhab_segment_info_active	target_assemblage	varchar	8
abhab_segments_count_sizes	abalone_habitat_code	varchar	2
abhab_segments_count_sizes	abalone_nn_code	varchar	11
abhab_segments_count_sizes	abalone_size_bin	varchar	3
abhab_segments_count_sizes	abalone_size_count	int unsigned	10
abhab_segments_count_sizes	count_qualifier_code	varchar	6
abhab_segments_count_sizes	create_date	date	10
abhab_segments_count_sizes	group_code	varchar	8
abhab_segments_count_sizes	method_code	varchar	6
abhab_segments_count_sizes	modify_date	timestamp	19			current_timestamp()
abhab_segments_count_sizes	segment_id	varchar	8
abhab_segments_count_sizes	site_code	char	6
abhab_segments_count_sizes	size_qualifier_code	varchar	6
abhab_segments_count_sizes	species_code	char	6
abhab_segments_count_sizes	survey_date	date	10
abhab_segments_count_sizes	target_assemblage	varchar	20
abhab_segments_count_sizes_active	abalone_habitat_code	varchar	2
abhab_segments_count_sizes_active	abalone_nn_code	varchar	11
abhab_segments_count_sizes_active	abalone_size_bin	varchar	3
abhab_segments_count_sizes_active	abalone_size_count	int unsigned	10
abhab_segments_count_sizes_active	count_qualifier_code	varchar	6
abhab_segments_count_sizes_active	create_date	date	10
abhab_segments_count_sizes_active	group_code	varchar	8
abhab_segments_count_sizes_active	method_code	varchar	6
abhab_segments_count_sizes_active	modify_date	timestamp	19			current_timestamp()
abhab_segments_count_sizes_active	segment_id	varchar	8
abhab_segments_count_sizes_active	site_code	char	6
abhab_segments_count_sizes_active	size_qualifier_code	varchar	6
abhab_segments_count_sizes_active	species_code	char	6
abhab_segments_count_sizes_active	survey_date	date	10
abhab_segments_count_sizes_active	target_assemblage	varchar	20
abhab_substrate_codes	create_date	date	10
abhab_substrate_codes	substrate_code	varchar	40
abhab_substrate_codes	substrate_description	varchar	150
biodiversity_sites	bio_latitude	float	12,8
biodiversity_sites	bio_longitude	float	10,5
biodiversity_sites	cbs_site_code	char	6
biodiversity_sites	comments	varchar	100	√		null
biodiversity_sites	create_date	date	10
biodiversity_sites	established_date	date	10
biodiversity_sites	site_code	char	6
biodiversity_sites	years_sampled	varchar	50
bird_codes	bird_code	varchar	15
bird_codes	bird_description	varchar	150
bird_codes	create_date	date	10
bird_count_values	bird_bin_max	varchar	5
bird_count_values	bird_bin_min	varchar	5
bird_count_values	bird_count_bin_description	varchar	100
bird_count_values	bird_count_value	varchar	6
bird_count_values	bird_sort_order	int	10
bird_count_values	create_date	date	10
checklist_codes_active	checklist_code	varchar	18
checklist_codes_active	checklist_description	varchar	100
checklist_codes_active	checklist_sort	int	10
checklist_entered	create_date	date	10
checklist_entered	group_code	varchar	8
checklist_entered	modify_date	timestamp	19			current_timestamp()
checklist_entered	quatraplot_code	varchar	4
checklist_entered	site_code	char	6
checklist_entered	survey_date	date	10
checklist_entered	survey_type_code	varchar	30
checklist_entered	target_assemblage	varchar	20
checklist_entered_active	create_date	date	10
checklist_entered_active	group_code	varchar	8
checklist_entered_active	modify_date	timestamp	19			current_timestamp()
checklist_entered_active	quatraplot_code	varchar	4
checklist_entered_active	site_code	char	6
checklist_entered_active	survey_date	date	10
checklist_entered_active	survey_type_code	varchar	30
checklist_entered_active	target_assemblage	varchar	20
checklist_not_sampled	create_date	date	10
checklist_not_sampled	group_code	varchar	8
checklist_not_sampled	modify_date	timestamp	19			current_timestamp()
checklist_not_sampled	quatraplot_code	varchar	6
checklist_not_sampled	site_code	char	6
checklist_not_sampled	survey_date	date	10
checklist_not_sampled	survey_type_code	varchar	30
checklist_not_sampled	target_assemblage	varchar	20
checklist_not_sampled_active	create_date	date	10
checklist_not_sampled_active	group_code	varchar	8
checklist_not_sampled_active	modify_date	timestamp	19			current_timestamp()
checklist_not_sampled_active	quatraplot_code	varchar	6
checklist_not_sampled_active	site_code	char	6
checklist_not_sampled_active	survey_date	date	10
checklist_not_sampled_active	survey_type_code	varchar	30
checklist_not_sampled_active	target_assemblage	varchar	20
checklist_quatraplots_active	quatraplot_code	varchar	6
checklist_quatraplots_active	site_code	char	6
checklist_quatraplots_active	survey_type_code	varchar	30
checklist_quatraplots_active	target_assemblage	varchar	20
checklist_sampled	create_date	date	10
checklist_sampled	group_code	varchar	8
checklist_sampled	modify_date	timestamp	19			current_timestamp()
checklist_sampled	quatraplot_code	varchar	6
checklist_sampled	site_code	char	6
checklist_sampled	survey_date	date	10
checklist_sampled	survey_type_code	varchar	30
checklist_sampled	target_assemblage	varchar	20
checklist_sampled_active	create_date	date	10
checklist_sampled_active	group_code	varchar	8
checklist_sampled_active	modify_date	timestamp	19			current_timestamp()
checklist_sampled_active	quatraplot_code	varchar	6
checklist_sampled_active	site_code	char	6
checklist_sampled_active	survey_date	date	10
checklist_sampled_active	survey_type_code	varchar	30
checklist_sampled_active	target_assemblage	varchar	20
checklist_supplemental_sitewide	active_status	enum	8			active
checklist_supplemental_sitewide	create_date	date	10
checklist_supplemental_sitewide	modify_date	timestamp	19			current_timestamp()
checklist_supplemental_sitewide	site_code	char	6
checklist_supplemental_sitewide	survey_type_code	varchar	30
checklist_supplemental_sitewide_active	site_code	char	6
checklist_supplemental_sitewide_active	survey_type_code	varchar	30
cit_sites	comments	varchar	100	√		null
cit_sites	create_date	date	10
cit_sites	established_date	date	10
cit_sites	site_code	char	6
collection_count_values	collection_bin_max	varchar	5
collection_count_values	collection_bin_min	varchar	5
collection_count_values	collection_count_bin_description	varchar	100
collection_count_values	collection_count_value	varchar	3
collection_count_values	collection_sort_order	int	10
collection_count_values	create_date	date	10
collection_projects	active_status	enum	8
collection_projects	contact_email	varchar	100
collection_projects	contact_name	varchar	50
collection_projects	project_code	varchar	8
collection_projects	project_description	varchar	200
collection_qualifiers	collection_qualifier_code	varchar	6
collection_species	active_status	enum	8
collection_species	collection_sort	int	10
collection_species	species_code	char	6
collection_types	collection_description	varchar	100
collection_types	collection_type	varchar	15
collection_types	create_date	date	10
condition_codes	condition_code	varchar	3
condition_codes	condition_description	varchar	8
condition_codes	condition_sort	int	10	√		null
condition_codes	create_date	date	10
count_qualifiers	count_qualifier_code	varchar	6
count_size_methods	method_code	varchar	6
count_size_plot_codes	create_date	date	10
count_size_plot_codes	plot_code	varchar	6
cryptochiton_count_sizes	count_qualifier_code	varchar	6
cryptochiton_count_sizes	create_date	date	10
cryptochiton_count_sizes	cryptochiton_size_bin	varchar	3
cryptochiton_count_sizes	cryptochiton_size_count	int unsigned	10
cryptochiton_count_sizes	group_code	varchar	8
cryptochiton_count_sizes	method_code	varchar	6
cryptochiton_count_sizes	modify_date	timestamp	19			current_timestamp()
cryptochiton_count_sizes	plot_code	varchar	6
cryptochiton_count_sizes	site_code	char	6
cryptochiton_count_sizes	size_qualifier_code	varchar	6
cryptochiton_count_sizes	species_code	char	6
cryptochiton_count_sizes	survey_date	date	10
cryptochiton_count_sizes	survey_type_code	varchar	30
cryptochiton_count_sizes	target_assemblage	varchar	20
cryptochiton_count_sizes_active	count_qualifier_code	varchar	6
cryptochiton_count_sizes_active	create_date	date	10
cryptochiton_count_sizes_active	cryptochiton_size_bin	varchar	3
cryptochiton_count_sizes_active	cryptochiton_size_count	int unsigned	10
cryptochiton_count_sizes_active	group_code	varchar	8
cryptochiton_count_sizes_active	method_code	varchar	6
cryptochiton_count_sizes_active	modify_date	timestamp	19			current_timestamp()
cryptochiton_count_sizes_active	plot_code	varchar	6
cryptochiton_count_sizes_active	site_code	char	6
cryptochiton_count_sizes_active	size_qualifier_code	varchar	6
cryptochiton_count_sizes_active	species_code	char	6
cryptochiton_count_sizes_active	survey_date	date	10
cryptochiton_count_sizes_active	survey_type_code	varchar	30
cryptochiton_count_sizes_active	target_assemblage	varchar	20
cryptochiton_group_species	active_status	enum	8
cryptochiton_group_species	create_date	date	10
cryptochiton_group_species	group_code	varchar	8
cryptochiton_group_species	modify_date	timestamp	19			current_timestamp()
cryptochiton_group_species	species_code	char	6
cryptochiton_group_species_active	group_code	varchar	8
cryptochiton_group_species_active	species_code	char	6
cryptochiton_size_bins	create_date	date	10
cryptochiton_size_bins	cryptochiton_bin_max	varchar	5
cryptochiton_size_bins	cryptochiton_bin_min	varchar	5
cryptochiton_size_bins	cryptochiton_size_bin	varchar	3
cryptochiton_size_bins	cryptochiton_size_bin_description	varchar	100
cryptochiton_size_bins	cryptochiton_sort_order	int	10
database_changes	change_code	varchar	40
database_changes	change_date	timestamp	19			current_timestamp()
database_changes	change_description	varchar	356
database_changes	change_source	varchar	256	√		null
field_event_bird_counts	bird_code	varchar	15
field_event_bird_counts	bird_count_value	varchar	6
field_event_bird_counts	create_date	date	10
field_event_bird_counts	group_code	varchar	8
field_event_bird_counts	modify_date	timestamp	19			current_timestamp()
field_event_bird_counts	site_code	char	6
field_event_bird_counts	survey_date	date	10
field_event_bird_counts_active	bird_code	varchar	15
field_event_bird_counts_active	bird_count_value	varchar	6
field_event_bird_counts_active	create_date	date	10
field_event_bird_counts_active	group_code	varchar	8
field_event_bird_counts_active	modify_date	timestamp	19			current_timestamp()
field_event_bird_counts_active	site_code	char	6
field_event_bird_counts_active	survey_date	date	10
field_event_collections	collection_count_value	varchar	3
field_event_collections	collection_notes	text	65535	√		null
field_event_collections	collection_qualifier	varchar	6			NQ
field_event_collections	collection_type	varchar	15
field_event_collections	collector	varchar	10
field_event_collections	create_date	date	10
field_event_collections	group_code	varchar	8
field_event_collections	modify_date	timestamp	19			current_timestamp()
field_event_collections	project_code	varchar	8
field_event_collections	site_code	char	6
field_event_collections	species_code	char	6
field_event_collections	survey_date	date	10
field_event_collections_active	collection_count_value	varchar	3
field_event_collections_active	collection_notes	text	65535	√		null
field_event_collections_active	collection_qualifier	varchar	6			NQ
field_event_collections_active	collection_type	varchar	15
field_event_collections_active	collector	varchar	10
field_event_collections_active	create_date	date	10
field_event_collections_active	group_code	varchar	8
field_event_collections_active	modify_date	timestamp	19			current_timestamp()
field_event_collections_active	project_code	varchar	8
field_event_collections_active	site_code	char	6
field_event_collections_active	species_code	char	6
field_event_collections_active	survey_date	date	10
field_event_conditions	bird_mammal_notes	text	65535	√		null
field_event_conditions	create_date	date	10
field_event_conditions	dead_animals	varchar	3
field_event_conditions	driftwood	varchar	3
field_event_conditions	end_time	time	8
field_event_conditions	group_code	varchar	8
field_event_conditions	humans_notes	text	65535	√		null
field_event_conditions	humans_reef	varchar	3
field_event_conditions	humans_sand	varchar	3
field_event_conditions	modify_date	timestamp	19			current_timestamp()
field_event_conditions	oil_tar	varchar	3
field_event_conditions	other_notes	text	65535	√		null
field_event_conditions	physical_notes	text	65535	√		null
field_event_conditions	plant_wrack	varchar	3
field_event_conditions	plot_notes	text	65535	√		null
field_event_conditions	rain_amount	varchar	3
field_event_conditions	rain_recent	varchar	3
field_event_conditions	rock_movement	varchar	3
field_event_conditions	scoured_reef	varchar	3
field_event_conditions	sediment_level	varchar	3
field_event_conditions	shell_debris	varchar	3
field_event_conditions	site_code	char	6
field_event_conditions	start_time	time	8
field_event_conditions	survey_date	date	10
field_event_conditions	swell_surge	varchar	3
field_event_conditions	trash	varchar	3
field_event_conditions	wind_speed	varchar	3
field_event_conditions_active	bird_mammal_notes	varchar	2000	√		null
field_event_conditions_active	create_date	date	10
field_event_conditions_active	dead_animals	varchar	3
field_event_conditions_active	driftwood	varchar	3
field_event_conditions_active	end_time	time	8
field_event_conditions_active	group_code	varchar	8
field_event_conditions_active	humans_notes	varchar	2000	√		null
field_event_conditions_active	humans_reef	varchar	3
field_event_conditions_active	humans_sand	varchar	3
field_event_conditions_active	modify_date	timestamp	19			current_timestamp()
field_event_conditions_active	oil_tar	varchar	3
field_event_conditions_active	other_notes	varchar	2000	√		null
field_event_conditions_active	physical_notes	varchar	2000	√		null
field_event_conditions_active	plant_wrack	varchar	3
field_event_conditions_active	plot_notes	varchar	2000	√		null
field_event_conditions_active	rain_amount	varchar	3
field_event_conditions_active	rain_recent	varchar	3
field_event_conditions_active	rock_movement	varchar	3
field_event_conditions_active	scoured_reef	varchar	3
field_event_conditions_active	sediment_level	varchar	3
field_event_conditions_active	shell_debris	varchar	3
field_event_conditions_active	site_code	char	6
field_event_conditions_active	start_time	time	8
field_event_conditions_active	survey_date	date	10
field_event_conditions_active	swell_surge	varchar	3
field_event_conditions_active	trash	varchar	3
field_event_conditions_active	wind_speed	varchar	3
field_event_data_collectors	create_date	date	10
field_event_data_collectors	group_code	varchar	8
field_event_data_collectors	modify_date	timestamp	19			current_timestamp()
field_event_data_collectors	personnel_code	varchar	10
field_event_data_collectors	role_code	varchar	12
field_event_data_collectors	site_code	char	6
field_event_data_collectors	survey_date	date	10
field_event_data_collectors	survey_type_code	varchar	30
field_event_data_collectors	target_assemblage	varchar	20
field_event_data_collectors_active	create_date	date	10
field_event_data_collectors_active	group_code	varchar	8
field_event_data_collectors_active	modify_date	timestamp	19			current_timestamp()
field_event_data_collectors_active	personnel_code	varchar	10
field_event_data_collectors_active	role_code	varchar	12
field_event_data_collectors_active	site_code	char	6
field_event_data_collectors_active	survey_date	date	10
field_event_data_collectors_active	survey_type_code	varchar	30
field_event_data_collectors_active	target_assemblage	varchar	20
field_event_mammal_counts	create_date	date	10
field_event_mammal_counts	group_code	varchar	8
field_event_mammal_counts	mammal_code	varchar	20
field_event_mammal_counts	mammal_count_value	varchar	3
field_event_mammal_counts	modify_date	timestamp	19			current_timestamp()
field_event_mammal_counts	site_code	char	6
field_event_mammal_counts	survey_date	date	10
field_event_mammal_counts_active	create_date	date	10
field_event_mammal_counts_active	group_code	varchar	8
field_event_mammal_counts_active	mammal_code	varchar	20
field_event_mammal_counts_active	mammal_count_value	varchar	3
field_event_mammal_counts_active	modify_date	timestamp	19			current_timestamp()
field_event_mammal_counts_active	site_code	char	6
field_event_mammal_counts_active	survey_date	date	10
field_event_mammal_disturbance	create_date	date	10
field_event_mammal_disturbance	disturbance_detail	varchar	80
field_event_mammal_disturbance	disturbance_level	int	10
field_event_mammal_disturbance	group_code	varchar	8
field_event_mammal_disturbance	mammal_age	enum	8
field_event_mammal_disturbance	mammal_code	varchar	20
field_event_mammal_disturbance	mammal_count_value	varchar	3
field_event_mammal_disturbance	mammal_sex	enum	7
field_event_mammal_disturbance	modify_date	timestamp	19			current_timestamp()
field_event_mammal_disturbance	observation_time	time	8
field_event_mammal_disturbance	site_code	char	6
field_event_mammal_disturbance	survey_date	date	10
field_event_mammal_disturbance_active	create_date	date	10
field_event_mammal_disturbance_active	disturbance_detail	varchar	80
field_event_mammal_disturbance_active	disturbance_level	int	10
field_event_mammal_disturbance_active	group_code	varchar	8
field_event_mammal_disturbance_active	mammal_age	enum	8
field_event_mammal_disturbance_active	mammal_code	varchar	20
field_event_mammal_disturbance_active	mammal_count_value	varchar	3
field_event_mammal_disturbance_active	mammal_sex	enum	7
field_event_mammal_disturbance_active	modify_date	timestamp	19			current_timestamp()
field_event_mammal_disturbance_active	observation_time	time	8
field_event_mammal_disturbance_active	site_code	char	6
field_event_mammal_disturbance_active	survey_date	date	10
field_event_non_native	create_date	date	10
field_event_non_native	group_code	varchar	8
field_event_non_native	modify_date	timestamp	19			current_timestamp()
field_event_non_native	non_native_abundance_code	varchar	3
field_event_non_native	site_code	char	6
field_event_non_native	species_code	varchar	15
field_event_non_native	survey_date	date	10
field_event_non_native_active	create_date	date	10
field_event_non_native_active	group_code	varchar	8
field_event_non_native_active	modify_date	timestamp	19			current_timestamp()
field_event_non_native_active	non_native_abundance_code	varchar	3
field_event_non_native_active	site_code	char	6
field_event_non_native_active	species_code	varchar	15
field_event_non_native_active	survey_date	date	10
field_event_participants	create_date	date	10
field_event_participants	group_code	varchar	8
field_event_participants	modify_date	timestamp	19			current_timestamp()
field_event_participants	personnel_code	varchar	10
field_event_participants	site_code	char	6
field_event_participants	survey_date	date	10
field_event_participants_active	create_date	date	10
field_event_participants_active	group_code	varchar	8
field_event_participants_active	modify_date	timestamp	19			current_timestamp()
field_event_participants_active	personnel_code	varchar	10
field_event_participants_active	site_code	char	6
field_event_participants_active	survey_date	date	10
field_event_recon	bleached_recon_condition_code	varchar	3
field_event_recon	create_date	date	10
field_event_recon	damaged_recon_condition_code	varchar	3
field_event_recon	fertile_recon_condition_code	varchar	3
field_event_recon	group_code	varchar	8
field_event_recon	modify_date	timestamp	19			current_timestamp()
field_event_recon	recon_abundance_code	varchar	3
field_event_recon	recon_recruitment_code	varchar	3
field_event_recon	site_code	char	6
field_event_recon	species_code	char	6
field_event_recon	survey_date	date	10
field_event_recon_active	bleached_recon_condition_code	varchar	3
field_event_recon_active	create_date	date	10
field_event_recon_active	damaged_recon_condition_code	varchar	3
field_event_recon_active	fertile_recon_condition_code	varchar	3
field_event_recon_active	group_code	varchar	8
field_event_recon_active	modify_date	timestamp	19			current_timestamp()
field_event_recon_active	recon_abundance_code	varchar	3
field_event_recon_active	recon_recruitment_code	varchar	3
field_event_recon_active	site_code	char	6
field_event_recon_active	species_code	char	6
field_event_recon_active	survey_date	date	10
field_events	create_date	date	10
field_events	group_code	varchar	8
field_events	marine_common_season	int unsigned	10
field_events	marine_sample_type	enum	10			standard
field_events	modify_date	timestamp	19			current_timestamp()
field_events	recorder	varchar	10
field_events	site_code	char	6				the site code
field_events	survey_date	date	10				The date the site was surveyed. Date format is yyyy-mm-dd.
field_events_active	create_date	date	10
field_events_active	group_code	varchar	8
field_events_active	marine_common_season	int unsigned	10
field_events_active	marine_sample_type	enum	10			standard
field_events_active	modify_date	timestamp	19			current_timestamp()
field_events_active	recorder	varchar	10
field_events_active	site_code	char	6
field_events_active	survey_date	date	10
form_method_codes	create_date	date	10
form_method_codes	method_code_description	varchar	100
form_methods	method_code	varchar	6
form_methods	site_code	char	6
form_methods	target_assemblage	varchar	20
form_photo_plot_species_sort	sort_order	int	10
form_photo_plot_species_sort	species_code	char	6
form_postelsia_site_plot_location_meter	location	decimal	2,1
form_postelsia_site_plot_location_meter	meter	decimal	3,1
form_postelsia_site_plot_location_meter	plot_code	varchar	6
form_postelsia_site_plot_location_meter	postelsia_direction_code	varchar	10
form_postelsia_site_plot_location_meter	site_code	char	6
form_postelsia_site_plot_location_meter	target_assemblage	varchar	20
form_transect_species_sort	sort_order	int	10
form_transect_species_sort	species_code	char	6
funding_groups	create_date	date	10
funding_groups	group_code	varchar	8
funding_history	comments	varchar	100	√		null
funding_history	create_date	date	10
funding_history	funding_end_year	year	0
funding_history	funding_level	varchar	20
funding_history	funding_start_year	year	0
funding_history	group_code	varchar	8
funding_history	modify_date	timestamp	19			current_timestamp()
funding_history	site_code	char	6
funding_levels	create_date	date	10
funding_levels	funding_description	varchar	100
funding_levels	funding_level	varchar	20
gps_boundary_codes	create_date	date	10
gps_boundary_codes	gps_boundary_code	varchar	30
gps_boundary_codes	gps_boundary_description	varchar	200
gps_boundary_codes	sort_order	int	10
gps_location_codes	create_date	date	10
gps_location_codes	gps_location_code	varchar	30
gps_location_codes	gps_location_description	varchar	100
katharina_count_sizes	count_qualifier_code	varchar	6
katharina_count_sizes	create_date	date	10
katharina_count_sizes	group_code	varchar	8
katharina_count_sizes	katharina_size_bin	varchar	3
katharina_count_sizes	katharina_size_count	int unsigned	10
katharina_count_sizes	method_code	varchar	6
katharina_count_sizes	modify_date	timestamp	19			current_timestamp()
katharina_count_sizes	plot_code	varchar	6
katharina_count_sizes	site_code	char	6
katharina_count_sizes	size_qualifier_code	varchar	6
katharina_count_sizes	species_code	char	6
katharina_count_sizes	survey_date	date	10
katharina_count_sizes	survey_type_code	varchar	30
katharina_count_sizes	target_assemblage	varchar	20
katharina_count_sizes_active	count_qualifier_code	varchar	6
katharina_count_sizes_active	create_date	date	10
katharina_count_sizes_active	group_code	varchar	8
katharina_count_sizes_active	katharina_size_bin	varchar	3
katharina_count_sizes_active	katharina_size_count	int unsigned	10
katharina_count_sizes_active	method_code	varchar	6
katharina_count_sizes_active	modify_date	timestamp	19			current_timestamp()
katharina_count_sizes_active	plot_code	varchar	6
katharina_count_sizes_active	site_code	char	6
katharina_count_sizes_active	size_qualifier_code	varchar	6
katharina_count_sizes_active	species_code	char	6
katharina_count_sizes_active	survey_date	date	10
katharina_count_sizes_active	survey_type_code	varchar	30
katharina_count_sizes_active	target_assemblage	varchar	20
katharina_group_species	active_status	enum	8
katharina_group_species	create_date	date	10
katharina_group_species	group_code	varchar	8
katharina_group_species	modify_date	timestamp	19			current_timestamp()
katharina_group_species	species_code	char	6
katharina_group_species_active	group_code	varchar	8
katharina_group_species_active	species_code	char	6
katharina_size_bins	create_date	date	10
katharina_size_bins	katharina_bin_max	varchar	5
katharina_size_bins	katharina_bin_min	varchar	5
katharina_size_bins	katharina_size_bin	varchar	3
katharina_size_bins	katharina_size_bin_description	varchar	100
katharina_size_bins	katharina_sort_order	int	10
lottia_count_sizes	count_qualifier_code	varchar	6
lottia_count_sizes	create_date	date	10
lottia_count_sizes	group_code	varchar	8
lottia_count_sizes	lottia_size_bin	varchar	3
lottia_count_sizes	lottia_size_count	int unsigned	10
lottia_count_sizes	method_code	varchar	6
lottia_count_sizes	modify_date	timestamp	19			current_timestamp()
lottia_count_sizes	plot_code	varchar	6
lottia_count_sizes	site_code	char	6
lottia_count_sizes	size_qualifier_code	varchar	6
lottia_count_sizes	species_code	char	6
lottia_count_sizes	survey_date	date	10
lottia_count_sizes	target_assemblage	varchar	20
lottia_count_sizes_active	count_qualifier_code	varchar	6
lottia_count_sizes_active	create_date	date	10
lottia_count_sizes_active	group_code	varchar	8
lottia_count_sizes_active	lottia_size_bin	varchar	3
lottia_count_sizes_active	lottia_size_count	int unsigned	10
lottia_count_sizes_active	method_code	varchar	6
lottia_count_sizes_active	modify_date	timestamp	19			current_timestamp()
lottia_count_sizes_active	plot_code	varchar	6
lottia_count_sizes_active	site_code	char	6
lottia_count_sizes_active	size_qualifier_code	varchar	6
lottia_count_sizes_active	species_code	char	6
lottia_count_sizes_active	survey_date	date	10
lottia_count_sizes_active	target_assemblage	varchar	20
lottia_cover	approx_cover	int	10
lottia_cover	create_date	date	10
lottia_cover	group_code	varchar	8
lottia_cover	modify_date	timestamp	19			current_timestamp()
lottia_cover	plot_code	varchar	6
lottia_cover	site_code	char	6
lottia_cover	species_code	char	6
lottia_cover	survey_date	date	10
lottia_cover	survey_type_code	varchar	30
lottia_cover	target_assemblage	varchar	20
lottia_cover_active	approx_cover	int	10
lottia_cover_active	create_date	date	10
lottia_cover_active	group_code	varchar	8
lottia_cover_active	modify_date	timestamp	19			current_timestamp()
lottia_cover_active	plot_code	varchar	6
lottia_cover_active	site_code	char	6
lottia_cover_active	species_code	char	6
lottia_cover_active	survey_date	date	10
lottia_cover_active	survey_type_code	varchar	30
lottia_cover_active	target_assemblage	varchar	20
lottia_cover_group_species	active_status	enum	8
lottia_cover_group_species	create_date	date	10
lottia_cover_group_species	group_code	varchar	8
lottia_cover_group_species	modify_date	timestamp	19			current_timestamp()
lottia_cover_group_species	species_code	char	6
lottia_cover_group_species_active	group_code	varchar	8
lottia_cover_group_species_active	species_code	char	6
lottia_group_species	active_status	enum	8
lottia_group_species	create_date	date	10
lottia_group_species	group_code	varchar	8
lottia_group_species	modify_date	timestamp	19			current_timestamp()
lottia_group_species	species_code	char	6
lottia_group_species_active	group_code	varchar	8
lottia_group_species_active	species_code	char	6
lottia_notes	create_date	date	10
lottia_notes	group_code	varchar	8
lottia_notes	lottia_note	text	65535	√		null
lottia_notes	modify_date	timestamp	19			current_timestamp()
lottia_notes	plot_code	varchar	6
lottia_notes	site_code	char	6
lottia_notes	survey_date	date	10
lottia_notes	target_assemblage	varchar	20
lottia_notes_active	create_date	date	10
lottia_notes_active	group_code	varchar	8
lottia_notes_active	lottia_note	text	65535	√		null
lottia_notes_active	modify_date	timestamp	19			current_timestamp()
lottia_notes_active	plot_code	varchar	6
lottia_notes_active	site_code	char	6
lottia_notes_active	survey_date	date	10
lottia_notes_active	target_assemblage	varchar	20
lottia_plot_info	active_status	enum	8
lottia_plot_info	comments	varchar	100	√		null
lottia_plot_info	create_date	date	10
lottia_plot_info	end_date	date	10	√		null
lottia_plot_info	established_date	date	10
lottia_plot_info	modify_date	timestamp	19			current_timestamp()
lottia_plot_info	plot_code	varchar	6
lottia_plot_info	site_code	char	6
lottia_plot_info	target_assemblage	varchar	20
lottia_plot_info_active	plot_code	varchar	6
lottia_plot_info_active	site_code	char	6
lottia_plot_info_active	target_assemblage	varchar	20
lottia_size_bins	create_date	date	10
lottia_size_bins	lottia_bin_max	varchar	5
lottia_size_bins	lottia_bin_min	varchar	5
lottia_size_bins	lottia_size_bin	varchar	3
lottia_size_bins	lottia_size_bin_description	varchar	100
lottia_size_bins	lottia_sort_order	int	10
mammal_codes	create_date	date	10
mammal_codes	mammal_code	varchar	20
mammal_codes	mammal_description	varchar	150
mammal_count_values	create_date	date	10
mammal_count_values	mammal_bin_max	varchar	5
mammal_count_values	mammal_bin_min	varchar	5
mammal_count_values	mammal_count_bin_description	varchar	100
mammal_count_values	mammal_count_value	varchar	3
mammal_count_values	mammal_sort_order	int	10
mammal_disturbance_details	create_date	date	10
mammal_disturbance_details	disturbance_detail	varchar	100
mammal_disturbance_details	modify_date	timestamp	19			current_timestamp()
mammal_disturbance_levels	create_date	date	10
mammal_disturbance_levels	description	text	65535	√		null
mammal_disturbance_levels	disturbance_level	int	10
mammal_disturbance_levels	level_of_response	varchar	15
mammal_disturbance_levels	modify_date	timestamp	19			current_timestamp()
marine_common_seasons	create_date	date	10
marine_common_seasons	marine_common_season	int unsigned	10
marine_common_seasons	marine_common_year	int unsigned	10
marine_common_seasons	marine_season_code	char	4
marine_common_seasons	season_name	varchar	6
marine_common_seasons	season_sequence	enum	2
marine_common_seasons	typical_end_date	date	10
marine_common_seasons	typical_start_date	date	10
marine_group_sites	active_status	enum	8			active
marine_group_sites	create_date	date	10
marine_group_sites	group_code	varchar	8
marine_group_sites	modify_date	timestamp	19			current_timestamp()
marine_group_sites	site_code	char	6
marine_groups	contact_email	varchar	100
marine_groups	contact_name	varchar	50
marine_groups	create_date	date	10
marine_groups	group_code	varchar	8
marine_groups	group_name	varchar	100
marine_groups	modify_date	timestamp	19			current_timestamp()
marine_lumping_codes	comments	varchar	100	√		null
marine_lumping_codes	create_date	date	10
marine_lumping_codes	lumping_code	varchar	10
marine_lumping_codes	lumping_name	varchar	50
marine_lumping_codes	modify_date	timestamp	19			current_timestamp()
marine_personnel	active_status	enum	8
marine_personnel	comments	varchar	100	√		null
marine_personnel	create_date	date	10
marine_personnel	end_date	date	10	√		null
marine_personnel	full_name	varchar	50
marine_personnel	modify_date	timestamp	19			current_timestamp()
marine_personnel	personnel_code	varchar	10
marine_personnel	start_date	date	10
marine_sites	established_date	date	10	√		null
marine_sites	ltm_latitude	float	12,8
marine_sites	ltm_longitude	float	10,5
marine_sites	site_code	char	6
marine_species	active_status	enum	8			active
marine_species	biological_flag	enum	5			TRUE
marine_species	create_date	date	10
marine_species	marine_species_definition	varchar	500	√		null
marine_species	marine_species_name	varchar	75
marine_species	modify_date	timestamp	19			current_timestamp()
marine_species	species_code	char	6
marine_species	taxonomic_id	varchar	100
marine_species	taxonomic_source	varchar	100
marine_species_lumping	comments_photoplots	varchar	100	√		null
marine_species_lumping	comments_transects	varchar	100	√		null
marine_species_lumping	create_date	date	10
marine_species_lumping	historically_lumped_with_photoplots	varchar	100	√		null
marine_species_lumping	historically_lumped_with_transects	varchar	100	√		null
marine_species_lumping	modify_date	timestamp	19			current_timestamp()
marine_species_lumping	nps_photo_lump_1999_present	varchar	10
marine_species_lumping	nps_photo_lump_2004_present	varchar	10
marine_species_lumping	nps_photo_lump_all_years	varchar	10
marine_species_lumping	nps_transect_lump_2003_present	varchar	10
marine_species_lumping	nps_transect_lump_all_years	varchar	10
marine_species_lumping	primary_species_lump_photo	varchar	10
marine_species_lumping	primary_species_lump_transects	varchar	10
marine_species_lumping	red_turf_lump	varchar	10
marine_species_lumping	species_code	char	6
marine_species_lumping	species_comments	varchar	100	√		null
marine_species_lumping	target_lump	varchar	10			DROP
marine_species_lumping	web_graph_lump	varchar	10
marine_species_lumping	yrs_used_by_group_photoplots	varchar	100	√		null
marine_species_lumping	yrs_used_by_group_transects	varchar	100	√		null
marine_subgroups	site_code	char	6
marine_subgroups	subgroup_code	varchar	8
master_site_reference	asbs_name	varchar	100	√		null
master_site_reference	bioregion	varchar	50	√		null
master_site_reference	comments	varchar	300
master_site_reference	country	varchar	30
master_site_reference	county	varchar	30
master_site_reference	county_designation	varchar	50	√		null
master_site_reference	create_date	date	10
master_site_reference	georegion	varchar	50	√		null
master_site_reference	island	varchar	30
master_site_reference	latitude	float	12,8
master_site_reference	longitude	float	10,5
master_site_reference	marine_site_name	varchar	50
master_site_reference	marine_sort_order	int unsigned	10
master_site_reference	modify_date	timestamp	19			current_timestamp()
master_site_reference	mpa_designation	varchar	10	√		null
master_site_reference	mpa_lt_region	varchar	50	√		null
master_site_reference	mpa_name	varchar	50	√		null
master_site_reference	mpa_region	varchar	50	√		null
master_site_reference	national_designation	varchar	50	√		null
master_site_reference	nms_name	varchar	50	√		null
master_site_reference	nps_network_code	varchar	4			NONE
master_site_reference	other_designation	varchar	50	√		null
master_site_reference	pisco_code	char	6	√		null
master_site_reference	site_code	char	6
master_site_reference	site_filename	varchar	50	√		null
master_site_reference	site_link	varchar	255
master_site_reference	state_province	varchar	30
master_site_reference	state_province_designation	varchar	50	√		null
method_codes	create_date	date	10
method_codes	method_code	varchar	6
method_codes	method_description	varchar	100
method_codes	modify_date	timestamp	19			current_timestamp()
migrations	batch	int	10
migrations	id	int unsigned	10		√
migrations	migration	varchar	255
mobile_group_species	active_status	enum	8
mobile_group_species	create_date	date	10
mobile_group_species	group_code	varchar	6
mobile_group_species	modify_date	timestamp	19			current_timestamp()
mobile_group_species	species_code	varchar	6
mobile_group_species_active	group_code	varchar	8
mobile_group_species_active	species_code	char	6
mobile_size_bins	create_date	date	10
mobile_size_bins	mobile_bin_max	varchar	5
mobile_size_bins	mobile_bin_min	varchar	5
mobile_size_bins	mobile_size_bin	varchar	3
mobile_size_bins	mobile_size_bin_description	varchar	100
mobile_size_bins	mobile_sort_order	int	10
monitoring_groups	create_date	date	10
monitoring_groups	group_code	varchar	8
mussel_depth_numbers	create_date	date	10
mussel_depth_numbers	modify_date	timestamp	19			current_timestamp()
mussel_depth_numbers	mussel_depth_number	int	10
mussel_depth_numbers	mussel_depth_number_description	varchar	200
mussel_depth_qualifiers	qualifier_code	varchar	6
mussel_depths	create_date	date	10
mussel_depths	group_code	varchar	8
mussel_depths	modify_date	timestamp	19			current_timestamp()
mussel_depths	mussel_depth_bin	int	10
mussel_depths	mussel_depth_number	int	10
mussel_depths	mussel_depth_qualifier	varchar	6
mussel_depths	quadrat_code	varchar	6
mussel_depths	site_code	char	6
mussel_depths	species_code	char	6
mussel_depths	survey_date	date	10
mussel_depths	survey_type_code	varchar	30
mussel_depths	target_assemblage	varchar	20
mussel_depths_active	create_date	date	10
mussel_depths_active	group_code	varchar	8
mussel_depths_active	modify_date	timestamp	19			current_timestamp()
mussel_depths_active	mussel_depth_bin	int	10
mussel_depths_active	mussel_depth_number	int	10
mussel_depths_active	mussel_depth_qualifier	varchar	6
mussel_depths_active	quadrat_code	varchar	6
mussel_depths_active	site_code	char	6
mussel_depths_active	species_code	char	6
mussel_depths_active	survey_date	date	10
mussel_depths_active	survey_type_code	varchar	30
mussel_depths_active	target_assemblage	varchar	20
mussel_layer_codes	create_date	date	10
mussel_layer_codes	modify_date	timestamp	19			current_timestamp()
mussel_layer_codes	mussel_layer_code	varchar	6
mussel_layer_codes	mussel_layer_description	varchar	200
mussel_size_depth_bins	create_date	date	10
mussel_size_depth_bins	mussel_size_bin_description	varchar	100
mussel_size_depth_bins	mussel_size_bin_max	varchar	5
mussel_size_depth_bins	mussel_size_bin_min	varchar	5
mussel_size_depth_bins	mussel_size_depth_bin	int	10
mussel_size_depth_bins	mussel_sort_order	int	10
mussel_size_depth_group_species	active_status	enum	8
mussel_size_depth_group_species	create_date	date	10
mussel_size_depth_group_species	group_code	varchar	6
mussel_size_depth_group_species	modify_date	timestamp	19			current_timestamp()
mussel_size_depth_group_species	species_code	char	6
mussel_size_depth_group_species_active	group_code	varchar	8
mussel_size_depth_group_species_active	species_code	char	6
mussel_size_qualifiers	qualifier_code	varchar	6
mussel_sizes	create_date	date	10
mussel_sizes	group_code	varchar	8
mussel_sizes	modify_date	timestamp	19			current_timestamp()
mussel_sizes	mussel_layer_code	varchar	6
mussel_sizes	mussel_size_bin	int	10
mussel_sizes	mussel_size_count	int unsigned	10
mussel_sizes	mussel_size_qualifier	varchar	6
mussel_sizes	quadrat_code	varchar	6
mussel_sizes	site_code	char	6
mussel_sizes	species_code	char	6
mussel_sizes	survey_date	date	10
mussel_sizes	survey_type_code	varchar	30
mussel_sizes	target_assemblage	varchar	20
mussel_sizes_active	create_date	date	10
mussel_sizes_active	group_code	varchar	8
mussel_sizes_active	modify_date	timestamp	19			current_timestamp()
mussel_sizes_active	mussel_layer_code	varchar	6
mussel_sizes_active	mussel_size_bin	int	10
mussel_sizes_active	mussel_size_count	int unsigned	10
mussel_sizes_active	mussel_size_qualifier	varchar	6
mussel_sizes_active	quadrat_code	varchar	6
mussel_sizes_active	site_code	char	6
mussel_sizes_active	species_code	char	6
mussel_sizes_active	survey_date	date	10
mussel_sizes_active	survey_type_code	varchar	30
mussel_sizes_active	target_assemblage	varchar	20
mussel_watch_sites	comments	varchar	100	√		null
mussel_watch_sites	create_date	date	10
mussel_watch_sites	established_date	date	10
mussel_watch_sites	site_code	char	6
non_native_abundance_codes	create_date	date	10
non_native_abundance_codes	non_native_abundance_code	varchar	3
non_native_abundance_codes	non_native_abundance_description	varchar	8
non_native_species	active_status	enum	8
non_native_species	common_name	varchar	40
non_native_species	create_date	date	10
non_native_species	modify_date	timestamp	19			current_timestamp()
non_native_species	non_native_sort	int	10
non_native_species	species	varchar	40
non_native_species	species_code	varchar	6
nps_entered	create_date	date	10
nps_entered	group_code	varchar	8
nps_entered	modify_date	timestamp	19			current_timestamp()
nps_entered	quatraplot_code	varchar	4
nps_entered	site_code	char	6
nps_entered	survey_date	date	10
nps_entered	survey_type_code	varchar	30
nps_entered	target_assemblage	varchar	20
oil_spill_sites	established_date	date	10
oil_spill_sites	site_code	char	6
other_sites	comments	varchar	100	√		null
other_sites	create_date	date	10
other_sites	established_date	date	10
other_sites	other_survey_name	varchar	25
other_sites	site_code	char	6
password_resets	created_at	timestamp	19	√		null
password_resets	email	varchar	255
password_resets	token	varchar	255
photo_plot_core_species	active_status	enum	8
photo_plot_core_species	create_date	date	10
photo_plot_core_species	modify_date	timestamp	19			current_timestamp()
photo_plot_core_species	species_code	varchar	6
photo_plot_core_species_active	species_code	varchar	6
photo_plot_group_species	group_code	char	6
photo_plot_group_species	species_code	char	6
photo_plot_group_species_active	group_code	char	6
photo_plot_group_species_active	species_code	char	6
photo_plot_groups	group_code	varchar	8
photo_plot_groups_active	group_code	varchar	8
photo_plot_info	active_status	enum	8
photo_plot_info	comments	varchar	100	√		null
photo_plot_info	create_date	date	10
photo_plot_info	end_date	date	10	√		null
photo_plot_info	established_date	date	10
photo_plot_info	modify_date	timestamp	19			current_timestamp()
photo_plot_info	photo_plot_area	float	7,3
photo_plot_info	quadrat_code	varchar	6
photo_plot_info	site_code	char	6
photo_plot_info	target_assemblage	varchar	20
photo_plot_info_active	quadrat_code	varchar	6
photo_plot_info_active	site_code	char	6
photo_plot_info_active	target_assemblage	varchar	20
photo_plot_layer_codes	create_date	date	10
photo_plot_layer_codes	layer_code	char	4
photo_plot_layer_codes	modify_date	timestamp	19			current_timestamp()
photo_plot_layer_codes	sort_order	int	10
photo_plot_layer_codes	species_code	char	6
photo_plot_layer_rules	bottom_layer	varchar	6
photo_plot_layer_rules	comments	varchar	500	√		null
photo_plot_layer_rules	create_date	date	10
photo_plot_layer_rules	layer_to_use	enum	12
photo_plot_layer_rules	modify_date	timestamp	19			current_timestamp()
photo_plot_layer_rules	top_layer	varchar	6
photo_plot_layer_rules_onp	bottom_layer	varchar	6
photo_plot_layer_rules_onp	comments	varchar	500	√		null
photo_plot_layer_rules_onp	create_date	date	10
photo_plot_layer_rules_onp	layer_to_use	enum	12
photo_plot_layer_rules_onp	modify_date	timestamp	19			current_timestamp()
photo_plot_layer_rules_onp	top_layer	varchar	6
photo_plot_layers	bottom_layer	varchar	6
photo_plot_layers	create_date	date	10
photo_plot_layers	data_type	enum	5			test
photo_plot_layers	group_code	varchar	8
photo_plot_layers	method_code	varchar	6
photo_plot_layers	modify_date	timestamp	19			current_timestamp()
photo_plot_layers	quadrat_code	varchar	6
photo_plot_layers	quadrat_location	varchar	10
photo_plot_layers	qualifier_code	varchar	6
photo_plot_layers	site_code	char	6
photo_plot_layers	survey_date	date	10
photo_plot_layers	target_assemblage	varchar	20
photo_plot_layers	top_layer	varchar	6
photo_plot_layers_active	bottom_layer	varchar	6
photo_plot_layers_active	create_date	date	10
photo_plot_layers_active	data_type	enum	5			test
photo_plot_layers_active	group_code	varchar	8
photo_plot_layers_active	method_code	varchar	6
photo_plot_layers_active	modify_date	timestamp	19			current_timestamp()
photo_plot_layers_active	quadrat_code	varchar	6
photo_plot_layers_active	quadrat_location	varchar	10
photo_plot_layers_active	qualifier_code	varchar	6
photo_plot_layers_active	site_code	char	6
photo_plot_layers_active	survey_date	date	10
photo_plot_layers_active	target_assemblage	varchar	20
photo_plot_layers_active	top_layer	varchar	6
photo_plot_layers_onp	create_date	date	10
photo_plot_layers_onp	group_code	varchar	8
photo_plot_layers_onp	method_code	varchar	6
photo_plot_layers_onp	modify_date	timestamp	19			current_timestamp()
photo_plot_layers_onp	quadrat_code	varchar	6
photo_plot_layers_onp	qualifier_code	varchar	6
photo_plot_layers_onp	site_code	char	6
photo_plot_layers_onp	survey_date	date	10
photo_plot_layers_onp	tally	int	10
photo_plot_layers_onp	target_assemblage	varchar	20
photo_plot_layers_onp	taxon_1	varchar	6
photo_plot_layers_onp	taxon_2	varchar	6
photo_plot_layers_onp	total_points	int	10
photo_plot_layers_summary	group_code	varchar	8
photo_plot_layers_summary	method_code	varchar	6
photo_plot_layers_summary	percent_cover	int unsigned	10
photo_plot_layers_summary	quadrat_code	varchar	6
photo_plot_layers_summary	qualifier_code	varchar	6
photo_plot_layers_summary	site_code	char	6
photo_plot_layers_summary	species_code	char	6
photo_plot_layers_summary	summary_create_date	date	10	√		null
photo_plot_layers_summary	survey_date	date	10
photo_plot_layers_summary	target_assemblage	varchar	20
photo_plot_layers_summary_active	group_code	varchar	8
photo_plot_layers_summary_active	method_code	varchar	6
photo_plot_layers_summary_active	percent_cover	int unsigned	10
photo_plot_layers_summary_active	quadrat_code	varchar	6
photo_plot_layers_summary_active	qualifier_code	varchar	6
photo_plot_layers_summary_active	site_code	char	6
photo_plot_layers_summary_active	species_code	char	6
photo_plot_layers_summary_active	summary_create_date	date	10	√		null
photo_plot_layers_summary_active	survey_date	date	10
photo_plot_layers_summary_active	target_assemblage	varchar	20
photo_plot_methods	method_code	varchar	6
photo_plot_notes	create_date	date	10
photo_plot_notes	group_code	varchar	8
photo_plot_notes	modify_date	timestamp	19			current_timestamp()
photo_plot_notes	photo_plot_note	text	65535	√		null
photo_plot_notes	quadrat_code	varchar	6
photo_plot_notes	site_code	char	6
photo_plot_notes	survey_date	date	10
photo_plot_notes	target_assemblage	varchar	20
photo_plot_notes_active	create_date	date	10
photo_plot_notes_active	group_code	varchar	8
photo_plot_notes_active	modify_date	timestamp	19			current_timestamp()
photo_plot_notes_active	photo_plot_note	text	65535	√		null
photo_plot_notes_active	quadrat_code	varchar	6
photo_plot_notes_active	site_code	char	6
photo_plot_notes_active	survey_date	date	10
photo_plot_notes_active	target_assemblage	varchar	20
photo_plot_photoquad	create_date	date	10	√		null
photo_plot_photoquad	marine_season_code	char	4
photo_plot_photoquad	marine_species_name	varchar	50
photo_plot_photoquad	method_code	varchar	6
photo_plot_photoquad	modify_date	timestamp	19			current_timestamp()
photo_plot_photoquad	percent_cover	int unsigned	10
photo_plot_photoquad	photo_target_code	char	3
photo_plot_photoquad	quadrat_code	varchar	6
photo_plot_photoquad	site_code	char	6
photo_plot_photoquad_active	create_date	date	10	√		null
photo_plot_photoquad_active	marine_season_code	char	4
photo_plot_photoquad_active	marine_species_name	varchar	50
photo_plot_photoquad_active	method_code	varchar	6
photo_plot_photoquad_active	modify_date	timestamp	19			current_timestamp()
photo_plot_photoquad_active	percent_cover	int unsigned	10
photo_plot_photoquad_active	photo_target_code	char	3
photo_plot_photoquad_active	quadrat_code	varchar	6
photo_plot_photoquad_active	site_code	char	6
photo_plot_photoquad_summary	group_code	varchar	8
photo_plot_photoquad_summary	method_code	varchar	6
photo_plot_photoquad_summary	modify_date	date	10	√		null
photo_plot_photoquad_summary	percent_cover	int unsigned	10
photo_plot_photoquad_summary	quadrat_code	varchar	6
photo_plot_photoquad_summary	qualifier_code	varchar	6
photo_plot_photoquad_summary	site_code	char	6
photo_plot_photoquad_summary	species_code	char	6
photo_plot_photoquad_summary	survey_date	date	10
photo_plot_photoquad_summary	target_assemblage	varchar	20
photo_plot_photoquad_summary_active	group_code	varchar	8
photo_plot_photoquad_summary_active	method_code	varchar	6
photo_plot_photoquad_summary_active	modify_date	date	10	√		null
photo_plot_photoquad_summary_active	percent_cover	int unsigned	10
photo_plot_photoquad_summary_active	quadrat_code	varchar	6
photo_plot_photoquad_summary_active	qualifier_code	varchar	6
photo_plot_photoquad_summary_active	site_code	char	6
photo_plot_photoquad_summary_active	species_code	char	6
photo_plot_photoquad_summary_active	survey_date	date	10
photo_plot_photoquad_summary_active	target_assemblage	varchar	20
photo_plot_quadrat_codes	create_date	date	10
photo_plot_quadrat_codes	quadrat_code	varchar	6
photo_plot_quadrat_locations	create_date	date	10
photo_plot_quadrat_locations	quadrat_location	varchar	10
photo_plot_quadrat_locations	quadrat_location_description	varchar	100
photo_plot_qualifiers	qualifier_code	varchar	6
photo_plot_supplemental_species	active_status	enum	8
photo_plot_supplemental_species	create_date	date	10
photo_plot_supplemental_species	group_code	varchar	6
photo_plot_supplemental_species	modify_date	timestamp	19			current_timestamp()
photo_plot_supplemental_species	species_code	varchar	6
photo_plot_supplemental_species_active	group_code	varchar	6
photo_plot_supplemental_species_active	species_code	varchar	6
photo_plot_target_assemblages	create_date	date	10
photo_plot_target_assemblages	target_assemblage	varchar	20
photo_plot_understory_layers_summary	group_code	varchar	8
photo_plot_understory_layers_summary	method_code	varchar	6
photo_plot_understory_layers_summary	percent_cover	int unsigned	10
photo_plot_understory_layers_summary	quadrat_code	varchar	6
photo_plot_understory_layers_summary	qualifier_code	varchar	6
photo_plot_understory_layers_summary	site_code	char	6
photo_plot_understory_layers_summary	species_code	char	6
photo_plot_understory_layers_summary	summary_create_date	date	10	√		null
photo_plot_understory_layers_summary	survey_date	date	10
photo_plot_understory_layers_summary	target_assemblage	varchar	20
photo_plots	create_date	date	10
photo_plots	group_code	varchar	8
photo_plots	method_code	varchar	6
photo_plots	modify_date	timestamp	19			current_timestamp()
photo_plots	percent_cover	decimal unsigned	5,2
photo_plots	photo_plot_qualifier_code	varchar	6
photo_plots	quadrat_code	varchar	6
photo_plots	site_code	char	6
photo_plots	species_code	char	6
photo_plots	survey_date	date	10
photo_plots	target_assemblage	varchar	20
photo_plots_active	create_date	date	10
photo_plots_active	group_code	varchar	8
photo_plots_active	method_code	varchar	6
photo_plots_active	modify_date	timestamp	19			current_timestamp()
photo_plots_active	percent_cover	int unsigned	10
photo_plots_active	quadrat_code	varchar	6
photo_plots_active	qualifier_code	varchar	6
photo_plots_active	site_code	char	6
photo_plots_active	species_code	char	6
photo_plots_active	survey_date	date	10
photo_plots_active	target_assemblage	varchar	20
photo_target_codes	create_date	date	10	√		null
photo_target_codes	photo_target_code	char	3
photo_target_codes	target_assemblage	varchar	20
postelsia	create_date	date	10
postelsia	group_code	varchar	8
postelsia	location	decimal	2,1
postelsia	meter	decimal	3,1
postelsia	method_code	varchar	6
postelsia	modify_date	timestamp	19			current_timestamp()
postelsia	plot_code	varchar	6
postelsia	postelsia_count	int unsigned	10
postelsia	postelsia_direction_code	varchar	10
postelsia	postelsia_qualifier_code	varchar	6
postelsia	site_code	char	6
postelsia	species_code	char	6
postelsia	survey_date	date	10
postelsia	target_assemblage	varchar	20
postelsia_active	create_date	date	10
postelsia_active	group_code	varchar	8
postelsia_active	location	decimal	2,1
postelsia_active	meter	decimal	3,1
postelsia_active	method_code	varchar	6
postelsia_active	modify_date	timestamp	19			current_timestamp()
postelsia_active	plot_code	varchar	6
postelsia_active	postelsia_count	int unsigned	10
postelsia_active	postelsia_direction_code	varchar	10
postelsia_active	postelsia_qualifier_code	varchar	6
postelsia_active	site_code	char	6
postelsia_active	species_code	char	6
postelsia_active	survey_date	date	10
postelsia_active	target_assemblage	varchar	20
postelsia_direction_codes	create_date	date	10
postelsia_direction_codes	postelsia_direction_code	varchar	10
postelsia_direction_codes	postelsia_direction_description	varchar	150
postelsia_group_species	active_status	enum	8
postelsia_group_species	create_date	date	10
postelsia_group_species	group_code	varchar	8
postelsia_group_species	modify_date	timestamp	19			current_timestamp()
postelsia_group_species	species_code	char	6
postelsia_group_species_active	group_code	varchar	8
postelsia_group_species_active	species_code	char	6
postelsia_info	active_status	enum	8
postelsia_info	comments	varchar	100	√		null
postelsia_info	create_date	date	10
postelsia_info	end_date	date	10	√		null
postelsia_info	established_date	date	10
postelsia_info	length_m	int	10
postelsia_info	modify_date	timestamp	19			current_timestamp()
postelsia_info	plot_area_m2	int	10
postelsia_info	plot_code	varchar	6
postelsia_info	site_code	char	6
postelsia_info	standard_location_number	varchar	3	√		null
postelsia_info	standard_location_width	varchar	3	√		null
postelsia_info	swath_location_number	varchar	3	√		null
postelsia_info	swath_location_width	varchar	3	√		null
postelsia_info	target_assemblage	varchar	20
postelsia_info_active	plot_code	varchar	6
postelsia_info_active	site_code	char	6
postelsia_info_active	target_assemblage	varchar	20
postelsia_methods	method_code	varchar	6
postelsia_notes	create_date	date	10
postelsia_notes	group_code	varchar	8
postelsia_notes	modify_date	timestamp	19			current_timestamp()
postelsia_notes	plot_code	varchar	6
postelsia_notes	postelsia_note	text	65535	√		null
postelsia_notes	site_code	char	6
postelsia_notes	survey_date	date	10
postelsia_notes	target_assemblage	varchar	20
postelsia_notes_active	create_date	date	10
postelsia_notes_active	group_code	varchar	8
postelsia_notes_active	modify_date	timestamp	19			current_timestamp()
postelsia_notes_active	plot_code	varchar	6
postelsia_notes_active	postelsia_note	text	65535	√		null
postelsia_notes_active	site_code	char	6
postelsia_notes_active	survey_date	date	10
postelsia_notes_active	target_assemblage	varchar	20
postelsia_qualifiers	postelsia_qualifier_code	varchar	6
qualifier_codes	create_date	date	10
qualifier_codes	modify_date	timestamp	19			current_timestamp()
qualifier_codes	qualifier_code	varchar	6
qualifier_codes	qualifier_description	varchar	100
quatraplot_codes	create_date	date	10
quatraplot_codes	quatraplot_code	varchar	6
recon_abundance_codes	create_date	date	10
recon_abundance_codes	recon_abundance_code	varchar	3
recon_abundance_codes	recon_abundance_description	varchar	8
recon_condition_codes	create_date	date	10
recon_condition_codes	recon_condition_code	varchar	3
recon_condition_codes	recon_condition_description	varchar	20
recon_group_species	active_status	enum	8
recon_group_species	create_date	date	10
recon_group_species	group_code	varchar	6
recon_group_species	modify_date	timestamp	19			current_timestamp()
recon_group_species	species_code	varchar	6
recon_group_species_active	group_code	varchar	6
recon_group_species_active	species_code	varchar	6
recon_notes	create_date	date	10
recon_notes	group_code	varchar	8
recon_notes	modify_date	timestamp	19			current_timestamp()
recon_notes	recon_note	text	65535	√		null
recon_notes	site_code	char	6
recon_notes	species_code	char	6
recon_notes	survey_date	date	10
recon_notes_active	create_date	date	10
recon_notes_active	group_code	varchar	8
recon_notes_active	modify_date	timestamp	19			current_timestamp()
recon_notes_active	recon_note	text	65535	√		null
recon_notes_active	site_code	char	6
recon_notes_active	species_code	char	6
recon_notes_active	survey_date	date	10
recon_recruitment_codes	create_date	date	10
recon_recruitment_codes	recon_recruitment_code	varchar	3
recon_recruitment_codes	recon_recruitment_description	varchar	20
reef_sand_people_count_values	create_date	date	10
reef_sand_people_count_values	reef_sand_people_bin_max	varchar	5
reef_sand_people_count_values	reef_sand_people_bin_min	varchar	5
reef_sand_people_count_values	reef_sand_people_count_bin_description	varchar	100
reef_sand_people_count_values	reef_sand_people_count_value	varchar	3
reef_sand_people_count_values	reef_sand_people_sort_order	int	10
restricted_site_reference	asbs_name	varchar	100	√		null
restricted_site_reference	bioregion	varchar	50	√		null
restricted_site_reference	comments	varchar	300
restricted_site_reference	country	varchar	30
restricted_site_reference	county	varchar	30
restricted_site_reference	county_designation	varchar	50	√		null
restricted_site_reference	create_date	date	10
restricted_site_reference	georegion	varchar	50	√		null
restricted_site_reference	island	varchar	30
restricted_site_reference	latitude	float	12,8
restricted_site_reference	longitude	float	10,5
restricted_site_reference	marine_site_name	varchar	50
restricted_site_reference	marine_sort_order	int unsigned	10
restricted_site_reference	modify_date	timestamp	19			current_timestamp()
restricted_site_reference	mpa_designation	varchar	10	√		null
restricted_site_reference	mpa_lt_region	varchar	50	√		null
restricted_site_reference	mpa_name	varchar	50	√		null
restricted_site_reference	mpa_region	varchar	50	√		null
restricted_site_reference	national_designation	varchar	50	√		null
restricted_site_reference	nms_name	varchar	50	√		null
restricted_site_reference	nps_network_code	varchar	4			NONE
restricted_site_reference	other_designation	varchar	50	√		null
restricted_site_reference	pisco_code	char	6	√		null
restricted_site_reference	restricted_site_code	char	6
restricted_site_reference	restricted_site_name	varchar	50
restricted_site_reference	site_code	char	6
restricted_site_reference	site_filename	varchar	50	√		null
restricted_site_reference	site_link	varchar	255
restricted_site_reference	state_province	varchar	30
restricted_site_reference	state_province_designation	varchar	50	√		null
role_codes	create_date	date	10
role_codes	role_code	varchar	12
role_codes	role_description	varchar	100
sea_star_color_count_sizes	color	enum	17
sea_star_color_count_sizes	count_qualifier_code	varchar	6
sea_star_color_count_sizes	create_date	date	10
sea_star_color_count_sizes	group_code	varchar	8
sea_star_color_count_sizes	method_code	varchar	6
sea_star_color_count_sizes	modify_date	timestamp	19			current_timestamp()
sea_star_color_count_sizes	plot_code	varchar	6
sea_star_color_count_sizes	sea_star_color_count	int unsigned	10
sea_star_color_count_sizes	sea_star_size_bin	varchar	3
sea_star_color_count_sizes	site_code	char	6
sea_star_color_count_sizes	size_qualifier_code	varchar	6
sea_star_color_count_sizes	species_code	char	6
sea_star_color_count_sizes	survey_date	date	10
sea_star_color_count_sizes	target_assemblage	varchar	20
sea_star_counts	count_qualifier_code	varchar	6
sea_star_counts	create_date	date	10
sea_star_counts	group_code	varchar	8
sea_star_counts	method_code	varchar	6
sea_star_counts	modify_date	timestamp	19			current_timestamp()
sea_star_counts	plot_code	varchar	6
sea_star_counts	sea_star_count	int unsigned	10
sea_star_counts	site_code	char	6
sea_star_counts	species_code	char	6
sea_star_counts	survey_date	date	10
sea_star_counts	target_assemblage	varchar	20
sea_star_disease_codes	create_date	date	10
sea_star_disease_codes	modify_date	timestamp	19			current_timestamp()
sea_star_disease_codes	sea_star_disease_code	varchar	8
sea_star_disease_codes	sea_star_disease_description	varchar	200
sea_star_disease_count_sizes	count_qualifier_code	varchar	6
sea_star_disease_count_sizes	create_date	date	10
sea_star_disease_count_sizes	group_code	varchar	8
sea_star_disease_count_sizes	method_code	varchar	6
sea_star_disease_count_sizes	modify_date	timestamp	19			current_timestamp()
sea_star_disease_count_sizes	plot_code	varchar	6
sea_star_disease_count_sizes	sea_star_disease_code	varchar	8
sea_star_disease_count_sizes	sea_star_size_bin	varchar	3
sea_star_disease_count_sizes	sea_star_size_count	int unsigned	10
sea_star_disease_count_sizes	site_code	char	6
sea_star_disease_count_sizes	size_qualifier_code	varchar	6
sea_star_disease_count_sizes	species_code	char	6
sea_star_disease_count_sizes	survey_date	date	10
sea_star_disease_count_sizes	target_assemblage	varchar	20
sea_star_disease_count_sizes_active	count_qualifier_code	varchar	6
sea_star_disease_count_sizes_active	create_date	date	10
sea_star_disease_count_sizes_active	group_code	varchar	8
sea_star_disease_count_sizes_active	method_code	varchar	6
sea_star_disease_count_sizes_active	modify_date	timestamp	19			current_timestamp()
sea_star_disease_count_sizes_active	plot_code	varchar	6
sea_star_disease_count_sizes_active	sea_star_disease_code	varchar	8
sea_star_disease_count_sizes_active	sea_star_size_bin	varchar	3
sea_star_disease_count_sizes_active	sea_star_size_count	int unsigned	10
sea_star_disease_count_sizes_active	site_code	char	6
sea_star_disease_count_sizes_active	size_qualifier_code	varchar	6
sea_star_disease_count_sizes_active	species_code	char	6
sea_star_disease_count_sizes_active	survey_date	date	10
sea_star_disease_count_sizes_active	target_assemblage	varchar	20
sea_star_group_species	active_status	enum	8
sea_star_group_species	create_date	date	10
sea_star_group_species	group_code	varchar	8
sea_star_group_species	modify_date	timestamp	19			current_timestamp()
sea_star_group_species	species_code	char	6
sea_star_group_species_active	group_code	varchar	8
sea_star_group_species_active	species_code	char	6
sea_star_notes	create_date	date	10
sea_star_notes	group_code	varchar	8
sea_star_notes	modify_date	timestamp	19			current_timestamp()
sea_star_notes	plot_code	varchar	6
sea_star_notes	sea_star_note	text	65535	√		null
sea_star_notes	site_code	char	6
sea_star_notes	survey_date	date	10
sea_star_notes	target_assemblage	varchar	20
sea_star_notes_active	create_date	date	10
sea_star_notes_active	group_code	varchar	8
sea_star_notes_active	modify_date	timestamp	19			current_timestamp()
sea_star_notes_active	plot_code	varchar	6
sea_star_notes_active	sea_star_note	text	65535	√		null
sea_star_notes_active	site_code	char	6
sea_star_notes_active	survey_date	date	10
sea_star_notes_active	target_assemblage	varchar	20
sea_star_plot_info	active_status	enum	8
sea_star_plot_info	comments	varchar	100	√		null
sea_star_plot_info	create_date	date	10
sea_star_plot_info	end_date	date	10	√		null
sea_star_plot_info	established_date	date	10
sea_star_plot_info	modify_date	timestamp	19			current_timestamp()
sea_star_plot_info	plot_code	varchar	6
sea_star_plot_info	site_code	char	6
sea_star_plot_info	target_assemblage	varchar	20
sea_star_plot_info_active	plot_code	varchar	6
sea_star_plot_info_active	site_code	char	6
sea_star_plot_info_active	target_assemblage	varchar	20
sea_star_size_bins	create_date	date	10
sea_star_size_bins	sea_star_bin_max	varchar	5
sea_star_size_bins	sea_star_bin_min	varchar	5
sea_star_size_bins	sea_star_size_bin	varchar	3
sea_star_size_bins	sea_star_size_bin_description	varchar	100
sea_star_size_bins	sea_star_sort_order	int	10
seagrass_conditions	abraded	varchar	3
seagrass_conditions	bleached_brown	varchar	3
seagrass_conditions	create_date	date	10
seagrass_conditions	flowers	varchar	3
seagrass_conditions	group_code	varchar	8
seagrass_conditions	melobesia	varchar	3
seagrass_conditions	modify_date	timestamp	19			current_timestamp()
seagrass_conditions	site_code	char	6
seagrass_conditions	smithora	varchar	3
seagrass_conditions	survey_date	date	10
seagrass_conditions_active	abraded	varchar	3
seagrass_conditions_active	bleached_brown	varchar	3
seagrass_conditions_active	create_date	date	10
seagrass_conditions_active	flowers	varchar	3
seagrass_conditions_active	group_code	varchar	8
seagrass_conditions_active	melobesia	varchar	3
seagrass_conditions_active	modify_date	timestamp	19			current_timestamp()
seagrass_conditions_active	site_code	char	6
seagrass_conditions_active	smithora	varchar	3
seagrass_conditions_active	survey_date	date	10
seagrass_cover	approx_cover	int	10
seagrass_cover	create_date	date	10
seagrass_cover	group_code	varchar	8
seagrass_cover	modify_date	timestamp	19			current_timestamp()
seagrass_cover	site_code	char	6
seagrass_cover	species_code	char	6
seagrass_cover	survey_date	date	10
seagrass_cover	survey_type_code	varchar	30
seagrass_cover	target_assemblage	varchar	20
seagrass_cover	transect_code	varchar	6
seagrass_cover_active	approx_cover	int	10
seagrass_cover_active	create_date	date	10
seagrass_cover_active	group_code	varchar	8
seagrass_cover_active	modify_date	timestamp	19			current_timestamp()
seagrass_cover_active	site_code	char	6
seagrass_cover_active	species_code	char	6
seagrass_cover_active	survey_date	date	10
seagrass_cover_active	survey_type_code	varchar	30
seagrass_cover_active	target_assemblage	varchar	20
seagrass_cover_active	transect_code	varchar	6
seagrass_cover_group_species	active_status	enum	8
seagrass_cover_group_species	create_date	date	10
seagrass_cover_group_species	group_code	varchar	8
seagrass_cover_group_species	modify_date	timestamp	19			current_timestamp()
seagrass_cover_group_species	species_code	char	6
seagrass_cover_group_species_active	group_code	varchar	8
seagrass_cover_group_species_active	species_code	char	6
seagrass_thickness	create_date	date	10
seagrass_thickness	group_code	varchar	8
seagrass_thickness	modify_date	timestamp	19			current_timestamp()
seagrass_thickness	point	varchar	3
seagrass_thickness	site_code	char	6
seagrass_thickness	species_code	char	6
seagrass_thickness	survey_date	date	10
seagrass_thickness	survey_type_code	varchar	30
seagrass_thickness	target_assemblage	varchar	20
seagrass_thickness	thickness	decimal unsigned	4,2
seagrass_thickness	transect_code	varchar	6
seagrass_thickness_active	create_date	date	10
seagrass_thickness_active	group_code	varchar	8
seagrass_thickness_active	modify_date	timestamp	19			current_timestamp()
seagrass_thickness_active	point	varchar	3
seagrass_thickness_active	site_code	char	6
seagrass_thickness_active	species_code	char	6
seagrass_thickness_active	survey_date	date	10
seagrass_thickness_active	survey_type_code	varchar	30
seagrass_thickness_active	target_assemblage	varchar	20
seagrass_thickness_active	thickness	decimal unsigned	4,2
seagrass_thickness_active	transect_code	varchar	6
seagrass_thickness_group_species	active_status	enum	8
seagrass_thickness_group_species	create_date	date	10
seagrass_thickness_group_species	group_code	varchar	8
seagrass_thickness_group_species	modify_date	timestamp	19			current_timestamp()
seagrass_thickness_group_species	species_code	char	6
seagrass_thickness_group_species_active	group_code	varchar	8
seagrass_thickness_group_species_active	species_code	char	6
secondary_plot_info	active_status	enum	8
secondary_plot_info	create_date	date	10
secondary_plot_info	modify_date	timestamp	19			current_timestamp()
secondary_plot_info	quatraplot_code	varchar	6
secondary_plot_info	site_code	char	6
secondary_plot_info	survey_type_code	varchar	30
secondary_plot_info	target_assemblage	varchar	20
secondary_plot_info_active	quatraplot_code	varchar	6
secondary_plot_info_active	site_code	char	6
secondary_plot_info_active	survey_type_code	varchar	30
secondary_plot_info_active	target_assemblage	varchar	20
site_not_sampled	create_date	date	10
site_not_sampled	group_code	varchar	8
site_not_sampled	marine_common_season	int unsigned	10
site_not_sampled	modify_date	timestamp	19			current_timestamp()
site_not_sampled	site_code	char	6
site_not_sampled	site_not_sampled_notes	text	65535	√		null
site_not_sampled_active	create_date	date	10
site_not_sampled_active	group_code	varchar	8
site_not_sampled_active	marine_common_season	int unsigned	10
site_not_sampled_active	modify_date	timestamp	19			current_timestamp()
site_not_sampled_active	site_code	char	6
site_not_sampled_active	site_not_sampled_notes	text	65535	√		null
size_qualifiers	size_qualifier_code	varchar	6
subsampled_plot_info	create_date	date	10
subsampled_plot_info	modify_date	timestamp	19			current_timestamp()
subsampled_plot_info	multiplier	decimal	5,4
subsampled_plot_info	quatraplot_code	varchar	6
subsampled_plot_info	site_code	char	6
subsampled_plot_info	sub_plot_code	varchar	6
subsampled_plot_info	survey_type_code	varchar	30
subsampled_plot_info	target_assemblage	varchar	20
survey_type_codes	create_date	date	10
survey_type_codes	survey_category	enum	9	√		null
survey_type_codes	survey_description	varchar	300
survey_type_codes	survey_group	enum	11			sitewide
survey_type_codes	survey_type_code	varchar	30
target_assemblage_species	create_date	date	10
target_assemblage_species	public	enum	4			yes
target_assemblage_species	species_code	char	6
target_assemblage_species	target_assemblage	varchar	20
target_assemblages	active_status	enum	8			active
target_assemblages	create_date	date	10
target_assemblages	modify_date	timestamp	19			current_timestamp()
target_assemblages	target_assemblage	varchar	20
target_assemblages	target_assemblage_description	varchar	1000			see target_assemblage_species
temperature_sites	established_date	date	10
temperature_sites	pisco_code	char	6
temperature_sites	site_code	char	6
tided_temperature_utc	air20_water0	enum	3
tided_temperature_utc	create_date	date	10
tided_temperature_utc	cutoff_ft	varchar	10	√		null
tided_temperature_utc	date_utc	date	10
tided_temperature_utc	flag	int	10			0
tided_temperature_utc	modify_date	timestamp	19			current_timestamp()
tided_temperature_utc	pisco_code	char	6
tided_temperature_utc	qc_complete	enum	4
tided_temperature_utc	replicate	char	3
tided_temperature_utc	temp_celsius	decimal	4,2
tided_temperature_utc	tide_f	decimal	4,2
tided_temperature_utc	time_format	enum	4
tided_temperature_utc	time_utc	varchar	11
tided_temperature_utc	zonetype	char	3
tided_temperature_utc_active	air20_water0	enum	3
tided_temperature_utc_active	create_date	date	10
tided_temperature_utc_active	cutoff_ft	varchar	10	√		null
tided_temperature_utc_active	date_utc	date	10
tided_temperature_utc_active	flag	int	10			0
tided_temperature_utc_active	modify_date	timestamp	19			current_timestamp()
tided_temperature_utc_active	pisco_code	char	6
tided_temperature_utc_active	qc_complete	enum	4
tided_temperature_utc_active	replicate	char	3
tided_temperature_utc_active	temp_celsius	decimal	4,2
tided_temperature_utc_active	tide_f	decimal	4,2
tided_temperature_utc_active	time_format	enum	4
tided_temperature_utc_active	time_utc	varchar	11
tided_temperature_utc_active	zonetype	char	3
transect_codes	create_date	date	10
transect_codes	transect_code	varchar	6
transect_core_species	active_status	enum	8
transect_core_species	create_date	date	10
transect_core_species	modify_date	timestamp	19			current_timestamp()
transect_core_species	species_code	varchar	6
transect_core_species_active	species_code	varchar	6
transect_group_species	group_code	varchar	8
transect_group_species	species_code	char	6
transect_group_species_active	group_code	varchar	8
transect_group_species_active	species_code	char	6
transect_groups	group_code	varchar	8
transect_groups_active	group_code	varchar	8
transect_info	active_status	enum	8
transect_info	comments	varchar	100	√		null
transect_info	create_date	date	10
transect_info	end_date	date	10	√		null
transect_info	established_date	date	10
transect_info	modify_date	timestamp	19			current_timestamp()
transect_info	site_code	char	6
transect_info	target_assemblage	varchar	20
transect_info	transect_code	varchar	6
transect_info_active	site_code	char	6
transect_info_active	target_assemblage	varchar	20
transect_info_active	transect_code	varchar	6
transect_methods	method_code	varchar	6
transect_notes	create_date	date	10
transect_notes	group_code	varchar	8
transect_notes	modify_date	timestamp	19			current_timestamp()
transect_notes	site_code	char	6
transect_notes	survey_date	date	10
transect_notes	target_assemblage	varchar	20
transect_notes	transect_code	varchar	6
transect_notes	transect_note	text	65535	√		null
transect_notes_active	create_date	date	10
transect_notes_active	group_code	varchar	8
transect_notes_active	modify_date	timestamp	19			current_timestamp()
transect_notes_active	site_code	char	6
transect_notes_active	survey_date	date	10
transect_notes_active	target_assemblage	varchar	20
transect_notes_active	transect_code	varchar	6
transect_notes_active	transect_note	text	65535	√		null
transect_qualifiers	transect_qualifier_code	varchar	6
transect_supplemental_species	active_status	enum	8
transect_supplemental_species	create_date	date	10
transect_supplemental_species	group_code	varchar	6
transect_supplemental_species	modify_date	timestamp	19			current_timestamp()
transect_supplemental_species	species_code	varchar	6
transect_supplemental_species_active	group_code	varchar	6
transect_supplemental_species_active	species_code	varchar	6
transects	create_date	date	10
transects	group_code	varchar	8
transects	method_code	varchar	6
transects	modify_date	timestamp	19			current_timestamp()
transects	percent_cover	decimal unsigned	5,2
transects	site_code	char	6
transects	species_code	char	6
transects	survey_date	date	10
transects	target_assemblage	varchar	20
transects	transect_code	varchar	6
transects	transect_qualifier_code	varchar	6
transects_active	create_date	date	10
transects_active	group_code	varchar	8
transects_active	method_code	varchar	6
transects_active	modify_date	timestamp	19			current_timestamp()
transects_active	percent_cover	int unsigned	10
transects_active	site_code	char	6
transects_active	species_code	char	6
transects_active	survey_date	date	10
transects_active	target_assemblage	varchar	20
transects_active	transect_code	varchar	6
transects_active	transect_qualifier_code	varchar	6
urchin_count_sizes	count_qualifier_code	varchar	6
urchin_count_sizes	create_date	date	10
urchin_count_sizes	group_code	varchar	8
urchin_count_sizes	method_code	varchar	6
urchin_count_sizes	modify_date	timestamp	19			current_timestamp()
urchin_count_sizes	plot_code	varchar	6
urchin_count_sizes	site_code	char	6
urchin_count_sizes	size_qualifier_code	varchar	6
urchin_count_sizes	species_code	char	6
urchin_count_sizes	survey_date	date	10
urchin_count_sizes	target_assemblage	varchar	20
urchin_count_sizes	urchin_disease_code	varchar	8
urchin_count_sizes	urchin_size_bin	varchar	4
urchin_count_sizes	urchin_size_count	int unsigned	10
urchin_count_sizes_active	count_qualifier_code	varchar	6
urchin_count_sizes_active	create_date	date	10
urchin_count_sizes_active	group_code	varchar	8
urchin_count_sizes_active	method_code	varchar	6
urchin_count_sizes_active	modify_date	timestamp	19			current_timestamp()
urchin_count_sizes_active	plot_code	varchar	6
urchin_count_sizes_active	site_code	char	6
urchin_count_sizes_active	size_qualifier_code	varchar	6
urchin_count_sizes_active	species_code	char	6
urchin_count_sizes_active	survey_date	date	10
urchin_count_sizes_active	target_assemblage	varchar	20
urchin_count_sizes_active	urchin_disease_code	varchar	8
urchin_count_sizes_active	urchin_size_bin	varchar	4
urchin_count_sizes_active	urchin_size_count	int unsigned	10
urchin_disease_codes	create_date	date	10
urchin_disease_codes	modify_date	timestamp	19			current_timestamp()
urchin_disease_codes	urchin_disease_code	varchar	8
urchin_disease_codes	urchin_disease_description	varchar	200
urchin_group_species	active_status	enum	8
urchin_group_species	create_date	date	10
urchin_group_species	group_code	varchar	8
urchin_group_species	modify_date	timestamp	19			current_timestamp()
urchin_group_species	species_code	char	6
urchin_group_species_active	group_code	varchar	8
urchin_group_species_active	species_code	char	6
urchin_notes	create_date	date	10
urchin_notes	group_code	varchar	8
urchin_notes	modify_date	timestamp	19			current_timestamp()
urchin_notes	plot_code	varchar	6
urchin_notes	site_code	char	6
urchin_notes	survey_date	date	10
urchin_notes	target_assemblage	varchar	20
urchin_notes	urchin_note	text	65535	√		null
urchin_notes_active	create_date	date	10
urchin_notes_active	group_code	varchar	8
urchin_notes_active	modify_date	timestamp	19			current_timestamp()
urchin_notes_active	plot_code	varchar	6
urchin_notes_active	site_code	char	6
urchin_notes_active	survey_date	date	10
urchin_notes_active	target_assemblage	varchar	20
urchin_notes_active	urchin_note	text	65535	√		null
urchin_plot_info	active_status	enum	8
urchin_plot_info	comments	varchar	200	√		null
urchin_plot_info	create_date	date	10
urchin_plot_info	end_date	date	10	√		null
urchin_plot_info	established_date	date	10
urchin_plot_info	modify_date	timestamp	19			current_timestamp()
urchin_plot_info	plot_code	varchar	6
urchin_plot_info	site_code	char	6
urchin_plot_info	target_assemblage	varchar	20
urchin_plot_info_active	plot_code	varchar	6
urchin_plot_info_active	site_code	char	6
urchin_plot_info_active	target_assemblage	varchar	20
urchin_size_bins	create_date	date	10
urchin_size_bins	urchin_bin_max	varchar	5
urchin_size_bins	urchin_bin_min	varchar	5
urchin_size_bins	urchin_size_bin	varchar	4
urchin_size_bins	urchin_size_bin_description	varchar	100
urchin_size_bins	urchin_sort_order	int	10
users	created_at	timestamp	19	√		null
users	email	varchar	255
users	id	int unsigned	10		√
users	name	varchar	255
users	password	varchar	255
users	remember_token	varchar	100	√		null
users	updated_at	timestamp	19	√		null
vouchered_sites	comments	varchar	100	√		null
vouchered_sites	create_date	date	10
vouchered_sites	established_date	date	10
vouchered_sites	site_code	char	6
wind_speeds	create_date	date	10
wind_speeds	wind_speed	varchar	3
wind_speeds	wind_speed_description	varchar	100
wind_speeds	wind_speed_sort	int	10
zonetype	description	varchar	50	√		null
zonetype	thetype	varchar	12
zonetype	thezone	char	12
zonetype	zonetype	char	3