21 .pdf

amnesty
id INT(10)
credit_id INT(10)
employee_id INT(10)
fee DECIMAL(10,2)
overdueFee DECIMAL(10,2)
fine DECIMAL(10,2)

sms

penalty DECIMAL(10,2)
commission DECIMAL(10,2)

id INT(10)

expire_at DATETIME

sms_id INT(10)

created_at TIMESTAMP

connection VARCHAR(255)

updated_at TIMESTAMP

phone VARCHAR(11)

Indexes

message VARCHAR(200)
status ENUM(...)
error VARCHAR(255)

credit

created_at TIMESTAMP

id INT(10)

Indexes

client_id INT(10)
offer_id INT(10)

discount

payment_provider
id SMALLINT(5)

id INT(10)

name VARCHAR(45)

credit_id INT(10)

payment_property

Indexes

created_at TIMESTAMP

name VARCHAR(45)

updated_at TIMESTAMP

id INT(10)

status ENUM(...)

credit_id INT(10)

created_at TIMESTAMP

amount DECIMAL(10,2)

updated_at TIMESTAMP

period SMALLINT(5)

Indexes

fee DECIMAL(8,4)

Indexes

overdue_fee DECIMAL(8,4)
penalty DECIMAL(8,4)

id INT(10)

payment_id INT(10)

client_id INT(10)

payment_property_id INT(10)

payment_source_id INT(10)

value VARCHAR(255)

id INT(10)

external_id VARCHAR(38)

service_id INT(10)

document_id INT(10)

payment_system_id SMALLINT(5)

amount DECIMAL(10,2)

payment_provider_id SMALLINT(5)

created_at TIMESTAMP

Indexes

id INT(10)

tariff_step_id INT(10)

id INT(10)

payment

payment_source

amount DECIMAL(10,2)

Indexes

payment_details

credit_conditions

application_id INT(10)

commission DECIMAL(8,4)
tariff_grid_id INT(10)
repayment_scheme_id INT(10)

Indexes

recalculated TINYINT(1)
created_at TIMESTAMP
updated_at TIMESTAMP

repayment_scheme

updated_at TIMESTAMP

Indexes

id INT(10)

Indexes

name VARCHAR(255)
created_at TIMESTAMP
updated_at TIMESTAMP
Indexes

payment_system
id SMALLINT(5)
name VARCHAR(45)

repayment_priority

Indexes

repayment_scheme_id INT(10)
repayment_target_id SMALLINT(5)
priority SMALLINT(6)
Indexes

repayment_target
id SMALLINT(5)
name VARCHAR(45)
Indexes

offer
id INT(10)
document_id INT(10)
client_id INT(10)
created_at TIMESTAMP
updated_at TIMESTAMP
Indexes

tariff_step
id INT(10)

document

tariff_id INT(10)

id INT(10)
name VARCHAR(255)

number TINYINT(1)

tariff

Indexes

name VARCHAR(45)

id INT(10)

min_amount DECIMAL(10,2)

name VARCHAR(255)

max_amount DECIMAL(10,2)

created_at TIMESTAMP

overdue_fee DECIMAL(8,4)

updated_at TIMESTAMP

document_template

penalty DECIMAL(8,4)

Indexes

id INT(10)

commission DECIMAL(4,4)

document_id INT(10)

tariff_grid_id INT(10)

path VARCHAR(100)

Indexes

tariff_grid

is_active TINYINT(1)

id INT(10)

created_at TIMESTAMP

name VARCHAR(128)

updated_at TIMESTAMP

comment TEXT

application

Indexes

created_at TIMESTAMP

id INT(10)
client_id INT(10)

scoring_model
scoring_model_plugin
scoring_model_id INT(10)
scoring_plugin_id INT(10)

tariff_grid_values

scoring_model_id INT(10)

id INT(10)

status ENUM(...)

time SMALLINT(5)

amount DECIMAL(10,2)

sum INT(10)

approved_amount DECIMAL(10,2)

percent DECIMAL(4,4)

period SMALLINT(5)

tariff_grid_id INT(10)

id INT(10)

tariff_id INT(10)

name VARCHAR(255)

payment_system_id SMALLINT(5)

