MATCH_HOST_SW_PROD_DET - Host-Software detailed information matched
|
|
Legend: |
Primary key columns |
Columns with indexes |
Implied relationships |
Excluded column relationships |
< n > number of related tables |
|
|
Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
ID |
number |
0 |
√ |
|
null |
|
|
HOST_ID |
number |
0 |
√ |
|
null |
|
|
HOSTNAME |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_UUID |
number |
18 |
√ |
|
null |
|
|
DISCOVERED_ID |
nvarchar2 |
100 |
√ |
|
null |
|
|
CAT_MANUFACTURER_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_PRODUCT_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_EDITION_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_VERSION_GROUP_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_VERSION_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_RELEASE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_TAXONOMY2012_ID |
number |
18 |
√ |
|
null |
|
|
CAT_CPE_URI_ID |
number |
18 |
√ |
|
null |
|
|
SUITE_ID |
number |
0 |
√ |
|
null |
|
|
IS_SUITE |
varchar2 |
1 |
√ |
|
null |
|
|
GROUP_ID |
number |
0 |
√ |
|
null |
|
|
DISCOVERED_NAME |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_VERSION |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_PUBLISHER |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_INSTALLDATE |
date |
7 |
√ |
|
null |
|
|
ORIGINATE_FROM |
number |
0 |
√ |
|
null |
|
|
SOURCE_BITMAP |
number |
0 |
√ |
|
null |
|
|
IS_MAPPED |
varchar2 |
1 |
√ |
|
null |
|
|
HIDDEN |
number |
0 |
√ |
|
null |
|
|
HIDDEN_REASON |
varchar2 |
1000 |
√ |
|
null |
|
|
IS_MAJOR_RELEASE |
varchar2 |
3 |
√ |
|
null |
|
|
CAT_SW_MAJOR_RELEASE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_MAJOR_VERSION |
varchar2 |
64 |
√ |
|
null |
|
|
IS_LATEST |
number |
0 |
√ |
|
null |
|
|
LATEST_CAT_SW_UUID |
number |
18 |
√ |
|
null |
|
|
DEDUP_ID |
number |
18 |
√ |
|
null |
|
|
IS_MERGED |
varchar2 |
3 |
√ |
|
null |
|
|
MATCH_HOST_SW_PROD_RN |
number |
18 |
√ |
|
null |
|
|
TASK_ID |
number |
18 |
√ |
|
null |
|
|
INVENTORY_ID |
number |
18 |
√ |
|
null |
|
|
DATASRC |
varchar2 |
25 |
√ |
|
null |
|
|
Analyzed at Thu Jul 20 12:13 PDT 2017
|
View Definition:
SELECT DISC_SW_PROD_ID ID,HOST_ID,HOSTNAME,CAT_SW_UUID,DISCOVERED_ID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,
CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,IS_SUITE,
GROUP_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,DISCOVERED_INSTALLDATE,ORIGINATE_FROM,SOURCE_BITMAP,
IS_MAPPED,HIDDEN,HIDDEN_REASON,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,IS_LATEST,LATEST_CAT_SW_UUID,
DEDUP_ID,IS_MERGED,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC
FROM MATCH_HOST_SW_PROD_ALL