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