rt_role

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

Child Relationships:

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

rt_role Check Constraints

Check Constraint Name CheckConstraint

rt_role01 primary_system IN ('true', 'false', 'TRUE', 'FALSE')

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

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