SchemaSpy Analysis of cxgn.sgn_bt - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Thu Jun 21 23:03 EDT 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.sgn_bt contains 731 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
abstract deprecated_maps text 2147483647
abstract map text 2147483647  √  null
accession library varchar 255  √  null
accession_id accession serial 10  √  nextval('accession_accession_id_seq'::regclass)
accession_names.accession_id accession_id_fk
map.parent_1 map_parent_1_fkey
map.parent_2 map_parent_2_fkey
pcr_exp_accession.accession_id accession_id_fk
accession_id accession_names int8 19  √  null
accession.accession_id accession_id_fk
accession_id forward_amplicon_sequence_information text 2147483647  √  null
accession_id pcr_exp_accession int8 19  √  null
accession.accession_id accession_id_fk
accession_id plants int4 10  √  null
accession_name accession_names varchar 255  √  null
accession_name plants varchar 255  √  null
accession_name_id accession int8 19  √  null
accession_names.accession_name_id accession_name_id_fk
accession_name_id accession_names bigserial 19  √  nextval('accession_names_accession_name_id_seq'::regclass)
accession.accession_name_id accession_name_id_fk
additional_enzymes pcr_experiment varchar 1023  √  null
alias marker_alias text 2147483647
alias_id marker_alias serial 10  √  nextval('marker_alias_alias_id_seq'::regclass)
align_length rflp_unigene_associations int8 19  √  null
alignment_seq family_member text 2147483647  √  null
ann_high ssr varchar 10  √  null
ann_low ssr varchar 10  √  null
annealing_temp pcr_experiment int8 19  √  null
annotation_target_id manual_annotations int8 19  √  null
annotation_target_type_id annotation_target_type bigserial 19  √  nextval('annotation_target_type_annotation_target_type_id_seq'::regclass)
annotation_target_type_id manual_annotations int8 19  √  null
annotation_text manual_annotations text 2147483647  √  null
annotation_text_fulltext manual_annotations tsvector 2147483647  √  null
apply_end blast_hits int8 19  √  null
apply_id blast_annotations int4 10  √  null
unigene.unigene_id apply_id_fkey
apply_start blast_hits int8 19  √  null
apply_type blast_annotations int4 10  √  null
arm fish_chromatin_density_constants varchar 1 'E'::character varying
arm_eu_length fish_karyotype_constants numeric 5,2
arm_het_length fish_karyotype_constants numeric 5,2
arm_length fish_karyotype_constants numeric 5,2
at_evalue cos_markers varchar 25  √  null
at_identities cos_markers numeric 11,3  √  null
at_match cos_markers varchar 25  √  null
at_position cos_markers numeric 11,7  √  null
attribution_display facility text 2147483647  √  null
attribution_id fish_result int8 19  √  null
attribution_id seqread int4 10  √  null
author_id authors serial 10  √  nextval('authors_author_id_seq'::regclass)
author_id manual_annotations int8 19  √  null
authors library varchar 255  √  null
bac_id cos_markers int8 19  √  null
band_size pcr_product int8 19  √  null
basecaller est varchar 40  √  null
basecaller qc_report varchar 40  √  null
batch_id seqread int4 10  √  null
begin cds int4 10  √  null
best_gb_prot_hit cos_markers varchar 25  √  null
blast_annotation_id blast_annotations serial 10  √  nextval('blast_annotations_blast_annotation_id_seq'::regclass)
blast_hits.blast_annotation_id blast_hits_blast_annotation_id_fkey
blast_annotation_id blast_hits int4 10  √  null
blast_annotations.blast_annotation_id blast_hits_blast_annotation_id_fkey
blast_db_group_id blast_db int4 10  √  null
blast_db_group.blast_db_group_id blast_db_blast_db_group_id_fkey
blast_db_group this belongs to, for displaying on web
blast_db_group_id blast_db_group serial 10  √  nextval('blast_db_group_blast_db_group_id_seq'::regclass)
blast_db.blast_db_group_id blast_db_blast_db_group_id_fkey
blast_db_id blast_db serial 10  √  nextval('blast_db_blast_db_id_seq'::regclass)
blast_hit_id blast_hits serial 10  √  nextval('blast_hits_blast_hit_id_seq'::regclass)
blast_program blast_targets varchar 7  √  null
blast_target_id blast_annotations int4 10  √  null
blast_target_id blast_defline int4 10  √  null
blast_target_id blast_targets serial 10  √  nextval('blast_targets_blast_target_id_seq'::regclass)
build_date family_build timestamp 29,6 ('now'::text)::timestamp(6) with time zone
build_date unigene_build date 13  √  now()
build_nr family_build int8 19  √  null
build_nr unigene_build int4 10 0
call_positions est text 2147483647  √  null
cds_id cds bigserial 19  √  nextval('cds_cds_id_seq'::regclass)
domain_match.cds_id domain_match_cds_id_fkey
cds_id domain_match int8 19  √  null
cds.cds_id domain_match_cds_id_fkey
cds_id family_member int8 19  √  null
censor_id manual_censor_reasons serial 10  √  nextval('manual_censor_reasons_censor_id_seq'::regclass)
censor_id seqread int4 10  √  null
chemistry facility varchar 40  √  null
chip_name microarray varchar 80  √  null
chromo_arm fish_karyotype_constants text 2147483647
chromo_arm fish_result varchar 1
chromo_arm fish_result_composite varchar 1 'P'::character varying
chromo_arm_ratio fish_karyotype_constants_old float4 8,8  √  null
chromo_length fish_karyotype_constants_old float4 8,8  √  null
chromo_num fish_karyotype_constants int2 5
fish_karyotype_constants_old.chromo_num Implied Constraint
chromo_num fish_karyotype_constants_old int2 5 (0)::smallint
fish_karyotype_constants.chromo_num Implied Constraint
fish_result.chromo_num Implied Constraint
fish_result_composite.chromo_num Implied Constraint
chromo_num fish_result int2 5
fish_karyotype_constants_old.chromo_num Implied Constraint
chromo_num fish_result_composite int2 5 (0)::smallint
fish_karyotype_constants_old.chromo_num Implied Constraint
clone_group_id clone int4 10  √  null
clone_id clone serial 10  √  nextval('clone_clone_id_seq'::regclass)
ests_mapped_by_clone.clone_id clone_id_fk
fish_result.clone_id fish_result_clone_id_fkey
seqread.clone_id clone_id_fk
clone_id ests_mapped_by_clone int8 19  √  null
clone.clone_id clone_id_fk
clone_id fish_result int8 19
clone.clone_id fish_result_clone_id_fkey
clone_id fish_result_composite int8 19 (0)::bigint
clone_id microarray int4 10  √  null
clone_id seqread int4 10  √  null
clone.clone_id clone_id_fk
clone_name clone varchar 50  √  null
clone_name rflp_markers varchar 16  √  null
cloning_host library varchar 80  √  null
cloning_kit library varchar 255  √  null
cloning_vector_id cloning_vector serial 10  √  nextval('cloning_vector_cloning_vector_id_seq'::regclass)
cluster_no unigene int8 19  √  null
comment cos_markers text 2147483647  √  null
comment groups text 2147483647  √  null
comment tm_markers text 2147483647  √  null
comment tm_markers_sequences text 2147483647  √  null
comment trim_feature_types text 2147483647  √  null
comment types text 2147483647  √  null
comment unigene_build text 2147483647  √  null
comments library text 2147483647  √  null
common_name accession varchar 80  √  null
common_name common_name varchar 255
common_name plants varchar 255  √  null
common_name_id common_name bigserial 19  √  nextval('common_name_common_name_id_seq'::regclass)
organism.common_name_id common_name_id_fk
common_name_id organism int8 19
common_name.common_name_id common_name_id_fk
confidence deprecated_marker_locations int8 19 (0)::bigint
deprecated_marker_confidences.legacy_conf_id confidence_fk
confidence mapmarkers_view int8 19  √  null
confidence_id deprecated_marker_confidences serial 10  √  nextval('deprecated_marker_confidences_confidence_id_seq'::regclass)
map_version.default_threshold map_version_default_threshold_fkey
marker_confidence.confidence_id Implied Constraint
confidence_id marker_confidence serial 10  √  nextval('marker_confidence_confidence_id_seq'::regclass)
marker_location.confidence_id marker_location_confidence_id_fkey
deprecated_marker_confidences.confidence_id Implied Constraint
confidence_id marker_location int4 10
marker_confidence.confidence_id marker_location_confidence_id_fkey
confidence_id marker_to_map int4 10  √  null
confidence_name deprecated_marker_confidences varchar 16  √  null
confidence_name marker_confidence text 2147483647  √  null
confirm_code submit_user varchar 16  √  null
consensi_id unigene int4 10  √  null
unigene_consensi.consensi_id unigene_unigene_consensi_id_fkey
consensi_id unigene_consensi serial 10  √  nextval('unigene_consensi_consensi_id_seq'::regclass)
unigene.consensi_id unigene_unigene_consensi_id_fkey
contact_information library text 2147483647  √  null
contact_information submit_user text 2147483647  √  null
content_specific_tag microarray varchar 40  √  null
contig_no unigene int8 19  √  null
copies cosii_ortholog varchar 1  √  null
cos_id cos_markers varchar 10 ''::character varying
cos_marker_id cos_markers serial 10  √  nextval('cos_markers_cos_marker_id_seq'::regclass)
cosii_unigene_id cosii_ortholog bigserial 19  √  nextval('cosii_ortholog_cosii_unigene_id_seq'::regclass)
cultivar library varchar 255  √  null
current_tc_id tigrtc_tracking int4 10  √  null
current_version map_version bool 1  √  null
current_version marker_to_map bool 1  √  null
cutting_site rflp_markers varchar 32  √  null
cxgn_production_visible accession bool 1  √  false
cxgn_production_visible accession_names bool 1  √  false
cxgn_production_visible annotation_target_type bool 1  √  false
cxgn_production_visible authors bool 1  √  false
cxgn_production_visible blast_annotations bool 1  √  false
cxgn_production_visible blast_db bool 1  √  false
cxgn_production_visible blast_db_group bool 1  √  false
cxgn_production_visible blast_defline bool 1  √  false
cxgn_production_visible blast_hits bool 1  √  false
cxgn_production_visible blast_targets bool 1  √  false
cxgn_production_visible cds bool 1  √  false
cxgn_production_visible clone bool 1  √  false
cxgn_production_visible cloning_vector bool 1  √  false
cxgn_production_visible common_name bool 1  √  false
cxgn_production_visible cos_markers bool 1  √  false
cxgn_production_visible cosii_ortholog bool 1  √  false
cxgn_production_visible deprecated_linkage_groups bool 1  √  false
cxgn_production_visible deprecated_map_cross bool 1  √  false
cxgn_production_visible deprecated_mapdata bool 1  √  false
cxgn_production_visible deprecated_maps bool 1  √  false
cxgn_production_visible deprecated_marker_confidences bool 1  √  false
cxgn_production_visible deprecated_marker_locations bool 1  √  false
cxgn_production_visible deprecated_marker_types bool 1  √  false
cxgn_production_visible deprecated_markers bool 1  √  false
cxgn_production_visible derived_from_source bool 1  √  false
cxgn_production_visible domain bool 1  √  false
cxgn_production_visible domain_match bool 1  √  false
cxgn_production_visible enzyme_restriction_sites bool 1  √  false
cxgn_production_visible enzymes bool 1  √  false
cxgn_production_visible est bool 1  √  false
cxgn_production_visible ests_mapped_by_clone bool 1  √  false
cxgn_production_visible experiment_type bool 1  √  false
cxgn_production_visible facility bool 1  √  false
cxgn_production_visible family bool 1  √  false
cxgn_production_visible family_build bool 1  √  false
cxgn_production_visible family_member bool 1  √  false
cxgn_production_visible family_tree bool 1  √  false
cxgn_production_visible fish_chromatin_density_constants bool 1  √  false
cxgn_production_visible fish_experimenter bool 1  √  false
cxgn_production_visible fish_file bool 1  √  false
cxgn_production_visible fish_image bool 1  √  false
cxgn_production_visible fish_karyotype_constants bool 1  √  false
cxgn_production_visible fish_karyotype_constants_old bool 1  √  false
cxgn_production_visible fish_result bool 1  √  false
cxgn_production_visible fish_result_composite bool 1  √  false
cxgn_production_visible forward_amplicon_sequence_information bool 1  √  true
cxgn_production_visible forward_amplicon_sequence_markers bool 1  √  true
cxgn_production_visible go bool 1  √  false
cxgn_production_visible group_linkage bool 1  √  false
cxgn_production_visible groups bool 1  √  false
cxgn_production_visible id_linkage bool 1  √  false
cxgn_production_visible interpro bool 1  √  false
cxgn_production_visible interpro_go bool 1  √  false
cxgn_production_visible library bool 1  √  false
cxgn_production_visible linkage_group bool 1  √  false
cxgn_production_visible loc_types bool 1  √  false
cxgn_production_visible manual_annotations bool 1  √  false
cxgn_production_visible manual_censor_reasons bool 1  √  false
cxgn_production_visible map bool 1  √  false
cxgn_production_visible map_version bool 1  √  false
cxgn_production_visible marker bool 1  √  false
cxgn_production_visible marker_alias bool 1  √  false
cxgn_production_visible marker_collectible bool 1  √  false
cxgn_production_visible marker_collection bool 1  √  false
cxgn_production_visible marker_confidence bool 1  √  false
cxgn_production_visible marker_derived_from bool 1  √  false
cxgn_production_visible marker_experiment bool 1  √  false
cxgn_production_visible marker_location bool 1  √  false
cxgn_production_visible microarray bool 1  √  false
cxgn_production_visible misc bool 1  √  false
cxgn_production_visible organism bool 1  √  false
cxgn_production_visible p_markers bool 1  √  false
cxgn_production_visible pcr_exp_accession bool 1  √  false
cxgn_production_visible pcr_experiment bool 1  √  false
cxgn_production_visible pcr_product bool 1  √  false
cxgn_production_visible primer_unigene_match bool 1  √  false
cxgn_production_visible qc_report bool 1  √  false
cxgn_production_visible rflp_markers bool 1  √  false
cxgn_production_visible rflp_sequences bool 1  √  false
cxgn_production_visible rflp_unigene_associations bool 1  √  false
cxgn_production_visible seqread bool 1  √  false
cxgn_production_visible sequence bool 1  √  false
cxgn_production_visible ssr bool 1  √  false
cxgn_production_visible ssr_primer_unigene_matches bool 1  √  false
cxgn_production_visible ssr_repeats bool 1  √  false
cxgn_production_visible submit_user bool 1  √  false
cxgn_production_visible temp_caps_correspondence bool 1  √  false
cxgn_production_visible temp_map_correspondence bool 1  √  false
cxgn_production_visible temp_marker_correspondence bool 1  √  false
cxgn_production_visible tigrtc_index bool 1  √  false
cxgn_production_visible tigrtc_membership bool 1  √  false
cxgn_production_visible tigrtc_tracking bool 1  √  false
cxgn_production_visible tm_markers bool 1  √  false
cxgn_production_visible tm_markers_sequences bool 1  √  false
cxgn_production_visible trim_feature bool 1  √  false
cxgn_production_visible trim_feature_types bool 1  √  false
cxgn_production_visible types bool 1  √  false
cxgn_production_visible unigene bool 1  √  false
cxgn_production_visible unigene_build bool 1  √  false
cxgn_production_visible unigene_consensi bool 1  √  false
cxgn_production_visible unigene_member bool 1  √  false
database_name cosii_ortholog varchar 11  √  null
database_name family_member varchar 20  √  null
database_name unigene varchar 2147483647 'SGN'::character varying
date est date 13  √  null
date seqread timestamp 29,6 ('now'::text)::timestamp(6) with time zone
date_entered manual_annotations date 13  √  null
date_loaded map_version date 13  √  null
db_name blast_targets varchar 80  √  null
db_path blast_targets varchar 255  √  null
default_threshold deprecated_maps int8 19 (0)::bigint
default_threshold map_version int4 10  √  null
deprecated_marker_confidences.confidence_id map_version_default_threshold_fkey
defline blast_defline text 2147483647  √  null
defline_fulltext blast_defline tsvector 2147483647  √  null
defline_id blast_defline serial 10  √  nextval('blast_defline_defline_id_seq'::regclass)
defline_id blast_hits int4 10  √  null
density fish_chromatin_density_constants float4 8,8  √  null
deprecated_by deprecated_maps int8 19  √  (0)::bigint
derived_from_source_id derived_from_source serial 10  √  nextval('derived_from_source_derived_from_source_id_seq'::regclass)
marker_derived_from.derived_from_source_id marker_derived_from_derived_from_source_id_fkey
derived_from_source_id marker_derived_from int4 10  √  null
derived_from_source.derived_from_source_id marker_derived_from_derived_from_source_id_fkey
description cos_markers text 2147483647  √  null
description deprecated_marker_types text 2147483647  √  null
description domain text 2147483647  √  null
description experiment_type text 2147483647  √  null
description go text 2147483647  √  null
description interpro text 2147483647  √  null
description_fulltext domain tsvector 2147483647  √  null
description_fulltext go tsvector 2147483647  √  null
description_fulltext interp