Home
rasid_maak
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
clients
id
increments
timestamps
timestamps
softDeletes
softDeletes
national_id
integer
name
string
(255)
phone
string
(50)
alam_code
string
(10)
status
integer
password
integer
use_password
integer
dob
date
email
string
(255)
salary_month
string
(20)
monthly_commitments
string
(20)
salary_file
string
(150)
fundrequests
id
increments
timestamps
timestamps
softDeletes
softDeletes
client_id
FK
integer
expected_fund_amount
string
(100)
monthly_installment
string
(100)
month_count
integer
fund_amount
string
(10)
approve_contract
integer
settings
id
increments
timestamps
timestamps
rate_profit
string
(10)
rate_fundrequest
string
(10)
month_count
integer
maximum_monthly_commitment
integer
rete_provider
string
(10)
maximum_repayment_period
integer
low_repayment_period
integer
maximum_purchase_amount
string
(10)
minimum_purchase_amount
string
(10)
profit_rate
string
(10)
maximum_amount
string
(10)
late_rate
string
(10)
employee_rate
string
(10)
install_rate
string
(10)
manager_rate
string
(10)
start_install
integer
end_install
integer
latest_install
integer
users
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(255)
user_number
string
(50)
phone
integer
email
string
(100)
password
string
(50)
verify_code
string
(10)
national_id
integer
type
integer
orders
id
increments
timestamps
timestamps
softDeletes
softDeletes
client_id
FK
integer
order_no
integer
provider_id
integer
segl_no
string
(100)
tax_no
string
(100)
created_date
date
profit_rate
string
(10)
maximum_repayment_period
integer
minimum_repayment_period
integer
maximum_purchase_amount
string
(10)
minimum_purchase_amount
string
(10)
repeat_product_period
integer
status
integer
roles
id
increments
timestamps
timestamps
softDeletes
softDeletes
role_name
string
(150)
role
string
(255)
user_roles
id
increments
timestamps
timestamps
softDeletes
softDeletes
user_id
FK
integer
role_id
FK
integer
client_installments
id
increments
timestamps
timestamps
softDeletes
softDeletes
client_id
FK
integer
fund_id
FK
integer
revise_no
integer
install_amount
string
(50)
status
integer
due_date
date
pay_date
date
provider_id
integer
notifications
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(255)
detail
text
created_at
timestamp
status
integer
client_id
FK
integer
provider_id
integer
setting_providers
id
increments
timestamps
timestamps
softDeletes
softDeletes
provider_id
integer
profit_rate
string
(10)
maximum_repayment_period
integer
minimum_repayment_period
integer
maximum_invoice_pay
string
(20)
minimum_invoice_pay
string
(20)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01