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 Columns

ColumnName	Domain	Datatype	NULL	Definition
primary_system		VARCHAR2(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 Primary and Unique Keys

Key Name

Key Type

Keys

rt_role Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

rt_role Check Constraints

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