Sakf-diagram - Laravel Schema Designer

managers

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_key string
phone string
city_id ^FK integer
lat string
lng string
address string
commerical_id string
password string
type enum
avatar string (255)
rate string (255)
bio text
wallet double (100)
is_subscribe boolean

owners

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_key string
phone string
city_id ^FK integer
password string
avatar string (255)
rate string (255)
wallet double (100)

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_key string
phone string
city_id ^FK integer
password string
avatar string (255)
rate string (255)
wallet double (100)

cities

id increments
timestamps timestamps
name string (255)

buildings

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
type_id string
lat string (255)
lng string (255)
address string (255)
use enum
cancel_reason text
ref_code string (255)
age double (255)
area double (255)
ratio double (255)
users_count integer
units_count integer
contract string (255)
instrument string (255)
construction_completion_certificate string (255)
civil_defense_certificate string (255)
status enum
owner_id ^FK integer
manager_id ^FK integer
seen boolean

building_types

id increments
timestamps timestamps
name string (255)

building_invoices

id increments
timestamps timestamps
building_id ^FK integer
manager_id ^FK integer
invoice string (255)
user_id ^FK integer

messages

id increments
timestamps timestamps
subject string (255)
text text
userable string (255)

maintenance_types

id increments
timestamps timestamps
name string (255)

workers

id increments
timestamps timestamps
name string (255)
maintenance_type_id ^FK integer
phone string (255)
country_key string (50)
rate double (100)
manager_id ^FK integer

worker_maintenance_types

id increments
timestamps timestamps
worker_id ^FK integer
building_id ^FK integer

maitenance_orders

id increments
timestamps timestamps
user_id ^FK integer
building_id ^FK integer
maintenance_type_id ^FK integer
worker_id ^FK integer
description text
seen boolean
invoice string (255)
status enum

rentals

id increments
timestamps timestamps
building_id ^FK integer
user_id ^FK integer
start date
end date
pay_date date
period_id ^FK integer
ref_code string (255)
price double (0,0)
electric_invoice string (255)
contract string (255)
electric_use boolean
water_use boolean

periods

id increments
timestamps timestamps
period integer

entitlements

id increments
timestamps timestamps
user_id ^FK integer
building_id ^FK integer
manager_id ^FK integer
start date
end date
day_date date
price double (100)
status enum

intros

id increments
timestamps timestamps
image string (255)
title string (255)
description text

notifications

id increments
timestamps timestamps
notifiable string
type string
data text
read_at timestamp

settings

id increments
timestamps timestamps
logo string
about text
email string
phone string
policy text
terms text
app_rate double

socials

id increments
timestamps timestamps
name string
image string
link string
title string

faqs

id increments
timestamps timestamps
question text
answer text

rates

id increments
timestamps timestamps
userable string
reviewable string
order_id ^FK integer
type enum
rate double (255)
comment text
showOrhide boolean

settlements

id increments
timestamps timestamps
userable string

plans

id increments
timestamps timestamps
name string
icon string
description text
price double
duration integer
building_count integer

subscriptions

id increments
timestamps timestamps
plan_id ^FK integer
manager_id ^FK integer
price double
duration integer
start_at date
end_at date
payment_type enum
payment_status boolean
unsupscribe boolean

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