Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ratid | bigserial | 19 | √ | nextval('tbl_probratingmasterpms_ratid_seq'::regclass) |
|
|
|||||
| employeeid | varchar | 50 | √ | null |
|
|
|||||
| emprat | numeric | 0 | √ | null |
|
|
|||||
| rep1id | varchar | 50 | √ | null |
|
|
|||||
| ret1rat | numeric | 0 | √ | null |
|
|
|||||
| rep2id | varchar | 50 | √ | null |
|
|
|||||
| rep2rat | numeric | 0 | √ | null |
|
|
|||||
| formid | int8 | 19 | √ | null |
|
|
|||||
| catid | int8 | 19 | √ | null |
|
|
|||||
| questionid | int8 | 19 | √ | null |
|
|
|||||
| subquestionid | int8 | 19 | √ | null |
|
|
|||||
| column1 | varchar | 500 | √ | null |
|
|
|||||
| column2 | int8 | 19 | √ | null |
|
|
|||||
| column3 | varchar | 500 | √ | null |
|
|
|||||
| column4 | varchar | 500 | √ | null |
|
|
|||||
| isemprat | bool | 1 | √ | false |
|
|
|||||
| isrep1rat | bool | 1 | √ | false |
|
|
|||||
| isrep2rat | bool | 1 | √ | false |
|
|
|||||
| effectivedate | timestamp | 29,6 | √ | null |
|
|
|||||
| isopenended | bool | 1 | √ | false |
|
|
|||||
| openanswer | varchar | 2000 | √ | null |
|
|
|||||
| empanswer | varchar | 2000 | √ | null |
|
|
|||||
| rep1answer | varchar | 2000 | √ | null |
|
|
|||||
| rep2answer | varchar | 2000 | √ | null |
|
|
|||||
| column5 | int4 | 10 | √ | null |
|
|
|||||
| column6 | varchar | 500 | √ | null |
|
|
|||||
| createdby | varchar | 50 | √ | null |
|
|
|||||
| createddate | timestamp | 29,6 | √ | null |
|
|
|||||
| modifiedby | varchar | 50 | √ | null |
|
|
|||||
| modifieddate | timestamp | 29,6 | √ | null |
|
|
|||||
| pms_goal_list_id | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_probratingmasterpms_pk_tbl_probratingmasterpms | Primary key | Asc | ratid |



