thistoo0615

Tables (15)

admin

  • admin_id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • name — VARCHAR(50) — NOT NULL — 성명
  • created_at — DATETIME — 작성일
  • updated_at — DATETIME — 수정일
  • deleted_at — DATETIME — 삭제일

agent

  • agent_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • license_no — VARCHAR(50) — 공인중개사자격번호
  • business_no — VARCHAR(50) — 사업자등록번호
  • office_name — VARCHAR(100) — 중개사무소명
  • approved — BOOLEAN — 관리자승인여부
  • deleted_at — DATETIME — 삭제일

agent_image

  • image_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → property.user_id — 유저아이디
  • image_url — VARCHAR(255) — 이미지경로
  • created_at — DATETIME — 작성일

bookmark

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • property_id — BIGINT — Foreign key → property.property_id — 매물아이디
  • created_at — DATETIME — 작성일

chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — 채팅방아이디
  • sender_id — BIGINT — 보낸이아이디
  • message — VARCHAR(2000) — 메시지내용
  • is_read — BOOLEAN — 읽음여부
  • created_at — DATETIME — 보낸시간

chat_room

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — 매물아이디
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • agent_id — BIGINT — 중개사아이디
  • created_at — DATETIME — 작성일
  • deleted_at — DATETIME — 삭제일

option

  • option_id — BIGINT
  • option_name — VARCHAR(20) — 옵션명

property

  • property_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • description — TEXT — 매물설명
  • property_type — VARCHAR(30) — 매물유형
  • transaction_type — VARCHAR(20) — 거래유형
  • price — BIGINT — 가격
  • deposit — BIGINT — 보증금
  • monthly_rent — INT — 월세
  • maintenance_fee — INT — 관리비
  • address — VARCHAR(200) — 주소
  • detail_address — VARCHAR(200) — 상세주소
  • region — VARCHAR(100) — 지역
  • area_m2 — DECIMAL(6,2) — 전용면적
  • room_count — INT — 방개수
  • bathroom_count — INT — 욕실개수
  • floor — INT — 층수
  • option_id — BIGINT — 매물옵션
  • move_in_date — DATE — 입주가능일
  • source_type — VARCHAR(20) — 출처유형
  • status — VARCHAR(20) — 상태
  • created_at — DATETIME — 작성일
  • updated_at — DATETIME — 수정일
  • deleted_at — DATETIME — 삭제일

property_image

  • image_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — 매물아이디
  • image_url — VARCHAR(255) — 이미지경로
  • is_thumbnail — BOOLEAN — 대표이미지여부
  • sort_order — INT — 정렬순서
  • created_at — DATETIME — 작성일

property_option

  • property_id — BIGINT — Foreign key → property.property_id
  • option_id — BIGINT — 옵션아이디
  • option_value — VARCHAR(20) — 옵션값

region

  • region_id — BIGINT — Primary key — NOT NULL
  • region_name — VARCHAR(20) — 지역명

report

  • report_id — BIGINT — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → property.property_id — 매물아이디
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • reason — VARCHAR(255) — 신고사유
  • status — VARCHAR(20) — 상태
  • created_at — DATETIME — 작성일
  • deleted_at — DATETIME — 삭제일

saved_search

  • search_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — 유저아이디
  • region — VARCHAR(100) — 지역
  • property_type — VARCHAR(30) — 매물유형
  • transaction_type — VARCHAR(20) — 거래유형
  • min_price — BIGINT — 최소가격
  • max_price — BIGINT — 최대가격
  • min_deposit — BIGINT — 최소보증금
  • max_deposit — BIGINT — 최대보증금
  • min_monthly_rent — BIGINT — 최소월세
  • max_monthly_rent — BIGINT — 최대월세
  • option_id — BIGINT — 검색옵션
  • created_at — DATETIME — 작성일
  • deleted_at — DATETIME — 삭제일

saved_search_option

  • search_id — BIGINT — Foreign key → saved_search.search_id
  • option_id — BIGINT — 옵션아이디
  • option_value — VARCHAR(20) — 옵션값

user

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL — 이메일
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • name — VARCHAR(50) — NOT NULL — 성명
  • nick — VARCHAR(50) — NOT NULL — 닉네임
  • phone — VARCHAR(20) — 연락처
  • role — VARCHAR(20) — 권한
  • refresh_token — VARCHAR(255) — 리프래시토큰
  • created_at — DATETIME — 작성일
  • updated_at — DATETIME — 수정일
  • deleted_at — DATETIME — 삭제일