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