Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| paidunpaidperformancerewardsid | bigserial | 19 | √ | nextval('tbl_paidunpaidperformancerewa_paidunpaidperformancerewardsi_seq'::regclass) |
|
|
|||||
| employeeid | varchar | 50 | √ | null |
|
|
|||||
| month | int4 | 10 | √ | null |
|
|
|||||
| year | int4 | 10 | √ | null |
|
|
|||||
| rewardtypeon | varchar | 500 | √ | null |
|
|
|||||
| peroramt | numeric | 0 | √ | null |
|
|
|||||
| pramount | numeric | 0 | √ | null |
|
|
|||||
| calculateddate | timestamp | 29,6 | √ | null |
|
|
|||||
| prstatus | bool | 1 | √ | false |
|
|
|||||
| paiddate | timestamp | 29,6 | √ | null |
|
|
|||||
| companyid | int4 | 10 | √ | null |
|
|
|||||
| other1 | varchar | 500 | √ | null |
|
|
|||||
| other2 | varchar | 500 | √ | null |
|
|
|||||
| other3 | numeric | 0 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_paidunpaidperformancerewards_pk_tbl_paidunpaidperformancere | Primary key | Asc | paidunpaidperformancerewardsid |
Relationships
Close relationships within degrees of separation
