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_person_id | int8 | 19 | √ | null |
|
|
|||||
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))) |