MoneyExchange - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
job_id ^FK integer
agency_id ^FK integer
slug string
registe_number string (255)
name string (255)
uv string
phone string (255)
email string (255)
password string
remember_token string
email_verified_at timestamp
status string (10)

customers

timestamps timestamps
id increments
softDeletes softDeletes
slug string
name string (255)
email string (255)
phone string (255)
nic_number string (255)
passport_number string
pass_expiry_date date
type_identification string
adresse string
ville string
status string (10)

agencys

id increments
timestamps timestamps
softDeletes softDeletes
partner_id ^FK integer
country_id ^FK integer
default_currency_id ^FK integer
slug string
uv string
cash string
name string (255)
commission string
alert_threshold string
open_hour time
close_hour time
status string (10)
use_mobile_pay string (10)

partners

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
default_currency_id ^FK integer
slug string
uv string
cash string
name string (255)
commission string
commission_rate string
status string (10)

jobs

id increments
timestamps timestamps
softDeletes softDeletes
slug string
name string (255)
status string (10)

countrys

id increments
timestamps timestamps
softDeletes softDeletes
currency_id ^FK integer
slug string
short_name string (255)
name string (255)
iso_code string (10)
phone_code string (10)
flag string (255)
status string (10)

intervals

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
currency_id ^FK integer
slug string
min decimal (15,2)
max decimal (15,2)
default string (10)
status string (10)

currencys

id increments
timestamps timestamps
softDeletes softDeletes
slug string
name string
iso_code string
iso_numeric string
symbol string
smallest_denomination string
status string (10)

transfer_fees

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
currency_id ^FK integer
interval_id ^FK integer
slug string
anount string
status string (10)

transfers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
beneficiary_user_id ^FK integer
box_id ^FK integer
sender_agency_id ^FK integer
beneficiary_agency_id ^FK integer
sender_customer_id ^FK integer
beneficiary_customer_id ^FK integer
beneficiary_country_id ^FK integer
transfer_fee_id ^FK integer
slug string
anount string
canceled string (10)
currency string
commission string
sending_code string
receipt_code string
transfer_fee_amount string
withdrawal_date timestamp
payment_method string (50)
mobile_api_token string (255)
status string

exchange_fees

id increments
timestamps timestamps
default string (10)
softDeletes softDeletes
currency_in_id ^FK integer
currency_out_id ^FK integer
slug string
my_anount_buy string
inter_amount_buy string
nat_amount_buy string
my_anount_sell string (255)
nat_amount_sell string (255)
inter_amount_sell string
status string

exchanges

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
box_id ^FK integer
customer_id ^FK integer
exchange_agency_id ^FK integer
cashout_agency_id ^FK integer
exchange_fee_id ^FK integer
country_withdrawal_id ^FK integer
amount string
currency string
sending_code string
slug string
receipt_code string
exchange_fee_amount string
local_withdrawal string (10)
withdrawal_date timestamp
motif string
autre_motif string
sell integer
status string

configs

id increments
timestamps timestamps
softDeletes softDeletes
default_currency_id ^FK integer
default_country_id ^FK integer
slug string
uv string
tva string
cash string
transfer_send_valid_message text
transfer_send_end_message text
exchange_send_valid_message text
exchange_send_end_message text
default_box_alert_threshold string
default_agency_alert_threshold string
default_open_hour time
default_close_hour time
status string (10)
use_mobile_pay string (10)

boxes

id increments
timestamps timestamps
softDeletes softDeletes
agency_id ^FK integer
slug string
name string (255)
alert_threshold string
status string (10)

commissions

id increments
timestamps timestamps
softDeletes softDeletes
box_id ^FK integer
user_id ^FK integer
agency_id ^FK integer
partner_id ^FK integer
slug string
anount string
status string (10)

payments_commissions

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
commission_id ^FK integer
slug string
anount string
status string (10)

cashs

id increments
timestamps timestamps
softDeletes softDeletes
slug string
currency_id ^FK integer
anount string
status string

cash_statements

id increments
timestamps timestamps
softDeletes softDeletes
user_box_id ^FK integer
admin_id ^FK integer
end_id ^FK integer
auditor_user_id ^FK integer
sender_user_id ^FK integer
beneficiary_user_id ^FK integer
slug string
uv integer
type string
date timestamp
open_to string (225)
start string (10)
end string (10)
audit_comment text
audit_status string (10)
rejet string (10)
rejet_description text
status string (10)

cash_bands

id increments
timestamps timestamps
softDeletes softDeletes
slug string
cash_id ^FK integer
cash_statement_id ^FK integer
quantity string
status string (10)

users_box

id increments
timestamps timestamps
softDeletes softDeletes
box_id ^FK integer
user_id ^FK integer
slug string
start_date timestamp
end_date timestamp
commission string
cash string
uv string
status string (10)

reloads_uv

id increments
timestamps timestamps
softDeletes softDeletes
users_id ^FK integer
agency_id ^FK integer
partner_id ^FK integer
users_box_id ^FK integer
reloader_id ^FK integer
slug string
amount string
type string (10)
status string (10)

password_reset_requests

id increments
timestamps timestamps
softDeletes softDeletes
users_id ^FK integer
admin_id ^FK integer
slug string
motif text
status string (10)

amount_cash_statements_currencies

id increments
timestamps timestamps
softDeletes softDeletes
cash_statement_id ^FK integer
currency_id ^FK integer
amount string (255)
status string (10)

amount_cash_users_box_currencies

id increments
timestamps timestamps
softDeletes softDeletes
user_box_id ^FK integer
currency_id ^FK integer
amount string (255)
status string (10)

amount_cash_agencies_currencies

id increments
timestamps timestamps
softDeletes softDeletes
currency_id ^FK integer
agency_id ^FK integer
amount string
status string (10)

amount_cash_partners_currencies

timestamps timestamps
softDeletes softDeletes
partner_id ^FK integer
currency_id ^FK integer
id increments
amount string
status string (10)

amount_cash_users_currencies

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
currency_id ^FK integer
amount string
status string (10)

audit_reports

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
cash_statement_id ^FK integer
slug string (225)
audit_comment text
status string (10)