rasid-m3ak - Laravel Schema Designer

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
email string (50)
national_id integer
password string (100)
is_active tinyInteger
email_verified_at date
phone string (25)
salary integer
date_of_birth date
monthly_outlay integer
available_funding integer
status tinyInteger
language_id integer
notification_status tinyInteger

users

id increments
timestamps timestamps
name string (100)
email string (50)
email_verified_at date
password string (50)
role_id ^FK integer
is_active tinyInteger

roles

id increments
timestamps timestamps
name string (100)
guard_name string (50)
slug string (100)

providers

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
category string (100)
logo string (100)
hot_line integer
branches_count integer
max_installments integer
profit_rate integer
facebook_url string (100)
linkedin_url string (100)
whatsapp_number string (100)
twitter_url string (100)

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
guard_name string (100)
slug string (100)

operattions

id increments
timestamps timestamps
provider_id ^FK integer
client_id ^FK integer
installment_count integer
installment_amount integer
main_amount integer
total_required integer
date date
status tinyInteger

notifications

id increments
timestamps timestamps
title string (50)
message string (150)
time datetime
status tinyInteger
client_id ^FK integer

installments

id increments
timestamps timestamps
operattion_id ^FK integer
date date
amount integer
status tinyInteger
delay_penalty integer
provider_id ^FK integer
client_id ^FK integer

invoices

id increments
timestamps timestamps
softDeletes softDeletes
amount integer
delay_penalty integer
tax double
total_required integer
date date

settings

id increments
timestamps timestamps
softDeletes softDeletes
title string (100)
type string (100)
value longText
user_id ^FK integer

invoice_installments

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id ^FK integer
installment_id ^FK integer

refunds

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id ^FK integer
invoice_amount integer
requested_amount integer
type tinyInteger
remaining_amount integer

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