sp_project_person

0 rows


Columns

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

Indexes

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

Check Constraints

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

Relationships

Close relationships within degrees of separation