최종본
테이블 (16)
agent_verification_request
- verification_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- license_number (중개업자 번호) — VARCHAR(50) — NOT NULL
- external_check_status (공공데이터 조회 상태) — VARCHAR(20) — NOT NULL
- broker_name (중개업자명) — VARCHAR(100)
- office_name (부동산 이름) — VARCHAR(150)
- office_address (부동산 주소) — VARCHAR(500)
- office_phone (부동산 전화번호) — VARCHAR(30)
- business_status (영업 상태) — VARCHAR(50)
- external_checked_at (공공데이터 조회 시간) — TIMESTAMP(6) — NOT NULL
- document_original_name (서류 파일명) — VARCHAR(255) — NOT NULL
- document_file_key (서류 객체 키) — VARCHAR(500) — NOT NULL
- document_content_type (서류 타입) — VARCHAR(100) — NOT NULL
- document_file_size (파일 사이즈) — BIGINT — NOT NULL
- submitted_at (제출 시간) — TIMESTAMP(6) — NOT NULL
- status (인증 상태) — VARCHAR(20) — NOT NULL
- reviewed_at (관리자 승인/반려 시각) — TIMESTAMP(6)
- created_at (생성 일자) — TIMESTAMP(6) — NOT NULL
- updated_at (수정 일자) — TIMESTAMP(6) — NOT NULL
checklist
- checklist_id — BIGINT — 기본 키 — NOT NULL
- meeting_id — BIGINT — 외래 키 → meeting.meeting_id — NOT NULL
- title — VARCHAR(100)
- created_at — TIMESTAMP
checklist_item
- item_id — BIGINT — 기본 키 — NOT NULL
- checklist_id — BIGINT — 외래 키 → checklist.checklist_id — NOT NULL
- content — VARCHAR(255)
- status — VARCHAR(20)
- memo — TEXT
defect
- defect_id — BIGINT — 기본 키 — NOT NULL
- capture_id — BIGINT — 외래 키 → session_capture.capture_id — NOT NULL
- type — VARCHAR(50)
- confidence — DOUBLE PRECISION
- description — TEXT
- status — VARCHAR(20)
- created_at — TIMESTAMP
document
- document_id — BIGINT — 기본 키 — NOT NULL
- property_id — BIGINT — 외래 키 → property.property_id — NOT NULL
- document_type — VARCHAR(50)
- file_url — VARCHAR(500)
- status — VARCHAR(20)
- created_at — TIMESTAMP
document_analysis
- analysis_id — BIGINT — 기본 키 — NOT NULL
- document_id — BIGINT — 외래 키 → document.document_id — NOT NULL
- risk_level — VARCHAR(20)
- summary — TEXT
- result_json — JSONB
- created_at — TIMESTAMP
favorite_property
- favorite_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- property_id — BIGINT — 외래 키 → property.property_id — NOT NULL
- created_at — TIMESTAMP
meeting
- meeting_id — BIGINT — 기본 키 — NOT NULL
- property_id — BIGINT — 외래 키 → property.property_id — NOT NULL
- tenant_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- agent_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- preferred_at_1 — TIMESTAMP — NOT NULL
- preferred_at_2 — TIMESTAMP
- preferred_at_3 — TIMESTAMP
- scheduled_at — TIMESTAMP
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
oauth_account
- oauth_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- profile_image — VARCHAR(500)
- created_at — TIMESTAMP
property
- property_id — BIGINT — 기본 키 — NOT NULL
- registrant_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(100)
- sigungu — VARCHAR(30)
- dong — VARCHAR(30)
- lot_number — VARCHAR(50)
- road_address — VARCHAR(255)
- complex_name — VARCHAR(100)
- built_year — INTEGER
- latitude — NUMERIC(10, 8)
- longitude — NUMERIC(11, 8)
- deposit — INTEGER
- monthly_rent — INTEGER
- maintenance_fee — INTEGER
- transaction_type — VARCHAR(30)
- room_type — VARCHAR(30)
- floor — INTEGER
- total_floor — INTEGER
- rooms — INTEGER
- area — DOUBLE PRECISION
- description — TEXT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
property_environment
- environment_id — BIGINT — 기본 키 — NOT NULL
- property_id — BIGINT — 외래 키 → property.property_id — NOT NULL
- 근처역 이름 (nearest_station_name) — VARCHAR(100)
- 역까지 거리 (station_distance_meter) — INTEGER
- 역까지 걷는 시간 (station_walking_minutes) — INTEGER
- 편의점 갯수 (convenience_store_count) — INTEGER
- 마트 갯수 (mart_count) — INTEGER
- 병원 갯수 (hospital_count) — INTEGER
- 약국 갯수 (pharmacy_count) — INTEGER
- 카페 갯수 (cafe_count) — INTEGER
- 병원 갯수 (police_count) — INTEGER
- 공원 갯수 (park_count) — INTEGER
- 은행 갯수 (bank_count) — INTEGER
- 빨래방 갯수 (laundry_count) — INTEGER
- 학교 갯수 (school_count) — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
property_image
- image_id — BIGINT — 기본 키 — NOT NULL
- property_id — BIGINT — 외래 키 → property.property_id — NOT NULL
- image_url — VARCHAR(500)
- sequence — INTEGER
- created_at — TIMESTAMP
report
- report_id — BIGINT — 기본 키 — NOT NULL
- meeting_id — BIGINT — 외래 키 → meeting.meeting_id — NOT NULL
- summary — TEXT
- status — VARCHAR(20)
- pdf_url — VARCHAR(500)
- created_at — TIMESTAMP
session
- session_id — BIGINT — 기본 키 — NOT NULL
- meeting_id — BIGINT — 외래 키 → meeting.meeting_id — NOT NULL
- room_token — VARCHAR(255)
- status — VARCHAR(20)
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
- created_at — TIMESTAMP
session_capture
- capture_id — BIGINT — 기본 키 — NOT NULL
- session_id — BIGINT — 외래 키 → session.session_id — NOT NULL
- image_url — VARCHAR(500)
- captured_at — TIMESTAMP
users
- user_id — BIGINT — 기본 키 — NOT NULL
- nickname — VARCHAR(50)
- name — VARCHAR(30)
- role — VARCHAR(20)
- birth — DATE
- phone — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP