real esatate - Laravel Schema Designer

contracts

id increments
landlord_id ^FK bigInteger
tenant_id ^FK bigInteger
property_id ^FK bigInteger
unit_id ^FK bigInteger
trn bigInteger
doc_no bigInteger
rent_amount double
contract_start_date date
contract_end_date date
created_date date
status enum
timestamps timestamps

rent_details

id increments
contract_id ^FK bigInteger
particular enum
sub_amount double
vat_percent double
vat_amount double
total_amount double
timestamps timestamps

payments

id increments
payment_method enum
cheq_no string
cheq_date date
payee_bank text
description longText
amount double
reason longText
status enum
timestamps timestamps

invoices

id increments
contract_id ^FK bigInteger
landlord_id ^FK bigInteger
tenant_id ^FK bigInteger
invoice_number string
sub_amount double
vat_amount double
total_amount double
date date
comments longText
timestamps timestamps

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