This table is used to store information about the current status of the RT machine. RT System runs two machines in parallel. One is always 'primary' and another is always 'shadow'. You can find out using this table if the machine in question is primary or shadow. Whenever the status of the RT machine change from 'primary' to 'shadow' or vice versa, the entry is created in the table with the timestamp

rt_role Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
primary_system		VARCHAR(5)	YES	It stores (not enforced) two string values in the field. 'true' and 'false'. If the value is 'true', the system is primary and if the value is 'false' the system is shadow
modification_time		DATE	YES	Time when status is updated

rt_role Keys

Key Name

Key Type

Keys

rt_role Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

rt_role Check Constraints

Check Constraint Name	CheckConstraint
rt_role01	primary_system IN ('true', 'false', 'TRUE', 'FALSE')