SearchCriteriaGroup Table (202)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Criteria storage for Selection and other Find mechanisms
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| SearchCriteriaGroup_id | Primary key | PK | |
| SearchCriteria_id | Owning model | FK SearchCriteria | |
| name | The name of this criteria group | String(254) | |
| textId | Extra information (descriptive) for this Criteria Group | FK text | ● |
| direction | 0 = Add, 1 = Subtract this group from the total result | Enum CriteriaGroupDirection | |
| rank | Rank order within this CriteriaModel | UShort | |
| active | Should this group be executed | UShort | |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| SearchCriteriaGroup_id | PK | Clustered, Unique |
| SearchCriteria_id, rank | FK, UShort | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| SearchCriteria | Criteria storage for Selection and other Find mechanisms |
| SearchCriterion | Criteria storage for Selection and other Find mechanisms |
| text | Long text fields from all over the system |
Replication Flags
- Area Management controlled table. Contents replicated to satellites and traveller databases.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.