prazy1208/text2sql
0
1-- Migration: add app_schema.column_agent_output (Column Agent 5b).2-- Run once on databases created before this table existed.3-- Safe if the table already exists.4 5CREATE TABLE IF NOT EXISTS app_schema.column_agent_output (6 id SERIAL PRIMARY KEY,7 table_agent_output_id INT NOT NULL REFERENCES app_schema.table_agent_output(id) ON DELETE CASCADE,8 selected_columns JSONB NOT NULL DEFAULT '{}'::jsonb,9 created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,10 UNIQUE (table_agent_output_id)11);12 13COMMENT ON TABLE app_schema.column_agent_output IS 'Column Agent: selected_columns (per table) for one table_agent_output row';14 