rakeez - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
email string
country_code string
phone string
avatar string
is_active tinyInteger
otp string
otp_expire_at timestamps

chances

id increments
timestamps timestamps
softDeletes softDeletes
title_ar string
title_en string
description_ar text
description_en text
status tinyInteger
active tinyInteger
publish tinyInteger
category_id integer
risk_id integer
requested_amount decimal (20,2)
amount decimal (20,2)

investors

id increments
timestamps timestamps
softDeletes softDeletes
investor_group_id integer
iban_id integer
balance decimal (20,2)
initial_balance decimal (20,2)
name string
email string
phone string
status tinyInteger

roles_and_permissions

id increments
timestamps timestamps
softDeletes softDeletes

attachments

id increments
timestamps timestamps
softDeletes softDeletes
name string
ext string
url string
type string
width integer
height integer
mime string
attachmentable_id bigInteger
attachmentable_type string

activity_logs

id increments
timestamps timestamps
softDeletes softDeletes

countries

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

ibans

id increments
timestamps timestamps
softDeletes softDeletes
account_name_ar string
account_name_en string
iban string
bban string
used tinyInteger

categories

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

investor_groups

id increments
name_ar string
name_en string
timestamps timestamps
softDeletes softDeletes
max_investment_yearly decimal (20,2)
default tinyInteger
enable_max_investment tinyInteger
chance_min_investment decimal (20,2)
chance_max_investment decimal (20,2)

chance_investor_group

id increments
timestamps timestamps
softDeletes softDeletes
investor_group_id integer
chance_id integer
min decimal (20,2)
max decimal (20,2)

risks

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

chance_installments

id increments
timestamps timestamps
softDeletes softDeletes
percentage decimal (10,4)
period integer
date date
chance_id integer

investments

id increments
timestamps timestamps
investor_id integer
chance_id integer
total decimal (20,2)
profit decimal (20,2)

wallets

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
balance decimal (20,2)
initial_balance decimal (20,2)
iban_id integer

banks

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string
swift_code string

instruments

id increments
timestamps timestamps
softDeletes softDeletes
chance_id integer
serial_no string
amount decimal (20,2)
investor_id string

investment_details

id increments
timestamps timestamps
softDeletes softDeletes
investment_id integer
instrument_id integer
amount decimal (20,2)

wallet_transactions

id increments
timestamps timestamps
softDeletes softDeletes
old_balance decimal (20,2)
balance decimal (20,2)
amount decimal (20,2)
wallet_id integer
operation tinyInteger
details_ar text
details_en text
user_id integer
investor_transaction_id integer

investor_transactions

id increments
timestamps timestamps
softDeletes softDeletes
old_balance decimal (20,2)
balance decimal (20,2)
amount decimal (20,2)
investor_id integer
operation tinyInteger
details_ar text
details_en text
user_id integer
investment_id integer
chance_id integer

chance_documents

id increments
timestamps timestamps
softDeletes softDeletes
name string
status tinyInteger
notes text

investor_data

id increments
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes

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