노카(NOCA)

테이블 (43)

accident

  • accident_id — BIGSERIAL — 기본 키 — NOT NULL
  • vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id — NOT NULL
  • vehicle_input_type — VARCHAR(10) — NOT NULL
  • snapshot_model_id — BIGINT — NOT NULL
  • snapshot_manufacturer — VARCHAR(50) — NOT NULL
  • snapshot_model_name — VARCHAR(100) — NOT NULL
  • snapshot_vehicle_type — VARCHAR(20) — NOT NULL
  • snapshot_car_class — VARCHAR(20) — NOT NULL
  • snapshot_model_year — SMALLINT — NOT NULL
  • actual_repair_cost — INTEGER
  • actual_repair_completed_date — DATE
  • repair_shop_name — VARCHAR(100)
  • actual_cost_recorded_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

accident_image

  • image_id — BIGSERIAL — 기본 키 — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • angle_code — VARCHAR(20)
  • quality_status — VARCHAR(20) — NOT NULL
  • quality_reason — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL

accident_image_asset

  • asset_id — BIGSERIAL — 기본 키 — NOT NULL
  • image_id — BIGINT — 외래 키 → accident_image.image_id — NOT NULL
  • variant — VARCHAR(20) — NOT NULL
  • s3_key — VARCHAR(500) — NOT NULL
  • width — SMALLINT
  • height — SMALLINT
  • file_size — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

accident_review

  • review_id — BIGSERIAL — 기본 키 — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reviewed_job_id — BIGINT — 외래 키 → analysis_job.job_id
  • snapshot_actual_repair_cost — INTEGER
  • reviewer_member_id — BIGINT — 외래 키 → member.member_id
  • reject_reason — VARCHAR(500)
  • queued_at — TIMESTAMPTZ — NOT NULL
  • reviewed_at — TIMESTAMPTZ

analysis_image_result

  • result_id — BIGSERIAL — 기본 키 — NOT NULL
  • job_id — BIGINT — 외래 키 → analysis_job.job_id — NOT NULL
  • image_id — BIGINT — 외래 키 → accident_image.image_id — NOT NULL
  • s3_key_overlay — VARCHAR(500)
  • detections — JSONB
  • is_excluded — BOOLEAN — NOT NULL
  • exclusion_reason — VARCHAR(50)

analysis_job

  • job_id — BIGSERIAL — 기본 키 — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — SMALLINT — NOT NULL
  • failure_reason — VARCHAR(50)
  • model_version — VARCHAR(50)
  • request_id — VARCHAR(64)
  • pipeline_version_id — BIGINT
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

analysis_stage

  • stage_id — BIGSERIAL — 기본 키 — NOT NULL
  • job_id — BIGINT — 외래 키 → analysis_job.job_id — NOT NULL
  • stage — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • detail — VARCHAR(100)
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ

audit_log

  • audit_log_id — BIGSERIAL — 기본 키 — NOT NULL
  • actor_member_id — BIGINT — 외래 키 → member.member_id
  • action_type — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — VARCHAR(100) — NOT NULL
  • request_id — VARCHAR(64)
  • before_data — TEXT
  • after_data — TEXT
  • change_reason — VARCHAR(500)
  • ip_address — VARCHAR(45)
  • created_at — TIMESTAMPTZ — NOT NULL

batch_job_execution

  • batch_job_execution_id — BIGSERIAL — 기본 키 — NOT NULL
  • job_name — VARCHAR(100) — NOT NULL
  • job_version — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • input_ref — VARCHAR(500)
  • started_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • summary — JSONB
  • error_message — TEXT

damaged_part

  • damaged_part_id — BIGSERIAL — 기본 키 — NOT NULL
  • job_id — BIGINT — 외래 키 → analysis_job.job_id — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code — NOT NULL
  • damage_type — VARCHAR(20) — NOT NULL
  • repair_method — VARCHAR(20)
  • severity_score — NUMERIC(6,2)
  • confidence — NUMERIC(5,4) — NOT NULL

data_validation_error

  • data_validation_error_id — BIGSERIAL — 기본 키 — NOT NULL
  • batch_job_execution_id — BIGINT — 외래 키 → batch_job_execution.batch_job_execution_id — NOT NULL
  • error_type — VARCHAR(50) — NOT NULL
  • source_ref — VARCHAR(500)
  • case_external_ref — VARCHAR(100)
  • category_id — VARCHAR(100)
  • error_detail — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

