감자

테이블 (13)

agent_review

  • review_id — INT — 외래 키 → review.review_id — NOT NULL

amenity

  • amenity_id — INT
  • name — VARCHAR(100) — NOT NULL

building

  • building_id — INT — 기본 키 — NOT NULL
  • building_type — ENUM(오피스텔, 고시원, 공인중개사, 기숙사, ...) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • road_address — VARCHAR(255)
  • lot_address — VARCHAR(255)
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(9,6)
  • visit_method — VARCHAR(100)
  • commission_fee — INT

dorm_review

  • review_id — INT — 외래 키 → review.review_id — NOT NULL
  • floor_category — ENUM('저층','중층','고층') — NOT NULL
  • dorm_population — INT — NOT NULL
  • dorm_fee — INT — NOT NULL

general_review

  • review_id — INT — 외래 키 → review.review_id — NOT NULL
  • floor_category — ENUM('반지하','저층','중층','고층','옥탑') — NOT NULL
  • area — DECIMAL(5,2) — NOT NULL
  • contract_type — ENUM('월세','전세') — NOT NULL
  • monthly_rent — INT
  • deposit — INT
  • maintenance_fee — INT — NOT NULL
  • jeonse_deposit — INT
  • jeonse_maintenance_fee — INT

photo

  • photo_id — INT — 기본 키 — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • review_id — INT — 외래 키 → review.review_id — NOT NULL

requirement

  • req_id — INT
  • name — VARCHAR(100) — NOT NULL
  • req_type — ENUM('region','grade','none') — NOT NULL

review

  • review_id — INT — 기본 키 — NOT NULL
  • building_id (building_id2) — INT — 외래 키 → building.building_id — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
  • dtype — VARCHAR — NOT NULL
  • rating — DECIMAL(2,1) — NOT NULL
  • description — TEXT
  • created_at — DATETIME
  • like_count — INT

review_amenity

  • review_id — INT — 기본 키 — NOT NULL
  • amenity_id — INT — 기본 키 — NOT NULL
  • amenity_scope — ENUM('individual','shared','rest') — NOT NULL

review_requirement

  • review_id — INT — 기본 키 — NOT NULL
  • req_id — INT — 기본 키 — NOT NULL

review_tag

  • tag_id (tag_id2) — INT — 외래 키 → tag.tag_id — NOT NULL
  • review_id — INT — 외래 키 → review.review_id — NOT NULL

tag

  • tag_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • tag_type — ENUM('advantage','disadvantage') — NOT NULL
  • category — ENUM('general','dorm','agent') — NOT NULL

users

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • created_at — DATETIME