سشنشى
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