embedding_model_version

  • model_version_id — BIGSERIAL — 기본 키 — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • version — VARCHAR(50) — NOT NULL
  • dimension — SMALLINT — NOT NULL
  • distance_metric — VARCHAR(20) — NOT NULL
  • preprocessing — JSONB
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

estimate

  • estimate_id — BIGSERIAL — 기본 키 — NOT NULL
  • job_id — BIGINT — 외래 키 → analysis_job.job_id — NOT NULL
  • version — SMALLINT — NOT NULL
  • is_estimable — BOOLEAN — NOT NULL
  • non_estimable_reason — VARCHAR(100)
  • labor_rate — INTEGER
  • total_hq — NUMERIC(7,2)
  • total_min — INTEGER
  • total_median — INTEGER
  • total_max — INTEGER
  • ref_case_total — INTEGER
  • confidence_grade — VARCHAR(10)
  • unresolved_parts — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

estimate_item

  • estimate_item_id — BIGSERIAL — 기본 키 — NOT NULL
  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id — NOT NULL
  • damaged_part_id — BIGINT — 외래 키 → damaged_part.damaged_part_id — NOT NULL
  • repair_method — VARCHAR(20) — NOT NULL
  • standard_hq — NUMERIC(6,2)
  • part_cost_median — INTEGER
  • labor_cost_median — INTEGER
  • paint_material_cost — INTEGER
  • item_min — INTEGER — NOT NULL
  • item_median — INTEGER — NOT NULL
  • item_max — INTEGER — NOT NULL
  • ref_case_count — INTEGER — NOT NULL
  • ref_condition — JSONB — NOT NULL
  • is_low_confidence — BOOLEAN — NOT NULL

estimate_narrative

  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • content — JSONB
  • failure_reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

estimate_notice

  • code — VARCHAR(30) — 기본 키 — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

estimate_report

  • report_id — BIGSERIAL — 기본 키 — NOT NULL
  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id — NOT NULL
  • report_no — VARCHAR(24) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • s3_key_pdf — VARCHAR(500)
  • failure_reason — VARCHAR(200)
  • retry_count — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

estimate_validation

  • validation_id — BIGSERIAL — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id
  • s3_key_file — VARCHAR(500)
  • file_type — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • claimed_total — INTEGER
  • llm_model — VARCHAR(50)
  • llm_grade — VARCHAR(20)
  • llm_summary — TEXT
  • failure_reason — VARCHAR(200)
  • rule_version — INTEGER — 외래 키 → estimate_validation_rule.rule_version
  • review_item_count — INTEGER — NOT NULL
  • total_item_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

estimate_validation_item

  • validation_item_id — BIGSERIAL — 기본 키 — NOT NULL
  • validation_id — BIGINT — 외래 키 → estimate_validation.validation_id — NOT NULL
  • line_no — SMALLINT — NOT NULL
  • raw_item_name — VARCHAR(200) — NOT NULL
  • normalized_item_name — VARCHAR(100)
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • work_type — VARCHAR(20)
  • quantity — SMALLINT — NOT NULL
  • part_cost — INTEGER
  • labor_cost — INTEGER
  • subtotal — INTEGER
  • llm_flag — VARCHAR(30)
  • llm_reason — VARCHAR(300)
  • reference_min — INTEGER
  • reference_median — INTEGER
  • reference_p75 — INTEGER
  • reference_max — INTEGER
  • reference_case_count — INTEGER

estimate_validation_question

  • question_id — BIGSERIAL — 기본 키 — NOT NULL
  • validation_id — BIGINT — 외래 키 → estimate_validation.validation_id — NOT NULL
  • validation_item_id — BIGINT — 외래 키 → estimate_validation_item.validation_item_id
  • source_flag — VARCHAR(30) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • question_text — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

estimate_validation_report

  • validation_id — BIGINT — 외래 키 → estimate_validation.validation_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • s3_key_pdf — VARCHAR(500)
  • failure_reason — VARCHAR(200)
  • retry_count — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

