MATCH_HOST_SW_PROD - Host-Software 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 |
DISC_SW_PROD_ID |
number |
0 |
√ |
|
null |
|
|
HOST_ID |
number |
0 |
√ |
|
null |
|
|
HOSTNAME |
varchar2 |
255 |
√ |
|
null |
|
|
DISCOVERED_ID |
nvarchar2 |
100 |
√ |
|
null |
|
|
DISCOVERED_NAME |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_VERSION |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_PUBLISHER |
nvarchar2 |
1024 |
√ |
|
null |
|
|
DISCOVERED_INSTALLDATE |
date |
7 |
√ |
|
null |
|
|
CAT_MANUFACTURER |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_PRODUCT_NAME |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_PRODUCT_FAMILY |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_PRODUCT_NFAMILY |
number |
0 |
√ |
|
null |
|
|
CAT_COMPONENT |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_PATCHLEVEL |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_VERSION |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_SUBVERSION |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_VERSION_GROUP |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_EDITION |
varchar2 |
2000 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY1 |
varchar2 |
256 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY2 |
varchar2 |
256 |
√ |
|
null |
|
|
IS_SUITE |
varchar2 |
1 |
√ |
|
null |
|
|
CAT_LICENSABLE |
varchar2 |
50 |
√ |
|
null |
|
|
CAT_LICENSABLE_DETAIL |
varchar2 |
50 |
√ |
|
null |
|
|
CAT_GA_DATE |
date |
7 |
√ |
|
null |
|
|
CAT_SW_UUID |
number |
18 |
√ |
|
null |
|
|
CAT_MANUFACTURER_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_PRODUCT_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_SW_EDITION_ID |
number |
18 |
√ |
|
null |
|
|
CAT_TAXONOMY2012_ID |
number |
18 |
√ |
|
null |
|
|
CAT_CPE_URI_ID |
number |
18 |
√ |
|
null |
|
|
SUITE_ID |
number |
0 |
√ |
|
null |
|
|
GROUP_ID |
number |
0 |
√ |
|
null |
|
|
IS_MAJOR_RELEASE |
varchar2 |
3 |
√ |
|
null |
|
|
CAT_SW_MAJOR_RELEASE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_MAJOR_VERSION |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_MAJOR_VERSION_GROUP |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_MAJOR_UUID |
number |
18 |
√ |
|
null |
|
|
IS_LATEST |
number |
0 |
√ |
|
null |
|
|
LATEST_CAT_SW_UUID |
number |
18 |
√ |
|
null |
|
|
DEDUP_ID |
number |
18 |
√ |
|
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,HOST_ID,HOSTNAME,DISCOVERED_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,
DISCOVERED_INSTALLDATE,CAT_MANUFACTURER,CAT_PRODUCT_NAME,CAT_PRODUCT_FAMILY,CAT_PRODUCT_NFAMILY,CAT_COMPONENT,CAT_PATCHLEVEL,
CAT_VERSION,CAT_SW_SUBVERSION,CAT_VERSION_GROUP,CAT_EDITION,CAT_TAXONOMY_CATEGORY1,CAT_TAXONOMY_CATEGORY2,IS_SUITE,CAT_LICENSABLE,
CAT_LICENSABLE_DETAIL,CAT_GA_DATE,CAT_SW_UUID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,
CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,
GROUP_ID,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,CAT_MAJOR_VERSION_GROUP,CAT_SW_MAJOR_UUID,
IS_LATEST,LATEST_CAT_SW_UUID,DEDUP_ID,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC
FROM MATCH_HOST_SW_PROD_ALL
WHERE hidden=0
Possibly Referenced Tables/Views: