Rasid_Jack - Laravel Schema Designer

banks

id increments
name string
deactivated_at timestamp
iban_start string (5)
timestamps timestamps
softDeletes softDeletes

bank_accounts

id increments
model_type string
model_id bigInteger
bank_id ^FK bigInteger
iban string (255)
deactivated_at timestamp
softDeletes softDeletes
timestamps timestamps

activities

id increments
name string
deactivated_at timestamp
softDeletes softDeletes
timestamps timestamps

activity_expected_sales

id increments
activity_id ^FK bigInteger
max_sale_value float (12,2)
deactivated_at timestamp
timestamps timestamps

areas

id increments
name string
deactivated_at timestamp
softDeletes softDeletes
timestamps timestamps

cities

id increments
area_id ^FK bigInteger
deactivated_at timestamp
softDeletes softDeletes
timestamps timestamps

branches

id increments
company_id bigInteger
manager_id bigInteger
city_id ^FK bigInteger
deactivated_at timestamp
softDeletes softDeletes
timestamps timestamps

devices

id increments
serial string (255)
status tinyInteger
manager_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

managers

id increments
name string (100)
email string (100)
password string (100)
email_verified_at timestamp
blocked_key string
is_active tinyInteger
delegation_file string (100)
forget_code string (50)
phone string (20)
identification_number integer
user_type string
birthdate date
remember_token string (100)
deactivated_at timestamp
company_id bigInteger
reason text
softDeletes softDeletes
timestamps timestamps

companies

id increments
timestamps timestamps
softDeletes softDeletes
name string
forbidden_employ tinyInteger
email string (100)
tax_number string (255)
image string (255)
black_list tinyInteger
identity_num string (255)
reason text
commercial_register string (255)
deactivated_at timestamp
activity_id ^FK bigInteger
nationality_id bigInteger
married_status tinyInteger
type string
block_key string (255)
comission_id bigInteger
marketer_id bigInteger
whatsapp string (100)
telegram string (100)
bank_account_status tinyInteger

pos_users

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string (100)
email_verified_at timestamp
blocked_key string (255)
is_active tinyInteger
forget_code string (100)
phone string (30)
identification_number string (100)
serial_number string (255)
remember_token string (255)
deactivated_at timestamp
company_id ^FK bigInteger
branch_id ^FK bigInteger

delegates

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK bigInteger
delegate_phone_for string (80)
delegate_name_for string (100)
delegate_identity_for string (100)
status tinyInteger
note text
end_date date
delegate_file string (100)

transactions

id increments
timestamps timestamps
softDeletes softDeletes
amount float (12,2)
total_amount float (12,2)
total_commission float
pos_user_id ^FK bigInteger
ref_number string (100)
status tinyInteger
reason text
deactivated_at timestamp
company_id ^FK bigInteger
transfer_status tinyInteger
commission_id ^FK bigInteger
tax_id ^FK bigInteger
service_fee_id ^FK bigInteger
bank_service_fee_id ^FK bigInteger
tax_percent float
tax_value float
commission_percent float
commission_value float
service_fee_percent float
service_fee_value float
bank_service_fee_percent float
bank_service_fee_value float
commission_tax_value float
service_tax_value float
bank_service_fee_tax_value float

transfers

id increments
timestamps timestamps
softDeletes softDeletes
value float (12,2)
company_id ^FK bigInteger
from_date date
to_date date
status tinyInteger
total_amount float (12,2)
iban string (255)
total_commission float (12,2)

transfer_transaction

id increments
timestamps timestamps
softDeletes softDeletes
transaction_id ^FK bigInteger
transfer_id ^FK bigInteger

account_mangers

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string (100)
phone string (30)
email_veriified_at timestamp
remain_commission float (12,2)
get_commission float (12,2)

marketers

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string (100)
phone string (30)
email_veriified_at timestamp
remain_commission float (12,2)
get_commission float (12,2)

collectors

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string (100)
phone string (30)
email_veriified_at timestamp
get_commission float (12,2)
remain_commission float (12,2)

marketing_commission_values

id increments
timestamps timestamps
softDeletes softDeletes
app string (255)
value float (12,2)
company_id ^FK bigInteger
status tinyInteger
date date
collector_id ^FK bigInteger
marketer_id ^FK bigInteger
account_manager_id ^FK bigInteger
note text

marketing_com_transaction

id increments
timestamps timestamps
softDeletes softDeletes
transaction_id ^FK bigInteger
marketing_commission_value_id ^FK bigInteger

nationalities

id increments
timestamps timestamps
softDeletes softDeletes
name string
status tinyInteger

