autoposter

Logical Entity Name | autoposter
Default Table Name | autoposter
Definition | Part of pcs system, identifies an event type and a series of tasks. Maintained by PCS package

autoposter Columns

ColumnName | Domain | Datatype | NULL | Definition
instancename |  | VARCHAR2(30) | NO |
controlgroup |  | VARCHAR2(20) | NO |
sourcetable |  | VARCHAR2(20) | NO |
state |  | VARCHAR2(20) | NO |
rank |  | NUMBER | NO |
result |  | NUMBER | YES |
acton |  | VARCHAR2(6) | YES |
eventtype |  | VARCHAR2(2) | YES |
lastid |  | NUMBER | YES |
lastlddate |  | DATE | YES |
lddate |  | DATE | YES |
resulttext |  | VARCHAR2(80) | YES |

autoposter Primary and Unique Keys

Key Name | Key Type | Keys
pk3_1 | PrimaryKey | instancename

autoposter 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

autoposter Check Constraints

Check Constraint Name | CheckConstraint
actionlist | actOn in ('EVENT', 'ORIGIN', 'NETMAG')