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 |
|
|