| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| EVT_ASSET_ID |
number |
22 |
|
|
|
|
|
| CUST_ID |
number |
22 |
√ |
|
null |
|
| CUST.CUST_ID
|
Implied Constraint |
|
| CUST_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| ASSET_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| PHYSICAL_ASSET_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| REF_ASSET_ID |
varchar2 |
300 |
√ |
|
null |
|
|
| MAC_ADDR |
varchar2 |
300 |
√ |
|
null |
|
|
| RACK_NUM |
varchar2 |
150 |
√ |
|
null |
|
|
| ROOM_NAME |
varchar2 |
300 |
√ |
|
null |
|
|
| BUILDING_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| CITY |
varchar2 |
300 |
√ |
|
null |
|
|
| STATE |
varchar2 |
300 |
√ |
|
null |
|
|
| CNTRY |
varchar2 |
300 |
√ |
|
null |
|
|
| ZIP_CD |
varchar2 |
150 |
√ |
|
null |
|
|
| ASSET_CTGRY_NAME |
varchar2 |
300 |
√ |
|
null |
|
|
| NETWORK_IDENTITY_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| ENV_IDENTITY_NAME |
varchar2 |
765 |
√ |
|
null |
|
|
| ASSET_VAL_NAME |
varchar2 |
150 |
√ |
|
null |
|
|
| CRIT_NAME |
varchar2 |
150 |
√ |
|
null |
|
|
| SENSITIVITY_NAME |
varchar2 |
150 |
√ |
|
null |
|
|
| CONTACT_NAME_1 |
varchar2 |
765 |
√ |
|
null |
|
|
| CONTACT_NAME_2 |
varchar2 |
765 |
√ |
|
null |
|
|
| ORGANIZATION_NAME_1 |
varchar2 |
300 |
√ |
|
null |
|
|
| ORGANIZATION_NAME_2 |
varchar2 |
300 |
√ |
|
null |
|
|
| ORGANIZATION_NAME_3 |
varchar2 |
300 |
√ |
|
null |
|
|
| ORGANIZATION_NAME_4 |
varchar2 |
300 |
√ |
|
null |
|
|
| DATE_CREATED |
date |
7 |
√ |
|
null |
|
|
| DATE_MODIFIED |
date |
7 |
√ |
|
null |
|
|
| CREATED_BY |
number |
22 |
√ |
|
null |
|
|
| MODIFIED_BY |
number |
22 |
√ |
|
null |
|
|
Table contained 138 rows at Tue May 04 17:09 EDT 2010
|
