Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| associd | int8 | 19 | √ | null |
|
|
|||||
| assetid | int8 | 19 | √ | null |
|
|
|||||
| cteid | int8 | 19 | √ | null |
|
|
|||||
| startdate | date | 13 | √ | null |
|
|
|||||
| endate | date | 13 | √ | null |
|
|
|||||
| originalamount | float8 | 17,17 | √ | null |
|
|
|||||
| finamountin | float8 | 17,17 | √ | null |
|
|
|||||
| finamountout | float8 | 17,17 | √ | null |
|
|
|||||
| cteorder | int4 | 10 | √ | null |
|
|
|||||
| ctestatus | varchar | 10 | √ | null |
|
|
|||||
| ctrid | int8 | 19 | √ | null |
|
|
|||||
| propreference | varchar | 30 | √ | null |
|
|
|||||
| ctreference | varchar | 30 | √ | null |
|
|
|||||
| ctstatus | varchar | 10 | √ | null |
|
|
|||||
| tpname | varchar | 100 | √ | null |
|
|
|||||
| tpreference | varchar | 30 | √ | null |
|
|
|||||
| tpid | int8 | 19 | √ | null |
|
|