individual_dbxref_evidence

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
individual_dbxref_evidence_id serial 10 √ nextval('phenome.individual_dbxref_evidence_individual_dbxref_evidence_id_seq'::regclass)
individual_dbxref_evidence_history.individual_dbxref_evidence_id individual_dbxref_evidence_hi_individual_dbxref_evidence_i_fkey R
individual_dbxref_id int4 10 √ null
individual_dbxref.individual_dbxref_id individual_dbxref_evidence_individual_dbxref_id_fkey R
relationship_type int4 10 √ null
dbxref.dbxref_id individual_dbxref_evidence_relationship_type_fkey R
evidence_code int4 10 √ null
dbxref.dbxref_id individual_dbxref_evidence_evidence_code_fkey R
evidence_description int4 10 √ null
dbxref.dbxref_id individual_dbxref_evidence_evidence_description_fkey R
evidence_with int4 10 √ null
dbxref.dbxref_id individual_dbxref_evidence_evidence_with_fkey R
reference_id int4 10 √ null
dbxref.dbxref_id individual_dbxref_evidence_reference_id_fkey R
sp_person_id int4 10 √ null
sp_person.sp_person_id individual_dbxref_evidence_sp_person_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id individual_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)
individual_dbxref_evidence_pkey Primary key Asc individual_dbxref_evidence_id

Relationships

Close relationships within degrees of separation