| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('app_perform_goal_id_seq'::regclass) |
|
|
||||||||
| context_id | int8 | 19 | null |
|
|
|||||||||
| category_id | int8 | 19 | null |
|
|
|||||||||
| owner_id | int8 | 19 | √ | null |
|
|
||||||||
| user_id | int8 | 19 | √ | null |
|
|
||||||||
| name | varchar | 1024 | ''::character varying |
|
|
|||||||||
| id_number | varchar | 100 | √ | null |
|
|
||||||||
| description | text | 2147483647 | √ | null |
|
|
||||||||
| start_date | int8 | 19 | null |
|
|
|||||||||
| target_type | varchar | 100 | ''::character varying |
|
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| app_perfgoal_id_pk | Primary key | Asc | id |
| app_perfgoal_cat_ix | Performance | Asc | category_id |
| app_perfgoal_clo_ix | Performance | Asc | closed_at |
| app_perfgoal_con_ix | Performance | Asc | context_id |
| app_perfgoal_id__ix | Performance | Asc | id_number |
| app_perfgoal_own_ix | Performance | Asc | owner_id |
| app_perfgoal_sta2_ix | Performance | Asc | status |
| app_perfgoal_sta3_ix | Performance | Asc | status_updated_at |
| app_perfgoal_sta_ix | Performance | Asc | start_date |
| app_perfgoal_tar_ix | Performance | Asc | target_date |
