list

36 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
list_id bigserial 19 √ nextval('sgn_people.list_list_id_seq'::regclass)
list_dbxref.list_id list_dbxref_list_id_fkey C
list_item.list_id list_item_list_id_fkey C
listprop.list_id listprop_list_id_fkey R
is_hotlist bool 1 √ false
sent_by int4 10 √ null
name varchar 128 √ null
description text 2147483647 √ null
owner int4 10 √ null
sp_person.sp_person_id list_owner_fkey C
type_id int8 19 √ null
cvterm.cvterm_id list_type_id_fkey R
is_public bool 1 false
create_date timestamp 29,6 √ now()
modified_date timestamp 29,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
list_pkey Primary key Asc list_id
list_id_unique Must be unique Asc list_id

Relationships

Close relationships within degrees of separation