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