Table BDNA_PUBLISH.dbo.MATCH_TASK_DET
Has Normalize task details information

 Generated by
SchemaSpy
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
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.TASK_ID FK0_DISC_COMPUTERSYSTEM R
DISC_CS_CAT_MAP.TASK_ID FK1_DISC_CS_CAT_MAP R
DISC_HOSTS.TASK_ID FK0_DISC_HOSTS R
DISC_OS_CAT_MAP.TASK_ID FK0_DISC_OS_CAT_MAP R
MATCH_ALL_ADDREMOVE.TASK_ID FK1_MATCH_ALL_ADDREMOVE R
MATCH_ALL_EXE.TASK_ID FK1_MATCH_ALL_EXE R
MATCH_HOST_HW_PROD_MODEL.TASK_ID FK1_MATCH_HOST_HW_PROD_MODEL R
MATCH_HOST_SW_PROD.TASK_ID FK6_MATCH_HOST_SW_PROD R
MATCH_HOST_SW_PROD_DET.TASK_ID FK6_MATCH_HOST_SW_PROD_DET R
MATCH_SOFTWARE_METERING.TASK_ID FK4_MATCH_SOFTWARE_METERING R
Task Id for this task
TASK_NAME varchar 256  √  null Task name for this task
PROCESS_STATUS varchar 20  √  null process status for this task
ERROR_CODE varchar 256  √  null error code for this task
ERROR_DESCRIPTION varchar 4000  √  null error description for this task
IMPORT_BEGIN_ON datetime 16,3  √  null import begin timestamp for this task
IMPORT_END_ON datetime 16,3  √  null import end timestamp for this task
MAPPING_BEGIN_ON datetime 16,3  √  null mapping begin timestamp for this task
MAPPING_END_ON datetime 16,3  √  null mapping end timestamp for this task
INVENTORY_ID float 8  √  null
MATCH_INVENTORY.INVENTORY_ID FK0_MATCH_TASK_DET R
Inventory Id for this task

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
TASK_ID Primary key Asc PK_MATCH_TASK_DET

Close relationships  within of separation: