swarm_state

Logical Entity Name | swarm_state
Default Table Name | swarm_state
Definition |

swarm_state Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
REGION |  | VARCHAR(24) | NO |
IN_PROGRESS |  | VARCHAR(1) | NO |
LAST_NOTIFY |  | NUMERIC(15, 0) | YES |
LAST_RERATE |  | NUMERIC(15, 0) | YES |
RATE_THRESHOLD |  | NUMERIC(7, 3) | NO |

swarm_state Keys

Key Name | Key Type | Keys
SWARM_STATEKEY01 | PrimaryKey | REGION

swarm_state 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

swarm_state Check Constraints

Check Constraint Name | CheckConstraint
SWARM_STATE02 | in_progress in ('t','f','T','F')
SWARM_STATE03 | rate_threshold > 0.0