Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
asset_id |
uuid |
2147483647 |
√ |
|
null |
|
asset.asset_id
|
Implied Constraint R |
|
cust_id |
int8 |
19 |
√ |
|
null |
|
cust.cust_id
|
Implied Constraint R |
|
asset_name |
varchar |
255 |
√ |
|
null |
|
|
physical_asset_id |
uuid |
2147483647 |
√ |
|
null |
|
|
product_id |
int8 |
19 |
√ |
|
null |
|
|
asset_category_id |
int8 |
19 |
√ |
|
null |
|
|
environment_identity_cd |
int8 |
19 |
√ |
|
null |
|
|
physical_asset_ind |
bool |
1 |
√ |
|
null |
|
|
asset_value_code |
int8 |
19 |
√ |
|
null |
|
|
criticality_id |
int8 |
19 |
√ |
|
null |
|
|
sensitivity_id |
int8 |
19 |
√ |
|
null |
|
|
date_created |
timestamptz |
35,6 |
√ |
|
null |
|
|
date_modified |
timestamptz |
35,6 |
√ |
|
null |
|
|
created_by |
int4 |
10 |
√ |
|
null |
|
|
modified_by |
int4 |
10 |
√ |
|
null |
|
|
Analyzed at Mon Mar 26 23:24 EDT 2012
|