Create the search criteria table clob #2365
Description
Describe the task
Implement a unified database table and API to replace CONSEP’s 32 existing criteria tables.
The new SAVED_SEARCH_CRITERIA table will store user-specific search filter criteria in JSON format, reducing schema complexity and allowing flexible addition or removal of filters without database changes.
Acceptance Criteria
- New SAVED_SEARCH_CRITERIA table is created using the proposed DDL.
- REVISION_COUNT increments on each update to prevent concurrent update conflicts.
- Existing 32 criteria tables are incorporated into the unified table
Additional context
Confluence documentation here: https://apps.nrs.gov.bc.ca/int/confluence/display/FSADT2/Saving+Search+Criteria+in+CONSEP