SchemaSpy Analysis of zfindb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Sep 15 00:41 PDT 2021
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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