SchemaSpy Analysis of zfindb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Sep 03 04:09 PDT 2018
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

zfindb.public contains 1955 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
paneled_markers abbrev text 2147483647  √  null
panels abbrev text 2147483647
sangerfeatures abbrev text 2147483647  √  null
zmap_pub_pan_mark abbrev text 2147483647
zmap_pub_pan_mark abbrevp text 2147483647
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)
zdb_submitters access text 2147483647  √  null
publication accession_no int4 10  √  null
accession_version accver_acc_num text 2147483647
accession_version accver_version int4 10
return_recs action text 2147483647  √  null
average_curation_time_metric actm_average_time_in_bin1 int4 10 0
average_curation_time_metric actm_average_time_in_bin2 int4 10 0
average_curation_time_metric actm_average_time_in_bin3 int4 10 0
average_curation_time_metric actm_average_time_in_curating_status int4 10 0
average_curation_time_metric actm_average_time_in_ortho int4 10 0
average_curation_time_metric actm_average_time_in_pheno int4 10 0
average_curation_time_metric actm_average_time_in_xpat int4 10 0
average_curation_time_metric actm_average_time_waiting_for_author int4 10 0
average_curation_time_metric actm_average_time_waiting_for_curator_review int4 10 0
average_curation_time_metric actm_average_time_waiting_for_nomenclature int4 10 0
average_curation_time_metric actm_average_time_waiting_for_ontology int4 10 0
average_curation_time_metric actm_average_time_waiting_for_software_fix int4 10 0
average_curation_time_metric actm_date_captured timestamp 29,6 now()
average_curation_time_metric actm_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)
company address text 2147483647  √  null
lab address text 2147483647  √  null
person address text 2147483647  √  null
affected_gene_group_member afgm_group_id int8 19
affected_gene_group_member afgm_member_id text 2147483647
affected_gene_group_member afgm_member_name text 2147483647  √  null
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
tmp_all_term_contains alltermcon_contained_zdb_id text 2147483647  √  null
all_term_contains alltermcon_container_zdb_id text 2147483647
tmp_all_term_contains alltermcon_container_zdb_id text 2147483647  √  null
all_term_contains alltermcon_min_contain_distance int4 10
tmp_all_term_contains alltermcon_min_contain_distance int4 10
anatomy_display anatdisp_indent int4 10
anatomy_display anatdisp_item_name text 2147483647
anatomy_display anatdisp_item_zdb_id text 2147483647
anatomy_display anatdisp_seq_num int4 10
anatomy_display anatdisp_stg_zdb_id text 2147483647
anatomy_stats anatstat_contains_object_count int4 10
anatomy_stats anatstat_object_count int4 10
anatomy_stats anatstat_object_type varchar 32
anatomy_stats anatstat_synonym_count int4 10
anatomy_stats anatstat_term_zdb_id text 2147483647  √  null
anatomy_stats anatstat_total_distinct_count int4 10
primer_set anneal_temp numeric 131089  √  null
tmp_zeco_tt aotermid text 2147483647  √  null
apato_tag apatotag_name text 2147483647
apato_infrastructure api_curator_zdb_id text 2147483647
apato_infrastructure api_date timestamp 29,6 now()
apato_infrastructure api_entity_1_subterm_zdb_id text 2147483647  √  null
apato_infrastructure api_entity_1_superterm_zdb_id text 2147483647
apato_infrastructure api_entity_2_subterm_zdb_id text 2147483647  √  null
apato_infrastructure api_entity_2_superterm_zdb_id text 2147483647  √  null
apato_infrastructure api_pub_zdb_id text 2147483647
apato_infrastructure api_quality_zdb_id text 2147483647
apato_infrastructure api_tag text 2147483647
apato_infrastructure api_zdb_id text 2147483647
annual_stats as_count int4 10
annual_stats as_date timestamp 29,6
annual_stats as_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
attribution_type attype_definition text 2147483647  √  null
attribution_type attype_type text 2147483647
databasechangelog author varchar 255
author author_first_name text 2147483647  √  null
author author_institution text 2147483647  √  null
author author_last_name text 2147483647  √  null
author 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
publication authors text 2147483647
tmp_betterfishdump badfishid text 2147483647  √  null
tmp_betterfishdump badfishname text 2147483647  √  null
primer_set band_size text 2147483647  √  null
blastdb_order bdborder_child_blastdb_zdb_id text 2147483647
blastdb_order bdborder_order int4 10
blastdb_order bdborder_parent_blastdb_zdb_id text 2147483647  √  null
blastdb_order bdborder_pk_id bigserial 19  √  nextval('blastdb_order_bdborder_pk_id_seq'::regclass)
blast_database_type bdbt_type 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
tmp_betterfishdump betterfishid text 2147483647  √  null
tmp_betterfishdump betterfishname text 2147483647  √  null
blast_hit bhit_alignment text 2147483647  √  null
blast_hit bhit_bqry_zdb_id text 2147483647
blast_hit bhit_expect_value float8 17,17
blast_hit bhit_hit_number int4 10
blast_hit bhit_identities_denominator int4 10  √  null
blast_hit bhit_identities_numerator int4 10  √  null
blast_hit bhit_positives_denominator int4 10
blast_hit bhit_positives_numerator int4 10
blast_hit bhit_probability float8 17,17  √  null
blast_hit bhit_score int4 10
blast_hit bhit_strand text 2147483647  √  null
blast_hit bhit_target_accbk_pk_id int8 19
blast_hit bhit_zdb_id text 2147483647
company bio text 2147483647  √  null
lab bio text 2147483647  √  null
blast_database blastdb_abbrev text 2147483647
blast_database blastdb_description text 2147483647  √  null
blast_database blastdb_is_being_processed bool 1 false
blast_database blastdb_last_regenerated timestamp 29,6  √  null
blast_database blastdb_name text 2147483647
blast_database blastdb_num_accessions int4 10  √  null
blast_database blastdb_num_seqs int4 10  √  null
blast_database blastdb_old_num_seqs text 2147483647  √  null
blast_database blastdb_origination_id int8 19  √  null
blast_database blastdb_path text 2147483647  √  null
blast_database blastdb_public bool 1 false
blast_database blastdb_tool_display_name text 2147483647
blast_database blastdb_tool_display_order int4 10  √  null
blast_database blastdb_type text 2147483647
blast_database blastdb_zdb_id text 2147483647
blastdb_run blastdbr_blastdb_zdb_id text 2147483647
blastdb_run blastdbr_run_zdb_id text 2147483647
pg_stat_statements blk_read_time float8 17,17  √  null
pg_stat_statements blk_write_time float8 17,17  √  null
bl_plate_tracking blpt_load_number text 2147483647
bl_plate_tracking blpt_pk_id bigserial 19  √  nextval('bl_plate_tracking_blpt_pk_id_seq'::regclass)
bl_plate_tracking blpt_plate text 2147483647  √  null
blast_query bqry_accbk_pk_id int8 19
blast_query bqry_runcan_zdb_id text 2147483647
blast_query bqry_zdb_id text 2147483647
blastdb_regen_content brc_acc_num text 2147483647
blastdb_regen_content brc_blastdb_zdb_id text 2147483647
blastdb_regen_content brc_pk_id bigserial 19  √  nextval('blastdb_regen_content_brc_pk_id_seq'::regclass)
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
pg_stat_statements calls int8 19  √  null
construct_component cc_cassette_number int4 10 1
construct_component cc_component text 2147483647
construct_component cc_component_category text 2147483647  √  null
construct_component cc_component_type text 2147483647  √  null
construct_component cc_component_zdb_id text 2147483647  √  null
construct_component cc_construct_zdb_id text 2147483647
construct_component cc_order int4 10
construct_component cc_pk_id bigserial 19  √  nextval('construct_component_cc_pk_id_seq'::regclass)
tmp_zeco_tt cctermid text 2147483647  √  null
editconstruct cczdb text 2147483647  √  null
condition_data_type cdt_group text 2147483647
condition_data_type cdt_name text 2147483647
condition_data_type cdt_significance int4 10
condition_data_type cdt_zdb_id text 2147483647
tmp_zeco_tt cdtid text 2147483647  √  null
clean_expression_fast_search cefs_genox_zdb_id text 2147483647
clean_expression_fast_search cefs_mrkr_zdb_id text 2147483647
clean_expression_fast_search cefs_pk_id bigserial 19  √  nextval('clean_expression_fast_search_new_cefs_pk_id_seq1'::regclass)
tmp_zeco_tt chebitermid text 2147483647  √  null
chromosome chrom_name text 2147483647
chromosome chrom_order int4 10
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
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
databasechangelog comments varchar 255  √  null
mapped_marker comments text 2147483647  √  null
primer_set comments text 2147483647  √  null
updates comments text 2147483647  √  null
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
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
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 construct_comments text 2147483647  √  null
construct construct_date_inserted timestamp 29,6 now()
construct construct_date_modified timestamp 29,6  √  now()
feature_data construct_id text 2147483647
construct construct_name text 2147483647
construct construct_owner_zdb_id text 2147483647
construct construct_type text 2147483647
construct construct_zdb_id text 2147483647
company contact_person text 2147483647  √  null
lab contact_person text 2147483647  √  null
databasechangelog contexts varchar 255  √  null
zdb_submitters cookie text 2147483647
company country text 2147483647  √  null
lab country text 2147483647  √  null
clone_problem_type cpt_type text 2147483647
zdb_submitters create_date date 13  √  null
curator_session cs_data_zdb_id text 2147483647  √  null
curator_session cs_field_name text 2147483647
curator_session cs_field_name_value text 2147483647
curator_session cs_person_zdb_id text 2147483647
curator_session cs_pk_id bigserial 19  √  nextval('curator_session_cs_pk_id_seq'::regclass)
country_code ctc_code text 2147483647
country_code ctc_comments text 2147483647  √  null
country_code ctc_display_order int4 10  √  null
country_code ctc_name text 2147483647
curation cur_closed_date timestamp 29,6  √  null
curation cur_curator_zdb_id text 2147483647
curation cur_data_found bool 1 false
curation cur_entry_date timestamp 29,6
curation cur_opened_date timestamp 29,6  √  null
curation cur_pub_zdb_id text 2147483647
curation cur_topic text 2147483647
curation cur_zdb_id text 2147483647
curation_topic curtopic_name text 2147483647
controlled_vocabulary cv_foreign_species text 2147483647  √  null
controlled_vocabulary cv_name_definition text 2147483647  √  null
controlled_vocabulary cv_term_name text 2147483647
controlled_vocabulary cv_zdb_id text 2147483647
data_alias dalias_alias text 2147483647
data_alias dalias_alias_lower text 2147483647
data_alias dalias_data_zdb_id text 2147483647
data_alias dalias_group_id int8 19
data_alias dalias_scope_id int8 19  √  null
data_alias dalias_zdb_id text 2147483647
disease_annotation_model damo_dat_zdb_id text 2147483647
disease_annotation_model damo_genox_zdb_id text 2147483647
disease_annotation_model damo_pk_id bigserial 19  √  nextval('disease_annotation_model_damo_pk_id_seq'::regclass)
disease_annotation dat_evidence_term_zdb_id text 2147483647  √  null
disease_annotation dat_source_zdb_id text 2147483647
disease_annotation dat_term_zdb_id text 2147483647
disease_annotation dat_zdb_id text 2147483647
databasechangelog dateexecuted timestamp 29,6
pg_stat_statements dbid oid 10  √  null
db_link dblink_acc_num text 2147483647
db_link dblink_acc_num_display text 2147483647
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
databasechangelog deployment_id varchar 10  √  null
databasechangelog description varchar 255  √  null
database_info di_code_version text 2147483647 'production'::text
database_info di_database_unloaded text 2147483647  √  null
database_info di_date_unloaded timestamp 29,6
database_info di_pk_id bigserial 19  √  nextval('database_info_di_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)
panels disp_order int4 10
linkages_copy dist numeric 8,2  √  null
data_note dnote_curator_zdb_id text 2147483647
data_note dnote_data_zdb_id text 2147483647
data_note dnote_date timestamp 29,6  √  null
data_note dnote_text text 2147483647  √  null
data_note dnote_zdb_id text 2147483647
doi_attempts doia_num_attempts int4 10
doi_attempts doia_pk_id bigserial 19  √  nextval('doi_attempts_doia_pk_id_seq'::regclass)
doi_attempts doia_pub_zdb_id text 2147483647
do_oevdispupdate_temp_first dout1_evidence_code bpchar 2  √  null
do_oevdispupdate_temp_first dout1_gene_zdb_id text 2147483647  √  null
do_oevdispupdate_temp_first dout1_organism_list text 2147483647
do_oevdispupdate_temp_first dout1_pub_zdb_id text 2147483647  √  null
do_oevdispupdate_temp_first dout1_session_id int4 10  √  null
do_oevdispupdate_temp_second dout2_evidence_code bpchar 2  √  null
do_oevdispupdate_temp_second dout2_gene_zdb_id text 2147483647  √  null
do_oevdispupdate_temp_second dout2_oevdisp_zdb_id text 2147483647  √  null
do_oevdispupdate_temp_second dout2_organism_list text 2147483647  √  null
do_oevdispupdate_temp_second dout2_session_id int4 10  √  null
data_reporting dr_data_zdb_id text 2147483647
data_reporting dr_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
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)
tmp_efs_map efs1 int8 19  √  null
tmp_efs_map efs2 int8 19  √  null
expression_figure_stage efs_end_stg_zdb_id text 2147483647
expression_figure_stage efs_fig_zdb_id text 2147483647
expression_figure_stage efs_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
entrez_gene eg_acc_num int4 10
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)
entrez_gene eg_name text 2147483647  √  null
entrez_gene eg_symbol text 2147483647  √  null
company email text 2147483647  √  null
lab email text 2147483647  √  null
person email text 2147483647  √  null
ensdar_mapping ensm_ensdarg_id text 2147483647
ensdar_mapping ensm_ensdarp_id text 2147483647  √  null
ensdar_mapping ensm_ensdart_id text 2147483647
ensdarg_ensdarp_mapping ensp_ensdarg_id text 2147483647
ensdarg_ensdarp_mapping ensp_ensdarp_id text 2147483647
ensdarg_ensdarp_mapping ensp_ensdart_id text 2147483647
ensdarg_ensdarp_mapping ensp_length int4 10  √  null
mapped_marker entry_date timestamp 26,3  √  null
zmap_pub_pan_mark entry_date timestamp 26,3
company entry_time timestamp 29,6  √  now()
lab entry_time timestamp 29,6  √  now()
panels entry_time timestamp 26,3
person entry_time timestamp 29,6  √  now()
ensdarg_ottdarg_mapping eom_ensdarg_id text 2147483647
ensdarg_ottdarg_mapping eom_ottdarg_id text 2147483647
entrez_to_protein ep_entrez_acc_num int4 10
entrez_to_protein ep_organism_common_name text 2147483647
entrez_to_protein ep_pk_id bigserial 19  √  nextval('entrez_to_protein_ep_pk_id_seq'::regclass)
entrez_to_protein ep_protein_acc_num 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
tmp_esag_predistinct esag_distance int4 10  √  null
expression_search_anatomy_generated esag_efs_id text 2147483647  √  null
tmp_esag_predistinct esag_efs_id text 2147483647  √  null
expression_search_anatomy_generated esag_is_direct bool 1  √  null
tmp_esag_predistinct esag_is_direct bool 1  √  null
expression_search_anatomy_generated esag_term_name text 2147483647  √  null
tmp_esag_predistinct esag_term_name text 2147483647  √  null
tmp_esag_predistinct esag_term_zdb_id text 2147483647  √  null
expression_term_fast_search etfs_created_date timestamp 29,6  √  now()
xpatfs_old etfs_created_date date 13 now
expression_term_fast_search etfs_is_xpatres_term bool 1  √  false
xpatfs_old etfs_is_xpatres_term bool 1  √  false
expression_term_fast_search etfs_pk_id bigserial 19  √  nextval('expression_term_fast_search_etfs_pk_id_seq'::regclass)
xpatfs_old etfs_pk_id bigserial 19  √  nextval('xpatfs_temp_etfs_pk_id_seq'::regclass)
expression_term_fast_search etfs_term_zdb_id text 2147483647  √  null
xpatfs_old etfs_term_zdb_id text 2147483647  √  null
expression_term_fast_search etfs_xpatres_pk_id int8 19  √  null
xpatfs_old etfs_xpatres_pk_id int8 19  √  null
entrez_to_xref ex_entrez_acc_num int4 10
entrez_to_xref ex_xref text 2147483647
databasechangelog exectype varchar 10
execweb execweb_executable text 2147483647  √  null
execweb execweb_id text 2147483647  √  null
fish_genox exp_id text 2147483647  √  null
experiment exp_name text 2147483647
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_taxon_term_zdb_id text 2147483647  √  null
experiment_condition expcond_zdb_id text 2147483647
experiment_condition expcond_zeco_term_zdb_id text 2147483647
tmp_zeco_tt expid text 2147483647  √  null
external_reference exref_attype_type text 2147483647
external_reference exref_data_zdb_id text 2147483647
external_reference exref_foreign_db_id int8 19  √  null
external_reference exref_pk_id bigserial 19  √  nextval('external_reference_exref_pk_id_seq'::regclass)
external_reference exref_reference text 2147483647
external_note extnote_data_zdb_id text 2147483647
external_note extnote_note text 2147483647
external_note extnote_note_type text 2147483647  √  null
external_note extnote_source_zdb_id text 2147483647
external_note extnote_zdb_id text 2147483647
external_note_type extntype_comment text 2147483647  √  null
external_note_type extntype_name text 2147483647
tmp_zeco_tt extra text 2147483647  √  null
company fax text 2147483647  √  null
lab fax text 2147483647  √  null
person fax text 2147483647  √  null
fish_components fc_affector_zdb_id text 2147483647
fish_components fc_construct_zdb_id text 2147483647  √  null
fish_components fc_fish_name text 2147483647
fish_components fc_fish_zdb_id text 2147483647
fish_components fc_gene_zdb_id text 2147483647  √  null
fish_components fc_genotype_zdb_id text 2147483647
fish_components fc_pk_id bigserial 19  √  nextval('fish_components_fc_pk_id_seq'::regclass)
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_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_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_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
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_intron_number int8 19  √  null
feature_dna_mutation_detail fdmd_number_additional_dna_base_pairs int8 19  √  null
feature_dna_mutation_detail fdmd_number_removed_dna_base_pairs int8 19  √  null
feature_dna_mutation_detail fdmd_zdb_id text 2147483647
feature_assay featassay_feature_zdb_id text 2147483647
feature_assay featassay_mutagee text 2147483647
feature_assay featassay_mutagen text 2147483647
feature_assay featassay_pk_id bigserial 19  √  nextval('feature_assay_featassay_pk_id_seq'::regclass)
feature_data feature_abb text 2147483647
feature feature_abbrev text 2147483647
tmp_feature feature_abbrev text 2147483647  √  null
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_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
updates field_name text 2147483647  √  null
figure fig_caption text 2147483647  √  null
figure fig_comments text 2147483647  √  null
figure fig_full_label text 2147483647  √  null
figure fig_label text 2147483647  √  null
figure fig_source_zdb_id text 2147483647
figure fig_zdb_id text 2147483647
databasechangelog filename varchar 255
return_recs fill_field text 2147483647  √  null
return_recs fill_table text 2147483647  √  null
person first_name text 2147483647
fish fish_full_name text 2147483647  √  null
fish fish_functional_affected_gene_count int8 19
fish fish_genotype_zdb_id text 2147483647
fish fish_handle text 2147483647
fish_genox fish_id text 2147483647  √  null
fish fish_is_wildtype bool 1 false
fish fish_modified bool 1  √  false
fish fish_name text 2147483647
fish fish_name_order text 2147483647
fish fish_order int8 19
fish fish_zdb_id text 2147483647
fish_str fishstr_fish_zdb_id text 2147483647
fish_str fishstr_str_zdb_id text 2147483647
int_person_company flag text 2147483647  √  null
int_person_lab flag text 2147483647  √  null
int_person_pub flag text 2147483647  √  null
fest_lib_inst fli_fest bpchar 6
fest_lib_inst fli_inst text 2147483647  √  null
fest_lib_inst fli_lib text 2147483647  √  null
fest_lib_inst fli_probelib_zdb_id text 2147483647  √  null
fishmisfortune fm_affected_gene_count int4 10  √  0
fishmisfortune fm_experiment_condition_count int4 10  √  0
fishmisfortune fm_feature_count int4 10  √  0
fishmisfortune fm_fish_display_name text 2147483647  √  null
fishmisfortune fm_fish_zdb_id text 2147483647  √  null
fishmisfortune fm_genox_zdb_id text 2147483647  √  null
fishmisfortune fm_misfortune_count int4 10  √  0
fishmisfortune fm_misfortune_count_minus_one int4 10  √  0
fishmisfortune fm_pub_zdb_id text 2147483647  √  null
fishmisfortune fm_str_count int4 10  √  0
feature_marker_relationship fmrel_ftr_zdb_id text 2147483647
feature_marker_relationship fmrel_mrkr_zdb_id text 2147483647
feature_marker_relationship fmrel_type text 2147483647
feature_marker_relationship fmrel_zdb_id text 2147483647
feature_marker_relationship_type fmreltype_1_to_2_comments text 2147483647  √  null
feature_marker_relationship_type fmreltype_2_to_1_comments text 2147483647  √  null
feature_marker_relationship_type fmreltype_ftr_type_group text 2147483647
feature_marker_relationship_type fmreltype_mrkr_type_group text 2147483647
feature_marker_relationship_type fmreltype_name text 2147483647
feature_marker_relationship_type fmreltype_produces_affected_marker bool 1 false
feature_prefix fp_date_entered timestamp 29,6 now()
feature_prefix fp_institute_display text 2147483647
feature_prefix fp_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
mapped_marker framework_t bool 1  √  null
feature_stats fstat_feat_zdb_id text 2147483647
feature_stats_old fstat_feat_zdb_id text 2147483647
feature_stats fstat_fig_zdb_id text 2147483647
feature_stats_old fstat_fig_zdb_id text 2147483647
feature_stats fstat_gene_zdb_id text 2147483647  √  null
feature_stats_old fstat_gene_zdb_id text 2147483647  √  null
feature_stats fstat_img_zdb_id text 2147483647  √  null
feature_stats_old fstat_img_zdb_id text 2147483647  √  null
feature_stats fstat_pk_id bigserial 19  √  nextval('feature_stats_fstat_pk_id_seq'::regclass)
feature_stats_old fstat_pk_id bigserial 19  √  nextval('feature_stats_temp_fstat_pk_id_seq'::regclass)
feature_stats fstat_pub_zdb_id text 2147483647
feature_stats_old fstat_pub_zdb_id text 2147483647
feature_stats fstat_subterm_zdb_id text 2147483647
feature_stats_old fstat_subterm_zdb_id text 2147483647
feature_stats fstat_superterm_zdb_id text 2147483647
feature_stats_old fstat_superterm_zdb_id text 2147483647
feature_stats fstat_type text 2147483647  √  null
feature_stats_old fstat_type varchar 20  √  null
feature_stats fstat_xpatres_zdb_id int8 19
feature_stats_old fstat_xpatres_zdb_id int8 19
feature_tracking ft_date_entered timestamp 29,6 now()
feature_tracking ft_feature_abbrev text 2147483647
feature_tracking ft_feature_name text 2147483647
feature_tracking ft_feature_zdb_id text 2147483647
feature_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_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
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 ftrtype_name text 2147483647
feature_type ftrtype_significance int4 10  √  null
feature_type ftrtype_type_display text 2147483647  √  null
person full_name text 2147483647
primer_set fwd_primer text 2147483647  √  null
genotype_component_significance gcs_fmrel_type text 2147483647
genotype_component_significance gcs_ftr_type text 2147483647
genotype_component_significance gcs_mrkr_type text 2147483647
genotype_component_significance gcs_pk_id bigserial 19  √  nextval('genotype_component_significance_gcs_pk_id_seq'::regclass)
genotype_component_significance gcs_significance int4 10
genotype geno_complexity_order int4 10 999999999
genotype geno_date_entered timestamp 29,6  √  now()
genotype geno_display_name text 2147483647
genotype geno_handle text 2147483647
genotype geno_is_extinct bool 1  √  false
genotype geno_is_wildtype bool 1  √  false
genotype geno_name_order text 2147483647  √  null
genotype geno_nickname text 2147483647  √  null
genotype geno_supplier_stock_number text 2147483647  √  null
genotype geno_zdb_id text 2147483647
genotype_background genoback_background_zdb_id text 2147483647
genotype_background genoback_geno_zdb_id text 2147483647
genotype_feature genofeat_dad_zygocity text 2147483647  √  null
genotype_feature genofeat_feature_zdb_id text 2147483647
genotype_feature genofeat_geno_zdb_id text 2147483647
genotype_feature genofeat_mom_zygocity text 2147483647  √  null
genotype_feature genofeat_zdb_id text 2147483647
genotype_feature genofeat_zygocity text 2147483647
fish_experiment genox_exp_zdb_id text 2147483647
tmp_genox_restore genox_exp_zdb_id text 2147483647  √  null
fish_experiment genox_fish_zdb_id text 2147483647
tmp_genox_restore genox_fish_zdb_id text 2147483647  √  null
fish_genox genox_id text 2147483647  √  null
fish_experiment genox_is_standard bool 1  √  false
tmp_genox_restore genox_is_standard bool 1  √  null
fish_experiment genox_is_std_or_generic_control bool 1  √  false
tmp_genox_restore genox_is_std_or_generic_control bool 1  √  null
fish_experiment genox_zdb_id text 2147483647
tmp_genox_restore genox_zdb_id text 2147483647  √  null
genox_fish_annotation_search genoxfas_fas_id int8 19
genox_fish_annotation_search_bkup genoxfas_fas_id int8 19
genox_fish_annotation_search_temp genoxfas_fas_id int8 19
genox_fish_annotation_search genoxfas_genox_zdb_id text 2147483647
genox_fish_annotation_search_bkup genoxfas_genox_zdb_id text 2147483647
genox_fish_annotation_search_temp genoxfas_genox_zdb_id text 2147483647
genox_fish_annotation_search genoxfas_pk_id bigserial 19  √  nextval('genox_fish_annotation_search_genoxfas_pk_id_seq'::regclass)
genox_fish_annotation_search_bkup genoxfas_pk_id bigserial 19  √  nextval('genox_fish_annotation_search_bkup_genoxfas_pk_id_seq'::regclass)
genox_fish_annotation_search_temp genoxfas_pk_id bigserial 19  √  nextval('genox_fish_annotation_search_temp_genoxfas_pk_id_seq'::regclass)
genedom_family_name gfam_name text 2147483647
genedom_family_member gfammem_gfam_name text 2147483647
genedom_family_member gfammem_mrkr_zdb_id text 2147483647
gff3 gff_biotype text 2147483647  √  null
gff3 gff_end int4 10  √  null
gff3 gff_feature text 2147483647  √  null
gff3 gff_frame bpchar 1  √  null
gff3 gff_id text 2147483647
gff3 gff_name text 2147483647  √  null
gff3 gff_parent text 2147483647  √  null
gff3 gff_score text 2147483647  √  null
gff3 gff_seqname text 2147483647  √  null
gff3 gff_source text 2147483647  √  null
gff3 gff_start int4 10  √  null
gff3 gff_strand bpchar 1  √  null
genotype_figure_fast_search gffs_date_created timestamp 29,6 now()
genotype_figure_fast_search gffs_fig_zdb_id text 2147483647
genotype_figure_fast_search gffs_fish_zdb_id text 2147483647
genotype_figure_fast_search gffs_geno_zdb_id text 2147483647
genotype_figure_fast_search gffs_genox_zdb_id text 2147483647  √  null
genotype_figure_fast_search gffs_morph_zdb_id text 2147483647  √  null
genotype_figure_fast_search gffs_pg_id int8 19
genotype_figure_fast_search gffs_psg_id int8 19  √  null
genotype_figure_fast_search gffs_serial_id bigserial 19  √  nextval('genotype_figure_fast_search_new_gffs_serial_id_seq1'::regclass)
go_flag gflag_display_order int4 10
go_flag gflag_name text 2147483647
genotype_group gg_geno_handle text 2147483647  √  null
genotype_group gg_geno_name text 2147483647  √  null
genox_group gg_genotype_zdb_id text 2147483647  √  null
genotype_group gg_group_name text 2147483647  √  null
genox_group gg_group_name text 2147483647  √  null
genotype_group gg_group_pk_id bigserial 19  √  nextval('genotype_group_gg_group_pk_id_seq'::regclass)
genox_group gg_group_pk_id bigserial 19  √  nextval('genox_group_gg_group_pk_id_seq'::regclass)
genox_group_member ggm_genotype_id text 2147483647  √  null
genotype_group_member ggm_group_id int8 19
genox_group_member ggm_group_id int8 19
genotype_group_member ggm_member_id text 2147483647
genox_group_member ggm_member_id text 2147483647
genotype_group_member ggm_member_name text 2147483647  √  null
genotype_group_member ggm_pk_id bigserial 19  √  nextval('genotype_group_member_ggm_pk_id_seq'::regclass)
genox_group_member ggm_pk_id bigserial 19  √  nextval('genox_group_member_ggm_pk_id_seq'::regclass)
genotype_group_member ggm_significance int4 10  √  null
go_evidence_code goev_code text 2147483647
go_evidence_code goev_display_order int4 10
go_evidence_code goev_name text 2147483647
go_ontology gont_ontology_internal_name text 2147483647  √  null
go_ontology gont_ontology_name text 2147483647
go_ontology gont_order int4 10
go_term goterm_go_id text 2147483647
go_term goterm_is_obsolete bool 1 false
go_term goterm_is_secondary bool 1 false
go_term goterm_name text 2147483647
go_term goterm_ontology text 2147483647  √  null
go_term goterm_zdb_id text 2147483647
geneprefix_institution gpi_institution text 2147483647
geneprefix_institution gpi_prefix text 2147483647  √  null
heavy_chain_isotype hviso_name text 2147483647
databasechangelog id varchar 255
databasechangeloglock id int4 10
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
tables_in_trouble idx_scan int8 19  √  null
int_fdbcont_analysis_tool ifat_blastdb_zdb_id text 2147483647
int_fdbcont_analysis_tool ifat_fdbcont_zdb_id text 2147483647
int_image_term iit_img_zdb_id text 2147483647
int_image_term iit_term_zdb_id text 2147483647
company image text 2147483647  √  null
lab image text 2147483647  √  null
person image text 2147483647  √  null
image img_annotation text 2147483647  √  null
image img_comments text 2147483647  √  null
image img_direction text 2147483647
image img_external_name text 2147483647  √  null
image img_fig_zdb_id text 2147483647  √  null
image img_form text 2147483647
image img_height int4 10
image img_image text 2147483647
image img_image_with_annotation text 2147483647  √  null
image img_is_video_still bool 1 false
image img_label text 2147483647  √  null
image img_owner_zdb_id text 2147483647
image img_preparation text 2147483647
image img_thumbnail text 2147483647
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
int_person_pub info text 2147483647  √  null
return_recs info text 2147483647  √  null
zdb_submitters is_curator bool 1 false
zdb_submitters issue_time timestamp 26,3  √  null
int_vegatype_tscripttype ivtst_tscriptt_type_id int8 19
int_vegatype_tscripttype ivtst_vega_type text 2147483647
journal jrnl_abbrev text 2147483647  √  null
journal jrnl_abbrev_lower text 2147483647
journal jrnl_is_nice bool 1  √  null
journal jrnl_isoabbrev text 2147483647  √  null
journal jrnl_medabbrev text 2147483647  √  null
journal jrnl_name text 2147483647
journal jrnl_name_lower text 2147483647
journal jrnl_nlmid text 2147483647  √  null
journal jrnl_online_issn text 2147483647  √  null
journal jrnl_print_issn text 2147483647  √  null
journal jrnl_publisher text 2147483647  √  null
journal jrnl_zdb_id text 2147483647
publication jtype text 2147483647
return_recs jump_to text 2147483647  √  null
publication keywords text 2147483647  √  null
mapped_marker lab text 2147483647  √  null
databasechangelog labels varchar 255  √  null
lab_position labpos_order int4 10
lab_position labpos_pk_id bigserial 19  √  nextval('lab_position_labpos_pk_id_seq'::regclass)
lab_position labpos_position text 2147483647
person last_name text 2147483647
lab_address_update_tracking laut_lab_zdb_id text 2147483647
lab_address_update_tracking laut_new_address text 2147483647
lab_address_update_tracking laut_pk_id bigserial 19  √  nextval('lab_address_update_tracking_laut_pk_id_seq'::regclass)
lab_address_update_tracking laut_previous_address text 2147483647
longest_bin_resident_metric lbrm_date_captured timestamp 29,6 now()
longest_bin_resident_metric lbrm_days_in_status_on_this_date int4 10
longest_bin_resident_metric lbrm_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
paneled_markers lg_location numeric 8,2  √  null
zmap_pub_pan_mark lg_location numeric 8,2
linkage_group lg_name text 2147483647
linkage_group lg_order int4 10  √  null
lines line_name text 2147483647  √  null
lines_tmp line_name text 2147483647  √  null
feature_data line_num text 2147483647
linkage_member_temp linkage_zdb_id text 2147483647  √  null
databasechangelog liquibase varchar 20  √  null
linkage_membership_search lms_distance numeric 8,2  √  null
linkage_membership_search_bkup lms_distance numeric 8,2  √  null
linkage_membership_search_temp lms_distance numeric 8,2  √  null
linkage_membership_search lms_lnkg_zdb_id text 2147483647
linkage_membership_search_bkup lms_lnkg_zdb_id text 2147483647
linkage_membership_search_temp lms_lnkg_zdb_id text 2147483647
linkage_membership_search lms_lnkgmem_id int8 19
linkage_membership_search_bkup lms_lnkgmem_id int8 19
linkage_membership_search_temp lms_lnkgmem_id int8 19
linkage_membership_search lms_lod numeric 8,2  √  null
linkage_membership_search_bkup lms_lod numeric 8,2  √  null
linkage_membership_search_temp lms_lod numeric 8,2  √  null
linkage_membership_search lms_member_1_zdb_id text 2147483647
linkage_membership_search_bkup lms_member_1_zdb_id text 2147483647
linkage_membership_search_temp lms_member_1_zdb_id text 2147483647
linkage_membership_search lms_member_2_zdb_id text 2147483647
linkage_membership_search_bkup lms_member_2_zdb_id text 2147483647
linkage_membership_search_temp lms_member_2_zdb_id text 2147483647
linkage_membership_search lms_pk_id bigserial 19  √  nextval('linkage_membership_search_lms_pk_id_seq'::regclass)
linkage_membership_search_bkup lms_pk_id bigserial 19  √  nextval('linkage_membership_search_bkup_lms_pk_id_seq'::regclass)
linkage_membership_search_temp lms_pk_id bigserial 19  √  nextval('linkage_membership_search_temp_lms_pk_id_seq'::regclass)
linkage_membership_search lms_units text 2147483647  √  null
linkage_membership_search_bkup lms_units text 2147483647  √  null
linkage_membership_search_temp lms_units text 2147483647  √  null
linkage lnkg_chromosome text 2147483647
linkage lnkg_comments text 2147483647  √  null
linkage_old lnkg_comments text 2147483647  √  null
linkage_old lnkg_or_lg text 2147483647
linkage lnkg_source_zdb_id text 2147483647
linkage lnkg_submitter_zdb_id text 2147483647  √  null
linkage_old lnkg_submitter_zdb_id text 2147483647  √  null
linkage lnkg_zdb_id text 2147483647
linkage_old lnkg_zdb_id text 2147483647
linkage_membership lnkgm_distance numeric 8,2  √  null
linkage_membership lnkgm_linkage_zdb_id text 2147483647
linkage_membership lnkgm_lod numeric 8,2  √  null
linkage_membership lnkgm_member_1_zdb_id text 2147483647
linkage_membership lnkgm_member_2_zdb_id text 2147483647
linkage_membership lnkgm_metric text 2147483647  √  null
linkage_membership lnkgm_pair_old_id text 2147483647  √  null
linkage_membership lnkgm_pk_id bigserial 19  √  nextval('linkage_membership_lnkgm_pk_id_seq'::regclass)
linkage_member lnkgmem_linkage_zdb_id text 2147483647
linkage_member lnkgmem_member_zdb_id text 2147483647
linkage_pair lnkgpair_distance numeric 8,2  √  null
linkage_pair lnkgpair_linkage_zdb_id text 2147483647  √  null
linkage_pair lnkgpair_lod numeric 8,2  √  null
linkage_pair lnkgpair_metric text 2147483647  √  null
linkage_pair lnkgpair_zdb_id text 2147483647
pg_stat_statements local_blks_dirtied int8 19  √  null
pg_stat_statements local_blks_hit int8 19  √  null
pg_stat_statements local_blks_read int8 19  √  null
pg_stat_statements local_blks_written int8 19  √  null
databasechangeloglock locked bool 1
databasechangeloglock lockedby varchar 255  √  null
databasechangeloglock lockgranted timestamp 29,6  √  null
linkages_copy lod numeric 8,2  √  null
zdb_submitters login text 2147483647  √  null
linkage_pair_member lpmem_linkage_pair_zdb_id text 2147483647
linkage_pair_member lpmem_linkage_zdb_id text 2147483647
linkage_pair_member lpmem_member_zdb_id text 2147483647
linkage_single lsingle_lnkg_zdb_id text 2147483647
linkage_single lsingle_member_zdb_id text 2147483647
linkage_single lsingle_pk_id bigserial 19  √  nextval('linkage_single_lsingle_pk_id_seq'::regclass)
light_chain_isotype ltiso_name text 2147483647
linkages_copy m1_id text 2147483647  √  null
linkages_copy m2_id text 2147483647  √  null
monthly_average_curated_metric macm_average_stay_in_bin_1 int4 10 0
monthly_average_curated_metric macm_average_stay_in_bin_2 int4 10 0
monthly_average_curated_metric macm_average_stay_in_bin_3 int4 10 0
monthly_average_curated_metric macm_average_stay_in_ortho_bin int4 10 0
monthly_average_curated_metric macm_average_stay_in_pheno_bin int4 10 0
monthly_average_curated_metric macm_average_stay_in_xpat_bin int4 10 0
monthly_average_curated_metric macm_date_captured timestamp 29,6  √  now()
monthly_average_curated_metric macm_longest_bin1_number_of_days int4 10 0
monthly_average_curated_metric macm_longest_bin2_number_of_days int4 10 0
monthly_average_curated_metric macm_longest_bin3_number_of_days int4 10 0
monthly_average_curated_metric macm_longest_expression_number_of_days int4 10 0
monthly_average_curated_metric macm_longest_ortho_number_of_days int4 10 0
monthly_average_curated_metric macm_longest_phenotype_number_of_days int4 10 0
monthly_average_curated_metric macm_paper_in_bin_1_longest text 2147483647  √  null
monthly_average_curated_metric macm_paper_in_bin_2_longest text 2147483647  √  null
monthly_average_curated_metric macm_paper_in_bin_3_longest text 2147483647  √  null
monthly_average_curated_metric macm_paper_in_expression_bin_longest text 2147483647  √  null
monthly_average_curated_metric macm_paper_in_ortho_bin_longest text 2147483647  √  null
monthly_average_curated_metric macm_paper_in_phenotype_bin_longest text 2147483647  √  null
monthly_average_curated_metric macm_pk_id bigserial 19  √  nextval('monthly_average_curated_metric_macm_pk_id_seq'::regclass)
mapped_marker map_name text 2147483647  √  null
paneled_markers map_name text 2147483647  √  null
map_metric mapmetric_code text 2147483647
map_metric mapmetric_description text 2147483647
map_metric mapmetric_name text 2147483647  √  null
panels mappanel_comments text 2147483647
panels mappanel_interactive_url text 2147483647  √  null
panels mappanel_interactive_url_extra_text text 2147483647  √  null
panels mappanel_meiotic_cross_type text 2147483647  √  null
panels mappanel_meiotic_num_meioses int4 10  √  null
panels mappanel_rh_num_cell_lines int4 10  √  null
panels mappanel_rh_rad_dose text 2147483647  √  null
linkage_member_temp marker_1_zdb_id text 2147483647  √  null
linkage_member_temp marker_2_zdb_id text 2147483647  √  null
mapped_marker marker_id text 2147483647  √  null
primer_set marker_id text 2147483647  √  null
mapped_marker marker_type text 2147483647
marker_types marker_type text 2147483647
pg_stat_statements max_time float8 17,17  √  null
monthly_curated_metric mcm_date_captured timestamp 29,6 now()
monthly_curated_metric mcm_number_archived_this_month int4 10 0
monthly_curated_metric mcm_number_closed_curated_this_month int4 10 0
monthly_curated_metric mcm_number_closed_unread_this_month int4 10 0
monthly_curated_metric mcm_number_in_bin_1 int4 10 0
monthly_curated_metric mcm_number_in_bin_2 int4 10 0
monthly_curated_metric mcm_number_in_bin_3 int4 10 0
monthly_curated_metric mcm_number_in_expression_bin int4 10 0
monthly_curated_metric mcm_number_in_ortho_bin int4 10 0
monthly_curated_metric mcm_number_in_phenotype_bin int4 10 0
monthly_curated_metric mcm_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
databasechangelog md5sum varchar 35  √  null
mutation_detail_controlled_vocabulary mdcv_term_abbreviation text 2147483647  √  null
mutation_detail_controlled_vocabulary mdcv_term_display_name text 2147483647
mutation_detail_controlled_vocabulary mdcv_term_order int8 19  √  null
mutation_detail_controlled_vocabulary mdcv_term_zdb_id text 2147483647
mutation_detail_controlled_vocabulary mdcv_used_in text 2147483647
pg_stat_statements mean_time float8 17,17  √  null
mesh_term mesht_mesh_id text 2147483647
mesh_term mesht_term_name text 2147483647
mesh_term mesht_type text 2147483647
mapped_marker metric text 2147483647  √  null
paneled_markers metric text 2147483647  √  null
panels metric text 2147483647
zmap_pub_pan_mark metric text 2147483647
mutant_fast_search mfs_genox_zdb_id text 2147483647
mutant_fast_search mfs_mrkr_zdb_id text 2147483647
paneled_markers mghframework bool 1  √  null
zmap_pub_pan_mark mghframework bool 1
marker_go_term_annotation_extension mgtae_dblink_zdb_id text 2147483647  √  null
marker_go_term_annotation_extension mgtae_extension_group_id int8 19
marker_go_term_annotation_extension mgtae_identifier_term_zdb_id text 2147483647  √  null
marker_go_term_annotation_extension mgtae_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
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
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 mhist_comments text 2147483647  √  null
marker_history mhist_dalias_zdb_id text 2147483647  √  null
marker_history mhist_date timestamp 29,6
marker_history mhist_event text 2147483647
marker_history mhist_mrkr_abbrev_on_mhist_date text 2147483647
marker_history mhist_mrkr_name_on_mhist_date text 2147483647
marker_history mhist_mrkr_prev_name text 2147483647  √  null
marker_history mhist_mrkr_zdb_id text 2147483647
marker_history mhist_reason text 2147483647  √  null
marker_history mhist_zdb_id text 2147483647
marker_history_reason mhistrsn_name text 2147483647
marker_history_event mhistvnt_name text 2147483647
mesh_heading_qualifier mhq_is_major_topic bool 1 false
mesh_heading_qualifier mhq_mesh_heading_id int8 19
mesh_heading_qualifier mhq_mesht_mesh_qualifier_id text 2147483647
pg_stat_statements min_time float8 17,17  √  null
mapped_marker mm_chrom_location numeric 8,2  √  null
mapped_marker mm_chromosome text 2147483647
merge_markers_sql mms_mrkr_1_zdb_id text 2147483647
merge_markers_sql mms_mrkr_2_zdb_id text 2147483647
merge_markers_sql mms_pk_id bigserial 19  √  nextval('merge_markers_sql_mms_pk_id_seq'::regclass)
merge_markers_sql mms_sql text 2147483647
zmap_pub_pan_mark mname 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 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_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_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_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_types mrkrtype_significance int4 10  √  null
marker_types mrkrtype_type_display text 2147483647  √  null
marker_type_group mtgrp_comments text 2147483647
marker_type_group mtgrp_display_name text 2147483647  √  null
marker_type_group mtgrp_name text 2147483647
marker_type_group mtgrp_searchable bool 1  √  false
marker_type_group_member mtgrpmem_mrkr_type text 2147483647
marker_type_group_member mtgrpmem_mrkr_type_group text 2147483647
paneled_markers mtype text 2147483647  √  null
zmap_pub_pan_mark mtype text 2147483647
mutagee mutagee_name text 2147483647
mutagen mutagen_name text 2147483647
tmp_feature mutationtype text 2147483647  √  null
company name text 2147483647  √  null
lab name text 2147483647
panels name text 2147483647
person name text 2147483647  √  null
zdb_submitters name text 2147483647  √  null
updates new_value text 2147483647  √  null
person nicknames text 2147483647  √  null
noctua_model nm_id text 2147483647
noctua_model_annotation nma_mrkrgoev_zdb_id text 2147483647
noctua_model_annotation nma_nm_id text 2147483647
name_precedence nmprec_comments text 2147483647
name_precedence nmprec_precedence text 2147483647
name_precedence nmprec_significance int4 10
ncbi_ortholog_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)
ncbi_ortholog noi_chromosome text 2147483647  √  null
ncbi_ortholog noi_entry_time timestamp 29,6  √  null
ncbi_ortholog noi_name text 2147483647  √  null
ncbi_ortholog noi_ncbi_gene_id text 2147483647
ncbi_ortholog noi_symbol text 2147483647  √  null
ncbi_ortholog noi_taxid int4 10
person nonzf_pubs text 2147483647  √  null
publication num_auths int4 10  √  null
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
ortholog_external_reference oef_accession_number text 2147483647
ortholog_external_reference oef_fdbcont_zdb_id text 2147483647
ortholog_external_reference oef_ortho_zdb_id text 2147483647
ortholog_evidence oev_evidence_code bpchar 2
ortholog_evidence oev_evidence_term_zdb_id text 2147483647
ortholog_evidence oev_ortho_zdb_id text 2147483647
ortholog_evidence oev_pub_zdb_id text 2147483647
ortholog_evidence_code oevcode_code bpchar 2
ortholog_evidence_code oevcode_name text 2147483647
ortholog_evidence_code oevcode_order int4 10
updates old_value text 2147483647  √  null
ortholog_load_tracking olt_last_run timestamp 29,6
ortholog_load_tracking olt_load_name text 2147483647
ortholog_load_tracking olt_number_of_flybase_links text 2147483647
ortholog_load_tracking olt_number_of_gene_links text 2147483647
ortholog_load_tracking olt_number_of_hgnc_links text 2147483647
ortholog_load_tracking olt_number_of_mgi_links text 2147483647
ortholog_load_tracking olt_number_of_omim_links text 2147483647
omim_phenotype omimp_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)
person on_dist_list bool 1  √  null
ontology ont_current_date text 2147483647  √  null
ontology ont_data_version text 2147483647  √  null
ontology ont_default_namespace text 2147483647  √  null
ontology ont_format_version text 2147483647  √  null
ontology ont_import text 2147483647  √  null
ontology ont_ontology_name text 2147483647  √  null
ontology ont_order int4 10
ontology ont_pk_id bigserial 19  √  nextval('ontology_ont_pk_id_seq'::regclass)
ontology ont_remark text 2147483647  √  null
ontology ont_saved_by text 2147483647  √  null
one_to_one_accession ooa_dblink_acc_num text 2147483647
one_to_one_accession ooa_dblink_zdb_id text 2147483647
one_to_one_accession ooa_feature_zdb_id text 2147483647
one_to_one_accession ooa_pk_id bigserial 19  √  nextval('one_to_one_accession_ooa_pk_id_seq'::regclass)
paneled_markers or_lg text 2147483647  √  null
person orcid_id text 2147483647  √  null
databasechangelog orderexecuted int4 10
organism organism_common_name text 2147483647
organism organism_display_order int4 10
organism organism_is_ab_host bool 1  √  false
organism organism_is_ab_immun bool 1  √  false
organism organism_species text 2147483647
organism organism_taxid int4 10
ortholog ortho_other_species_chromosome text 2147483647  √  null
ortholog ortho_other_species_name text 2147483647  √  null
ortholog ortho_other_species_ncbi_gene_id text 2147483647
ortholog ortho_other_species_ncbi_gene_is_obsolete bool 1 false
ortholog ortho_other_species_symbol text 2147483647  √  null
ortholog ortho_other_species_taxid int4 10  √  null
ortholog ortho_zdb_id text 2147483647
ortholog ortho_zebrafish_gene_zdb_id text 2147483647
ontology_subset osubset_ont_id int8 19
ontology_subset osubset_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
feature_data other_feature_id text 2147483647  √  null
tmp_zeco_tt othertermid text 2147483647  √  null
omimp_termxref_mapping otm_omimp_id int8 19
omimp_termxref_mapping otm_tx_id int8 19
company owner text 2147483647  √  null
lab owner text 2147483647  √  null
linkages_copy owner text 2147483647  √  null
mapped_marker owner text 2147483647  √  null
panels owner text 2147483647
person owner text 2147483647  √  null
publication owner text 2147483647  √  null
missing_xpatfig oxpatfig_fig_zdb_id text 2147483647  √  null
missing_xpatfig oxpatfig_xpatres_zdb_id text 2147483647  √  null
tmp_feature pageurl text 2147483647  √  null
zmap_pub_pan_mark panel_abbrev text 2147483647  √  null
panels panel_date date 13
zmap_pub_pan_mark panel_id text 2147483647
panel_count panelcnt_chromosome text 2147483647
panel_count panelcnt_count int4 10
panel_count panelcnt_mrkr_type text 2147483647
panel_count panelcnt_or_lg text 2147483647  √  null
panel_count panelcnt_panel_zdb_id text 2147483647
zdb_submitters password text 2147483647  √  null
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
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
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
person pers_bio text 2147483647  √  null
person pers_is_deceased bool 1 false
person pers_is_hidden bool 1 false
person_author persauth_author_id int8 19
person_author persauth_connected_by text 2147483647
person_author persauth_date_connected_date timestamp 29,6 now()
person_author persauth_person_zdb_id text 2147483647
person_author persauth_pk_id bigserial 19  √  nextval('person_author_persauth_pk_id_seq'::regclass)
person person_country text 2147483647  √  null
publication_file pf_date_entered timestamp 29,6 now()
publication_file pf_file_name text 2147483647
publication_file pf_file_type_id int8 19
publication_file pf_original_file_name text 2147483647  √  null
publication_file pf_pk_id bigserial 19  √  nextval('publication_file_pf_pk_id_seq'::regclass)
publication_file pf_pub_zdb_id text 2147483647
phenotype_figure_group pfigg_geno_handle text 2147483647  √  null
phenotype_figure_group pfigg_geno_name text 2147483647  √  null
phenotype_figure_group pfigg_genox_zdb_id text 2147483647  √  null
phenotype_figure_group pfigg_group_name text 2147483647  √  null
phenotype_figure_group 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)
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
phenotype_source_generated pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_end_stg_zdb_id text 2147483647  √  null
phenotype_source_generated pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_fig_zdb_id text 2147483647  √  null
phenotype_source_generated pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_genox_zdb_id text 2147483647  √  null
phenotype_source_generated pg_id int8 19  √  null
phenotype_source_generated_bkup pg_id int8 19  √  null
phenotype_source_generated_temp pg_id bigserial 19  √  nextval('phenotype_source_generated_temp_pg_id_seq'::regclass)
phenotype_source_generated pg_start_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_bkup pg_start_stg_zdb_id text 2147483647  √  null
phenotype_source_generated_temp pg_start_stg_zdb_id text 2147483647  √  null
phenotype_generated_curated_mapping pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping_bkup pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping_temp pgcm_id_type text 2147483647  √  null
phenotype_generated_curated_mapping pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping_bkup pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping_temp pgcm_pg_id int8 19  √  null
phenotype_generated_curated_mapping pgcm_source_id text 2147483647  √  null
phenotype_generated_curated_mapping_bkup pgcm_source_id text 2147483647  √  null
phenotype_generated_curated_mapping_temp pgcm_source_id text 2147483647  √  null
phenotype_statement phenos_created_date timestamp 29,6  √  now()
phenotype_statement phenos_entity_1_subterm_zdb_id text 2147483647  √  null
phenotype_statement phenos_entity_1_superterm_zdb_id text 2147483647
phenotype_statement phenos_entity_2_subterm_zdb_id text 2147483647  √  null
phenotype_statement phenos_entity_2_superterm_zdb_id text 2147483647  √  null
remove_phenos_ids phenos_id bigserial 19  √  nextval('remove_phenos_ids_phenos_id_seq'::regclass)
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
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
company phone text 2147483647  √  null
lab phone text 2147483647  √  null
person phone text 2147483647  √  null
probe_lib pl_description text 2147483647  √  null
probe_lib pl_develop_stage text 2147483647  √  null
probe_lib pl_lab_host text 2147483647  √  null
probe_lib pl_lib_name text 2147483647  √  null
probe_lib pl_organ text 2147483647  √  null
probe_lib pl_organism text 2147483647  √  null
probe_lib pl_r_site_1 text 2147483647  √  null
probe_lib pl_r_site_2 text 2147483647  √  null
probe_lib pl_sex text 2147483647  √  null
probe_lib pl_strain text 2147483647  √  null
probe_lib pl_tissue_type text 2147483647  √  null
probe_lib pl_url text 2147483647  √  null
probe_lib pl_vector text 2147483647  √  null
probe_lib pl_zdb_id text 2147483647  √  null
publication_note pnote_curator_zdb_id text 2147483647
publication_note pnote_date timestamp 29,6  √  null
publication_note pnote_pub_zdb_id text 2147483647
publication_note pnote_text text 2147483647  √  null
publication_note pnote_zdb_id text 2147483647
int_person_company position_id int8 19  √  null
int_person_lab position_id int8 19  √  null
zdb_submitters previous_login timestamp 26,3  √  null
tables_in_trouble priority text 2147483647  √  null
probe_library probelib_host text 2147483647  √  null
probe_library probelib_name text 2147483647  √  null
probe_library probelib_non_zfin_stg_name text 2147483647  √  null
probe_library probelib_non_zfin_strain_name text 2147483647  √  null
probe_library probelib_non_zfin_tissue_name text 2147483647  √  null
probe_library probelib_restriction_sites text 2147483647  √  null
probe_library probelib_sex text 2147483647  √  null
probe_library probelib_species text 2147483647
probe_library probelib_stg_zdb_id text 2147483647  √  null
probe_library probelib_strain_zdb_id text 2147483647  √  null
probe_library probelib_term_zdb_id text 2147483647  √  null
probe_library probelib_tissue_zdb_id text 2147483647  √  null
probe_library probelib_url text 2147483647  √  null
probe_library probelib_zdb_id text 2147483647
panels producer text 2147483647
phenotype_observation_generated psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1_relation_name text 2147483647  √  null
phenotype_observation_generated psg_e1a_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1a_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1a_name text 2147483647  √  null
phenotype_observation_generated psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e1a_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e1b_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1b_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e1b_name text 2147483647  √  null
phenotype_observation_generated psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e1b_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2_relation_name text 2147483647  √  null
phenotype_observation_generated psg_e2a_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2a_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2a_name text 2147483647  √  null
phenotype_observation_generated psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e2a_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_e2b_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2b_name text 2147483647  √  null
phenotype_observation_generated_temp psg_e2b_name text 2147483647  √  null
phenotype_observation_generated psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_e2b_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_id int8 19  √  null
phenotype_observation_generated_bkup psg_id int8 19  √  null
phenotype_observation_generated_temp psg_id bigserial 19  √  nextval('phenotype_observation_generated_temp_psg_id_seq'::regclass)
phenotype_observation_generated psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated_bkup psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated_temp psg_mrkr_abbrev text 2147483647  √  null
phenotype_observation_generated psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated_bkup psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated_temp psg_mrkr_relation text 2147483647  √  null
phenotype_observation_generated psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_mrkr_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_pg_id int8 19  √  null
phenotype_observation_generated_bkup psg_pg_id int8 19  √  null
phenotype_observation_generated_temp psg_pg_id int8 19  √  null
phenotype_observation_generated psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated_bkup psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated_temp psg_pre_eap_phenotype bool 1  √  false
phenotype_observation_generated psg_quality_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_quality_name text 2147483647  √  null
phenotype_observation_generated_temp psg_quality_name text 2147483647  √  null
phenotype_observation_generated psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated_bkup psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated_temp psg_quality_zdb_id text 2147483647  √  null
phenotype_observation_generated psg_short_name text 2147483647  √  null
phenotype_observation_generated_bkup psg_short_name text 2147483647  √  null
phenotype_observation_generated_temp psg_short_name text 2147483647  √  null
phenotype_observation_generated psg_tag text 2147483647  √  null
phenotype_observation_generated_bkup psg_tag text 2147483647  √  null
phenotype_observation_generated_temp psg_tag text 2147483647  √  null
pheno_term pt_end_stg_zdb_id text 2147483647
pheno_term_old pt_end_stg_zdb_id text 2147483647
pheno_term pt_fig_zdb_id text 2147483647
pheno_term_old pt_fig_zdb_id text 2147483647
pheno_term pt_geno_is_wildtype bool 1
pheno_term_old pt_geno_is_wildtype bool 1
pheno_term pt_geno_zdb_id text 2147483647
pheno_term_old pt_geno_zdb_id text 2147483647
pheno_term pt_genox_zdb_id text 2147483647
pheno_term_old pt_genox_zdb_id text 2147483647
pheno_term pt_pheno_entity text 2147483647
pheno_term_old pt_pheno_entity text 2147483647
pheno_term pt_pk_id bigserial 19  √  nextval('pheno_term_pt_pk_id_seq'::regclass)
pheno_term_old pt_pk_id bigserial 19  √  nextval('pheno_term_old_pt_pk_id_seq'::regclass)
pheno_term pt_pub_zdb_id text 2147483647
pheno_term_old pt_pub_zdb_id text 2147483647
pheno_term pt_start_stg_zdb_id text 2147483647
pheno_term_old pt_start_stg_zdb_id text 2147483647
pheno_term pt_tag text 2147483647  √  null
pheno_term_old pt_tag text 2147483647  √  null
pheno_term_fast_search ptfs_created_date timestamp 29,6  √  now()
pheno_term_fast_search_tmp ptfs_created_date timestamp 29,6  √  now()
pheno_term_fast_search ptfs_is_direct_annotation bool 1  √  false
pheno_term_fast_search_tmp ptfs_is_direct_annotation bool 1  √  false
pheno_term_fast_search ptfs_phenos_created_date timestamp 29,6
pheno_term_fast_search_tmp ptfs_phenos_created_date timestamp 29,6
pheno_term_fast_search ptfs_pk_id bigserial 19  √  nextval('pheno_term_fast_search_ptfs_pk_id_seq'::regclass)
pheno_term_fast_search_tmp ptfs_pk_id bigserial 19  √  nextval('pheno_term_fast_search_tmp_ptfs_pk_id_seq'::regclass)
pheno_term_fast_search ptfs_psg_id int8 19  √  null
pheno_term_fast_search_tmp ptfs_psg_id int8 19  √  null
pheno_term_fast_search ptfs_tag text 2147483647  √  null
pheno_term_fast_search_tmp ptfs_tag text 2147483647  √  null
pheno_term_fast_search ptfs_term_zdb_id text 2147483647
pheno_term_fast_search_tmp ptfs_term_zdb_id text 2147483647
pub_tracking_history pth_claimed_by text 2147483647  √  null
pub_tracking_history pth_days_in_status int4 10  √  null
pub_tracking_history pth_location_id int8 19  √  null
pub_tracking_history pth_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_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
panels ptype text 2147483647
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
feature_data pub_id text 2147483647  √  null
publication pub_indexed_date timestamp 29,6  √  null
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_mini_ref text 2147483647  √  null
publication pub_pages text 2147483647  √  null
publication pub_volume text 2147483647  √  null
publication_correspondence pubcorr_contacted_date timestamp 29,6 now()
publication_correspondence pubcorr_curator_zdb_id text 2147483647
publication_correspondence pubcorr_gave_up_date timestamp 29,6  √  null
publication_correspondence pubcorr_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
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_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_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
publication pubmed_authors text 2147483647  √  null
pg_stat_statements query text 2147483647  √  null
pg_stat_statements queryid int8 19  √  null
replaced_accession_number ran_new_acc_num text 2147483647
replaced_accession_number ran_old_acc_num text 2147483647
updates rec_id text 2147483647  √  null
return_recs rec_update bool 1  √  null
record_attribution recattrib_data_zdb_id text 2147483647
record_attribution recattrib_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
mapped_marker refcross_id text 2147483647
primer_set restr_enzyme text 2147483647  √  null
return_recs return_form text 2147483647  √  null
return_recs return_recid text 2147483647  √  null
primer_set rev_primer text 2147483647  √  null
pg_stat_statements rows int8 19  √  null
run run_blastdb text 2147483647
run run_date timestamp 29,6
run run_name text 2147483647
run run_nomen_pub_zdb_id text 2147483647 'ZDB-PUB-030508-1'::text
run run_program text 2147483647
run run_relation_pub_zdb_id text 2147483647  √  null
run run_type text 2147483647
run run_version text 2147483647  √  null
run run_zdb_id text 2147483647
run_candidate runcan_cnd_zdb_id text 2147483647
run_candidate runcan_done bool 1 false
run_candidate runcan_locked_by text 2147483647  √  null
run_candidate runcan_occurrence_order int4 10
run_candidate runcan_run_zdb_id text 2147483647
run_candidate runcan_zdb_id text 2147483647
run_program runprog_program text 2147483647
run_program runprog_query_type text 2147483647  √  null
run_program runprog_target_type text 2147483647  √  null
run_type runtype_name text 2147483647
source_alias salias_alias text 2147483647
source_alias salias_alias_lower text 2147483647
source_alias salias_source_zdb_id text 2147483647
source_alias salias_zdb_id text 2147483647
mapped_marker scoring_data text 2147483647  √  null
marker_sequence seq_left_end text 2147483647  √  null
snp_sequence seq_left_end text 2147483647  √  null
marker_sequence seq_mrkr_zdb_id text 2147483647
snp_sequence seq_mrkr_zdb_id text 2147483647  √  null
marker_sequence seq_offset_start int4 10  √  null
snp_sequence seq_offset_start int4 10  √  null
marker_sequence seq_offset_stop int4 10  √  null
snp_sequence seq_offset_stop int4 10  √  null
tables_in_trouble seq_scan int8 19  √  null
marker_sequence seq_sequence text 2147483647  √  null
snp_sequence seq_sequence text 2147483647  √  null
marker_sequence seq_sequence_2 text 2147483647  √  null
snp_sequence seq_sequence_2 text 2147483647  √  null
marker_sequence seq_type text 2147483647  √  null
snp_sequence seq_type text 2147483647  √  null
snp_sequence seq_variation text 2147483647  √  null
sequence_ambiguity_code seqac_meaning text 2147483647
sequence_ambiguity_code seqac_symbol bpchar 1  √  null
sequence_type seqtype_comments text 2147483647  √  null
sequence_type seqtype_name text 2147483647
tmp_feature sequence text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_acc_num text 2147483647  √  null
sequence_feature_chromosome_location sfcl_assembly text 2147483647  √  null
sequence_feature_chromosome_location sfcl_chromosome text 2147483647
sequence_feature_chromosome_location_bkup sfcl_chromosome text 2147483647
sequence_feature_chromosome_location_temp sfcl_chromosome text 2147483647
sequence_feature_chromosome_location_bkup sfcl_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_end int4 10  √  null
sequence_feature_chromosome_location_temp sfcl_end int4 10  √  null
sequence_feature_chromosome_location sfcl_end_position int4 10  √  null
sequence_feature_chromosome_location_bkup sfcl_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_temp sfcl_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location sfcl_feature_zdb_id text 2147483647
sequence_feature_chromosome_location_bkup sfcl_location_source text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_location_source text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_temp sfcl_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_bkup sfcl_start int4 10  √  null
sequence_feature_chromosome_location_temp sfcl_start int4 10  √  null
sequence_feature_chromosome_location sfcl_start_position int4 10  √  null
sequence_feature_chromosome_location sfcl_zdb_id text 2147483647
sequence_feature_chromosome_location_generated sfclg_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_acc_num text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_assembly text 2147483647  √  'GRCv10'::text
sequence_feature_chromosome_location_generated sfclg_chromosome text 2147483647
sequence_feature_chromosome_location_generated_bkup sfclg_chromosome text 2147483647
sequence_feature_chromosome_location_generated_temp sfclg_chromosome text 2147483647
sequence_feature_chromosome_location_generated sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_data_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_end int4 10  √  null
sequence_feature_chromosome_location_generated sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated_temp sfclg_fdb_db_id int8 19  √  null
sequence_feature_chromosome_location_generated sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_gbrowse_track text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_source text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_subsource text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_pk_id bigserial 19  √  nextval('sequence_feature_chromosome_location_generated_sfclg_pk_id_seq'::regclass)
sequence_feature_chromosome_location_bkup sfclg_pub_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_pub_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_temp sfclg_pub_zdb_id text 2147483647  √  null
sequence_feature_chromosome_location_generated sfclg_start int4 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_start int4 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_start int4 10  √  null
source_feature_prefix sfp_current_designation bool 1 true
source_feature_prefix sfp_prefix_id int8 19
source_feature_prefix sfp_source_zdb_id text 2147483647
pg_stat_statements shared_blks_dirtied int8 19  √  null
pg_stat_statements shared_blks_hit int8 19  √  null
pg_stat_statements shared_blks_read int8 19  √  null
pg_stat_statements shared_blks_written int8 19  √  null
single sngl_one text 2147483647  √  null
snp_download snpd_mrkr_zdb_id text 2147483647
snp_download snpd_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
panels source text 2147483647
primer_set source text 2147483647  √  null
int_person_company source_id text 2147483647
int_person_lab source_id text 2147483647
int_person_pub source_id text 2147483647
source_url srcurl_display_text text 2147483647
source_url srcurl_purpose text 2147483647 'information'::text
source_url srcurl_source_zdb_id text 2147483647
source_url srcurl_url text 2147483647
source_url_purpose srcurlpurp_comments text 2147483647  √  null
source_url_purpose srcurlpurp_name text 2147483647
company status text 2147483647  √  null
int_person_company status text 2147483647  √  null
int_person_lab status text 2147483647  √  null
int_person_pub status text 2147483647  √  null
lab status text 2147483647  √  null
panels status text 2147483647
publication status text 2147483647  √  null
state_code stc_code text 2147483647
state_code stc_display_order int4 10  √  null
state_code stc_name text 2147483647
pg_stat_statements stddev_time float8 17,17  √  null
stage stg_abbrev text 2147483647  √  null
stage stg_hours_end numeric 7,2
stage stg_hours_start numeric 7,2
stage stg_name text 2147483647  √  null
stage stg_name_ext text 2147483647  √  null
stage stg_name_long text 2147483647  √  null
stage stg_obo_id text 2147483647
stage stg_other_features text 2147483647  √  null
stage stg_zdb_id text 2147483647
primer_set strain_id text 2147483647  √  null
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)
mapped_marker submitter text 2147483647  √  null
updates submitter_id text 2147483647  √  null
updates submitter_name text 2147483647  √  null
tables_in_trouble sz_n_byts int8 19  √  null
so_zfin_mapping szm_object_type text 2147483647
so_zfin_mapping szm_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
tables_in_trouble table_in_trouble text 2147483647  √  null
databasechangelog tag varchar 255  √  null
paneled_markers target_abbrev text 2147483647  √  null
zmap_pub_pan_mark target_abbrev text 2147483647
int_person_company target_id text 2147483647
int_person_lab target_id text 2147483647
int_person_pub target_id text 2147483647
paneled_markers target_id text 2147483647  √  null
zmap_pub_pan_mark target_id text 2147483647
tables_in_trouble tbl_rec_count text 2147483647  √  null
pg_stat_statements temp_blks_read int8 19  √  null
pg_stat_statements temp_blks_written int8 19  √  null
term term_comment text 2147483647  √  null
term term_definition text 2147483647  √  null
term term_is_obsolete bool 1 false
term term_is_root bool 1 false
term term_is_secondary bool 1 false
term term_name text 2147483647
term term_name_order text 2147483647  √  null
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_relationship termrel_term_1_zdb_id text 2147483647
term_relationship termrel_term_2_zdb_id text 2147483647
term_relationship termrel_type text 2147483647
term_relationship termrel_zdb_id text 2147483647
term_relationship_type termreltype_name text 2147483647
term_subset termsub_subset_id int8 19
term_subset termsub_term_zdb_id text 2147483647
term_group tg_geno_handle text 2147483647  √  null
term_group tg_geno_name text 2147483647  √  null
term_group tg_genox_group text 2147483647  √  null
term_group tg_group_name text 2147483647  √  null
term_group tg_group_pk_id bigserial 19  √  nextval('term_group_tg_group_pk_id_seq'::regclass)
tmp_feature tgtgeneid text 2147483647  √  null
tmp_feature tgtgenesymbol text 2147483647  √  null
primer_set the_id text 2147483647  √  null
publication title text 2147483647  √  null
tmp_db_link tmp_acc_num text 2147483647  √  null
tmp_db_link tmp_db_name text 2147483647  √  null
tmp_db_link tmp_dblink_zdb_id text 2147483647  √  null
tmp_db_link tmp_fdbcont_zdb_id text 2147483647  √  null
tmp_db_link tmp_info text 2147483647  √  null
tmp_db_link tmp_length int4 10  √  null
tmp_db_link tmp_linked_recid text 2147483647  √  null
pg_stat_statements total_time float8 17,17  √  null
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
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_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_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
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
unique_location ul_chromosome text 2147483647
unique_location ul_data_zdb_id text 2147483647
updates upd_pk_id bigserial 19  √  nextval('updates_upd_pk_id_seq'::regclass)
updates upd_when timestamp 26,3  √  null
company url text 2147483647  √  null
lab url text 2147483647  √  null
person url text 2147483647  √  null
url_ref urlref_data_zdb_id text 2147483647
url_ref urlref_display_text text 2147483647  √  null
url_ref urlref_full_url text 2147483647  √  null
url_ref urlref_zdb_id text 2147483647
pg_stat_statements userid oid 10  √  null
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)
validate_check_history vldcheck_count int4 10
validate_check_history vldcheck_date timestamp 29,6
validate_check_history vldcheck_name text 2147483647
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)
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)
xpat_exp_details_generated xedg_assay_name text 2147483647
xpat_exp_details_generated_bkup xedg_assay_name text 2147483647  √  null
xpat_exp_details_generated_temp xedg_assay_name text 2147483647  √  null
xpat_exp_details_generated xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_atb_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_dblink_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_direct_submission_date timestamp 29,6 now()
xpat_exp_details_generated_bkup xedg_direct_submission_date timestamp 29,6  √  now()
xpat_exp_details_generated_temp xedg_direct_submission_date timestamp 29,6  √  now()
xpat_exp_details_generated xedg_fig_zdb_id text 2147483647
xpat_exp_details_generated_bkup xedg_fig_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_fig_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_gene_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_genox_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_genox_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_genox_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_pk_id int8 19
xpat_exp_details_generated_bkup xedg_pk_id bigserial 19  √  nextval('xpat_exp_details_generated_bkup_xedg_pk_id_seq'::regclass)
xpat_exp_details_generated_temp xedg_pk_id bigserial 19  √  nextval('xpat_exp_details_generated_temp_xedg_pk_id_seq'::regclass)
xpat_exp_details_generated xedg_probe_feature_zdb_id text 2147483647  √  null
xpat_exp_details_generated_bkup xedg_probe_feature_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_probe_feature_zdb_id text 2147483647  √  null
xpat_exp_details_generated xedg_zdb_id text 2147483647
xpat_exp_details_generated_bkup xedg_zdb_id text 2147483647  √  null
xpat_exp_details_generated_temp xedg_zdb_id text 2147483647  √  null
xpat_figure_group xfigg_geno_handle text 2147483647  √  null
xpat_figure_group xfigg_genox_zdb_id text 2147483647  √  null
xpat_figure_group xfigg_group_name text 2147483647  √  null
xpat_figure_group xfigg_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)
tmp_efs_map xpat_found bool 1  √  null
expression_pattern_assay xpatassay_abbrev text 2147483647  √  null
expression_pattern_assay xpatassay_comments text 2147483647  √  null
expression_pattern_assay xpatassay_display_order int4 10
expression_pattern_assay xpatassay_mmo_id text 2147483647  √  null
expression_pattern_assay xpatassay_name text 2147483647
expression_experiment xpatex_assay_name text 2147483647  √  null
expression_experiment2 xpatex_assay_name text 2147483647
expression_experiment_bkup xpatex_assay_name text 2147483647  √  null
expression_experiment_temp xpatex_assay_name text 2147483647  √  null
expression_experiment xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_atb_zdb_id text 2147483647  √  null
expression_experiment xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_dblink_zdb_id text 2147483647  √  null
expression_experiment xpatex_direct_submission_date timestamp 29,6  √  now()
expression_experiment2 xpatex_direct_submission_date timestamp 29,6 now()
expression_experiment_bkup xpatex_direct_submission_date timestamp 29,6  √  null
expression_experiment_temp xpatex_direct_submission_date timestamp 29,6  √  null
expression_experiment xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_gene_zdb_id text 2147483647  √  null
expression_experiment xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_genox_zdb_id text 2147483647  √  null
expression_experiment xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_probe_feature_zdb_id text 2147483647  √  null
expression_experiment xpatex_source_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_source_zdb_id text 2147483647  √  null
expression_experiment_bkup xpatex_source_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_source_zdb_id text 2147483647  √  null
expression_experiment xpatex_zdb_id text 2147483647  √  null
expression_experiment2 xpatex_zdb_id text 2147483647
expression_experiment_bkup xpatex_zdb_id text 2147483647  √  null
expression_experiment_temp xpatex_zdb_id text 2147483647  √  null
expression_pattern_figure xpatfig_fig_zdb_id text 2147483647  √  null
expression_pattern_figure_bkup xpatfig_fig_zdb_id text 2147483647  √  null
expression_pattern_figure_temp xpatfig_fig_zdb_id text 2147483647  √  null
expression_pattern_figure xpatfig_xpatres_zdb_id int8 19  √  null
expression_pattern_figure_bkup xpatfig_xpatres_zdb_id int8 19  √  null
expression_pattern_figure_temp xpatfig_xpatres_zdb_id int8 19  √  null
expression_pattern_infrastructure xpatinf_curator_zdb_id text 2147483647
expression_pattern_infrastructure xpatinf_date timestamp 29,6 now()
expression_pattern_infrastructure xpatinf_expression_found bool 1  √  true
expression_pattern_infrastructure xpatinf_pub_zdb_id text 2147483647
expression_pattern_infrastructure xpatinf_quality_term_zdb_id text 2147483647  √  null
expression_pattern_infrastructure xpatinf_subterm_zdb_id text 2147483647  √  null
expression_pattern_infrastructure xpatinf_superterm_zdb_id text 2147483647
expression_pattern_infrastructure xpatinf_tag text 2147483647  √  null
expression_pattern_infrastructure xpatinf_zdb_id text 2147483647
expression_result xpatres_comments text 2147483647  √  null
expression_result2 xpatres_efs_id int8 19
expression_result_bkup xpatres_end_stage_zdb_id text 2147483647  √  null
expression_result xpatres_end_stg_zdb_id text 2147483647  √  null
expression_result_temp xpatres_end_stg_zdb_id text 2147483647  √  null
expression_result xpatres_expression_found bool 1  √  true
expression_result2 xpatres_expression_found bool 1
expression_result_bkup xpatres_expression_found bool 1  √  null
expression_result_temp xpatres_expression_found bool 1  √  null
expression_result xpatres_fig_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_fig_zdb_id text 2147483647  √  null
expression_result_temp xpatres_fig_zdb_id text 2147483647  √  null
expression_result2 xpatres_pk_id bigserial 19  √  nextval('expression_result2_xpatres_pk_id_seq'::regclass)
expression_result_bkup xpatres_pk_id int8 19  √  null
expression_result_bkup xpatres_start_stage_zdb_id text 2147483647  √  null
expression_result xpatres_start_stg_zdb_id text 2147483647  √  null
expression_result_temp xpatres_start_stg_zdb_id text 2147483647  √  null
tmp_efs_map xpatres_subterm text 2147483647  √  null
expression_result xpatres_subterm_zdb_id text 2147483647  √  null
expression_result2 xpatres_subterm_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_subterm_zdb_id text 2147483647  √  null
expression_result_temp xpatres_subterm_zdb_id text 2147483647  √  null
tmp_efs_map xpatres_superterm text 2147483647  √  null
expression_result xpatres_superterm_zdb_id text 2147483647  √  null
expression_result2 xpatres_superterm_zdb_id text 2147483647
expression_result_bkup xpatres_superterm_zdb_id text 2147483647  √  null
expression_result_temp xpatres_superterm_zdb_id text 2147483647  √  null
expression_result xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result_bkup xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result_temp xpatres_xpatex_zdb_id text 2147483647  √  null
expression_result xpatres_zdb_id int8 19  √  null
expression_result_temp xpatres_zdb_id bigserial 19  √  nextval('expression_result_temp_xpatres_zdb_id_seq'::regclass)
xpat_results_generated xrg_comments text 2147483647  √  null
xpat_results_generated_bkup xrg_comments text 2147483647  √  null
xpat_results_generated_temp xrg_comments text 2147483647  √  null
xpat_results_generated xrg_end_stg_zdb_id text 2147483647
xpat_results_generated_bkup xrg_end_stg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_end_stg_zdb_id text 2147483647  √  null
xpat_results_generated xrg_expression_found bool 1 true
xpat_results_generated_bkup xrg_expression_found bool 1  √  true
xpat_results_generated_temp xrg_expression_found bool 1  √  true
xpat_results_generated xrg_pk_id int8 19
xpat_results_generated_bkup xrg_pk_id bigserial 19  √  nextval('xpat_results_generated_bkup_xrg_pk_id_seq'::regclass)
xpat_results_generated_temp xrg_pk_id bigserial 19  √  nextval('xpat_results_generated_temp_xrg_pk_id_seq'::regclass)
xpat_results_generated xrg_start_stg_zdb_id text 2147483647
xpat_results_generated_bkup xrg_start_stg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_start_stg_zdb_id text 2147483647  √  null
xpat_results_generated xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated_bkup xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_subterm_zdb_id text 2147483647  √  null
xpat_results_generated xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated_bkup xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated_temp xrg_suggested_anatomy_item text 2147483647  √  null
xpat_results_generated xrg_superterm_zdb_id text 2147483647
xpat_results_generated_bkup xrg_superterm_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_superterm_zdb_id text 2147483647  √  null
xpat_results_generated xrg_xedg_id int8 19
xpat_results_generated_bkup xrg_xedg_id int8 19  √  null
xpat_results_generated_temp xrg_xedg_id int8 19  √  null
xpat_results_generated xrg_xedg_zdb_id text 2147483647
xpat_results_generated_bkup xrg_xedg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_xedg_zdb_id text 2147483647  √  null
xpat_results_generated xrg_zdb_id text 2147483647
xpat_results_generated_bkup xrg_zdb_id text 2147483647  √  null
xpat_results_generated_temp xrg_zdb_id text 2147483647  √  null
zfin_accession_number za_acc_num text 2147483647
zfin_accession_number za_date_entered timestamp 29,6 now()
zfin_accession_number za_prefix text 2147483647 'ZFINNUCL'::text
zfin_accession_number za_sequence_number int8 19
zdb_active_data zactvd_zdb_id text 2147483647
zdb_active_source zactvs_zdb_id text 2147483647
company zdb_id text 2147483647
lab zdb_id text 2147483647
mapped_marker zdb_id text 2147483647
paneled_markers zdb_id text 2147483647  √  null
panels zdb_id text 2147483647
person zdb_id text 2147483647
primer_set zdb_id text 2147483647
publication zdb_id text 2147483647
return_recs zdb_id text 2147483647  √  null
zdb_submitters zdb_id text 2147483647
zmap_pub_pan_mark zdb_id text 2147483647  √  null
tmp_zeco_tt zecoid text 2147483647  √  null
zfin_ensembl_gene zeg_alias text 2147483647
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_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
zdb_flag zflag_is_on bool 1
zdb_flag zflag_last_modified timestamp 29,6
zdb_flag zflag_name text 2147483647
zmap_pub_pan_mark zmap_chromosome text 2147483647
zdb_object_type zobjtype_attribution_display_tier int4 10  √  2
zdb_object_type zobjtype_day date 13
zdb_object_type zobjtype_home_table text 2147483647
zdb_object_type zobjtype_home_zdb_id_column text 2147483647
zdb_object_type zobjtype_is_data bool 1  √  null
zdb_object_type zobjtype_is_source bool 1  √  null
zdb_object_type zobjtype_name text 2147483647
zdb_orphan_data zorphand_home_table text 2147483647  √  null
zdb_orphan_data zorphand_home_zdb_id_column text 2147483647  √  null
zdb_orphan_data zorphand_zdb_id text 2147483647
zdb_orphan_source zorphans_home_table text 2147483647  √  null
zdb_orphan_source zorphans_home_zdb_id_column text 2147483647  √  null
zdb_orphan_source zorphans_zdb_id text 2147483647
zdb_replaced_data zrepld_new_zdb_id text 2147483647
zdb_replaced_data zrepld_old_name text 2147483647  √  null
zdb_replaced_data zrepld_old_zdb_id text 2147483647
zdb_replaced_data zrepld_pk_id bigserial 19  √  nextval('zdb_replaced_data_zrepld_pk_id_seq'::regclass)
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_name text 2147483647
zygocity zyg_zdb_id text 2147483647