rasid-m3ak - Laravel Schema Designer

merchants

id increments
name string
email string
phone string
logo string
Identification_number string
birth_date date
work_type enum
salary double
obligations double
insurances double
total_finance double
profit_rate double
forget_code string (10)
verfication_code string
password string
verfication_code_expiration_date date
maximum_repayment_period integer
minmum_repayment_period integer
profit_percentage double
ability_to_notify boolean
timestamps timestamps

transactions

id increments
amount double
total_Installments double
repayment_period integer
status enum
merchant_id integer
user_id integer
timestamps timestamps

notifications

id increments
title string
content text
is_read boolean
merchant_id integer
timestamps timestamps
notificationable_type string
notificationable_id integer

installments

id increments
installment_date date
payment_date date
amount double
transaction_id integer
status enum
timestamps timestamps
punish_of_delay double

users

id increments
name string
phone string
address text
email string
bank_id integer
verfication_code string
monthly_salary_amount double
monthly_commitments_amount double
Insurance_value double
marketer_id ^FK integer
forget_code string
verfication_code_expiration_date date
offers_letter_file string
expected_funding string
is_registerd_by_marketer boolean
timestamps timestamps
ability_to_notify boolean

financial_managers

id increments
name string
email string
phone string
timestamps timestamps
erp_id integer

marketers

id increments
timestamps timestamps
name string
email string
phone string
erp_id integer

collection_officer

id increments
name string
email string
phone string
erp_id integer
timestamps timestamps

invoices

id increments
payment_method string
status string
installment_id ^FK integer
amount double
punish_of_delay double
failure_reason text
timestamps timestamps
tax_value double

settings

id increments
financing_ratio double
months_financing double
maximum_monthly_commitments double
default_financier_percentage double
default_maximum_repayment_period double
efault_minimum_repayment_period double
default_maximum_purchase_amount double
default_minimum_purchase_amount double
interest_rate_transaction_amount double
maximum_amount_repaid double
date_of_first_installment double
late_fine_rate double
timestamps timestamps

commission_settings

id increments
marketer_commission_rate double
nstallment_number_to_pay_commission integer
from_installment string
to_installment integer
timestamps timestamps

commissions

id increments
amount double
commission_percentage double
commissionable_id integer
transaction_id ^FK integer
installment_id ^FK integer
timestamps timestamps
commissionable_type string

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