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