rt_role

Logical Entity Name | rt_role
Default Table Name | rt_role
Definition | 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 | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

rt_role Check Constraints

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