admins

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string (100)
password string (40)
email_verified_at timestamp
block_key string (100)
forget_code string (50)
deactivated_at timestamp
remember_token string (100)
identity_num string (255)
phone string (40)
department_id bigInteger
job_id bigInteger
nationality_id ^FK bigInteger
prevent_employees tinyInteger
type string
black_list tinyInteger
block tinyInteger
reason text
bank_id bigInteger
iban string (255)
generate_code string (255)

employees

id increments
timestamps timestamps
name string
email string (100)
identity_num string (100)
phone string (30)
nationality_id ^FK bigInteger
black_list tinyInteger
block tinyInteger
reasom text
generate_code string (100)

jobs

id increments
timestamps timestamps
name string
status tinyInteger
department_id bigInteger
commission_allow tinyInteger

departments

id increments
timestamps timestamps
name string
status tinyInteger

groups

id increments
timestamps timestamps
softDeletes softDeletes
name string
status tinyInteger

groupables

id increments
timestamps timestamps
softDeletes softDeletes
group_id ^FK bigInteger
groupable_type string
groupable_id bigInteger

auto_replies

id increments
timestamps timestamps
softDeletes softDeletes
service_name string
reply text

messages

id increments
timestamps timestamps
softDeletes softDeletes
content text
group_id ^FK bigInteger
messageable_id bigInteger
message_type string (100)

attribution_orders

id increments
timestamps timestamps
softDeletes softDeletes
account_manger_id ^FK bigInteger
activity_id ^FK bigInteger
city_id ^FK bigInteger
client_classify string
address text
deactivated_at timestamp
status tinyInteger

attribution_orders_details

id increments
timestamps timestamps
softDeletes softDeletes
attribution_order_id ^FK bigInteger
marketer_id ^FK bigInteger
clinet_id bigInteger
start_date date
end_date date
status tinyInteger

attribution_orders_clients

id increments
timestamps timestamps
softDeletes softDeletes
attribution_orders_detail_id ^FK bigInteger
marketer_id ^FK bigInteger
app string
status tinyInteger

marketer_clients

id increments
timestamps timestamps
softDeletes softDeletes
name string
image string
identity_num string
reason text
deactivated_at timestamp
activity_id ^FK bigInteger
nationality_id ^FK bigInteger
married_status tinyInteger
type string
marketer_id ^FK bigInteger

commissions

id increments
timestamps timestamps
softDeletes softDeletes
type string
value float (12,2)
status tinyInteger

taxes

id increments
timestamps timestamps
softDeletes softDeletes
date_od_starting date
percent float
deactivated_at timestamp

user_types

id increments
timestamps timestamps
softDeletes softDeletes
type string
deactivated_at timestamp

settings

id increments
timestamps timestamps
softDeletes softDeletes
title string
user_type_id ^FK bigInteger
type string
value float
options string
maximum_percent float
deactivated_at timestamp

marketing_commissions

id increments
timestamps timestamps
softDeletes softDeletes
user_type_id ^FK bigInteger
service_id bigInteger
job_id bigInteger
client_classfiy string
communication_type string
value float (12,2)
period integer
status tinyInteger
app string

paymeny_methods

id increments
timestamps timestamps
name string
deactivated_at timestamp

service_fee

id increments
timestamps timestamps
softDeletes softDeletes
paymeny_method_id ^FK bigInteger
percent float
maximum_value float
minimum_value float
deactivated_at timestamp

intermidate_banks

id increments
timestamps timestamps
softDeletes softDeletes
name string
deactivated_at timestamp

bank_service_fees

id increments
timestamps timestamps
softDeletes softDeletes
middel_bank_id ^FK bigInteger
percent float
value float
deactivated_at timestamp

double_commissions

id increments
timestamps timestamps
softDeletes softDeletes
contract_rasid_jack float
contract_rasid_m3ak float
contract_rasid_pos float
contract_rasid_pay float
case string
deactivated_at timestamp

marketing_period

id increments
timestamps timestamps
softDeletes softDeletes
period float
status tinyInteger
app string

commission_get_periods

id increments
timestamps timestamps
softDeletes softDeletes
job_id ^FK bigInteger
commission_type string
month_num integer
status tinyInteger
app string

indications

id increments
timestamps timestamps
softDeletes softDeletes
name string
repeat_num integer
deactivated_at timestamp

job_employee

id increments
timestamps timestamps
softDeletes softDeletes
job_id ^FK bigInteger
employee_id ^FK bigInteger

maximum_increase_ratios

id increments
timestamps timestamps
softDeletes softDeletes
percent_type string
percent float
status tinyInteger
from_date date
to_date date
note text
date_type string

streets

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
distrcit_id ^FK bigInteger

districts

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
city_id ^FK bigInteger