realestates - Laravel Schema Designer

users

id increments
name string
email string
password string
type enum
cities_id string
phone string
logo_image string (500)
license_image string
user_id ^FK integer
nationality string
sex string
date_of_brth date
passport_image string (500)
id_image string (500)
visa_image string (500)
addrse string
government_name string
timestamps timestamps

subscribe

id increments
user_id ^FK integer
start_date date
end_date date
timestamps timestamps

inquiry

id increments
user_id ^FK integer
real_id ^FK integer
email string
phone string
message string (500)
status enum
note string (500)
timestamps timestamps

cities

id increments
emirate string
city_ar string
city_en string
timestamps timestamps

maintenance

id increments
user_id ^FK integer
title string
content string
timestamps timestamps

property

categories

id increments
name string
image string (500)
timestamps timestamps

sections

id increments
categories_id ^FK integer
name string
image string
timestamps timestamps

tenant

id increments
user_id ^FK integer
full_name string (500)
emirate_ID integer
email string (100)
date_of_birth date
gender enum
marital_status string
nationality string
phone string
tenant_image string (500)
emirate_id_image string
visa_image string (500)
timestamps timestamps
softDeletes softDeletes

tenancy_contracts

id increments
property_id ^FK integer
tenant_id ^FK integer
type enum
start_date date
end_date date
status enum
deposit integer
total_rent integer
unit_number integer
invoices_image string
timestamps timestamps

checks

id increments
timestamps timestamps
tenancy_contracts_id ^FK integer
amount integer
check_date date
check_status enum
check_image string
note string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01