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 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')