BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_CLOUD_INSTANCE - Mapped Instance data

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 Comments
HOST_ID number 0  √  null Unique host ID
INSTANCE_TYPE nvarchar2 256  √  null Instance Type
ARN nvarchar2 256  √  null Amazon Resource Name (Instanceid + Ownerid + Region)
INSTANCE_OWNER_ID nvarchar2 256  √  null Instance Owner ID
IMAGE_ID nvarchar2 256  √  null ID of the AMI used to launch the instance
IMAGE_NAME nvarchar2 256  √  null Name of the Image
IMAGE_DESC nvarchar2 1024  √  null Description of the Image
CAT_CLOUD_OFFERING_ID number 18  √  null Unique Cloud Offering ID from Technopedia
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + HOST_ID Primary key Asc/Asc/Asc PK_MATCH_HOST_CLOUD_INSTANCE These unique columns are also nullable
Confidential and Proprietary to BDNA