sp_project_person - cxgn_breedbase.sgn

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

sp_project_person_id

serial

10

√

nextval('sgn_people.sp_project_person_sp_project_person_id_seq'::regclass)

sp_project_id

int8

19

√

null

sp_project.sp_project_id

sp_project_person_sp_project_id_fkey

R

sp_person_id

int8

19

√

null

sp_person.sp_person_id

person_id_fk

R

type

varchar

6

√

null

Showing 1 to 4 of 4 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
sp_project_person_pkey	Primary key	Asc	sp_project_person_id

Showing 1 to 1 of 1 entries

Check Constraints

Search:

Constraint Name	Constraint
chk_sp_project_person_type	((((type)::text = 'PI'::text) OR ((type)::text = 'co-PI'::text) OR ((type)::text = 'Member'::text) OR ((type)::text = ''::text) OR (type IS NULL)))

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees