zfindb.public contains 2461 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
accession_bank	accbk_pk_id	bigserial	19		√	nextval('accession_bank_accbk_pk_id_seq'::regclass)
average_curation_time_metric	actm_pk_id	bigserial	19		√	nextval('average_curation_time_metric_actm_pk_id_seq'::regclass)
average_time_per_person	actpp_pk_id	bigserial	19		√	nextval('average_time_per_person_actpp_pk_id_seq'::regclass)
amsterdam_file	af_pk_id	bigserial	19		√	nextval('amsterdam_file_af_pk_id_seq'::regclass)
affected_gene_group_member	afgm_pk_id	bigserial	19		√	nextval('affected_gene_group_member_afgm_pk_id_seq'::regclass)
alias_group	aliasgrp_pk_id	bigserial	19		√	nextval('alias_group_aliasgrp_pk_id_seq'::regclass)
alias_scope	aliasscope_pk_id	bigserial	19		√	nextval('alias_scope_aliasscope_pk_id_seq'::regclass)
annual_stats	as_pk_id	bigserial	19		√	nextval('annual_stats_as_pk_id_seq'::regclass)
author	author_pk_id	bigserial	19		√	nextval('author_author_pk_id_seq'::regclass)
author_publication	authorpub_pk_id	bigserial	19		√	nextval('author_publication_authorpub_pk_id_seq'::regclass)
blastdb_order	bdborder_pk_id	bigserial	19		√	nextval('blastdb_order_bdborder_pk_id_seq'::regclass)
blast_database_origination_type	bdot_pk_id	bigserial	19		√	nextval('blast_database_origination_type_bdot_pk_id_seq'::regclass)
bl_plate_tracking	blpt_pk_id	bigserial	19		√	nextval('bl_plate_tracking_blpt_pk_id_seq'::regclass)
blastdb_regen_content	brc_pk_id	bigserial	19		√	nextval('blastdb_regen_content_brc_pk_id_seq'::regclass)
construct_component	cc_pk_id	bigserial	19		√	nextval('construct_component_cc_pk_id_seq'::regclass)
clean_expression_fast_search	cefs_pk_id	bigserial	19		√	nextval('clean_expression_fast_search_new_cefs_pk_id_seq1'::regclass)
company_position	compos_pk_id	bigserial	19		√	nextval('company_position_compos_pk_id_seq'::regclass)
construct_figure	consfig_pk_id	bigserial	19		√	nextval('construct_figure_consfig_pk_id_seq'::regclass)
curator_session	cs_pk_id	bigserial	19		√	nextval('curator_session_cs_pk_id_seq'::regclass)
disease_annotation_model	damo_pk_id	bigserial	19		√	nextval('disease_annotation_model_damo_pk_id_seq'::regclass)
database_info	di_pk_id	bigserial	19		√	nextval('database_info_di_pk_id_seq'::regclass)
daily_indexed_metric	dim_pk_id	bigserial	19		√	nextval('daily_indexed_metric_dim_pk_id_seq'::regclass)
doi_attempts	doia_pk_id	bigserial	19		√	nextval('doi_attempts_doia_pk_id_seq'::regclass)
data_reporting	dr_pk_id	bigserial	19		√	nextval('data_reporting_dr_pk_id_seq'::regclass)
experiment_condition_restricted	ecr_pk_id	bigserial	19		√	nextval('experiment_condition_restricted_ecr_pk_id_seq'::regclass)
expression_figure_stage	efs_pk_id	bigserial	19		√	nextval('expression_figure_stage_efs_pk_id_seq'::regclass)
environment_group	eg_group_pk_id	bigserial	19		√	nextval('environment_group_eg_group_pk_id_seq'::regclass)
eco_go_mapping	egm_pk_id	bigserial	19		√	nextval('eco_go_mapping_egm_pk_id_seq'::regclass)
entrez_to_protein	ep_pk_id	bigserial	19		√	nextval('entrez_to_protein_ep_pk_id_seq'::regclass)
expression_phenotype_term	ept_pk_id	bigserial	19		√	nextval('expression_phenotype_term_ept_pk_id_seq'::regclass)
expression_phenotype_term_controlled_vocab	eptcv_pk_id	bigserial	19		√	nextval('expression_phenotype_term_controlled_vocab_eptcv_pk_id_seq'::regclass)
expression_term_fast_search	etfs_pk_id	bigserial	19		√	nextval('expression_term_fast_search_etfs_pk_id_seq'::regclass)
xpatfs_old	etfs_pk_id	bigserial	19		√	nextval('xpatfs_temp_etfs_pk_id_seq'::regclass)
external_reference	exref_pk_id	bigserial	19		√	nextval('external_reference_exref_pk_id_seq'::regclass)
fish_components	fc_pk_id	bigserial	19		√	nextval('fish_components_fc_pk_id_seq'::regclass)
feature_community_contribution	fcc_pk_id	bigserial	19		√	nextval('feature_community_contribution_fcc_pk_id_seq'::regclass)
foreign_db	fdb_db_pk_id	bigserial	19		√	nextval('foreign_db_fdb_db_pk_id_seq'::regclass)
foreign_db_contains_display_group	fdbcdg_pk_id	bigserial	19		√	nextval('foreign_db_contains_display_group_fdbcdg_pk_id_seq'::regclass)
foreign_db_contains_display_group_member	fdbcdgm_pk_id	bigserial	19		√	nextval('foreign_db_contains_display_group_member_fdbcdgm_pk_id_seq'::regclass)
foreign_db_data_type	fdbdt_pk_id	bigserial	19		√	nextval('foreign_db_data_type_fdbdt_pk_id_seq'::regclass)
feature_assay	featassay_pk_id	bigserial	19		√	nextval('feature_assay_featassay_pk_id_seq'::regclass)
feature_group	fg_group_pk_id	bigserial	19		√	nextval('feature_group_fg_group_pk_id_seq'::regclass)
feature_group_member	fgm_pk_id	bigserial	19		√	nextval('feature_group_member_fgm_pk_id_seq'::regclass)
feature_prefix	fp_pk_id	bigserial	19		√	nextval('feature_prefix_fp_pk_id_seq'::regclass)
feature_stats	fstat_pk_id	bigserial	19		√	nextval('feature_stats_temp_fstat_pk_id_seq'::regclass)
feature_stats_old	fstat_pk_id	bigserial	19		√	nextval('feature_stats_temp_fstat_pk_id_seq1'::regclass)
feature_tracking	ft_pk_id	bigserial	19		√	nextval('feature_tracking_ft_pk_id_seq'::regclass)
feature_type_mutagen_group_member	ftmgm_pk_id	bigserial	19		√	nextval('feature_type_mutagen_group_member_ftmgm_pk_id_seq'::regclass)
feature_type_ordering	fto_pk_id	bigserial	19		√	nextval('feature_type_ordering_fto_pk_id_seq'::regclass)
genotype_component_significance	gcs_pk_id	bigserial	19		√	nextval('genotype_component_significance_gcs_pk_id_seq'::regclass)
gene_description	gd_pk_id	bigserial	19		√	nextval('gene_description_gd_pk_id_seq'::regclass)
genox_fish_annotation_search	genoxfas_pk_id	bigserial	19		√	nextval('genox_fish_annotation_search_genoxfas_pk_id_seq'::regclass)
genox_fish_annotation_search_bkup	genoxfas_pk_id	bigserial	19		√	nextval('genox_fish_annotation_search_bkup_genoxfas_pk_id_seq'::regclass)
genox_fish_annotation_search_temp	genoxfas_pk_id	bigserial	19		√	nextval('genox_fish_annotation_search_temp_genoxfas_pk_id_seq'::regclass)
genotype_figure_fast_search	gffs_serial_id	bigserial	19		√	nextval('genotype_figure_fast_search_new_gffs_serial_id_seq'::regclass)
genotype_group	gg_group_pk_id	bigserial	19		√	nextval('genotype_group_gg_group_pk_id_seq'::regclass)
genox_group	gg_group_pk_id	bigserial	19		√	nextval('genox_group_gg_group_pk_id_seq'::regclass)
genotype_group_member	ggm_pk_id	bigserial	19		√	nextval('genotype_group_member_ggm_pk_id_seq'::regclass)
genox_group_member	ggm_pk_id	bigserial	19		√	nextval('genox_group_member_ggm_pk_id_seq'::regclass)
htp_dataset_alternate_identifier	hdai_pk_id	bigserial	19		√	nextval('htp_dataset_alternate_identifier_hdai_pk_id_seq'::regclass)
htp_dataset_category_tag	hdct_pk_id	bigserial	19		√	nextval('htp_dataset_category_tag_hdct_pk_id_seq'::regclass)
htp_dataset_publication	hdp_pk_id	bigserial	19		√	nextval('htp_dataset_publication_hdp_pk_id_seq'::regclass)
htp_dataset_sample	hds_pk_id	bigserial	19		√	nextval('htp_dataset_sample_hds_pk_id_seq'::regclass)
htp_dataset_sample_detail	hdsd_pk_id	bigserial	19		√	nextval('htp_dataset_sample_detail_hdsd_pk_id_seq'::regclass)
int_data_source	ids_pk_id	bigserial	19		√	nextval('int_data_source_ids_pk_id_seq'::regclass)
lab_position	labpos_pk_id	bigserial	19		√	nextval('lab_position_labpos_pk_id_seq'::regclass)
lab_address_update_tracking	laut_pk_id	bigserial	19		√	nextval('lab_address_update_tracking_laut_pk_id_seq'::regclass)
longest_bin_resident_metric	lbrm_pk_id	bigserial	19		√	nextval('longest_bin_resident_metric_lbrm_pk_id_seq'::regclass)
linkage_membership_search	lms_pk_id	bigserial	19		√	nextval('linkage_membership_search_lms_pk_id_seq'::regclass)
linkage_membership_search_bkup	lms_pk_id	bigserial	19		√	nextval('linkage_membership_search_bkup_lms_pk_id_seq'::regclass)
linkage_membership_search_temp	lms_pk_id	bigserial	19		√	nextval('linkage_membership_search_temp_lms_pk_id_seq'::regclass)
linkage_membership	lnkgm_pk_id	bigserial	19		√	nextval('linkage_membership_lnkgm_pk_id_seq'::regclass)
linkage_single	lsingle_pk_id	bigserial	19		√	nextval('linkage_single_lsingle_pk_id_seq'::regclass)
monthly_average_curated_metric	macm_pk_id	bigserial	19		√	nextval('monthly_average_curated_metric_macm_pk_id_seq'::regclass)
monthly_curated_metric	mcm_pk_id	bigserial	19		√	nextval('monthly_curated_metric_mcm_pk_id_seq'::regclass)
marker_go_term_annotation_extension	mgtae_pk_id	bigserial	19		√	nextval('marker_go_term_annotation_extension_mgtae_pk_id_seq'::regclass)
marker_go_term_annotation_extension_group	mgtaeg_annotation_extension_group_id	bigserial	19		√	nextval('marker_go_term_annotation_ext_mgtaeg_annotation_extension_g_seq'::regclass)
mesh_heading	mh_pk_id	bigserial	19		√	nextval('mesh_heading_mh_pk_id_seq'::regclass)
marker_history_audit	mha_pk_id	bigserial	19		√	nextval('marker_history_audit_mha_pk_id_seq'::regclass)
merge_markers_sql	mms_pk_id	bigserial	19		√	nextval('merge_markers_sql_mms_pk_id_seq'::regclass)
marker_go_term_evidence_annotation_organization	mrkrgoevas_pk_id	bigserial	19		√	nextval('marker_go_term_evidence_annotation_organiz_mrkrgoevas_pk_id_seq'::regclass)
marker_go_term_evidence_annotation_created_by_source	mrkrgoevcb_pk_id	bigserial	19		√	nextval('marker_go_term_evidence_annotation_created_mrkrgoevcb_pk_id_seq'::regclass)
marker_to_protein	mtp_pk_id	bigserial	19		√	nextval('marker_to_protein_mtp_pk_id_seq'::regclass)
ncbi_ortholog_alias	noa_pk_id	bigserial	19		√	nextval('ncbi_ortholog_alias_noa_pk_id_seq'::regclass)
ncbi_ortholog_external_reference	noer_pk_id	bigserial	19		√	nextval('ncbi_ortholog_external_reference_noer_pk_id_seq'::regclass)
obsolete_term_replacement	obstermrep_pk_id	bigserial	19		√	nextval('obsolete_term_replacement_obstermrep_pk_id_seq'::regclass)
obsolete_term_suggestion	obstermsug_pk_id	bigserial	19		√	nextval('obsolete_term_suggestion_obstermsug_pk_id_seq'::regclass)
omim_phenotype	omimp_pk_id	bigserial	19		√	nextval('omim_phenotype_omimp_pk_id_seq'::regclass)
ontology	ont_pk_id	bigserial	19		√	nextval('ontology_ont_pk_id_seq'::regclass)
one_to_one_accession	ooa_pk_id	bigserial	19		√	nextval('one_to_one_accession_ooa_pk_id_seq'::regclass)
ontology_subset	osubset_pk_id	bigserial	19		√	nextval('ontology_subset_osubset_pk_id_seq'::regclass)
pub_correspondence_subject	pcs_subject_pk_id	bigserial	19		√	nextval('pub_correspondence_subject_pcs_subject_pk_id_seq'::regclass)
processing_checklist_task	pct_pk_id	bigserial	19		√	nextval('processing_checklist_task_pct_pk_id_seq'::regclass)
publication_contact_tracking	pct_pk_id	bigserial	19		√	nextval('publication_contact_tracking_pct_pk_id_seq'::regclass)
pub_db_xref	pdx_pk_id	bigserial	19		√	nextval('pub_db_xref_pdx_pk_id_seq'::regclass)
person_author	persauth_pk_id	bigserial	19		√	nextval('person_author_persauth_pk_id_seq'::regclass)
publication_file	pf_pk_id	bigserial	19		√	nextval('publication_file_pf_pk_id_seq'::regclass)
phenotype_figure_group	pfigg_group_pk_id	bigserial	19		√	nextval('phenotype_figure_group_pfigg_group_pk_id_seq'::regclass)
phenotype_figure_group_member	pfiggm_pk_id	bigserial	19		√	nextval('phenotype_figure_group_member_pfiggm_pk_id_seq'::regclass)
publication_file_type	pft_pk_id	bigserial	19		√	nextval('publication_file_type_pft_pk_id_seq'::regclass)
phenotype_source_generated_temp	pg_id	bigserial	19		√	nextval('phenotype_source_generated_temp_pg_id_seq'::regclass)
remove_phenos_ids	phenos_id	bigserial	19		√	nextval('remove_phenos_ids_phenos_id_seq'::regclass)
phenotype_statement	phenos_pk_id	bigserial	19		√	nextval('phenotype_statement_phenos_pk_id_seq'::regclass)
phenotype_experiment	phenox_pk_id	bigserial	19		√	nextval('phenotype_experiment_phenox_pk_id_seq'::regclass)
pubmed_publication_author	ppa_pk_id	bigserial	19		√	nextval('pubmed_publication_author_ppa_pk_id_seq'::regclass)
publication_processing_checklist	ppc_pk_id	bigserial	19		√	nextval('publication_processing_checklist_ppc_pk_id_seq'::regclass)
phenotype_observation_generated_temp	psg_id	bigserial	19		√	nextval('phenotype_observation_generated_temp_psg_id_seq'::regclass)
pheno_term	pt_pk_id	bigserial	19		√	nextval('pheno_term_pt_pk_id_seq'::regclass)
pheno_term_old	pt_pk_id	bigserial	19		√	nextval('pheno_term_old_pt_pk_id_seq'::regclass)
pheno_term_fast_search	ptfs_pk_id	bigserial	19		√	nextval('pheno_term_fast_search_ptfs_pk_id_seq'::regclass)
pheno_term_fast_search_tmp	ptfs_pk_id	bigserial	19		√	nextval('pheno_term_fast_search_tmp_ptfs_pk_id_seq'::regclass)
pub_tracking_history	pth_pk_id	bigserial	19		√	nextval('pub_tracking_history_pth_pk_id_seq'::regclass)
protein_to_interpro	pti_pk_id	bigserial	19		√	nextval('protein_to_interpro_pti_pk_id_seq'::regclass)
pub_tracking_location	ptl_pk_id	bigserial	19		√	nextval('pub_tracking_location_ptl_pk_id_seq'::regclass)
protein_to_pdb	ptp_pk_id	bigserial	19		√	nextval('protein_to_pdb_ptp_pk_id_seq'::regclass)
pub_tracking_status	pts_pk_id	bigserial	19		√	nextval('pub_tracking_status_pts_pk_id_seq'::regclass)
publication_correspondence	pubcorr_pk_id	bigserial	19		√	nextval('publication_correspondence_pubcorr_pk_id_seq'::regclass)
pub_correspondence_recipient	pubcr_pk_id	bigserial	19		√	nextval('pub_correspondence_recipient_pubcr_pk_id_seq'::regclass)
pub_correspondence_received_email	pubcre_pk_id	bigserial	19		√	nextval('pub_correspondence_received_email_pubcre_pk_id_seq'::regclass)
pub_correspondence_sent_email	pubcse_pk_id	bigserial	19		√	nextval('pub_correspondence_sent_email_pubcse_pk_id_seq'::regclass)
pub_correspondence_sent_tracker	pubcst_pk_id	bigserial	19		√	nextval('pub_correspondence_sent_tracker_pubcst_pk_id_seq'::regclass)
record_attribution	recattrib_pk_id	bigserial	19		√	nextval('record_attribution_recattrib_pk_id_seq'::regclass)
revinfo	rev	int4	10		√
sequence_feature_chromosome_location_generated	sfclg_pk_id	bigserial	19		√	nextval('sequence_feature_chromosome_location_generated_sfclg_pk_id_seq'::regclass)
snp_download	snpd_pk_id	serial	10		√	nextval('snp_download_snpd_pk_id_seq'::regclass)
str_group	strg_group_pk_id	bigserial	19		√	nextval('str_group_strg_group_pk_id_seq'::regclass)
so_zfin_mapping	szm_pk_id	bigserial	19		√	nextval('so_zfin_mapping_szm_pk_id_seq'::regclass)
term_group	tg_group_pk_id	bigserial	19		√	nextval('term_group_tg_group_pk_id_seq'::regclass)
transcript_status	tscripts_pk_id	bigserial	19		√	nextval('transcript_status_tscripts_pk_id_seq'::regclass)
transcript_type	tscriptt_pk_id	bigserial	19		√	nextval('transcript_type_tscriptt_pk_id_seq'::regclass)
tscript_type_status_definition	ttsdef_pk_id	bigserial	19		√	nextval('tscript_type_status_definition_ttsdef_pk_id_seq'::regclass)
term_xref	tx_pk_id	bigserial	19		√	nextval('term_xref_tx_pk_id_seq'::regclass)
updates	upd_pk_id	bigserial	19		√	nextval('updates_upd_pk_id_seq'::regclass)
video	video_pk_id	bigserial	19		√	nextval('video_video_pk_id_seq'::regclass)
withdrawn_data	wd_pk_id	bigserial	19		√	nextval('withdrawn_data_wd_pk_id_seq'::regclass)
warehouse_run_tracking	wrt_pk_id	bigserial	19		√	nextval('warehouse_run_tracking_wrt_pk_id_seq'::regclass)
xpat_exp_details_generated_bkup	xedg_pk_id	bigserial	19		√	nextval('xpat_exp_details_generated_bkup_xedg_pk_id_seq'::regclass)
xpat_exp_details_generated_temp	xedg_pk_id	bigserial	19		√	nextval('xpat_exp_details_generated_temp_xedg_pk_id_seq'::regclass)
xpat_figure_group	xfigg_group_pk_id	bigserial	19		√	nextval('xpat_figure_group_xfigg_group_pk_id_seq'::regclass)
xpat_figure_group_member	xfiggm_pk_id	bigserial	19		√	nextval('xpat_figure_group_member_xfiggm_pk_id_seq'::regclass)
expression_result2	xpatres_pk_id	bigserial	19		√	nextval('expression_result2_xpatres_pk_id_seq'::regclass)
expression_result_temp	xpatres_zdb_id	bigserial	19		√	nextval('expression_result_temp_xpatres_zdb_id_seq'::regclass)
xpat_results_generated_bkup	xrg_pk_id	bigserial	19		√	nextval('xpat_results_generated_bkup_xrg_pk_id_seq'::regclass)
xpat_results_generated_temp	xrg_pk_id	bigserial	19		√	nextval('xpat_results_generated_temp_xrg_pk_id_seq'::regclass)
zdb_replaced_data	zrepld_pk_id	bigserial	19		√	nextval('zdb_replaced_data_zrepld_pk_id_seq'::regclass)
paneled_markers	abbrev	text	2147483647	√		null
panels	abbrev	text	2147483647
sangerfeatures	abbrev	text	2147483647	√		null
zmap_pub_pan_mark	abbrev	text	2147483647
zmap_pub_pan_mark	abbrevp	text	2147483647
abregistry	abregid	text	2147483647	√		null
accession_bank	accbk_abbreviation	text	2147483647	√		null
accession_bank	accbk_acc_num	text	2147483647
accession_bank	accbk_defline	text	2147483647	√		null
accession_bank	accbk_fdbcont_zdb_id	text	2147483647
accession_bank	accbk_length	int4	10	√		null
accession_bank	accbk_name	text	2147483647	√		null
zdb_submitters	access	text	2147483647	√		null
publication	accession_no	int4	10	√		null
newfeaturedata	accid	text	2147483647	√		null
accession_version	accver_acc_num	text	2147483647
accession_version	accver_version	int4	10
return_recs	action	text	2147483647	√		null
average_curation_time_metric	actm_average_time_in_bin1	int4	10			0
average_curation_time_metric	actm_average_time_in_bin2	int4	10			0
average_curation_time_metric	actm_average_time_in_bin3	int4	10			0
average_curation_time_metric	actm_average_time_in_curating_status	int4	10			0
average_curation_time_metric	actm_average_time_in_ortho	int4	10			0
average_curation_time_metric	actm_average_time_in_pheno	int4	10			0
average_curation_time_metric	actm_average_time_in_xpat	int4	10			0
average_curation_time_metric	actm_average_time_waiting_for_author	int4	10			0
average_curation_time_metric	actm_average_time_waiting_for_curator_review	int4	10			0
average_curation_time_metric	actm_average_time_waiting_for_nomenclature	int4	10			0
average_curation_time_metric	actm_average_time_waiting_for_ontology	int4	10			0
average_curation_time_metric	actm_average_time_waiting_for_software_fix	int4	10			0
average_curation_time_metric	actm_date_captured	timestamp	29,6			now()
average_curation_time_metric	actm_stddev_in_bin1	int4	10			0
average_curation_time_metric	actm_stddev_in_bin2	int4	10			0
average_curation_time_metric	actm_stddev_in_bin3	int4	10			0
average_curation_time_metric	actm_stddev_in_ortho	int4	10			0
average_curation_time_metric	actm_stddev_in_pheno	int4	10			0
average_curation_time_metric	actm_stddev_in_xpat	int4	10			0
average_curation_time_metric	actm_stddev_time_in_curating_status	int4	10			0
average_curation_time_metric	actm_stdev_time_waiting_for_author	int4	10			0
average_curation_time_metric	actm_stdev_time_waiting_for_curator_review	int4	10			0
average_curation_time_metric	actm_stdev_time_waiting_for_nomenclature	int4	10			0
average_curation_time_metric	actm_stdev_time_waiting_for_ontology	int4	10			0
average_curation_time_metric	actm_stdev_time_waiting_for_software_fix	int4	10			0
average_time_per_person	actpp_average_time_spent_days	int4	10			0
average_time_per_person	actpp_curation_type	text	2147483647
average_time_per_person	actpp_date_captured	timestamp	29,6			now()
average_time_per_person	actpp_person_zdb_id	text	2147483647
tmp_addgene	addgeneid	text	2147483647	√		null
tmp_addgene	addgenename	text	2147483647	√		null
company	address	text	2147483647	√		null
lab	address	text	2147483647	√		null
person	address	text	2147483647	√		null
amsterdam_file	af_feature_zdb_id	text	2147483647
amsterdam_file	af_file_location	text	2147483647
amsterdam_file	af_is_overlapping_file	text	2147483647	√		null
tmp_final	affected_components	text	2147483647	√		null
tmp_fish490	affected_components	text	2147483647	√		null
tmp_fish_thatfitthebill	affected_components	text	2147483647	√		null
tmp_fishnoeap	affected_components	text	2147483647	√		null
final491	affector	text	2147483647	√		null
tmp_onlyfish	affector	text	2147483647	√		null
affected_gene_group_member	afgm_group_id	int8	19
affected_gene_group_member	afgm_member_id	text	2147483647
affected_gene_group_member	afgm_member_name	text	2147483647	√		null
alias_group	aliasgrp_definition	text	2147483647	√		null
alias_group	aliasgrp_name	text	2147483647
alias_group	aliasgrp_significance	int4	10
alias_scope	aliasscope_scope	text	2147483647
all_alias_tokens	aliastok_dalias_zdb_id	text	2147483647
all_alias_tokens	aliastok_token_lower	text	2147483647
all_anatomy_contains	allanatcon_contained_zdb_id	text	2147483647
all_anatomy_contains	allanatcon_container_zdb_id	text	2147483647
all_anatomy_contains	allanatcon_min_contain_distance	int4	10
featuregenedata	allele	text	2147483647
featurenogenedata	allele	text	2147483647
featurezmp	allele	text	2147483647
featurezmpdata	allele	text	2147483647
sanger_flanking_sequence	allele	text	2147483647
sanger_location	allele	text	2147483647
burgess_location_post	allele1	text	2147483647
sanger_location_post	allele1	text	2147483647
featuredata	alleleid	text	2147483647
newfeaturedata	alleleid	text	2147483647
sanger_flanking_sequence_post_proc	alleleid	text	2147483647
tmp_ftrnote	alleletag	text	2147483647	√		null
all_term_contains	alltermcon_contained_zdb_id	text	2147483647
tmp_all_term_contains	alltermcon_contained_zdb_id	text	2147483647	√		null
all_term_contains	alltermcon_container_zdb_id	text	2147483647
tmp_all_term_contains	alltermcon_container_zdb_id	text	2147483647	√		null
all_term_contains	alltermcon_min_contain_distance	int4	10
tmp_all_term_contains	alltermcon_min_contain_distance	int4	10
sanger_flanking_sequence	alt	text	2147483647
anatomy_display	anatdisp_indent	int4	10
anatomy_display	anatdisp_item_name	text	2147483647
anatomy_display	anatdisp_item_zdb_id	text	2147483647
anatomy_display	anatdisp_seq_num	int4	10
anatomy_display	anatdisp_stg_zdb_id	text	2147483647
anatomy_stats	anatstat_contains_object_count	int4	10
anatomy_stats	anatstat_object_count	int4	10
anatomy_stats	anatstat_object_type	varchar	32
anatomy_stats	anatstat_synonym_count	int4	10
anatomy_stats	anatstat_term_zdb_id	text	2147483647	√		null
anatomy_stats	anatstat_total_distinct_count	int4	10
primer_set	anneal_temp	numeric	131089	√		null
tmp_zeco_tt	aotermid	text	2147483647	√		null
apato_tag	apatotag_name	text	2147483647
apato_infrastructure	api_curator_zdb_id	text	2147483647
apato_infrastructure	api_date	timestamp	29,6			now()
apato_infrastructure	api_entity_1_subterm_zdb_id	text	2147483647	√		null
apato_infrastructure	api_entity_1_superterm_zdb_id	text	2147483647
apato_infrastructure	api_entity_2_subterm_zdb_id	text	2147483647	√		null
apato_infrastructure	api_entity_2_superterm_zdb_id	text	2147483647	√		null
apato_infrastructure	api_pub_zdb_id	text	2147483647
apato_infrastructure	api_quality_zdb_id	text	2147483647
apato_infrastructure	api_tag	text	2147483647
apato_infrastructure	api_zdb_id	text	2147483647
annual_stats	as_count	int4	10
annual_stats	as_date	timestamp	29,6
annual_stats	as_section	text	2147483647
annual_stats	as_type	text	2147483647
cnechr1	assembly	text	2147483647
sanger_location	assembly	text	2147483647
burgess_location_post	assembly1	text	2147483647
sanger_location_post	assembly1	text	2147483647
antibody	atb_host_organism	text	2147483647	√		null
antibody	atb_hviso_name	text	2147483647	√		null
antibody	atb_immun_organism	text	2147483647	√		null
antibody	atb_ltiso_name	text	2147483647	√		null
antibody	atb_type	text	2147483647	√		null
antibody	atb_zdb_id	text	2147483647
antibody_type	atbtype_name	text	2147483647
attribution_type	attype_definition	text	2147483647	√		null
attribution_type	attype_type	text	2147483647
databasechangelog	author	varchar	255
author	author_first_name	text	2147483647	√		null
author	author_institution	text	2147483647	√		null
author	author_last_name	text	2147483647	√		null
author_publication	authorpub_author_id	int8	19
author_publication	authorpub_pub_zdb_id	text	2147483647
publication	authors	text	2147483647
tmp_betterfishdump	badfishid	text	2147483647	√		null
tmp_betterfishdump	badfishname	text	2147483647	√		null
primer_set	band_size	text	2147483647	√		null
blastdb_order	bdborder_child_blastdb_zdb_id	text	2147483647
blastdb_order	bdborder_order	int4	10
blastdb_order	bdborder_parent_blastdb_zdb_id	text	2147483647	√		null
blast_database_type	bdbt_type	text	2147483647
blast_database_origination_type	bdot_definition	text	2147483647
blast_database_origination_type	bdot_type	text	2147483647
tmp_betterfishdump	betterfishid	text	2147483647	√		null
tmp_betterfishdump	betterfishname	text	2147483647	√		null
blast_hit	bhit_alignment	text	2147483647	√		null
blast_hit	bhit_bqry_zdb_id	text	2147483647
blast_hit	bhit_expect_value	float8	17,17
blast_hit	bhit_hit_number	int4	10
blast_hit	bhit_identities_denominator	int4	10	√		null
blast_hit	bhit_identities_numerator	int4	10	√		null
blast_hit	bhit_positives_denominator	int4	10
blast_hit	bhit_positives_numerator	int4	10
blast_hit	bhit_probability	float8	17,17	√		null
blast_hit	bhit_score	int4	10
blast_hit	bhit_strand	text	2147483647	√		null
blast_hit	bhit_target_accbk_pk_id	int8	19
blast_hit	bhit_zdb_id	text	2147483647
company	bio	text	2147483647	√		null
lab	bio	text	2147483647	√		null
blast_database	blastdb_abbrev	text	2147483647
blast_database	blastdb_description	text	2147483647	√		null
blast_database	blastdb_is_being_processed	bool	1			false
blast_database	blastdb_last_regenerated	timestamp	29,6	√		null
blast_database	blastdb_name	text	2147483647
blast_database	blastdb_num_accessions	int4	10	√		null
blast_database	blastdb_num_seqs	int4	10	√		null
blast_database	blastdb_old_num_seqs	text	2147483647	√		null
blast_database	blastdb_origination_id	int8	19	√		null
blast_database	blastdb_path	text	2147483647	√		null
blast_database	blastdb_public	bool	1			false
blast_database	blastdb_tool_display_name	text	2147483647
blast_database	blastdb_tool_display_order	int4	10	√		null
blast_database	blastdb_type	text	2147483647
blast_database	blastdb_zdb_id	text	2147483647
blastdb_run	blastdbr_blastdb_zdb_id	text	2147483647
blastdb_run	blastdbr_run_zdb_id	text	2147483647
pg_stat_statements	blk_read_time	float8	17,17	√		null
pg_stat_statements	blk_write_time	float8	17,17	√		null
bl_plate_tracking	blpt_load_number	text	2147483647
bl_plate_tracking	blpt_plate	text	2147483647	√		null
blast_query	bqry_accbk_pk_id	int8	19
blast_query	bqry_runcan_zdb_id	text	2147483647
blast_query	bqry_zdb_id	text	2147483647
blastdb_regen_content	brc_acc_num	text	2147483647
blastdb_regen_content	brc_blastdb_zdb_id	text	2147483647
blast_report	brpt_bqry_zdb_id	text	2147483647
blast_report	brpt_detail_header	text	2147483647	√		null
blast_report	brpt_exitcode	int4	10
blast_report	brpt_zdb_id	text	2147483647
finalct3	bundle	text	2147483647	√		null
dupcrispr	calias	varchar	50	√		null
pg_stat_statements	calls	int8	19	√		null
construct_component	cc_cassette_number	int4	10			1
construct_component	cc_component	text	2147483647
construct_component	cc_component_category	text	2147483647	√		null
construct_component	cc_component_type	text	2147483647	√		null
construct_component	cc_component_zdb_id	text	2147483647	√		null
construct_component	cc_construct_zdb_id	text	2147483647
construct_component	cc_order	int4	10
tmp_zeco_tt	cctermid	text	2147483647	√		null
editconstruct	cczdb	text	2147483647	√		null
condition_data_type	cdt_group	text	2147483647
condition_data_type	cdt_name	text	2147483647
condition_data_type	cdt_significance	int4	10
condition_data_type	cdt_zdb_id	text	2147483647
tmp_zeco_tt	cdtid	text	2147483647	√		null
clean_expression_fast_search	cefs_genox_zdb_id	text	2147483647
clean_expression_fast_search	cefs_mrkr_zdb_id	text	2147483647
tmp_zeco_tt	chebitermid	text	2147483647	√		null
cnechr	chr	text	2147483647	√		null
cnechr	chrend	int4	10	√		null
chromosome	chrom_name	text	2147483647
chromosome	chrom_order	int4	10
cnechr1	chromosome	text	2147483647
sanger_location	chromosome	text	2147483647
burgess_location_post	chromosome1	text	2147483647
sanger_location_post	chromosome1	text	2147483647
clone	clone_cloning_site	text	2147483647	√		null
clone	clone_comments	text	2147483647	√		null
clone	clone_digest	text	2147483647	√		null
clone	clone_insert_size	int4	10	√		null
clone	clone_mrkr_zdb_id	text	2147483647
clone	clone_pcr_amplification	text	2147483647	√		null
clone	clone_polymerase_name	text	2147483647	√		null
clone	clone_probelib_zdb_id	text	2147483647
clone	clone_problem_type	text	2147483647	√		null
clone	clone_rating	int4	10	√		null
clone	clone_sequence_type	text	2147483647			'unspecified'::text
clone	clone_vector_name	text	2147483647	√		null
dupcrispr	cname	varchar	50	√		null
candidate	cnd_is_problem	bool	1			false
candidate	cnd_last_done_date	timestamp	29,6	√		null
candidate	cnd_mrkr_type	text	2147483647
candidate	cnd_note	text	2147483647	√		null
candidate	cnd_run_count	int4	10			0
candidate	cnd_suggested_name	text	2147483647	√		null
candidate	cnd_zdb_id	text	2147483647
cnechr	cne	text	2147483647	√		null
tmpcne	cneabbrev	text	2147483647	√		null
cnechr1	cneid	text	2147483647
cnedata	cneid	text	2147483647
tmpcne	cneid	text	2147483647	√		null
cnedata	cnename	text	2147483647	√		null
tmpcne	cnetype	text	2147483647	√		null
databasechangelog	comments	varchar	255	√		null
mapped_marker	comments	text	2147483647	√		null
primer_set	comments	text	2147483647	√		null
tmp_ottens	comments	text	2147483647	√		null
updates	comments	text	2147483647	√		null
company_position	compos_order	int4	10
company_position	compos_position	text	2147483647
condition	condition_group	text	2147483647
construct_marker_relationship	conmrkrrel_construct_zdb_id	text	2147483647
construct_marker_relationship	conmrkrrel_mrkr_zdb_id	text	2147483647
construct_marker_relationship	conmrkrrel_relationship_type	text	2147483647
construct_marker_relationship	conmrkrrel_zdb_id	text	2147483647
ftrconsequence	cons	text	2147483647	√		null
ftrconsequencenew	cons1	text	2147483647	√		null
ftrconsequencenew	cons2	text	2147483647	√		null
construct_figure	consfig_construct_zdb_id	text	2147483647
construct_figure	consfig_fig_zdb_id	text	2147483647
constructrel	construct1	text	2147483647	√		null
constructreln	construct1	text	2147483647	√		null
constructrel	construct2	text	2147483647	√		null
constructreln	construct2	text	2147483647	√		null
construct	construct_comments	text	2147483647	√		null
construct	construct_date_inserted	timestamp	29,6			now()
construct	construct_date_modified	timestamp	29,6	√		now()
feature_data	construct_id	text	2147483647
construct	construct_name	text	2147483647
construct	construct_owner_zdb_id	text	2147483647
construct	construct_type	text	2147483647
construct	construct_zdb_id	text	2147483647
company	contact_person	text	2147483647	√		null
lab	contact_person	text	2147483647	√		null
databasechangelog	contexts	varchar	255	√		null
zdb_submitters	cookie	text	2147483647
company	country	text	2147483647	√		null
lab	country	text	2147483647	√		null
clone_problem_type	cpt_type	text	2147483647
zdb_submitters	create_date	date	13	√		null
curator_session	cs_data_zdb_id	text	2147483647	√		null
curator_session	cs_field_name	text	2147483647
curator_session	cs_field_name_value	text	2147483647
curator_session	cs_person_zdb_id	text	2147483647
dupcrispr	cseq	varchar	50	√		null
country_code	ctc_code	text	2147483647
country_code	ctc_comments	text	2147483647	√		null
country_code	ctc_display_order	int4	10	√		null
country_code	ctc_name	text	2147483647
curation	cur_closed_date	timestamp	29,6	√		null
curation	cur_curator_zdb_id	text	2147483647
curation	cur_data_found	bool	1			false
curation	cur_entry_date	timestamp	29,6
curation	cur_opened_date	timestamp	29,6	√		null
curation	cur_pub_zdb_id	text	2147483647
curation	cur_topic	text	2147483647
curation	cur_zdb_id	text	2147483647
curation_topic	curtopic_name	text	2147483647
controlled_vocabulary	cv_foreign_species	text	2147483647	√		null
controlled_vocabulary	cv_name_definition	text	2147483647	√		null
controlled_vocabulary	cv_term_name	text	2147483647
controlled_vocabulary	cv_zdb_id	text	2147483647
data_alias	dalias_alias	text	2147483647
data_alias	dalias_alias_lower	text	2147483647
data_alias	dalias_data_zdb_id	text	2147483647
data_alias	dalias_group_id	int8	19
data_alias	dalias_scope_id	int8	19	√		null
data_alias	dalias_zdb_id	text	2147483647
disease_annotation_model	damo_dat_zdb_id	text	2147483647
disease_annotation_model	damo_genox_zdb_id	text	2147483647
disease_annotation	dat_evidence_term_zdb_id	text	2147483647	√		null
disease_annotation	dat_source_zdb_id	text	2147483647
disease_annotation	dat_term_zdb_id	text	2147483647
disease_annotation	dat_zdb_id	text	2147483647
databasechangelog	dateexecuted	timestamp	29,6
pg_stat_statements	dbid	oid	10	√		null
db_link	dblink_acc_num	text	2147483647
db_link	dblink_acc_num_display	text	2147483647	√		null
db_link	dblink_fdbcont_zdb_id	text	2147483647
db_link	dblink_info	text	2147483647	√		null
db_link	dblink_length	int4	10	√		null
db_link	dblink_linked_recid	text	2147483647
db_link	dblink_zdb_id	text	2147483647
ensdarg_post_proc	dblinkid	text	2147483647
tmp_addgene	dblinkid	text	2147483647	√		null
tmp_rnac_zfin	dblinkid	text	2147483647	√		null
tmp_zirc_geno	dblinkid	text	2147483647	√		null
databasechangelog	deployment_id	varchar	10	√		null
databasechangelog	description	varchar	255	√		null
database_info	di_code_version	text	2147483647			'production'::text
database_info	di_database_unloaded	text	2147483647	√		null
database_info	di_date_unloaded	timestamp	29,6
daily_indexed_metric	dim_date_captured	timestamp	29,6			now()
daily_indexed_metric	dim_number_archived	int4	10			0
daily_indexed_metric	dim_number_closed_no_data	int4	10			0
daily_indexed_metric	dim_number_closed_no_pdf	int4	10			0
daily_indexed_metric	dim_number_expression_bin	int4	10			0
daily_indexed_metric	dim_number_indexed_bin_1	int4	10			0
daily_indexed_metric	dim_number_indexed_bin_2	int4	10			0
daily_indexed_metric	dim_number_indexed_bin_3	int4	10			0
daily_indexed_metric	dim_number_orthology_bin	int4	10			0
daily_indexed_metric	dim_number_phenotype_bin	int4	10			0
panels	disp_order	int4	10
linkages_copy	dist	numeric	8,2	√		null
data_note	dnote_curator_zdb_id	text	2147483647
data_note	dnote_data_zdb_id	text	2147483647
data_note	dnote_date	timestamp	29,6	√		null
data_note	dnote_text	text	2147483647	√		null
data_note	dnote_zdb_id	text	2147483647
doi_attempts	doia_num_attempts	int4	10
doi_attempts	doia_pub_zdb_id	text	2147483647
do_oevdispupdate_temp_first	dout1_evidence_code	bpchar	2	√		null
do_oevdispupdate_temp_first	dout1_gene_zdb_id	text	2147483647	√		null
do_oevdispupdate_temp_first	dout1_organism_list	text	2147483647
do_oevdispupdate_temp_first	dout1_pub_zdb_id	text	2147483647	√		null
do_oevdispupdate_temp_first	dout1_session_id	int4	10	√		null
do_oevdispupdate_temp_second	dout2_evidence_code	bpchar	2	√		null
do_oevdispupdate_temp_second	dout2_gene_zdb_id	text	2147483647	√		null
do_oevdispupdate_temp_second	dout2_oevdisp_zdb_id	text	2147483647	√		null
do_oevdispupdate_temp_second	dout2_organism_list	text	2147483647	√		null
do_oevdispupdate_temp_second	dout2_session_id	int4	10	√		null
data_reporting	dr_data_zdb_id	text	2147483647
data_reporting	dr_report_generated_date	timestamp	29,6
data_reporting	dr_report_name	text	2147483647
tmp_fish_thatfitthebill	e1subtermid	varchar	2147483647	√		null
tmp_fishnoeap	e1subtermid	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e1subtermname	varchar	2147483647	√		null
tmp_fishnoeap	e1subtermname	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e1supertermid	varchar	2147483647	√		null
tmp_fishnoeap	e1supertermid	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e1supertermname	varchar	2147483647	√		null
tmp_fishnoeap	e1supertermname	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e2subtermid	varchar	2147483647	√		null
tmp_fishnoeap	e2subtermid	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e2subtermname	varchar	2147483647	√		null
tmp_fishnoeap	e2subtermname	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e2supertermid	varchar	2147483647	√		null
tmp_fishnoeap	e2supertermid	varchar	2147483647	√		null
tmp_fish_thatfitthebill	e2supertermname	varchar	2147483647	√		null
tmp_fishnoeap	e2supertermname	varchar	2147483647	√		null
experiment_condition_restricted	ecr_cdt_zdb_id	text	2147483647
experiment_condition_restricted	ecr_chebi_term_zdb_id	text	2147483647	√		null
experiment_condition_restricted	ecr_exp_zdb_id	text	2147483647
tmp_efs_map	efs1	int8	19	√		null
tmp_efs_map	efs2	int8	19	√		null
expression_figure_stage	efs_end_stg_zdb_id	text	2147483647
expression_figure_stage	efs_fig_zdb_id	text	2147483647
expression_figure_stage	efs_start_stg_zdb_id	text	2147483647
expression_figure_stage	efs_xpatex_zdb_id	text	2147483647
entrez_gene	eg_acc_num	int4	10
environment_group	eg_genox_zdb_id	text	2147483647
environment_group	eg_group_name	text	2147483647	√		null
entrez_gene	eg_name	text	2147483647	√		null
entrez_gene	eg_symbol	text	2147483647	√		null
eco_go_mapping	egm_go_evidence_code	text	2147483647
eco_go_mapping	egm_term_zdb_id	text	2147483647
company	email	text	2147483647	√		null
lab	email	text	2147483647	√		null
person	email	text	2147483647	√		null
cnechr1	endlocation	int4	10	√		null
ensdart_name_mapping	enm_ensdarg_id	text	2147483647	√		null
ensdart_name_mapping	enm_ensdart_stable_id	text	2147483647	√		null
ensdart_name_mapping	enm_ensdart_versioned_id	text	2147483647	√		null
ensdart_name_mapping	enm_ensembl_tscript_name	text	2147483647	√		null
ensdart_name_mapping	enm_ottdart_id	text	2147483647	√		null
ensdart_name_mapping	enm_tscript_zdb_id	text	2147483647	√		null
inputensdarg	ensdarg	text	2147483647
featuredata	ensdarg1	text	2147483647	√		null
featuredata	ensdarg2	text	2147483647	√		null
featuregenedata	ensdargid	text	2147483647
featurezmpdata	ensdargid	text	2147483647
ensdarg_post_proc	ensdargidpost	text	2147483647
ensdart_ottdart_mapping	ensdart_id	text	2147483647	√		null
tmp_ottens	ensdartid	text	2147483647	√		null
tscriptens	ensdartid	text	2147483647	√		null
tscriptens1	ensdartid1	text	2147483647	√		null
ensdar_mapping	ensm_ensdarg_id	text	2147483647
ensdar_mapping	ensm_ensdarp_id	text	2147483647	√		null
ensdar_mapping	ensm_ensdart_id	text	2147483647
ensdarg_ensdarp_mapping	ensp_ensdarg_id	text	2147483647
ensdarg_ensdarp_mapping	ensp_ensdarp_id	text	2147483647
ensdarg_ensdarp_mapping	ensp_ensdart_id	text	2147483647
ensdarg_ensdarp_mapping	ensp_length	int4	10	√		null
mapped_marker	entry_date	timestamp	26,3	√		null
zmap_pub_pan_mark	entry_date	timestamp	26,3
company	entry_time	timestamp	29,6	√		now()
lab	entry_time	timestamp	29,6	√		now()
panels	entry_time	timestamp	26,3
person	entry_time	timestamp	29,6	√		now()
ensdarg_ottdarg_mapping	eom_ensdarg_id	text	2147483647
ensdarg_ottdarg_mapping	eom_ottdarg_id	text	2147483647
entrez_to_protein	ep_entrez_acc_num	int4	10
entrez_to_protein	ep_organism_common_name	text	2147483647
entrez_to_protein	ep_protein_acc_num	text	2147483647
tmp_expression_phenotype_term	ept_pk_id	int8	19	√		null
expression_phenotype_term	ept_quality_term_zdb_id	text	2147483647
tmp_expression_phenotype_term	ept_quality_term_zdb_id	text	2147483647	√		null
expression_phenotype_term	ept_relational_term	text	2147483647			'expressed_in'::text
tmp_expression_phenotype_term	ept_relational_term	text	2147483647	√		null
expression_phenotype_term	ept_tag	text	2147483647			'abnormal'::text
tmp_expression_phenotype_term	ept_tag	text	2147483647	√		null
expression_phenotype_term	ept_xpatres_id	int8	19
tmp_expression_phenotype_term	ept_xpatres_id	int8	19	√		null
expression_phenotype_term_controlled_vocab	eptcv_term_zdb_id	text	2147483647
tmp_esag_predistinct	esag_distance	int4	10	√		null
expression_search_anatomy_generated	esag_efs_id	text	2147483647	√		null
tmp_esag_predistinct	esag_efs_id	text	2147483647	√		null
expression_search_anatomy_generated	esag_is_direct	bool	1	√		null
tmp_esag_predistinct	esag_is_direct	bool	1	√		null
expression_search_anatomy_generated	esag_term_name	text	2147483647	√		null
tmp_esag_predistinct	esag_term_name	text	2147483647	√		null
tmp_esag_predistinct	esag_term_zdb_id	text	2147483647	√		null
expression_term_fast_search	etfs_created_date	timestamp	29,6	√		now()
xpatfs_old	etfs_created_date	date	13			now
expression_term_fast_search	etfs_is_xpatres_term	bool	1	√		false
xpatfs_old	etfs_is_xpatres_term	bool	1	√		false
expression_term_fast_search	etfs_term_zdb_id	text	2147483647	√		null
xpatfs_old	etfs_term_zdb_id	text	2147483647	√		null
expression_term_fast_search	etfs_xpatres_pk_id	int8	19	√		null
xpatfs_old	etfs_xpatres_pk_id	int8	19	√		null
cnechr1	evidence	text	2147483647	√		null
entrez_to_xref	ex_entrez_acc_num	int4	10
entrez_to_xref	ex_xref	text	2147483647
databasechangelog	exectype	varchar	10
execweb	execweb_executable	text	2147483647	√		null
execweb	execweb_id	text	2147483647	√		null
fish_genox	exp_id	text	2147483647	√		null
experiment	exp_name	text	2147483647
tmp_fish_thatfitthebill	exp_name	text	2147483647	√		null
tmp_fishnoeap	exp_name	text	2147483647	√		null
experiment	exp_source_zdb_id	text	2147483647
experiment	exp_zdb_id	text	2147483647
experiment_condition	expcond_ao_term_zdb_id	text	2147483647	√		null
experiment_condition	expcond_cdt_zdb_id	text	2147483647	√		null
experiment_condition	expcond_chebi_term_zdb_id	text	2147483647	√		null
experiment_condition	expcond_exp_zdb_id	text	2147483647
experiment_condition	expcond_go_cc_term_zdb_id	text	2147483647	√		null
experiment_condition	expcond_spatial_term_zdb_id	text	2147483647	√		null
experiment_condition	expcond_taxon_term_zdb_id	text	2147483647	√		null
experiment_condition	expcond_zdb_id	text	2147483647
experiment_condition	expcond_zeco_term_zdb_id	text	2147483647
tmp_zeco_tt	expid	text	2147483647	√		null
external_reference	exref_attype_type	text	2147483647
external_reference	exref_data_zdb_id	text	2147483647
external_reference	exref_foreign_db_id	int8	19	√		null
external_reference	exref_reference	text	2147483647
external_note	extnote_data_zdb_id	text	2147483647
external_note	extnote_note	text	2147483647
external_note	extnote_note_type	text	2147483647	√		null
external_note	extnote_source_zdb_id	text	2147483647
external_note	extnote_tag	text	2147483647	√		null
external_note	extnote_zdb_id	text	2147483647
external_note_type	extntype_comment	text	2147483647	√		null
external_note_type	extntype_name	text	2147483647
tmp_zeco_tt	extra	text	2147483647	√		null
company	fax	text	2147483647	√		null
lab	fax	text	2147483647	√		null
person	fax	text	2147483647	√		null
fish_components	fc_affector_zdb_id	text	2147483647
fish_components	fc_construct_zdb_id	text	2147483647	√		null
fish_components	fc_fish_name	text	2147483647
fish_components	fc_fish_zdb_id	text	2147483647
fish_components	fc_gene_zdb_id	text	2147483647	√		null
fish_components	fc_genotype_zdb_id	text	2147483647
feature_community_contribution	fcc_added_by	text	2147483647
feature_community_contribution_audit	fcc_added_by	text	2147483647	√		null
feature_community_contribution	fcc_adult_viable	bool	1	√		false
feature_community_contribution_audit	fcc_adult_viable	bool	1	√		null
feature_community_contribution	fcc_currently_available	bool	1	√		false
feature_community_contribution_audit	fcc_currently_available	bool	1	√		null
feature_community_contribution	fcc_date_added	timestamp	29,6			now()
feature_community_contribution_audit	fcc_date_added	timestamp	29,6	√		null
feature_community_contribution	fcc_feature_zdb_id	text	2147483647
feature_community_contribution_audit	fcc_feature_zdb_id	text	2147483647	√		null
feature_community_contribution	fcc_functional_consequence	text	2147483647	√		null
feature_community_contribution_audit	fcc_functional_consequence	text	2147483647	√		null
feature_community_contribution	fcc_maternal_zygosity_examined	bool	1	√		false
feature_community_contribution_audit	fcc_maternal_zygosity_examined	bool	1	√		null
feature_community_contribution	fcc_nmd_apparent	text	2147483647	√		null
feature_community_contribution	fcc_other_line_information	text	2147483647	√		null
feature_community_contribution_audit	fcc_other_line_information	text	2147483647	√		null
foreign_db	fdb_db_display_name	text	2147483647	√		null
foreign_db	fdb_db_name	text	2147483647
foreign_db	fdb_db_query	text	2147483647
foreign_db	fdb_db_significance	int4	10
foreign_db	fdb_url_suffix	text	2147483647	√		null
foreign_db_contains_display_group	fdbcdg_definition	text	2147483647
foreign_db_contains_display_group	fdbcdg_name	text	2147483647
foreign_db_contains_display_group_member	fdbcdgm_fdbcont_zdb_id	text	2147483647
foreign_db_contains_display_group_member	fdbcdgm_group_id	int8	19
foreign_db_contains	fdbcont_fdb_db_id	int8	19
foreign_db_contains	fdbcont_fdbdt_id	int8	19
foreign_db_contains	fdbcont_organism_common_name	text	2147483647
foreign_db_contains	fdbcont_primary_blastdb_zdb_id	text	2147483647	√		null
foreign_db_contains	fdbcont_zdb_id	text	2147483647
tmp_rnac_zfin	fdbcontid	text	2147483647	√		null
tmp_zirc_geno	fdbcontid	text	2147483647	√		null
foreign_db_data_type	fdbdt_data_type	text	2147483647	√		null
foreign_db_data_type	fdbdt_display_order	int4	10	√		null
foreign_db_data_type	fdbdt_super_type	text	2147483647
feature_dna_mutation_detail	fdmd_deleted_sequence	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_dna_mutation_term_zdb_id	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_dna_position_end	int8	19	√		null
feature_dna_mutation_detail	fdmd_dna_position_start	int8	19	√		null
feature_dna_mutation_detail	fdmd_dna_sequence_of_reference_accession_number	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_exon_number	int8	19	√		null
feature_dna_mutation_detail	fdmd_fdbcont_zdb_id	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_feature_zdb_id	text	2147483647
feature_dna_mutation_detail	fdmd_gene_localization_term_zdb_id	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_inserted_sequence	text	2147483647	√		null
feature_dna_mutation_detail	fdmd_intron_number	int8	19	√		null
feature_dna_mutation_detail	fdmd_number_additional_dna_base_pairs	int8	19	√		null
feature_dna_mutation_detail	fdmd_number_removed_dna_base_pairs	int8	19	√		null
feature_dna_mutation_detail	fdmd_zdb_id	text	2147483647
feature_assay	featassay_feature_zdb_id	text	2147483647
feature_assay	featassay_mutagee	text	2147483647
feature_assay	featassay_mutagen	text	2147483647
tmp_onlydeficiencies	featdef	text	2147483647	√		null
pmflankseq	featid	text	2147483647	√		null
featmkr	feattype	text	2147483647	√		null
feature_data	feature_abb	text	2147483647
feature	feature_abbrev	text	2147483647
feature_audit	feature_abbrev	text	2147483647	√		null
tmp_feature	feature_abbrev	text	2147483647	√		null
feature	feature_abbrev_order	text	2147483647
feature	feature_date_entered	timestamp	29,6	√		now()
feature_audit	feature_date_entered	timestamp	29,6	√		null
feature	feature_df_transloc_complex_prefix	text	2147483647	√		null
feature_audit	feature_df_transloc_complex_prefix	text	2147483647	√		null
feature	feature_dominant	bool	1			false
feature_audit	feature_dominant	bool	1	√		null
feature	feature_known_insertion_site	bool	1			false
feature_audit	feature_known_insertion_site	bool	1	√		null
feature	feature_lab_prefix_id	int8	19	√		null
feature_audit	feature_lap_prefix_id	int8	19	√		null
feature	feature_line_number	text	2147483647	√		null
feature_audit	feature_line_number	text	2147483647	√		null
feature	feature_name	text	2147483647
feature_audit	feature_name	text	2147483647	√		null
feature	feature_name_order	text	2147483647
feature_audit	feature_name_order	text	2147483647	√		null
feature	feature_tg_suffix	text	2147483647	√		null
feature_audit	feature_tg_suffix	text	2147483647	√		null
feature	feature_type	text	2147483647
feature_audit	feature_type	text	2147483647	√		null
feature	feature_unrecovered	bool	1			false
feature_audit	feature_unrecovered	bool	1	√		null
feature	feature_unspecified	bool	1			false
feature_audit	feature_unspecified	bool	1	√		null
feature	feature_zdb_id	text	2147483647
feature_audit	feature_zdb_id	text	2147483647	√		null
seqvar	featureabb	text	2147483647	√		null
seqvar	featureid	text	2147483647	√		null
tmp_ftrnote	featureid	text	2147483647	√		null
missing_varseq	featurezdb	text	2147483647	√		null
featmkr	featzdb	text	2147483647	√		null
tmp_seqref	featzdb	text	2147483647	√		null
feature_group	fg_geno_name	text	2147483647	√		null
feature_group	fg_geno_zdb_id	text	2147483647	√		null
feature_group	fg_genox_zdb_id	text	2147483647	√		null
feature_group	fg_group_name	text	2147483647	√		null
feature_group	fg_group_order	text	2147483647	√		null
feature_group	fg_type_group	text	2147483647	√		null
feature_group_member	fgm_feature_type	text	2147483647	√		null
feature_group_member	fgm_genotype_id	text	2147483647	√		null
feature_group_member	fgm_group_id	int8	19
feature_group_member	fgm_member_id	text	2147483647	√		null
feature_group_member	fgm_member_name	text	2147483647	√		null
feature_group_member	fgm_significance	int4	10	√		null
feature_genomic_mutation_detail	fgmd_feature_zdb_id	text	2147483647
feature_genomic_mutation_detail	fgmd_padded_base	varchar	1	√		null
feature_genomic_mutation_detail	fgmd_sequence_of_reference	text	2147483647	√		null
feature_genomic_mutation_detail	fgmd_sequence_of_reference_accession_number	text	2147483647	√		null
feature_genomic_mutation_detail	fgmd_sequence_of_variation	text	2147483647	√		null
feature_genomic_mutation_detail	fgmd_variation_strand	text	2147483647			'+'::text
feature_genomic_mutation_detail	fgmd_zdb_id	text	2147483647
missing_varseq	fgmdid	text	2147483647	√		null
tmp_ftrnote	fgmdid	varchar	50	√		null
fgmdnote	fgmdnote	text	2147483647
fgmdnote	fgmdnote_zdb_id	varchar	50	√		null
fgmdnote	fgmdref	text	2147483647
fgmdnote	fgmdtag	text	2147483647	√		null
fgmdnote	fgmdtype	text	2147483647	√		null
fgmdnote	fgmdzdb	text	2147483647
feature_history	fhist_comments	text	2147483647	√		null
feature_history	fhist_dalias_zdb_id	text	2147483647	√		null
feature_history	fhist_date	timestamp	29,6
feature_history	fhist_event	text	2147483647
feature_history	fhist_ftr_abbrev_on_fhist_date	text	2147483647
feature_history	fhist_ftr_name_on_fhist_date	text	2147483647
feature_history	fhist_ftr_prev_name	text	2147483647	√		null
feature_history	fhist_ftr_zdb_id	text	2147483647
feature_history	fhist_reason	text	2147483647	√		null
feature_history	fhist_zdb_id	text	2147483647
updates	field_name	text	2147483647	√		null
figure	fig_caption	text	2147483647	√		null
figure	fig_comments	text	2147483647	√		null
figure	fig_full_label	text	2147483647	√		null
figure	fig_inserted_by	text	2147483647	√		null
figure	fig_inserted_date	date	13	√		now()
figure	fig_label	text	2147483647	√		null
tmp_fish_thatfitthebill	fig_label	text	2147483647	√		null
tmp_fishnoeap	fig_label	text	2147483647	√		null
figure	fig_source_zdb_id	text	2147483647
tmp_fish_thatfitthebill	fig_source_zdb_id	text	2147483647	√		null
tmp_fishnoeap	fig_source_zdb_id	text	2147483647	√		null
figure	fig_updated_by	text	2147483647	√		null
figure	fig_updated_date	date	13	√		now()
figure	fig_zdb_id	text	2147483647
tmp_fish_thatfitthebill	fig_zdb_id	text	2147483647	√		null
tmp_fishnoeap	fig_zdb_id	text	2147483647	√		null
tmp_figure	figsource	text	2147483647	√		null
tmp_pub5	figsource	text	2147483647	√		null
aa	file	text	2147483647	√		null
databasechangelog	filename	varchar	255
return_recs	fill_field	text	2147483647	√		null
return_recs	fill_table	text	2147483647	√		null
person	first_name	text	2147483647
fish	fish_full_name	text	2147483647	√		null
fish	fish_functional_affected_gene_count	int8	19
fish	fish_genotype_zdb_id	text	2147483647
fish	fish_handle	text	2147483647
fish_genox	fish_id	text	2147483647	√		null
fish	fish_is_wildtype	bool	1			false
fish	fish_modified	bool	1	√		false
fish	fish_name	text	2147483647
tmp_fish490	fish_name	text	2147483647	√		null
tmp_fish_thatfitthebill	fish_name	text	2147483647	√		null
tmp_fishnoeap	fish_name	text	2147483647	√		null
tmp_onlyfish	fish_name	text	2147483647	√		null
fish	fish_name_order	text	2147483647
fish	fish_order	int8	19
fish	fish_phenotypic_construct_count	int4	10			0
fish	fish_zdb_id	text	2147483647
tmp_fish490	fish_zdb_id	text	2147483647	√		null
tmp_fish_thatfitthebill	fish_zdb_id	text	2147483647	√		null
tmp_fishnoeap	fish_zdb_id	text	2147483647	√		null
tmp_onlyfish	fish_zdb_id	text	2147483647	√		null
fish_str	fishstr_fish_zdb_id	text	2147483647
fish_str	fishstr_str_zdb_id	text	2147483647
int_person_company	flag	text	2147483647	√		null
int_person_lab	flag	text	2147483647	√		null
int_person_pub	flag	text	2147483647	√		null
tmp_seqref	flankid	text	2147483647	√		null
sanger_flanking_sequence	flankingseq	text	2147483647
fest_lib_inst	fli_fest	bpchar	6
fest_lib_inst	fli_inst	text	2147483647	√		null
fest_lib_inst	fli_lib	text	2147483647	√		null
fest_lib_inst	fli_probelib_zdb_id	text	2147483647	√		null
fishmisfortune	fm_affected_gene_count	int4	10	√		0
fishmisfortune	fm_experiment_condition_count	int4	10	√		0
fishmisfortune	fm_feature_count	int4	10	√		0
fishmisfortune	fm_fish_display_name	text	2147483647	√		null
fishmisfortune	fm_fish_zdb_id	text	2147483647	√		null
fishmisfortune	fm_genox_zdb_id	text	2147483647	√		null
fishmisfortune	fm_misfortune_count	int4	10	√		0
fishmisfortune	fm_misfortune_count_minus_one	int4	10	√		0
fishmisfortune	fm_pub_zdb_id	text	2147483647	√		null
fishmisfortune	fm_str_count	int4	10	√		0
feature_marker_relationship	fmrel_ftr_zdb_id	text	2147483647
feature_marker_relationship	fmrel_mrkr_zdb_id	text	2147483647
feature_marker_relationship	fmrel_type	text	2147483647
feature_marker_relationship	fmrel_zdb_id	text	2147483647
feature_marker_relationship_type	fmreltype_1_to_2_comments	text	2147483647	√		null
feature_marker_relationship_type	fmreltype_2_to_1_comments	text	2147483647	√		null
feature_marker_relationship_type	fmreltype_ftr_type_group	text	2147483647
feature_marker_relationship_type	fmreltype_mrkr_type_group	text	2147483647
feature_marker_relationship_type	fmreltype_name	text	2147483647
feature_marker_relationship_type	fmreltype_produces_affected_marker	bool	1			false
feature_prefix	fp_date_entered	timestamp	29,6			now()
feature_prefix	fp_institute_display	text	2147483647
feature_prefix	fp_prefix	text	2147483647
feature_protein_mutation_detail	fpmd_fdbcont_zdb_id	text	2147483647	√		null
feature_protein_mutation_detail	fpmd_feature_zdb_id	text	2147483647
feature_protein_mutation_detail	fpmd_mutant_or_stop_protein_term_zdb_id	text	2147483647	√		null
feature_protein_mutation_detail	fpmd_number_amino_acids_added	int8	19	√		null
feature_protein_mutation_detail	fpmd_number_amino_acids_removed	int8	19	√		null
feature_protein_mutation_detail	fpmd_protein_consequence_term_zdb_id	text	2147483647	√		null
feature_protein_mutation_detail	fpmd_protein_position_end	int8	19	√		null
feature_protein_mutation_detail	fpmd_protein_position_start	int8	19	√		null
feature_protein_mutation_detail	fpmd_sequence_of_reference_accession_number	text	2147483647	√		null
feature_protein_mutation_detail	fpmd_wt_protein_term_zdb_id	text	2147483647	√		null
feature_protein_mutation_detail	fpmd_zdb_id	text	2147483647
mapped_marker	framework_t	bool	1	√		null
feature_stats	fstat_feat_zdb_id	text	2147483647
feature_stats_old	fstat_feat_zdb_id	text	2147483647
feature_stats	fstat_fig_zdb_id	text	2147483647
feature_stats_old	fstat_fig_zdb_id	text	2147483647
feature_stats	fstat_gene_zdb_id	text	2147483647	√		null
feature_stats_old	fstat_gene_zdb_id	text	2147483647	√		null
feature_stats	fstat_img_zdb_id	text	2147483647	√		null
feature_stats_old	fstat_img_zdb_id	text	2147483647	√		null
feature_stats	fstat_pub_zdb_id	text	2147483647
feature_stats_old	fstat_pub_zdb_id	text	2147483647
feature_stats	fstat_subterm_zdb_id	text	2147483647
feature_stats_old	fstat_subterm_zdb_id	text	2147483647
feature_stats	fstat_superterm_zdb_id	text	2147483647
feature_stats_old	fstat_superterm_zdb_id	text	2147483647
feature_stats	fstat_type	varchar	20	√		null
feature_stats_old	fstat_type	varchar	20	√		null
feature_stats	fstat_xpatres_zdb_id	int8	19
feature_stats_old	fstat_xpatres_zdb_id	int8	19
feature_tracking	ft_date_entered	timestamp	29,6			now()
feature_tracking	ft_feature_abbrev	text	2147483647
feature_tracking	ft_feature_name	text	2147483647
feature_tracking	ft_feature_zdb_id	text	2147483647
feature_transcript_mutation_detail	ftmd_exon_number	int8	19	√		null
feature_transcript_mutation_detail	ftmd_feature_zdb_id	text	2147483647
feature_transcript_mutation_detail	ftmd_intron_number	int8	19	√		null
feature_transcript_mutation_detail	ftmd_transcript_consequence_term_zdb_id	text	2147483647
feature_transcript_mutation_detail	ftmd_zdb_id	text	2147483647
feature_type_mutagen_group_member	ftmgm_feature_type	text	2147483647
feature_type_mutagen_group_member	ftmgm_mutagen	text	2147483647
feature_type_ordering	fto_name	text	2147483647
feature_type_ordering	fto_priority	int4	10			0
ftrconsequence	ftr	text	2147483647	√		null
ftrconsequencenew	ftr	text	2147483647	√		null
ftrmutdets	ftr	text	2147483647	√		null
ftrmutdetssanger	ftr	text	2147483647	√		null
tmp_ftrchrdate	ftr	text	2147483647	√		null
tmp_ftrchrdate2	ftr	text	2147483647	√		null
aa	ftr1	text	2147483647	√		null
aa	ftr2	text	2147483647	√		null
aa	ftr3	text	2147483647	√		null
aa	ftr4	text	2147483647	√		null
feature	ftr_chr_info_date	timestamp	29,6	√		null
feature_type_group	ftrgrp_comments	text	2147483647
feature_type_group	ftrgrp_name	text	2147483647
feature_type_group_member	ftrgrpmem_ftr_type	text	2147483647
feature_type_group_member	ftrgrpmem_ftr_type_group	text	2147483647
tmp_zirc_geno	ftrid	text	2147483647	√		null
tmp_ftrchrdate	ftrnote	text	2147483647	√		null
tmp_ftrchrdate2	ftrnote	text	2147483647	√		null
tmp_ftrnote	ftrnote	text	2147483647	√		null
tmp_ftrchrdate	ftrstring	text	2147483647	√		null
tmp_ftrchrdate2	ftrstring	text	2147483647	√		null
tmp_ftrnote	ftrtype	text	2147483647	√		null
feature_type	ftrtype_name	text	2147483647
feature_type	ftrtype_significance	int4	10	√		null
feature_type	ftrtype_type_display	text	2147483647	√		null
person	full_name	text	2147483647
primer_set	fwd_primer	text	2147483647	√		null
genotype_component_significance	gcs_fmrel_type	text	2147483647
genotype_component_significance	gcs_ftr_type	text	2147483647
genotype_component_significance	gcs_mrkr_type	text	2147483647
genotype_component_significance	gcs_significance	int4	10
gene_description	gd_description	text	2147483647	√		null
gene_description	gd_do_biomarker_description	text	2147483647	√		null
gene_description	gd_do_description	text	2147483647	√		null
gene_description	gd_do_experimental_description	text	2147483647	√		null
gene_description	gd_do_orthology_description	text	2147483647	√		null
gene_description	gd_gene_zdb_id	text	2147483647
gene_description	gd_go_component_description	text	2147483647	√		null
gene_description	gd_go_description	text	2147483647	√		null
gene_description	gd_go_function_description	text	2147483647	√		null
gene_description	gd_go_process_description	text	2147483647	√		null
gene_description	gd_orthology_description	text	2147483647	√		null
dupcrispr	gene	varchar	50	√		null
tmp_to_convert	gene_id	text	2147483647	√		null
seqvar	geneabb	text	2147483647	√		null
featurezmp	geneabbrev	text	2147483647
featurezmpdata	geneabbrev	text	2147483647
ensdarg_post_proc	geneid	text	2147483647
featuregenedata	geneid	text	2147483647
seqvar	geneid	text	2147483647	√		null
tmp_rnac_zfin	geneid	text	2147483647	√		null
featmkr	genezdb	text	2147483647	√		null
genotype	geno_complexity_order	int4	10			999999999
genotype	geno_date_entered	timestamp	29,6	√		now()
genotype	geno_display_name	text	2147483647
genotype	geno_handle	text	2147483647
genotype	geno_is_extinct	bool	1	√		false
genotype	geno_is_wildtype	bool	1	√		false
genotype	geno_name_order	text	2147483647	√		null
genotype	geno_nickname	text	2147483647	√		null
genotype	geno_supplier_stock_number	text	2147483647	√		null
genotype	geno_zdb_id	text	2147483647
genotype_background	genoback_background_zdb_id	text	2147483647
genotype_background	genoback_geno_zdb_id	text	2147483647
genotype_feature	genofeat_dad_zygocity	text	2147483647	√		null
genotype_feature	genofeat_feature_zdb_id	text	2147483647
genotype_feature	genofeat_geno_zdb_id	text	2147483647
genotype_feature	genofeat_mom_zygocity	text	2147483647	√		null
genotype_feature	genofeat_zdb_id	text	2147483647
genotype_feature	genofeat_zygocity	text	2147483647
fish_experiment	genox_exp_zdb_id	text	2147483647
tmp_fish_thatfitthebill	genox_exp_zdb_id	text	2147483647	√		null
tmp_fishnoeap	genox_exp_zdb_id	text	2147483647	√		null
tmp_genox_restore	genox_exp_zdb_id	text	2147483647	√		null
fish_experiment	genox_fish_zdb_id	text	2147483647
tmp_genox_restore	genox_fish_zdb_id	text	2147483647	√		null
fish_genox	genox_id	text	2147483647	√		null
fish_experiment	genox_is_standard	bool	1	√		false
tmp_genox_restore	genox_is_standard	bool	1	√		null
fish_experiment	genox_is_std_or_generic_control	bool	1	√		false
tmp_genox_restore	genox_is_std_or_generic_control	bool	1	√		null
fish_experiment	genox_zdb_id	text	2147483647
tmp_fish_thatfitthebill	genox_zdb_id	text	2147483647	√		null
tmp_fishnoeap	genox_zdb_id	text	2147483647	√		null
tmp_genox_restore	genox_zdb_id	text	2147483647	√		null
genox_fish_annotation_search	genoxfas_fas_id	int8	19
genox_fish_annotation_search_bkup	genoxfas_fas_id	int8	19
genox_fish_annotation_search_temp	genoxfas_fas_id	int8	19
genox_fish_annotation_search	genoxfas_genox_zdb_id	text	2147483647
genox_fish_annotation_search_bkup	genoxfas_genox_zdb_id	text	2147483647
genox_fish_annotation_search_temp	genoxfas_genox_zdb_id	text	2147483647
genedom_family_name	gfam_name	text	2147483647
genedom_family_member	gfammem_gfam_name	text	2147483647
genedom_family_member	gfammem_mrkr_zdb_id	text	2147483647
gff3	gff_biotype	text	2147483647	√		null
gff3	gff_end	int4	10	√		null
gff3	gff_feature	text	2147483647	√		null
gff3	gff_frame	bpchar	1	√		null
gff3	gff_id	text	2147483647
gff3	gff_name	text	2147483647	√		null
gff3	gff_parent	text	2147483647	√		null
gff3	gff_score	text	2147483647	√		null
gff3	gff_seqname	text	2147483647	√		null
gff3	gff_source	text	2147483647	√		null
gff3	gff_start	int4	10	√		null
gff3	gff_strand	bpchar	1	√		null
genotype_figure_fast_search	gffs_date_created	timestamp	29,6			now()
genotype_figure_fast_search	gffs_fig_zdb_id	text	2147483647
genotype_figure_fast_search	gffs_fish_zdb_id	text	2147483647
genotype_figure_fast_search	gffs_geno_zdb_id	text	2147483647
genotype_figure_fast_search	gffs_genox_zdb_id	text	2147483647	√		null
genotype_figure_fast_search	gffs_morph_zdb_id	text	2147483647	√		null
genotype_figure_fast_search	gffs_pg_id	int8	19
genotype_figure_fast_search	gffs_psg_id	int8	19	√		null
go_flag	gflag_display_order	int4	10
go_flag	gflag_name	text	2147483647
genotype_group	gg_geno_handle	text	2147483647	√		null
genotype_group	gg_geno_name	text	2147483647	√		null
genox_group	gg_genotype_zdb_id	text	2147483647	√		null
genotype_group	gg_group_name	text	2147483647	√		null
genox_group	gg_group_name	text	2147483647	√		null
genox_group_member	ggm_genotype_id	text	2147483647	√		null
genotype_group_member	ggm_group_id	int8	19
genox_group_member	ggm_group_id	int8	19
genotype_group_member	ggm_member_id	text	2147483647
genox_group_member	ggm_member_id	text	2147483647
genotype_group_member	ggm_member_name	text	2147483647	√		null
genotype_group_member	ggm_significance	int4	10	√		null
go_evidence_code	goev_code	text	2147483647
go_evidence_code	goev_display_order	int4	10
go_evidence_code	goev_name	text	2147483647
final491	goid	text	2147483647	√		null
jenk491	goid	text	2147483647	√		null
jenk491b	goid	text	2147483647	√		null
tmp_final	goid	text	2147483647	√		null
go_ontology	gont_ontology_internal_name	text	2147483647	√		null
go_ontology	gont_ontology_name	text	2147483647
go_ontology	gont_order	int4	10
go_term	goterm_go_id	text	2147483647
go_term	goterm_is_obsolete	bool	1			false
go_term	goterm_is_secondary	bool	1			false
go_term	goterm_name	text	2147483647
go_term	goterm_ontology	text	2147483647	√		null
go_term	goterm_zdb_id	text	2147483647
geneprefix_institution	gpi_institution	text	2147483647
geneprefix_institution	gpi_prefix	text	2147483647	√		null
tmp_go	grouped_item	text	2147483647	√		null
htp_category_tag	hct_category_tag	text	2147483647
htp_category_tag	hct_zdb_id	text	2147483647
htp_dataset	hd_date_curated	timestamp	29,6			now()
htp_dataset	hd_original_dataset_id	text	2147483647
htp_dataset	hd_subseries_id	text	2147483647	√		null
htp_dataset	hd_summary	text	2147483647	√		null
htp_dataset	hd_title	text	2147483647	√		null
htp_dataset	hd_zdb_id	text	2147483647
htp_dataset_alternate_identifier	hdai_accession_number	text	2147483647
htp_dataset_alternate_identifier	hdai_hd_zdb_id	text	2147483647
htp_dataset_category_tag	hdct_category_tag	text	2147483647
htp_dataset_category_tag	hdct_dataset_zdb_id	text	2147483647
htp_dataset_publication	hdp_dataset_zdb_id	text	2147483647
htp_dataset_publication	hdp_pub_zdb_id	text	2147483647
htp_dataset_sample	hds_abundance	text	2147483647	√		null
htp_dataset_sample	hds_assay_type	text	2147483647
htp_dataset_sample	hds_assembly	text	2147483647	√		null
htp_dataset_sample	hds_fish_zdb_id	text	2147483647	√		null
htp_dataset_sample	hds_hd_zdb_id	text	2147483647	√		null
htp_dataset_sample	hds_notes	text	2147483647	√		null
htp_dataset_sample	hds_sample_id	text	2147483647	√		null
htp_dataset_sample	hds_sample_title	text	2147483647	√		null
htp_dataset_sample	hds_sample_type	text	2147483647
htp_dataset_sample	hds_sequencing_format	text	2147483647	√		null
htp_dataset_sample	hds_sex	text	2147483647	√		null
htp_dataset_sample	hds_stage_term_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_anatomy_sub_term_qualifier_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_anatomy_sub_term_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_anatomy_super_term_qualifier_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_anatomy_super_term_zdb_id	text	2147483647
htp_dataset_sample_detail	hdsd_cellular_component_term_qualifier_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_cellular_component_term_zdb_id	text	2147483647	√		null
htp_dataset_sample_detail	hdsd_hds_id	int8	19
human_gene_detail	hgd_gene_id	text	2147483647
human_gene_detail	hgd_gene_name	text	2147483647	√		null
human_gene_detail	hgd_gene_symbol	text	2147483647
heavy_chain_isotype	hviso_name	text	2147483647
databasechangelog	id	varchar	255
databasechangeloglock	id	int4	10
feature_audit	id	int4	10	√		null
post_aud	id	int8	19
int_data_source	ids_data_zdb_id	text	2147483647
int_data_source	ids_source_zdb_id	text	2147483647
int_data_supplier	idsup_acc_num	text	2147483647	√		null
int_data_supplier	idsup_avail_state	text	2147483647	√		null
int_data_supplier	idsup_data_zdb_id	text	2147483647
int_data_supplier	idsup_supplier_zdb_id	text	2147483647
tables_in_trouble	idx_scan	int8	19	√		null
int_fdbcont_analysis_tool	ifat_blastdb_zdb_id	text	2147483647
int_fdbcont_analysis_tool	ifat_fdbcont_zdb_id	text	2147483647
int_image_term	iit_img_zdb_id	text	2147483647
int_image_term	iit_term_zdb_id	text	2147483647
company	image	text	2147483647	√		null
lab	image	text	2147483647	√		null
person	image	text	2147483647	√		null
image	img_annotation	text	2147483647	√		null
image	img_comments	text	2147483647	√		null
image	img_direction	text	2147483647
image	img_external_name	text	2147483647	√		null
image	img_fig_zdb_id	text	2147483647	√		null
image	img_form	text	2147483647
image	img_height	int4	10
image	img_image	text	2147483647
image	img_image_with_annotation	text	2147483647	√		null
image	img_image_with_annotation_medium	text	2147483647	√		null
image	img_inserted_by	text	2147483647	√		null
image	img_inserted_date	date	13	√		now()
image	img_is_video_still	bool	1			false
image	img_label	text	2147483647	√		null
image	img_medium	text	2147483647	√		null
image	img_owner_zdb_id	text	2147483647
image	img_preparation	text	2147483647
image	img_thumbnail	text	2147483647
image	img_updated_by	text	2147483647	√		null
image	img_updated_date	date	13	√		now
image	img_view	text	2147483647
image	img_width	int4	10
image	img_zdb_id	text	2147483647
image_direction	imgdir_name	text	2147483647
image_form	imgform_name	text	2147483647
image_preparation	imgprep_name	text	2147483647
image_stage	imgstg_end_stg_zdb_id	text	2147483647
image_stage	imgstg_img_zdb_id	text	2147483647
image_stage	imgstg_start_stg_zdb_id	text	2147483647
image_view	imgview_name	text	2147483647
finalct3	inf	text	2147483647	√		null
finalgo	inf	text	2147483647	√		null
tmp_go1	inf	text	2147483647	√		null
jenk491b	inference	text	2147483647	√		null
inference_group_member	infgrmem_inferred_from	text	2147483647
inference_group_member	infgrmem_mrkrgoev_zdb_id	text	2147483647
inference_group_member	infgrmem_notes	text	2147483647	√		null
int_person_pub	info	text	2147483647	√		null
return_recs	info	text	2147483647	√		null
interpro_protein	ip_interpro_id	text	2147483647
interpro_protein	ip_name	text	2147483647
interpro_protein	ip_type	text	2147483647
zdb_submitters	is_curator	bool	1			false
zdb_submitters	is_student	bool	1	√		false
zdb_submitters	issue_time	timestamp	26,3	√		null
int_vegatype_tscripttype	ivtst_tscriptt_type_id	int8	19
int_vegatype_tscripttype	ivtst_vega_type	text	2147483647
journal	jrnl_abbrev	text	2147483647	√		null
journal	jrnl_abbrev_lower	text	2147483647
journal	jrnl_is_nice	bool	1	√		null
journal	jrnl_isoabbrev	text	2147483647	√		null
journal	jrnl_medabbrev	text	2147483647	√		null
journal	jrnl_name	text	2147483647
journal	jrnl_name_lower	text	2147483647
journal	jrnl_nlmid	text	2147483647	√		null
journal	jrnl_online_issn	text	2147483647	√		null
journal	jrnl_print_issn	text	2147483647	√		null
journal	jrnl_publisher	text	2147483647	√		null
journal	jrnl_zdb_id	text	2147483647
publication	jtype	text	2147483647
return_recs	jump_to	text	2147483647	√		null
publication	keywords	text	2147483647	√		null
mapped_marker	lab	text	2147483647	√		null
databasechangelog	labels	varchar	255	√		null
lab_position	labpos_order	int4	10
lab_position	labpos_position	text	2147483647
person	last_name	text	2147483647
lab_address_update_tracking	laut_lab_zdb_id	text	2147483647
lab_address_update_tracking	laut_new_address	text	2147483647
lab_address_update_tracking	laut_previous_address	text	2147483647
longest_bin_resident_metric	lbrm_date_captured	timestamp	29,6			now()
longest_bin_resident_metric	lbrm_days_in_status_on_this_date	int4	10
longest_bin_resident_metric	lbrm_pub_zdb_id	text	2147483647
longest_bin_resident_metric	lbrm_status_counted	text	2147483647
paneled_markers	lg_location	numeric	8,2	√		null
zmap_pub_pan_mark	lg_location	numeric	8,2
linkage_group	lg_name	text	2147483647
linkage_group	lg_order	int4	10	√		null
lines	line_name	text	2147483647	√		null
lines_tmp	line_name	text	2147483647	√		null
feature_data	line_num	text	2147483647
linkage_member_temp	linkage_zdb_id	text	2147483647	√		null
databasechangelog	liquibase	varchar	20	√		null
linkage_membership_search	lms_distance	numeric	8,2	√		null
linkage_membership_search_bkup	lms_distance	numeric	8,2	√		null
linkage_membership_search_temp	lms_distance	numeric	8,2	√		null
linkage_membership_search	lms_lnkg_zdb_id	text	2147483647
linkage_membership_search_bkup	lms_lnkg_zdb_id	text	2147483647
linkage_membership_search_temp	lms_lnkg_zdb_id	text	2147483647
linkage_membership_search	lms_lnkgmem_id	int8	19
linkage_membership_search_bkup	lms_lnkgmem_id	int8	19
linkage_membership_search_temp	lms_lnkgmem_id	int8	19
linkage_membership_search	lms_lod	numeric	8,2	√		null
linkage_membership_search_bkup	lms_lod	numeric	8,2	√		null
linkage_membership_search_temp	lms_lod	numeric	8,2	√		null
linkage_membership_search	lms_member_1_zdb_id	text	2147483647
linkage_membership_search_bkup	lms_member_1_zdb_id	text	2147483647
linkage_membership_search_temp	lms_member_1_zdb_id	text	2147483647
linkage_membership_search	lms_member_2_zdb_id	text	2147483647
linkage_membership_search_bkup	lms_member_2_zdb_id	text	2147483647
linkage_membership_search_temp	lms_member_2_zdb_id	text	2147483647
linkage_membership_search	lms_units	text	2147483647	√		null
linkage_membership_search_bkup	lms_units	text	2147483647	√		null
linkage_membership_search_temp	lms_units	text	2147483647	√		null
linkage	lnkg_chromosome	text	2147483647
linkage	lnkg_comments	text	2147483647	√		null
linkage_old	lnkg_comments	text	2147483647	√		null
linkage_old	lnkg_or_lg	text	2147483647
linkage	lnkg_source_zdb_id	text	2147483647
linkage	lnkg_submitter_zdb_id	text	2147483647	√		null
linkage_old	lnkg_submitter_zdb_id	text	2147483647	√		null
linkage	lnkg_zdb_id	text	2147483647
linkage_old	lnkg_zdb_id	text	2147483647
linkage_membership	lnkgm_distance	numeric	8,2	√		null
linkage_membership	lnkgm_linkage_zdb_id	text	2147483647
linkage_membership	lnkgm_lod	numeric	8,2	√		null
linkage_membership	lnkgm_member_1_zdb_id	text	2147483647
linkage_membership	lnkgm_member_2_zdb_id	text	2147483647
linkage_membership	lnkgm_metric	text	2147483647	√		null
linkage_membership	lnkgm_pair_old_id	text	2147483647	√		null
linkage_member	lnkgmem_linkage_zdb_id	text	2147483647
linkage_member	lnkgmem_member_zdb_id	text	2147483647
linkage_pair	lnkgpair_distance	numeric	8,2	√		null
linkage_pair	lnkgpair_linkage_zdb_id	text	2147483647	√		null
linkage_pair	lnkgpair_lod	numeric	8,2	√		null
linkage_pair	lnkgpair_metric	text	2147483647	√		null
linkage_pair	lnkgpair_zdb_id	text	2147483647
pg_stat_statements	local_blks_dirtied	int8	19	√		null
pg_stat_statements	local_blks_hit	int8	19	√		null
pg_stat_statements	local_blks_read	int8	19	√		null
pg_stat_statements	local_blks_written	int8	19	√		null
sanger_location	location	int4	10	√		null
seqvar	location	text	2147483647	√		null
burgess_location_post	location1	int4	10	√		null
sanger_location_post	location1	int4	10	√		null
databasechangeloglock	locked	bool	1
databasechangeloglock	lockedby	varchar	255	√		null
databasechangeloglock	lockgranted	timestamp	29,6	√		null
linkages_copy	lod	numeric	8,2	√		null
zdb_submitters	login	text	2147483647	√		null
linkage_pair_member	lpmem_linkage_pair_zdb_id	text	2147483647
linkage_pair_member	lpmem_linkage_zdb_id	text	2147483647
linkage_pair_member	lpmem_member_zdb_id	text	2147483647
linkage_single	lsingle_lnkg_zdb_id	text	2147483647
linkage_single	lsingle_member_zdb_id	text	2147483647
light_chain_isotype	ltiso_name	text	2147483647
linkages_copy	m1_id	text	2147483647	√		null
linkages_copy	m2_id	text	2147483647	√		null
monthly_average_curated_metric	macm_average_stay_in_bin_1	int4	10			0
monthly_average_curated_metric	macm_average_stay_in_bin_2	int4	10			0
monthly_average_curated_metric	macm_average_stay_in_bin_3	int4	10			0
monthly_average_curated_metric	macm_average_stay_in_ortho_bin	int4	10			0
monthly_average_curated_metric	macm_average_stay_in_pheno_bin	int4	10			0
monthly_average_curated_metric	macm_average_stay_in_xpat_bin	int4	10			0
monthly_average_curated_metric	macm_date_captured	timestamp	29,6	√		now()
monthly_average_curated_metric	macm_longest_bin1_number_of_days	int4	10			0
monthly_average_curated_metric	macm_longest_bin2_number_of_days	int4	10			0
monthly_average_curated_metric	macm_longest_bin3_number_of_days	int4	10			0
monthly_average_curated_metric	macm_longest_expression_number_of_days	int4	10			0
monthly_average_curated_metric	macm_longest_ortho_number_of_days	int4	10			0
monthly_average_curated_metric	macm_longest_phenotype_number_of_days	int4	10			0
monthly_average_curated_metric	macm_paper_in_bin_1_longest	text	2147483647	√		null
monthly_average_curated_metric	macm_paper_in_bin_2_longest	text	2147483647	√		null
monthly_average_curated_metric	macm_paper_in_bin_3_longest	text	2147483647	√		null
monthly_average_curated_metric	macm_paper_in_expression_bin_longest	text	2147483647	√		null
monthly_average_curated_metric	macm_paper_in_ortho_bin_longest	text	2147483647	√		null
monthly_average_curated_metric	macm_paper_in_phenotype_bin_longest	text	2147483647	√		null
mapped_marker	map_name	text	2147483647	√		null
paneled_markers	map_name	text	2147483647	√		null
map_metric	mapmetric_code	text	2147483647
map_metric	mapmetric_description	text	2147483647
map_metric	mapmetric_name	text	2147483647	√		null
panels	mappanel_comments	text	2147483647
panels	mappanel_interactive_url	text	2147483647	√		null
panels	mappanel_interactive_url_extra_text	text	2147483647	√		null
panels	mappanel_meiotic_cross_type	text	2147483647	√		null
panels	mappanel_meiotic_num_meioses	int4	10	√		null
panels	mappanel_rh_num_cell_lines	int4	10	√		null
panels	mappanel_rh_rad_dose	text	2147483647	√		null
linkage_member_temp	marker_1_zdb_id	text	2147483647	√		null
linkage_member_temp	marker_2_zdb_id	text	2147483647	√		null
mapped_marker	marker_id	text	2147483647	√		null
primer_set	marker_id	text	2147483647	√		null
mapped_marker	marker_type	text	2147483647
marker_types	marker_type	text	2147483647
pg_stat_statements	max_exec_time	float8	17,17	√		null
pg_stat_statements	max_plan_time	float8	17,17	√		null
monthly_curated_metric	mcm_date_captured	timestamp	29,6			now()
monthly_curated_metric	mcm_number_archived_this_month	int4	10			0
monthly_curated_metric	mcm_number_closed_curated_this_month	int4	10			0
monthly_curated_metric	mcm_number_closed_unread_this_month	int4	10			0
monthly_curated_metric	mcm_number_in_bin_1	int4	10			0
monthly_curated_metric	mcm_number_in_bin_2	int4	10			0
monthly_curated_metric	mcm_number_in_bin_3	int4	10			0
monthly_curated_metric	mcm_number_in_expression_bin	int4	10			0
monthly_curated_metric	mcm_number_in_ortho_bin	int4	10			0
monthly_curated_metric	mcm_number_in_phenotype_bin	int4	10			0
monthly_curated_metric	mcm_pub_arrival_date_month	text	2147483647
monthly_curated_metric	mcm_pub_arrival_date_year	text	2147483647
databasechangelog	md5sum	varchar	35	√		null
mutation_detail_controlled_vocabulary	mdcv_term_abbreviation	text	2147483647	√		null
mutation_detail_controlled_vocabulary	mdcv_term_display_name	text	2147483647
mutation_detail_controlled_vocabulary	mdcv_term_order	int8	19	√		null
mutation_detail_controlled_vocabulary	mdcv_term_zdb_id	text	2147483647
mutation_detail_controlled_vocabulary	mdcv_used_in	text	2147483647
pg_stat_statements	mean_exec_time	float8	17,17	√		null
pg_stat_statements	mean_plan_time	float8	17,17	√		null
mesh_term	mesht_mesh_id	text	2147483647
mesh_term	mesht_term_name	text	2147483647
mesh_term	mesht_type	text	2147483647
final491	messup	text	2147483647	√		null
jenk491	messup	text	2147483647	√		null
jenk491b	messup	text	2147483647	√		null
tmp_final	messup	text	2147483647	√		null
mapped_marker	metric	text	2147483647	√		null
paneled_markers	metric	text	2147483647	√		null
panels	metric	text	2147483647
zmap_pub_pan_mark	metric	text	2147483647
mutant_fast_search	mfs_data_zdb_id	text	2147483647
mutant_fast_search	mfs_genox_zdb_id	text	2147483647
paneled_markers	mghframework	bool	1	√		null
zmap_pub_pan_mark	mghframework	bool	1
marker_go_term_annotation_extension	mgtae_dblink_zdb_id	text	2147483647	√		null
marker_go_term_annotation_extension	mgtae_extension_group_id	int8	19
marker_go_term_annotation_extension	mgtae_identifier_term_zdb_id	text	2147483647	√		null
marker_go_term_annotation_extension	mgtae_relationship_term_zdb_id	text	2147483647
marker_go_term_annotation_extension	mgtae_term_text	text	2147483647	√		null
marker_go_term_annotation_extension_group	mgtaeg_mrkrgoev_zdb_id	text	2147483647
mesh_heading	mh_descriptor_is_major_topic	bool	1			false
mesh_heading	mh_mesht_mesh_descriptor_id	text	2147483647
mesh_heading	mh_pub_zdb_id	text	2147483647
marker_history_audit	mha_insert_date	timestamp	29,6			now()
marker_history_audit	mha_mrkr_abbrev_after	text	2147483647
marker_history_audit	mha_mrkr_abbrev_before	text	2147483647
marker_history_audit	mha_mrkr_name_after	text	2147483647	√		null
marker_history_audit	mha_mrkr_name_before	text	2147483647	√		null
marker_history_audit	mha_mrkr_zdb_id	text	2147483647
marker_history	mhist_comments	text	2147483647	√		null
marker_history	mhist_dalias_zdb_id	text	2147483647	√		null
marker_history	mhist_date	timestamp	29,6
marker_history	mhist_event	text	2147483647
marker_history	mhist_mrkr_abbrev_on_mhist_date	text	2147483647
marker_history	mhist_mrkr_name_on_mhist_date	text	2147483647
marker_history	mhist_mrkr_prev_name	text	2147483647	√		null
marker_history	mhist_mrkr_zdb_id	text	2147483647
marker_history	mhist_reason	text	2147483647	√		null
marker_history	mhist_zdb_id	text	2147483647
marker_history_reason	mhistrsn_name	text	2147483647
marker_history_event	mhistvnt_name	text	2147483647
mesh_heading_qualifier	mhq_is_major_topic	bool	1			false
mesh_heading_qualifier	mhq_mesh_heading_id	int8	19
mesh_heading_qualifier	mhq_mesht_mesh_qualifier_id	text	2147483647
pg_stat_statements	min_exec_time	float8	17,17	√		null
pg_stat_statements	min_plan_time	float8	17,17	√		null
mapped_marker	mm_chrom_location	numeric	8,2	√		null
mapped_marker	mm_chromosome	text	2147483647
merge_markers_sql	mms_mrkr_1_zdb_id	text	2147483647
merge_markers_sql	mms_mrkr_2_zdb_id	text	2147483647
merge_markers_sql	mms_sql	text	2147483647
zmap_pub_pan_mark	mname	text	2147483647
tmp_rnac_zfin	mod	text	2147483647	√		null
marker_relationship	mrel_comments	text	2147483647	√		null
marker_relationship	mrel_mrkr_1_zdb_id	text	2147483647
marker_relationship	mrel_mrkr_2_zdb_id	text	2147483647
marker_relationship	mrel_type	text	2147483647
marker_relationship	mrel_zdb_id	text	2147483647
marker_relationship_type	mreltype_1_to_2_comments	text	2147483647
marker_relationship_type	mreltype_2_to_1_comments	text	2147483647
marker_relationship_type	mreltype_mrkr_type_group_1	text	2147483647
marker_relationship_type	mreltype_mrkr_type_group_2	text	2147483647
marker_relationship_type	mreltype_name	text	2147483647
marker	mrkr_abbrev	text	2147483647
tmp_go	mrkr_abbrev	text	2147483647	√		null
marker	mrkr_abbrev_order	text	2147483647
marker	mrkr_comments	text	2147483647	√		null
marker	mrkr_name	text	2147483647
marker	mrkr_name_order	text	2147483647
marker	mrkr_owner	text	2147483647
marker	mrkr_type	text	2147483647
finalct3	mrkr_zdb_id	text	2147483647	√		null
finalgo	mrkr_zdb_id	text	2147483647	√		null
marker	mrkr_zdb_id	text	2147483647
tmp_go	mrkr_zdb_id	text	2147483647	√		null
tmp_go1	mrkr_zdb_id	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_annotation_organization	int8	19
marker_go_term_evidence	mrkrgoev_annotation_organization_created_by	text	2147483647			'ZFIN'::text
marker_go_term_evidence	mrkrgoev_contributed_by	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_date_entered	timestamp	29,6	√		now()
marker_go_term_evidence	mrkrgoev_date_modified	timestamp	29,6	√		now()
marker_go_term_evidence	mrkrgoev_evidence_code	text	2147483647
marker_go_term_evidence	mrkrgoev_external_load_date	timestamp	29,6	√		null
marker_go_term_evidence	mrkrgoev_gflag_name	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_modified_by	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_mrkr_zdb_id	text	2147483647
marker_go_term_evidence	mrkrgoev_notes	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_protein_dblink_zdb_id	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_relation_qualifier	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_relation_term_zdb_id	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_source_zdb_id	text	2147483647
marker_go_term_evidence	mrkrgoev_tag_submit_format	text	2147483647	√		null
marker_go_term_evidence	mrkrgoev_term_zdb_id	text	2147483647
marker_go_term_evidence	mrkrgoev_zdb_id	text	2147483647
tmp_go	mrkrgoev_zdb_id	text	2147483647	√		null
tmp_go1	mrkrgoev_zdb_id	text	2147483647	√		null
marker_go_term_evidence_annotation_organization	mrkrgoevas_annotation_organization	text	2147483647
marker_go_term_evidence_annotation_organization	mrkrgoevas_definition	text	2147483647
marker_go_term_evidence_annotation_organization	mrkrgoevas_organization_url	text	2147483647	√		null
marker_go_term_evidence_annotation_created_by_source	mrkrgoevcb_name	text	2147483647
marker_go_term_evidence_annotation_created_by_source	mrkrgoevcb_url	text	2147483647	√		null
marker_types	mrkrtype_significance	int4	10	√		null
marker_types	mrkrtype_type_display	text	2147483647	√		null
marker_type_group	mtgrp_comments	text	2147483647
marker_type_group	mtgrp_display_name	text	2147483647	√		null
marker_type_group	mtgrp_name	text	2147483647
marker_type_group	mtgrp_searchable	bool	1	√		false
marker_type_group_member	mtgrpmem_mrkr_type	text	2147483647
marker_type_group_member	mtgrpmem_mrkr_type_group	text	2147483647
marker_to_protein	mtp_mrkr_zdb_id	text	2147483647
marker_to_protein	mtp_uniprot_id	text	2147483647
paneled_markers	mtype	text	2147483647	√		null
zmap_pub_pan_mark	mtype	text	2147483647
mutagee	mutagee_name	text	2147483647
mutagen	mutagen_name	text	2147483647
tmp_feature	mutationtype	text	2147483647	√		null
seqvar	mutdesc	text	2147483647	√		null
seqvar	mutname	text	2147483647	√		null
seqvar	mutterm	text	2147483647	√		null
seqvar	muttype	text	2147483647	√		null
company	name	text	2147483647	√		null
lab	name	text	2147483647
panels	name	text	2147483647
person	name	text	2147483647	√		null
zdb_submitters	name	text	2147483647	√		null
tmpcne	nccrabbrev	text	2147483647	√		null
tmpcne	nccrid	text	2147483647	√		null
tmpcne	nccrname	text	2147483647	√		null
tmpcne	nccrtype	text	2147483647	√		null
updates	new_value	text	2147483647	√		null
person	nicknames	text	2147483647	√		null
noctua_model	nm_id	text	2147483647
noctua_model_annotation	nma_mrkrgoev_zdb_id	text	2147483647
noctua_model_annotation	nma_nm_id	text	2147483647
name_precedence	nmprec_comments	text	2147483647
name_precedence	nmprec_precedence	text	2147483647
name_precedence	nmprec_significance	int4	10
ncbi_ortholog_alias	noa_alias	text	2147483647
ncbi_ortholog_alias	noa_ncbi_gene_id	text	2147483647
ncbi_ortholog_external_reference	noer_fdbcont_zdb_id	text	2147483647
ncbi_ortholog_external_reference	noer_other_species_accession_number	text	2147483647
ncbi_ortholog_external_reference	noer_other_species_ncbi_gene_id	text	2147483647
ncbi_ortholog	noi_chromosome	text	2147483647	√		null
ncbi_ortholog	noi_entry_time	timestamp	29,6	√		null
ncbi_ortholog	noi_name	text	2147483647	√		null
ncbi_ortholog	noi_ncbi_gene_id	text	2147483647
ncbi_ortholog	noi_symbol	text	2147483647	√		null
ncbi_ortholog	noi_taxid	int4	10
person	nonzf_pubs	text	2147483647	√		null
obsolete_term_replacement	obstermrep_term_replacement_zdb_id	text	2147483647
obsolete_term_replacement	obstermrep_term_zdb_id	text	2147483647
obsolete_term_suggestion	obstermsug_term_suggestion_zdb_id	text	2147483647
obsolete_term_suggestion	obstermsug_term_zdb_id	text	2147483647
ortholog_external_reference	oef_accession_number	text	2147483647
ortholog_external_reference	oef_fdbcont_zdb_id	text	2147483647
ortholog_external_reference	oef_ortho_zdb_id	text	2147483647
ortholog_evidence	oev_evidence_code	bpchar	2
ortholog_evidence	oev_evidence_term_zdb_id	text	2147483647
ortholog_evidence	oev_ortho_zdb_id	text	2147483647
ortholog_evidence	oev_pub_zdb_id	text	2147483647
ortholog_evidence_code	oevcode_code	bpchar	2
ortholog_evidence_code	oevcode_name	text	2147483647
ortholog_evidence_code	oevcode_order	int4	10
updates	old_value	text	2147483647	√		null
ortholog_load_tracking	olt_last_run	timestamp	29,6
ortholog_load_tracking	olt_load_name	text	2147483647
ortholog_load_tracking	olt_number_of_flybase_links	text	2147483647
ortholog_load_tracking	olt_number_of_gene_links	text	2147483647
ortholog_load_tracking	olt_number_of_hgnc_links	text	2147483647
ortholog_load_tracking	olt_number_of_mgi_links	text	2147483647
ortholog_load_tracking	olt_number_of_omim_links	text	2147483647
omim_phenotype	omimp_human_gene_id	text	2147483647	√		null
omim_phenotype	omimp_name	text	2147483647
omim_phenotype	omimp_omim_id	text	2147483647	√		null
omim_phenotype	omimp_ortho_zdb_id	text	2147483647	√		null
person	on_dist_list	bool	1	√		null
final491	ont	text	2147483647	√		null
finalct3	ont	text	2147483647	√		null
finalgo	ont	text	2147483647	√		null
jenk491	ont	text	2147483647	√		null
jenk491b	ont	text	2147483647	√		null
tmp_final	ont	text	2147483647	√		null
tmp_go	ont	text	2147483647	√		null
tmp_go1	ont	text	2147483647	√		null
ontology	ont_current_date	text	2147483647	√		null
ontology	ont_data_version	text	2147483647	√		null
ontology	ont_default_namespace	text	2147483647	√		null
ontology	ont_format_version	text	2147483647	√		null
ontology	ont_import	text	2147483647	√		null
ontology	ont_ontology_name	text	2147483647	√		null
ontology	ont_order	int4	10
ontology	ont_remark	text	2147483647	√		null
ontology	ont_saved_by	text	2147483647	√		null
one_to_one_accession	ooa_dblink_acc_num	text	2147483647
one_to_one_accession	ooa_dblink_zdb_id	text	2147483647
one_to_one_accession	ooa_feature_zdb_id	text	2147483647
paneled_markers	or_lg	text	2147483647	√		null
person	orcid_id	text	2147483647	√		null
databasechangelog	orderexecuted	int4	10
organism	organism_common_name	text	2147483647
organism	organism_display_order	int4	10
organism	organism_is_ab_host	bool	1	√		false
organism	organism_is_ab_immun	bool	1	√		false
organism	organism_species	text	2147483647
organism	organism_taxid	int4	10
ortholog	ortho_other_species_chromosome	text	2147483647	√		null
ortholog	ortho_other_species_name	text	2147483647	√		null
ortholog	ortho_other_species_ncbi_gene_id	text	2147483647
ortholog	ortho_other_species_ncbi_gene_is_obsolete	bool	1			false
ortholog	ortho_other_species_symbol	text	2147483647	√		null
ortholog	ortho_other_species_taxid	int4	10	√		null
ortholog	ortho_zdb_id	text	2147483647
ortholog	ortho_zebrafish_gene_zdb_id	text	2147483647
ontology_subset	osubset_ont_id	int8	19
ontology_subset	osubset_subset_definition	text	2147483647
ontology_subset	osubset_subset_name	text	2147483647
ontology_subset	osubset_subset_type	text	2147483647	√		null
feature_data	other_feature_id	text	2147483647	√		null
tmp_zeco_tt	othertermid	text	2147483647	√		null
omimp_termxref_mapping	otm_omimp_id	int8	19
omimp_termxref_mapping	otm_tx_id	int8	19
ensdart_ottdart_mapping	ottdart_id	text	2147483647	√		null
tmp_ottens	ottdartid	text	2147483647	√		null
tscriptens	ottdartid	text	2147483647	√		null
tscriptens1	ottdartid1	text	2147483647	√		null
company	owner	text	2147483647	√		null
lab	owner	text	2147483647	√		null
linkages_copy	owner	text	2147483647	√		null
mapped_marker	owner	text	2147483647	√		null
panels	owner	text	2147483647
person	owner	text	2147483647	√		null
publication	owner	text	2147483647	√		null
missing_xpatfig	oxpatfig_fig_zdb_id	text	2147483647	√		null
missing_xpatfig	oxpatfig_xpatres_zdb_id	text	2147483647	√		null
tmp_feature	pageurl	text	2147483647	√		null
zmap_pub_pan_mark	panel_abbrev	text	2147483647	√		null
panels	panel_date	date	13
zmap_pub_pan_mark	panel_id	text	2147483647
panel_count	panelcnt_chromosome	text	2147483647
panel_count	panelcnt_count	int4	10
panel_count	panelcnt_mrkr_type	text	2147483647
panel_count	panelcnt_or_lg	text	2147483647	√		null
panel_count	panelcnt_panel_zdb_id	text	2147483647
zdb_submitters	password	text	2147483647	√		null
zdb_submitters	password_reset_date	timestamp	26,3	√		null
zdb_submitters	password_reset_key	text	2147483647	√		null
pub_correspondence_subject	pcs_handle	text	2147483647
pub_correspondence_subject	pcs_subject_text	text	2147483647
pub_correspondence_subject	pcs_subject_type	text	2147483647
publication_contact_tracking	pct_contacted_date	timestamp	29,6			now()
publication_contact_tracking	pct_curator_zdb_id	text	2147483647
publication_contact_tracking	pct_gave_up_date	timestamp	29,6	√		null
publication_contact_tracking	pct_pub_zdb_id	text	2147483647
publication_contact_tracking	pct_responded_date	timestamp	29,6	√		null
processing_checklist_task	pct_task	text	2147483647
tmp_zirc_geno	pdf	text	2147483647	√		null
pub_db_xref	pdx_accession_number	text	2147483647
pub_db_xref	pdx_fdbcont_zdb_id	text	2147483647
pub_db_xref	pdx_pub_zdb_id	text	2147483647
person	pers_bio	text	2147483647	√		null
person	pers_is_deceased	bool	1			false
person	pers_is_hidden	bool	1			false
person_author	persauth_author_id	int8	19
person_author	persauth_connected_by	text	2147483647
person_author	persauth_date_connected_date	timestamp	29,6			now()
person_author	persauth_person_zdb_id	text	2147483647
person	person_country	text	2147483647	√		null
publication_file	pf_date_entered	timestamp	29,6			now()
publication_file	pf_file_name	text	2147483647
publication_file	pf_file_type_id	int8	19
publication_file	pf_original_file_name	text	2147483647	√		null
publication_file	pf_pub_zdb_id	text	2147483647
phenotype_figure_group	pfigg_geno_handle	text	2147483647	√		null
phenotype_figure_group	pfigg_geno_name	text	2147483647	√		null
phenotype_figure_group	pfigg_genox_zdb_id	text	2147483647	√		null
phenotype_figure_group	pfigg_group_name	text	2147483647	√		null
phenotype_figure_group_member	pfiggm_group_id	int8	19
phenotype_figure_group_member	pfiggm_member_id	text	2147483647
phenotype_figure_group_member	pfiggm_member_name	text	2147483647	√		null
publication_file_type	pft_type	text	2147483647
publication_file_type	pft_type_order	int8	19
phenotype_source_generated	pg_end_stg_zdb_id	text	2147483647	√		null
phenotype_source_generated_bkup	pg_end_stg_zdb_id	text	2147483647	√		null
phenotype_source_generated_temp	pg_end_stg_zdb_id	text	2147483647	√		null
phenotype_source_generated	pg_fig_zdb_id	text	2147483647	√		null
phenotype_source_generated_bkup	pg_fig_zdb_id	text	2147483647	√		null
phenotype_source_generated_temp	pg_fig_zdb_id	text	2147483647	√		null
phenotype_source_generated	pg_genox_zdb_id	text	2147483647	√		null
phenotype_source_generated_bkup	pg_genox_zdb_id	text	2147483647	√		null
phenotype_source_generated_temp	pg_genox_zdb_id	text	2147483647	√		null
phenotype_source_generated	pg_id	int8	19	√		null
phenotype_source_generated_bkup	pg_id	int8	19	√		null
phenotype_source_generated	pg_start_stg_zdb_id	text	2147483647	√		null
phenotype_source_generated_bkup	pg_start_stg_zdb_id	text	2147483647	√		null
phenotype_source_generated_temp	pg_start_stg_zdb_id	text	2147483647	√		null
phenotype_generated_curated_mapping	pgcm_id_type	text	2147483647	√		null
phenotype_generated_curated_mapping_bkup	pgcm_id_type	text	2147483647	√		null
phenotype_generated_curated_mapping_temp	pgcm_id_type	text	2147483647	√		null
phenotype_generated_curated_mapping	pgcm_pg_id	int8	19	√		null
phenotype_generated_curated_mapping_bkup	pgcm_pg_id	int8	19	√		null
phenotype_generated_curated_mapping_temp	pgcm_pg_id	int8	19	√		null
phenotype_generated_curated_mapping	pgcm_source_id	text	2147483647	√		null
phenotype_generated_curated_mapping_bkup	pgcm_source_id	text	2147483647	√		null
phenotype_generated_curated_mapping_temp	pgcm_source_id	text	2147483647	√		null
phenotype_statement	phenos_created_date	timestamp	29,6	√		now()
phenotype_statement	phenos_entity_1_subterm_zdb_id	text	2147483647	√		null
phenotype_statement	phenos_entity_1_superterm_zdb_id	text	2147483647
phenotype_statement	phenos_entity_2_subterm_zdb_id	text	2147483647	√		null
phenotype_statement	phenos_entity_2_superterm_zdb_id	text	2147483647	√		null
phenotype_statement	phenos_last_modified	timestamp	29,6	√		now()
phenotype_statement	phenos_phenox_pk_id	int8	19
phenotype_statement	phenos_quality_zdb_id	text	2147483647
phenotype_statement	phenos_tag	text	2147483647	√		null
phenotype_experiment	phenox_created_date	timestamp	29,6	√		now()
phenotype_experiment	phenox_end_stg_zdb_id	text	2147483647
phenotype_experiment	phenox_fig_zdb_id	text	2147483647
phenotype_experiment	phenox_genox_zdb_id	text	2147483647
phenotype_experiment	phenox_last_modified	timestamp	29,6	√		now()
phenotype_experiment	phenox_start_stg_zdb_id	text	2147483647
company	phone	text	2147483647	√		null
lab	phone	text	2147483647	√		null
person	phone	text	2147483647	√		null
probe_lib	pl_description	text	2147483647	√		null
probe_lib	pl_develop_stage	text	2147483647	√		null
probe_lib	pl_lab_host	text	2147483647	√		null
probe_lib	pl_lib_name	text	2147483647	√		null
probe_lib	pl_organ	text	2147483647	√		null
probe_lib	pl_organism	text	2147483647	√		null
probe_lib	pl_r_site_1	text	2147483647	√		null
probe_lib	pl_r_site_2	text	2147483647	√		null
probe_lib	pl_sex	text	2147483647	√		null
probe_lib	pl_strain	text	2147483647	√		null
probe_lib	pl_tissue_type	text	2147483647	√		null
probe_lib	pl_url	text	2147483647	√		null
probe_lib	pl_vector	text	2147483647	√		null
probe_lib	pl_zdb_id	text	2147483647	√		null
pg_stat_statements	plans	int8	19	√		null
dupcrispr	pmid	text	2147483647	√		null
publication_note	pnote_curator_zdb_id	text	2147483647
publication_note	pnote_date	timestamp	29,6	√		null
publication_note	pnote_pub_zdb_id	text	2147483647
publication_note	pnote_text	text	2147483647	√		null
publication_note	pnote_zdb_id	text	2147483647
int_person_company	position_id	int8	19	√		null
int_person_lab	position_id	int8	19	√		null
pubmed_publication_author	ppa_author_first_name	text	2147483647	√		null
pubmed_publication_author	ppa_author_last_name	text	2147483647
pubmed_publication_author	ppa_author_middle_name	text	2147483647	√		null
pubmed_publication_author	ppa_publication_zdb_id	text	2147483647	√		null
pubmed_publication_author	ppa_pubmed_id	text	2147483647
publication_processing_checklist	ppc_date_completed	timestamp	29,6	√		now()
publication_processing_checklist	ppc_person_zdb_id	text	2147483647
publication_processing_checklist	ppc_pub_zdb_id	text	2147483647
publication_processing_checklist	ppc_task_id	int8	19
pre_db_link	predblink_acc_num	varchar	50
pre_db_link	predblink_acc_num_display	varchar	50
pre_db_link	predblink_data_zdb_id	varchar	50
pre_db_link	predblink_dblink_zdb_id	varchar	50	√		null
pre_db_link	predblink_fdbcont_zdb_id	varchar	50
pre_feature_marker_relationship	prefmrel_feature_zdb_id	varchar	50	√		null
pre_feature_marker_relationship	prefmrel_marker_zdb_id	varchar	50	√		null
pre_feature_marker_relationship	prefmrel_type	varchar	60	√		null
pre_feature_marker_relationship	prefmrel_zdb_id	varchar	50	√		null
zdb_submitters	previous_login	timestamp	26,3	√		null
tables_in_trouble	priority	text	2147483647	√		null
probe_library	probelib_host	text	2147483647	√		null
probe_library	probelib_name	text	2147483647	√		null
probe_library	probelib_non_zfin_stg_name	text	2147483647	√		null
probe_library	probelib_non_zfin_strain_name	text	2147483647	√		null
probe_library	probelib_non_zfin_tissue_name	text	2147483647	√		null
probe_library	probelib_restriction_sites	text	2147483647	√		null
probe_library	probelib_sex	text	2147483647	√		null
probe_library	probelib_species	text	2147483647
probe_library	probelib_stg_zdb_id	text	2147483647	√		null
probe_library	probelib_strain_zdb_id	text	2147483647	√		null
probe_library	probelib_term_zdb_id	text	2147483647	√		null
probe_library	probelib_tissue_zdb_id	text	2147483647	√		null
probe_library	probelib_url	text	2147483647	√		null
probe_library	probelib_zdb_id	text	2147483647
panels	producer	text	2147483647
phenotype_observation_generated	psg_e1_relation_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e1_relation_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e1_relation_name	text	2147483647	√		null
tmp_fish_thatfitthebill	psg_e1_relation_name	text	2147483647	√		null
tmp_fishnoeap	psg_e1_relation_name	text	2147483647	√		null
phenotype_observation_generated	psg_e1a_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e1a_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e1a_name	text	2147483647	√		null
phenotype_observation_generated	psg_e1a_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e1a_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e1a_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_e1b_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e1b_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e1b_name	text	2147483647	√		null
phenotype_observation_generated	psg_e1b_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e1b_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e1b_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_e2_relation_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e2_relation_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e2_relation_name	text	2147483647	√		null
tmp_fish_thatfitthebill	psg_e2_relation_name	text	2147483647	√		null
tmp_fishnoeap	psg_e2_relation_name	text	2147483647	√		null
phenotype_observation_generated	psg_e2a_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e2a_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e2a_name	text	2147483647	√		null
phenotype_observation_generated	psg_e2a_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e2a_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e2a_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_e2b_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e2b_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e2b_name	text	2147483647	√		null
phenotype_observation_generated	psg_e2b_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_e2b_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_e2b_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_id	int8	19	√		null
phenotype_observation_generated_bkup	psg_id	int8	19	√		null
phenotype_observation_generated	psg_mrkr_abbrev	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_mrkr_abbrev	text	2147483647	√		null
phenotype_observation_generated_temp	psg_mrkr_abbrev	text	2147483647	√		null
phenotype_observation_generated	psg_mrkr_relation	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_mrkr_relation	text	2147483647	√		null
phenotype_observation_generated_temp	psg_mrkr_relation	text	2147483647	√		null
phenotype_observation_generated	psg_mrkr_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_mrkr_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_mrkr_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_pg_id	int8	19	√		null
phenotype_observation_generated_bkup	psg_pg_id	int8	19	√		null
phenotype_observation_generated_temp	psg_pg_id	int8	19	√		null
phenotype_observation_generated	psg_pre_eap_phenotype	bool	1	√		false
phenotype_observation_generated_bkup	psg_pre_eap_phenotype	bool	1	√		false
phenotype_observation_generated_temp	psg_pre_eap_phenotype	bool	1	√		false
phenotype_observation_generated	psg_quality_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_quality_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_quality_name	text	2147483647	√		null
tmp_fish_thatfitthebill	psg_quality_name	text	2147483647	√		null
tmp_fishnoeap	psg_quality_name	text	2147483647	√		null
phenotype_observation_generated	psg_quality_zdb_id	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_quality_zdb_id	text	2147483647	√		null
phenotype_observation_generated_temp	psg_quality_zdb_id	text	2147483647	√		null
phenotype_observation_generated	psg_short_name	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_short_name	text	2147483647	√		null
phenotype_observation_generated_temp	psg_short_name	text	2147483647	√		null
phenotype_observation_generated	psg_tag	text	2147483647	√		null
phenotype_observation_generated_bkup	psg_tag	text	2147483647	√		null
phenotype_observation_generated_temp	psg_tag	text	2147483647	√		null
tmp_fish_thatfitthebill	psg_tag	text	2147483647	√		null
tmp_fishnoeap	psg_tag	text	2147483647	√		null
pheno_term	pt_end_stg_zdb_id	text	2147483647
pheno_term_old	pt_end_stg_zdb_id	text	2147483647
pheno_term	pt_fig_zdb_id	text	2147483647
pheno_term_old	pt_fig_zdb_id	text	2147483647
pheno_term	pt_geno_is_wildtype	bool	1
pheno_term_old	pt_geno_is_wildtype	bool	1
pheno_term	pt_geno_zdb_id	text	2147483647
pheno_term_old	pt_geno_zdb_id	text	2147483647
pheno_term	pt_genox_zdb_id	text	2147483647
pheno_term_old	pt_genox_zdb_id	text	2147483647
pheno_term	pt_pheno_entity	text	2147483647
pheno_term_old	pt_pheno_entity	text	2147483647
pheno_term	pt_pub_zdb_id	text	2147483647
pheno_term_old	pt_pub_zdb_id	text	2147483647
pheno_term	pt_start_stg_zdb_id	text	2147483647
pheno_term_old	pt_start_stg_zdb_id	text	2147483647
pheno_term	pt_tag	text	2147483647	√		null
pheno_term_old	pt_tag	text	2147483647	√		null
pheno_term_fast_search	ptfs_created_date	timestamp	29,6	√		now()
pheno_term_fast_search_tmp	ptfs_created_date	timestamp	29,6	√		now()
pheno_term_fast_search	ptfs_is_direct_annotation	bool	1	√		false
pheno_term_fast_search_tmp	ptfs_is_direct_annotation	bool	1	√		false
pheno_term_fast_search	ptfs_phenos_created_date	timestamp	29,6
pheno_term_fast_search_tmp	ptfs_phenos_created_date	timestamp	29,6
pheno_term_fast_search	ptfs_psg_id	int8	19	√		null
pheno_term_fast_search_tmp	ptfs_psg_id	int8	19	√		null
pheno_term_fast_search	ptfs_tag	text	2147483647	√		null
pheno_term_fast_search_tmp	ptfs_tag	text	2147483647	√		null
pheno_term_fast_search	ptfs_term_zdb_id	text	2147483647
pheno_term_fast_search_tmp	ptfs_term_zdb_id	text	2147483647
pub_tracking_history	pth_claimed_by	text	2147483647	√		null
pub_tracking_history	pth_days_in_status	int4	10	√		null
pub_tracking_history	pth_location_id	int8	19	√		null
pub_tracking_history	pth_pub_zdb_id	text	2147483647
pub_tracking_history	pth_status_id	int8	19
pub_tracking_history	pth_status_insert_date	timestamp	29,6			now()
pub_tracking_history	pth_status_is_current	bool	1			false
pub_tracking_history	pth_status_made_non_current_date	timestamp	29,6	√		null
pub_tracking_history	pth_status_set_by	text	2147483647
protein_to_interpro	pti_domain_end	int4	10	√		null
protein_to_interpro	pti_domain_start	int4	10	√		null
protein_to_interpro	pti_interpro_id	text	2147483647
protein_to_interpro	pti_uniprot_id	text	2147483647
pub_tracking_location	ptl_display_order	int4	10			9999
pub_tracking_location	ptl_location	text	2147483647
pub_tracking_location	ptl_location_definition	text	2147483647
pub_tracking_location	ptl_location_display	text	2147483647
pub_tracking_location	ptl_role	text	2147483647
protein_to_pdb	ptp_pdb_id	text	2147483647
protein_to_pdb	ptp_uniprot_id	text	2147483647
pub_tracking_status	pts_definition	text	2147483647	√		null
pub_tracking_status	pts_hidden_status	bool	1			false
pub_tracking_status	pts_pipeline_pull_down_order	int8	19
pub_tracking_status	pts_status	text	2147483647	√		null
pub_tracking_status	pts_status_display	text	2147483647
pub_tracking_status	pts_status_qualifier	text	2147483647	√		null
pub_tracking_status	pts_terminal_status	bool	1			true
panels	ptype	text	2147483647
cnechr1	pub	text	2147483647	√		null
final491	pub	text	2147483647	√		null
finalct3	pub	text	2147483647	√		null
finalgo	pub	text	2147483647	√		null
jenk491	pub	text	2147483647	√		null
jenk491b	pub	text	2147483647	√		null
tmp_final	pub	text	2147483647	√		null
tmp_go	pub	text	2147483647	√		null
tmp_go1	pub	text	2147483647	√		null
publication	pub_abstract	text	2147483647	√		null
publication	pub_acknowledgment	text	2147483647	√		null
publication	pub_arrival_date	timestamp	29,6			now()
publication	pub_authors_lower	text	2147483647
publication	pub_can_show_images	bool	1			false
publication	pub_completion_date	timestamp	29,6	√		null
publication	pub_date	date	13	√		null
publication	pub_doi	text	2147483647	√		null
publication	pub_errata_and_notes	text	2147483647	√		null
publication	pub_goref_id	text	2147483647	√		null
feature_data	pub_id	text	2147483647	√		null
publication	pub_indexed_by	text	2147483647	√		null
publication	pub_indexed_date	timestamp	29,6	√		null
publication	pub_is_curatable	bool	1			true
publication	pub_is_indexed	bool	1			false
publication	pub_jrnl_zdb_id	text	2147483647
publication	pub_last_correspondence_date	timestamp	29,6	√		null
publication	pub_mid	text	2147483647	√		null
publication	pub_mini_ref	text	2147483647	√		null
publication	pub_pages	text	2147483647	√		null
publication	pub_pmc_id	text	2147483647	√		null
publication	pub_volume	text	2147483647	√		null
publication_correspondence	pubcorr_contacted_date	timestamp	29,6			now()
publication_correspondence	pubcorr_curator_zdb_id	text	2147483647
publication_correspondence	pubcorr_gave_up_date	timestamp	29,6	√		null
publication_correspondence	pubcorr_pub_zdb_id	text	2147483647
publication_correspondence	pubcorr_responded_date	timestamp	29,6	√		null
pub_correspondence_recipient	pubcr_recipient_email_address	text	2147483647	√		null
pub_correspondence_recipient	pubcr_recipient_first_name	text	2147483647	√		null
pub_correspondence_recipient	pubcr_recipient_last_name	text	2147483647	√		null
pub_correspondence_recipient	pubcr_recipient_person_zdb_id	text	2147483647	√		null
pub_correspondence_recipient	pubcr_recipient_sent_email_id	int8	19
pub_correspondence_received_email	pubcre_correspondence_from_email_address	text	2147483647
pub_correspondence_received_email	pubcre_correspondence_from_first_name	text	2147483647	√		null
pub_correspondence_received_email	pubcre_correspondence_from_last_name	text	2147483647	√		null
pub_correspondence_received_email	pubcre_correspondence_from_person_zdb_id	text	2147483647	√		null
pub_correspondence_received_email	pubcre_pub_zdb_id	text	2147483647
pub_correspondence_received_email	pubcre_received_by	text	2147483647	√		null
pub_correspondence_received_email	pubcre_received_date	timestamp	29,6			now()
pub_correspondence_received_email	pubcre_subject	text	2147483647
pub_correspondence_received_email	pubcre_text	text	2147483647	√		null
pub_correspondence_sent_email	pubcse_date_composed	timestamp	29,6			now()
pub_correspondence_sent_email	pubcse_pub_zdb_id	text	2147483647
pub_correspondence_sent_email	pubcse_recipient_group	text	2147483647
pub_correspondence_sent_email	pubcse_sent_by	text	2147483647
pub_correspondence_sent_email	pubcse_subject	text	2147483647
pub_correspondence_sent_email	pubcse_text	text	2147483647
pub_correspondence_sent_email_contains_subject	pubcsecs_sent_email_id	int8	19
pub_correspondence_sent_email_contains_subject	pubcsecs_subject_matter_id	int8	19
pub_correspondence_sent_tracker	pubcst_date_sent	timestamp	29,6			now()
pub_correspondence_sent_tracker	pubcst_gave_up_date	timestamp	29,6	√		null
pub_correspondence_sent_tracker	pubcst_pub_zdb_id	text	2147483647
pub_correspondence_sent_tracker	pubcst_resend	bool	1			false
pub_correspondence_sent_tracker	pubcst_sent_by	text	2147483647
pub_correspondence_sent_tracker	pubcst_sent_email_id	int8	19
publication	pubmed_authors	text	2147483647	√		null
tmp_fish_thatfitthebill	pubmedid	int4	10	√		null
tmp_fishnoeap	pubmedid	int4	10	√		null
tmp_pub	pubzdb	text	2147483647	√		null
tmp_pub3	pubzdb	text	2147483647	√		null
tmp_fish_thatfitthebill	qualityid	varchar	2147483647	√		null
tmp_fishnoeap	qualityid	varchar	2147483647	√		null
pg_stat_statements	query	text	2147483647	√		null
pg_stat_statements	queryid	int8	19	√		null
replaced_accession_number	ran_new_acc_num	text	2147483647
replaced_accession_number	ran_old_acc_num	text	2147483647
updates	rec_id	text	2147483647	√		null
return_recs	rec_update	bool	1	√		null
record_attribution	recattrib_data_zdb_id	text	2147483647
record_attribution	recattrib_source_significance	int4	10	√		null
record_attribution	recattrib_source_type	text	2147483647			'standard'::text
record_attribution	recattrib_source_zdb_id	text	2147483647
sanger_flanking_sequence	ref	text	2147483647
ftrmutdets	ref1	text	2147483647	√		null
ftrmutdetssanger	ref1	text	2147483647	√		null
ftrmutdets	ref2	text	2147483647	√		null
ftrmutdetssanger	ref2	text	2147483647	√		null
mapped_marker	refcross_id	text	2147483647
seqvar	refseq	text	2147483647	√		null
constructrel	region	text	2147483647	√		null
constructreln	region	text	2147483647	√		null
constructrel	relationship	text	2147483647	√		null
constructreln	relationship	text	2147483647	√		null
primer_set	restr_enzyme	text	2147483647	√		null
return_recs	return_form	text	2147483647	√		null
return_recs	return_recid	text	2147483647	√		null
feature_audit	rev	int4	10	√		null
post_aud	rev	int4	10
primer_set	rev_primer	text	2147483647	√		null
revinfo	revtstmp	int8	19	√		null
feature_audit	revtype	int4	10	√		null
post_aud	revtype	int4	10	√		null
tmp_rnac_zfin	rnacid	text	2147483647	√		null
pg_stat_statements	rows	int8	19	√		null
run	run_blastdb	text	2147483647
run	run_date	timestamp	29,6
run	run_name	text	2147483647
run	run_nomen_pub_zdb_id	text	2147483647			'ZDB-PUB-030508-1'::text
run	run_program	text	2147483647
run	run_relation_pub_zdb_id	text	2147483647	√		null
run	run_type	text	2147483647
run	run_version	text	2147483647	√		null
run	run_zdb_id	text	2147483647
run_candidate	runcan_cnd_zdb_id	text	2147483647
run_candidate	runcan_done	bool	1			false
run_candidate	runcan_locked_by	text	2147483647	√		null
run_candidate	runcan_occurrence_order	int4	10
run_candidate	runcan_run_zdb_id	text	2147483647
run_candidate	runcan_zdb_id	text	2147483647
run_program	runprog_program	text	2147483647
run_program	runprog_query_type	text	2147483647	√		null
run_program	runprog_target_type	text	2147483647	√		null
run_type	runtype_name	text	2147483647
source_alias	salias_alias	text	2147483647
source_alias	salias_alias_lower	text	2147483647
source_alias	salias_source_zdb_id	text	2147483647
source_alias	salias_zdb_id	text	2147483647
mapped_marker	scoring_data	text	2147483647	√		null
pmflankseq	seq1	text	2147483647	√		null
pmflankseq	seq2	text	2147483647	√		null
marker_sequence	seq_left_end	text	2147483647	√		null
snp_sequence	seq_left_end	text	2147483647	√		null
marker_sequence	seq_mrkr_zdb_id	text	2147483647
snp_sequence	seq_mrkr_zdb_id	text	2147483647	√		null
marker_sequence	seq_offset_start	int4	10	√		null
snp_sequence	seq_offset_start	int4	10	√		null
marker_sequence	seq_offset_stop	int4	10	√		null
snp_sequence	seq_offset_stop	int4	10	√		null
tables_in_trouble	seq_scan	int8	19	√		null
marker_sequence	seq_sequence	text	2147483647	√		null
snp_sequence	seq_sequence	text	2147483647	√		null
marker_sequence	seq_sequence_2	text	2147483647	√		null
snp_sequence	seq_sequence_2	text	2147483647	√		null
marker_sequence	seq_type	text	2147483647	√		null
snp_sequence	seq_type	text	2147483647	√		null
snp_sequence	seq_variation	text	2147483647	√		null
sequence_ambiguity_code	seqac_meaning	text	2147483647
sequence_ambiguity_code	seqac_symbol	bpchar	1	√		null
missing_varseq	seqref	text	2147483647	√		null
tmp_seqref	seqref1	text	2147483647	√		null
tmp_seqref	seqref2	text	2147483647	√		null
sequence_type	seqtype_comments	text	2147483647	√		null
sequence_type	seqtype_name	text	2147483647
sanger_flanking_sequence_post_proc	sequence	text	2147483647
tmp_feature	sequence	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfcl_acc_num	text	2147483647	√		null
sequence_feature_chromosome_location_temp	sfcl_acc_num	text	2147483647	√		null
sequence_feature_chromosome_location	sfcl_assembly	text	2147483647	√		null
sequence_feature_chromosome_location	sfcl_chromosome	text	2147483647
sequence_feature_chromosome_location_bkup	sfcl_chromosome	text	2147483647
sequence_feature_chromosome_location_temp	sfcl_chromosome	text	2147483647
sequence_feature_chromosome_location	sfcl_chromosome_reference_accession_number	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfcl_data_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_temp	sfcl_data_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfcl_end	int4	10	√		null
sequence_feature_chromosome_location_temp	sfcl_end	int4	10	√		null
sequence_feature_chromosome_location	sfcl_end_position	int4	10	√		null
sequence_feature_chromosome_location	sfcl_evidence_code	text	2147483647
sequence_feature_chromosome_location_bkup	sfcl_fdb_db_id	int8	19	√		null
sequence_feature_chromosome_location_temp	sfcl_fdb_db_id	int8	19	√		null
sequence_feature_chromosome_location	sfcl_feature_zdb_id	text	2147483647
sequence_feature_chromosome_location_bkup	sfcl_location_source	text	2147483647	√		null
sequence_feature_chromosome_location_temp	sfcl_location_source	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfcl_location_subsource	text	2147483647	√		null
sequence_feature_chromosome_location_temp	sfcl_location_subsource	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfcl_start	int4	10	√		null
sequence_feature_chromosome_location_temp	sfcl_start	int4	10	√		null
sequence_feature_chromosome_location	sfcl_start_position	int4	10	√		null
sequence_feature_chromosome_location	sfcl_zdb_id	text	2147483647
sequence_feature_chromosome_location_generated	sfclg_acc_num	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_acc_num	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_acc_num	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_assembly	text	2147483647	√		'GRCv10'::text
sequence_feature_chromosome_location_generated	sfclg_chromosome	text	2147483647
sequence_feature_chromosome_location_generated_bkup	sfclg_chromosome	text	2147483647
sequence_feature_chromosome_location_generated_temp	sfclg_chromosome	text	2147483647
sequence_feature_chromosome_location_generated	sfclg_data_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_data_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_data_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_end	int4	10	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_end	int4	10	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_end	int4	10	√		null
sequence_feature_chromosome_location_generated	sfclg_evidence_code	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_evidence_code	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_evidence_code	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_fdb_db_id	int8	19	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_fdb_db_id	int8	19	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_fdb_db_id	int8	19	√		null
sequence_feature_chromosome_location_generated	sfclg_gbrowse_track	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_gbrowse_track	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_gbrowse_track	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_location_source	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_location_source	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_location_source	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_location_subsource	text	2147483647	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_location_subsource	text	2147483647	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_location_subsource	text	2147483647	√		null
sequence_feature_chromosome_location_bkup	sfclg_pub_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_pub_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_temp	sfclg_pub_zdb_id	text	2147483647	√		null
sequence_feature_chromosome_location_generated	sfclg_start	int4	10	√		null
sequence_feature_chromosome_location_generated_bkup	sfclg_start	int4	10	√		null
sequence_feature_chromosome_location_generated_temp	sfclg_start	int4	10	√		null
burgess_location_post	sfclid	varchar	50	√		null
sanger_location_post	sfclid	varchar	50	√		null
source_feature_prefix	sfp_current_designation	bool	1			true
source_feature_prefix	sfp_prefix_id	int8	19
source_feature_prefix	sfp_source_zdb_id	text	2147483647
pg_stat_statements	shared_blks_dirtied	int8	19	√		null
pg_stat_statements	shared_blks_hit	int8	19	√		null
pg_stat_statements	shared_blks_read	int8	19	√		null
pg_stat_statements	shared_blks_written	int8	19	√		null
single	sngl_one	text	2147483647	√		null
snp_download	snpd_mrkr_zdb_id	text	2147483647
snp_download	snpd_rs_acc_num	text	2147483647
snp_download_attribution	snpdattr_pub_zdb_id	text	2147483647
snp_download_attribution	snpdattr_snpd_pk_id	int4	10
panels	source	text	2147483647
primer_set	source	text	2147483647	√		null
int_person_company	source_id	text	2147483647
int_person_lab	source_id	text	2147483647
int_person_pub	source_id	text	2147483647
source_url	srcurl_display_text	text	2147483647
source_url	srcurl_purpose	text	2147483647			'information'::text
source_url	srcurl_source_zdb_id	text	2147483647
source_url	srcurl_url	text	2147483647
source_url_purpose	srcurlpurp_comments	text	2147483647	√		null
source_url_purpose	srcurlpurp_name	text	2147483647
cnechr	startchr	int4	10	√		null
company	status	text	2147483647	√		null
int_person_company	status	text	2147483647	√		null
int_person_lab	status	text	2147483647	√		null
int_person_pub	status	text	2147483647	√		null
lab	status	text	2147483647	√		null
panels	status	text	2147483647
publication	status	text	2147483647	√		null
state_code	stc_code	text	2147483647
state_code	stc_display_order	int4	10	√		null
state_code	stc_name	text	2147483647
pg_stat_statements	stddev_exec_time	float8	17,17	√		null
pg_stat_statements	stddev_plan_time	float8	17,17	√		null
stage	stg_abbrev	text	2147483647	√		null
stage	stg_hours_end	numeric	7,2
stage	stg_hours_start	numeric	7,2
stage	stg_name	text	2147483647	√		null
stage	stg_name_ext	text	2147483647	√		null
stage	stg_name_long	text	2147483647	√		null
stage	stg_obo_id	text	2147483647
stage	stg_other_features	text	2147483647	√		null
stage	stg_zdb_id	text	2147483647
cnechr1	stlocation	int4	10	√		null
primer_set	strain_id	text	2147483647	√		null
featmkr	strand	text	2147483647	√		null
sanger_flanking_sequence	strand	text	2147483647
str_group	strg_genox_zdb_id	text	2147483647	√		null
str_group	strg_group_name	text	2147483647	√		null
mapped_marker	submitter	text	2147483647	√		null
updates	submitter_id	text	2147483647	√		null
updates	submitter_name	text	2147483647	√		null
tables_in_trouble	sz_n_byts	int8	19	√		null
so_zfin_mapping	szm_object_type	text	2147483647
so_zfin_mapping	szm_term_name	text	2147483647
so_zfin_mapping	szm_term_ont_id	text	2147483647
tables_in_trouble	table_in_trouble	text	2147483647	√		null
databasechangelog	tag	varchar	255	√		null
paneled_markers	target_abbrev	text	2147483647	√		null
zmap_pub_pan_mark	target_abbrev	text	2147483647
int_person_company	target_id	text	2147483647
int_person_lab	target_id	text	2147483647
int_person_pub	target_id	text	2147483647
paneled_markers	target_id	text	2147483647	√		null
zmap_pub_pan_mark	target_id	text	2147483647
tmp_rnac_zfin	taxon	text	2147483647	√		null
tables_in_trouble	tbl_rec_count	text	2147483647	√		null
pg_stat_statements	temp_blks_read	int8	19	√		null
pg_stat_statements	temp_blks_written	int8	19	√		null
term	term_comment	text	2147483647	√		null
term	term_definition	text	2147483647	√		null
term	term_is_obsolete	bool	1			false
term	term_is_root	bool	1			false
term	term_is_secondary	bool	1			false
term	term_name	text	2147483647
term	term_name_order	text	2147483647	√		null
finalct3	term_ont_id	text	2147483647	√		null
finalgo	term_ont_id	text	2147483647	√		null
term	term_ont_id	text	2147483647
tmp_go	term_ont_id	text	2147483647	√		null
tmp_go1	term_ont_id	text	2147483647	√		null
term	term_ontology	text	2147483647	√		null
term	term_ontology_id	int8	19
term	term_primary_subset_id	int8	19	√		null
term	term_zdb_id	text	2147483647
term_relationship	termrel_term_1_zdb_id	text	2147483647
term_relationship	termrel_term_2_zdb_id	text	2147483647
term_relationship	termrel_type	text	2147483647
term_relationship	termrel_zdb_id	text	2147483647
term_relationship_type	termreltype_name	text	2147483647
term_subset	termsub_subset_id	int8	19
term_subset	termsub_term_zdb_id	text	2147483647
term_group	tg_geno_handle	text	2147483647	√		null
term_group	tg_geno_name	text	2147483647	√		null
term_group	tg_genox_group	text	2147483647	√		null
term_group	tg_group_name	text	2147483647	√		null
tmp_feature	tgtgeneid	text	2147483647	√		null
tmp_feature	tgtgenesymbol	text	2147483647	√		null
primer_set	the_id	text	2147483647	√		null
post_aud	title	text	2147483647	√		null
publication	title	text	2147483647	√		null
tmp_db_link	tmp_acc_num	text	2147483647	√		null
tmp_db_link	tmp_db_name	text	2147483647	√		null
tmp_db_link	tmp_dblink_zdb_id	text	2147483647	√		null
tmp_db_link	tmp_fdbcont_zdb_id	text	2147483647	√		null
tmp_db_link	tmp_info	text	2147483647	√		null
tmp_db_link	tmp_length	int4	10	√		null
tmp_db_link	tmp_linked_recid	text	2147483647	√		null
pg_stat_statements	total_exec_time	float8	17,17	√		null
pg_stat_statements	total_plan_time	float8	17,17	√		null
term_stage	ts_end_stg_zdb_id	text	2147483647	√		null
transcript_sequence	ts_sequence	text	2147483647	√		null
term_stage	ts_start_stg_zdb_id	text	2147483647	√		null
term_stage	ts_term_zdb_id	text	2147483647	√		null
transcript_sequence	ts_transcript_ottdart_id	text	2147483647
transcript_sequence	ts_transcript_zdb_id	text	2147483647
transcript	tscript_ensdart_id	text	2147483647	√		null
transcript	tscript_load_id	text	2147483647
transcript	tscript_mrkr_zdb_id	text	2147483647
transcript	tscript_status_id	int8	19	√		null
transcript	tscript_type_id	int8	19
tmp_ottens	tscriptid	text	2147483647	√		null
tmp_rnac_zfin	tscriptid	text	2147483647	√		null
tscriptens	tscriptid	text	2147483647	√		null
tscriptsequence	tscriptid	text	2147483647	√		null
tscriptens1	tscriptid1	text	2147483647	√		null
tscriptsequence	tscriptottdart	text	2147483647	√		null
transcript_status	tscripts_display	text	2147483647
transcript_status	tscripts_order	int4	10	√		null
transcript_status	tscripts_status	text	2147483647
tscriptsequence	tscriptseq	text	2147483647	√		null
transcript_type	tscriptt_definition	text	2147483647	√		null
transcript_type	tscriptt_display	text	2147483647
transcript_type	tscriptt_indent	bool	1			false
transcript_type	tscriptt_order	int4	10	√		null
transcript_type	tscriptt_so_id	text	2147483647	√		null
transcript_type	tscriptt_type	text	2147483647
tmp_rnac_zfin	tscripttype	text	2147483647	√		null
tscript_type_status_definition	ttsdef_definition	text	2147483647
tscript_type_status_definition	ttsdef_tscript_status_id	int8	19
tscript_type_status_definition	ttsdef_tscript_type_id	int8	19	√		null
term_xref	tx_accession	text	2147483647	√		null
term_xref	tx_fdb_db_id	int8	19	√		null
term_xref	tx_full_accession	text	2147483647
term_xref	tx_prefix	text	2147483647
term_xref	tx_term_zdb_id	text	2147483647
unique_location	ul_chromosome	text	2147483647
unique_location	ul_data_zdb_id	text	2147483647
protein	up_fdbcont_zdb_id	text	2147483647
protein	up_length	int4	10	√		null
protein	up_uniprot_id	text	2147483647
updates	upd_when	timestamp	26,3	√		null
company	url	text	2147483647	√		null
lab	url	text	2147483647	√		null
person	url	text	2147483647	√		null
url_ref	urlref_data_zdb_id	text	2147483647
url_ref	urlref_display_text	text	2147483647	√		null
url_ref	urlref_full_url	text	2147483647	√		null
url_ref	urlref_zdb_id	text	2147483647
pg_stat_statements	userid	oid	10	√		null
tmp_ftrnote	varianttag	text	2147483647	√		null
sanger_flanking_sequence_post_proc	variation	text	2147483647
pmflankseq	varseq	text	2147483647	√		null
seqvar	varseq	text	2147483647	√		null
pmflankseq	varseqid	text	2147483647	√		null
vector	vector_name	text	2147483647
vector	vector_type_name	text	2147483647			'Not specified'::text
vector_type	vectype_comments	text	2147483647	√		null
vector_type	vectype_name	text	2147483647
variant_flanking_sequence	vfseq_data_zdb_id	text	2147483647
variant_flanking_sequence	vfseq_five_prime_flanking_sequence	text	2147483647	√		null
variant_flanking_sequence	vfseq_flanking_sequence_origin	text	2147483647	√		null
variant_flanking_sequence	vfseq_flanking_sequence_type	text	2147483647	√		null
variant_flanking_sequence	vfseq_offset_start	int4	10	√		null
variant_flanking_sequence	vfseq_offset_stop	int4	10	√		null
variant_flanking_sequence	vfseq_sequence	text	2147483647	√		null
variant_flanking_sequence	vfseq_three_prime_flanking_sequence	text	2147483647	√		null
variant_flanking_sequence	vfseq_type	text	2147483647
variant_flanking_sequence	vfseq_variation	text	2147483647	√		null
variant_flanking_sequence	vfseq_zdb_id	text	2147483647
sanger_flanking_sequence_post_proc	vfseqid	varchar	50	√		null
video	video_image_still_zdb_id	text	2147483647
video	video_path_to_file	text	2147483647
validate_check_history	vldcheck_count	int4	10
validate_check_history	vldcheck_date	timestamp	29,6
validate_check_history	vldcheck_name	text	2147483647
pg_stat_statements	wal_bytes	numeric	131089	√		null
pg_stat_statements	wal_fpi	int8	19	√		null
pg_stat_statements	wal_records	int8	19	√		null
withdrawn_data	wd_display_note	text	2147483647	√		null
withdrawn_data	wd_new_zdb_id	text	2147483647
withdrawn_data	wd_old_zdb_id	text	2147483647
warehouse_run_tracking	wrt_last_loaded_date	timestamp	29,6			now()
warehouse_run_tracking	wrt_mart_load_successful	bool	1	√		true
warehouse_run_tracking	wrt_mart_name	text	2147483647
xpat_exp_details_generated	xedg_assay_name	text	2147483647
xpat_exp_details_generated_bkup	xedg_assay_name	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_assay_name	text	2147483647	√		null
xpat_exp_details_generated	xedg_atb_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_bkup	xedg_atb_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_atb_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_dblink_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_bkup	xedg_dblink_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_dblink_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_direct_submission_date	timestamp	29,6			now()
xpat_exp_details_generated_bkup	xedg_direct_submission_date	timestamp	29,6	√		now()
xpat_exp_details_generated_temp	xedg_direct_submission_date	timestamp	29,6	√		now()
xpat_exp_details_generated	xedg_fig_zdb_id	text	2147483647
xpat_exp_details_generated_bkup	xedg_fig_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_fig_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_gene_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_bkup	xedg_gene_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_gene_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_genox_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_bkup	xedg_genox_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_genox_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_pk_id	int8	19
xpat_exp_details_generated	xedg_probe_feature_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_bkup	xedg_probe_feature_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_probe_feature_zdb_id	text	2147483647	√		null
xpat_exp_details_generated	xedg_zdb_id	text	2147483647
xpat_exp_details_generated_bkup	xedg_zdb_id	text	2147483647	√		null
xpat_exp_details_generated_temp	xedg_zdb_id	text	2147483647	√		null
xpat_figure_group	xfigg_geno_handle	text	2147483647	√		null
xpat_figure_group	xfigg_genox_zdb_id	text	2147483647	√		null
xpat_figure_group	xfigg_group_name	text	2147483647	√		null
xpat_figure_group	xfigg_has_images	bool	1	√		false
xpat_figure_group_member	xfiggm_group_id	int8	19
xpat_figure_group_member	xfiggm_member_id	text	2147483647
xpat_figure_group_member	xfiggm_member_name	text	2147483647	√		null
tmp_efs_map	xpat_found	bool	1	√		null
expression_pattern_assay	xpatassay_abbrev	text	2147483647	√		null
expression_pattern_assay	xpatassay_comments	text	2147483647	√		null
expression_pattern_assay	xpatassay_display_order	int4	10
expression_pattern_assay	xpatassay_mmo_id	text	2147483647	√		null
expression_pattern_assay	xpatassay_name	text	2147483647
expression_experiment	xpatex_assay_name	text	2147483647	√		null
expression_experiment2	xpatex_assay_name	text	2147483647
expression_experiment_bkup	xpatex_assay_name	text	2147483647	√		null
expression_experiment_temp	xpatex_assay_name	text	2147483647	√		null
expression_experiment	xpatex_atb_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_atb_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_atb_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_atb_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_dblink_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_dblink_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_dblink_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_dblink_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_direct_submission_date	timestamp	29,6	√		now()
expression_experiment2	xpatex_direct_submission_date	timestamp	29,6			now()
expression_experiment_bkup	xpatex_direct_submission_date	timestamp	29,6	√		null
expression_experiment_temp	xpatex_direct_submission_date	timestamp	29,6	√		null
expression_experiment	xpatex_gene_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_gene_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_gene_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_gene_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_genox_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_genox_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_genox_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_genox_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_probe_feature_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_probe_feature_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_probe_feature_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_probe_feature_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_source_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_source_zdb_id	text	2147483647	√		null
expression_experiment_bkup	xpatex_source_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_source_zdb_id	text	2147483647	√		null
expression_experiment	xpatex_zdb_id	text	2147483647	√		null
expression_experiment2	xpatex_zdb_id	text	2147483647
expression_experiment_bkup	xpatex_zdb_id	text	2147483647	√		null
expression_experiment_temp	xpatex_zdb_id	text	2147483647	√		null
expression_pattern_figure	xpatfig_fig_zdb_id	text	2147483647	√		null
expression_pattern_figure_bkup	xpatfig_fig_zdb_id	text	2147483647	√		null
expression_pattern_figure_temp	xpatfig_fig_zdb_id	text	2147483647	√		null
expression_pattern_figure	xpatfig_xpatres_zdb_id	int8	19	√		null
expression_pattern_figure_bkup	xpatfig_xpatres_zdb_id	int8	19	√		null
expression_pattern_figure_temp	xpatfig_xpatres_zdb_id	int8	19	√		null
expression_pattern_infrastructure	xpatinf_curator_zdb_id	text	2147483647
expression_pattern_infrastructure	xpatinf_date	timestamp	29,6			now()
expression_pattern_infrastructure	xpatinf_expression_found	bool	1	√		true
expression_pattern_infrastructure	xpatinf_pub_zdb_id	text	2147483647
expression_pattern_infrastructure	xpatinf_quality_term_zdb_id	text	2147483647	√		null
expression_pattern_infrastructure	xpatinf_subterm_zdb_id	text	2147483647	√		null
expression_pattern_infrastructure	xpatinf_superterm_zdb_id	text	2147483647
expression_pattern_infrastructure	xpatinf_tag	text	2147483647	√		null
expression_pattern_infrastructure	xpatinf_zdb_id	text	2147483647
expression_result	xpatres_comments	text	2147483647	√		null
expression_result2	xpatres_efs_id	int8	19
expression_result_bkup	xpatres_end_stage_zdb_id	text	2147483647	√		null
expression_result	xpatres_end_stg_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_end_stg_zdb_id	text	2147483647	√		null
expression_result	xpatres_expression_found	bool	1	√		true
expression_result2	xpatres_expression_found	bool	1
expression_result_bkup	xpatres_expression_found	bool	1	√		null
expression_result_temp	xpatres_expression_found	bool	1	√		null
expression_result	xpatres_fig_zdb_id	text	2147483647	√		null
expression_result_bkup	xpatres_fig_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_fig_zdb_id	text	2147483647	√		null
expression_result_bkup	xpatres_pk_id	int8	19	√		null
expression_result_bkup	xpatres_start_stage_zdb_id	text	2147483647	√		null
expression_result	xpatres_start_stg_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_start_stg_zdb_id	text	2147483647	√		null
tmp_efs_map	xpatres_subterm	text	2147483647	√		null
expression_result	xpatres_subterm_zdb_id	text	2147483647	√		null
expression_result2	xpatres_subterm_zdb_id	text	2147483647	√		null
expression_result_bkup	xpatres_subterm_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_subterm_zdb_id	text	2147483647	√		null
tmp_efs_map	xpatres_superterm	text	2147483647	√		null
expression_result	xpatres_superterm_zdb_id	text	2147483647	√		null
expression_result2	xpatres_superterm_zdb_id	text	2147483647
expression_result_bkup	xpatres_superterm_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_superterm_zdb_id	text	2147483647	√		null
expression_result	xpatres_xpatex_zdb_id	text	2147483647	√		null
expression_result_bkup	xpatres_xpatex_zdb_id	text	2147483647	√		null
expression_result_temp	xpatres_xpatex_zdb_id	text	2147483647	√		null
expression_result	xpatres_zdb_id	int8	19	√		null
xpat_results_generated	xrg_comments	text	2147483647	√		null
xpat_results_generated_bkup	xrg_comments	text	2147483647	√		null
xpat_results_generated_temp	xrg_comments	text	2147483647	√		null
xpat_results_generated	xrg_end_stg_zdb_id	text	2147483647
xpat_results_generated_bkup	xrg_end_stg_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_end_stg_zdb_id	text	2147483647	√		null
xpat_results_generated	xrg_expression_found	bool	1			true
xpat_results_generated_bkup	xrg_expression_found	bool	1	√		true
xpat_results_generated_temp	xrg_expression_found	bool	1	√		true
xpat_results_generated	xrg_pk_id	int8	19
xpat_results_generated	xrg_start_stg_zdb_id	text	2147483647
xpat_results_generated_bkup	xrg_start_stg_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_start_stg_zdb_id	text	2147483647	√		null
xpat_results_generated	xrg_subterm_zdb_id	text	2147483647	√		null
xpat_results_generated_bkup	xrg_subterm_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_subterm_zdb_id	text	2147483647	√		null
xpat_results_generated	xrg_suggested_anatomy_item	text	2147483647	√		null
xpat_results_generated_bkup	xrg_suggested_anatomy_item	text	2147483647	√		null
xpat_results_generated_temp	xrg_suggested_anatomy_item	text	2147483647	√		null
xpat_results_generated	xrg_superterm_zdb_id	text	2147483647
xpat_results_generated_bkup	xrg_superterm_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_superterm_zdb_id	text	2147483647	√		null
xpat_results_generated	xrg_xedg_id	int8	19
xpat_results_generated_bkup	xrg_xedg_id	int8	19	√		null
xpat_results_generated_temp	xrg_xedg_id	int8	19	√		null
xpat_results_generated	xrg_xedg_zdb_id	text	2147483647
xpat_results_generated_bkup	xrg_xedg_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_xedg_zdb_id	text	2147483647	√		null
xpat_results_generated	xrg_zdb_id	text	2147483647
xpat_results_generated_bkup	xrg_zdb_id	text	2147483647	√		null
xpat_results_generated_temp	xrg_zdb_id	text	2147483647	√		null
zfin_accession_number	za_acc_num	text	2147483647
zfin_accession_number	za_date_entered	timestamp	29,6			now()
zfin_accession_number	za_prefix	text	2147483647			'ZFINNUCL'::text
zfin_accession_number	za_sequence_number	int8	19
zdb_active_data	zactvd_zdb_id	text	2147483647
zdb_active_source	zactvs_zdb_id	text	2147483647
company	zdb_id	text	2147483647
lab	zdb_id	text	2147483647
mapped_marker	zdb_id	text	2147483647
paneled_markers	zdb_id	text	2147483647	√		null
panels	zdb_id	text	2147483647
person	zdb_id	text	2147483647
primer_set	zdb_id	text	2147483647
publication	zdb_id	text	2147483647
return_recs	zdb_id	text	2147483647	√		null
tmp_pub2	zdb_id	text	2147483647	√		null
zdb_submitters	zdb_id	text	2147483647
zmap_pub_pan_mark	zdb_id	text	2147483647	√		null
abregistry	zdbid	text	2147483647	√		null
dupcrispr	zdbid	varchar	50	√		null
tmp_ftrchrdate	zdbid	text	2147483647	√		null
tmp_ftrchrdate2	zdbid	text	2147483647	√		null
zebrashare_data_edit_permission	zdep_person_is_submitter	bool	1	√		false
zebrashare_data_edit_permission	zdep_person_zdb_id	text	2147483647
zebrashare_data_edit_permission	zdep_pub_zdb_id	text	2147483647
zebrashare_data_edit_permission	zdep_zdb_id	text	2147483647
tmp_zeco_tt	zecoid	text	2147483647	√		null
zfin_ensembl_gene	zeg_end	int4	10	√		null
zfin_ensembl_gene	zeg_feature	text	2147483647	√		null
zfin_ensembl_gene	zeg_frame	bpchar	1	√		null
zfin_ensembl_gene	zeg_gene_zdb_id	text	2147483647
zfin_ensembl_gene	zeg_id_name	text	2147483647	√		null
zfin_ensembl_gene	zeg_score	text	2147483647	√		null
zfin_ensembl_gene	zeg_seqname	text	2147483647	√		null
zfin_ensembl_gene	zeg_source	text	2147483647	√		null
zfin_ensembl_gene	zeg_start	int4	10	√		null
zfin_ensembl_gene	zeg_strand	bpchar	1	√		null
tmp_addgene	zfingene	text	2147483647	√		null
cnedata	zfishchr	text	2147483647
zdb_flag	zflag_is_on	bool	1
zdb_flag	zflag_last_modified	timestamp	29,6
zdb_flag	zflag_name	text	2147483647
zmap_pub_pan_mark	zmap_chromosome	text	2147483647
zdb_object_type	zobjtype_attribution_display_tier	int4	10	√		2
zdb_object_type	zobjtype_day	date	13
zdb_object_type	zobjtype_home_table	text	2147483647
zdb_object_type	zobjtype_home_zdb_id_column	text	2147483647
zdb_object_type	zobjtype_is_data	bool	1	√		null
zdb_object_type	zobjtype_is_source	bool	1	√		null
zdb_object_type	zobjtype_name	text	2147483647
zdb_orphan_data	zorphand_home_table	text	2147483647	√		null
zdb_orphan_data	zorphand_home_zdb_id_column	text	2147483647	√		null
zdb_orphan_data	zorphand_zdb_id	text	2147483647
zdb_orphan_source	zorphans_home_table	text	2147483647	√		null
zdb_orphan_source	zorphans_home_zdb_id_column	text	2147483647	√		null
zdb_orphan_source	zorphans_zdb_id	text	2147483647
zdb_replaced_data	zrepld_new_zdb_id	text	2147483647
zdb_replaced_data	zrepld_old_name	text	2147483647	√		null
zdb_replaced_data	zrepld_old_zdb_id	text	2147483647
zebrashare_submission_metadata	zsm_lab_of_origin_zdb_id	text	2147483647
zebrashare_submission_metadata	zsm_pub_zdb_id	text	2147483647
zebrashare_submission_metadata	zsm_submitter_email	text	2147483647	√		null
zebrashare_submission_metadata	zsm_submitter_name	text	2147483647	√		null
zebrashare_submission_metadata	zsm_submitter_zdb_id	text	2147483647
zfa_uberon_mapping	zum_uberon_id	varchar	55	√		null
zfa_uberon_mapping	zum_zfa_id	varchar	55	√		null
zfa_uberon_mapping	zum_zfa_term_zdb_id	varchar	55	√		null
zygocity	zyg_abbrev	text	2147483647	√		null
zygocity	zyg_allele_display	text	2147483647	√		null
zygocity	zyg_definition	text	2147483647
zygocity	zyg_gene_prefix	text	2147483647	√		null
zygocity	zyg_geno_ont_id	text	2147483647	√		null
zygocity	zyg_name	text	2147483647
zygocity	zyg_zdb_id	text	2147483647