route_segment_transition

updated_at TIMESTAMP
Indexes

created_at TIMESTAMP

priority INT(11)

updated_at TIMESTAMP

Indexes

Indexes

route_point_priority
id INT(10)
route_segment_id INT(10)
route_point_id INT(10)

application_settings

priority TINYINT(1)

tariff_id INT(10)

Indexes

client_application_route_id INT(10)

application_route

guest_application_route_id INT(10)

offer_id INT(10)
Indexes

id INT(10)

alias VARCHAR(255)

application_route_id INT(10)

stage ENUM(...)

scoring_plugin

name VARCHAR(50)

route_segment_to_id INT(10)

Indexes

weight DECIMAL(8,2)

Indexes

id INT(10)

route_segment_from_id INT(10)

client_account_id INT(10)

Indexes

route_segment

id INT(10)

id INT(10)
name VARCHAR(255)

Indexes

start_route_segment_id INT(10)

name VARCHAR(255)

Indexes

description TEXT
Indexes

route_point
id INT(10)

phone

name VARCHAR(45)

id INT(10)

route_point_visit

client_id INT(10)
number VARCHAR(20)

client_account
id INT(10)

type ENUM(...)

id INT(10)

is_owner TINYINT(4)

client_id INT(10)

route_point_id INT(10)
application_route_id INT(10)
created_at TIMESTAMP

series INT(10)

Indexes

client_id INT(10)

passport

Indexes

number INT(10)

payment_source_id INT(10)

when DATE

Indexes

issuer VARCHAR(255)
subdivision VARCHAR(7)
birthday DATE
birthplace VARCHAR(255)
status ENUM(...)
Indexes

address

region

id INT(10)
street VARCHAR(200)

account_details
account_property
name VARCHAR(45)
Indexes

name VARCHAR(120)

id INT(10)

house VARCHAR(10)

client_account_id INT(10)

flat VARCHAR(10)

account_property_name VARCHAR(45)

corps VARCHAR(10)

value VARCHAR(255)

postal VARCHAR(6)

short_name VARCHAR(10)
id INT(10)

area

region_id INT(10)

Indexes

client_id INT(10)
created_at TIMESTAMP
updated_at TIMESTAMP

Indexes

game_account_history

created_at TIMESTAMP

phone VARCHAR(20)

updated_at TIMESTAMP

finished_at DATETIME

name VARCHAR(255)

ariuspay_session

UTC INT(11)

locality

name VARCHAR(120)
short_name VARCHAR(10)
postal_code VARCHAR(6)
region_id INT(10)

amount DECIMAL(10,2)

payture_session

bin SMALLINT(5)

client_id INT(10)

last_four_digits SMALLINT(5)

order_id VARCHAR(50)
started_at DATETIME
finished_at DATETIME

area_id INT(10)

type ENUM(...)

id INT(10)

Indexes

id INT(10)

paynet_orderid INT(10)

parent_id INT(10)
type ENUM(...)
center_status TINYINT(4)

status ENUM(...)

guid CHAR(36)

order_stage VARCHAR(32)

Indexes

Indexes

id INT(10)
client_id INT(10)
login VARCHAR(50)
pass VARCHAR(50)
Indexes

referrer TEXT
verification_method ENUM(...)

social_profile

created_at TIMESTAMP
updated_at TIMESTAMP
user_id INT(10)

is_hidden TINYINT(1)

client_id INT(10)

is_multiple TINYINT(1)

balance DECIMAL(10,2)

social_id VARCHAR(30)

client_id INT(10)

game_account
id INT(10)

client_id INT(10)

id INT(10)

Indexes

base_award INT(11)

id INT(10)

sms_planned

provider VARCHAR(50)

message VARCHAR(200)

created_at TIMESTAMP

plan_at TIMESTAMP

updated_at TIMESTAMP

Indexes

start_balance DECIMAL(10,2)

Indexes

social_detail
profile_id INT(10)
property_name VARCHAR(40)
value VARCHAR(255)
created_at TIMESTAMP

social_property
name VARCHAR(40)
Indexes

updated_at TIMESTAMP
Indexes

fssp_profile

Indexes

id INT(10)
client_id INT(10)

