SchemaSpy Analysis of zfindb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Sep 15 16:40 PDT 2020
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

zfindb.public contains 2327 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
aa file text 2147483647  √  null
aa ftr1 text 2147483647  √  null
aa ftr2 text 2147483647  √  null
aa ftr3 text 2147483647  √  null
aa ftr4 text 2147483647  √  null
abregistry abregid text 2147483647  √  null
abregistry zdbid 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
accession_bank accbk_pk_id bigserial 19  √  nextval('accession_bank_accbk_pk_id_seq'::regclass)
accession_version accver_acc_num text 2147483647
accession_version accver_version int4 10
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
affected_gene_group_member afgm_pk_id bigserial 19  √  nextval('affected_gene_group_member_afgm_pk_id_seq'::regclass)
alias_group aliasgrp_definition text 2147483647  √  null
alias_group aliasgrp_name text 2147483647
alias_group aliasgrp_pk_id bigserial 19  √  nextval('alias_group_aliasgrp_pk_id_seq'::regclass)
alias_group aliasgrp_significance int4 10
alias_scope aliasscope_pk_id bigserial 19  √  nextval('alias_scope_aliasscope_pk_id_seq'::regclass)
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
all_term_contains alltermcon_contained_zdb_id text 2147483647
all_term_contains alltermcon_container_zdb_id text 2147483647
all_term_contains alltermcon_min_contain_distance int4 10
amsterdam_file af_feature_zdb_id text 2147483647
amsterdam_file af_file_location text 2147483647
amsterdam_file af_is_overlapping_file text 2147483647  √  null
amsterdam_file af_pk_id bigserial 19  √  nextval('amsterdam_file_af_pk_id_seq'::regclass)
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
annual_stats as_count int4 10
annual_stats as_date timestamp 29,6
annual_stats as_pk_id bigserial 19  √  nextval('annual_stats_as_pk_id_seq'::regclass)
annual_stats as_section text 2147483647
annual_stats as_type 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
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
apato_tag apatotag_name text 2147483647
attribution_type attype_definition text 2147483647  √  null
attribution_type attype_type text 2147483647
author author_first_name text 2147483647  √  null
author author_institution text 2147483647  √  null
author author_last_name text 2147483647  √  null
author author_pk_id bigserial 19  √  nextval('author_author_pk_id_seq'::regclass)
author_publication authorpub_author_id int8 19
author_publication authorpub_pk_id bigserial 19  √  nextval('author_publication_authorpub_pk_id_seq'::regclass)
author_publication authorpub_pub_zdb_id text 2147483647
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_pk_id bigserial 19  √  nextval('average_curation_time_metric_actm_pk_id_seq'::regclass)
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
average_time_per_person actpp_pk_id bigserial 19  √  nextval('average_time_per_person_actpp_pk_id_seq'::regclass)
bl_plate_tracking blpt_load_number text 2147483647
bl_plate_tracking blpt_pk_id bigserial 19  √  nextval('bl_plate_tracking_blpt_pk_id_seq'::regclass)
bl_plate_tracking blpt_plate 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
blast_database_origination_type bdot_definition text 2147483647
blast_database_origination_type bdot_pk_id bigserial 19  √  nextval('blast_database_origination_type_bdot_pk_id_seq'::regclass)
blast_database_origination_type bdot_type text 2147483647
blast_database_type bdbt_type text 2147483647
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
blast_query bqry_accbk_pk_id int8 19
blast_query bqry_runcan_zdb_id text 2147483647
blast_query bqry_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
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
blastdb_order bdborder_pk_id bigserial 19  √  nextval('blastdb_order_bdborder_pk_id_seq'::regclass)
blastdb_regen_content brc_acc_num text 2147483647
blastdb_regen_content brc_blastdb_zdb_id text 2147483647
blastdb_regen_content brc_pk_id bigserial 19  √  nextval('blastdb_regen_content_brc_pk_id_seq'::regclass)
blastdb_run blastdbr_blastdb_zdb_id text 2147483647
blastdb_run blastdbr_run_zdb_id text 2147483647
burgess_location_post allele1 text 2147483647
burgess_location_post assembly1 text 2147483647
burgess_location_post chromosome1 text 2147483647
burgess_location_post location1 int4 10  √  null
burgess_location_post sfclid 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
chromosome chrom_name text 2147483647
chromosome chrom_order int4 10
clean_expression_fast_search cefs_genox_zdb_id text 2147483647
clean_expression_fast_search cefs_mrkr_zdb_id text 2147483647
clean_expression_fast_search cefs_pk_id bigserial 19  √  nextval('clean_expression_fast_search_new_cefs_pk_id_seq'::regclass)
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
clone_problem_type cpt_type text 2147483647
cnechr chr text 2147483647  √  null
cnechr chrend int4 10  √  null
cnechr cne text 2147483647  √  null
cnechr startchr int4 10  √  null
cnechr1 assembly text 2147483647
cnechr1 chromosome text 2147483647
cnechr1 cneid text 2147483647
cnechr1 endlocation int4 10  √  null
cnechr1 evidence text 2147483647  √  null
cnechr1 pub text 2147483647  √  null
cnechr1 stlocation int4 10  √  null
cnedata cneid text 2147483647
cnedata cnename text 2147483647  √  null
cnedata zfishchr text 2147483647
company address text 2147483647  √  null
company bio text 2147483647  √  null
company contact_person text 2147483647  √  null
company country text 2147483647  √  null
company email text 2147483647  √  null
company entry_time timestamp 29,6  √  now()
company fax text 2147483647  √  null
company image text 2147483647  √  null
company name text 2147483647  √  null
company owner text 2147483647  √  null
company phone text 2147483647  √  null
company status text 2147483647  √  null
company url text 2147483647  √  null
company zdb_id text 2147483647
company_position compos_order int4 10
company_position compos_pk_id bigserial 19  √  nextval('company_position_compos_pk_id_seq'::regclass)
company_position compos_position text 2147483647
condition condition_group text 2147483647
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
construct construct_comments text 2147483647  √  null
construct construct_date_inserted timestamp 29,6 now()
construct construct_date_modified timestamp 29,6  √  now()
construct construct_name text 2147483647
construct construct_owner_zdb_id text 2147483647
construct construct_type text 2147483647
construct construct_zdb_id text 2147483647
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
construct_component cc_pk_id bigserial 19  √  nextval('construct_component_cc_pk_id_seq'::regclass)
construct_figure consfig_construct_zdb_id text 2147483647
construct_figure consfig_fig_zdb_id text 2147483647
construct_figure consfig_pk_id bigserial 19  √  nextval('construct_figure_consfig_pk_id_seq'::regclass)
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
constructrel construct1 text 2147483647  √  null
constructrel construct2 text 2147483647  √  null
constructrel region text 2147483647  √  null
constructrel relationship text 2147483647  √  null
constructreln construct1 text 2147483647  √  null
constructreln construct2 text 2147483647  √  null
constructreln region text 2147483647  √  null
constructreln relationship text 2147483647  √  null
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
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
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
curator_session cs_pk_id bigserial 19  √  nextval('curator_session_cs_pk_id_seq'::regclass)
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
daily_indexed_metric dim_pk_id bigserial 19  √  nextval('daily_indexed_metric_dim_pk_id_seq'::regclass)
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
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
data_reporting dr_data_zdb_id text 2147483647
data_reporting dr_pk_id bigserial 19  √  nextval('data_reporting_dr_pk_id_seq'::regclass)
data_reporting dr_report_generated_date timestamp 29,6
data_reporting dr_report_name text 2147483647
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
database_info di_pk_id bigserial 19  √  nextval('database_info_di_pk_id_seq'::regclass)
databasechangelog author varchar 255
databasechangelog comments varchar 255  √  null
databasechangelog contexts varchar 255  √  null
databasechangelog dateexecuted timestamp 29,6
databasechangelog deployment_id varchar 10  √  null
databasechangelog description varchar 255  √  null
databasechangelog exectype varchar 10
databasechangelog filename varchar 255
databasechangelog id varchar 255
databasechangelog labels varchar 255  √  null
databasechangelog liquibase varchar 20  √  null
databasechangelog md5sum varchar 35  √  null
databasechangelog orderexecuted int4 10
databasechangelog tag varchar 255  √  null
databasechangeloglock id int4 10
databasechangeloglock locked bool 1
databasechangeloglock lockedby varchar 255  √  null
databasechangeloglock lockgranted timestamp 29,6  √  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
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
disease_annotation_model damo_dat_zdb_id text 2147483647
disease_annotation_model damo_genox_zdb_id text 2147483647
disease_annotation_model damo_pk_id bigserial 19  √  nextval('disease_annotation_model_damo_pk_id_seq'::regclass)
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
doi_attempts doia_num_attempts int4 10
doi_attempts doia_pk_id bigserial 19  √  nextval('doi_attempts_doia_pk_id_seq'::regclass)
doi_attempts doia_pub_zdb_id text 2147483647
dupcrispr calias varchar 50  √  null
dupcrispr cname varchar 50  √  null
dupcrispr cseq varchar 50  √  null
dupcrispr gene varchar 50  √  null
dupcrispr pmid text 2147483647  √  null
dupcrispr zdbid varchar 50  √  null
eco_go_mapping egm_go_evidence_code text 2147483647
eco_go_mapping egm_pk_id bigserial 19  √  nextval('eco_go_mapping_egm_pk_id_seq'::regclass)
eco_go_mapping egm_term_zdb_id text 2147483647
editconstruct cczdb 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
ensdarg_ottdarg_mapping eom_ensdarg_id text 2147483647
ensdarg_ottdarg_mapping eom_ottdarg_id text 2147483647
ensdarg_post_proc dblinkid text 2147483647
ensdarg_post_proc ensdargidpost text 2147483647
ensdarg_post_proc geneid text 2147483647
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
ensdart_ottdart_mapping ensdart_id text 2147483647  √  null
ensdart_ottdart_mapping ottdart_id text 2147483647  √  null
entrez_gene eg_acc_num int4 10
entrez_gene eg_name text 2147483647  √  null
entrez_gene eg_symbol text 2147483647  √  null
entrez_to_protein ep_entrez_acc_num int4 10
entrez_to_protein ep_organism_common_name text 2147483647
entrez_to_protein ep_pk_id bigserial 19  √  nextval('entrez_to_protein_ep_pk_id_seq'::regclass)
entrez_to_protein ep_protein_acc_num text 2147483647
entrez_to_xref ex_entrez_acc_num int4 10
entrez_to_xref ex_xref text 2147483647
environment_group eg_genox_zdb_id text 2147483647
environment_group eg_group_name text 2147483647  √  null
environment_group eg_group_pk_id bigserial 19  √  nextval('environment_group_eg_group_pk_id_seq'::regclass)
execweb execweb_executable text 2147483647  √  null
execweb execweb_id text 2147483647  √  null
experiment exp_name text 2147483647
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
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
experiment_condition_restricted ecr_pk_id bigserial 19  √  nextval('experiment_condition_restricted_ecr_pk_id_seq'::regclass)
expression_experiment xpatex_assay_name text 2147483647  √  null
expression_experiment xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment xpatex_direct_submission_date timestamp 29,6  √  now()
expression_experiment xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment xpatex_source_zdb_id text 2147483647  √  null
expression_experiment xpatex_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_assay_name text 2147483647
expression_experiment2 xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_direct_submission_date timestamp 29,6 now()
expression_experiment2 xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_source_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_zdb_id text 2147483647
expression_experiment_bkup xpatex_assay_name text 2147483647  √  null
expression_experiment_bkup xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_direct_submission_date timestamp 29,6  √  null
expression_experiment_bkup xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_source_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_assay_name text 2147483647  √  null
expression_experiment_temp xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_direct_submission_date timestamp 29,6  √  null
expression_experiment_temp xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_source_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_zdb_id text 2147483647  √  null
expression_figure_stage efs_end_stg_zdb_id text 2147483647
expression_figure_stage efs_fig_zdb_id text 2147483647
expression_figure_stage efs_pk_id bigserial 19  √  nextval('expression_figure_stage_efs_pk_id_seq'::regclass)
expression_figure_stage efs_start_stg_zdb_id text 2147483647
expression_figure_stage efs_xpatex_zdb_id text 2147483647
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_pattern_figure xpatfig_fig_zdb_id text 2147483647  √  null
expression_pattern_figure xpatfig_xpatres_zdb_id int8 19  √  null
expression_pattern_figure_bkup xpatfig_fig_zdb_id text 2147483647  √  null
expression_pattern_figure_bkup xpatfig_xpatres_zdb_id int8 19  √  null
expression_pattern_figure_temp xpatfig_fig_zdb_id text 2147483647  √  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_phenotype_term ept_pk_id bigserial 19  √  nextval('expression_phenotype_term_ept_pk_id_seq'::regclass)
expression_phenotype_term ept_quality_term_zdb_id text 2147483647
expression_phenotype_term ept_relational_term text 2147483647 'expressed_in'::text
expression_phenotype_term ept_tag text 2147483647 'abnormal'::text
expression_phenotype_term ept_xpatres_id int8 19
expression_phenotype_term_controlled_vocab eptcv_pk_id bigserial 19  √  nextval('expression_phenotype_term_controlled_vocab_eptcv_pk_id_seq'::regclass)
expression_phenotype_term_controlled_vocab eptcv_term_zdb_id text 2147483647
expression_result xpatres_comments text 2147483647  √  null
expression_result xpatres_end_stg_zdb_id text 2147483647  √  null
expression_result xpatres_expression_found bool 1  √  true
expression_result xpatres_fig_zdb_id text 2147483647  √  null
expression_result xpatres_start_stg_zdb_id text 2147483647  √  null
expression_result xpatres_subterm_zdb_id text 2147483647  √  null
expression_result xpatres_superterm_zdb_id text 2147483647  √  null
expression_result xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result xpatres_zdb_id int8 19  √  null
expression_result2 xpatres_efs_id int8 19
expression_result2 xpatres_expression_found bool 1
expression_result2 xpatres_pk_id bigserial 19  √  nextval('expression_result2_xpatres_pk_id_seq'::regclass)
expression_result2 xpatres_subterm_zdb_id text 2147483647  √  null
expression_result2 xpatres_superterm_zdb_id text 2147483647
expression_result_bkup xpatres_end_stage_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_expression_found bool 1  √  null
expression_result_bkup 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_bkup xpatres_subterm_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_superterm_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result_temp xpatres_end_stg_zdb_id text 2147483647  √  null
expression_result_temp xpatres_expression_found bool 1  √  null
expression_result_temp xpatres_fig_zdb_id text 2147483647  √  null
expression_result_temp xpatres_start_stg_zdb_id text 2147483647  √  null
expression_result_temp xpatres_subterm_zdb_id text 2147483647  √  null
expression_result_temp xpatres_superterm_zdb_id text 2147483647  √  null
expression_result_temp xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result_temp xpatres_zdb_id bigserial 19  √  nextval('expression_result_temp_xpatres_zdb_id_seq'::regclass)
expression_search_anatomy_generated esag_efs_id text 2147483647  √  null
expression_search_anatomy_generated esag_is_direct bool 1  √  null
expression_search_anatomy_generated esag_term_name text 2147483647  √  null
expression_term_fast_search etfs_created_date timestamp 29,6  √  now()
expression_term_fast_search etfs_is_xpatres_term bool 1  √  false
expression_term_fast_search etfs_pk_id bigserial 19  √  nextval('expression_term_fast_search_etfs_pk_id_seq'::regclass)
expression_term_fast_search etfs_term_zdb_id text 2147483647  √  null
expression_term_fast_search etfs_xpatres_pk_id int8 19  √  null
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_zdb_id text 2147483647
external_note_type extntype_comment text 2147483647  √  null
external_note_type extntype_name text 2147483647
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_pk_id bigserial 19  √  nextval('external_reference_exref_pk_id_seq'::regclass)
external_reference exref_reference text 2147483647
featmkr feattype text 2147483647  √  null
featmkr featzdb text 2147483647  √  null
featmkr genezdb text 2147483647  √  null
featmkr strand text 2147483647  √  null
feature feature_abbrev text 2147483647
feature feature_abbrev_order text 2147483647
feature feature_date_entered timestamp 29,6  √  now()
feature feature_df_transloc_complex_prefix text 2147483647  √  null
feature feature_dominant bool 1 false
feature feature_known_insertion_site bool 1 false
feature feature_lab_prefix_id int8 19  √  null
feature feature_line_number text 2147483647  √  null
feature feature_name text 2147483647
feature feature_name_order text 2147483647
feature feature_tg_suffix text 2147483647  √  null
feature feature_type text 2147483647
feature feature_unrecovered bool 1 false
feature feature_unspecified bool 1 false
feature feature_zdb_id text 2147483647
feature_assay featassay_feature_zdb_id text 2147483647
feature_assay featassay_mutagee text 2147483647
feature_assay featassay_mutagen text 2147483647
feature_assay featassay_pk_id bigserial 19  √  nextval('feature_assay_featassay_pk_id_seq'::regclass)
feature_audit feature_abbrev text 2147483647  √  null
feature_audit feature_date_entered timestamp 29,6  √  null
feature_audit feature_df_transloc_complex_prefix text 2147483647  √  null
feature_audit feature_dominant bool 1  √  null
feature_audit feature_known_insertion_site bool 1  √  null
feature_audit feature_lap_prefix_id int8 19  √  null
feature_audit feature_line_number text 2147483647  √  null
feature_audit feature_name text 2147483647  √  null
feature_audit feature_name_order text 2147483647  √  null
feature_audit feature_tg_suffix text 2147483647  √  null
feature_audit feature_type text 2147483647  √  null
feature_audit feature_unrecovered bool 1  √  null
feature_audit feature_unspecified bool 1  √  null
feature_audit feature_zdb_id text 2147483647  √  null
feature_audit id int4 10  √  null
feature_audit rev int4 10  √  null
feature_audit revtype int4 10  √  null
feature_community_contribution fcc_added_by text 2147483647
feature_community_contribution fcc_adult_viable bool 1  √  false
feature_community_contribution fcc_currently_available bool 1  √  false
feature_community_contribution fcc_date_added timestamp 29,6 now()
feature_community_contribution fcc_feature_zdb_id text 2147483647
feature_community_contribution fcc_functional_consequence text 2147483647  √  null
feature_community_contribution fcc_maternal_zygosity_examined bool 1  √  false
feature_community_contribution fcc_nmd_apparent text 2147483647  √  null
feature_community_contribution fcc_other_line_information text 2147483647  √  null
feature_community_contribution fcc_pk_id bigserial 19  √  nextval('feature_community_contribution_fcc_pk_id_seq'::regclass)
feature_community_contribution_audit fcc_added_by text 2147483647  √  null
feature_community_contribution_audit fcc_adult_viable bool 1  √  null
feature_community_contribution_audit fcc_currently_available bool 1  √  null
feature_community_contribution_audit fcc_date_added timestamp 29,6  √  null
feature_community_contribution_audit fcc_feature_zdb_id text 2147483647  √  null
feature_community_contribution_audit fcc_functional_consequence text 2147483647  √  null
feature_community_contribution_audit fcc_maternal_zygosity_examined bool 1  √  null
feature_community_contribution_audit fcc_other_line_information text 2147483647  √  null
feature_data construct_id text 2147483647
feature_data feature_abb text 2147483647
feature_data line_num text 2147483647
feature_data other_feature_id text 2147483647  √  null
feature_data pub_id text 2147483647  √  null
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_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
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_group_pk_id bigserial 19  √  nextval('feature_group_fg_group_pk_id_seq'::regclass)
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_pk_id bigserial 19  √  nextval('feature_group_member_fgm_pk_id_seq'::regclass)
feature_group_member fgm_significance int4 10  √  null
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
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_pk_id bigserial 19  √  nextval('feature_prefix_fp_pk_id_seq'::regclass)
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
feature_stats fstat_feat_zdb_id text 2147483647
feature_stats fstat_fig_zdb_id text 2147483647
feature_stats fstat_gene_zdb_id text 2147483647  √  null
feature_stats fstat_img_zdb_id text 2147483647  √  null
feature_stats fstat_pk_id bigserial 19  √  nextval('feature_stats_temp_fstat_pk_id_seq'::regclass)
feature_stats fstat_pub_zdb_id text 2147483647
feature_stats fstat_subterm_zdb_id text 2147483647
feature_stats fstat_superterm_zdb_id text 2147483647
feature_stats fstat_type varchar 20  √  null
feature_stats fstat_xpatres_zdb_id int8 19
feature_stats_old fstat_feat_zdb_id text 2147483647
feature_stats_old fstat_fig_zdb_id text 2147483647
feature_stats_old fstat_gene_zdb_id text 2147483647  √  null
feature_stats_old fstat_img_zdb_id text 2147483647  √  null
feature_stats_old fstat_pk_id bigserial 19  √  nextval('feature_stats_temp_fstat_pk_id_seq1'::regclass)
feature_stats_old fstat_pub_zdb_id text 2147483647
feature_stats_old fstat_subterm_zdb_id text 2147483647
feature_stats_old fstat_superterm_zdb_id text 2147483647
feature_stats_old fstat_type varchar 20  √  null
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_tracking ft_pk_id bigserial 19  √  nextval('feature_tracking_ft_pk_id_seq'::regclass)
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 ftrtype_name text 2147483647
feature_type ftrtype_significance int4 10  √  null
feature_type ftrtype_type_display text 2147483647  √  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
feature_type_mutagen_group_member ftmgm_feature_type text 2147483647
feature_type_mutagen_group_member ftmgm_mutagen text 2147483647
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_name text 2147483647
feature_type_ordering fto_pk_id bigserial 19  √  nextval('feature_type_ordering_fto_pk_id_seq'::regclass)
feature_type_ordering fto_priority int4 10 0
featuredata alleleid text 2147483647
featuredata ensdarg1 text 2147483647  √  null
featuredata ensdarg2 text 2147483647  √  null
featuregenedata allele text 2147483647
featuregenedata ensdargid text 2147483647
featuregenedata geneid text 2147483647
featurenogenedata allele text 2147483647
featurezmp allele text 2147483647
featurezmp geneabbrev text 2147483647
featurezmpdata allele text 2147483647
featurezmpdata ensdargid text 2147483647
featurezmpdata geneabbrev 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
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
figure fig_source_zdb_id text 2147483647
figure fig_updated_by text 2147483647  √  null
figure fig_updated_date date 13  √  now()
figure fig_zdb_id 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 fish_is_wildtype bool 1 false
fish fish_modified bool 1  √  false
fish fish_name text 2147483647
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
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
fish_components fc_pk_id bigserial 19  √  nextval('fish_components_fc_pk_id_seq'::regclass)
fish_experiment genox_exp_zdb_id text 2147483647
fish_experiment genox_fish_zdb_id text 2147483647
fish_experiment genox_is_standard bool 1  √  false
fish_experiment genox_is_std_or_generic_control bool 1  √  false
fish_experiment genox_zdb_id text 2147483647
fish_genox exp_id text 2147483647  √  null
fish_genox fish_id text 2147483647  √  null
fish_genox genox_id text 2147483647  √  null
fish_str fishstr_fish_zdb_id text 2147483647
fish_str fishstr_str_zdb_id text 2147483647
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
foreign_db fdb_db_display_name text 2147483647  √  null
foreign_db fdb_db_name text 2147483647
foreign_db fdb_db_pk_id bigserial 19  √  nextval('foreign_db_fdb_db_pk_id_seq'::regclass)
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 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
foreign_db_contains_display_group fdbcdg_definition text 2147483647
foreign_db_contains_display_group fdbcdg_name text 2147483647
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_fdbcont_zdb_id text 2147483647
foreign_db_contains_display_group_member fdbcdgm_group_id int8 19
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_data_type text 2147483647  √  null
foreign_db_data_type fdbdt_display_order int4 10  √  null
foreign_db_data_type fdbdt_pk_id bigserial 19  √  nextval('foreign_db_data_type_fdbdt_pk_id_seq'::regclass)
foreign_db_data_type fdbdt_super_type text 2147483647
ftrconsequence cons text 2147483647  √  null
ftrconsequence ftr text 2147483647  √  null
ftrconsequencenew cons1 text 2147483647  √  null
ftrconsequencenew cons2 text 2147483647  √  null
ftrconsequencenew ftr text 2147483647  √  null
ftrmutdets ftr text 2147483647  √  null
ftrmutdets ref1 text 2147483647  √  null
ftrmutdets ref2 text 2147483647  √  null
ftrmutdetssanger ftr text 2147483647  √  null
ftrmutdetssanger ref1 text 2147483647  √  null
ftrmutdetssanger ref2 text 2147483647  √  null
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
gene_description gd_pk_id bigserial 19  √  nextval('gene_description_gd_pk_id_seq'::regclass)
genedom_family_member gfammem_gfam_name text 2147483647
genedom_family_member gfammem_mrkr_zdb_id text 2147483647
genedom_family_name gfam_name text 2147483647
geneprefix_institution gpi_institution text 2147483647
geneprefix_institution gpi_prefix 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_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_pk_id bigserial 19  √  nextval('genotype_component_significance_gcs_pk_id_seq'::regclass)
genotype_component_significance gcs_significance int4 10
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
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
genotype_figure_fast_search gffs_serial_id bigserial 19  √  nextval('genotype_figure_fast_search_new_gffs_serial_id_seq1'::regclass)
genotype_group gg_geno_handle text 2147483647  √  null
genotype_group gg_geno_name text 2147483647  √  null
genotype_group gg_group_name text 2147483647  √  null
genotype_group gg_group_pk_id bigserial 19  √  nextval('genotype_group_gg_group_pk_id_seq'::regclass)
genotype_group_member ggm_group_id int8 19
genotype_group_member ggm_member_id text 2147483647
genotype_group_member ggm_member_name text 2147483647  √  null
genotype_group_member ggm_pk_id bigserial 19  √  nextval('genotype_group_member_ggm_pk_id_seq'::regclass)
genotype_group_member ggm_significance int4 10  √  null
genox_fish_annotation_search genoxfas_fas_id int8 19
genox_fish_annotation_search genoxfas_genox_zdb_id text 2147483647
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_fas_id int8 19
genox_fish_annotation_search_bkup genoxfas_genox_zdb_id text 2147483647
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_fas_id int8 19
genox_fish_annotation_search_temp genoxfas_genox_zdb_id text 2147483647
genox_fish_annotation_search_temp genoxfas_pk_id bigserial 19  √  nextval('genox_fish_annotation_search_temp_genoxfas_pk_id_seq'::regclass)
genox_group gg_genotype_zdb_id text 2147483647  √  null
genox_group gg_group_name text 2147483647  √  null
genox_group gg_group_pk_id bigserial 19  √  nextval('genox_group_gg_group_pk_id_seq'::regclass)
genox_group_member ggm_genotype_id text 2147483647  √  null
genox_group_member ggm_group_id int8 19
genox_group_member ggm_member_id text 2147483647
genox_group_member ggm_pk_id bigserial 19  √  nextval('genox_group_member_ggm_pk_id_seq'::regclass)
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
go_evidence_code goev_code text 2147483647
go_evidence_code goev_display_order int4 10
go_evidence_code goev_name text 2147483647
go_flag gflag_display_order int4 10
go_flag gflag_name text 2147483647
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
heavy_chain_isotype hviso_name text 2147483647
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_alternate_identifier hdai_pk_id bigserial 19  √  nextval('htp_dataset_alternate_identifier_hdai_pk_id_seq'::regclass)
htp_dataset_category_tag hdct_category_tag text 2147483647
htp_dataset_category_tag hdct_dataset_zdb_id text 2147483647
htp_dataset_category_tag hdct_pk_id bigserial 19  √  nextval('htp_dataset_category_tag_hdct_pk_id_seq'::regclass)
htp_dataset_publication hdp_dataset_zdb_id text 2147483647
htp_dataset_publication hdp_pk_id bigserial 19  √  nextval('htp_dataset_publication_hdp_pk_id_seq'::regclass)
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_pk_id bigserial 19  √  nextval('htp_dataset_sample_hds_pk_id_seq'::regclass)
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
htp_dataset_sample_detail hdsd_pk_id bigserial 19  √  nextval('htp_dataset_sample_detail_hdsd_pk_id_seq'::regclass)
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
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
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
inputensdarg ensdarg text 2147483647
int_data_source ids_data_zdb_id text 2147483647
int_data_source ids_pk_id bigserial 19  √  nextval('int_data_source_ids_pk_id_seq'::regclass)
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
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
int_person_company flag text 2147483647  √  null
int_person_company position_id int8 19  √  null
int_person_company source_id text 2147483647
int_person_company status text 2147483647  √  null
int_person_company target_id text 2147483647
int_person_lab flag text 2147483647  √  null
int_person_lab position_id int8 19  √  null
int_person_lab source_id text 2147483647
int_person_lab status text 2147483647  √  null
int_person_lab target_id text 2147483647
int_person_pub flag text 2147483647  √  null
int_person_pub info text 2147483647  √  null
int_person_pub source_id text 2147483647
int_person_pub status text 2147483647  √  null
int_person_pub target_id text 2147483647
int_vegatype_tscripttype ivtst_tscriptt_type_id int8 19
int_vegatype_tscripttype ivtst_vega_type text 2147483647
interpro_protein ip_interpro_id text 2147483647
interpro_protein ip_name text 2147483647
interpro_protein ip_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
lab address text 2147483647  √  null
lab bio text 2147483647  √  null
lab contact_person text 2147483647  √  null
lab country text 2147483647  √  null
lab email text 2147483647  √  null
lab entry_time timestamp 29,6  √  now()
lab fax text 2147483647  √  null
lab image text 2147483647  √  null
lab name text 2147483647
lab owner text 2147483647  √  null
lab phone text 2147483647  √  null
lab status text 2147483647  √  null
lab url text 2147483647  √  null
lab zdb_id 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_pk_id bigserial 19  √  nextval('lab_address_update_tracking_laut_pk_id_seq'::regclass)
lab_address_update_tracking laut_previous_address text 2147483647
lab_position labpos_order int4 10
lab_position labpos_pk_id bigserial 19  √  nextval('lab_position_labpos_pk_id_seq'::regclass)
lab_position labpos_position text 2147483647
light_chain_isotype ltiso_name text 2147483647
lines line_name text 2147483647  √  null
lines_tmp line_name text 2147483647  √  null
linkage lnkg_chromosome text 2147483647
linkage lnkg_comments text 2147483647  √  null
linkage lnkg_source_zdb_id text 2147483647
linkage lnkg_submitter_zdb_id text 2147483647  √  null
linkage lnkg_zdb_id text 2147483647
linkage_group lg_name text 2147483647
linkage_group lg_order int4 10  √  null
linkage_member lnkgmem_linkage_zdb_id text 2147483647
linkage_member lnkgmem_member_zdb_id text 2147483647
linkage_member_temp linkage_zdb_id text 2147483647  √  null
linkage_member_temp marker_1_zdb_id text 2147483647  √  null
linkage_member_temp marker_2_zdb_id text 2147483647  √  null
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_membership lnkgm_pk_id bigserial 19  √  nextval('linkage_membership_lnkgm_pk_id_seq'::regclass)
linkage_membership_search lms_distance numeric 8,2  √  null
linkage_membership_search lms_lnkg_zdb_id text 2147483647
linkage_membership_search lms_lnkgmem_id int8 19
linkage_membership_search lms_lod numeric 8,2  √  null
linkage_membership_search lms_member_1_zdb_id text 2147483647
linkage_membership_search lms_member_2_zdb_id text 2147483647
linkage_membership_search lms_pk_id bigserial 19  √  nextval('linkage_membership_search_lms_pk_id_seq'::regclass)
linkage_membership_search lms_units text 2147483647  √  null
linkage_membership_search_bkup lms_distance numeric 8,2  √  null
linkage_membership_search_bkup lms_lnkg_zdb_id text 2147483647
linkage_membership_search_bkup lms_lnkgmem_id int8 19
linkage_membership_search_bkup lms_lod numeric 8,2  √  null
linkage_membership_search_bkup lms_member_1_zdb_id text 2147483647
linkage_membership_search_bkup lms_member_2_zdb_id text 2147483647
linkage_membership_search_bkup lms_pk_id bigserial 19  √  nextval('linkage_membership_search_bkup_lms_pk_id_seq'::regclass)
linkage_membership_search_bkup lms_units text 2147483647  √  null
linkage_membership_search_temp lms_distance numeric 8,2  √  null
linkage_membership_search_temp lms_lnkg_zdb_id text 2147483647
linkage_membership_search_temp lms_lnkgmem_id int8 19
linkage_membership_search_temp lms_lod numeric 8,2  √  null
linkage_membership_search_temp lms_member_1_zdb_id text 2147483647
linkage_membership_search_temp lms_member_2_zdb_id text 2147483647
linkage_membership_search_temp lms_pk_id bigserial 19  √  nextval('linkage_membership_search_temp_lms_pk_id_seq'::regclass)
linkage_membership_search_temp lms_units text 2147483647  √  null
linkage_old lnkg_comments text 2147483647  √  null
linkage_old lnkg_or_lg text 2147483647
linkage_old lnkg_submitter_zdb_id text 2147483647  √  null
linkage_old lnkg_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
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
linkage_single lsingle_pk_id bigserial 19  √  nextval('linkage_single_lsingle_pk_id_seq'::regclass)
linkages_copy dist numeric 8,2  √  null
linkages_copy lod numeric 8,2  √  null
linkages_copy m1_id text 2147483647  √  null
linkages_copy m2_id text 2147483647  √  null
linkages_copy owner text 2147483647  √  null
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_pk_id bigserial 19  √  nextval('longest_bin_resident_metric_lbrm_pk_id_seq'::regclass)
longest_bin_resident_metric lbrm_pub_zdb_id text 2147483647
longest_bin_resident_metric lbrm_status_counted text 2147483647
map_metric mapmetric_code text 2147483647
map_metric mapmetric_description text 2147483647
map_metric mapmetric_name text 2147483647  √  null
mapped_marker comments text 2147483647  √  null
mapped_marker entry_date timestamp 26,3  √  null
mapped_marker framework_t bool 1  √  null
mapped_marker lab text 2147483647  √  null
mapped_marker map_name text 2147483647  √  null
mapped_marker marker_id text 2147483647  √  null
mapped_marker marker_type text 2147483647
mapped_marker metric text 2147483647  √  null
mapped_marker mm_chrom_location numeric 8,2  √  null
mapped_marker mm_chromosome text 2147483647
mapped_marker owner text 2147483647  √  null
mapped_marker refcross_id text 2147483647
mapped_marker scoring_data text 2147483647  √  null
mapped_marker submitter text 2147483647  √  null
mapped_marker zdb_id text 2147483647
marker mrkr_abbrev text 2147483647
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
marker mrkr_zdb_id text 2147483647
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_pk_id bigserial 19  √  nextval('marker_go_term_annotation_extension_mgtae_pk_id_seq'::regclass)
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_annotation_extension_group_id bigserial 19  √  nextval('marker_go_term_annotation_ext_mgtaeg_annotation_extension_g_seq'::regclass)
marker_go_term_annotation_extension_group mgtaeg_mrkrgoev_zdb_id text 2147483647
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_source_zdb_id text 2147483647
marker_go_term_evidence mrkrgoev_term_zdb_id text 2147483647
marker_go_term_evidence mrkrgoev_zdb_id text 2147483647
marker_go_term_evidence_annotation_created_by_source mrkrgoevcb_name text 2147483647
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_go_term_evidence_annotation_created_by_source mrkrgoevcb_url 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_organization mrkrgoevas_pk_id bigserial 19  √  nextval('marker_go_term_evidence_annotation_organiz_mrkrgoevas_pk_id_seq'::regclass)
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_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_audit mha_pk_id bigserial 19  √  nextval('marker_history_audit_mha_pk_id_seq'::regclass)
marker_history_event mhistvnt_name text 2147483647
marker_history_reason mhistrsn_name text 2147483647
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_sequence seq_left_end text 2147483647  √  null
marker_sequence seq_mrkr_zdb_id text 2147483647
marker_sequence seq_offset_start int4 10  √  null
marker_sequence seq_offset_stop int4 10  √  null
marker_sequence seq_sequence text 2147483647  √  null
marker_sequence seq_sequence_2 text 2147483647  √  null
marker_sequence seq_type text 2147483647  √  null
marker_to_protein mtp_mrkr_zdb_id text 2147483647
marker_to_protein mtp_pk_id bigserial 19  √  nextval('marker_to_protein_mtp_pk_id_seq'::regclass)
marker_to_protein mtp_uniprot_id text 2147483647
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_types marker_type text 2147483647
marker_types mrkrtype_significance int4 10  √  null
marker_types mrkrtype_type_display text 2147483647  √  null
merge_markers_sql mms_mrkr_1_zdb_id text 2147483647
merge_markers_sql mms_mrkr_2_zdb_id text 2147483647
merge_markers_sql mms_pk_id bigserial 19  √  nextval('merge_markers_sql_mms_pk_id_seq'::regclass)
merge_markers_sql mms_sql text 2147483647
mesh_heading mh_descriptor_is_major_topic bool 1 false
mesh_heading mh_mesht_mesh_descriptor_id text 2147483647
mesh_heading mh_pk_id bigserial 19  √  nextval('mesh_heading_mh_pk_id_seq'::regclass)
mesh_heading mh_pub_zdb_id 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
mesh_term mesht_mesh_id text 2147483647
mesh_term mesht_term_name text 2147483647
mesh_term mesht_type text 2147483647
missing_varseq featurezdb text 2147483647  √  null
missing_varseq fgmdid text 2147483647  √  null
missing_varseq seqref text 2147483647  √  null
missing_xpatfig oxpatfig_fig_zdb_id text 2147483647  √  null
missing_xpatfig oxpatfig_xpatres_zdb_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
monthly_average_curated_metric macm_pk_id bigserial 19  √  nextval('monthly_average_curated_metric_macm_pk_id_seq'::regclass)
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_pk_id bigserial 19  √  nextval('monthly_curated_metric_mcm_pk_id_seq'::regclass)
monthly_curated_metric mcm_pub_arrival_date_month text 2147483647
monthly_curated_metric mcm_pub_arrival_date_year text 2147483647
mutagee mutagee_name text 2147483647
mutagen mutagen_name text 2147483647
mutant_fast_search mfs_genox_zdb_id text 2147483647
mutant_fast_search mfs_mrkr_zdb_id text 2147483647
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
name_precedence nmprec_comments text 2147483647
name_precedence nmprec_precedence text 2147483647
name_precedence nmprec_significance int4 10
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
ncbi_ortholog_alias noa_alias text 2147483647
ncbi_ortholog_alias noa_ncbi_gene_id text 2147483647
ncbi_ortholog_alias noa_pk_id bigserial 19  √  nextval('ncbi_ortholog_alias_noa_pk_id_seq'::regclass)
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_external_reference noer_pk_id bigserial 19  √  nextval('ncbi_ortholog_external_reference_noer_pk_id_seq'::regclass)
newfeaturedata accid text 2147483647  √  null
newfeaturedata alleleid text 2147483647
noctua_model nm_id text 2147483647
noctua_model_annotation nma_mrkrgoev_zdb_id text 2147483647
noctua_model_annotation nma_nm_id text 2147483647
obsolete_term_replacement obstermrep_pk_id bigserial 19  √  nextval('obsolete_term_replacement_obstermrep_pk_id_seq'::regclass)
obsolete_term_replacement obstermrep_term_replacement_zdb_id text 2147483647
obsolete_term_replacement obstermrep_term_zdb_id text 2147483647
obsolete_term_suggestion obstermsug_pk_id bigserial 19  √  nextval('obsolete_term_suggestion_obstermsug_pk_id_seq'::regclass)
obsolete_term_suggestion obstermsug_term_suggestion_zdb_id text 2147483647
obsolete_term_suggestion obstermsug_term_zdb_id 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
omim_phenotype omimp_pk_id bigserial 19  √  nextval('omim_phenotype_omimp_pk_id_seq'::regclass)
omimp_termxref_mapping otm_omimp_id int8 19
omimp_termxref_mapping otm_tx_id int8 19
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
one_to_one_accession ooa_pk_id bigserial 19  √  nextval('one_to_one_accession_ooa_pk_id_seq'::regclass)
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_pk_id bigserial 19  √  nextval('ontology_ont_pk_id_seq'::regclass)
ontology ont_remark text 2147483647  √  null
ontology ont_saved_by text 2147483647  √  null
ontology_subset osubset_ont_id int8 19
ontology_subset osubset_pk_id bigserial 19  √  nextval('ontology_subset_osubset_pk_id_seq'::regclass)
ontology_subset osubset_subset_definition text 2147483647
ontology_subset osubset_subset_name text 2147483647
ontology_subset osubset_subset_type text 2147483647  √  null
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
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
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_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
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
paneled_markers abbrev text 2147483647  √  null
paneled_markers lg_location numeric 8,2  √  null
paneled_markers map_name text 2147483647  √  null
paneled_markers metric text 2147483647  √  null
paneled_markers mghframework bool 1  √  null
paneled_markers mtype text 2147483647  √  null
paneled_markers or_lg text 2147483647  √  null
paneled_markers target_abbrev text 2147483647  √  null
paneled_markers target_id text 2147483647  √  null
paneled_markers zdb_id text 2147483647  √  null
panels abbrev text 2147483647
panels disp_order int4 10
panels entry_time timestamp 26,3
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
panels metric text 2147483647
panels name text 2147483647
panels owner text 2147483647
panels panel_date date 13
panels producer text 2147483647
panels ptype text 2147483647
panels source text 2147483647
panels status text 2147483647
panels zdb_id text 2147483647
person address text 2147483647  √  null
person email text 2147483647  √  null
person entry_time timestamp 29,6  √  now()
person fax text 2147483647  √  null
person first_name text 2147483647
person full_name text 2147483647
person image text 2147483647  √  null
person last_name text 2147483647
person name text 2147483647  √  null
person nicknames text 2147483647  √  null
person nonzf_pubs text 2147483647  √  null
person on_dist_list bool 1  √  null
person orcid_id text 2147483647  √  null
person owner text 2147483647  √  null
person pers_bio text 2147483647  √  null
person pers_is_deceased bool 1 false
person pers_is_hidden bool 1 false
person person_country text 2147483647  √  null
person phone text 2147483647  √  null
person url text 2147483647  √  null
person zdb_id text 2147483647
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_author persauth_pk_id bigserial 19  √  nextval('person_author_persauth_pk_id_seq'::regclass)
pg_stat_statements blk_read_time float8 17,17  √  null
pg_stat_statements blk_write_time float8 17,17  √  null
pg_stat_statements calls int8 19  √  null
pg_stat_statements dbid oid 10  √  null
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
pg_stat_statements max_time float8 17,17  √  null
pg_stat_statements mean_time float8 17,17  √  null
pg_stat_statements min_time float8 17,17  √  null
pg_stat_statements query text 2147483647  √  null
pg_stat_statements queryid int8 19  √  null
pg_stat_statements rows int8 19  √  null
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
pg_stat_statements stddev_time float8 17,17  √  null
pg_stat_statements temp_blks_read int8 19  √  null
pg_stat_statements temp_blks_written int8 19  √  null
pg_stat_statements total_time float8 17,17  √  null
pg_stat_statements userid oid 10  √  null
pheno_term pt_end_stg_zdb_id text 2147483647
pheno_term pt_fig_zdb_id text 2147483647
pheno_term pt_geno_is_wildtype bool 1
pheno_term pt_geno_zdb_id text 2147483647
pheno_term pt_genox_zdb_id text 2147483647
pheno_term pt_pheno_entity text 2147483647
pheno_term pt_pk_id bigserial 19  √  nextval('pheno_term_pt_pk_id_seq'::regclass)
pheno_term pt_pub_zdb_id text 2147483647
pheno_term pt_start_stg_zdb_id text 2147483647
pheno_term pt_tag text 2147483647  √  null
pheno_term_fast_search ptfs_created_date timestamp 29,6  √  now()
pheno_term_fast_search ptfs_is_direct_annotation bool 1  √  false
pheno_term_fast_search ptfs_phenos_created_date timestamp 29,6
pheno_term_fast_search ptfs_pk_id bigserial 19  √  nextval('pheno_term_fast_search_ptfs_pk_id_seq'::regclass)
pheno_term_fast_search ptfs_psg_id int8 19  √  null
pheno_term_fast_search ptfs_tag text 2147483647  √  null
pheno_term_fast_search ptfs_term_zdb_id text 2147483647
pheno_term_fast_search_tmp ptfs_created_date timestamp 29,6  √  now()
pheno_term_fast_search_tmp ptfs_is_direct_annotation bool 1  √  false
pheno_term_fast_search_tmp ptfs_phenos_created_date timestamp 29,6
pheno_term_fast_search_tmp ptfs_pk_id bigserial 19  √  nextval('pheno_term_fast_search_tmp_ptfs_pk_id_seq'::regclass)
pheno_term_fast_search_tmp ptfs_psg_id int8 19  √  null
pheno_term_fast_search_tmp ptfs_tag text 2147483647  √  null
pheno_term_fast_search_tmp ptfs_term_zdb_id text 2147483647
pheno_term_old pt_end_stg_zdb_id text 2147483647
pheno_term_old pt_fig_zdb_id text 2147483647
pheno_term_old pt_geno_is_wildtype bool 1
pheno_term_old pt_geno_zdb_id text 2147483647
pheno_term_old pt_genox_zdb_id text 2147483647
pheno_term_old pt_pheno_entity text 2147483647
pheno_term_old pt_pk_id bigserial 19  √  nextval('pheno_term_old_pt_pk_id_seq'::regclass)
pheno_term_old pt_pub_zdb_id text 2147483647
pheno_term_old pt_start_stg_zdb_id text 2147483647
pheno_term_old pt_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_pk_id bigserial 19  √  nextval('phenotype_experiment_phenox_pk_id_seq'::regclass)
phenotype_experiment phenox_start_stg_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 pfigg_group_pk_id bigserial 19  √  nextval('phenotype_figure_group_pfigg_group_pk_id_seq'::regclass)
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
phenotype_figure_group_member pfiggm_pk_id bigserial 19  √  nextval('phenotype_figure_group_member_pfiggm_pk_id_seq'::regclass)
phenotype_generated_curated_mapping pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping pgcm_source_id text 2147483647  √  null
phenotype_generated_curated_mapping_bkup pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping_bkup pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping_bkup pgcm_source_id text 2147483647  √  null
phenotype_generated_curated_mapping_temp pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping_temp pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping_temp pgcm_source_id text 2147483647  √  null
phenotype_observation_generated psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated psg_e1a_name text 2147483647  √  null
phenotype_observation_generated psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e1b_name text 2147483647  √  null
phenotype_observation_generated psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated psg_e2a_name text 2147483647  √  null
phenotype_observation_generated psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e2b_name text 2147483647  √  null
phenotype_observation_generated psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_id int8 19  √  null
phenotype_observation_generated psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_pg_id int8 19  √  null
phenotype_observation_generated psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated psg_quality_name text 2147483647  √  null
phenotype_observation_generated psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_short_name text 2147483647  √  null
phenotype_observation_generated psg_tag text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1a_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1b_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2a_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2b_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_id int8 19  √  null
phenotype_observation_generated_bkup psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated_bkup psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated_bkup psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_pg_id int8 19  √  null
phenotype_observation_generated_bkup psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated_bkup psg_quality_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_short_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_tag text 2147483647  √  null
phenotype_observation_generated_temp psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1a_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e1b_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2a_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e2b_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_id bigserial 19  √  nextval('phenotype_observation_generated_temp_psg_id_seq'::regclass)
phenotype_observation_generated_temp psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated_temp psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated_temp psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_pg_id int8 19  √  null
phenotype_observation_generated_temp psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated_temp psg_quality_name text 2147483647  √  null
phenotype_observation_generated_temp psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_short_name text 2147483647  √  null
phenotype_observation_generated_temp psg_tag text 2147483647  √  null
phenotype_source_generated pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated pg_id int8 19  √  null
phenotype_source_generated pg_start_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_id int8 19  √  null
phenotype_source_generated_bkup pg_start_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_id bigserial 19  √  nextval('phenotype_source_generated_temp_pg_id_seq'::regclass)
phenotype_source_generated_temp pg_start_stg_zdb_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_pk_id bigserial 19  √  nextval('phenotype_statement_phenos_pk_id_seq'::regclass)
phenotype_statement phenos_quality_zdb_id text 2147483647
phenotype_statement phenos_tag text 2147483647  √  null
pmflankseq featid text 2147483647  √  null
pmflankseq seq1 text 2147483647  √  null
pmflankseq seq2 text 2147483647  √  null
pmflankseq varseq text 2147483647  √  null
pmflankseq varseqid text 2147483647  √  null
post_aud id int8 19
post_aud rev int4 10
post_aud revtype int4 10  √  null
post_aud title text 2147483647  √  null
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
primer_set anneal_temp numeric 131089  √  null
primer_set band_size text 2147483647  √  null
primer_set comments text 2147483647  √  null
primer_set fwd_primer text 2147483647  √  null
primer_set marker_id text 2147483647  √  null
primer_set restr_enzyme text 2147483647  √  null
primer_set rev_primer text 2147483647  √  null
primer_set source text 2147483647  √  null
primer_set strain_id text 2147483647  √  null
primer_set the_id text 2147483647  √  null
primer_set zdb_id text 2147483647
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
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
processing_checklist_task pct_pk_id bigserial 19  √  nextval('processing_checklist_task_pct_pk_id_seq'::regclass)
processing_checklist_task pct_task text 2147483647
protein up_fdbcont_zdb_id text 2147483647
protein up_length int4 10  √  null
protein up_uniprot_id 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_pk_id bigserial 19  √  nextval('protein_to_interpro_pti_pk_id_seq'::regclass)
protein_to_interpro pti_uniprot_id text 2147483647
protein_to_pdb ptp_pdb_id text 2147483647
protein_to_pdb ptp_pk_id bigserial 19  √  nextval('protein_to_pdb_ptp_pk_id_seq'::regclass)
protein_to_pdb ptp_uniprot_id text 2147483647
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_pk_id bigserial 19  √  nextval('pub_correspondence_received_email_pubcre_pk_id_seq'::regclass)
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_recipient pubcr_pk_id bigserial 19  √  nextval('pub_correspondence_recipient_pubcr_pk_id_seq'::regclass)
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_sent_email pubcse_date_composed timestamp 29,6 now()
pub_correspondence_sent_email pubcse_pk_id bigserial 19  √  nextval('pub_correspondence_sent_email_pubcse_pk_id_seq'::regclass)
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_pk_id bigserial 19  √  nextval('pub_correspondence_sent_tracker_pubcst_pk_id_seq'::regclass)
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
pub_correspondence_subject pcs_handle text 2147483647
pub_correspondence_subject pcs_subject_pk_id bigserial 19  √  nextval('pub_correspondence_subject_pcs_subject_pk_id_seq'::regclass)
pub_correspondence_subject pcs_subject_text text 2147483647
pub_correspondence_subject pcs_subject_type text 2147483647
pub_db_xref pdx_accession_number text 2147483647
pub_db_xref pdx_fdbcont_zdb_id text 2147483647
pub_db_xref pdx_pk_id bigserial 19  √  nextval('pub_db_xref_pdx_pk_id_seq'::regclass)
pub_db_xref pdx_pub_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_pk_id bigserial 19  √  nextval('pub_tracking_history_pth_pk_id_seq'::regclass)
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
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_pk_id bigserial 19  √  nextval('pub_tracking_location_ptl_pk_id_seq'::regclass)
pub_tracking_location ptl_role 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_pk_id bigserial 19  √  nextval('pub_tracking_status_pts_pk_id_seq'::regclass)
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
publication accession_no int4 10  √  null
publication authors text 2147483647
publication jtype text 2147483647
publication keywords text 2147483647  √  null
publication owner 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
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 pubmed_authors text 2147483647  √  null
publication status text 2147483647  √  null
publication title text 2147483647  √  null
publication zdb_id 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_pk_id bigserial 19  √  nextval('publication_contact_tracking_pct_pk_id_seq'::regclass)
publication_contact_tracking pct_pub_zdb_id text 2147483647
publication_contact_tracking pct_responded_date timestamp 29,6  √  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_pk_id bigserial 19  √  nextval('publication_correspondence_pubcorr_pk_id_seq'::regclass)
publication_correspondence pubcorr_pub_zdb_id text 2147483647
publication_correspondence pubcorr_responded_date timestamp 29,6  √  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_pk_id bigserial 19  √  nextval('publication_file_pf_pk_id_seq'::regclass)
publication_file pf_pub_zdb_id text 2147483647
publication_file_type pft_pk_id bigserial 19  √  nextval('publication_file_type_pft_pk_id_seq'::regclass)
publication_file_type pft_type text 2147483647
publication_file_type pft_type_order int8 19
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
publication_processing_checklist ppc_date_completed timestamp 29,6  √  now()
publication_processing_checklist ppc_person_zdb_id text 2147483647
publication_processing_checklist ppc_pk_id bigserial 19  √  nextval('publication_processing_checklist_ppc_pk_id_seq'::regclass)
publication_processing_checklist ppc_pub_zdb_id text 2147483647
publication_processing_checklist ppc_task_id int8 19
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_pk_id bigserial 19  √  nextval('pubmed_publication_author_ppa_pk_id_seq'::regclass)
pubmed_publication_author ppa_publication_zdb_id text 2147483647  √  null
pubmed_publication_author ppa_pubmed_id text 2147483647
record_attribution recattrib_data_zdb_id text 2147483647
record_attribution recattrib_pk_id bigserial 19  √  nextval('record_attribution_recattrib_pk_id_seq'::regclass)
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
remove_phenos_ids phenos_id bigserial 19  √  nextval('remove_phenos_ids_phenos_id_seq'::regclass)
replaced_accession_number ran_new_acc_num text 2147483647
replaced_accession_number ran_old_acc_num text 2147483647
return_recs action text 2147483647  √  null
return_recs fill_field text 2147483647  √  null
return_recs fill_table text 2147483647  √  null
return_recs info text 2147483647  √  null
return_recs jump_to text 2147483647  √  null
return_recs rec_update bool 1  √  null
return_recs return_form text 2147483647  √  null
return_recs return_recid text 2147483647  √  null
return_recs zdb_id text 2147483647  √  null
revinfo rev int4 10  √ 
revinfo revtstmp 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
sanger_flanking_sequence allele text 2147483647
sanger_flanking_sequence alt text 2147483647
sanger_flanking_sequence flankingseq text 2147483647
sanger_flanking_sequence ref text 2147483647
sanger_flanking_sequence strand text 2147483647
sanger_flanking_sequence_post_proc alleleid text 2147483647
sanger_flanking_sequence_post_proc sequence text 2147483647
sanger_flanking_sequence_post_proc variation text 2147483647
sanger_flanking_sequence_post_proc vfseqid varchar 50  √  null
sanger_location allele text 2147483647
sanger_location assembly text 2147483647
sanger_location chromosome text 2147483647
sanger_location location int4 10  √  null
sanger_location_post allele1 text 2147483647
sanger_location_post assembly1 text 2147483647
sanger_location_post chromosome1 text 2147483647
sanger_location_post location1 int4 10  √  null
sanger_location_post sfclid varchar 50  √  null
sangerfeatures abbrev text 2147483647  √  null
sequence_ambiguity_code seqac_meaning text 2147483647
sequence_ambiguity_code seqac_symbol bpchar 1  √  null
sequence_feature_chromosome_location sfcl_assembly text 2147483647  √  null
sequence_feature_chromosome_location sfcl_chromosome text 2147483647
sequence_feature_chromosome_location sfcl_chromosome_reference_accession_number text 2147483647  √  null
sequence_feature_chromosome_location sfcl_end_position int4 10  √  null
sequence_feature_chromosome_location sfcl_evidence_code text 2147483647
sequence_feature_chromosome_location sfcl_feature_zdb_id text 2147483647
sequence_feature_chromosome_location sfcl_start_position int4 10  √  null
sequence_feature_chromosome_location sfcl_zdb_id text 2147483647
sequence_feature_chromosome_location_bkup sfcl_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_chromosome text 2147483647
sequence_feature_chromosome_location_bkup sfcl_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_end int4 10  √  null
sequence_feature_chromosome_location_bkup sfcl_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_bkup sfcl_location_source text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_start int4 10  √  null
sequence_feature_chromosome_location_bkup sfclg_pub_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated 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 sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated sfclg_evidence_code text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_pk_id bigserial 19  √  nextval('sequence_feature_chromosome_location_generated_sfclg_pk_id_seq'::regclass)
sequence_feature_chromosome_location_generated sfclg_pub_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_start int4 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_chromosome text 2147483647
sequence_feature_chromosome_location_generated_bkup sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_evidence_code text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_start int4 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_chromosome text 2147483647
sequence_feature_chromosome_location_generated_temp sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_evidence_code text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated_temp sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_start int4 10  √  null
sequence_feature_chromosome_location_temp sfcl_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_chromosome text 2147483647
sequence_feature_chromosome_location_temp sfcl_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_end int4 10  √  null
sequence_feature_chromosome_location_temp sfcl_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_temp sfcl_location_source text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_start int4 10  √  null
sequence_feature_chromosome_location_temp sfclg_pub_zdb_id text 2147483647  √  null
sequence_type seqtype_comments text 2147483647  √  null
sequence_type seqtype_name text 2147483647
seqvar featureabb text 2147483647  √  null
seqvar featureid text 2147483647  √  null
seqvar geneabb text 2147483647  √  null
seqvar geneid text 2147483647  √  null
seqvar location text 2147483647  √  null
seqvar mutdesc text 2147483647  √  null
seqvar mutname text 2147483647  √  null
seqvar mutterm text 2147483647  √  null
seqvar muttype text 2147483647  √  null
seqvar refseq text 2147483647  √  null
seqvar varseq text 2147483647  √  null
single sngl_one text 2147483647  √  null
snp_download snpd_mrkr_zdb_id text 2147483647
snp_download snpd_pk_id serial 10  √  nextval('snp_download_snpd_pk_id_seq'::regclass)
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
snp_sequence seq_left_end text 2147483647  √  null
snp_sequence seq_mrkr_zdb_id text 2147483647  √  null
snp_sequence seq_offset_start int4 10  √  null
snp_sequence seq_offset_stop int4 10  √  null
snp_sequence seq_sequence text 2147483647  √  null
snp_sequence seq_sequence_2 text 2147483647  √  null
snp_sequence seq_type text 2147483647  √  null
snp_sequence seq_variation text 2147483647  √  null
so_zfin_mapping szm_object_type text 2147483647
so_zfin_mapping szm_pk_id bigserial 19  √  nextval('so_zfin_mapping_szm_pk_id_seq'::regclass)
so_zfin_mapping szm_term_name text 2147483647
so_zfin_mapping szm_term_ont_id 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
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
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
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
state_code stc_code text 2147483647
state_code stc_display_order int4 10  √  null
state_code stc_name text 2147483647
str_group strg_genox_zdb_id text 2147483647  √  null
str_group strg_group_name text 2147483647  √  null
str_group strg_group_pk_id bigserial 19  √  nextval('str_group_strg_group_pk_id_seq'::regclass)
tables_in_trouble idx_scan int8 19  √  null
tables_in_trouble priority text 2147483647  √  null
tables_in_trouble seq_scan int8 19  √  null
tables_in_trouble sz_n_byts int8 19  √  null
tables_in_trouble table_in_trouble text 2147483647  √  null
tables_in_trouble tbl_rec_count text 2147483647  √  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
term term_ont_id text 2147483647
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_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
term_group tg_group_pk_id bigserial 19  √  nextval('term_group_tg_group_pk_id_seq'::regclass)
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_stage ts_end_stg_zdb_id text 2147483647  √  null
term_stage ts_start_stg_zdb_id text 2147483647  √  null
term_stage ts_term_zdb_id text 2147483647  √  null
term_subset termsub_subset_id int8 19
term_subset termsub_term_zdb_id text 2147483647
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_pk_id bigserial 19  √  nextval('term_xref_tx_pk_id_seq'::regclass)
term_xref tx_prefix text 2147483647
term_xref tx_term_zdb_id text 2147483647
tmp_addgene addgeneid text 2147483647  √  null
tmp_addgene addgenename text 2147483647  √  null
tmp_addgene dblinkid text 2147483647  √  null
tmp_addgene zfingene text 2147483647  √  null
tmp_all_term_contains alltermcon_contained_zdb_id text 2147483647  √  null
tmp_all_term_contains alltermcon_container_zdb_id text 2147483647  √  null
tmp_all_term_contains alltermcon_min_contain_distance int4 10
tmp_betterfishdump badfishid text 2147483647  √  null
tmp_betterfishdump badfishname text 2147483647  √  null
tmp_betterfishdump betterfishid text 2147483647  √  null
tmp_betterfishdump betterfishname 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
tmp_efs_map efs1 int8 19  √  null
tmp_efs_map efs2 int8 19  √  null
tmp_efs_map xpat_found bool 1  √  null
tmp_efs_map xpatres_subterm text 2147483647  √  null
tmp_efs_map xpatres_superterm text 2147483647  √  null
tmp_esag_predistinct esag_distance int4 10  √  null
tmp_esag_predistinct esag_efs_id text 2147483647  √  null
tmp_esag_predistinct esag_is_direct bool 1  √  null
tmp_esag_predistinct esag_term_name text 2147483647  √  null
tmp_esag_predistinct esag_term_zdb_id text 2147483647  √  null
tmp_expression_phenotype_term ept_pk_id int8 19  √  null
tmp_expression_phenotype_term ept_quality_term_zdb_id text 2147483647  √  null
tmp_expression_phenotype_term ept_relational_term text 2147483647  √  null
tmp_expression_phenotype_term ept_tag text 2147483647  √  null
tmp_expression_phenotype_term ept_xpatres_id int8 19  √  null
tmp_feature feature_abbrev text 2147483647  √  null
tmp_feature mutationtype text 2147483647  √  null
tmp_feature pageurl text 2147483647  √  null
tmp_feature sequence text 2147483647  √  null
tmp_feature tgtgeneid text 2147483647  √  null
tmp_feature tgtgenesymbol text 2147483647  √  null
tmp_figure figsource text 2147483647  √  null
tmp_genox_restore genox_exp_zdb_id text 2147483647  √  null
tmp_genox_restore genox_fish_zdb_id text 2147483647  √  null
tmp_genox_restore genox_is_standard bool 1  √  null
tmp_genox_restore genox_is_std_or_generic_control bool 1  √  null
tmp_genox_restore genox_zdb_id text 2147483647  √  null
tmp_ncbi_ensembl ensembl_id text 2147483647  √  null
tmp_ncbi_ensembl gene_id text 2147483647  √  null
tmp_ncbi_ensembl gene_symbol text 2147483647  √  null
tmp_ncbi_ensembl ncbi_id text 2147483647  √  null
tmp_ncbi_ensembl taxon_id text 2147483647  √  null
tmp_ortholog_external_reference accession text 2147483647  √  null
tmp_ortholog_external_reference fdbcont_id text 2147483647  √  null
tmp_ortholog_external_reference ortho_id text 2147483647  √  null
tmp_ottens comments text 2147483647  √  null
tmp_ottens ensdartid text 2147483647  √  null
tmp_ottens ottdartid text 2147483647  √  null
tmp_ottens tscriptid text 2147483647  √  null
tmp_pub pubzdb text 2147483647  √  null
tmp_pub2 zdb_id text 2147483647  √  null
tmp_pub3 pubzdb text 2147483647  √  null
tmp_pub5 figsource text 2147483647  √  null
tmp_seqref featzdb text 2147483647  √  null
tmp_seqref flankid text 2147483647  √  null
tmp_seqref seqref1 text 2147483647  √  null
tmp_seqref seqref2 text 2147483647  √  null
tmp_to_convert gene_id text 2147483647  √  null
tmp_zeco_tt aotermid text 2147483647  √  null
tmp_zeco_tt cctermid text 2147483647  √  null
tmp_zeco_tt cdtid text 2147483647  √  null
tmp_zeco_tt chebitermid text 2147483647  √  null
tmp_zeco_tt expid text 2147483647  √  null
tmp_zeco_tt extra text 2147483647  √  null
tmp_zeco_tt othertermid text 2147483647  √  null
tmp_zeco_tt zecoid text 2147483647  √  null
tmpcne cneabbrev text 2147483647  √  null
tmpcne cneid text 2147483647  √  null
tmpcne cnetype text 2147483647  √  null
tmpcne nccrabbrev text 2147483647  √  null
tmpcne nccrid text 2147483647  √  null
tmpcne nccrname text 2147483647  √  null
tmpcne nccrtype text 2147483647  √  null
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
transcript_sequence ts_sequence text 2147483647  √  null
transcript_sequence ts_transcript_ottdart_id text 2147483647
transcript_sequence ts_transcript_zdb_id text 2147483647
transcript_status tscripts_display text 2147483647
transcript_status tscripts_order int4 10  √  null
transcript_status tscripts_pk_id bigserial 19  √  nextval('transcript_status_tscripts_pk_id_seq'::regclass)
transcript_status tscripts_status text 2147483647
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_pk_id bigserial 19  √  nextval('transcript_type_tscriptt_pk_id_seq'::regclass)
transcript_type tscriptt_so_id text 2147483647  √  null
transcript_type tscriptt_type text 2147483647
tscript_type_status_definition ttsdef_definition text 2147483647
tscript_type_status_definition ttsdef_pk_id bigserial 19  √  nextval('tscript_type_status_definition_ttsdef_pk_id_seq'::regclass)
tscript_type_status_definition ttsdef_tscript_status_id int8 19
tscript_type_status_definition ttsdef_tscript_type_id int8 19  √  null
tscriptens ensdartid text 2147483647  √  null
tscriptens ottdartid text 2147483647  √  null
tscriptens tscriptid text 2147483647  √  null
tscriptens1 ensdartid1 text 2147483647  √  null
tscriptens1 ottdartid1 text 2147483647  √  null
tscriptens1 tscriptid1 text 2147483647  √  null
tscriptsequence tscriptid text 2147483647  √  null
tscriptsequence tscriptottdart text 2147483647  √  null
tscriptsequence tscriptseq text 2147483647  √  null
unique_location ul_chromosome text 2147483647
unique_location ul_data_zdb_id text 2147483647
updates comments text 2147483647  √  null
updates field_name text 2147483647  √  null
updates new_value text 2147483647  √  null
updates old_value text 2147483647  √  null
updates rec_id text 2147483647  √  null
updates submitter_id text 2147483647  √  null
updates submitter_name text 2147483647  √  null
updates upd_pk_id bigserial 19  √  nextval('updates_upd_pk_id_seq'::regclass)
updates upd_when timestamp 26,3  √  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
validate_check_history vldcheck_count int4 10
validate_check_history vldcheck_date timestamp 29,6
validate_check_history vldcheck_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
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
video video_image_still_zdb_id text 2147483647
video video_path_to_file text 2147483647
video video_pk_id bigserial 19  √  nextval('video_video_pk_id_seq'::regclass)
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
warehouse_run_tracking wrt_pk_id bigserial 19  √  nextval('warehouse_run_tracking_wrt_pk_id_seq'::regclass)
withdrawn_data wd_display_note text 2147483647  √  null
withdrawn_data wd_new_zdb_id text 2147483647
withdrawn_data wd_old_zdb_id text 2147483647
withdrawn_data wd_pk_id bigserial 19  √  nextval('withdrawn_data_wd_pk_id_seq'::regclass)
xpat_exp_details_generated xedg_assay_name text 2147483647
xpat_exp_details_generated xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_direct_submission_date timestamp 29,6 now()
xpat_exp_details_generated xedg_fig_zdb_id text 2147483647
xpat_exp_details_generated xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated 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 xedg_zdb_id text 2147483647
xpat_exp_details_generated_bkup xedg_assay_name text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_direct_submission_date timestamp 29,6  √  now()
xpat_exp_details_generated_bkup xedg_fig_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_genox_zdb_id text 2147483647  √  null
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_bkup xedg_probe_feature_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_assay_name text 2147483647  √  null
xpat_exp_details_generated_temp xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_direct_submission_date timestamp 29,6  √  now()
xpat_exp_details_generated_temp xedg_fig_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_genox_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_pk_id bigserial 19  √  nextval('xpat_exp_details_generated_temp_xedg_pk_id_seq'::regclass)
xpat_exp_details_generated_temp xedg_probe_feature_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_group_pk_id bigserial 19  √  nextval('xpat_figure_group_xfigg_group_pk_id_seq'::regclass)
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
xpat_figure_group_member xfiggm_pk_id bigserial 19  √  nextval('xpat_figure_group_member_xfiggm_pk_id_seq'::regclass)
xpat_results_generated xrg_comments text 2147483647  √  null
xpat_results_generated xrg_end_stg_zdb_id text 2147483647
xpat_results_generated 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 xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated xrg_superterm_zdb_id text 2147483647
xpat_results_generated xrg_xedg_id int8 19
xpat_results_generated xrg_xedg_zdb_id text 2147483647
xpat_results_generated xrg_zdb_id text 2147483647
xpat_results_generated_bkup xrg_comments text 2147483647  √  null
xpat_results_generated_bkup xrg_end_stg_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_expression_found bool 1  √  true
xpat_results_generated_bkup xrg_pk_id bigserial 19  √  nextval('xpat_results_generated_bkup_xrg_pk_id_seq'::regclass)
xpat_results_generated_bkup xrg_start_stg_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated_bkup xrg_superterm_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_xedg_id int8 19  √  null
xpat_results_generated_bkup xrg_xedg_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_comments text 2147483647  √  null
xpat_results_generated_temp xrg_end_stg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_expression_found bool 1  √  true
xpat_results_generated_temp xrg_pk_id bigserial 19  √  nextval('xpat_results_generated_temp_xrg_pk_id_seq'::regclass)
xpat_results_generated_temp xrg_start_stg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated_temp xrg_superterm_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_xedg_id int8 19  √  null
xpat_results_generated_temp xrg_xedg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_zdb_id text 2147483647  √  null
xpatfs_old etfs_created_date date 13 now
xpatfs_old etfs_is_xpatres_term bool 1  √  false
xpatfs_old etfs_pk_id bigserial 19  √  nextval('xpatfs_temp_etfs_pk_id_seq'::regclass)
xpatfs_old etfs_term_zdb_id text 2147483647  √  null
xpatfs_old etfs_xpatres_pk_id int8 19  √  null
zdb_active_data zactvd_zdb_id text 2147483647
zdb_active_source zactvs_zdb_id text 2147483647
zdb_flag zflag_is_on bool 1
zdb_flag zflag_last_modified timestamp 29,6
zdb_flag zflag_name 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
zdb_replaced_data zrepld_pk_id bigserial 19  √  nextval('zdb_replaced_data_zrepld_pk_id_seq'::regclass)
zdb_submitters access text 2147483647  √  null
zdb_submitters cookie text 2147483647
zdb_submitters create_date date 13  √  null
zdb_submitters is_curator bool 1 false
zdb_submitters is_student bool 1  √  false
zdb_submitters issue_time timestamp 26,3  √  null
zdb_submitters login text 2147483647  √  null
zdb_submitters name text 2147483647  √  null
zdb_submitters password text 2147483647  √  null
zdb_submitters password_reset_date timestamp 26,3  √  null
zdb_submitters password_reset_key text 2147483647  √  null
zdb_submitters previous_login timestamp 26,3  √  null
zdb_submitters zdb_id text 2147483647
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
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
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
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
zmap_pub_pan_mark abbrev text 2147483647
zmap_pub_pan_mark abbrevp text 2147483647
zmap_pub_pan_mark entry_date timestamp 26,3
zmap_pub_pan_mark lg_location numeric 8,2
zmap_pub_pan_mark metric text 2147483647
zmap_pub_pan_mark mghframework bool 1
zmap_pub_pan_mark mname text 2147483647
zmap_pub_pan_mark mtype text 2147483647
zmap_pub_pan_mark panel_abbrev text 2147483647  √  null
zmap_pub_pan_mark panel_id text 2147483647
zmap_pub_pan_mark target_abbrev text 2147483647
zmap_pub_pan_mark target_id text 2147483647
zmap_pub_pan_mark zdb_id text 2147483647  √  null
zmap_pub_pan_mark zmap_chromosome text 2147483647
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