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)