| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| id |
bigserial |
19 |
|
√ |
nextval('app_prog_future_user_assignment_id_seq'::regclass) |
|
|
|
| programid |
int8 |
19 |
√ |
|
null |
|
|
|
| userid |
int8 |
19 |
√ |
|
null |
|
|
|
| assignmentid |
int8 |
19 |
√ |
|
null |
|
|
|
| Constraint Name |
Type |
Sort |
Column(s) |
| app_progfutuuserassi_id_pk |
Primary key |
Asc |
id |
| app_progfutuuserassi_ass_ix |
Performance |
Asc |
assignmentid |
| app_progfutuuserassi_pro_ix |
Performance |
Asc |
programid |
| app_progfutuuserassi_prous_uix |
Must be unique |
Asc/Asc/Asc |
programid + userid + assignmentid |
| app_progfutuuserassi_use_ix |
Performance |
Asc |
userid |
Diagram producer might be missing
No diagrams were produced please see application output for any errors