Amlaky - Laravel Schema Designer

bills

id increments
timestamps timestamps
softDeletes softDeletes
realty_id integer
unit_id integer
serial_num integer
bill_status integer
date datetime
value double
user_id integer
due_days integer

realties

units

id increments
timestamps timestamps
softDeletes softDeletes
realty_id integer
unit_type integer
unit_num integer
unit_space double
floor string
floor_num integer
rooms_num integer
receptions_num integer
bathrooms_num integer
kitchen_cabinet enum
shop_num integer
shop_space double
office_num integer
office_space double
desk_count integer
private_parking enum
electricity_account string
one_water_account enum
rent_value double
rent_durations integer
unit_status integer
description text
notes text
user_id integer
water_account string

expenses

id increments
timestamps timestamps
softDeletes softDeletes
realty_id integer
unit_id integer
provider_id integer
date datetime
bill_num string
total double
exchange_id integer
description text
serial integer
user_id integer

providers

id increments
timestamps timestamps
softDeletes softDeletes
name string
service_id integer
email string
reposible_name string
phone_num string
description text
user_id integer

exchanges

id increments
timestamps timestamps
softDeletes softDeletes
name string

services

id increments
timestamps timestamps
softDeletes softDeletes
name string

requests

id increments
timestamps timestamps
softDeletes softDeletes
realty_id integer
unit_id integer
provider_id integer
request_status integer
details text
date datetime
user_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
expire_date datetime
max_units integer
order_id integer
visa integer

payments

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
paid double
payment_method_id integer
bill_id integer
due double

paymentmethods

id increments
timestamps timestamps
softDeletes softDeletes
name string

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string
currency string
code string
nationality string

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
country_id integer

contractors

id increments
timestamps timestamps
softDeletes softDeletes
name string
national_id string
birth_date datetime
social_status integer
family_count integer
phone_num string
email string
work_location string
nationality_id integer
country_id integer
user_id integer
family_number integer

contracts

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
contractor_id integer
realty_id integer
unit_id integer
period integer
period_durations integer
value double
value_durations integer
update enum
start_at datetime
contract_status integer
expire_at datetime
next_payments datetime
days integer
notes text

activations

id increments
timestamps timestamps
softDeletes softDeletes
phone_num string
code string
user_id integer

license_realty

id increments
timestamps timestamps
softDeletes softDeletes
preset_id integer
realty_id integer

packages

id increments
timestamps timestamps
softDeletes softDeletes
title string
type enum
to_units integer
free boolean
price double
description string

discounts

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
value double
type enum
period integer
repeat integer
max_uses integer
uses integer

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
pakage_id integer
due_date datetime
upgrade_date datetime
expire_date datetime
discount_id integer
discount_count integer
total double
status enum
max_units integer

invoices

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
order_id integer
total double
paid boolean

package_discount

id increments
timestamps timestamps
softDeletes softDeletes
discount_id integer
package_id integer

presets

id increments
timestamps timestamps
softDeletes softDeletes
name string
type string

pushers

id increments
timestamps timestamps
title string (200)
message text

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