Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleINVENTORY_AGENT_CLUSTERS
FieldNullableData typeConstraintUnique Constraint Description
IDNOT NULLNUMERICPrimary Key  
INSTANCE_IDNOT NULLNUMERICForeign Key 

references INVENTORY_INSTANCES.ID

PROCESS_CLASS_ID
NOT NULLNUMERICForeign Key  X

references INVENTORY_PROCESS_CLASSES.ID

SCHEDULING_TYPE
NOT NULLVARCHAR  

 

NUMBER_OF_AGENTS
NOT NULLNUMERIC   
CREATEDNOT NULLDATETIME  UTC timestamp of record creation
MODIFIEDNOT NULLDATETIME  UTC timestamp of record modification
Expand
titleINVENTORY_AGENT_INSTANCES
FieldNullableData typeConstraintUnique Constraint Description
IDNOT NULLNUMERICPrimary Key  
INSTANCE_IDNOT NULLNUMERICForeign Key  X

references INVENTORY_INSTANCES.ID

OS_ID
NOT NULLNUMERICForeign Key 

references INVENTORY_OPERATING_SYSTEMS.ID

HOSTNAME
NOT NULLVARCHAR  

 

VERSION
NOT NULLVARCHAR   
URL
 VARCHAR   X 
STATE
 NUMERIC    
STARTED_AT
 DATETIME    
CREATEDNOT NULLDATETIME  UTC timestamp of record creation
MODIFIEDNOT NULLDATETIME  UTC timestamp of record modification
Expand
titleINVENTORY_APPLIED_LOCKS
FieldNullableData typeConstraintUnique Constraint Description
IDNOT NULLNUMERICPrimary Key  
JOB_IDNOT NULLNUMERICForeign Key  X

references INVENTORY_JOBS.ID

LOCK_ID
NOT NULLNUMERICForeign Key X

references INVENTORY_LOCKS.ID

CREATEDNOT NULLDATETIME  UTC timestamp of record creation
MODIFIEDNOT NULLDATETIME  UTC timestamp of record modification

...