Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| attdatatype | varchar | 10 | √ | null |
|
|
|||||
| attinputtype | varchar | 10 | √ | null |
|
|
|||||
| parcode | varchar | 10 | √ | null |
|
|
|||||
| attcodeparent | varchar | 10 | √ | null |
|
|
|||||
| style | varchar | 200 | √ | null |
|
|
|||||
| colspan | int4 | 10 | √ | null |
|
|
|||||
| attnbrows | int4 | 10 | √ | null |
|
|
|||||
| entity | varchar | 10 | √ | null |
|
|
|||||
| entitytype | varchar | 10 | √ | null |
|
|
|||||
| prcode | varchar | 10 | √ | null |
|
|
|||||
| assetfamily | varchar | 10 | √ | null |
|
|
|||||
| assettype | varchar | 10 | √ | null |
|
|
|||||
| assetcategory | varchar | 10 | √ | null |
|
|
|||||
| attcode | varchar | 10 | √ | null |
|
|
|||||
| defautvalue | varchar | 30 | √ | null |
|
|
|||||
| minvalue | varchar | 30 | √ | null |
|
|
|||||
| maxvalue | varchar | 30 | √ | null |
|
|
|||||
| displaytype | varchar | 10 | √ | null |
|
|
|||||
| displaysection | varchar | 100 | √ | null |
|
|
|||||
| displayposition | varchar | 10 | √ | null |
|
|
|||||
| displayorder | int4 | 10 | √ | null |
|
|
|||||
| assetsegment | varchar | 10 | √ | null |
|
|
|||||
| assetmodel | varchar | 10 | √ | null |
|
|