| swarm_state |
| Logical Entity Name | swarm_state |
| Default Table Name | swarm_state |
| Definition |
| swarm_state Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| region |
VARCHAR2(24) | NO | ||
| in_progress | VARCHAR2(1) | NO | ||
| last_notify | NUMBER(15, 0) | YES | ||
| last_rerate | NUMBER(15, 0) | YES | ||
| rate_threshold | NUMBER(7, 3) | NO |
| swarm_state Primary and Unique Keys |
| Key Name | Key Type | Keys |
| swarm_statekey01 | PrimaryKey | region |
| swarm_state 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 |
| swarm_state Check Constraints |
| Check Constraint Name | CheckConstraint |
| swarm_state03 | rate_threshold > 0.0 |
| swarm_state02 | in_progress in ('t','f','T','F') |