pms - Laravel Schema Designer

users

id increments
User_name string (255)
User_email string (255)
User_password string (255)
timestamps timestamps
softDeletes softDeletes

companies

id increments
Company_name string (255)
Company_phone string (255)
Company_email string (255)
password string (255)
timestamps timestamps
softDeletes softDeletes

company_users

id increments
Company_user_name string (255)
Company_user_email string (255)
Company_user_phone string (255)
password string (255)
role integer
timestamps timestamps
softDeletes softDeletes

protfolios

id increments
block_id integer
Protfolio_name string (255)
post_office string (255)
contract_number string (255)
start_date datetime
end_date date
commision_type boolean
commision_amount string (100)
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (255)
description text
timestamps timestamps

user_roles

id increments
user_id integer
role_id integer
timestamps timestamps

governorates

id increments
governorate_name string (255)
timestamps timestamps
softDeletes softDeletes

cities

id increments
city_name string (255)
governorate_id integer
timestamps timestamps
softDeletes softDeletes

areas

id increments
area_name string (255)
city_id integer
governorate_id integer
timestamps timestamps

blocks

id increments
block_name string (255)
area_id integer
city_id integer
governorate_id integer
timestamps timestamps

attachments

id increments
url string (255)
attachmentable_id integer
attachmentable_type string (255)
timestamps timestamps

protfolio_refrences

id increments
name string (255)
protfolio_id integer
timestamps timestamps

protfolio_owners

id increments
owner_name string (255)
owner_type enum
contactg_person_name string (255)
contactg_person_job string (255)
contactg_person_phone string (100)
contactg_person_email string
adress text
owner_phone string (100)
owner_fax string (100)
owner_po string (100)
owner_email string (100)
timestamps timestamps

properties

id increments
protfolio_id integer
owner_id integer
address text
received_date date
account_number string (50)
phone string (50)
receipt_number string
property_no integer
latitude string (25)
longitude string (25)
estimated_value string (255)
property_value string (255)
built_date date
uses enum
timestamps timestamps
softDeletes softDeletes
location string (255)
cladding_type integer
sanitary_type integer
Leaseability_notes string (255)
finishing_type integer
space integer
power_delivery_date date
Expected_withdrawal_date date
Leaseability string (255)
Leaseability_date date
gaurd_id integer

property_services

id increments
title string (255)
code string (100)
description text
property_id integer
timestamps timestamps

property_supported_services

id increments
title string (255)
code string (100)
description text
property_id integer
timestamps timestamps

items

id increments
item_name string (255)
itemable_id integer
itemable_type string (255)
timestamps timestamps

gaurds

id increments
name string (255)
phone string (15)
description text
ream_emp string (100)
timestamps timestamps

permissions

id increments
timestamps timestamps
name string (255)

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