list - cxgn_breedbase.sgn

Columns

Related columns Constraint Comments

Search:

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()

Showing 1 to 10 of 10 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees