locus_dbxref_evidence

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locus_dbxref_evidence_id serial 10 √ nextval('phenome.locus_dbxref_evidence_locus_dbxref_evidence_id_seq'::regclass)
locus_dbxref_evidence_history.locus_dbxref_evidence_id locus_dbxref_evidence_history_locus_dbxref_evidence_id_fkey R
locus_dbxref_id int4 10 √ null
locus_dbxref.locus_dbxref_id locus_dbxref_evidence_locus_dbxref_id_fkey R
relationship_type_id int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_evidence_relationship_type_id_fkey R
evidence_code_id int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_evidence_code_id_fkey R
evidence_description_id int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_evidence_description_id_fkey R
evidence_with int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_evidence_with_fkey R
reference_id int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_reference_id_fkey R
sp_person_id int4 10 √ null
sp_person.sp_person_id locus_dbxref_evidence_sp_person_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id locus_dbxref_evidence_updated_by_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
obsolete bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
locus_dbxref_evidence_pkey Primary key Asc locus_dbxref_evidence_id

Relationships

Close relationships within degrees of separation