estimate_validation_rule

  • rule_version — INTEGER — 기본 키 — NOT NULL
  • reference_percentile — SMALLINT — NOT NULL
  • severe_over_p75_multiplier — NUMERIC(5,2) — NOT NULL
  • caution_total_difference_ratio — NUMERIC(5,4) — NOT NULL
  • needs_review_total_difference_ratio — NUMERIC(5,4) — NOT NULL
  • needs_review_item_count — SMALLINT — NOT NULL
  • changed_by — BIGINT — 외래 키 → member.member_id
  • change_note — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL

feature_pipeline_version

  • pipeline_version_id — BIGSERIAL — 기본 키 — NOT NULL
  • pipeline_name — VARCHAR(100) — NOT NULL
  • version — VARCHAR(50) — NOT NULL
  • pair_rule_version — VARCHAR(50) — NOT NULL
  • pair_threshold — NUMERIC(3,2) — NOT NULL
  • roi_padding_ratio — NUMERIC(3,2)
  • params — JSONB
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

member

  • member_id — BIGSERIAL — 기본 키 — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(12) — NOT NULL
  • email — VARCHAR(255)
  • profile_image_key — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • withdrawn_at — TIMESTAMPTZ

part_code

  • part_code — VARCHAR(50) — 기본 키 — NOT NULL
  • name_ko — VARCHAR(50) — NOT NULL
  • layout_zone — VARCHAR(20) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • code_scope — VARCHAR(20) — NOT NULL
  • version — BIGINT — NOT NULL

part_name_mapping

  • raw_name — VARCHAR(200) — 기본 키 — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code — NOT NULL

repair_case

  • case_id — BIGSERIAL — 기본 키 — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • external_ref — VARCHAR(50)
  • model_id — BIGINT — 외래 키 → vehicle_model.model_id
  • manufacturer — VARCHAR(50)
  • model_name — VARCHAR(100)
  • car_class — VARCHAR(20) — NOT NULL
  • model_year — SMALLINT
  • repair_year — SMALLINT
  • labor_rate — INTEGER
  • total_cost — INTEGER
  • claim_amount — INTEGER
  • paid_amount — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

repair_case_damage_feature

  • damage_feature_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_image_id — BIGINT — 외래 키 → repair_case_image.case_image_id — NOT NULL
  • pipeline_version_id — BIGINT — 외래 키 → feature_pipeline_version.pipeline_version_id — NOT NULL
  • roi_index — SMALLINT — NOT NULL
  • damage_type — VARCHAR(20) — NOT NULL
  • damage_polygon — JSONB — NOT NULL
  • roi_box — JSONB — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • pair_status — VARCHAR(20) — NOT NULL
  • quality_status — VARCHAR(20) — NOT NULL
  • confidence — NUMERIC(5,4)
  • is_searchable — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

repair_case_image

  • case_image_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_id — BIGINT — 외래 키 → repair_case.case_id — NOT NULL
  • source_image_ref — VARCHAR(255) — NOT NULL
  • storage_key — VARCHAR(500) — NOT NULL
  • blur_key — VARCHAR(500)
  • angle_tag — VARCHAR(20)
  • image_type — VARCHAR(20) — NOT NULL
  • source_dataset_split — VARCHAR(20)
  • quality_status — VARCHAR(20)
  • is_searchable — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

repair_case_image_part_annotation

  • case_image_part_annotation_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_image_id — BIGINT — 외래 키 → repair_case_image.case_image_id — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code — NOT NULL
  • source_annotation_ref — VARCHAR(255) — NOT NULL
  • part_polygon — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

repair_case_item

  • case_item_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_id — BIGINT — 외래 키 → repair_case.case_id — NOT NULL
  • source_item_key — VARCHAR(100) — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • raw_item_name — VARCHAR(500)
  • line_type — VARCHAR(20) — NOT NULL
  • work_type — VARCHAR(20)
  • work_code — VARCHAR(30)
  • assessment_status — VARCHAR(20)
  • hq — NUMERIC(6,2)
  • reference_part_price — INTEGER
  • part_cost — INTEGER
  • paint_material_cost — INTEGER
  • labor_cost — INTEGER
  • pre_adjustment_part_cost — INTEGER
  • pre_adjustment_labor_cost — INTEGER
  • post_adjustment_part_cost — INTEGER
  • post_adjustment_labor_cost — INTEGER
  • item_total — INTEGER

