rentsure - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
last_name string
phone string
email string
password string
role_id ^FK integer
dealer_id integer

roles

id increments
title string

comments

id increments
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer
paragraph_id ^FK integer
user_id ^FK integer
contract_id ^FK integer

paragraphs

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
section_id ^FK integer
language_id ^FK integer
display_order integer
required boolean
default boolean
contract_type_id ^FK integer
price decimal
paragraph_type_id ^FK integer

persons

id increments
timestamps timestamps
softDeletes softDeletes
name string
address string
phone string
tax_id string
email string

building_types

id increments
title string

contract_types

id increments
title string

contracts

id increments
timestamps timestamps
softDeletes softDeletes
contract_type_id ^FK integer
building_type_id ^FK integer
language_id ^FK integer
expire datetime
user_id ^FK integer
tenant_id ^FK integer
landlord_id ^FK integer
building_id ^FK integer

contract_content

contract_id ^FK integer
paragraph_id ^FK integer
free_text text

languages

id increments
title string

sections

id increments
title string
display_order integer

paragraph_types

id increments
title string

repairings

id increments
timestamps timestamps
softDeletes softDeletes
person_id ^FK integer

repairing_content

repairing_id ^FK integer
paragraph_id ^FK integer

insurances

id increments
timestamps timestamps
softDeletes softDeletes
building_type_id ^FK integer
net_cost decimal
tax_cost decimal
start_date datetime
expire_date datetime
building_id ^FK integer

buildings

id increments
timestamps timestamps
softDeletes softDeletes
title string
address string
section string
flat string
rooms tinyInteger
floor tinyInteger
rent_rate integer
is_bail boolean
bank_id ^FK integer

banks

id increments
title string
parent_id ^FK integer

insurance_content

insurance_id ^FK integer
paragraph_id ^FK integer

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