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