locus

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locus_id serial 10 √ nextval('phenome.locus_locus_id_seq'::regclass)
allele.locus_id allele_locus_id_fkey R
allele_history.locus_id allele_history_locus_id_fkey C
individual_locus.locus_id individual_locus_locus_id_fkey R
locus2locus.object_id locus2locus_object_id_fkey R
locus2locus.subject_id locus2locus_subject_id_fkey R
locus_alias.locus_id locus_alias_locus_id_fkey R
locus_dbxref.locus_id locus_dbxref_locus_id_fkey R
locus_history.locus_id locus_history_locus_id_fkey C
locus_image.locus_id locus_image_locus_id_fkey R
locus_marker.locus_id locus_marker_locus_id_fkey R
locus_owner.locus_id locus_owner_locus_id_fkey C
locus_pub_ranking.locus_id locus_pub_ranking_locus_id_fkey R
locus_pub_ranking_validate.locus_id locus_pub_ranking_validate_locus_id_fkey R
locus_registry.locus_id locus_registry_locus_id_fkey R
locus_unigene.locus_id locus_unigene_locus_id_fkey R
locusgroup_member.locus_id locusgroup_member_locus_id_fkey C
variant.locus_id variant_locus_id_fkey R
locus_name varchar 255 null
locus_symbol varchar 32 null
original_symbol varchar 32 √ null
gene_activity text 2147483647 √ null
locus_notes text 2147483647 √ null
obsolete bool 1 √ false
sp_person_id int4 10 √ null
sp_person.sp_person_id locus_sp_person_id_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
description text 2147483647 √ null
linkage_group varchar 16 √ null
lg_arm varchar 16 √ null
common_name_id int4 10 null
common_name.common_name_id locus_common_name_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id locus_updated_by_fkey R
locus varchar 24 √ null
organism_id int4 10 √ null
organism.organism_id locus_organism_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
locus_pkey Primary key Asc locus_id
locus_name_key Must be unique Asc/Asc/Asc locus_name + common_name_id + obsolete
locus_symbol_key Must be unique Asc/Asc/Asc locus_symbol + common_name_id + obsolete

Check Constraints

Constraint Name Constraint
chk_lg_arm ((((lg_arm)::text = 'short'::text) OR ((lg_arm)::text = 'long'::text) OR ((lg_arm)::text = ''::text)))

Relationships

Close relationships within degrees of separation