aa

Tables (17)

analysis

  • analysis_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → room.room_id — NOT NULL
  • in_scan_id — BIGINT — Foreign key → scan.scan_id — NOT NULL
  • out_scan_id — BIGINT — Foreign key → scan.scan_id — NULL이면 단일 스캔 탐지
  • total_cost — INT
  • status — VARCHAR(20) — NOT NULL — PENDING, COMPLETED, FAILED
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

chat_answer_cache

  • question_key — VARCHAR(200) — Primary key — NOT NULL
  • answer — TEXT — NOT NULL
  • hit_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_message

  • chat_message_id — BIGINT — Primary key — NOT NULL
  • chat_session_id — BIGINT — Foreign key → chat_session.chat_session_id — NOT NULL
  • role — VARCHAR(10) — NOT NULL — USER, ASSISTANT
  • content — TEXT — NOT NULL
  • defect_id — BIGINT — Foreign key → defect.defect_id — 하자 선택 대화면 세팅
  • created_at — DATETIME — NOT NULL

chat_session

  • chat_session_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

defect

  • defect_id — BIGINT — Primary key — NOT NULL
  • analysis_id — BIGINT — Foreign key → analysis.analysis_id — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • severity — VARCHAR(255) — NOT NULL — LOW, MEDIUM, HIGH
  • location — VARCHAR(255) — NOT NULL
  • area — FLOAT — NOT NULL
  • estimated_cost — INT — NOT NULL
  • description — VARCHAR(255)
  • image_url — TEXT
  • region_3d — TEXT — 3D 좌표 리스트(JSON)
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME

defect_repair_guide

  • defect_id — BIGINT — Foreign key → defect.defect_id — NOT NULL
  • self_repair_possible — TINYINT(1) — NOT NULL
  • description — TEXT — NOT NULL — 자가 수리 가능 여부 설명
  • videos — TEXT — 참고 영상 목록(JSON)
  • video_search_query — VARCHAR(255)
  • items — TEXT — 준비물 목록(JSON)
  • total_cost — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

defect_unit_price

  • defect_type — VARCHAR(20) — Primary key — NOT NULL
  • unit_price — INT — NOT NULL

estimate

  • estimate_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • room_id — BIGINT — Foreign key → room.room_id — NOT NULL
  • analysis_id — BIGINT — Foreign key → analysis.analysis_id
  • provider_name — VARCHAR(255) — NOT NULL
  • provider_phone — VARCHAR(255)
  • provider_address — VARCHAR(255)
  • provider_external_id — VARCHAR(255) — 카카오 로컬 place id
  • provider_lat — FLOAT
  • provider_lng — FLOAT
  • status — VARCHAR(20) — NOT NULL — REQUESTED, SENT, FAILED, COMPLETED
  • message — VARCHAR(255)
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

estimate_defect

  • estimate_defect_id — BIGINT — Primary key — NOT NULL
  • estimate_id — BIGINT — Foreign key → estimate.estimate_id — NOT NULL
  • defect_id — BIGINT — Foreign key → defect.defect_id — NOT NULL

house

  • house_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • house_color — VARCHAR(30)
  • floor_color — VARCHAR(30)
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

refresh_token

  • refresh_token_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • is_revoked — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

repair

  • repair_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → room.room_id — NOT NULL
  • estimate_id — BIGINT — Foreign key → estimate.estimate_id
  • provider_name — VARCHAR(255) — NOT NULL
  • repair_cost — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — IN_PROGRESS, COMPLETED
  • repaired_at — DATETIME
  • note — VARCHAR(255)
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

repair_defect

  • repair_defect_id — BIGINT — Primary key — NOT NULL
  • repair_id — BIGINT — Foreign key → repair.repair_id — NOT NULL
  • defect_id — BIGINT — Foreign key → defect.defect_id — NOT NULL

repair_supply

  • repair_supply_id — BIGINT — Primary key — NOT NULL
  • defect_type — VARCHAR(30) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • image_url — TEXT
  • purchase_url — TEXT — NOT NULL
  • sort_order — INT — NOT NULL

room

  • room_id — BIGINT — Primary key — NOT NULL
  • house_id — BIGINT — Foreign key → house.house_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • move_in_date — DATE
  • move_out_date — DATE
  • ply_url — VARCHAR(2000)
  • usdz_url — VARCHAR(2000)
  • thumbnail_url — VARCHAR(2000)
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

scan

  • scan_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • house_id — BIGINT — Foreign key → house.house_id
  • room_id — BIGINT — Foreign key → room.room_id
  • file_url — VARCHAR(2000)
  • ply_url — VARCHAR(2000)
  • usdz_url — VARCHAR(2000)
  • thumbnail_url — VARCHAR(2000)
  • status — VARCHAR(20) — NOT NULL — SCANNING, COMPLETED, FAILED
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • main_house_id — BIGINT — Foreign key → house.house_id
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL