RASID MA3AK - Laravel Schema Designer

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (192)
email string (255)
phone string (255)
photo string (255)
password string (255)
remember_token string (100)
status enum
birth_date timestamps
month_income double (8,2)
month_responsibilty double (8,2)
attachment_salary string (255)

transactions

id increments
timestamps timestamps
status enum
client_id ^FK integer
merchant_id integer
main_amount double (8,2)
total_fees double (8,2)
number_of_left_fee integer

installments

timestamps timestamps
id increments
merchant_id integer
cient_id ^FK integer
status enum
date_of_due timestamps
value_of_installment double (8,2)
payment_log_id integer

verification_codes

id increments
timestamps timestamps
phone string (255)
code string (255)
user_type string (255)
sms_provider string (255)
operation_type string (255)
verfied tinyInteger

payment_logs

id increments
timestamps timestamps
client_id ^FK integer
transaction_number string (255)
description string (255)
payment_method string (255)

merchants

id increments
timestamps timestamps
name string (255)
phone string (255)
email string (255)
avaialble_amount double (8,2)
percentage double (8,2)

account_manager

id increments
name string (255)
email string (255)
phone string (255)
timestamps timestamps
image string (255)
remember_token string (255)
is_block enum
password string (255)

marketing_officer

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
code string (255)
image string (255)
is_block enum
password string (255)
remember_token string (255)

collection_officer

id increments
name string (255)
phone string (255)
email string (255)
image string (255)
password string (255)
remember_token string (255)
timestamps timestamps

notifications

id increments
timestamps timestamps
clint_id ^FK integer
text string (255)
status enum
merchant_id ^FK integer

invoices

id increments
timestamps timestamps
client_id ^FK integer
basic_amount double (8,2)
repayment_period double (8,2)
monthly_installment double (8,2)
total double (8,2)
status string (255)

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