최종본

테이블 (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