maru
Tables (11)
admin_audit_logs
- id — BIGINT — Primary key — NOT NULL
- admin_user_id — BIGINT — Foreign key → users.id
- action — ENUM('APPROVE_PROPERTY','REJECT_PROPERTY','DELETE_PROPERTY','SUSPEND_USER','RESOLVE_REPORT','REJECT_REPORT','OTHER') — NOT NULL
- target_table — VARCHAR(100)
- target_id — BIGINT
- before_value — JSON
- after_value — JSON
- ip_address — VARCHAR(45)
- user_agent — TEXT
- created_at — DATETIME(6) — NOT NULL
agent_profiles
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- office_name — VARCHAR(150) — NOT NULL
- business_registration_no — VARCHAR(50)
- realtor_license_no — VARCHAR(80)
- office_phone — VARCHAR(30)
- office_address — VARCHAR(500)
- verified — BOOLEAN — NOT NULL
- verified_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
properties
- id — BIGINT — Primary key — NOT NULL
- agent_user_id — BIGINT — Foreign key → users.id — NOT NULL
- region_id — BIGINT — Foreign key → regions.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- property_type — ENUM('APARTMENT','OFFICETEL','VILLA','HOUSE','ROOM','OTHER') — NOT NULL
- trade_type — ENUM('MONTHLY_RENT','JEONSE','SALE') — NOT NULL
- status — ENUM('PENDING','ACTIVE','REJECTED') — NOT NULL
- address — VARCHAR(500) — NOT NULL
- address_detail — VARCHAR(200)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- deposit_amount — BIGINT
- monthly_rent — BIGINT
- sale_amount — BIGINT
- maintenance_fee — BIGINT
- area_m2 — DECIMAL(8,2)
- floor — INT
- total_floors — INT
- room_count — INT
- bathroom_count — INT
- available_from — DATE
- view_count — BIGINT — NOT NULL
- rejection_reason — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
property_accessibility
- property_id — BIGINT — Foreign key → properties.id — NOT NULL
- has_elevator — BOOLEAN
- has_ramp — BOOLEAN
- ramp_slope_ratio — DECIMAL(5,2)
- entrance_step_height_cm — DECIMAL(6,2)
- entrance_door_width_cm — DECIMAL(6,2)
- corridor_width_cm — DECIMAL(6,2)
- bathroom_door_width_cm — DECIMAL(6,2)
- has_accessible_bathroom — BOOLEAN
- wheelchair_accessible — BOOLEAN
- note — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
property_accessibility_scores
- property_id — BIGINT — Foreign key → properties.id — NOT NULL
- total_score — DECIMAL(5,2) — NOT NULL
- wheelchair_score — DECIMAL(5,2)
- senior_score — DECIMAL(5,2)
- visual_impairment_score — DECIMAL(5,2)
- hearing_impairment_score — DECIMAL(5,2)
- grade — VARCHAR(5) — NOT NULL
- calculation_detail — JSON
- calculated_at — DATETIME(6) — NOT NULL
property_favorites
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- property_id — BIGINT — Foreign key → properties.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
property_images
- id — BIGINT — Primary key — NOT NULL
- property_id — BIGINT — Foreign key → properties.id — NOT NULL
- image_url — TEXT — NOT NULL
- image_type — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
regions
- id — BIGINT — Primary key — NOT NULL
- sido — VARCHAR(50) — NOT NULL
- sigungu — VARCHAR(80)
- eupmyeondong — VARCHAR(80)
- legal_dong_code — VARCHAR(20)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
reports
- id — BIGINT — Primary key — NOT NULL
- reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
- property_id — BIGINT — Foreign key → properties.id
- review_id — BIGINT — Foreign key → reviews.id
- report_type — VARCHAR(80) — NOT NULL
- reason — TEXT — NOT NULL
- status — ENUM('RECEIVED','REVIEWING','RESOLVED','REJECTED') — NOT NULL
- handled_by — BIGINT — Foreign key → users.id
- handled_at — DATETIME(6)
- result_message — TEXT
- created_at — DATETIME(6) — NOT NULL
reviews
- id — BIGINT — Primary key — NOT NULL
- property_id — BIGINT — Foreign key → properties.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- rating — TINYINT — NOT NULL
- accessibility_rating — TINYINT
- content — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- role — ENUM('USER','AGENT','ADMIN') — NOT NULL
- status — ENUM('ACTIVE','SUSPENDED','WITHDRAWN') — NOT NULL
- last_login_at — DATETIME(6)
- password_changed_at — DATETIME(6)
- withdrawn_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)