{"ok":true,"status":"OK","readonly":true,"driver":"psycopg","price_table":"portfolio.portfolio_price_cache","price_rows":731,"missing_columns":[],"blocking_required_columns":[],"columns":[{"column_name":"id","data_type":"uuid","is_nullable":"NO","column_default":"gen_random_uuid()"},{"column_name":"asset_id","data_type":"uuid","is_nullable":"YES","column_default":null},{"column_name":"price_date","data_type":"date","is_nullable":"YES","column_default":null},{"column_name":"price_time","data_type":"time without time zone","is_nullable":"YES","column_default":null},{"column_name":"price","data_type":"numeric","is_nullable":"YES","column_default":null},{"column_name":"currency","data_type":"text","is_nullable":"NO","column_default":"'EUR'::text"},{"column_name":"fx_rate_to_eur","data_type":"numeric","is_nullable":"YES","column_default":null},{"column_name":"price_eur","data_type":"numeric","is_nullable":"YES","column_default":null},{"column_name":"source","data_type":"text","is_nullable":"NO","column_default":"'portfolio_price_cache_manual'::text"},{"column_name":"source_reference","data_type":"text","is_nullable":"YES","column_default":null},{"column_name":"is_latest","data_type":"boolean","is_nullable":"NO","column_default":"false"},{"column_name":"notes","data_type":"text","is_nullable":"YES","column_default":null},{"column_name":"created_at","data_type":"timestamp with time zone","is_nullable":"NO","column_default":"now()"},{"column_name":"price_key","data_type":"text","is_nullable":"YES","column_default":"('PRICE-'::text || replace((gen_random_uuid())::text, '-'::text, ''::text))"},{"column_name":"asset_key","data_type":"text","is_nullable":"YES","column_default":null},{"column_name":"price_value","data_type":"numeric","is_nullable":"YES","column_default":null},{"column_name":"price_currency","data_type":"text","is_nullable":"NO","column_default":"'EUR'::text"},{"column_name":"price_source","data_type":"text","is_nullable":"NO","column_default":"'manual'::text"},{"column_name":"raw_json","data_type":"jsonb","is_nullable":"NO","column_default":"'{}'::jsonb"},{"column_name":"is_active","data_type":"boolean","is_nullable":"NO","column_default":"true"},{"column_name":"is_deleted","data_type":"boolean","is_nullable":"NO","column_default":"false"},{"column_name":"updated_at","data_type":"timestamp with time zone","is_nullable":"NO","column_default":"now()"}],"duration_ms":38.89,"checked_at_utc":"2026-07-16T18:57:24+00:00"}