سشنشى

Tables (10)

admins

  • admin_id — INT
  • name — VARCHAR(150) — NOT NULL
  • email — VARCHAR(150) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • role — ENUM('super_admin','moderator','verifier') — NOT NULL
  • status — ENUM('active','inactive','banned') — NOT NULL
  • last_login_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

favorites

  • favorite_id — INT
  • user_id — INT — NOT NULL
  • home_id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — ix_fav_user
  • INDEX — ix_fav_home

home

  • home_id — INT
  • user_id — INT — NOT NULL
  • institute_id — INT
  • description — TEXT — NOT NULL
  • price — DECIMAL(10,2)
  • currency — VARCHAR(60) — NOT NULL
  • rent_period — ENUM('monthly','semester','yearly') — NOT NULL
  • property_type — ENUM('apartment','room','shared','studio') — NOT NULL
  • capacity — INT — NOT NULL
  • current_occupants — INT — NOT NULL
  • gender_preference — ENUM('male','female','any') — NOT NULL
  • status — ENUM('active','reserved','inactive','archived') — NOT NULL
  • available_from — DATE
  • address_line — VARCHAR(255)
  • rooms — INT — NOT NULL
  • bathrooms — INT — NOT NULL
  • beds — INT — NOT NULL
  • whatsapp_phone — VARCHAR(20)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • wifi — BOOLEAN — NOT NULL
  • tv — BOOLEAN — NOT NULL
  • kitchen — BOOLEAN — NOT NULL
  • washer — BOOLEAN — NOT NULL
  • air_conditioning — BOOLEAN — NOT NULL
  • dedicated_workspace — BOOLEAN — NOT NULL
  • latitude — DECIMAL(10,8)
  • longitude — DECIMAL(11,8)
  • published_at — DATETIME
  • admin_id — INT
  • approved_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — DATETIME
  • INDEX — ix_home_owner
  • INDEX — ix__status
  • INDEX — ix_home_geo

home_images

  • image_id — INT
  • home_id — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — ix_li_home
  • INDEX — ix_li_primary

institutes

  • institute_id — INT
  • name — VARCHAR(200) — NOT NULL
  • type — ENUM('university','institute','college','school') — NOT NULL
  • description — TEXT
  • address_line — VARCHAR(255)
  • phone — VARCHAR(30)
  • email — VARCHAR(150)
  • website — VARCHAR(255)
  • logo — VARCHAR(255)
  • latitude — DECIMAL(10,8)
  • longitude — DECIMAL(11,8)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — DATETIME
  • INDEX — ix_institutes_name

messages

  • message_id — BIGINT
  • home_id — INT
  • sender_id — INT — NOT NULL
  • receiver_id — INT — NOT NULL
  • message_text — TEXT — NOT NULL
  • attachments — JSON
  • read_at — DATETIME
  • deleted_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — ix_msg_conv
  • INDEX — ix_msg_home
  • INDEX — ix_msg_unread

reports

  • report_id — INT
  • admin_id — INT — NOT NULL
  • home_id — INT
  • user_id — INT
  • report_type — ENUM('home','user','other')
  • message — TEXT — NOT NULL
  • status — ENUM('pending','reviewed','resolved')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

reviews

  • review_id — INT
  • user_id — INT — NOT NULL
  • home_id — INT — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT — EXT NUL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • INDEX — ix_reviews_home
  • INDEX — ix_reviews_user

user_verifications

  • verification_id — INT
  • user_id — INT — NOT NULL
  • admin_id — INT
  • verification_type — ENUM('national_id','passport','email','phone') — NOT NULL
  • document_image — VARCHAR(255)
  • personal_photo — VARCHAR(255)
  • status — ENUM('pending','approved','rejected') — NOT NULL
  • notes — TEXT
  • verified_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • INDEX — ix_uv_user
  • INDEX — ix_uv_status

users

  • user_id — INT
  • first_name — VARCHAR(150) — NOT NULL
  • last_name — VARCHAR(150) — NOT NULL
  • email — VARCHAR(150) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30)
  • gender — ENUM('male','female','unspecified') — NOT NULL
  • birth_date — DATE
  • role — ENUM('student','owner','broker') — NOT NULL
  • profile_image — VARCHAR(255)
  • is_verified — TINYINT(1) — NOT NULL
  • email_verified_at — DATETIME
  • phone_verified_at — DATETIME
  • status — ENUM('active','inactive','banned') — NOT NULL
  • last_login_at — DATETIME
  • login_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — DATETIME
  • INDEX — ix_users_role_gender