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 Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
INSTANCENAME |  | VARCHAR(30) | NO |
CONTROLGROUP |  | VARCHAR(20) | NO |
SOURCETABLE |  | VARCHAR(20) | NO |
STATE |  | VARCHAR(20) | NO |
RANK |  | NUMERIC(0, 0) | NO |
RESULT |  | NUMERIC(0, 0) | YES |
ACTON |  | VARCHAR(6) | YES |
EVENTTYPE |  | VARCHAR(2) | YES |
LASTID |  | NUMERIC(0, 0) | YES |
LASTLDDATE |  | DATE | YES |
LDDATE |  | DATE | YES |
RESULTTEXT |  | VARCHAR(80) | YES |

autoposter Keys

Key Name | Key Type | Keys
PK3_1 | PrimaryKey | INSTANCENAME

autoposter Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

autoposter Check Constraints

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