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