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