Previous Topic: IDTypeNext Topic: MachineRole


WgnMachine

This table contains all details of machines accounts for machines in the CMS machine hierarchy.

Column

Primary Key

Datatype

Length

Notes

MachineIDM

Part-key that uniquely identifies a machine.

Yes

INTEGER

4

None

MachineID

Part-key that uniquely identifies a machine.

Yes

INTEGER

4

 

MachineName

The name of the machine.

 

VARCHAR

64

There may be only one active (non-deleted) machine with this name at any one time.

PolicyIDM

Part-key identifying the machines policy document.

 

INTEGER

4

Foreign key: WgnPolicy

PolicyID

Part-key identifying the machines policy document.

 

INTEGER

4

Foreign key: WgnPolicy

MachineCreateTime

The time at which the machine account was created.

 

TIMESTAMP

8

 

MachineRole

The role of the machine (eg, CMS).

 

INTEGER

4

Follow the hyperlink for details.

MachineAttributes

Bitmap of machine attributes.

 

DECIMAL

13

Currently unused.

MachineIPAddress

The IP address of the machine.

 

VARCHAR

64

Currently unused.

DeletedFlag

Identifies whether this machine account deleted.

 

BIT

1

 

VersionIDM

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionID

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionRanking

Used to detect and resolve replication update collisions.

 

INTEGER

4