SchemaSpy Analysis of zfindb.informix - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Jun 22 08:42 PDT 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

zfindb.informix contains 2210 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
paneled_markers abbrev varchar 40  √  null
panels abbrev varchar 20
sangerfeatures abbrev varchar 50  √  null
zmap_pub_pan_mark abbrev varchar 10
zmap_pub_pan_mark abbrevp varchar 15
accession_bank accbk_abbreviation varchar 30  √  null
accession_bank accbk_acc_num varchar 30
accession_bank accbk_defline lvarchar 2048  √  null
accession_bank accbk_fdbcont_zdb_id varchar 50
accession_bank accbk_length int 10  √  null
accession_bank accbk_name varchar 255  √  null
accession_bank accbk_pk_id serial8 19  √ 
zdb_submitters access varchar 80  √  null
publication accession_no int 10  √  null
accession_version accver_acc_num varchar 50
accession_version accver_version int 10
return_recs action varchar 50  √  null
average_curation_time_metric actm_average_time_in_bin1 int 10 0
average_curation_time_metric actm_average_time_in_bin2 int 10 0
average_curation_time_metric actm_average_time_in_bin3 int 10 0
average_curation_time_metric actm_average_time_in_curating_status int 10 0
average_curation_time_metric actm_average_time_in_ortho int 10 0
average_curation_time_metric actm_average_time_in_pheno int 10 0
average_curation_time_metric actm_average_time_in_xpat int 10 0
average_curation_time_metric actm_average_time_waiting_for_author int 10 0
average_curation_time_metric actm_average_time_waiting_for_curator_review int 10 0
average_curation_time_metric actm_average_time_waiting_for_nomenclature int 10 0
average_curation_time_metric actm_average_time_waiting_for_ontology int 10 0
average_curation_time_metric actm_average_time_waiting_for_software_fix int 10 0
average_curation_time_metric actm_date_captured datetime year to second 19 current
average_curation_time_metric actm_pk_id serial8 19  √  0
average_curation_time_metric actm_stddev_in_bin1 int 10 0
average_curation_time_metric actm_stddev_in_bin2 int 10 0
average_curation_time_metric actm_stddev_in_bin3 int 10 0
average_curation_time_metric actm_stddev_in_ortho int 10 0
average_curation_time_metric actm_stddev_in_pheno int 10 0
average_curation_time_metric actm_stddev_in_xpat int 10 0
average_curation_time_metric actm_stddev_time_in_curating_status int 10 0
average_curation_time_metric actm_stdev_time_waiting_for_author int 10 0
average_curation_time_metric actm_stdev_time_waiting_for_curator_review int 10 0
average_curation_time_metric actm_stdev_time_waiting_for_nomenclature int 10 0
average_curation_time_metric actm_stdev_time_waiting_for_ontology int 10 0
average_curation_time_metric actm_stdev_time_waiting_for_software_fix int 10 0
average_time_per_person actpp_average_time_spent_days int 10 0
average_time_per_person actpp_curation_type varchar 20
average_time_per_person actpp_date_captured datetime year to second 19 current
average_time_per_person actpp_person_zdb_id varchar 50
average_time_per_person actpp_pk_id serial8 19  √ 
company address lvarchar 450  √  null
lab address lvarchar 450  √  null
person address lvarchar 450  √  null
affected_gene_group afg_geno_name varchar 255  √  null
affected_gene_group afg_geno_zdb_id varchar 50  √  null
affected_gene_group afg_genox_zdb_id varchar 50  √  null
affected_gene_group afg_group_name lvarchar 1500  √  null
affected_gene_group afg_group_order lvarchar 3000  √  null
affected_gene_group afg_group_pk_id serial8 19  √ 
affected_gene_group_member afgm_group_id int8 19
affected_gene_group_member afgm_member_id varchar 50
affected_gene_group_member afgm_member_name varchar 50  √  null
affected_gene_group_member afgm_pk_id serial8 19  √ 
alias_group aliasgrp_definition lvarchar 2048  √  null
alias_group aliasgrp_name varchar 30
alias_group aliasgrp_pk_id serial8 19  √ 
alias_group aliasgrp_significance int 10
alias_scope aliasscope_pk_id serial8 19  √ 
alias_scope aliasscope_scope varchar 30
all_alias_tokens aliastok_dalias_zdb_id varchar 50
all_alias_tokens aliastok_token_lower varchar 255
all_anatomy_contains allanatcon_contained_zdb_id varchar 50
all_anatomy_contains allanatcon_container_zdb_id varchar 50
all_anatomy_contains allanatcon_min_contain_distance int 10
all_map_names allmapnm_name varchar 255
all_map_names allmapnm_name_lower varchar 255
all_map_names allmapnm_precedence varchar 80
all_map_names allmapnm_serial_id serial8 19  √ 
all_map_names allmapnm_significance int 10
all_map_names allmapnm_zdb_id varchar 50
all_name_ends allnmend_allmapnm_serial_id int8 19
all_name_ends allnmend_name_end_lower varchar 255
all_term_contains alltermcon_contained_zdb_id varchar 50
all_term_contains_new alltermcon_contained_zdb_id varchar 50  √  null
all_term_contains alltermcon_container_zdb_id varchar 50
all_term_contains_new alltermcon_container_zdb_id varchar 50  √  null
all_term_contains alltermcon_min_contain_distance int 10
all_term_contains_new alltermcon_min_contain_distance int 10
sysbldobjects alter_can_fail boolean 1  √  f
sysbldobjects alter_sql lvarchar 2048  √  null
anatomy_display anatdisp_indent int 10
anatomy_display anatdisp_item_name varchar 80
anatomy_display anatdisp_item_zdb_id varchar 50
anatomy_display anatdisp_seq_num int 10
anatomy_display anatdisp_stg_zdb_id varchar 50
anatomy_stats anatstat_contains_object_count int 10
anatomy_stats anatstat_object_count int 10
anatomy_stats anatstat_object_type varchar 32
anatomy_stats anatstat_synonym_count int 10
anatomy_stats anatstat_term_zdb_id varchar 50  √  null
anatomy_stats anatstat_total_distinct_count int 10
primer_set anneal_temp smallfloat 7  √  null
tmp_zeco_tt aotermid varchar 50  √  null
apato_tag apatotag_name varchar 25
apato_infrastructure api_curator_zdb_id varchar 50
apato_infrastructure api_date datetime year to day 10 current
apato_infrastructure api_entity_1_subterm_zdb_id varchar 50  √  null
apato_infrastructure api_entity_1_superterm_zdb_id varchar 50
apato_infrastructure api_entity_2_subterm_zdb_id varchar 50  √  null
apato_infrastructure api_entity_2_superterm_zdb_id varchar 50  √  null
apato_infrastructure api_pub_zdb_id varchar 50
apato_infrastructure api_quality_zdb_id varchar 50
apato_infrastructure api_tag varchar 25
apato_infrastructure api_zdb_id varchar 50
annual_stats as_count int 10
annual_stats as_date datetime year to second 19
annual_stats as_pk_id serial8 19  √ 
annual_stats as_section varchar 255
annual_stats as_type varchar 255
antibody atb_host_organism varchar 30  √  null
antibody atb_hviso_name varchar 20  √  null
antibody atb_immun_organism varchar 30  √  null
antibody atb_ltiso_name varchar 10  √  null
antibody atb_type varchar 20  √  null
antibody atb_zdb_id varchar 50
antibody_type atbtype_name varchar 20
attribution_type attype_definition varchar 255  √  null
attribution_type attype_type varchar 60
databasechangelog author varchar 255
staging_webpages author varchar 40  √  null
webpages author varchar 40  √  null
author author_first_name varchar 100  √  null
author author_institution lvarchar 255  √  null
author author_last_name varchar 100  √  null
author author_pk_id serial8 19  √ 
author_publication authorpub_author_id int8 19
author_publication authorpub_pk_id serial8 19  √ 
author_publication authorpub_pub_zdb_id varchar 50
publication authors lvarchar 3000
tmp_betterfishdump badfishid varchar 50  √  null
tmp_betterfishdump badfishname varchar 255  √  null
primer_set band_size varchar 80  √  null
blastdb_order bdborder_child_blastdb_zdb_id varchar 50
blastdb_order bdborder_order int 10
blastdb_order bdborder_parent_blastdb_zdb_id varchar 50  √  null
blastdb_order bdborder_pk_id serial8 19  √ 
blast_database_type bdbt_type varchar 10
blast_database_origination_type bdot_definition lvarchar 2048
blast_database_origination_type bdot_pk_id serial8 19  √ 
blast_database_origination_type bdot_type varchar 30
tmp_betterfishdump betterfishid varchar 50  √  null
tmp_betterfishdump betterfishname varchar 255  √  null
blast_hit bhit_alignment lvarchar 30000  √  null
blast_hit bhit_bqry_zdb_id varchar 50
blast_hit bhit_expect_value float 17
blast_hit bhit_hit_number int 10
blast_hit bhit_identities_denominator int 10  √  null
blast_hit bhit_identities_numerator int 10  √  null
blast_hit bhit_positives_denominator int 10
blast_hit bhit_positives_numerator int 10
blast_hit bhit_probability float 17  √  null
blast_hit bhit_score int 10
blast_hit bhit_strand varchar 30  √  null
blast_hit bhit_target_accbk_pk_id int8 19
blast_hit bhit_zdb_id varchar 50
company bio lvarchar 6000  √  null
lab bio lvarchar 6000  √  null
blast_database blastdb_abbrev varchar 30
blast_database blastdb_description lvarchar 2500  √  null
blast_database blastdb_is_being_processed boolean 1 f
blast_database blastdb_last_regenerated datetime year to second 19  √  null
blast_database blastdb_name varchar 100
blast_database blastdb_num_accessions int 10  √  null
blast_database blastdb_num_seqs int 10  √  null
blast_database blastdb_old_num_seqs varchar 30  √  null
blast_database blastdb_origination_id int8 19  √  null
blast_database blastdb_path varchar 255  √  null
blast_database blastdb_public boolean 1 f
blast_database blastdb_tool_display_name varchar 70
blast_database blastdb_tool_display_order int 10  √  null
blast_database blastdb_type varchar 10
blast_database blastdb_zdb_id varchar 50
blastdb_run blastdbr_blastdb_zdb_id varchar 50
blastdb_run blastdbr_run_zdb_id varchar 50
bld_registered bld_id char 64
bldi_provided bld_id char 64
bldi_required bld_id char 64
sysblderrorlog bld_id char 64  √  null
sysbldiprovided bld_id char 64
sysbldirequired bld_id char 64
sysbldobjdepends bld_id char 64
sysbldobjects bld_id char 64
sysbldregistered bld_id char 64
bldi_provided bldi_id char 64
bldi_required bldi_id char 64
sysbldiprovided bldi_id char 64
sysbldirequired bldi_id char 64
bl_plate_tracking blpt_load_number varchar 10
bl_plate_tracking blpt_pk_id serial8 19  √ 
bl_plate_tracking blpt_plate varchar 40  √  null
blast_query bqry_accbk_pk_id int8 19
blast_query bqry_runcan_zdb_id varchar 50
blast_query bqry_zdb_id varchar 50
blastdb_regen_content brc_acc_num varchar 30
blastdb_regen_content brc_blastdb_zdb_id varchar 50
blastdb_regen_content brc_pk_id serial8 19  √ 
blast_report brpt_bqry_zdb_id varchar 50
blast_report brpt_detail_header lvarchar 2500  √  null
blast_report brpt_exitcode int 10
blast_report brpt_zdb_id varchar 50
construct_component cc_cassette_number int 10 1
construct_component cc_component varchar 30
construct_component cc_component_category varchar 60  √  null
construct_component cc_component_type varchar 60  √  null
construct_component cc_component_zdb_id varchar 50  √  null
construct_component cc_construct_zdb_id varchar 50
construct_component cc_order int 10
construct_component cc_pk_id serial8 19  √ 
construct_component_search ccs_coding_all_names lvarchar 15000  √  null
construct_component_search_backup ccs_coding_all_names lvarchar 15000  √  null
construct_component_search_temp ccs_coding_all_names lvarchar 15000  √  null
construct_component_search ccs_cons_id int8 19
construct_component_search_backup ccs_cons_id int8 19
construct_component_search_temp ccs_cons_id int8 19
construct_component_search ccs_engineered_region_all_names lvarchar 2048  √  null
construct_component_search_backup ccs_engineered_region_all_names lvarchar 2048  √  null
construct_component_search_temp ccs_engineered_region_all_names lvarchar 2048  √  null
construct_component_search ccs_gene_abbrev varchar 255  √  null
construct_component_search_backup ccs_gene_abbrev varchar 255  √  null
construct_component_search_temp ccs_gene_abbrev varchar 255  √  null
construct_component_search ccs_gene_abbrev_order varchar 255  √  null
construct_component_search_backup ccs_gene_abbrev_order varchar 255  √  null
construct_component_search_temp ccs_gene_abbrev_order varchar 255  √  null
construct_component_search ccs_gene_zdb_id varchar 50  √  null
construct_component_search_backup ccs_gene_zdb_id varchar 50  √  null
construct_component_search_temp ccs_gene_zdb_id varchar 50  √  null
construct_component_search ccs_pk_id serial8 19  √ 
construct_component_search_backup ccs_pk_id serial8 19  √ 
construct_component_search_temp ccs_pk_id serial8 19  √ 
construct_component_search ccs_promoter_all_names lvarchar 15000  √  null
construct_component_search_backup ccs_promoter_all_names lvarchar 15000  √  null
construct_component_search_temp ccs_promoter_all_names lvarchar 15000  √  null
construct_component_search ccs_relationship_type varchar 40  √  null
construct_component_search_backup ccs_relationship_type varchar 40  √  null
construct_component_search_temp ccs_relationship_type varchar 40  √  null
tmp_zeco_tt cctermid varchar 50  √  null
condition_data_type cdt_group varchar 100
condition_data_type cdt_name varchar 100
condition_data_type cdt_significance int 10
condition_data_type cdt_zdb_id varchar 50
tmp_zeco_tt cdtid varchar 50  √  null
clean_expression_fast_search cefs_genox_zdb_id varchar 50
clean_expression_fast_search cefs_mrkr_zdb_id varchar 50
clean_expression_fast_search cefs_pk_id serial8 19  √ 
construct_group cg_geno_name varchar 255  √  null
construct_group cg_geno_zdb_id varchar 50  √  null
construct_group cg_genox_zdb_id varchar 50  √  null
construct_group cg_group_name lvarchar 500  √  null
construct_group cg_group_order lvarchar 2000  √  null
construct_group cg_group_pk_id serial8 19  √ 
construct_gene_feature_result_view cgfrv_allele_gene_abbrev varchar 255  √  null
construct_gene_feature_result_view_backup cgfrv_allele_gene_abbrev varchar 255  √  null
construct_gene_feature_result_view_temp cgfrv_allele_gene_abbrev varchar 255  √  null
construct_gene_feature_result_view cgfrv_allele_gene_all_names lvarchar 15000  √  null
construct_gene_feature_result_view_backup cgfrv_allele_gene_all_names lvarchar 15000  √  null
construct_gene_feature_result_view_temp cgfrv_allele_gene_all_names lvarchar 15000  √  null
construct_gene_feature_result_view cgfrv_allele_gene_order varchar 255  √  null
construct_gene_feature_result_view_backup cgfrv_allele_gene_order varchar 255  √  null
construct_gene_feature_result_view_temp cgfrv_allele_gene_order varchar 255  √  null
construct_gene_feature_result_view cgfrv_allele_gene_zdb_id varchar 50  √  null
construct_gene_feature_result_view_backup cgfrv_allele_gene_zdb_id varchar 50  √  null
construct_gene_feature_result_view_temp cgfrv_allele_gene_zdb_id varchar 50  √  null
construct_gene_feature_result_view cgfrv_available varchar 50  √  null
construct_gene_feature_result_view_backup cgfrv_available varchar 50  √  null
construct_gene_feature_result_view_temp cgfrv_available varchar 50  √  null
construct_gene_feature_result_view cgfrv_cs_id int8 19
construct_gene_feature_result_view_backup cgfrv_cs_id int8 19
construct_gene_feature_result_view_temp cgfrv_cs_id int8 19
construct_gene_feature_result_view cgfrv_feature_abbrev varchar 50  √  null
construct_gene_feature_result_view_backup cgfrv_feature_abbrev varchar 50  √  null
construct_gene_feature_result_view_temp cgfrv_feature_abbrev varchar 50  √  null
construct_gene_feature_result_view cgfrv_feature_name varchar 255  √  null
construct_gene_feature_result_view_backup cgfrv_feature_name varchar 255  √  null
construct_gene_feature_result_view_temp cgfrv_feature_name varchar 255  √  null
construct_gene_feature_result_view cgfrv_feature_order varchar 255  √  null
construct_gene_feature_result_view_backup cgfrv_feature_order varchar 255  √  null
construct_gene_feature_result_view_temp cgfrv_feature_order varchar 255  √  null
construct_gene_feature_result_view cgfrv_feature_zdb_id varchar 50  √  null
construct_gene_feature_result_view_backup cgfrv_feature_zdb_id varchar 50  √  null
construct_gene_feature_result_view_temp cgfrv_feature_zdb_id varchar 50  √  null
construct_gene_feature_result_view cgfrv_lab_name varchar 255  √  null
construct_gene_feature_result_view_backup cgfrv_lab_name varchar 255  √  null
construct_gene_feature_result_view_temp cgfrv_lab_name varchar 255  √  null
construct_gene_feature_result_view cgfrv_lab_of_origin varchar 50  √  null
construct_gene_feature_result_view_backup cgfrv_lab_of_origin varchar 50  √  null
construct_gene_feature_result_view_temp cgfrv_lab_of_origin varchar 50  √  null
construct_gene_feature_result_view cgfrv_pk_id serial8 19  √ 
construct_gene_feature_result_view_backup cgfrv_pk_id serial8 19  √ 
construct_gene_feature_result_view_temp cgfrv_pk_id serial8 19  √ 
tmp_zeco_tt chebitermid varchar 50  √  null
chromosome chrom_name varchar 2
chromosome chrom_order int 10
webtags class varchar 40  √  null
webudrs class varchar 40  √  null
clone clone_cloning_site varchar 80  √  null
clone clone_comments lvarchar 2048  √  null
clone clone_digest varchar 20  √  null
clone clone_insert_size int 10  √  null
clone clone_mrkr_zdb_id varchar 50
clone clone_pcr_amplification lvarchar 2048  √  null
clone clone_polymerase_name varchar 80  √  null
clone clone_probelib_zdb_id varchar 50
clone clone_problem_type varchar 60  √  null
clone clone_rating int 10  √  null
clone clone_sequence_type varchar 20 unspecified
clone clone_vector_name varchar 80  √  null
sysindexes clust float 17  √  null
sysindexes clustered char 1  √  null
candidate cnd_is_problem boolean 1 f
candidate cnd_last_done_date datetime year to day 10  √  null
candidate cnd_mrkr_type varchar 10
candidate cnd_note lvarchar 1500  √  null
candidate cnd_run_count int 10 0
candidate cnd_suggested_name varchar 255  √  null
candidate cnd_zdb_id varchar 50
databasechangelog comments varchar 255  √  null
mapped_marker comments varchar 100  √  null
primer_set comments lvarchar 2048  √  null
updates comments lvarchar 2048  √  null
company_position compos_order int 10
company_position compos_pk_id serial8 19  √ 
company_position compos_position varchar 25
condition condition_group varchar 100
webconfigs config_name varchar 80
construct_marker_relationship conmrkrrel_construct_zdb_id varchar 50
construct_marker_relationship conmrkrrel_mrkr_zdb_id varchar 50
construct_marker_relationship conmrkrrel_relationship_type varchar 40
construct_marker_relationship conmrkrrel_zdb_id varchar 50
construct_search cons_abbrev varchar 255  √  null
construct_search_backup cons_abbrev varchar 255  √  null
construct_search_temp cons_abbrev varchar 255  √  null
construct_search cons_abbrev_order varchar 255  √  null
construct_search_backup cons_abbrev_order varchar 255  √  null
construct_search_temp cons_abbrev_order varchar 255  √  null
construct_search cons_all_names lvarchar 16000  √  null
construct_search_backup cons_all_names lvarchar 16000  √  null
construct_search_temp cons_all_names lvarchar 16000  √  null
construct_search cons_all_with_spaces lvarchar 10000  √  null
construct_search_backup cons_all_with_spaces lvarchar 10000  √  null
construct_search_temp cons_all_with_spaces lvarchar 10000  √  null
construct_search cons_construct_zdb_id varchar 50
construct_search_backup cons_construct_zdb_id varchar 50
construct_search_temp cons_construct_zdb_id varchar 50
construct_search cons_name varchar 255  √  null
construct_search_backup cons_name varchar 255  √  null
construct_search_temp cons_name varchar 255  √  null
construct_search cons_pk_id serial8 19  √ 
construct_search_backup cons_pk_id serial8 19  √ 
construct_search_temp cons_pk_id serial8 19  √ 
construct_search cons_type varchar 50  √  null
construct_search_backup cons_type varchar 50  √  null
construct_search_temp cons_type varchar 50  √  null
construct_figure consfig_construct_zdb_id varchar 50
construct_figure consfig_fig_zdb_id varchar 50
construct_figure consfig_pk_id serial8 19  √ 
construct construct_comments lvarchar 2048  √  null
construct construct_date_inserted datetime year to second 19 current
construct construct_date_modified datetime year to second 19  √  current
construct construct_name varchar 255
construct construct_owner_zdb_id varchar 50
construct construct_type varchar 10
construct construct_zdb_id varchar 50
company contact_person varchar 50  √  null
lab contact_person varchar 50  √  null
webtags content html 8192
databasechangelog contexts varchar 255  √  null
zdb_submitters cookie varchar 30
company country varchar 10  √  null
lab country varchar 10  √  null
clone_problem_type cpt_type varchar 60
sysbldobjects create_can_fail boolean 1  √  f
zdb_submitters create_date date 10  √  null
sysbldobjects create_order serial8 19  √ 
sysbldobjects create_sql sysbldsqltext 24000  √  null
curator_session cs_data_zdb_id varchar 50  √  null
curator_session cs_field_name varchar 100
curator_session cs_field_name_value lvarchar 1000
curator_session cs_person_zdb_id varchar 50
curator_session cs_pk_id serial8 19  √ 
country_code ctc_code varchar 3
country_code ctc_comments varchar 255  √  null
country_code ctc_display_order int 10  √  null
country_code ctc_name varchar 60
curation cur_closed_date datetime year to day 10  √  null
curation cur_curator_zdb_id varchar 50
curation cur_data_found boolean 1 f
curation cur_entry_date datetime year to day 10
curation cur_opened_date datetime year to second 19  √  null
curation cur_pub_zdb_id varchar 50
curation cur_topic varchar 40
curation cur_zdb_id varchar 50
curation_topic curtopic_name varchar 40
controlled_vocabulary cv_foreign_species varchar 100  √  null
controlled_vocabulary cv_name_definition varchar 255  √  null
controlled_vocabulary cv_term_name varchar 255
controlled_vocabulary cv_zdb_id varchar 50
data_alias dalias_alias varchar 255
data_alias dalias_alias_lower varchar 255
data_alias dalias_data_zdb_id varchar 50
data_alias dalias_group_id int8 19
data_alias dalias_scope_id int8 19  √  null
data_alias dalias_zdb_id varchar 50
disease_annotation_model damo_dat_zdb_id varchar 50
disease_annotation_model damo_genox_zdb_id varchar 50
disease_annotation_model damo_pk_id serial8 19  √ 
disease_annotation dat_evidence_code varchar 3
disease_annotation dat_source_zdb_id varchar 50
disease_annotation dat_term_zdb_id varchar 50
disease_annotation dat_zdb_id varchar 50
webenvvariables data_type char 1
databasechangelog dateexecuted datetime year to fraction(5) 25
db_link dblink_acc_num varchar 50
db_link dblink_acc_num_display varchar 50
db_link dblink_fdbcont_zdb_id varchar 50
db_link dblink_info varchar 80  √  null
db_link dblink_length int 10  √  null
db_link dblink_linked_recid varchar 50
db_link dblink_zdb_id varchar 50
webenvvariables default_value varchar 255  √  null
database_env_name_matrix denm_db_name char 12
database_env_name_matrix denm_env_file_name char 20
database_env_name_matrix denm_instance varchar 20
database_env_name_matrix denm_pk_id serial8 19  √ 
database_env_name_matrix denm_server char 25 development
databasechangelog deployment_id varchar 10  √  null
databasechangelog description varchar 255  √  null
staging_webpages description varchar 250  √  null
sysbldobjkinds description varchar 32  √  null
webcmimages description varchar 250  √  null
webcmpages description varchar 40
webpages description varchar 250  √  null
webtags description varchar 250  √  null
webudrs description varchar 250  √  null
database_info di_code_version varchar 20 production
database_info di_database_unloaded varchar 50  √  null
database_info di_date_unloaded datetime year to second 19
database_info di_pk_id serial8 19  √ 
daily_indexed_metric dim_date_captured datetime year to second 19 current
daily_indexed_metric dim_number_archived int 10 0
daily_indexed_metric dim_number_closed_no_data int 10 0
daily_indexed_metric dim_number_closed_no_pdf int 10 0
daily_indexed_metric dim_number_expression_bin int 10 0
daily_indexed_metric dim_number_indexed_bin_1 int 10 0
daily_indexed_metric dim_number_indexed_bin_2 int 10 0
daily_indexed_metric dim_number_indexed_bin_3 int 10 0
daily_indexed_metric dim_number_phenotype_bin int 10 0
daily_indexed_metric dim_pk_id serial8 19  √ 
webconfigs disable char 1  √  null
panels disp_order int 10
linkages_copy dist decimal 8,2  √  null
data_note dnote_curator_zdb_id varchar 50
data_note dnote_data_zdb_id varchar 50
data_note dnote_date datetime year to second 19  √  null
data_note dnote_text lvarchar 12000  √  null
data_note dnote_zdb_id varchar 50
doi_attempts doia_num_attempts int 10
doi_attempts doia_pk_id serial8 19  √ 
doi_attempts doia_pub_zdb_id varchar 50
do_oevdispupdate_temp_first dout1_evidence_code char 2  √  null
do_oevdispupdate_temp_first dout1_gene_zdb_id varchar 50  √  null
do_oevdispupdate_temp_first dout1_organism_list varchar 100
do_oevdispupdate_temp_first dout1_pub_zdb_id varchar 50  √  null
do_oevdispupdate_temp_first dout1_session_id int 10  √  null
do_oevdispupdate_temp_second dout2_evidence_code char 2  √  null
do_oevdispupdate_temp_second dout2_gene_zdb_id varchar 50  √  null
do_oevdispupdate_temp_second dout2_oevdisp_zdb_id varchar 50  √  null
do_oevdispupdate_temp_second dout2_organism_list varchar 100  √  null
do_oevdispupdate_temp_second dout2_session_id int 10  √  null
data_reporting dr_data_zdb_id varchar 50
data_reporting dr_pk_id serial8 19  √ 
data_reporting dr_report_generated_date datetime year to second 19
data_reporting dr_report_name varchar 250
sysbldobjects drop_can_fail boolean 1  √  f
sysbldobjects drop_sql lvarchar 2048  √  null
experiment_condition_restricted ecr_cdt_zdb_id varchar 50
experiment_condition_restricted ecr_chebi_term_zdb_id varchar 50  √  null
experiment_condition_restricted ecr_exp_zdb_id varchar 50
experiment_condition_restricted ecr_pk_id serial8 19  √ 
expression_figure_stage efs_end_stg_zdb_id varchar 50
expression_figure_stage efs_fig_zdb_id varchar 50
expression_figure_stage efs_pk_id serial8 19  √ 
expression_figure_stage efs_start_stg_zdb_id varchar 50
expression_figure_stage efs_xpatex_zdb_id varchar 50
entrez_gene eg_acc_num int 10
environment_group eg_genox_zdb_id varchar 50
environment_group eg_group_name lvarchar 380  √  null
environment_group eg_group_pk_id serial8 19  √ 
entrez_gene eg_name varchar 255  √  null
entrez_gene eg_symbol varchar 60  √  null
company email varchar 80  √  null
lab email varchar 80  √  null
person email varchar 150  √  null
ensdar_mapping ensm_ensdarg_id varchar 50
ensdar_mapping ensm_ensdarp_id varchar 50  √  null
ensdar_mapping ensm_ensdart_id varchar 50
ensdarg_ensdarp_mapping ensp_ensdarg_id varchar 50
ensdarg_ensdarp_mapping ensp_ensdarp_id varchar 50
ensdarg_ensdarp_mapping ensp_ensdart_id varchar 50
ensdarg_ensdarp_mapping ensp_length int 10  √  null
mapped_marker entry_date datetime year to fraction(3) 23  √  null
zmap_pub_pan_mark entry_date datetime year to fraction(3) 23
company entry_time datetime year to second 19  √  current
lab entry_time datetime year to second 19  √  current
panels entry_time datetime year to fraction(3) 23
person entry_time datetime year to second 19  √  current
ensdarg_ottdarg_mapping eom_ensdarg_id varchar 30
ensdarg_ottdarg_mapping eom_ottdarg_id varchar 30
entrez_to_protein ep_entrez_acc_num int 10
entrez_to_protein ep_organism_common_name varchar 30
entrez_to_protein ep_pk_id serial8 19  √ 
entrez_to_protein ep_protein_acc_num varchar 50
expression_phenotype_term ept_pk_id serial8 19  √ 
expression_phenotype_term ept_quality_term_zdb_id varchar 50
expression_phenotype_term ept_relational_term varchar 50 expressed_in
expression_phenotype_term ept_tag varchar 25 abnormal
expression_phenotype_term ept_xpatres_id int8 19
expression_phenotype_term_controlled_vocab eptcv_pk_id serial8 19  √ 
expression_phenotype_term_controlled_vocab eptcv_term_zdb_id varchar 50
sysblderrorlog err_expected char 32  √  null
sysblderrorlog err_operation char 32  √  null
sysblderrorlog err_sql_state lvarchar 2048  √  null
sysblderrorlog err_sql_stmt lvarchar 2048  √  null
expression_term_fast_search etfs_created_date datetime year to second 19  √  current
xpatfs_old etfs_created_date datetime year to second 19  √  current
expression_term_fast_search etfs_is_xpatres_term boolean 1  √  f
xpatfs_old etfs_is_xpatres_term boolean 1  √  f
expression_term_fast_search etfs_pk_id serial8 19  √ 
xpatfs_old etfs_pk_id serial8 19  √ 
expression_term_fast_search etfs_term_zdb_id varchar 50  √  null
xpatfs_old etfs_term_zdb_id varchar 50  √  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 int 10
entrez_to_xref ex_xref varchar 30
databasechangelog exectype varchar 10
execweb execweb_executable lvarchar 2048  √  null
execweb execweb_id lvarchar 2048  √  null
fish_genox exp_id varchar 50  √  null
experiment exp_name varchar 255
experiment exp_source_zdb_id varchar 50
experiment exp_zdb_id varchar 50
experiment_condition expcond_ao_term_zdb_id varchar 50  √  null
experiment_condition expcond_cdt_zdb_id varchar 50  √  null
experiment_condition expcond_chebi_term_zdb_id varchar 50  √  null
experiment_condition expcond_exp_zdb_id varchar 50
experiment_condition expcond_go_cc_term_zdb_id varchar 50  √  null
experiment_condition expcond_taxon_term_zdb_id varchar 50  √  null
experiment_condition expcond_zdb_id varchar 50
experiment_condition expcond_zeco_term_zdb_id varchar 50
tmp_zeco_tt expid varchar 50  √  null
external_reference exref_attype_type varchar 60
external_reference exref_data_zdb_id varchar 50
external_reference exref_foreign_db_id int8 19  √  null
external_reference exref_pk_id serial8 19  √ 
external_reference exref_reference varchar 200
external_note extnote_data_zdb_id varchar 50
external_note extnote_note lvarchar 8192
external_note extnote_note_type varchar 30  √  null
external_note extnote_source_zdb_id varchar 50
external_note extnote_zdb_id varchar 50
external_note_type extntype_comment lvarchar 2048  √  null
external_note_type extntype_name varchar 30
tmp_zeco_tt extra varchar 1  √  null
functional_annotation fa_affector_type_group lvarchar 1000  √  null
functional_annotation fa_all lvarchar 4000  √  null
functional_annotation fa_construct_alias lvarchar 3000  √  null
functional_annotation fa_construct_group lvarchar 500  √  null
functional_annotation fa_environment_group lvarchar 380  √  null
functional_annotation fa_environment_group_is_standard_or_control boolean 1  √  f
functional_annotation fa_feature_alias lvarchar 380  √  null
functional_annotation fa_feature_count int 10  √  null
functional_annotation fa_feature_group lvarchar 2500  √  null
functional_annotation fa_feature_group_id int8 19  √  null
functional_annotation fa_feature_order lvarchar 1000  √  null
functional_annotation fa_feature_significance int 10  √  null
functional_annotation fa_fish_parts_count int 10  √  null
functional_annotation fa_fish_significance int 10  √  null
functional_annotation fa_gene_alias lvarchar 1500  √  null
functional_annotation fa_gene_alt_alias lvarchar 1000  √  null
functional_annotation fa_gene_count int 10  √  null
functional_annotation fa_gene_group lvarchar 1500  √  null
functional_annotation fa_gene_order lvarchar 1000  √  null
functional_annotation fa_geno_alias lvarchar 1000  √  null
functional_annotation fa_geno_handle varchar 255
functional_annotation fa_geno_is_wildtype boolean 1  √  null
functional_annotation fa_geno_name varchar 255  √  null
functional_annotation fa_geno_zdb_id varchar 50  √  null
functional_annotation fa_genox_zdb_id varchar 50  √  null
functional_annotation fa_pheno_figure_count int 10  √  null
functional_annotation fa_pheno_figure_group lvarchar 3000  √  null
functional_annotation fa_pheno_term_count int 10  √  null
functional_annotation fa_pheno_term_group lvarchar 4000  √  null
functional_annotation fa_pk_id serial8 19  √ 
functional_annotation fa_str_alias lvarchar 1000  √  null
functional_annotation fa_str_group lvarchar 380  √  null
functional_annotation fa_str_member_count int 10  √  null
functional_annotation fa_str_significance int 10  √  null
functional_annotation fa_total_figure_count int 10  √  null
functional_annotation fa_xfigg_has_images boolean 1  √  f
functional_annotation fa_xpat_figure_group lvarchar 3000  √  null
company fax varchar 50  √  null
lab fax varchar 50  √  null
person fax varchar 100  √  null
fish_components fc_affector_zdb_id varchar 50
fish_components fc_construct_zdb_id varchar 50  √  null
fish_components fc_fish_name varchar 255
fish_components fc_fish_zdb_id varchar 50
fish_components fc_gene_zdb_id varchar 50  √  null
fish_components fc_genotype_zdb_id varchar 50
fish_components fc_pk_id serial8 19  √ 
foreign_db fdb_db_display_name varchar 50  √  null
foreign_db fdb_db_name varchar 50
foreign_db fdb_db_pk_id serial8 19  √ 
foreign_db fdb_db_query varchar 250
foreign_db fdb_db_significance int 10
foreign_db fdb_url_suffix varchar 20  √  null
foreign_db_contains_display_group fdbcdg_definition lvarchar 2048
foreign_db_contains_display_group fdbcdg_name varchar 60
foreign_db_contains_display_group fdbcdg_pk_id serial8 19  √ 
foreign_db_contains_display_group_member fdbcdgm_fdbcont_zdb_id varchar 50
foreign_db_contains_display_group_member fdbcdgm_group_id int8 19
foreign_db_contains_display_group_member fdbcdgm_pk_id serial8 19  √ 
foreign_db_contains fdbcont_fdb_db_id int8 19
foreign_db_contains fdbcont_fdbdt_id int8 19
foreign_db_contains fdbcont_organism_common_name varchar 30
foreign_db_contains fdbcont_primary_blastdb_zdb_id varchar 50  √  null
foreign_db_contains fdbcont_zdb_id varchar 50
foreign_db_data_type fdbdt_data_type varchar 40  √  null
foreign_db_data_type fdbdt_display_order int 10  √  null
foreign_db_data_type fdbdt_pk_id serial8 19  √ 
foreign_db_data_type fdbdt_super_type varchar 50
feature_dna_mutation_detail fdmd_dna_mutation_term_zdb_id varchar 50  √  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 varchar 30  √  null
feature_dna_mutation_detail fdmd_exon_number int8 19  √  null
feature_dna_mutation_detail fdmd_fdbcont_zdb_id varchar 50  √  null
feature_dna_mutation_detail fdmd_feature_zdb_id varchar 50
feature_dna_mutation_detail fdmd_gene_localization_term_zdb_id varchar 50  √  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 varchar 50
feature_assay featassay_feature_zdb_id varchar 50
feature_assay featassay_mutagee varchar 20
feature_assay featassay_mutagen varchar 20
feature_assay featassay_pk_id serial8 19  √ 
feature feature_abbrev varchar 150
feature feature_abbrev_order varchar 255
feature feature_date_entered datetime year to second 19  √  current
feature feature_df_transloc_complex_prefix varchar 60  √  null
feature feature_dominant boolean 1 f
feature feature_known_insertion_site boolean 1 f
feature feature_lab_prefix_id int8 19  √  null
feature feature_line_number varchar 70  √  null
feature feature_name varchar 255
feature feature_name_order varchar 255
feature feature_tg_suffix varchar 5  √  null
feature feature_type varchar 30
feature feature_unrecovered boolean 1 f
feature feature_unspecified boolean 1 f
feature feature_zdb_id varchar 50
feature_group fg_geno_name varchar 255  √  null
feature_group fg_geno_zdb_id varchar 50  √  null
feature_group fg_genox_zdb_id varchar 50  √  null
feature_group fg_group_name lvarchar 2500  √  null
feature_group fg_group_order lvarchar 2000  √  null
feature_group fg_group_pk_id serial8 19  √ 
feature_group fg_type_group varchar 255  √  null
feature_group_member fgm_feature_type varchar 30  √  null
feature_group_member fgm_genotype_id varchar 50  √  null
feature_group_member fgm_group_id int8 19
feature_group_member fgm_member_id varchar 50  √  null
feature_group_member fgm_member_name varchar 50  √  null
feature_group_member fgm_pk_id serial8 19  √ 
feature_group_member fgm_significance int 10  √  null
feature_history fhist_comments lvarchar 2048  √  null
feature_history fhist_dalias_zdb_id varchar 50  √  null
feature_history fhist_date datetime year to second 19
feature_history fhist_event varchar 40
feature_history fhist_ftr_abbrev_on_fhist_date varchar 150
feature_history fhist_ftr_name_on_fhist_date varchar 255
feature_history fhist_ftr_prev_name varchar 255  √  null
feature_history fhist_ftr_zdb_id varchar 50
feature_history fhist_reason varchar 50  √  null
feature_history fhist_zdb_id varchar 50
updates field_name varchar 40  √  null
figure fig_caption lvarchar 10000  √  null
fig_comm fig_comm_name varchar 50  √  null
figure fig_comments lvarchar 256  √  null
figure fig_full_label varchar 255  √  null
figure fig_label varchar 50  √  null
fig_tmp fig_line_name varchar 50  √  null
figure fig_source_zdb_id varchar 50
figure fig_zdb_id varchar 50
fig_comm figcomm lvarchar 10000  √  null
fig_tmp figcomments lvarchar 10000  √  null
fig_tmp figzdbid varchar 50  √  null
databasechangelog filename varchar 255
return_recs fill_field varchar 50  √  null
return_recs fill_table varchar 50  √  null
sysbldobjdepends final_state char 1  √  U
sysbldobjects final_state char 1  √  U
person first_name varchar 100
fish fish_full_name varchar 255  √  null
fish fish_functional_affected_gene_count int8 19
fish fish_genotype_zdb_id varchar 50
fish fish_handle varchar 255
fish_genox fish_id varchar 50  √  null
fish fish_is_wildtype boolean 1 f
fish fish_modified boolean 1  √  f
fish fish_name lvarchar 255
fish fish_name_order varchar 255
fish fish_order int8 19
fish fish_zdb_id varchar 50
fish_str fishstr_fish_zdb_id varchar 50
fish_str fishstr_str_zdb_id varchar 50
int_person_company flag varchar 20  √  null
int_person_lab flag varchar 20  √  null
int_person_pub flag varchar 20  √  null
fest_lib_inst fli_fest char 6
fest_lib_inst fli_inst varchar 80  √  null
fest_lib_inst fli_lib varchar 80  √  null
fest_lib_inst fli_probelib_zdb_id varchar 50  √  null
fishmisfortune fm_affected_gene_count int 10  √  0
fishmisfortune fm_experiment_condition_count int 10  √  0
fishmisfortune fm_feature_count int 10  √  0
fishmisfortune fm_fish_display_name varchar 255  √  null
fishmisfortune fm_fish_zdb_id varchar 50  √  null
fishmisfortune fm_genox_zdb_id varchar 50  √  null
fishmisfortune fm_misfortune_count int 10  √  0
fishmisfortune fm_misfortune_count_minus_one int 10  √  0
fishmisfortune fm_pub_zdb_id varchar 50  √  null
fishmisfortune fm_str_count int 10  √  0
feature_marker_relationship fmrel_ftr_zdb_id varchar 50
feature_marker_relationship fmrel_mrkr_zdb_id varchar 50
feature_marker_relationship fmrel_type varchar 60
feature_marker_relationship fmrel_zdb_id varchar 50
feature_marker_relationship_type fmreltype_1_to_2_comments varchar 255  √  null
feature_marker_relationship_type fmreltype_2_to_1_comments varchar 255  √  null
feature_marker_relationship_type fmreltype_ftr_type_group varchar 30
feature_marker_relationship_type fmreltype_mrkr_type_group varchar 60
feature_marker_relationship_type fmreltype_name varchar 60
feature_marker_relationship_type fmreltype_produces_affected_marker boolean 1 f
sysbldobjkinds format varchar 64  √  null
feature_prefix fp_date_entered datetime year to second 19 current
feature_prefix fp_institute_display varchar 255
feature_prefix fp_pk_id serial8 19  √ 
feature_prefix fp_prefix varchar 3
feature_protein_mutation_detail fpmd_fdbcont_zdb_id varchar 50  √  null
feature_protein_mutation_detail fpmd_feature_zdb_id varchar 50
feature_protein_mutation_detail fpmd_mutant_or_stop_protein_term_zdb_id varchar 50  √  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 varchar 50  √  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 varchar 30  √  null
feature_protein_mutation_detail fpmd_wt_protein_term_zdb_id varchar 50  √  null
feature_protein_mutation_detail fpmd_zdb_id varchar 50
mapped_marker framework_t boolean 1  √  null
feature_stats fstat_feat_zdb_id varchar 50
feature_stats_old fstat_feat_zdb_id varchar 50
feature_stats fstat_fig_zdb_id varchar 50
feature_stats_old fstat_fig_zdb_id varchar 50
feature_stats fstat_gene_zdb_id varchar 50  √  null
feature_stats_old fstat_gene_zdb_id varchar 50  √  null
feature_stats fstat_img_zdb_id varchar 50  √  null
feature_stats_old fstat_img_zdb_id varchar 50  √  null
feature_stats fstat_pk_id serial8 19  √ 
feature_stats_old fstat_pk_id serial8 19  √ 
feature_stats fstat_pub_zdb_id varchar 50
feature_stats_old fstat_pub_zdb_id varchar 50
feature_stats fstat_subterm_zdb_id varchar 50
feature_stats_old fstat_subterm_zdb_id varchar 50
feature_stats fstat_superterm_zdb_id varchar 50
feature_stats_old fstat_superterm_zdb_id varchar 50
feature_stats fstat_type varchar 20  √  null
feature_stats_old fstat_type varchar 20  √  null
feature_stats fstat_xpatres_zdb_id int8 19
feature_stats_old fstat_xpatres_zdb_id int8 19
feature_tracking ft_date_entered datetime year to second 19 current
feature_tracking ft_feature_abbrev varchar 70
feature_tracking ft_feature_name varchar 255
feature_tracking ft_feature_zdb_id varchar 50
feature_tracking ft_pk_id serial8 19  √ 
figure_term_construct_search ftcs_cs_id int8 19
figure_term_construct_search_backup ftcs_cs_id int8 19
figure_term_construct_search_temp ftcs_cs_id int8 19
figure_term_construct_search ftcs_fig_zdb_id varchar 50
figure_term_construct_search_backup ftcs_fig_zdb_id varchar 50
figure_term_construct_search_temp ftcs_fig_zdb_id varchar 50
figure_term_construct_search ftcs_geno_handle varchar 255  √  null
figure_term_construct_search_backup ftcs_geno_handle varchar 255  √  null
figure_term_construct_search_temp ftcs_geno_handle varchar 255  √  null
figure_term_construct_search ftcs_geno_name varchar 255  √  null
figure_term_construct_search_backup ftcs_geno_name varchar 255  √  null
figure_term_construct_search_temp ftcs_geno_name varchar 255  √  null
figure_term_construct_search ftcs_genox_zdb_id varchar 50  √  null
figure_term_construct_search_backup ftcs_genox_zdb_id varchar 50  √  null
figure_term_construct_search_temp ftcs_genox_zdb_id varchar 50  √  null
figure_term_construct_search ftcs_has_images boolean 1 f
figure_term_construct_search_backup ftcs_has_images boolean 1 f
figure_term_construct_search_temp ftcs_has_images boolean 1 f
figure_term_construct_search ftcs_pk_id serial8 19  √ 
figure_term_construct_search_backup ftcs_pk_id serial8 19  √ 
figure_term_construct_search_temp ftcs_pk_id serial8 19  √ 
figure_term_construct_search ftcs_term_group lvarchar 3000  √  null
figure_term_construct_search_backup ftcs_term_group lvarchar 3000  √  null
figure_term_construct_search_temp ftcs_term_group lvarchar 3000  √  null
feature_transcript_mutation_detail ftmd_exon_number int8 19  √  null
feature_transcript_mutation_detail ftmd_feature_zdb_id varchar 50
feature_transcript_mutation_detail ftmd_intron_number int8 19  √  null
feature_transcript_mutation_detail ftmd_transcript_consequence_term_zdb_id varchar 50
feature_transcript_mutation_detail ftmd_zdb_id varchar 50
feature_type_mutagen_group_member ftmgm_feature_type varchar 30
feature_type_mutagen_group_member ftmgm_mutagen varchar 20
feature_type_mutagen_group_member ftmgm_pk_id serial8 19  √ 
feature_type_ordering fto_name varchar 60
feature_type_ordering fto_pk_id serial8 19  √ 
feature_type_ordering fto_priority int 10 0
feature_type_group ftrgrp_comments lvarchar 2048
feature_type_group ftrgrp_name varchar 30
feature_type_group_member ftrgrpmem_ftr_type varchar 30
feature_type_group_member ftrgrpmem_ftr_type_group varchar 30
feature_type ftrtype_name varchar 30
feature_type ftrtype_significance int 10  √  null
feature_type ftrtype_type_display varchar 40  √  null
person full_name varchar 150
primer_set fwd_primer lvarchar 2048  √  null
genotype_component_significance gcs_fmrel_type varchar 60
genotype_component_significance gcs_ftr_type varchar 30
genotype_component_significance gcs_mrkr_type varchar 10
genotype_component_significance gcs_pk_id serial8 19  √ 
genotype_component_significance gcs_significance int 10
genotype geno_complexity_order int 10 999999999
genotype geno_date_entered datetime year to second 19  √  current
genotype geno_display_name varchar 255
genotype geno_handle varchar 255
genotype geno_is_extinct boolean 1  √  f
genotype geno_is_wildtype boolean 1  √  f
genotype geno_name_order varchar 255  √  null
genotype geno_nickname varchar 255  √  null
genotype geno_supplier_stock_number varchar 100  √  null
genotype geno_zdb_id varchar 50
genotype_background genoback_background_zdb_id varchar 50
genotype_background genoback_geno_zdb_id varchar 50
genotype_feature genofeat_dad_zygocity varchar 50  √  null
genotype_feature genofeat_feature_zdb_id varchar 50
genotype_feature genofeat_geno_zdb_id varchar 50
genotype_feature genofeat_mom_zygocity varchar 50  √  null
genotype_feature genofeat_zdb_id varchar 50
genotype_feature genofeat_zygocity varchar 50
fish_experiment genox_exp_zdb_id varchar 50
fish_experiment genox_fish_zdb_id varchar 50
fish_genox genox_id varchar 50  √  null
fish_experiment genox_is_standard boolean 1  √  f
fish_experiment genox_is_std_or_generic_control boolean 1  √  f
fish_experiment genox_zdb_id varchar 50
tmp_genox genox_zdb_id varchar 50  √  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 varchar 50
genox_fish_annotation_search_bkup genoxfas_genox_zdb_id varchar 50
genox_fish_annotation_search_temp genoxfas_genox_zdb_id varchar 50
genox_fish_annotation_search genoxfas_pk_id serial8 19  √ 
genox_fish_annotation_search_bkup genoxfas_pk_id serial8 19  √ 
genox_fish_annotation_search_temp genoxfas_pk_id serial8 19  √ 
genedom_family_name gfam_name varchar 255
genedom_family_member gfammem_gfam_name varchar 255
genedom_family_member gfammem_mrkr_zdb_id varchar 50
gff3 gff_biotype varchar 55  √  null
gff3 gff_end int 10  √  null
gff3 gff_feature varchar 45  √  null
gff3 gff_frame char 1  √  null
gff3 gff_id varchar 45
gff3 gff_name varchar 45  √  null
gff3 gff_parent varchar 45  √  null
gff3 gff_score varchar 5  √  null
gff3 gff_seqname varchar 25  √  null
gff3 gff_source varchar 45  √  null
gff3 gff_start int 10  √  null
gff3 gff_strand char 1  √  null
genotype_figure_fast_search gffs_date_created datetime year to second 19 current
genotype_figure_fast_search gffs_fig_zdb_id varchar 50
genotype_figure_fast_search gffs_fish_zdb_id varchar 50
genotype_figure_fast_search gffs_geno_zdb_id varchar 50
genotype_figure_fast_search gffs_genox_zdb_id varchar 50  √  null
genotype_figure_fast_search gffs_morph_zdb_id varchar 50  √  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 serial8 19  √ 
go_flag gflag_display_order int 10
go_flag gflag_name varchar 50
genotype_group gg_geno_handle varchar 255  √  null
genotype_group gg_geno_name varchar 255  √  null
genox_group gg_genotype_zdb_id varchar 50  √  null
genotype_group gg_group_name lvarchar 500  √  null
genox_group gg_group_name lvarchar 380  √  null
genotype_group gg_group_pk_id serial8 19  √ 
genox_group gg_group_pk_id serial8 19  √ 
genox_group_member ggm_genotype_id varchar 50  √  null
genotype_group_member ggm_group_id int8 19
genox_group_member ggm_group_id int8 19
genotype_group_member ggm_member_id varchar 50
genox_group_member ggm_member_id varchar 50
genotype_group_member ggm_member_name varchar 50  √  null
genotype_group_member ggm_pk_id serial8 19  √ 
genox_group_member ggm_pk_id serial8 19  √ 
genotype_group_member ggm_significance int 10  √  null
go_evidence_code goev_code varchar 3
go_evidence_code goev_display_order int 10
go_evidence_code goev_name varchar 100
go_ontology gont_ontology_internal_name varchar 50  √  null
go_ontology gont_ontology_name varchar 30
go_ontology gont_order int 10
go_term goterm_go_id varchar 10
go_term goterm_is_obsolete boolean 1 f
go_term goterm_is_secondary boolean 1 f
go_term goterm_name varchar 255
go_term goterm_ontology varchar 30  √  null
go_term goterm_zdb_id varchar 50
geneprefix_institution gpi_institution varchar 80
geneprefix_institution gpi_prefix varchar 5  √  null
webcmimages height int 10  √  null
heavy_chain_isotype hviso_name varchar 20
databasechangelog id varchar 255
databasechangeloglock id int 10
staging_webpages id varchar 40
sysdomains id serial 10
webcmimages id varchar 40
webcmpages id varchar 40
webpages id varchar 40
webtags id varchar 40
webudrs id varchar 40
int_data_source ids_data_zdb_id varchar 50
int_data_source ids_pk_id serial8 19  √ 
int_data_source ids_source_zdb_id varchar 50
int_data_supplier idsup_acc_num varchar 50  √  null
int_data_supplier idsup_avail_state varchar 30  √  null
int_data_supplier idsup_data_zdb_id varchar 50
int_data_supplier idsup_supplier_zdb_id varchar 50
sysindexes idxname varchar 128  √  null
sysindexes idxtype char 1  √  null
int_fdbcont_analysis_tool ifat_blastdb_zdb_id varchar 50
int_fdbcont_analysis_tool ifat_fdbcont_zdb_id varchar 50
int_image_term iit_img_zdb_id varchar 50
int_image_term iit_term_zdb_id varchar 50
company image varchar 150  √  null
lab image varchar 150  √  null
person image varchar 150  √  null
image img_annotation lvarchar 2048  √  null
image img_comments lvarchar 2048  √  null
image img_direction varchar 30
image img_external_name varchar 100  √  null
image img_fig_zdb_id varchar 50  √  null
image img_form varchar 15
image img_height int 10
image img_image varchar 150
image img_image_with_annotation varchar 150  √  null
image img_is_video_still boolean 1 f
image img_label varchar 200  √  null
image img_owner_zdb_id varchar 50
image img_preparation varchar 15
image img_thumbnail varchar 150
image img_view varchar 20
image img_width int 10
image img_zdb_id varchar 50
image_direction imgdir_name varchar 30
image_form imgform_name varchar 15
image_preparation imgprep_name varchar 15
image_stage imgstg_end_stg_zdb_id varchar 50
image_stage imgstg_img_zdb_id varchar 50
image_stage imgstg_start_stg_zdb_id varchar 50
image_view imgview_name varchar 20
inference_group_member infgrmem_inferred_from varchar 80
inference_group_member infgrmem_mrkrgoev_zdb_id varchar 50
vgroupsize infgrmem_mrkrgoev_zdb_id varchar 50  √  null
inference_group_member infgrmem_notes varchar 255  √  null
int_person_pub info varchar 50  √  null
return_recs info varchar 50  √  null
zdb_submitters is_curator boolean 1 f
zdb_submitters issue_time datetime year to fraction(3) 23  √  null
int_vegatype_tscripttype ivtst_tscriptt_type_id int8 19
int_vegatype_tscripttype ivtst_vega_type varchar 60
journal jrnl_abbrev varchar 255  √  null
journal jrnl_abbrev_lower varchar 255
journal jrnl_is_nice boolean 1  √  null
journal jrnl_isoabbrev varchar 255  √  null
journal jrnl_medabbrev varchar 255  √  null
journal jrnl_name varchar 255
journal jrnl_name_lower varchar 255
journal jrnl_nlmid varchar 100  √  null
journal jrnl_online_issn varchar 100  √  null
journal jrnl_print_issn varchar 100  √  null
journal jrnl_publisher varchar 100  √  null
journal jrnl_zdb_id varchar 50
publication jtype varchar 20
return_recs jump_to varchar 30  √  null
publication keywords lvarchar 2200  √  null
mapped_marker lab varchar 50  √  null
databasechangelog labels varchar 255  √  null
lab_position labpos_order int 10
lab_position labpos_pk_id serial8 19  √ 
lab_position labpos_position varchar 25
staging_webpages last_changed datetime year to fraction(3) 23  √  null
webpages last_changed datetime year to fraction(3) 23  √  null
staging_webpages last_changed_by varchar 40  √  null
webpages last_changed_by varchar 40  √  null
person last_name varchar 100
lab_address_update_tracking laut_lab_zdb_id varchar 50
lab_address_update_tracking laut_new_address lvarchar 450
lab_address_update_tracking laut_pk_id serial8 19  √ 
lab_address_update_tracking laut_previous_address lvarchar 450
longest_bin_resident_metric lbrm_date_captured datetime year to second 19 current
longest_bin_resident_metric lbrm_days_in_status_on_this_date int 10
longest_bin_resident_metric lbrm_pk_id serial8 19  √ 
longest_bin_resident_metric lbrm_pub_zdb_id varchar 50
longest_bin_resident_metric lbrm_status_counted varchar 20
sysindexes leaves float 17  √  null
sysindexes levels smallint 5  √  null
paneled_markers lg_location decimal 8,2  √  null
zmap_pub_pan_mark lg_location decimal 8,2
linkage_group lg_name varchar 2
linkage_group lg_order int 10  √  null
lines line_name varchar 50  √  null
lines_tmp line_name varchar 50  √  null
linkage_member_temp linkage_zdb_id varchar 50  √  null
databasechangelog liquibase varchar 20  √  null
linkage_membership_search lms_distance decimal 8,2  √  null
linkage_membership_search_bkup lms_distance decimal 8,2  √  null
linkage_membership_search_temp lms_distance decimal 8,2  √  null
linkage_membership_search lms_lnkg_zdb_id varchar 50
linkage_membership_search_bkup lms_lnkg_zdb_id varchar 50
linkage_membership_search_temp lms_lnkg_zdb_id varchar 50
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 decimal 8,2  √  null
linkage_membership_search_bkup lms_lod decimal 8,2  √  null
linkage_membership_search_temp lms_lod decimal 8,2  √  null
linkage_membership_search lms_member_1_zdb_id varchar 50
linkage_membership_search_bkup lms_member_1_zdb_id varchar 50
linkage_membership_search_temp lms_member_1_zdb_id varchar 50
linkage_membership_search lms_member_2_zdb_id varchar 50
linkage_membership_search_bkup lms_member_2_zdb_id varchar 50
linkage_membership_search_temp lms_member_2_zdb_id varchar 50
linkage_membership_search lms_pk_id serial8 19  √ 
linkage_membership_search_bkup lms_pk_id serial8 19  √ 
linkage_membership_search_temp lms_pk_id serial8 19  √ 
linkage_membership_search lms_units varchar 5  √  null
linkage_membership_search_bkup lms_units varchar 5  √  null
linkage_membership_search_temp lms_units varchar 5  √  null
linkage lnkg_chromosome varchar 2
linkage lnkg_comments lvarchar 2048  √  null
linkage_old lnkg_comments lvarchar 2048  √  null
linkage_old lnkg_or_lg varchar 2
linkage lnkg_source_zdb_id varchar 50
linkage lnkg_submitter_zdb_id varchar 50  √  null
linkage_old lnkg_submitter_zdb_id varchar 50  √  null
linkage lnkg_zdb_id varchar 50
linkage_old lnkg_zdb_id varchar 50
linkage_membership lnkgm_distance decimal 8,2  √  null
linkage_membership lnkgm_linkage_zdb_id varchar 50
linkage_membership lnkgm_lod decimal 8,2  √  null
linkage_membership lnkgm_member_1_zdb_id varchar 50
linkage_membership lnkgm_member_2_zdb_id varchar 50
linkage_membership lnkgm_metric varchar 5  √  null
linkage_membership lnkgm_pair_old_id varchar 50  √  null
linkage_membership lnkgm_pk_id serial8 19  √ 
linkage_member lnkgmem_linkage_zdb_id varchar 50
linkage_member lnkgmem_member_zdb_id varchar 50
linkage_pair lnkgpair_distance decimal 8,2  √  null
linkage_pair lnkgpair_linkage_zdb_id varchar 50  √  null
linkage_pair lnkgpair_lod decimal 8,2  √  null
linkage_pair lnkgpair_metric varchar 5  √  null
linkage_pair lnkgpair_zdb_id varchar 50
databasechangeloglock locked boolean 1
databasechangeloglock lockedby varchar 255  √  null
databasechangeloglock lockgranted datetime year to fraction(5) 25  √  null
linkages_copy lod decimal 8,2  √  null
zdb_submitters login varchar 30  √  null
linkage_pair_member lpmem_linkage_pair_zdb_id varchar 50
linkage_pair_member lpmem_linkage_zdb_id varchar 50
linkage_pair_member lpmem_member_zdb_id varchar 50
linkage_single lsingle_lnkg_zdb_id varchar 50
linkage_single lsingle_member_zdb_id varchar 50
linkage_single lsingle_pk_id serial8 19  √ 
light_chain_isotype ltiso_name varchar 10
linkages_copy m1_id varchar 50  √  null
linkages_copy m2_id varchar 50  √  null
monthly_average_curated_metric macm_average_stay_in_bin_1 int 10 0
monthly_average_curated_metric macm_average_stay_in_bin_2 int 10 0
monthly_average_curated_metric macm_average_stay_in_bin_3 int 10 0
monthly_average_curated_metric macm_average_stay_in_ortho_bin int 10 0
monthly_average_curated_metric macm_average_stay_in_pheno_bin int 10 0
monthly_average_curated_metric macm_average_stay_in_xpat_bin int 10 0
monthly_average_curated_metric macm_date_captured datetime year to second 19 current
monthly_average_curated_metric macm_longest_bin1_number_of_days int 10 0
monthly_average_curated_metric macm_longest_bin2_number_of_days int 10 0
monthly_average_curated_metric macm_longest_bin3_number_of_days int 10 0
monthly_average_curated_metric macm_longest_expression_number_of_days int 10 0
monthly_average_curated_metric macm_longest_ortho_number_of_days int 10 0
monthly_average_curated_metric macm_longest_phenotype_number_of_days int 10 0
monthly_average_curated_metric macm_paper_in_bin_1_longest varchar 50  √  null
monthly_average_curated_metric macm_paper_in_bin_2_longest varchar 50  √  null
monthly_average_curated_metric macm_paper_in_bin_3_longest varchar 50  √  null
monthly_average_curated_metric macm_paper_in_expression_bin_longest varchar 50  √  null
monthly_average_curated_metric macm_paper_in_ortho_bin_longest varchar 50  √  null
monthly_average_curated_metric macm_paper_in_phenotype_bin_longest varchar 50  √  null
monthly_average_curated_metric macm_pk_id serial8 19  √ 
mapped_marker map_name varchar 40  √  null
paneled_markers map_name varchar 40  √  null
map_metric mapmetric_code varchar 5
map_metric mapmetric_description lvarchar 2048
map_metric mapmetric_name varchar 20  √  null
panels mappanel_comments lvarchar 15000
panels mappanel_interactive_url varchar 60  √  null
panels mappanel_interactive_url_extra_text varchar 60  √  null
panels mappanel_meiotic_cross_type varchar 20  √  null
panels mappanel_meiotic_num_meioses int 10  √  null
panels mappanel_rh_num_cell_lines int 10  √  null
panels mappanel_rh_rad_dose varchar 60  √  null
linkage_member_temp marker_1_zdb_id varchar 50  √  null
linkage_member_temp marker_2_zdb_id varchar 50  √  null
mapped_marker marker_id varchar 50  √  null
primer_set marker_id varchar 50  √  null
mapped_marker marker_type varchar 10
marker_types marker_type varchar 60
monthly_curated_metric mcm_date_captured datetime year to second 19 current
monthly_curated_metric mcm_number_archived_this_month int 10 0
monthly_curated_metric mcm_number_closed_curated_this_month int 10 0
monthly_curated_metric mcm_number_closed_unread_this_month int 10 0
monthly_curated_metric mcm_number_in_bin_1 int 10 0
monthly_curated_metric mcm_number_in_bin_2 int 10 0
monthly_curated_metric mcm_number_in_bin_3 int 10 0
monthly_curated_metric mcm_number_in_expression_bin int 10 0
monthly_curated_metric mcm_number_in_ortho_bin int 10 0
monthly_curated_metric mcm_number_in_phenotype_bin int 10 0
monthly_curated_metric mcm_pk_id serial8 19  √ 
monthly_curated_metric mcm_pub_arrival_date_month varchar 10
monthly_curated_metric mcm_pub_arrival_date_year varchar 10
databasechangelog md5sum varchar 35  √  null
mutation_detail_controlled_vocabulary mdcv_term_abbreviation varchar 255  √  null
mutation_detail_controlled_vocabulary mdcv_term_display_name varchar 255
mutation_detail_controlled_vocabulary mdcv_term_order int8 19  √  null
mutation_detail_controlled_vocabulary mdcv_term_zdb_id varchar 50
mutation_detail_controlled_vocabulary mdcv_used_in varchar 100
mesh_term mesht_mesh_id varchar 10
mesh_term mesht_term_name varchar 255
mesh_term mesht_type varchar 30
sysbldobjects metadata lvarchar 2048  √  null
mapped_marker metric varchar 5  √  null
paneled_markers metric varchar 5  √  null
panels metric varchar 5
zmap_pub_pan_mark metric varchar 5
mutant_fast_search mfs_genox_zdb_id varchar 50
mutant_fast_search mfs_mrkr_zdb_id varchar 50
paneled_markers mghframework boolean 1  √  null
zmap_pub_pan_mark mghframework boolean 1
mesh_heading mh_descriptor_is_major_topic boolean 1 f
mesh_heading mh_mesht_mesh_descriptor_id varchar 10
mesh_heading mh_pk_id serial8 19  √ 
mesh_heading mh_pub_zdb_id varchar 50
marker_history_audit mha_insert_date datetime year to second 19 current
marker_history_audit mha_mrkr_abbrev_after varchar 100
marker_history_audit mha_mrkr_abbrev_before varchar 100
marker_history_audit mha_mrkr_name_after varchar 255  √  null
marker_history_audit mha_mrkr_name_before varchar 255  √  null
marker_history_audit mha_mrkr_zdb_id varchar 50
marker_history_audit mha_pk_id serial8 19  √ 
marker_history mhist_comments lvarchar 2048  √  null
marker_history mhist_dalias_zdb_id varchar 50  √  null
marker_history mhist_date datetime year to second 19
marker_history mhist_event varchar 40
marker_history mhist_mrkr_abbrev_on_mhist_date varchar 150
marker_history mhist_mrkr_name_on_mhist_date varchar 255
marker_history mhist_mrkr_prev_name varchar 255  √  null
marker_history mhist_mrkr_zdb_id varchar 50
marker_history mhist_reason varchar 50  √  null
marker_history mhist_zdb_id varchar 50
marker_history_reason mhistrsn_name varchar 50
marker_history_event mhistvnt_name varchar 40
mesh_heading_qualifier mhq_is_major_topic boolean 1 f
mesh_heading_qualifier mhq_mesh_heading_id int8 19
mesh_heading_qualifier mhq_mesht_mesh_qualifier_id varchar 10
staging_webpages mime_type varchar 40
webpages mime_type varchar 40
mapped_marker mm_chrom_location decimal 8,2  √  null
mapped_marker mm_chromosome varchar 2
merge_markers_sql mms_mrkr_1_zdb_id varchar 50
merge_markers_sql mms_mrkr_2_zdb_id varchar 50
merge_markers_sql mms_pk_id serial8 19  √ 
merge_markers_sql mms_sql lvarchar 500
zmap_pub_pan_mark mname varchar 80
marker_relationship mrel_comments lvarchar 2048  √  null
marker_relationship mrel_mrkr_1_zdb_id varchar 50
marker_relationship mrel_mrkr_2_zdb_id varchar 50
marker_relationship mrel_type varchar 40
marker_relationship mrel_zdb_id varchar 50
marker_relationship_type mreltype_1_to_2_comments varchar 60
marker_relationship_type mreltype_2_to_1_comments varchar 60
marker_relationship_type mreltype_mrkr_type_group_1 varchar 60
marker_relationship_type mreltype_mrkr_type_group_2 varchar 60
marker_relationship_type mreltype_name varchar 40
marker mrkr_abbrev varchar 150
marker mrkr_abbrev_order varchar 255
marker mrkr_comments lvarchar 1500  √  null
marker mrkr_name varchar 255
marker mrkr_name_order varchar 140
marker mrkr_owner varchar 50
marker mrkr_type varchar 60
marker mrkr_zdb_id varchar 50
vmrkrgoevsamesize mrkrgoev1 varchar 50  √  null
vmrkrgoevsamesize mrkrgoev2 varchar 50  √  null
marker_go_term_evidence mrkrgoev_annotation_organization int8 19
marker_go_term_evidence mrkrgoev_annotation_organization_created_by varchar 80 ZFIN
marker_go_term_evidence mrkrgoev_contributed_by varchar 50  √  null
marker_go_term_evidence mrkrgoev_date_entered datetime year to second 19  √  current
marker_go_term_evidence mrkrgoev_date_modified datetime year to second 19  √  current
marker_go_term_evidence mrkrgoev_evidence_code varchar 3
marker_go_term_evidence mrkrgoev_external_load_date datetime year to second 19  √  null
marker_go_term_evidence mrkrgoev_gflag_name varchar 50  √  null
marker_go_term_evidence mrkrgoev_modified_by varchar 50  √  null
marker_go_term_evidence mrkrgoev_mrkr_zdb_id varchar 50
marker_go_term_evidence mrkrgoev_notes lvarchar 2048  √  null
marker_go_term_evidence mrkrgoev_source_zdb_id varchar 50
marker_go_term_evidence mrkrgoev_term_zdb_id varchar 50
marker_go_term_evidence mrkrgoev_zdb_id varchar 50
marker_go_term_evidence_annotation_organization mrkrgoevas_annotation_organization varchar 30
marker_go_term_evidence_annotation_organization mrkrgoevas_definition varchar 100
marker_go_term_evidence_annotation_organization mrkrgoevas_organization_url varchar 255  √  null
marker_go_term_evidence_annotation_organization mrkrgoevas_pk_id serial8 19  √ 
marker_go_term_evidence_annotation_created_by_source mrkrgoevcb_name varchar 80
marker_go_term_evidence_annotation_created_by_source mrkrgoevcb_pk_id serial8 19  √ 
marker_go_term_evidence_annotation_created_by_source mrkrgoevcb_url varchar 255  √  null
marker_types mrkrtype_significance int 10  √  null
marker_types mrkrtype_type_display varchar 30  √  null
marker_type_group mtgrp_comments lvarchar 2048
marker_type_group mtgrp_display_name varchar 80  √  null
marker_type_group mtgrp_name varchar 60
marker_type_group mtgrp_searchable boolean 1  √  f
marker_type_group_member mtgrpmem_mrkr_type varchar 60
marker_type_group_member mtgrpmem_mrkr_type_group varchar 60
paneled_markers mtype varchar 10  √  null
zmap_pub_pan_mark mtype varchar 10
mutagee mutagee_name varchar 20
mutagen mutagen_name varchar 20
company name varchar 150  √  null
lab name varchar 150
panels name varchar 50
person name varchar 150  √  null
sysdomains name varchar 128  √  null
zdb_submitters name varchar 80  √  null
sysbldobjdepends need_obj_kind int 10  √  0
sysbldobjdepends need_obj_owner char 64  √  informix
sysbldobjdepends need_obj_signature lvarchar 2048
updates new_value lvarchar 2000  √  null
person nicknames varchar 200  √  null
name_precedence nmprec_comments lvarchar 2048
name_precedence nmprec_precedence varchar 80
name_precedence nmprec_significance int 10
ncbi_ortholog_external_reference noer_fdbcont_zdb_id varchar 50
ncbi_ortholog_external_reference noer_other_species_accession_number varchar 50
ncbi_ortholog_external_reference noer_other_species_ncbi_gene_id varchar 40
ncbi_ortholog_external_reference noer_pk_id serial8 19  √ 
ncbi_ortholog noi_chromosome varchar 30  √  null
ncbi_ortholog noi_entry_time datetime year to second 19  √  null
ncbi_ortholog noi_name varchar 255  √  null
ncbi_ortholog noi_ncbi_gene_id varchar 40
ncbi_ortholog noi_symbol varchar 100  √  null
ncbi_ortholog noi_taxid int 10
person nonzf_pubs clob 2147483647  √  null
publication num_auths int 10  √  null
webudrs numargs int 10  √  null
sysindexes nunique float 17  √  null
sysbldobjdepends obj_kind int 10  √  0
sysbldobjects obj_kind int 10  √  0
sysbldobjkinds obj_kind int 10
sysbldobjdepends obj_owner char 64  √  informix
sysbldobjects obj_owner char 64  √  informix
sysbldobjdepends obj_signature lvarchar 2048
sysbldobjects obj_signature lvarchar 2048
staging_webpages object html 8192  √  null
webcmimages object blob 2147483647  √  null
webcmpages object html 8192  √  null
webpages object html 8192  √  null
staging_webpages object_type varchar 40
webpages object_type varchar 40
obsolete_term_replacement obstermrep_pk_id serial8 19  √ 
obsolete_term_replacement obstermrep_term_replacement_zdb_id varchar 50
obsolete_term_replacement obstermrep_term_zdb_id varchar 50
obsolete_term_suggestion obstermsug_pk_id serial8 19  √ 
obsolete_term_suggestion obstermsug_term_suggestion_zdb_id varchar 50
obsolete_term_suggestion obstermsug_term_zdb_id varchar 50
ortholog_external_reference oef_accession_number varchar 40
ortholog_external_reference oef_fdbcont_zdb_id varchar 50
ortholog_external_reference oef_ortho_zdb_id varchar 50
ortholog_evidence oev_evidence_code char 2
ortholog_evidence oev_ortho_zdb_id varchar 50
ortholog_evidence oev_pub_zdb_id varchar 50
ortholog_evidence_code oevcode_code char 2
ortholog_evidence_code oevcode_name varchar 45
ortholog_evidence_code oevcode_order int 10
updates old_value lvarchar 2000  √  null
ortholog_load_tracking olt_last_run datetime year to second 19
ortholog_load_tracking olt_load_name varchar 100
ortholog_load_tracking olt_number_of_flybase_links varchar 50
ortholog_load_tracking olt_number_of_gene_links varchar 50
ortholog_load_tracking olt_number_of_hgnc_links varchar 50
ortholog_load_tracking olt_number_of_mgi_links varchar 50
ortholog_load_tracking olt_number_of_omim_links varchar 50
omim_phenotype omimp_name varchar 200
omim_phenotype omimp_omim_id varchar 10  √  null
omim_phenotype omimp_ortho_zdb_id varchar 50  √  null
omim_phenotype omimp_pk_id serial8 19  √ 
person on_dist_list boolean 1  √  null
ontology ont_current_date varchar 20  √  null
ontology ont_data_version varchar 20  √  null
ontology ont_default_namespace varchar 50  √  null
ontology ont_format_version varchar 20  √  null
ontology ont_import varchar 255  √  null
ontology ont_ontology_name varchar 50  √  null
ontology ont_order int 10
ontology ont_pk_id serial8 19  √ 
ontology ont_remark varchar 255  √  null
ontology ont_saved_by varchar 50  √  null
one_to_one_accession ooa_dblink_acc_num varchar 50
one_to_one_accession ooa_dblink_zdb_id varchar 50
one_to_one_accession ooa_feature_zdb_id varchar 50
one_to_one_accession ooa_pk_id serial8 19  √ 
paneled_markers or_lg varchar 2  √  null
person orcid_id varchar 20  √  null
sysblderrorlog order serial8 19  √ 
databasechangelog orderexecuted int 10
organism organism_common_name varchar 30
organism organism_display_order int 10
organism organism_is_ab_host boolean 1  √  f
organism organism_is_ab_immun boolean 1  √  f
organism organism_species varchar 60
organism organism_taxid int 10
ortholog ortho_other_species_chromosome varchar 50  √  null
ortholog ortho_other_species_name varchar 255  √  null
ortholog ortho_other_species_ncbi_gene_id varchar 40
ortholog ortho_other_species_ncbi_gene_is_obsolete boolean 1 f
ortholog ortho_other_species_symbol varchar 255  √  null
ortholog ortho_other_species_taxid int 10  √  null
ortholog ortho_zdb_id varchar 50
ortholog ortho_zebrafish_gene_zdb_id varchar 50
ontology_subset osubset_ont_id int8 19
ontology_subset osubset_pk_id serial8 19  √ 
ontology_subset osubset_subset_definition lvarchar 2048
ontology_subset osubset_subset_name varchar 100
ontology_subset osubset_subset_type varchar 10  √  null
tmp_zeco_tt othertermid varchar 50  √  null
omimp_termxref_mapping otm_omimp_id int8 19
omimp_termxref_mapping otm_tx_id int8 19
webconfigs overwrite char 1
company owner varchar 50  √  null
lab owner varchar 50  √  null
linkages_copy owner varchar 50  √  null
mapped_marker owner varchar 50  √  null
panels owner varchar 50
person owner varchar 50  √  null
publication owner varchar 50  √  null
sysdomains owner char 32  √  null
sysindexes owner char 32  √  null
missing_xpatfig oxpatfig_fig_zdb_id varchar 50  √  null
missing_xpatfig oxpatfig_xpatres_zdb_id varchar 50  √  null
staging_webpages page_version int 10  √  null
webpages page_version int 10  √  null
zmap_pub_pan_mark panel_abbrev varchar 10  √  null
panels panel_date date 10
zmap_pub_pan_mark panel_id varchar 50
panel_count panelcnt_chromosome varchar 2
panel_count panelcnt_count int 10
panel_count panelcnt_mrkr_type varchar 10
panel_count panelcnt_or_lg varchar 2  √  null
panel_count panelcnt_panel_zdb_id varchar 50
webtags parameters varchar 250  √  null
webudrs parameters varchar 250  √  null
webudrs paramtypes lvarchar 2048  √  null
sysindexes part1 smallint 5  √  null
sysindexes part10 smallint 5  √  null
sysindexes part11 smallint 5  √  null
sysindexes part12 smallint 5  √  null
sysindexes part13 smallint 5  √  null
sysindexes part14 smallint 5  √  null
sysindexes part15 smallint 5  √  null
sysindexes part16 smallint 5  √  null
sysindexes part2 smallint 5  √  null
sysindexes part3 smallint 5  √  null
sysindexes part4 smallint 5  √  null
sysindexes part5 smallint 5  √  null
sysindexes part6 smallint 5  √  null
sysindexes part7 smallint 5  √  null
sysindexes part8 smallint 5  √  null
sysindexes part9 smallint 5  √  null
zdb_submitters password varchar 40  √  null
pub_correspondence_subject pcs_handle varchar 100
pub_correspondence_subject pcs_subject_pk_id serial8 19  √ 
pub_correspondence_subject pcs_subject_text lvarchar 1000
pub_correspondence_subject pcs_subject_type varchar 20
publication_contact_tracking pct_contacted_date datetime year to second 19 current
publication_contact_tracking pct_curator_zdb_id varchar 50
publication_contact_tracking pct_gave_up_date datetime year to second 19  √  null
publication_contact_tracking pct_pk_id serial8 19  √ 
publication_contact_tracking pct_pub_zdb_id varchar 50
publication_contact_tracking pct_responded_date datetime year to second 19  √  null
pub_db_xref pdx_accession_number varchar 70
pub_db_xref pdx_fdbcont_zdb_id varchar 50
pub_db_xref pdx_pk_id serial8 19  √ 
pub_db_xref pdx_pub_zdb_id varchar 50
person pers_bio lvarchar 12000  √  null
person pers_is_deceased boolean 1 f
person_author persauth_author_id int8 19
person_author persauth_connected_by varchar 50
person_author persauth_date_connected_date datetime year to second 19 current
person_author persauth_person_zdb_id varchar 50
person_author persauth_pk_id serial8 19  √ 
person person_country varchar 10  √  null
publication_file pf_date_entered datetime year to second 19 current
publication_file pf_file_name varchar 255
publication_file pf_file_type_id int8 19
publication_file pf_original_file_name varchar 255  √  null
publication_file pf_pk_id serial8 19  √ 
publication_file pf_pub_zdb_id varchar 50
phenotype_figure_group pfigg_geno_handle varchar 255  √  null
phenotype_figure_group pfigg_geno_name varchar 255  √  null
phenotype_figure_group pfigg_genox_zdb_id varchar 50  √  null
phenotype_figure_group pfigg_group_name lvarchar 380  √  null
phenotype_figure_group pfigg_group_pk_id serial8 19  √ 
phenotype_figure_group_member pfiggm_group_id int8 19
phenotype_figure_group_member pfiggm_member_id varchar 50
phenotype_figure_group_member pfiggm_member_name varchar 50  √  null
phenotype_figure_group_member pfiggm_pk_id serial8 19  √ 
publication_file_type pft_pk_id serial8 19  √ 
publication_file_type pft_type varchar 100
publication_file_type pft_type_order int8 19
phenotype_source_generated pg_end_stg_zdb_id varchar 50  √  null
phenotype_source_generated_bkup pg_end_stg_zdb_id varchar 50  √  null
phenotype_source_generated_temp pg_end_stg_zdb_id varchar 50  √  null
phenotype_source_generated pg_fig_zdb_id varchar 50  √  null
phenotype_source_generated_bkup pg_fig_zdb_id varchar 50  √  null
phenotype_source_generated_temp pg_fig_zdb_id varchar 50  √  null
phenotype_source_generated pg_genox_zdb_id varchar 50  √  null
phenotype_source_generated_bkup pg_genox_zdb_id varchar 50  √  null
phenotype_source_generated_temp pg_genox_zdb_id varchar 50  √  null
phenotype_source_generated pg_id int8 19  √  null
phenotype_source_generated_bkup pg_id int8 19  √  null
phenotype_source_generated_temp pg_id serial8 19  √ 
phenotype_source_generated pg_start_stg_zdb_id varchar 50  √  null
phenotype_source_generated_bkup pg_start_stg_zdb_id varchar 50  √  null
phenotype_source_generated_temp pg_start_stg_zdb_id varchar 50  √  null
phenotype_generated_curated_mapping pgcm_id_type varchar 10  √  null
phenotype_generated_curated_mapping_bkup pgcm_id_type varchar 10  √  null
phenotype_generated_curated_mapping_temp pgcm_id_type varchar 10  √  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 varchar 50  √  null
phenotype_generated_curated_mapping_bkup pgcm_source_id varchar 50  √  null
phenotype_generated_curated_mapping_temp pgcm_source_id varchar 50  √  null
phenotype_statement phenos_created_date datetime year to second 19  √  current
phenotype_statement phenos_entity_1_subterm_zdb_id varchar 50  √  null
phenotype_statement phenos_entity_1_superterm_zdb_id varchar 50
phenotype_statement phenos_entity_2_subterm_zdb_id varchar 50  √  null
phenotype_statement phenos_entity_2_superterm_zdb_id varchar 50  √  null
remove_phenos_ids phenos_id serial8 19  √ 
phenotype_statement phenos_last_modified datetime year to second 19  √  current
phenotype_statement phenos_phenox_pk_id int8 19
phenotype_statement phenos_pk_id serial8 19  √ 
phenotype_statement phenos_quality_zdb_id varchar 50
phenotype_statement phenos_tag varchar 25  √  null
phenotype_experiment phenox_created_date datetime year to second 19  √  current
phenotype_experiment phenox_end_stg_zdb_id varchar 50
phenotype_experiment phenox_fig_zdb_id varchar 50
phenotype_experiment phenox_genox_zdb_id varchar 50
phenotype_experiment phenox_last_modified datetime year to second 19  √  current
phenotype_experiment phenox_pk_id serial8 19  √ 
phenotype_experiment phenox_start_stg_zdb_id varchar 50
company phone varchar 100  √  null
lab phone varchar 50  √  null
person phone varchar 100  √  null
probe_lib pl_description lvarchar 2048  √  null
probe_lib pl_develop_stage varchar 160  √  null
probe_lib pl_lab_host varchar 80  √  null
probe_lib pl_lib_name varchar 80  √  null
probe_lib pl_organ varchar 80  √  null
probe_lib pl_organism varchar 40  √  null
probe_lib pl_r_site_1 varchar 40  √  null
probe_lib pl_r_site_2 varchar 40  √  null
probe_lib pl_sex varchar 80  √  null
probe_lib pl_strain varchar 80  √  null
probe_lib pl_tissue_type varchar 80  √  null
probe_lib pl_url varchar 255  √  null
probe_lib pl_vector varchar 40  √  null
probe_lib pl_zdb_id varchar 50  √  null
publication_note pnote_curator_zdb_id varchar 50
publication_note pnote_date datetime year to second 19  √  null
publication_note pnote_pub_zdb_id varchar 50
publication_note pnote_text lvarchar 2048  √  null
publication_note pnote_zdb_id varchar 50
int_person_company position_id int8 19  √  null
int_person_lab position_id int8 19  √  null
webenvvariables possible_values varchar 255  √  null
zdb_submitters previous_login datetime year to fraction(3) 23  √  null
probe_library probelib_host varchar 100  √  null
probe_library probelib_name varchar 80  √  null
probe_library probelib_non_zfin_stg_name varchar 80  √  null
probe_library probelib_non_zfin_strain_name varchar 100  √  null
probe_library probelib_non_zfin_tissue_name varchar 150  √  null
probe_library probelib_restriction_sites varchar 80  √  null
probe_library probelib_sex varchar 15  √  null
probe_library probelib_species varchar 60
probe_library probelib_stg_zdb_id varchar 50  √  null
probe_library probelib_strain_zdb_id varchar 50  √  null
probe_library probelib_term_zdb_id varchar 50  √  null
probe_library probelib_tissue_zdb_id varchar 50  √  null
probe_library probelib_url varchar 100  √  null
probe_library probelib_zdb_id varchar 50
webudrs procid int 10  √  null
webudrs procname varchar 128  √  null
panels producer varchar 50
staging_webpages project varchar 40
webpages project varchar 40
phenotype_observation_generated psg_e1_relation_name varchar 30  √  null
phenotype_observation_generated_bkup psg_e1_relation_name varchar 30  √  null
phenotype_observation_generated_temp psg_e1_relation_name varchar 30  √  null
phenotype_observation_generated psg_e1a_name varchar 255  √  null
phenotype_observation_generated_bkup psg_e1a_name varchar 255  √  null
phenotype_observation_generated_temp psg_e1a_name varchar 255  √  null
phenotype_observation_generated psg_e1a_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_e1a_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_e1a_zdb_id varchar 50  √  null
phenotype_observation_generated psg_e1b_name varchar 255  √  null
phenotype_observation_generated_bkup psg_e1b_name varchar 255  √  null
phenotype_observation_generated_temp psg_e1b_name varchar 255  √  null
phenotype_observation_generated psg_e1b_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_e1b_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_e1b_zdb_id varchar 50  √  null
phenotype_observation_generated psg_e2_relation_name varchar 50  √  null
phenotype_observation_generated_bkup psg_e2_relation_name varchar 50  √  null
phenotype_observation_generated_temp psg_e2_relation_name varchar 50  √  null
phenotype_observation_generated psg_e2a_name varchar 255  √  null
phenotype_observation_generated_bkup psg_e2a_name varchar 255  √  null
phenotype_observation_generated_temp psg_e2a_name varchar 255  √  null
phenotype_observation_generated psg_e2a_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_e2a_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_e2a_zdb_id varchar 50  √  null
phenotype_observation_generated psg_e2b_name varchar 255  √  null
phenotype_observation_generated_bkup psg_e2b_name varchar 255  √  null
phenotype_observation_generated_temp psg_e2b_name varchar 255  √  null
phenotype_observation_generated psg_e2b_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_e2b_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_e2b_zdb_id varchar 50  √  null
phenotype_observation_generated psg_id int8 19  √  null
phenotype_observation_generated_bkup psg_id int8 19  √  null
phenotype_observation_generated_temp psg_id serial8 19  √ 
phenotype_observation_generated psg_mrkr_abbrev varchar 255  √  null
phenotype_observation_generated_bkup psg_mrkr_abbrev varchar 255  √  null
phenotype_observation_generated_temp psg_mrkr_abbrev varchar 255  √  null
phenotype_observation_generated psg_mrkr_relation varchar 30  √  null
phenotype_observation_generated_bkup psg_mrkr_relation varchar 30  √  null
phenotype_observation_generated_temp psg_mrkr_relation varchar 30  √  null
phenotype_observation_generated psg_mrkr_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_mrkr_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_mrkr_zdb_id varchar 50  √  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 boolean 1  √  f
phenotype_observation_generated_bkup psg_pre_eap_phenotype boolean 1  √  f
phenotype_observation_generated_temp psg_pre_eap_phenotype boolean 1  √  f
phenotype_observation_generated psg_quality_name varchar 255  √  null
phenotype_observation_generated_bkup psg_quality_name varchar 255  √  null
phenotype_observation_generated_temp psg_quality_name varchar 255  √  null
phenotype_observation_generated psg_quality_zdb_id varchar 50  √  null
phenotype_observation_generated_bkup psg_quality_zdb_id varchar 50  √  null
phenotype_observation_generated_temp psg_quality_zdb_id varchar 50  √  null
phenotype_observation_generated psg_short_name varchar 255  √  null
phenotype_observation_generated_bkup psg_short_name varchar 255  √  null
phenotype_observation_generated_temp psg_short_name varchar 255  √  null
phenotype_observation_generated psg_tag varchar 40  √  null
phenotype_observation_generated_bkup psg_tag varchar 40  √  null
phenotype_observation_generated_temp psg_tag varchar 40  √  null
pheno_term pt_end_stg_zdb_id varchar 50
pheno_term_old pt_end_stg_zdb_id varchar 50
pheno_term pt_fig_zdb_id varchar 50
pheno_term_old pt_fig_zdb_id varchar 50
pheno_term pt_geno_is_wildtype boolean 1
pheno_term_old pt_geno_is_wildtype boolean 1
pheno_term pt_geno_zdb_id varchar 50
pheno_term_old pt_geno_zdb_id varchar 50
pheno_term pt_genox_zdb_id varchar 50
pheno_term_old pt_genox_zdb_id varchar 50
pheno_term pt_pheno_entity varchar 50
pheno_term_old pt_pheno_entity varchar 50
pheno_term pt_pk_id serial8 19  √ 
pheno_term_old pt_pk_id serial8 19  √ 
pheno_term pt_pub_zdb_id varchar 50
pheno_term_old pt_pub_zdb_id varchar 50
pheno_term pt_start_stg_zdb_id varchar 50
pheno_term_old pt_start_stg_zdb_id varchar 50
pheno_term pt_tag varchar 25  √  null
pheno_term_old pt_tag varchar 25  √  null
pheno_term_fast_search ptfs_created_date datetime year to second 19  √  current
pheno_term_fast_search_tmp ptfs_created_date datetime year to second 19  √  current
pheno_term_fast_search ptfs_is_direct_annotation boolean 1  √  f
pheno_term_fast_search_tmp ptfs_is_direct_annotation boolean 1  √  f
pheno_term_fast_search ptfs_phenos_created_date datetime year to second 19
pheno_term_fast_search_tmp ptfs_phenos_created_date datetime year to second 19
pheno_term_fast_search ptfs_pk_id serial8 19  √ 
pheno_term_fast_search_tmp ptfs_pk_id serial8 19  √ 
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 varchar 25  √  null
pheno_term_fast_search_tmp ptfs_tag varchar 25  √  null
pheno_term_fast_search ptfs_term_zdb_id varchar 50
pheno_term_fast_search_tmp ptfs_term_zdb_id varchar 50
pub_tracking_history pth_claimed_by varchar 50  √  null
pub_tracking_history pth_days_in_status int 10  √  null
pub_tracking_history pth_location_id int8 19  √  null
pub_tracking_history pth_pk_id serial8 19  √ 
pub_tracking_history pth_pub_zdb_id varchar 50
pub_tracking_history pth_status_id int8 19
pub_tracking_history pth_status_insert_date datetime year to second 19 current
pub_tracking_history pth_status_is_current boolean 1 f
pub_tracking_history pth_status_made_non_current_date datetime year to second 19  √  null
pub_tracking_history pth_status_set_by varchar 50
pub_tracking_location ptl_location varchar 30
pub_tracking_location ptl_location_definition varchar 255
pub_tracking_location ptl_location_display varchar 60
pub_tracking_location ptl_pk_id serial8 19  √ 
pub_tracking_location ptl_role varchar 50
pub_tracking_status pts_definition varchar 255  √  null
pub_tracking_status pts_hidden_status boolean 1 f
pub_tracking_status pts_pipeline_pull_down_order int8 19
pub_tracking_status pts_pk_id serial8 19  √ 
pub_tracking_status pts_status varchar 100  √  null
pub_tracking_status pts_status_display varchar 150
pub_tracking_status pts_status_qualifier varchar 50  √  null
pub_tracking_status pts_terminal_status boolean 1 t
panels ptype varchar 50
publication pub_abstract clob 2147483647  √  null
publication pub_acknowledgment lvarchar 2048  √  null
publication pub_arrival_date datetime year to day 10 current
publication pub_authors_lower lvarchar 1500
publication pub_can_show_images boolean 1 f
publication pub_completion_date datetime year to day 10  √  null
publication pub_date date 10  √  null
publication pub_doi varchar 70  √  null
publication pub_errata_and_notes lvarchar 3000  √  null
publication pub_indexed_date datetime year to day 10  √  null
publication pub_is_indexed boolean 1 f
publication pub_jrnl_zdb_id varchar 50
publication pub_last_sent_email_date datetime year to second 19  √  null
publication pub_mini_ref varchar 60  √  null
publication pub_pages varchar 35  √  null
publication pub_volume varchar 60  √  null
publication_correspondence pubcorr_contacted_date datetime year to second 19 current
publication_correspondence pubcorr_curator_zdb_id varchar 50
publication_correspondence pubcorr_gave_up_date datetime year to second 19  √  null
publication_correspondence pubcorr_pk_id serial8 19  √ 
publication_correspondence pubcorr_pub_zdb_id varchar 50
publication_correspondence pubcorr_responded_date datetime year to second 19  √  null
pub_correspondence_recipient pubcr_pk_id serial8 19  √ 
pub_correspondence_recipient pubcr_recipient_email_address varchar 100  √  null
pub_correspondence_recipient pubcr_recipient_first_name varchar 100  √  null
pub_correspondence_recipient pubcr_recipient_last_name varchar 100  √  null
pub_correspondence_recipient pubcr_recipient_person_zdb_id varchar 50  √  null
pub_correspondence_recipient pubcr_recipient_sent_email_id int8 19
pub_correspondence_received_email pubcre_correspondence_from_email_address varchar 100
pub_correspondence_received_email pubcre_correspondence_from_first_name varchar 100  √  null
pub_correspondence_received_email pubcre_correspondence_from_last_name varchar 100  √  null
pub_correspondence_received_email pubcre_correspondence_from_person_zdb_id varchar 50  √  null
pub_correspondence_received_email pubcre_pk_id serial8 19  √ 
pub_correspondence_received_email pubcre_pub_zdb_id varchar 50
pub_correspondence_received_email pubcre_received_by varchar 50  √  null
pub_correspondence_received_email pubcre_received_date datetime year to second 19 current
pub_correspondence_received_email pubcre_subject varchar 100
pub_correspondence_received_email pubcre_text lvarchar 10000  √  null
pub_correspondence_sent_email pubcse_date_composed datetime year to second 19 current
pub_correspondence_sent_email pubcse_pk_id serial8 19  √ 
pub_correspondence_sent_email pubcse_pub_zdb_id varchar 50
pub_correspondence_sent_email pubcse_recipient_group varchar 100
pub_correspondence_sent_email pubcse_sent_by varchar 50
pub_correspondence_sent_email pubcse_subject varchar 100
pub_correspondence_sent_email pubcse_text lvarchar 10000
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 datetime year to second 19 current
pub_correspondence_sent_tracker pubcst_gave_up_date datetime year to second 19  √  null
pub_correspondence_sent_tracker pubcst_pk_id serial8 19  √ 
pub_correspondence_sent_tracker pubcst_pub_zdb_id varchar 50
pub_correspondence_sent_tracker pubcst_resend boolean 1 f
pub_correspondence_sent_tracker pubcst_sent_by varchar 50
pub_correspondence_sent_tracker pubcst_sent_email_id int8 19
publication pubmed_authors lvarchar 400  √  null
replaced_accession_number ran_new_acc_num varchar 60
replaced_accession_number ran_old_acc_num varchar 60
staging_webpages read_level int 10  √  null
webcmpages read_level int 10  √  null
webpages read_level int 10  √  null
updates rec_id varchar 50  √  null
return_recs rec_update boolean 1  √  null
record_attribution recattrib_data_zdb_id varchar 50
record_attribution recattrib_pk_id serial8 19  √ 
record_attribution recattrib_source_significance int 10  √  null
record_attribution recattrib_source_type varchar 60 standard
record_attribution recattrib_source_zdb_id varchar 50
mapped_marker refcross_id varchar 50
sysbldobjdepends reserved1 varchar 255  √  null
sysbldobjects reserved1 varchar 255  √  null
sysbldobjdepends reserved2 int 10  √  null
sysbldobjects reserved2 int 10  √  null
sysbldobjdepends reserved3 int 10  √  null
sysbldobjects reserved3 int 10  √  null
primer_set restr_enzyme varchar 80  √  null
return_recs return_form varchar 100  √  null
return_recs return_recid varchar 100  √  null
primer_set rev_primer lvarchar 2048  √  null
run run_blastdb varchar 30
run run_date datetime year to day 10
run run_name varchar 30
run run_nomen_pub_zdb_id varchar 50 ZDB-PUB-030508-1
run run_program varchar 10
run run_relation_pub_zdb_id varchar 50  √  null
run run_type varchar 30
run run_version varchar 10  √  null
run run_zdb_id varchar 50
run_candidate runcan_cnd_zdb_id varchar 50
run_candidate runcan_done boolean 1 f
run_candidate runcan_locked_by varchar 50  √  null
run_candidate runcan_occurrence_order int 10
run_candidate runcan_run_zdb_id varchar 50
run_candidate runcan_zdb_id varchar 50
run_program runprog_program varchar 10
run_program runprog_query_type varchar 10  √  null
run_program runprog_target_type varchar 10  √  null
run_type runtype_name varchar 30
source_alias salias_alias varchar 255
source_alias salias_alias_lower varchar 255
source_alias salias_source_zdb_id varchar 50
source_alias salias_zdb_id varchar 50
mapped_marker scoring_data varchar 200  √  null
marker_sequence seq_left_end varchar 10  √  null
snp_sequence seq_left_end varchar 10  √  null
marker_sequence seq_mrkr_zdb_id varchar 50
snp_sequence seq_mrkr_zdb_id varchar 50  √  null
marker_sequence seq_offset_start int 10  √  null
snp_sequence seq_offset_start int 10  √  null
marker_sequence seq_offset_stop int 10  √  null
snp_sequence seq_offset_stop int 10  √  null
marker_sequence seq_sequence varchar 255  √  null
snp_sequence seq_sequence varchar 255  √  null
marker_sequence seq_sequence_2 varchar 255  √  null
snp_sequence seq_sequence_2 varchar 255  √  null
marker_sequence seq_type varchar 20  √  null
snp_sequence seq_type varchar 20  √  null
snp_sequence seq_variation varchar 20  √  null
sequence_ambiguity_code seqac_meaning varchar 20
sequence_ambiguity_code seqac_symbol char 1  √  null
sequence_type seqtype_comments lvarchar 2048  √  null
sequence_type seqtype_name varchar 20
sysbldobjects sequence int 10  √  0
sequence_feature_chromosome_location_bkup sfcl_acc_num varchar 30  √  null
sequence_feature_chromosome_location_temp sfcl_acc_num varchar 30  √  null
sequence_feature_chromosome_location sfcl_assembly varchar 10  √  null
sequence_feature_chromosome_location sfcl_chromosome varchar 2
sequence_feature_chromosome_location_bkup sfcl_chromosome varchar 20
sequence_feature_chromosome_location_temp sfcl_chromosome varchar 20
sequence_feature_chromosome_location_bkup sfcl_data_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_temp sfcl_data_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_bkup sfcl_end int 10  √  null
sequence_feature_chromosome_location_temp sfcl_end int 10  √  null
sequence_feature_chromosome_location sfcl_end_position int 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 varchar 50
sequence_feature_chromosome_location_bkup sfcl_location_source varchar 40  √  null
sequence_feature_chromosome_location_temp sfcl_location_source varchar 40  √  null
sequence_feature_chromosome_location_bkup sfcl_location_subsource varchar 255  √  null
sequence_feature_chromosome_location_temp sfcl_location_subsource varchar 255  √  null
sequence_feature_chromosome_location_bkup sfcl_start int 10  √  null
sequence_feature_chromosome_location_temp sfcl_start int 10  √  null
sequence_feature_chromosome_location sfcl_start_position int 10  √  null
sequence_feature_chromosome_location sfcl_zdb_id varchar 50
sequence_feature_chromosome_location_generated sfclg_acc_num varchar 30  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_acc_num varchar 30  √  null
sequence_feature_chromosome_location_generated_temp sfclg_acc_num varchar 30  √  null
sequence_feature_chromosome_location_generated sfclg_assembly varchar 10  √  GRCv10
sequence_feature_chromosome_location_generated sfclg_chromosome varchar 20
sequence_feature_chromosome_location_generated_bkup sfclg_chromosome varchar 20
sequence_feature_chromosome_location_generated_temp sfclg_chromosome varchar 20
sequence_feature_chromosome_location_generated sfclg_data_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_data_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_generated_temp sfclg_data_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_generated sfclg_end int 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_end int 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_end int 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 varchar 50  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_gbrowse_track varchar 50  √  null
sequence_feature_chromosome_location_generated_temp sfclg_gbrowse_track varchar 50  √  null
sequence_feature_chromosome_location_generated sfclg_location_source varchar 40  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_source varchar 40  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_source varchar 40  √  null
sequence_feature_chromosome_location_generated sfclg_location_subsource varchar 255  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_location_subsource varchar 100  √  null
sequence_feature_chromosome_location_generated_temp sfclg_location_subsource varchar 255  √  null
sequence_feature_chromosome_location_generated sfclg_pk_id serial8 19  √ 
sequence_feature_chromosome_location_bkup sfclg_pub_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_generated sfclg_pub_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_temp sfclg_pub_zdb_id varchar 50  √  null
sequence_feature_chromosome_location_generated sfclg_start int 10  √  null
sequence_feature_chromosome_location_generated_bkup sfclg_start int 10  √  null
sequence_feature_chromosome_location_generated_temp sfclg_start int 10  √  null
source_feature_prefix sfp_current_designation boolean 1 t
source_feature_prefix sfp_prefix_id int8 19
source_feature_prefix sfp_source_zdb_id varchar 50
company snapshot blob 2147483647  √  null
lab snapshot blob 2147483647  √  null
person snapshot blob 2147483647  √  null
single sngl_one varchar 1  √  null
snp_download snpd_mrkr_zdb_id varchar 50
snp_download snpd_pk_id serial 10  √ 
snp_download snpd_rs_acc_num varchar 40
snp_download_attribution snpdattr_pub_zdb_id varchar 50
snp_download_attribution snpdattr_snpd_pk_id int 10
panels source varchar 50
primer_set source varchar 50  √  null
int_person_company source_id varchar 50
int_person_lab source_id varchar 50
int_person_pub source_id varchar 50
source_url srcurl_display_text varchar 255
source_url srcurl_purpose varchar 20 information
source_url srcurl_source_zdb_id varchar 50
source_url srcurl_url varchar 255
source_url_purpose srcurlpurp_comments varchar 255  √  null
source_url_purpose srcurlpurp_name varchar 20
sysbldobjdepends state char 1  √  U
sysbldobjects state char 1  √  U
company status varchar 20  √  null
int_person_company status varchar 20  √  null
int_person_lab status varchar 20  √  null
int_person_pub status varchar 20  √  null
lab status varchar 20  √  null
panels status varchar 10
publication status varchar 30  √  null
state_code stc_code varchar 4
state_code stc_display_order int 10  √  null
state_code stc_name varchar 60
stage stg_abbrev varchar 40  √  null
stage stg_hours_end decimal 7,2
stage stg_hours_start decimal 7,2
stage stg_name varchar 80  √  null
stage stg_name_ext varchar 50  √  null
stage stg_name_long varchar 130  √  null
stage stg_obo_id varchar 20
stage stg_other_features varchar 50  √  null
stage stg_zdb_id varchar 50
btsfse_storage sto_row row 2132  √  null
primer_set strain_id varchar 50  √  null
str_group strg_genox_zdb_id varchar 50  √  null
str_group strg_group_name lvarchar 200  √  null
str_group strg_group_pk_id serial8 19  √ 
mapped_marker submitter varchar 50  √  null
updates submitter_id varchar 50  √  null
updates submitter_name varchar 80  √  null
so_zfin_mapping szm_object_type varchar 100
so_zfin_mapping szm_pk_id serial8 19  √ 
so_zfin_mapping szm_term_name varchar 100
so_zfin_mapping szm_term_ont_id varchar 50
sysindexes tabid int 10  √  null
databasechangelog tag varchar 255  √  null
vgroupsize tally decimal 15
vmrkrgoevsamesize tally decimal 15
paneled_markers target_abbrev varchar 20  √  null
zmap_pub_pan_mark target_abbrev varchar 10
int_person_company target_id varchar 50
int_person_lab target_id varchar 50
int_person_pub target_id varchar 50
paneled_markers target_id varchar 50  √  null
zmap_pub_pan_mark target_id varchar 50
sysbldobjdepends temp_state char 1  √  U
sysbldobjects temp_state char 1  √  U
term term_comment lvarchar 2048  √  null
term term_definition lvarchar 2048  √  null
term term_is_obsolete boolean 1 f
term term_is_root boolean 1 f
term term_is_secondary boolean 1 f
term term_name varchar 255
term term_name_order varchar 255  √  null
term term_ont_id varchar 50
term term_ontology varchar 50  √  null
term term_ontology_id int8 19
term term_primary_subset_id int8 19  √  null
term term_zdb_id varchar 50
term_relationship termrel_term_1_zdb_id varchar 50
term_relationship termrel_term_2_zdb_id varchar 50
term_relationship termrel_type varchar 100
term_relationship termrel_zdb_id varchar 50
term_relationship_type termreltype_name varchar 100
term_subset termsub_subset_id int8 19
term_subset termsub_term_zdb_id varchar 50
term_group tg_geno_handle varchar 255  √  null
term_group tg_geno_name varchar 255  √  null
term_group tg_genox_group varchar 50  √  null
term_group tg_group_name lvarchar 5000  √  null
term_group tg_group_pk_id serial8 19  √ 
primer_set the_id varchar 80  √  null
webcmpages time_stamp datetime year to second 19
webconfigs time_stamp datetime year to second 19
webenvvariables time_stamp datetime year to second 19
publication title lvarchar 400  √  null
tmp_db_link tmp_acc_num varchar 50  √  null
tmp_db_link tmp_db_name varchar 50  √  null
tmp_db_link tmp_dblink_zdb_id varchar 50  √  null
tmp_db_link tmp_fdbcont_zdb_id varchar 50  √  null
tmp_db_link tmp_info varchar 80  √  null
tmp_db_link tmp_length int 10  √  null
tmp_db_link tmp_linked_recid varchar 50  √  null
term_stage ts_end_stg_zdb_id varchar 50  √  null
term_stage ts_start_stg_zdb_id varchar 50  √  null
term_stage ts_term_zdb_id varchar 50  √  null
transcript tscript_load_id varchar 50
transcript tscript_mrkr_zdb_id varchar 50
transcript tscript_status_id int8 19  √  null
transcript tscript_type_id int8 19
transcript_status tscripts_display varchar 60
transcript_status tscripts_order int 10  √  null
transcript_status tscripts_pk_id serial8 19  √ 
transcript_status tscripts_status varchar 60
transcript_type tscriptt_definition lvarchar 2048  √  null
transcript_type tscriptt_display varchar 60
transcript_type tscriptt_indent boolean 1 f
transcript_type tscriptt_order int 10  √  null
transcript_type tscriptt_pk_id serial8 19  √ 
transcript_type tscriptt_type varchar 60
tscript_type_status_definition ttsdef_definition lvarchar 2048
tscript_type_status_definition ttsdef_pk_id serial8 19  √ 
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 varchar 40
term_xref tx_fdb_db_id int8 19  √  null
term_xref tx_full_accession varchar 80
term_xref tx_pk_id serial8 19  √ 
term_xref tx_prefix varchar 20
term_xref tx_term_zdb_id varchar 50
sysdomains type smallint 5  √  null
unique_location ul_chromosome varchar 20
unique_location ul_data_zdb_id varchar 50
updates upd_pk_id serial8 19  √ 
company url varchar 80  √  null
lab url varchar 255  √  null
person url varchar 150  √  null
url_ref urlref_data_zdb_id varchar 50
url_ref urlref_display_text varchar 255  √  null
url_ref urlref_full_url varchar 255  √  null
url_ref urlref_zdb_id varchar 50
webconfigs value varchar 255  √  null
webconfigs variable_name varchar 80
webenvvariables variable_name varchar 80
vector vector_name varchar 80
vector vector_type_name varchar 20 Not specified
vector_type vectype_comments lvarchar 2048  √  null
vector_type vectype_name varchar 20
video video_image_still_zdb_id varchar 50
video video_path_to_file varchar 100
video video_pk_id serial8 19  √ 
validate_check_history vldcheck_count int 10
validate_check_history vldcheck_date datetime year to second 19
validate_check_history vldcheck_name varchar 60
withdrawn_data wd_display_note lvarchar 2048  √  null
withdrawn_data wd_new_zdb_id varchar 50
withdrawn_data wd_old_zdb_id varchar 50
withdrawn_data wd_pk_id serial8 19  √ 
updates when datetime year to fraction(3) 23  √  null
webcmimages width int 10  √  null
staging_webpages write_level int 10  √  null
webpages write_level int 10  √  null
warehouse_run_tracking wrt_last_loaded_date datetime year to second 19 current
warehouse_run_tracking wrt_mart_load_successful boolean 1  √  t
warehouse_run_tracking wrt_mart_name varchar 20
warehouse_run_tracking wrt_pk_id serial8 19  √ 
xpat_exp_details_generated xedg_assay_name varchar 40
xpat_exp_details_generated_bkup xedg_assay_name varchar 40  √  null
xpat_exp_details_generated_temp xedg_assay_name varchar 40  √  null
xpat_exp_details_generated xedg_atb_zdb_id varchar 50  √  null
xpat_exp_details_generated_bkup xedg_atb_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_atb_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_dblink_zdb_id varchar 50  √  null
xpat_exp_details_generated_bkup xedg_dblink_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_dblink_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_direct_submission_date datetime year to day 10 current
xpat_exp_details_generated_bkup xedg_direct_submission_date datetime year to day 10  √  current
xpat_exp_details_generated_temp xedg_direct_submission_date datetime year to day 10  √  current
xpat_exp_details_generated xedg_fig_zdb_id varchar 50
xpat_exp_details_generated_bkup xedg_fig_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_fig_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_gene_zdb_id varchar 50  √  null
xpat_exp_details_generated_bkup xedg_gene_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_gene_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_genox_zdb_id varchar 50  √  null
xpat_exp_details_generated_bkup xedg_genox_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_genox_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_pk_id int8 19
xpat_exp_details_generated_bkup xedg_pk_id serial8 19  √ 
xpat_exp_details_generated_temp xedg_pk_id serial8 19  √ 
xpat_exp_details_generated xedg_probe_feature_zdb_id varchar 50  √  null
xpat_exp_details_generated_bkup xedg_probe_feature_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_probe_feature_zdb_id varchar 50  √  null
xpat_exp_details_generated xedg_zdb_id varchar 50
xpat_exp_details_generated_bkup xedg_zdb_id varchar 50  √  null
xpat_exp_details_generated_temp xedg_zdb_id varchar 50  √  null
xpat_figure_group xfigg_geno_handle varchar 255  √  null
xpat_figure_group xfigg_genox_zdb_id varchar 50  √  null
xpat_figure_group xfigg_group_name lvarchar 380  √  null
xpat_figure_group xfigg_group_pk_id serial8 19  √ 
xpat_figure_group xfigg_has_images boolean 1  √  f
xpat_figure_group_member xfiggm_group_id int8 19
xpat_figure_group_member xfiggm_member_id varchar 50
xpat_figure_group_member xfiggm_member_name varchar 50  √  null
xpat_figure_group_member xfiggm_pk_id serial8 19  √ 
expression_pattern_assay xpatassay_abbrev varchar 30  √  null
expression_pattern_assay xpatassay_comments lvarchar 2048  √  null
expression_pattern_assay xpatassay_display_order int 10
expression_pattern_assay xpatassay_name varchar 40
expression_experiment xpatex_assay_name varchar 40  √  null
expression_experiment2 xpatex_assay_name varchar 40
expression_experiment_bkup xpatex_assay_name varchar 40  √  null
expression_experiment_temp xpatex_assay_name varchar 40  √  null
expression_experiment xpatex_atb_zdb_id varchar 50  √  null
expression_experiment2 xpatex_atb_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_atb_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_atb_zdb_id varchar 50  √  null
expression_experiment xpatex_dblink_zdb_id varchar 50  √  null
expression_experiment2 xpatex_dblink_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_dblink_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_dblink_zdb_id varchar 50  √  null
expression_experiment xpatex_direct_submission_date datetime year to day 10  √  current
expression_experiment2 xpatex_direct_submission_date datetime year to day 10 current
expression_experiment_bkup xpatex_direct_submission_date datetime year to day 10  √  null
expression_experiment_temp xpatex_direct_submission_date datetime year to day 10  √  null
expression_experiment xpatex_gene_zdb_id varchar 50  √  null
expression_experiment2 xpatex_gene_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_gene_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_gene_zdb_id varchar 50  √  null
expression_experiment xpatex_genox_zdb_id varchar 50  √  null
expression_experiment2 xpatex_genox_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_genox_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_genox_zdb_id varchar 50  √  null
expression_experiment xpatex_probe_feature_zdb_id varchar 50  √  null
expression_experiment2 xpatex_probe_feature_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_probe_feature_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_probe_feature_zdb_id varchar 50  √  null
expression_experiment xpatex_source_zdb_id varchar 50  √  null
expression_experiment2 xpatex_source_zdb_id varchar 50  √  null
expression_experiment_bkup xpatex_source_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_source_zdb_id varchar 50  √  null
expression_experiment xpatex_zdb_id varchar 50  √  null
expression_experiment2 xpatex_zdb_id varchar 50
expression_experiment_bkup xpatex_zdb_id varchar 50  √  null
expression_experiment_temp xpatex_zdb_id varchar 50  √  null
expression_pattern_figure xpatfig_fig_zdb_id varchar 50  √  null
expression_pattern_figure_bkup xpatfig_fig_zdb_id varchar 50  √  null
expression_pattern_figure_temp xpatfig_fig_zdb_id varchar 50  √  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 varchar 50
expression_pattern_infrastructure xpatinf_date datetime year to day 10 current
expression_pattern_infrastructure xpatinf_expression_found boolean 1  √  t
expression_pattern_infrastructure xpatinf_pub_zdb_id varchar 50
expression_pattern_infrastructure xpatinf_quality_term_zdb_id varchar 50  √  null
expression_pattern_infrastructure xpatinf_subterm_zdb_id varchar 50  √  null
expression_pattern_infrastructure xpatinf_superterm_zdb_id varchar 50
expression_pattern_infrastructure xpatinf_tag varchar 40  √  null
expression_pattern_infrastructure xpatinf_zdb_id varchar 50
expression_result xpatres_comments varchar 255  √  null
expression_result2 xpatres_efs_id int8 19
expression_result_bkup xpatres_end_stage_zdb_id varchar 50  √  null
expression_result xpatres_end_stg_zdb_id varchar 50  √  null
expression_result_temp xpatres_end_stg_zdb_id varchar 50  √  null
expression_result xpatres_expression_found boolean 1  √  t
expression_result2 xpatres_expression_found boolean 1
expression_result_bkup xpatres_expression_found boolean 1  √  null
expression_result_temp xpatres_expression_found boolean 1  √  null
expression_result xpatres_fig_zdb_id varchar 50  √  null
expression_result_bkup xpatres_fig_zdb_id varchar 50  √  null
expression_result_temp xpatres_fig_zdb_id varchar 50  √  null
expression_result2 xpatres_pk_id serial8 19  √ 
expression_result_bkup xpatres_pk_id int8 19  √  null
expression_result_bkup xpatres_start_stage_zdb_id varchar 50  √  null
expression_result xpatres_start_stg_zdb_id varchar 50  √  null
expression_result_temp xpatres_start_stg_zdb_id varchar 50  √  null
expression_result xpatres_subterm_zdb_id varchar 50  √  null
expression_result2 xpatres_subterm_zdb_id varchar 50  √  null
expression_result_bkup xpatres_subterm_zdb_id varchar 50  √  null
expression_result_temp xpatres_subterm_zdb_id varchar 50  √  null
expression_result xpatres_superterm_zdb_id varchar 50  √  null
expression_result2 xpatres_superterm_zdb_id varchar 50
expression_result_bkup xpatres_superterm_zdb_id varchar 50  √  null
expression_result_temp xpatres_superterm_zdb_id varchar 50  √  null
expression_result xpatres_xpatex_zdb_id varchar 50  √  null
expression_result_bkup xpatres_xpatex_zdb_id varchar 50  √  null
expression_result_temp xpatres_xpatex_zdb_id varchar 50  √  null
expression_result xpatres_zdb_id int8 19  √  null
expression_result_temp xpatres_zdb_id serial8 19  √ 
xpat_results_generated xrg_comments varchar 255  √  null
xpat_results_generated_bkup xrg_comments varchar 255  √  null
xpat_results_generated_temp xrg_comments varchar 255  √  null
xpat_results_generated xrg_end_stg_zdb_id varchar 50
xpat_results_generated_bkup xrg_end_stg_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_end_stg_zdb_id varchar 50  √  null
xpat_results_generated xrg_expression_found boolean 1 t
xpat_results_generated_bkup xrg_expression_found boolean 1  √  t
xpat_results_generated_temp xrg_expression_found boolean 1  √  t
xpat_results_generated xrg_pk_id int8 19
xpat_results_generated_bkup xrg_pk_id serial8 19  √ 
xpat_results_generated_temp xrg_pk_id serial8 19  √ 
xpat_results_generated xrg_start_stg_zdb_id varchar 50
xpat_results_generated_bkup xrg_start_stg_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_start_stg_zdb_id varchar 50  √  null
xpat_results_generated xrg_subterm_zdb_id varchar 50  √  null
xpat_results_generated_bkup xrg_subterm_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_subterm_zdb_id varchar 50  √  null
xpat_results_generated xrg_suggested_anatomy_item varchar 75  √  null
xpat_results_generated_bkup xrg_suggested_anatomy_item varchar 75  √  null
xpat_results_generated_temp xrg_suggested_anatomy_item varchar 75  √  null
xpat_results_generated xrg_superterm_zdb_id varchar 50
xpat_results_generated_bkup xrg_superterm_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_superterm_zdb_id varchar 50  √  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 varchar 50
xpat_results_generated_bkup xrg_xedg_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_xedg_zdb_id varchar 50  √  null
xpat_results_generated xrg_zdb_id varchar 50
xpat_results_generated_bkup xrg_zdb_id varchar 50  √  null
xpat_results_generated_temp xrg_zdb_id varchar 50  √  null
zfin_accession_number za_acc_num varchar 40
zfin_accession_number za_date_entered datetime year to second 19 current
zfin_accession_number za_prefix varchar 15 ZFINNUCL
zfin_accession_number za_sequence_number int8 19
zdb_active_data zactvd_zdb_id varchar 50
zdb_active_source zactvs_zdb_id varchar 50
company zdb_id varchar 50
lab zdb_id varchar 50
mapped_marker zdb_id varchar 50
paneled_markers zdb_id varchar 50  √  null
panels zdb_id varchar 50
person zdb_id varchar 50
primer_set zdb_id varchar 50
publication zdb_id varchar 50
return_recs zdb_id varchar 100  √  null
zdb_submitters zdb_id varchar 50
zmap_pub_pan_mark zdb_id varchar 50  √  null
tmp_zeco_tt zecoid varchar 50  √  null
zfin_ensembl_gene zeg_alias varchar 55
zfin_ensembl_gene zeg_end int 10  √  null
zfin_ensembl_gene zeg_feature varchar 45  √  null
zfin_ensembl_gene zeg_frame char 1  √  null
zfin_ensembl_gene zeg_id_name varchar 110  √  null
zfin_ensembl_gene zeg_score varchar 5  √  null
zfin_ensembl_gene zeg_seqname varchar 25  √  null
zfin_ensembl_gene zeg_source varchar 45  √  null
zfin_ensembl_gene zeg_start int 10  √  null
zfin_ensembl_gene zeg_strand char 1  √  null
zdb_flag zflag_is_on boolean 1
zdb_flag zflag_last_modified datetime year to second 19
zdb_flag zflag_name varchar 30
zmap_pub_pan_mark zmap_chromosome varchar 2
zdb_object_type zobjtype_app_page varchar 40  √  null
zdb_object_type zobjtype_attribution_display_tier int 10  √  2
zdb_object_type zobjtype_day date 10
zdb_object_type zobjtype_home_table varchar 128
zdb_object_type zobjtype_home_zdb_id_column varchar 128
zdb_object_type zobjtype_is_data boolean 1  √  null
zdb_object_type zobjtype_is_source boolean 1  √  null
zdb_object_type zobjtype_name varchar 10
zdb_orphan_data zorphand_home_table varchar 128  √  null
zdb_orphan_data zorphand_home_zdb_id_column varchar 128  √  null
zdb_orphan_data zorphand_zdb_id varchar 50
zdb_orphan_source zorphans_home_table varchar 128  √  null
zdb_orphan_source zorphans_home_zdb_id_column varchar 128  √  null
zdb_orphan_source zorphans_zdb_id varchar 50
zdb_replaced_data zrepld_new_zdb_id varchar 50
zdb_replaced_data zrepld_old_name varchar 255  √  null
zdb_replaced_data zrepld_old_zdb_id varchar 50
zdb_replaced_data zrepld_pk_id serial8 19  √ 
zygocity zyg_abbrev varchar 10  √  null
zygocity zyg_allele_display varchar 10  √  null
zygocity zyg_definition varchar 255
zygocity zyg_gene_prefix varchar 10  √  null
zygocity zyg_name varchar 60
zygocity zyg_zdb_id varchar 50