repair_case_roi_embedding

  • roi_embedding_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_image_id — BIGINT — 외래 키 → repair_case_image.case_image_id — NOT NULL
  • model_version_id — BIGINT — 외래 키 → embedding_model_version.model_version_id — NOT NULL
  • damage_feature_id — BIGINT — 외래 키 → repair_case_damage_feature.damage_feature_id — NOT NULL
  • confidence — NUMERIC(5,4)
  • embedding — VECTOR(768) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

repair_checklist

  • checklist_id — BIGSERIAL — 기본 키 — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • generation_no — SMALLINT — NOT NULL
  • failure_reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • regenerated_at — TIMESTAMPTZ
  • summary — VARCHAR(300)

repair_checklist_common_item

  • code — VARCHAR(30) — 기본 키 — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

repair_checklist_item

  • item_id — BIGSERIAL — 기본 키 — NOT NULL
  • checklist_id — BIGINT — 외래 키 → repair_checklist.checklist_id — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • common_code — VARCHAR(30) — 외래 키 → repair_checklist_common_item.code
  • content — VARCHAR(500) — NOT NULL
  • is_checked — BOOLEAN — NOT NULL
  • memo — VARCHAR(500)
  • display_order — SMALLINT — NOT NULL
  • checked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • category — VARCHAR(10) — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • reason — VARCHAR(300)

repair_code

  • code_type — VARCHAR(20) — 기본 키 — NOT NULL
  • code — VARCHAR(20) — 기본 키 — NOT NULL
  • display_name — VARCHAR(50) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • version — BIGINT — NOT NULL

repair_cost_stat

  • stat_id — BIGSERIAL — 기본 키 — NOT NULL
  • car_class — VARCHAR(20) — NOT NULL
  • part_code — VARCHAR(50) — NOT NULL
  • damage_type — VARCHAR(20) — NOT NULL
  • repair_method — VARCHAR(20) — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • case_count — INTEGER — NOT NULL
  • hq_median — NUMERIC(6,2)
  • cost_min — INTEGER — NOT NULL
  • cost_p25 — INTEGER — NOT NULL
  • cost_median — INTEGER — NOT NULL
  • cost_p75 — INTEGER — NOT NULL
  • cost_max — INTEGER — NOT NULL
  • part_cost_median — INTEGER
  • labor_cost_median — INTEGER
  • aggregated_at — TIMESTAMPTZ — NOT NULL

repair_method_rule

  • rule_id — BIGSERIAL — 기본 키 — NOT NULL
  • damage_type — VARCHAR(20) — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • severity_min — NUMERIC(6,2) — NOT NULL
  • severity_max — NUMERIC(6,2) — NOT NULL
  • max_inclusive — BOOLEAN — NOT NULL
  • repair_method — VARCHAR(20) — NOT NULL
  • priority — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

repair_question

  • question_id — BIGSERIAL — 기본 키 — NOT NULL
  • accident_id — BIGINT — 외래 키 → accident.accident_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • generation_no — SMALLINT — NOT NULL
  • failure_reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • regenerated_at — TIMESTAMPTZ

repair_question_item

  • item_id — BIGSERIAL — 기본 키 — NOT NULL
  • question_id — BIGINT — 외래 키 → repair_question.question_id — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • part_code — VARCHAR(50) — 외래 키 → part_code.part_code
  • snapshot_part_name — VARCHAR(50)
  • damage_type — VARCHAR(20)
  • repair_method — VARCHAR(20)
  • display_order — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

terms_agreement

  • agreement_id — BIGSERIAL — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • terms_type — VARCHAR(20) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • agreed_at — TIMESTAMPTZ — NOT NULL

vehicle

  • vehicle_id — BIGSERIAL — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • model_id — BIGINT — 외래 키 → vehicle_model.model_id — NOT NULL
  • model_year — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

vehicle_model

  • model_id — BIGSERIAL — 기본 키 — NOT NULL
  • manufacturer — VARCHAR(50) — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • vehicle_type — VARCHAR(20) — NOT NULL
  • car_class — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • version — BIGINT — NOT NULL