class VARCHAR(255)

email_reset

count INT(10)

id INT(10)

sum INT(10)

client_id INT(10)

has_credit TINYINT(4)

hash VARCHAR(32)

is_criminal TINYINT(4)

is_used TINYINT(1)

status ENUM(...)

user

created_at TIMESTAMP

service_availability
id INT(10)

Indexes

is_available TINYINT(1)

id INT(10)

updated_at TIMESTAMP

created_at TIMESTAMP

is_blocked TINYINT(1)

1 more...

updated_at TIMESTAMP

created_at TIMESTAMP

Indexes

service_id INT(10)

updated_at TIMESTAMP
Indexes

Indexes

employee
id INT(10)
user_id INT(10)
login VARCHAR(60)

assigned_roles

name VARCHAR(60)

role_id INT(10)

password VARCHAR(60)

user_id INT(10)

created_at TIMESTAMP

Indexes

updated_at TIMESTAMP
remember_token VARCHAR(100)

role
id INT(10)
name VARCHAR(255)
Indexes

role_permission
role_id INT(10)
permission_id INT(10)
Indexes

permission
id INT(10)
name VARCHAR(255)
alias VARCHAR(255)
Indexes

Indexes

service_permission
id INT(10)
is_permitted TINYINT(1)
created_at TIMESTAMP
updated_at TIMESTAMP
service_id INT(10)
employee_id INT(10)
Indexes

service
id INT(10)
name VARCHAR(255)
Indexes

street_postal

name VARCHAR(120)

street_id VARCHAR(255)

short_name VARCHAR(10)

postalcode VARCHAR(255)

postal_code VARCHAR(6)

id INT(11)

locality_id INT(10)

street_id1 INT(10)

Indexes

payture_user

reject_reason TEXT

street
id INT(10)

guid CHAR(36)

Indexes

need_manual_check_reason VARCHAR(255)

name VARCHAR(100)

Indexes

id INT(10)

endpoint SMALLINT(5)

Indexes

need_manual_check TINYINT(4)

game_action_id INT(10)

name VARCHAR(255)

application_route_id INT(10)

started_at DATETIME

need_verify_reason VARCHAR(255)

Indexes

Indexes

client_id INT(10)

need_verify TINYINT(4)

id INT(10)

game_achievement_id INT(10)

error VARCHAR(255)

email VARCHAR(60)

id INT(10)

game_achievement

game_award

utm_registration_id INT(10)

last_check DATE

created_at TIMESTAMP

description VARCHAR(200)

id INT(10)

employment ENUM(...)

is_new TINYINT(1)

event VARCHAR(255)

status ENUM(...)

is_employment_official TINYINT(4)

delta DECIMAL(8,2)

name VARCHAR(100)

operator_id INT(10)

sex ENUM(...)

game_achievement_id INT(10)

id INT(10)

amount DECIMAL(10,2)

middle_name VARCHAR(60)

Indexes

game_account_id INT(10)

game_action

actual_address_id INT(10)

last_name VARCHAR(60)

init_game_action_id INT(10)

Indexes

customer_reference VARCHAR(12)

first_name VARCHAR(60)

game_achievement_id INT(10)

class VARCHAR(255)

registered_address_id INT(10)

rehab_step INT(11)

game_condition

name VARCHAR(255)

client_id INT(10)

remember_token VARCHAR(100)

id INT(10)

Indexes

region_timezone

id INT(10)

password VARCHAR(64)

utm_record

code VARCHAR(60)

id INT(10)

client

Indexes

utm_property

timezone_id INT(10)
Indexes

cnp_transfer

utm_record_id INT(10)

region_timezone_id INT(10)
Indexes

guid CHAR(36)

Indexes

content VARCHAR(200)

timezone_id INT(10)

center_status TINYINT(4)

suburb_id INT(10)

utm_property_code VARCHAR(60)

name VARCHAR(120)

region_id INT(10)

locality_id INT(10)

utm_value

is_federal_city TINYINT(1)

short_name VARCHAR(10)

area_id INT(10)

guid CHAR(36)

id INT(10)

Indexes

alias VARCHAR(100)
uri VARCHAR(255)
Indexes