locus_dbxref_evidence_history

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locus_dbxref_evidence_history_id serial 10 √ nextval('phenome.locus_dbxref_evidence_history_locus_dbxref_evidence_history_seq'::regclass)
locus_dbxref_evidence_id int4 10 √ null
locus_dbxref_evidence.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_history_locus_dbxref_id_fkey R
relationship_type int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_history_relationship_type_fkey R
evidence_code int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_history_evidence_code_fkey R
evidence_description int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_history_evidence_description_fkey R
evidence_with int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_history_evidence_with_fkey R
reference_id int4 10 √ null
dbxref.dbxref_id locus_dbxref_evidence_history_reference_id_fkey R
sp_person_id int4 10 √ null
sp_person.sp_person_id locus_dbxref_evidence_history_sp_person_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id locus_dbxref_evidence_history_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_history_pkey Primary key Asc locus_dbxref_evidence_history_id

Relationships

Close relationships within degrees of separation