aqarless - Laravel Schema Designer

users

id increments
timestamps timestamps

units

id increments
timestamps timestamps
owner_id ^FK bigInteger

installment_durations

id increments
title string (255)
years_num tinyInteger
timestamps timestamps

payment_cycles

id increments
title string (255)
months_num tinyInteger
timestamps timestamps

payment_plans

id increments
title string
owner_id ^FK bigInteger
installment_duration_id ^FK bigInteger
down_payment decimal (8,2)
payment_cycle_id ^FK bigInteger
interest_ratio decimal (8,2)
timestamps timestamps

owners

id increments
user_id ^FK bigInteger
timestamps timestamps

contracts

id increments
unit_id ^FK bigInteger
owner_id ^FK bigInteger
payment_plan_id ^FK bigInteger
signature_date date
start_date date
end_date date
timestamps timestamps

installment_calc_durations

id increments
title string (255)
years_num tinyInteger
timestamps timestamps

Installment_calc_logs

id increments
user_id bigInteger
unit_price decimal
installment_duration_id bigInteger
installment_calc_cycle_id bigInteger
down_payments decimal
interest_ratio decimal (8,2)
timestamps timestamps

installment_calc_cycles

id increments
title string (255)
months_num tinyInteger
timestamps timestamps

installmenplanpayments

id increments
timestamps timestamps
contract_id ^FK bigInteger
payment_type_id ^FK bigInteger
payment_method_id ^FK bigInteger
status enum
date date
due_date date

payment_types

id increments
timestamps timestamps
name string (255)

payment_methods

id increments
timestamps timestamps
name string (255)

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