pcs_state

Logical Entity Name | pcs_state
Default Table Name | pcs_state
Definition | Part of the pcs system. Stores state of a task. Used by PCS package

pcs_state Columns

ColumnName | Domain | Datatype | NULL | Definition
controlgroup |  | VARCHAR2(20) | NO |
sourcetable |  | VARCHAR2(20) | NO |
id |  | NUMBER | NO |
state |  | VARCHAR2(20) | NO |
rank |  | NUMBER | NO |
result |  | NUMBER | YES |
secondaryid |  | NUMBER | YES |
secondarysourcetable |  | VARCHAR2(20) | YES |
auth |  | VARCHAR2(15) | YES |
subsource |  | VARCHAR2(8) | YES |
lddate |  | DATE | YES |

pcs_state Primary and Unique Keys

Key Name | Key Type | Keys
pk14 | PrimaryKey | controlgroup, sourcetable, id, state

pcs_state 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

pcs_state Check Constraints

Check Constraint Name | CheckConstraint