Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| opid | int8 | 19 | √ | null |
|
|
|||||
| offerid | int8 | 19 | √ | null |
|
|
|||||
| prcode | varchar | 10 | √ | null |
|
|
|||||
| assettype | varchar | 10 | √ | null |
|
|
|||||
| assetcategory | varchar | 10 | √ | null |
|
|
|||||
| catalogid | int8 | 19 | √ | null |
|
|
|||||
| offerpricingstatus | varchar | 10 | √ | null |
|
|
|||||
| startdate | date | 13 | √ | null |
|
|
|||||
| enddate | date | 13 | √ | null |
|
|
|||||
| packid | int8 | 19 | √ | null |
|
|
|||||
| packlabel | varchar | 100 | √ | null |
|
|
|||||
| packdescription | varchar | 500 | √ | null |
|
|
|||||
| priid | int8 | 19 | √ | null |
|
|
|||||
| ctetype | varchar | 10 | √ | null |
|
|
|||||
| prilabel | varchar | 250 | √ | null |
|
|
|||||
| pridescription | varchar | 500 | √ | null |
|
|
|||||
| assetlabel | text | 2147483647 | √ | null |
|
|
|||||
| assetdescription | text | 2147483647 | √ | null |
|
|
|||||
| assetconstructorreference | text | 2147483647 | √ | null |
|
|
|||||
| assetnetamount | int4 | 10 | √ | null |
|
|
|||||
| assetgrossamount | int4 | 10 | √ | null |
|
|
|||||
| assetconstructor | int4 | 10 | √ | null |
|
|
|||||
| assetmodel | text | 2147483647 | √ | null |
|
|
|||||
| assetvariant | text | 2147483647 | √ | null |
|
|
|||||
| assetpictureurl | text | 2147483647 | √ | null |
|
|
|||||
| tpidsupplier | int4 | 10 | √ | null |
|
|
|||||
| catalogstatus | text | 2147483647 | √ | null |
|
|
|||||
| offerlabel | varchar | 250 | √ | null |
|
|