skala-final
Tables (29)
analysis_log
- id — VARCHAR(40) — Primary key — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- analysis_run_id — BIGINT — NOT NULL
- pattern_id — VARCHAR(100) — NOT NULL
- pattern_name — VARCHAR(200) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- severity — VARCHAR(20)
- summary — TEXT
- matched_count — INT — NOT NULL
- results_json — TEXT
- analyzed_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
analysis_run
- id — BIGSERIAL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
analysis_snapshot
- id — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- version — INTEGER — NOT NULL
- trigger_type — VARCHAR(20) — NOT NULL
- is_latest — BOOLEAN — NOT NULL
- availability_tier — VARCHAR(20)
- rto_tolerance — VARCHAR(20)
- reliability_weight — DOUBLE — NOT NULL
- cost_weight — DOUBLE — NOT NULL
- total_detected — INTEGER — NOT NULL
analysis_snapshot_item
- id — VARCHAR(40) — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- snapshot_id — VARCHAR(40) — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- rank — INTEGER
- is_deferred — BOOLEAN — NOT NULL
- pattern_id — VARCHAR(30) — NOT NULL
- title — TEXT — NOT NULL
- category — VARCHAR(30) — NOT NULL
- tags_json — TEXT
- score — DOUBLE — NOT NULL
- matched_count — INTEGER — NOT NULL
- resources_json — TEXT
- failure_impact — VARCHAR(30)
- recovery — VARCHAR(30)
- change_scope — VARCHAR(30)
- trade_off_json — TEXT
aws_connection
- id — VARCHAR(40)
- alias — VARCHAR(100) — NOT NULL
- account_id — VARCHAR(12) — NOT NULL
- role_arn — VARCHAR(300) — NOT NULL
- external_id — VARCHAR(120) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- permission — VARCHAR(30) — NOT NULL
- cur_bucket_name — VARCHAR(100)
- cur_bucket_region — VARCHAR(30)
- tenant_id — VARCHAR(120)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
chat_message
- id — VARCHAR(40)
- session_id — VARCHAR(40) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- intent — VARCHAR(40)
- operation_json — JSONB
- studio_graph_version_id — VARCHAR(40)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
cost_estimation_node
- id — VARCHAR(40) — Primary key — NOT NULL
- run_id — BIGINT — NOT NULL
- node_id — VARCHAR(200) — NOT NULL
- node_type — VARCHAR(50)
- node_name — VARCHAR(200)
- monthly_cost — NUMERIC(14,6) — NOT NULL
- default_fallback_used — BOOLEAN — NOT NULL
- metrics_json — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
cost_estimation_run
- id — BIGSERIAL — Primary key — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- total_monthly_cost — NUMERIC(14,6) — NOT NULL
- node_count — INT — NOT NULL
- default_fallback_used — BOOLEAN — NOT NULL
- default_fallback_node_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
metric_snapshot
- id — VARCHAR(40)
- scan_id — VARCHAR(40) — NOT NULL
- connection_id — VARCHAR(40) — NOT NULL
- region — VARCHAR(30) — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP — NOT NULL
- period_seconds — INTEGER — NOT NULL
- status — VARCHAR(30) — NOT NULL
- metrics_json — TEXT
- failed_metrics_json — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
pattern_detection_result
- id — VARCHAR(40) — Primary key — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- pattern_id — VARCHAR(20) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- resource_address — VARCHAR(300)
- resource_name — VARCHAR(200)
- resource_type — VARCHAR(50)
- reasons_json — TEXT
- result_json — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
pricing_unit
- id — VARCHAR(160)
- service_code — VARCHAR(40) — NOT NULL
- region — VARCHAR(30) — NOT NULL
- lookup_key — VARCHAR(100) — NOT NULL
- unit — VARCHAR(20) — NOT NULL
- price_per_unit — NUMERIC(20,10) — NOT NULL
- currency — VARCHAR(8) — NOT NULL
- attributes — JSONB
- fetched_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
project
- project_id — UUID
- tenant_id — VARCHAR(40) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
recommendation
- id — VARCHAR(60)
- workload_id — VARCHAR(40) — NOT NULL
- title — VARCHAR(300) — NOT NULL
- target — VARCHAR(50) — NOT NULL
- impact — VARCHAR(50) — NOT NULL
- confidence — VARCHAR(20) — NOT NULL
- risk — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
recommendation_chat_message
- id — VARCHAR(40) — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- snapshot_id — VARCHAR(40) — NOT NULL
- role — VARCHAR(10) — NOT NULL
- content — TEXT — NOT NULL
- intent — VARCHAR(30)
resource_graph_snapshot
- id — VARCHAR(40)
- connection_id — VARCHAR(40) — NOT NULL
- region — VARCHAR(30) — NOT NULL
- graph_json — JSONB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
resource_metric_summary
- id — VARCHAR(60)
- metric_snapshot_id — VARCHAR(40) — NOT NULL
- scan_id — VARCHAR(40) — NOT NULL
- connection_id — VARCHAR(40) — NOT NULL
- region — VARCHAR(30) — NOT NULL
- resource_type — VARCHAR(50) — NOT NULL
- cloud_id — VARCHAR(500) — NOT NULL
- namespace — VARCHAR(100) — NOT NULL
- metric_name — VARCHAR(120) — NOT NULL
- stat — VARCHAR(40) — NOT NULL
- dimension_name — VARCHAR(100) — NOT NULL
- dimension_value — VARCHAR(500) — NOT NULL
- avg_value — DOUBLE
- max_value — DOUBLE
- min_value — DOUBLE
- datapoint_count — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
scan_execution
- id — VARCHAR(40)
- workload_id — VARCHAR(40) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- progress_percent — INTEGER — NOT NULL
- current_step — VARCHAR(60)
- scan_snapshot_id — VARCHAR(40)
- metric_snapshot_id — VARCHAR(40)
- message — VARCHAR(500)
- started_at — TIMESTAMP — NOT NULL
- finished_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
scan_snapshot
- id — VARCHAR(40)
- connection_id — VARCHAR(40) — NOT NULL
- workload_id — VARCHAR(40)
- scan_execution_id — VARCHAR(40)
- region — VARCHAR(30) — NOT NULL
- resource_types — VARCHAR(200) — NOT NULL
- raw_json — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
scan_task
- id — VARCHAR(50)
- scan_id — VARCHAR(40) — NOT NULL
- step_key — VARCHAR(60)
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(30)
- percent — INTEGER — NOT NULL
- order_no — INTEGER — NOT NULL
- message — VARCHAR(500)
- started_at — TIMESTAMP
- finished_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
studio_graph_version
- id — VARCHAR(40)
- session_id — VARCHAR(40) — NOT NULL
- version — INTEGER — NOT NULL
- source_type — VARCHAR(40) — NOT NULL
- change_type — VARCHAR(40) — NOT NULL
- change_summary — VARCHAR(500)
- resource_graph_json — JSONB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
studio_session
- id — VARCHAR(40)
- tenant_id — VARCHAR(120) — NOT NULL
- project_id — VARCHAR(120) — NOT NULL
- name — VARCHAR(160) — NOT NULL
- latest_version — INTEGER — NOT NULL
- current_graph_version_id — VARCHAR(40)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
survey_responses
- id — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- tenant_id — VARCHAR(40) — NOT NULL
- project_id — VARCHAR(40) — NOT NULL
- workload_type_json — TEXT
- operation_hours — VARCHAR(30)
- availability_tier_raw — VARCHAR(20)
- availability_tier_normalized — VARCHAR(20)
- rto_tolerance_raw — VARCHAR(20)
- rto_tolerance_normalized — VARCHAR(20)
- traffic_pattern — VARCHAR(30)
- constraints_json — TEXT
- change_scope — VARCHAR(30)
- warnings_json — TEXT
- detected_pattern_count — INTEGER — NOT NULL
tenant
- tenant_id — VARCHAR(40)
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
terraform_dependency
- dependency_id — UUID
- project_id — UUID — NOT NULL
- source_resource_id — UUID
- target_resource_id — UUID
- source_address — VARCHAR(500) — NOT NULL
- target_address — VARCHAR(500)
- dependency_type — VARCHAR(50) — NOT NULL
- attribute_key — VARCHAR(255)
- reference_expression — TEXT
- is_resolved — BOOLEAN — NOT NULL
- file_path — VARCHAR(500)
- line — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
terraform_file
- file_id — UUID
- project_id — UUID — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- content_hash — VARCHAR(128)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
terraform_resource
- resource_id — UUID
- project_id — UUID — NOT NULL
- file_id — UUID
- address — VARCHAR(500) — NOT NULL
- type — VARCHAR(150) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- provider — VARCHAR(150)
- module_path — VARCHAR(500)
- file_path — VARCHAR(500)
- line — INTEGER
- tags_json — JSONB — NOT NULL
- raw_attributes_json — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
terraform_snapshot
- id — VARCHAR(40)
- studio_graph_version_id — VARCHAR(40) — NOT NULL
- source_type — VARCHAR(40) — NOT NULL
- raw_hcl — TEXT — NOT NULL
- sources_json — JSONB — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
workload
- id — VARCHAR(40)
- name — VARCHAR(120) — NOT NULL
- customer — VARCHAR(100)
- environment — VARCHAR(50)
- owner — VARCHAR(100)
- connection_id — VARCHAR(40) — NOT NULL
- origin — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- tenant_id — VARCHAR(120)
- project_id — VARCHAR(40)
- studio_graph_version_id — VARCHAR(40)
- scope_json — TEXT
- resource_count — INTEGER — NOT NULL
- monthly_cost — NUMERIC(12,2) — NOT NULL
- saving_potential — NUMERIC(12,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
workload_resource
- id — VARCHAR(40)
- workload_id — VARCHAR(40) — NOT NULL
- resource_key — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- resource_count — INTEGER — NOT NULL
- monthly_cost — NUMERIC(12,2) — NOT NULL
- selected — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL