노카(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