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