Update schema - fix convention & add fields for rationale indexing

[HinsonSIDAN]

Update the schema to follow convention of using snake_case for all tables and fields.

Also update schema - and add field to support rationale indexing - refer to this plan: https://github.com/nomos-guild/cgov-mcp/blob/main/IMPLEMENTATION_PLAN_RATIONALE_INDEXING.md