pcs_transition

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

pcs_transition Columns

ColumnName | Domain | Datatype | NULL | Definition
groupold |  | VARCHAR2(20) | NO |
sourceold |  | VARCHAR2(20) | NO |
stateold |  | VARCHAR2(20) | NO |
resultold |  | NUMBER | NO |
groupnew |  | VARCHAR2(20) | NO |
sourcenew |  | VARCHAR2(20) | NO |
statenew |  | VARCHAR2(20) | NO |
ranknew |  | NUMBER | YES |
resultnew |  | NUMBER | YES |
auth |  | VARCHAR2(15) | YES |
subsource |  | VARCHAR2(8) | YES |
lddate |  | DATE | YES |

pcs_transition Primary and Unique Keys

Key Name | Key Type | Keys
pcs_state_pk | PrimaryKey | groupold, sourceold, stateold, resultold, groupnew, sourcenew, statenew

pcs_transition 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_transition Check Constraints

Check Constraint Name | CheckConstraint