Home
Rasid_M3ak
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (1)
admins
id
increments
name
string
email
string
password
string
email_verified_at
timestamp
forget_code
string
deactive_at
timestamp
block
string
timestamps
timestamps
clinets
id
increments
name
string
password
string
identity_number
string
phone
string
email
text
verify_code
string
forget_code
string
expired_code_at
timestamp
monthly_ncome
float
(12,2)
ordered_vocabulary
string
available_balance
float
(15,2)
address
string
salary
float
(15,2)
image
string
block
string
notify
boolean
timestamps
timestamps
financiers
id
increments
first_name
string
second_name
string
third_name
string
last_name
string
address
string
categery_id
FK
bigInteger
phone
string
branches_number
integer
interest_rate
float
(3,2)
maximum_repayment_period
integer
minmum_repayment_period
integer
maximum_rasidma3k_Pay
float
minimum_rasidma3k_Pay
float
whatsApp
string
linkedin
text
facebook
text
twitter
text
bank_id
FK
bigInteger
iban
string
image
string
tax_number
string
manager_id
bigInteger
registration_number
string
files
string
status
tinyInteger
reason
text
accept_admin_id
bigInteger
notify
boolean
timestamps
timestamps
logs
id
increments
description
text
type
string
device_serial_number
string
admin_id
FK
bigInteger
page_id
bigInteger
timestamps
timestamps
transactions
id
increments
number
bigInteger
date
date
principal_amount
float
(12,2)
total_installments
float
(15,2)
installment_number
integer
remain_installement_number
integer
installment_value
float
(12,2)
client_id
FK
bigInteger
financier_id
FK
bigInteger
status
tinyInteger
timestamps
timestamps
installments
id
increments
number
integer
date
date
value
float
(12,2)
delay_penalty
float
(12,2)
status
tinyInteger
transaction_id
FK
bigInteger
timestamps
timestamps
public_settings
id
increments
percent
integer
month_number
integer
max_monthly_commitment
float
default_financer_percent
float
(3,2)
maximum_repayment_period
integer
minimum_repayment_period
integer
minimum_amount
float
(12,2)
maximum_amount
float
(12,2)
timestamps
timestamps
invoices
id
increments
number
integer
value
float
(12,2)
date
date
status
tinyInteger
reason
text
installment_id
FK
bigInteger
delay_penalty
float
value_added_tax
integer
invoice_id
FK
bigInteger
type
tinyInteger
timestamps
timestamps
notifications
id
increments
title
string
content
text
client_id
FK
bigInteger
financier_id
FK
bigInteger
read_at
timestamp
timestamps
timestamps
password_resets
id
increments
token
string
email
string
created_at
timestamp
timestamps
timestamps
monthly_commitments
id
increments
name
string
value
float
(15,2)
client_id
FK
bigInteger
status
tinyInteger
timestamps
timestamps
categories
id
increments
name
string
timestamps
timestamps
banks
id
increments
name
string
timestamps
timestamps
transaction_settings
id
increments
marketing_commission_percent
float
(3,2)
commission_due_on_installment
integer
percent
float
(3,2)
from_dept_id
bigInteger
to_dept_id
bigInteger
timestamps
timestamps
pages
id
increments
name
string
timestamps
timestamps
×
Comments for Rasid_M3ak
AhmedShaiboub . 09 June 2022
Hello Eng\Mahmoud I know That There are Three Table banks category and financers We will use It From Rasid Jack So That I suggest use It From External Connect From Rasid Ma3k To Rasid Jack Datebase Thanks
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01