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
|