locusgroup_member

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locusgroup_member_id serial 10 nextval('phenome.locusgroup_member_locusgroup_member_id_seq'::regclass)
locusgroup_id int4 10 null
locusgroup.locusgroup_id locusgroup_member_locusgroup_id_fkey R
locus_id int4 10 null
locus.locus_id locusgroup_member_locus_id_fkey C
direction varchar 16 null
evidence_id int4 10 null
cvterm.cvterm_id locusgroup_member_evidence_id_fkey R
reference_id int4 10 null
dbxref.dbxref_id locusgroup_member_reference_id_fkey R
sp_person_id int4 10 null
sp_person.sp_person_id locusgroup_member_sp_person_id_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)
locusgroup_member_pkey Primary key Asc locusgroup_member_id
locusgroup_member_key Must be unique Asc/Asc locus_id + locusgroup_id

Check Constraints

Constraint Name Constraint
locusgroup_member_direction_check ((((direction)::text = 'subject'::text) OR ((direction)::text = 'object'::text) OR ((direction)::text = ''::text)))

Relationships