Splynx Database Schema

Complete database structure documentation with live data fetching

496
Total Tables
338
Relationships
4863
Total Columns

HS_finance_statement_callback

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
bank_statement_id int YES NULL
status varchar(255) YES NULL
Sample Data
Loading sample data...

HS_logs

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
message varchar(255) YES NULL
status varchar(255) YES NULL
mac varchar(255) YES NULL
customer varchar(255) YES NULL
voucher varchar(255) YES NULL
request text YES NULL
errors text YES NULL
date_time datetime YES NULL
Sample Data
Loading sample data...

HS_migration

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES NULL
Sample Data
Loading sample data...

HS_plan_usage

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
customer_id int NO MUL NULL
tariff_id int NO NULL
create_at datetime NO NULL
Sample Data
Loading sample data...

NCDO_background

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
start_time varchar(255) YES NULL
update_time varchar(255) YES NULL
status varchar(255) YES NULL
worker_class varchar(255) YES NULL
arguments varchar(255) YES NULL
pid varchar(255) YES NULL
progress double YES NULL
errors text YES NULL
total_count int YES NULL
with_errors_count int YES NULL
Sample Data
Loading sample data...

NCDO_charge_logs

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
message text YES NULL
status varchar(255) YES NULL
type varchar(30) NO NULL
additional_info text YES NULL
date_time datetime YES NULL
customer_id int YES NULL
invoice_id int YES NULL
Sample Data
Loading sample data...

NCDO_log

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
message varchar(255) YES NULL
status varchar(255) YES NULL
date_time varchar(255) YES NULL
type varchar(255) YES NULL
admin_id int YES NULL
customer_id int YES NULL
additional_info text YES NULL
Sample Data
Loading sample data...

NCDO_mandate

+
Table Structure (6 columns)
Column Type Null Key Default Extra
account_ref varchar(32) NO PRI NULL
pdf varchar(32) YES NULL
charge_day varchar(32) YES NULL
mandate_url varchar(255) YES NULL
status varchar(12) YES NULL
created_at datetime YES NULL
Sample Data
Loading sample data...

NCDO_migration

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES NULL
Sample Data
Loading sample data...

NCDO_payments

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
payment_id varchar(255) NO NULL
batch_name varchar(255) NO NULL
bank_statement_id int NO NULL
type varchar(255) NO NULL
invoices json YES NULL
batch_file varchar(255) NO NULL
file_token varchar(255) NO NULL
status varchar(255) YES new
created_at int NO NULL
updated_at int NO NULL
customer_id int YES NULL
Sample Data
Loading sample data...

NC_background

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
start_time varchar(255) YES NULL
update_time varchar(255) YES NULL
status varchar(255) YES NULL
worker_class varchar(255) YES NULL
arguments varchar(255) YES NULL
pid varchar(255) YES NULL
progress double YES NULL
errors text YES NULL
Sample Data
Loading sample data...

NC_log

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
message varchar(255) YES NULL
status varchar(255) YES NULL
date_time datetime YES NULL
order_id int YES NULL
customer_id int YES NULL
payment_type varchar(25) YES NULL
request_response text YES NULL
Sample Data
Loading sample data...

NC_migration

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES NULL
Sample Data
Loading sample data...

NC_pending_payment

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
bank_statement_id int YES NULL
status varchar(64) YES NULL
created_at int YES NULL
updated_at int YES NULL
Sample Data
Loading sample data...

SASA_api_limit

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
message varchar(255) YES NULL
created_at int YES NULL
updated_at int YES NULL
Sample Data
Loading sample data...

SASA_api_limit_counter

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
calls_count int YES NULL
date date YES NULL
created_at int YES NULL
updated_at int YES NULL
Sample Data
Loading sample data...

SASA_credit_note

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
customer_id int unsigned YES NULL
accounting_customer_id varchar(255) YES NULL
number varchar(255) YES NULL
date_created date YES NULL
items varchar(255) YES NULL
accounting_id varchar(255) YES NULL
total decimal(19,4) NO NULL
accounting_total decimal(19,4) NO NULL
total_tax decimal(19,4) NO NULL
accounting_total_tax decimal(19,4) NO NULL
created_at int YES NULL
updated_at int YES NULL
Relationships
References: → accounting_credit_notes.credit_note_id (via id)
Sample Data
Loading sample data...

SASA_customer

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(255) YES NULL
email varchar(255) YES NULL
phone varchar(255) YES NULL
street_1 varchar(255) YES NULL
city varchar(255) YES NULL
zip_code varchar(255) YES NULL
accounting_id varchar(255) YES NULL
billing_person varchar(255) YES NULL
billing_street_1 varchar(255) YES NULL
billing_zip_code varchar(255) YES NULL
billing_city varchar(255) YES NULL
created_at int YES NULL
updated_at int YES NULL
vat_id varchar(255) YES NULL
Relationships
References: → accounting_customers.customer_id (via id)
Sample Data
Loading sample data...

SASA_customers_manual_pairing

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id varchar(255) NO PRI NULL
name varchar(255) YES NULL
Sample Data
Loading sample data...

SASA_invoice

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
customer_id int unsigned YES NULL
accounting_customer_id varchar(255) YES NULL
number varchar(255) YES NULL
date_created date YES NULL
date_till date YES NULL
note varchar(255) YES NULL
items varchar(255) YES NULL
accounting_id varchar(255) YES NULL
created_at int YES NULL
updated_at int YES NULL
Relationships
References: → accounting_invoices.invoice_id (via id)
Sample Data
Loading sample data...

SASA_migration

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES NULL
Sample Data
Loading sample data...

SASA_pid_restriction

+
Table Structure (2 columns)
Column Type Null Key Default Extra
key varchar(255) NO PRI NULL
pid int NO PRI NULL
Sample Data
Loading sample data...

SAWB_archived_events

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
customerId int YES NULL
year int YES NULL
month int YES NULL
threatType varchar(255) YES NULL
domain varchar(512) YES NULL
eventsCount int YES NULL
Sample Data
Loading sample data...

SAWB_events

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
event_id varchar(128) YES NULL
timestamp int YES MUL NULL
resolver int YES NULL
action varchar(255) YES NULL
clientIP varchar(255) YES NULL
domain varchar(512) YES NULL
threatType varchar(255) YES NULL
identifier varchar(1024) YES NULL
coordinates varchar(255) YES NULL
countryCode varchar(64) YES NULL
customerId int YES NULL
serviceId int YES NULL
Sample Data
Loading sample data...

SAWB_migration

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES NULL
Sample Data
Loading sample data...

accounting_bank_accounts

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
accounting_id varchar(256) NO NULL
name varchar(256) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← payments_types.accounting_bank_accounts_id
Sample Data
Loading sample data...

accounting_categories

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
accounting_id varchar(256) NO NULL
name varchar(255) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← billing_transactions_categories.accounting_category_id
Sample Data
Loading sample data...

accounting_credit_notes

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
credit_note_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
accounting_id varchar(256) YES NULL
create_date datetime NO NULL
last_updated datetime NO NULL
accounting_status int YES NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → credit_notes.id (via credit_note_id)
Referenced by: ← SASA_credit_note.id
Sample Data
Loading sample data...

accounting_customers

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
accounting_id varchar(256) YES NULL
create_date datetime NO NULL
last_updated datetime NO NULL
accounting_status int YES NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← SASA_customer.id
Sample Data
Loading sample data...

accounting_invoices

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
invoice_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
accounting_id varchar(256) YES NULL
create_date datetime NO NULL
last_updated datetime NO NULL
accounting_status int YES NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → invoices.id (via invoice_id)
Referenced by: ← SASA_invoice.id
Sample Data
Loading sample data...

accounting_payments

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
payment_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
accounting_id varchar(256) YES NULL
create_date datetime NO NULL
last_updated datetime NO NULL
accounting_status int YES NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → payments.id (via payment_id)
Sample Data
Loading sample data...

accounting_tax_rates

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
accounting_id varchar(256) NO NULL
name varchar(256) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← tax.accounting_tax_rates_id
Sample Data
Loading sample data...

acs_device_activity_log

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
device_id int unsigned NO MUL NULL
model_class varchar(255) NO NULL
log_datetime datetime NO NULL
log_user_id int unsigned YES NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Relationships
References: → acs_devices.id (via device_id)
Sample Data
Loading sample data...

acs_device_tr_attributes

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(64) NO MUL NULL
title varchar(64) NO NULL
show_in_device_list enum('1','0') NO 0
show_in_customers_list enum('1','0') NO 0
show_in_customers_online_list enum('1','0') NO 0
refresh_every int unsigned NO 300
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← acs_device_tr_attributes_configs.name, acs_device_tr_attributes_values.name
Sample Data
Loading sample data...

acs_device_tr_attributes_configs

+
Table Structure (6 columns)
Column Type Null Key Default Extra
group_id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
acs_field varchar(255) NO NULL
writable enum('0','1') NO 0
field_type varchar(255) YES NULL
is_updated tinyint NO 0
Relationships
References: → acs_groups.id (via group_id), acs_device_tr_attributes.name (via name)
Sample Data
Loading sample data...

acs_device_tr_attributes_values

+
Table Structure (4 columns)
Column Type Null Key Default Extra
customer_id int unsigned YES MUL NULL
device_id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → customers.id (via customer_id), acs_devices.id (via device_id), acs_device_tr_attributes.name (via name)
Sample Data
Loading sample data...

acs_devices

+
Table Structure (25 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
internet_service_id int unsigned NO NULL
voice_service_id int unsigned NO NULL
recurring_service_id int unsigned NO NULL
device_id varchar(255) NO UNI NULL
type int unsigned NO MUL NULL
prefix varchar(255) NO NULL
group int unsigned NO MUL NULL
product_class varchar(255) NO NULL
model_name varchar(255) NO NULL
manufacturer varchar(255) NO NULL
oui varchar(255) NO NULL
serial_number varchar(255) NO NULL
software_version varchar(255) NO NULL
hardware_version varchar(255) YES NULL
last_inform datetime NO MUL NULL
registered datetime NO MUL NULL
auto_provisioning enum('0','1') NO 1
force_provisioning enum('0','1') NO 0
provisioned enum('yes','no','error') NO MUL no
last_provision datetime NO NULL
provision_retry_count int NO NULL
last_updated datetime NO NULL
uptime int YES NULL
Relationships
Referenced by: ← acs_device_activity_log.device_id, acs_device_tr_attributes_values.device_id, acs_devices_values.id
Sample Data
Loading sample data...

acs_devices_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
disabled enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← acs_devices_values.name
Sample Data
Loading sample data...

acs_devices_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → acs_devices.id (via id), acs_devices_fields.name (via name)
Sample Data
Loading sample data...

acs_groups

+
Table Structure (16 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
vendor varchar(255) NO MUL NULL
product_class varchar(255) NO NULL
software_version varchar(255) YES NULL
model_name varchar(255) NO NULL
partner_id int unsigned NO NULL
location_id int unsigned NO NULL
inventory_product_id int unsigned NO NULL
acs_type int unsigned NO NULL
periodic int unsigned YES NULL
auto_provisioning enum('0','1') NO 0
provisioning_code varchar(255) YES NULL
original_file_name varchar(255) YES NULL
file_name varchar(255) YES NULL
use_image_from_inventory enum('1','0') NO 0
Relationships
Referenced by: ← acs_device_tr_attributes_configs.group_id, acs_provisioning_flow.acs_group_id, acs_provisioning_flow_raw.acs_group_id
Sample Data
Loading sample data...

acs_provisioning_errors

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
acs_device_id int NO NULL
datetime_added datetime NO NULL
error varchar(255) NO NULL
Sample Data
Loading sample data...

acs_provisioning_flow

+
Table Structure (11 columns)
Column Type Null Key Default Extra
acs_group_id int unsigned NO MUL NULL
action varchar(255) YES update
object varchar(255) YES .
key varchar(255) NO NULL
selected varchar(64) NO NULL
value text NO NULL
type enum('string','boolean','unsignedInt','unsignedLong','int','long','base64','dateTime') NO string
position int unsigned NO NULL
object_position int unsigned YES 1
enabled enum('0','1') NO 1
count int unsigned YES 1
Relationships
References: → acs_groups.id (via acs_group_id)
Sample Data
Loading sample data...

acs_provisioning_flow_raw

+
Table Structure (5 columns)
Column Type Null Key Default Extra
acs_group_id int unsigned NO MUL NULL
device_id_clean varchar(255) NO NULL
device_clean_values longtext NO NULL
device_id_full varchar(255) NO NULL
device_full_values longtext NO NULL
Relationships
References: → acs_groups.id (via acs_group_id)
Sample Data
Loading sample data...

acs_types

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
Sample Data
Loading sample data...

acs_upgrade_batches

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
group_id int unsigned NO NULL
original_version varchar(255) NO
new_version varchar(255) NO
file varchar(255) NO
days varchar(36) NO 1,2,3,4,5
hours varchar(96) NO 1,2,3,4,5,6
event varchar(128) NO boot
max_try_count tinyint unsigned NO 3
max_devices_per_day smallint unsigned NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← acs_upgrade_records.upgrade_id
Sample Data
Loading sample data...

acs_upgrade_records

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
upgrade_id int unsigned NO MUL NULL
device_id int unsigned NO NULL
try_count tinyint unsigned NO 0
last_try_datetime datetime NO NULL
status varchar(64) NO new
deleted enum('0','1') NO 0
Relationships
References: → acs_upgrade_batches.id (via upgrade_id)
Sample Data
Loading sample data...

acs_values

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
device_id int unsigned NO MUL NULL
key varchar(255) NO NULL
value varchar(255) NO NULL
updated_at datetime NO NULL
Sample Data
Loading sample data...

activate_service_charge

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
customer_id int unsigned NO NULL
service_id int unsigned NO NULL
service_type enum('internet','voice','custom','bundle') NO MUL NULL
processed tinyint(1) NO 0
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
processed_at datetime YES NULL
processing_cancelled varchar(254) YES NULL
Sample Data
Loading sample data...

admin_customer_search_fields

+
Table Structure (5 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
source enum('main','additional','info') NO PRI NULL
enabled enum('1','0') NO NULL
search_operator enum('=','!=','>=','<=','>','<','<>','IS','REGEXP','LIKE','LIKE_OR','FIND_IN_SET','IN','BETWEEN') YES NULL
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

admin_onboarding

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO MUL NULL
onboarding_tour varchar(64) YES NULL
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

admin_reset_password

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
random_code varchar(90) NO NULL
datetime_added datetime NO NULL
admin_id int NO NULL
Sample Data
Loading sample data...

admin_show_hide_columns

+
Table Structure (7 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
model varchar(128) NO PRI NULL
module varchar(64) NO PRI NULL
property varchar(128) NO PRI
is_additional enum('1','0') NO PRI NULL
display enum('1','0') NO NULL
position tinyint unsigned NO NULL
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

admins

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
partner_id int unsigned NO MUL NULL
role_name varchar(32) NO MUL NULL
router_access enum('none','read','write','full') NO none
login varchar(64) NO NULL
name varchar(64) NO NULL
email varchar(64) NO NULL
password varchar(512) NO NULL
otp_secret varchar(512) NO NULL
timeout int unsigned NO 0
deleted enum('0','1') NO MUL 0
last_ip varchar(15) NO NULL
last_dt datetime NO NULL
phone varchar(256) NO
photo_version varchar(50) NO NULL
default_photo int NO 0
send_from_my_name enum('0','1') YES 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
calendar_color varchar(50) YES NULL
Relationships
References: → roles.name (via role_name)
Referenced by: ← admin_customer_search_fields.admin_id, admin_onboarding.admin_id, admin_show_hide_columns.admin_id, admins_imap.admin_id, admins_values.id, background_tasks.admin_id, google_account.admin_id, paired_calendars.admin_id, permissions_administrator.id, scheduling_task_timer.admin_id, ticket_agents.admin_id, ticket_assignments.admin_id
Sample Data
id0partner_id1role_name2router_access3login4name5email6password7otp_secret8timeout9deleted10last_ip11last_dt12phone13photo_version14default_photo15send_from_my_name16updated_at17calendar_color18
1100super-administratorsuper-administratornonenoneadminadminMain AdminMain Adminadmin1@splynx.comadmin1@splynx.comSKQiI0LRp6tMvxxBPSVZSMeEwEkzxHIup3OZq8o/6M0=SKQiI0LRp6tMvxxBPSVZSMeEwEkzxHIup3OZq8o/6M0=0000188.163.9.1188.163.9.12023-04-03 13:35:472023-04-03 13:35:4700002023-04-03 13:33:272023-04-03 13:33:27#4bf5f4#4bf5f4
2200super-administratorsuper-administratornonenonesplynxsplynxSplynx adminSplynx adminadmin2@splynx.comadmin2@splynx.comyfELVXXVKzjzhJxvechm6Obwk7utE+kDG91iioysQ9w=yfELVXXVKzjzhJxvechm6Obwk7utE+kDG91iioysQ9w=000085.159.5.21185.159.5.2112020-11-24 16:35:142020-11-24 16:35:1400002021-05-03 16:56:222021-05-03 16:56:22#be8df5#be8df5
3300super-administratorsuper-administratornonenonerichardrichardRichard WinderRichard Winderrichard@windstone.co.zarichard@windstone.co.zaoHHxtQsDIsZmCii1J/lcoQUCAnGTAFbZB43IzP+9+WKkeVJ...oHHxtQsDIsZmCii1J/lcoQUCAnGTAFbZB43IzP+9+WKkeVJ...001187.122.104.1587.122.104.152021-03-09 11:22:262021-03-09 11:22:26+4917632461595+491763246159500002021-03-09 11:22:262021-03-09 11:22:26

admins_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← admins_values.name
Sample Data
Loading sample data...

admins_imap

+
Table Structure (29 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL auto_increment
auth_type varchar(64) NO basic
oauth_id int unsigned YES NULL
imap_server varchar(128) NO
imap_port int NO 143
imap_username varchar(256) NO
imap_password varchar(512) NO
imap_chunk_size int NO 1000
enabled_imap_processing enum('1','0') NO MUL 0
imap_security_mode enum('none','ssl','tls') NO none
imap_what_find enum('all','unread') NO all
sent_mailbox varchar(128) NO
process_old enum('1','0') NO 0
imap_last_processing_date datetime YES NULL
mark_as_read enum('1','0') NO 1
smtp_type enum('none','use_system','use_office') NO none
enable_sending enum('1','0') YES 0
smtp_server varchar(128) NO
smtp_port int NO 25
smtp_security_mode enum('none','ssl','tls') NO none
smtp_username varchar(256) NO
smtp_password varchar(512) NO
no_validate_cert enum('0','1') NO 0
no_smtp_validate_cert enum('0','1') NO 0
reply_to varchar(256) YES NULL
link_emails enum('1','0') YES 1
admins_with_access text NO NULL
denylist text NO NULL
set_local_domain enum('1','0') NO 0
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

admins_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → admins.id (via id), admins_fields.name (via name)
Sample Data
Loading sample data...

api

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
partner_id int unsigned NO MUL NULL
title varchar(128) NO NULL
key varchar(32) NO NULL
secret varchar(512) NO NULL
unsecure_auth enum('0','1') NO 0
enable_logging enum('1','0') NO 0
check_nonce enum('1','0') NO 0
added_by_addon enum('1','0') NO 0
last_ip varchar(128) NO NULL
last_dt datetime NO NULL
last_nonce bigint unsigned NO NULL
white_list varchar(1024) NO []
usage_count bigint unsigned NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← api_values.id, permissions_api_key.id
Sample Data
Loading sample data...

api_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 1
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← api_values.name
Sample Data
Loading sample data...

api_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → api.id (via id), api_fields.name (via name)
Sample Data
Loading sample data...

auto_charge

+
Table Structure (22 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type enum('invoice','request','balances','prepaid') NO invoice
enabled enum('0','1') NO MUL 1
period enum('day_of_issue','1_day_after_issue','day_before_due_date','on_due_date','n_days_after_issue','day_of_month','hourly_day_of_issue','n_days_before_expiration') NO day_of_issue
period_time time NO 23:59:00
n_day smallint NO 0
admin_id int unsigned NO NULL
partners text NO NULL
location int unsigned NO NULL
payment_type int unsigned NO NULL
status varchar(128) YES
customer_id varchar(1024) NO
customer_status varchar(256) YES
customer_labels varchar(256) YES
external_handler varchar(256) NO
handler_params text NO NULL
total decimal(19,4) NO NULL
total_condition varchar(1) NO NULL
invoice_type enum('all','one_time','recurring') YES NULL
by_invoice tinyint(1) NO 1
n_day_expiration smallint unsigned YES NULL
use_available_balance tinyint(1) NO 0
Sample Data
Loading sample data...

background_tasks

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
pid int unsigned YES NULL
admin_id int unsigned YES MUL NULL
model varchar(128) NO MUL NULL
arguments mediumtext YES NULL
status enum('new','process','ready','error') YES MUL new
result_file varchar(256) YES NULL
progress int YES 0
deleted enum('0','1') NO 0
datetime_create datetime NO NULL
datetime_update datetime NO NULL
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

backup

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
category enum('manual','auto','remote') NO manual
datetime datetime YES NULL
admin_id int YES NULL
file_name_original varchar(255) YES NULL
size bigint unsigned YES 0
included text YES NULL
password varchar(255) YES NULL
status tinyint NO MUL 0
splynx_version varchar(255) YES NULL
Sample Data
Loading sample data...

bank_statements_process

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
date_time datetime NO MUL NULL
title varchar(64) NO MUL NULL
handler varchar(64) NO NULL
delimiter varchar(64) NO NULL
payment_type int unsigned NO NULL
status enum('new','fail','success') NO NULL
filename_original varchar(256) NO NULL
filename_uploaded varchar(128) NO NULL
filename_parsed varchar(128) NO NULL
records int NO NULL
processed int NO NULL
errors int NO NULL
canceled int NO 0
pending int NO 0
manual_paired int NO 0
ignored int NO 0
new int NO 0
deleted enum('0','1') NO 0
Relationships
Referenced by: ← bank_statements_records.bank_statements_process_id
Sample Data
Loading sample data...

bank_statements_records

+
Table Structure (24 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
bank_statements_process_id int unsigned NO MUL NULL
datetime datetime NO NULL
payment_date date NO NULL
amount decimal(19,4) NO NULL
status enum('new','processed','canceled','error','ignored','deleted','manual_paired','pending') NO new
pairing_1 varchar(64) NO NULL
pairing_2 varchar(64) NO NULL
pairing_3 varchar(64) NO NULL
additional_1 varchar(512) NO NULL
additional_2 varchar(512) NO NULL
additional_3 varchar(512) NO NULL
comment varchar(256) NO NULL
customer_id int unsigned YES MUL NULL
invoice_id int unsigned YES NULL
credit_note_id int unsigned YES NULL
request_id int unsigned YES NULL
payment_id int unsigned YES MUL NULL
transaction_id int unsigned YES NULL
callback_data json YES NULL
callback_status enum('new','processing','failed','processed') NO new
source enum('customer','admin','system','direct') YES NULL
errors json YES NULL
deleted enum('0','1') YES MUL 0
Relationships
References: → bank_statements_process.id (via bank_statements_process_id)
Sample Data
Loading sample data...

billing_transactions

+
Table Structure (27 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
sub_account_id int unsigned YES NULL
type enum('debit','credit') NO NULL
quantity int NO 1
unit varchar(32) NO NULL
price decimal(19,4) NO NULL
total decimal(19,4) NO NULL
remind_amount decimal(19,4) NO NULL
tax_percent decimal(6,4) NO NULL
tax_id int unsigned NO NULL
date date NO MUL NULL
category int unsigned NO MUL NULL
description varchar(256) NO NULL
comment varchar(512) NO NULL
period_from date NO NULL
period_to date NO NULL
to_invoice enum('0','1') NO 0
service_id int unsigned YES MUL NULL
service_type enum('internet','voice','custom','bundle','one_time') NO NULL
payment_id int unsigned YES NULL
invoice_id int unsigned YES MUL NULL
invoiced_by_id int unsigned YES MUL NULL
source enum('manual','auto','cdr','config') NO manual
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
credit_note_id int unsigned YES NULL
Relationships
References: → customers.id (via customer_id)
Referenced by: ← billing_transactions_values.id
Sample Data
Loading sample data...

billing_transactions_categories

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(64) NO MUL NULL
deleted enum('0','1') NO MUL 0
is_base enum('0','1') NO 0
accounting_category_id int unsigned YES MUL NULL
einvoicing_category_id int unsigned YES MUL NULL
einvoicing_private_person_category_id int unsigned YES MUL NULL
einvoicing_type_id int unsigned YES MUL NULL
einvoicing_private_person_type_id int unsigned YES MUL NULL
Relationships
References: → accounting_categories.id (via accounting_category_id), einvoicing_categories.id (via einvoicing_category_id), einvoicing_categories.id (via einvoicing_private_person_category_id), einvoicing_types.id (via einvoicing_private_person_type_id), einvoicing_types.id (via einvoicing_type_id)
Sample Data
Loading sample data...

billing_transactions_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← billing_transactions_values.name
Sample Data
Loading sample data...

billing_transactions_type

+
Table Structure (2 columns)
Column Type Null Key Default Extra
type varchar(64) NO PRI NULL
category_id int unsigned NO NULL
Sample Data
Loading sample data...

billing_transactions_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → billing_transactions.id (via id), billing_transactions_fields.name (via name)
Sample Data
Loading sample data...

bonus_capped_data

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int unsigned NO MUL NULL
quantity bigint unsigned NO 0
quantity_remind bigint unsigned NO 0
valid_till datetime YES NULL
Sample Data
Loading sample data...

bonus_traffic_counter

+
Table Structure (4 columns)
Column Type Null Key Default Extra
service_id int unsigned NO PRI NULL
date date NO PRI NULL
up bigint unsigned NO NULL
down bigint unsigned NO NULL
Sample Data
Loading sample data...

bundle

+
Table Structure (28 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
available_for_services enum('0','1') NO 1
show_on_customer_portal enum('0','1') NO 0
hide_on_admin_portal enum('0','1') NO 0
service_description varchar(64) NO NULL
price decimal(19,4) NO 0.0000
billing_days_count smallint unsigned YES NULL
with_vat enum('0','1') NO 1
vat_percent decimal(6,4) NO 0.0000
tax_id int unsigned NO NULL
partner_id int unsigned NO NULL
activation_fee decimal(19,4) unsigned NO 0.0000
get_activation_fee_when enum('create_service','first_service_billing') NO NULL
issue_invoice_while_service_creation enum('0','1') NO 0
deactivation_fee decimal(19,4) unsigned NO 0.0000
contract_duration int unsigned NO NULL
automatic_renewal enum('0','1') NO 0
auto_reactivate enum('0','1') NO 0
cancellation_fee decimal(19,4) unsigned YES 0.0000
prior_cancellation_fee decimal(19,4) unsigned NO 0.0000
change_to_other_bundle_fee decimal(19,4) unsigned NO 0.0000
discount_period int unsigned NO NULL
discount_value decimal(19,4) YES NULL
discount_type enum('percent','fixed') NO percent
transaction_category_id int unsigned NO 0
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← bundle_module_labels.id, bundle_to_billing_types.bundle_id, bundle_to_customer_categories.bundle_id, bundle_to_locations.bundle_id, bundle_to_partners.bundle_id, bundle_to_tariffs_custom.bundle_id, bundle_to_tariffs_internet.bundle_id, bundle_to_tariffs_voice.bundle_id, bundle_values.id
Sample Data
Loading sample data...

bundle_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← bundle_values.name
Sample Data
Loading sample data...

bundle_module_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → bundle.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

bundle_to_billing_types

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO PRI NULL
billing_type varchar(255) NO PRI NULL
Relationships
References: → bundle.id (via bundle_id)
Sample Data
Loading sample data...

bundle_to_customer_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO PRI NULL
customer_category varchar(255) NO PRI NULL
Relationships
References: → bundle.id (via bundle_id)
Sample Data
Loading sample data...

bundle_to_locations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO PRI NULL
location_id int unsigned NO PRI NULL
Relationships
References: → bundle.id (via bundle_id), locations.id (via location_id)
Sample Data
Loading sample data...

bundle_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → bundle.id (via bundle_id), partners.id (via partner_id)
Sample Data
Loading sample data...

bundle_to_tariffs_custom

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO MUL NULL
tariff_id int unsigned NO MUL NULL
Relationships
References: → bundle.id (via bundle_id), tariffs_custom.id (via tariff_id)
Sample Data
Loading sample data...

bundle_to_tariffs_internet

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO MUL NULL
tariff_id int unsigned NO MUL NULL
Relationships
References: → bundle.id (via bundle_id), tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

bundle_to_tariffs_voice

+
Table Structure (2 columns)
Column Type Null Key Default Extra
bundle_id int unsigned NO MUL NULL
tariff_id int unsigned NO MUL NULL
Relationships
References: → bundle.id (via bundle_id), tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

bundle_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → bundle.id (via id), bundle_fields.name (via name)
Sample Data
Loading sample data...

callback_authentication

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO UNI NULL
secret varchar(64) NO NULL
Sample Data
Loading sample data...

calls

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
from varchar(32) NO MUL NULL
to varchar(32) NO MUL NULL
duration int unsigned NO NULL
direction enum('incoming','outgoing') YES NULL
comment text YES NULL
recording_url text YES NULL
voice_file_url text YES NULL
ticket_id int unsigned YES NULL
client_id int unsigned YES NULL
agent_id int unsigned YES NULL
datetime datetime NO NULL
added_by enum('system','api','admin') YES NULL
added_by_id int YES NULL
deleted enum('0','1') NO 0
Sample Data
Loading sample data...

cap_notifications

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariff_id int unsigned NO NULL
type enum('mail_cap','sms_cap') NO mail_cap
source enum('total_usage','monthly_limit','cap_data','top_up','auto_top_up') NO monthly_limit
reached tinyint unsigned YES 1
template int unsigned YES NULL
subject varchar(256) YES NULL
deleted enum('1','0') NO MUL 0
Sample Data
Loading sample data...

cap_tariff

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariff_id int unsigned NO NULL
title varchar(64) NO NULL
amount bigint NO NULL
amount_in enum('mb','gb') NO mb
price decimal(19,4) NO 0.0000
type enum('manual','automatic') NO manual
validity varchar(20) NO NULL
validity_number int unsigned NO 0
to_invoice enum('0','1') NO 0
transaction_category_id int unsigned NO 0
deleted enum('0','1') NO 0
Sample Data
Loading sample data...

capped_data

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int unsigned NO MUL NULL
quantity bigint NO 0
quantity_remind bigint NO 0
over_usage bigint unsigned NO 0
valid_till datetime NO NULL
transaction_id int unsigned NO MUL NULL
end_of_period enum('1','0') NO 0
added_by enum('system','admin','customer','api') NO admin
type enum('customer_top_up','admin_top_up','api_top_up','auto_top_up','rollover_unused','rollover_to_next_month') YES NULL
deleted enum('0','1') NO 0
Relationships
References: → services_internet.id (via service_id)
Sample Data
Loading sample data...

cards_prepaid

+
Table Structure (40 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
serie int unsigned NO MUL NULL
status enum('new','active','expired','used','disabled') NO MUL new
changed enum('Y','N') NO N
price decimal(19,4) NO NULL
prefix varchar(32) NO NULL
short_login varchar(32) NO NULL
login varchar(64) NO NULL
password varchar(512) NO NULL
seller_name varchar(512) NO NULL
full_name varchar(64) NO NULL
email varchar(64) NO NULL
phone varchar(64) NO NULL
expired_by enum('valid_date','activation_time') NO NULL
time_expired int unsigned NO NULL
time_expired_selector enum('minutes','hours','days') NO minutes
valid_till date NO NULL
activated_at datetime NO NULL
pool_id int NO -1
partner_id int unsigned NO NULL
location_id int unsigned NO NULL
speed_upload int unsigned NO NULL
speed_download int unsigned NO NULL
traffic_in_total bigint unsigned NO MUL NULL
traffic_in_used bigint unsigned NO NULL
traffic_out_total bigint unsigned NO MUL NULL
traffic_out_used bigint unsigned NO NULL
traffic_all_total bigint unsigned NO MUL NULL
traffic_all_used bigint unsigned NO NULL
time_online_selector enum('minutes','hours','days') NO minutes
time_online int unsigned NO MUL NULL
time_online_used int unsigned NO NULL
created_at datetime NO NULL
remark varchar(256) NO NULL
deleted enum('1','0') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
mac varchar(12) NO MUL NULL
customer_id int unsigned YES MUL 0
tariff_id int unsigned YES MUL 0
invoice_id int unsigned YES MUL 0
Relationships
Referenced by: ← cards_prepaid_online.card_id, cards_prepaid_values.id
Sample Data
Loading sample data...

cards_prepaid_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← cards_prepaid_values.name
Sample Data
Loading sample data...

cards_prepaid_online

+
Table Structure (16 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
card_id int unsigned NO MUL NULL
nas_id int unsigned NO NULL
nas_ip varchar(45) NO NULL
login varchar(128) NO MUL NULL
in_bytes bigint unsigned NO NULL
out_bytes bigint unsigned NO NULL
start_session datetime NO NULL
ipv4 varbinary(4) NO NULL
mac varchar(32) NO NULL
call_to varchar(32) NO NULL
port varchar(32) NO NULL
time_on int unsigned NO NULL
last_change datetime NO NULL
session_id varchar(48) NO MUL NULL
nas_identifier varchar(64) YES NULL
Relationships
References: → cards_prepaid.id (via card_id)
Sample Data
Loading sample data...

cards_prepaid_statistics

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
card_id int unsigned NO MUL NULL
nas_id int unsigned NO NULL
login varchar(128) NO NULL
in_bytes bigint unsigned NO NULL
out_bytes bigint unsigned NO NULL
start_date date NO PRI NULL
start_time time NO NULL
end_date date NO NULL
end_time time NO NULL
ipv4 varbinary(4) NO NULL
mac varchar(32) NO NULL
call_to varchar(32) NO NULL
port varchar(32) NO NULL
error tinyint(1) NO NULL
error_repeat int NO NULL
session_id varchar(32) NO MUL NULL
terminate_cause tinyint unsigned NO NULL
nas_identifier varchar(64) YES NULL
Sample Data
Loading sample data...

cards_prepaid_statistics_cache

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
cards_prepaid_statistics_id int unsigned NO NULL
card_id int unsigned NO MUL NULL
session_id varchar(48) NO NULL
date_time datetime NO MUL NULL
Sample Data
Loading sample data...

cards_prepaid_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → cards_prepaid.id (via id), cards_prepaid_fields.name (via name)
Sample Data
Loading sample data...

cards_refill

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
serie int unsigned NO MUL NULL
status enum('active','expired','used','disabled') NO active
changed enum('Y','N') NO N
price decimal(19,4) NO NULL
prefix varchar(32) NO NULL
code varchar(512) NO NULL
seller_name varchar(512) NO NULL
valid_till date NO NULL
activated_at datetime NO NULL
customer_id int unsigned NO NULL
partner_id int unsigned NO NULL
created_at datetime NO NULL
remark varchar(256) NO NULL
deleted enum('1','0') NO MUL 0
Relationships
Referenced by: ← cards_refill_values.id
Sample Data
Loading sample data...

cards_refill_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← cards_refill_values.name
Sample Data
Loading sample data...

cards_refill_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → cards_refill.id (via id), cards_refill_fields.name (via name)
Sample Data
Loading sample data...

cdr_auto_import_history

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
cdr_import_entry_point_id int unsigned NO MUL NULL
cdr_history_id int unsigned YES MUL NULL
file_path varchar(255) NO NULL
datetime datetime NO NULL
datetime_created datetime NO NULL
status enum('process','ready','error','empty','warning','deleted') NO MUL ready
result_files text YES NULL
info text YES NULL
all_rows int unsigned NO 0
good_rows int unsigned NO 0
error_rows int unsigned NO 0
warning_rows int unsigned NO 0
Relationships
References: → cdr_history.id (via cdr_history_id), cdr_import_entry_point.id (via cdr_import_entry_point_id)
Sample Data
Loading sample data...

cdr_errors

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
import_id int unsigned NO MUL NULL
voice_type enum('call','message','data') NO call
error_type enum('warning','error') NO error
source varchar(48) NO
destination varchar(48) YES
datetime datetime NO NULL
data text NO NULL
errors text NO NULL
Sample Data
Loading sample data...

cdr_history

+
Table Structure (14 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
status enum('new','finished') NO new
datetime datetime NO NULL
provider_id int unsigned YES NULL
filename varchar(64) NO NULL
filename_uploaded varchar(64) NO NULL
delimiter varchar(64) NO NULL
type enum('call','message','data','mixed') NO call
handler varchar(64) NO NULL
data_unit enum('b','kb','mb','gb') YES NULL
is_first_row_contain_names enum('1','0') NO 0
selected_columns text YES NULL
deleted enum('1','0') NO 0
source enum('manual','auto','api') NO auto
Relationships
Referenced by: ← cdr_auto_import_history.cdr_history_id
Sample Data
Loading sample data...

cdr_import_entry_point

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO UNI NULL
import_data_source_id int unsigned NO MUL NULL
file_name_pattern varchar(255) YES NULL
is_first_row_contain_names tinyint(1) NO 1
delimiter varchar(50) NO NULL
type varchar(50) NO NULL
voice_providers_id int unsigned YES MUL NULL
handler varchar(255) NO NULL
data_unit varchar(50) YES NULL
columns text YES NULL
launch_time_interval int NO NULL
last_launch_time datetime YES NULL
max_processing_time smallint unsigned NO 300
import_from_mtime datetime YES NULL
status enum('new','process','ready','error','stopping','stopped','warning') NO new
enabled tinyint(1) NO 0
background_task_id int unsigned YES NULL
info text YES NULL
Relationships
References: → import_data_source.id (via import_data_source_id), voice_providers.id (via voice_providers_id)
Referenced by: ← cdr_auto_import_history.cdr_import_entry_point_id
Sample Data
Loading sample data...

charge_balances

+
Table Structure (22 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
source enum('manual','auto') NO manual
created_at datetime NO NULL
charge_status text NO NULL
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
partners text NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
statuses text NO NULL
customer_id text NO NULL
customer_status varchar(256) YES
customer_labels varchar(256) YES
external_handler text NO NULL
params text NO NULL
filename_real text NO NULL
filename_download text NO NULL
extension text NO NULL
amount_due decimal(19,4) NO NULL
total_condition text NO NULL
by_invoice tinyint(1) NO 1
Sample Data
Loading sample data...

charge_invoices

+
Table Structure (25 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
source enum('manual','auto') NO manual
created_at datetime NO NULL
charge_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
from date NO NULL
to date NO NULL
partners text NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
status varchar(128) NO NULL
invoice_type varchar(32) NO NULL
customer_id varchar(128) NO NULL
customer_status varchar(256) YES
customer_labels varchar(256) YES
number varchar(128) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
total decimal(19,4) NO NULL
total_condition varchar(1) NO NULL
Sample Data
Loading sample data...

charge_prepaid

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
source enum('manual','auto') NO manual
created_at datetime NO NULL
charge_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
partners text NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
customer_id text NO NULL
customer_status varchar(256) YES
customer_labels varchar(256) YES
external_handler text NO NULL
params text NO NULL
filename_real text NO NULL
filename_download text NO NULL
extension text NO NULL
minimum_charge_amount decimal(19,4) NO NULL
use_available_balance tinyint(1) NO 0
Sample Data
Loading sample data...

charge_requests

+
Table Structure (24 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
source enum('manual','auto') NO manual
created_at datetime NO NULL
charge_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
from date NO NULL
to date NO NULL
partners text NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
status varchar(128) NO NULL
customer_id varchar(128) NO NULL
customer_status varchar(256) YES
number varchar(128) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
total decimal(19,4) NO NULL
total_condition varchar(1) NO NULL
customer_labels varchar(256) YES
Sample Data
Loading sample data...

cloud_client_clients

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
enabled enum('0','1') NO 1
name varchar(256) NO NULL
comment text YES NULL
connect_to varchar(256) NO NULL
mode enum('tcp','udp') NO udp
port int NO 1194
username varchar(256) NO NULL
password varchar(256) NO NULL
auth enum('sha1','md5') NO sha1
cipher enum('ES-CBC','RC2-CBC','DES-EDE-CBC','DES-EDE3-CBC','DESX-CBC','BF-CBC','RC2-40-CBC','CAST5-CBC','RC2-64-CBC','AES-128-CBC','AES-192-CBC','AES-256-CBC') NO BF-CBC
ca text NO NULL
cert text NO NULL
key text NO NULL
routes text NO NULL
tls_auth text NO NULL
full_file longtext NO NULL
ip varchar(32) NO NULL
tls_key_direction enum('not_set','0','1') NO not_set
remote_cert_tls enum('0','1') NO 1
Sample Data
Loading sample data...

cloud_server_clients

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
enabled enum('0','1') NO MUL 1
name varchar(32) NO MUL NULL
comment text YES NULL
ip varchar(32) NO NULL
ip_id int unsigned NO NULL
username varchar(255) NO NULL
password varchar(255) NO NULL
routes text NO NULL
last_connection datetime NO NULL
Sample Data
Loading sample data...

config

+
Table Structure (5 columns)
Column Type Null Key Default Extra
module varchar(64) NO PRI NULL
path varchar(64) NO PRI NULL
key varchar(64) NO PRI NULL
type text YES NULL
value text NO NULL
Sample Data
Loading sample data...

config_partner

+
Table Structure (6 columns)
Column Type Null Key Default Extra
partner_id int unsigned NO PRI NULL
module varchar(64) NO PRI NULL
path varchar(64) NO PRI NULL
key varchar(64) NO PRI NULL
type text YES NULL
value varchar(535) NO NULL
Sample Data
Loading sample data...

config_product

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
product_id int NO MUL NULL
module varchar(64) NO NULL
path varchar(64) NO NULL
key varchar(64) NO NULL
type varchar(64) NO NULL
value varchar(255) NO NULL
Sample Data
Loading sample data...

controllers

+
Table Structure (2 columns)
Column Type Null Key Default Extra
source varchar(255) NO PRI NULL
disabled enum('yes','no') NO no
Sample Data
Loading sample data...

cost_categories

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(64) NO NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← costs.category_id, fixed_costs.category_id
Sample Data
Loading sample data...

costs

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
category_id int unsigned NO MUL NULL
supplier_invoice_id int unsigned YES NULL
fixed_cost_id int unsigned NO NULL
description text YES NULL
date_time datetime NO NULL
amount decimal(19,4) NO NULL
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → cost_categories.id (via category_id)
Referenced by: ← costs_values.id
Sample Data
Loading sample data...

costs_fields

+
Table Structure (22 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← costs_values.name
Sample Data
Loading sample data...

costs_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → costs.id (via id), costs_fields.name (via name)
Sample Data
Loading sample data...

cpe

+
Table Structure (27 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
title varchar(128) NO NULL
host varchar(128) NO NULL
api_login varchar(32) NO NULL
api_password varchar(512) NO NULL
api_port int unsigned NO 8728
status enum('unknown','error_connection','api_error','api_ok') NO NULL
gps varchar(256) YES NULL
is_changed enum('0','1') NO MUL NULL
change_status enum('0','1') NO 1
last_status datetime NO MUL NULL
last_update datetime NO NULL
last_connect datetime NO NULL
type varchar(128) NO NULL
signal varchar(128) NO NULL
is_used enum('0','1') NO MUL NULL
used_date_time datetime NO NULL
cpe_status text NO NULL
cpe_interfaces text NO NULL
cpe_wireless text NO NULL
cpe_wireless_interfaces text NO NULL
connection_error int NO MUL NULL
service_id int unsigned NO NULL
qos enum('0','1') NO 1
qos_target varchar(128) NO NULL
deleted enum('0','1') NO MUL NULL
Relationships
References: → customers.id (via customer_id)
Referenced by: ← cpe_ap.cpe_id, cpe_dhcp.id, cpe_qos.cpe_id, cpe_values.id
Sample Data
Loading sample data...

cpe_ap

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
cpe_id int unsigned NO MUL NULL
name varchar(32) NO NULL
mode enum('alignment-only','ap-bridge','bridge','nstreme-dual-slave','station','station-bridge','station-pseudobridge','station-pseudobridge-clone','station-wds','wds-slave') NO NULL
interface varchar(32) NO NULL
master varchar(32) NO NULL
protocol enum('802.11','nstreme','nv2') NO 802.11
frequency varchar(32) NO auto
band varchar(32) NO NULL
channel_width varchar(32) NO NULL
country varchar(64) NO NULL
security varchar(256) NO NULL
encryption varchar(256) NO NULL
password varchar(512) NO NULL
enabled enum('0','1') NO 1
Relationships
References: → cpe.id (via cpe_id)
Sample Data
Loading sample data...

cpe_dhcp

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
enabled enum('0','1') NO 0
name varchar(32) NO NULL
interface varchar(32) NO NULL
lease_time int unsigned NO 10
network varchar(32) NO NULL
gateway varchar(32) NO NULL
pool_from varchar(32) NO NULL
pool_to varchar(32) NO NULL
dns_servers varchar(256) NO NULL
wins_server varchar(256) NO NULL
Relationships
References: → cpe.id (via id)
Sample Data
Loading sample data...

cpe_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 1
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← cpe_values.name
Sample Data
Loading sample data...

cpe_qos

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
cpe_id int unsigned NO MUL NULL
title varchar(128) NO NULL
dst varchar(128) NO NULL
speed_in int unsigned NO NULL
speed_out int unsigned NO NULL
limit_at tinyint unsigned NO NULL
priority tinyint unsigned NO NULL
Relationships
References: → cpe.id (via cpe_id)
Sample Data
Loading sample data...

cpe_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → cpe.id (via id), cpe_fields.name (via name)
Sample Data
Loading sample data...

credit_notes

+
Table Structure (16 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
number varchar(64) YES MUL NULL
date_created date NO NULL
real_create_datetime datetime NO NULL
date_updated date NO NULL
date_payment date NO NULL
total decimal(19,4) NO NULL
status enum('not_refunded','refunded','deleted','used') NO not_refunded
remind_amount decimal(19,4) NO NULL
is_sent enum('0','1') NO 0
note text NO NULL
payment_id int NO NULL
added_by enum('system','api','admin') NO system
added_by_id int NO NULL
deleted enum('0','1') YES MUL 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← accounting_credit_notes.credit_note_id, credit_notes_items.credit_note_id, credit_notes_to_invoices.credit_note_id, credit_notes_values.id, einvoicing_credit_notes.credit_note_id
Sample Data
Loading sample data...

credit_notes_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
disabled enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← credit_notes_values.name
Sample Data
Loading sample data...

credit_notes_items

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
credit_note_id int unsigned NO MUL NULL
sub_account_id int unsigned YES NULL
position smallint unsigned NO MUL NULL
description varchar(256) NO NULL
quantity int NO NULL
unit varchar(16) NO NULL
price decimal(19,4) NO NULL
tax decimal(6,4) NO NULL
tax_id int unsigned NO NULL
transaction_id int unsigned NO NULL
invoice_item_id int unsigned YES NULL
deleted enum('0','1') YES MUL 0
Relationships
References: → credit_notes.id (via credit_note_id)
Sample Data
Loading sample data...

credit_notes_to_invoices

+
Table Structure (3 columns)
Column Type Null Key Default Extra
credit_note_id int unsigned NO PRI NULL
invoice_id int unsigned NO PRI NULL
reset_period_for_service enum('1','0') NO 0
Relationships
References: → credit_notes.id (via credit_note_id), invoices.id (via invoice_id)
Sample Data
Loading sample data...

credit_notes_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → credit_notes.id (via id), credit_notes_fields.name (via name)
Sample Data
Loading sample data...

crm_activity_log

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
lead_id int unsigned NO MUL NULL
model_class varchar(255) NO NULL
log_datetime datetime NO NULL
log_user_id int unsigned YES NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Relationships
References: → customers.id (via lead_id)
Sample Data
Loading sample data...

crm_lead_owner_notifications

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
lead_id int NO NULL
admin_id int NO NULL
note_id int YES NULL
datetime datetime NO NULL
scheduled_send_time datetime NO MUL NULL
title varchar(50) YES NULL
message text NO NULL
is_done enum('0','1') NO 0
is_send enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

crm_lead_status_logs_changes

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
lead_id int unsigned NO MUL NULL
old_status int unsigned NO NULL
new_status int unsigned NO NULL
datetime datetime NO NULL
duration_in_previous_status int unsigned NO NULL
changed_by enum('admin','api') NO admin
changed_by_id int unsigned NO NULL
deleted enum('1','0') NO 0
Relationships
References: → leads_info.customer_id (via lead_id)
Sample Data
Loading sample data...

crm_leads_pipeline

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(64) NO NULL
is_base enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
label varchar(8) NO default
bg_color varchar(22) NO rgba(255,255,255,1)
is_bg_color tinyint NO 0
stage enum('crm_lead_stage_new','crm_lead_stage_in_progress','crm_lead_stage_qualified','crm_lead_stage_unqualified') NO crm_lead_stage_new
due_days smallint NO 0
position int unsigned NO 1
Sample Data
Loading sample data...

customer_activity_log

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
administrator_id int unsigned NO NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_datetime datetime NO NULL
log_entry_id int unsigned NO NULL
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_billing

+
Table Structure (33 columns)
Column Type Null Key Default Extra
customer_id int unsigned NO PRI NULL
reminder_enable enum('0','1') NO 1
enabled enum('0','1') NO 0
billing_person varchar(128) NO NULL
billing_street_1 varchar(255) NO NULL
billing_zip_code varchar(32) NO NULL
billing_city varchar(32) NO NULL
type tinyint NO 1
deposit decimal(19,4) NO 0.0000
payment_method varchar(64) NO NULL
billing_date tinyint unsigned NO 1
billing_due tinyint unsigned NO 15
blocking_period tinyint NO 0
grace_period tinyint NO 10
make_invoices enum('0','1') NO 1
min_balance decimal(19,4) NO 0.0000
request_auto_enable enum('0','1') NO 0
month_price decimal(19,4) NO 0.0000
blocking_date date NO 0000-00-00
request_auto_day tinyint unsigned NO 1
request_auto_type tinyint unsigned NO 1
request_auto_period tinyint unsigned NO 0
request_auto_next date NO NULL
send_finance_notification enum('0','1') NO 1
reminder_day_1 tinyint unsigned NO 2
reminder_day_2 tinyint unsigned NO 8
reminder_day_3 tinyint unsigned NO 20
reminder_payment enum('0','1') NO 0
reminder_payment_value decimal(19,4) NO 0.0000
reminder_payment_comment varchar(255) NO NULL
reminder_type enum('0','1','2') NO 0
partner_percent decimal(5,2) YES NULL
sub_billing_mode enum('aggregated','independent') NO independent
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_cap

+
Table Structure (6 columns)
Column Type Null Key Default Extra
customer_id int unsigned NO PRI NULL auto_increment
auto_cap enum('1','0') NO 0
limitation_type enum('auto_top_up','manual_top_up','any_top_up') NO auto_top_up
max_cap_during_month int YES 10
transfer_usage_to_new_service enum('1','0') NO 1
deleted enum('1','0') NO 0
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_disabling

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
date_disabling date NO NULL
date_enabling date NO NULL
customer_id int unsigned NO MUL NULL
service_id int unsigned NO NULL
service_type enum('internet','voice','custom','bundle') NO NULL
status varchar(64) NO NULL
enabled enum('no','yes','error') NO MUL no
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_documents

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
hash_id varchar(32) NO NULL
added_by enum('admin','customer','system','api') NO admin
added_by_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
type enum('uploaded','generated','contract') YES NULL
title varchar(64) NO NULL
created_at datetime NO NULL
updated_at datetime NO NULL
description varchar(512) NO NULL
visible_by_customer enum('1','0') NO 0
filename_original varchar(256) NO NULL
filename_uploaded varchar(64) NO NULL
code mediumtext NO NULL
sign_date datetime YES NULL
terms_month smallint YES NULL
deleted enum('0','1') NO MUL 0
thumbnail varchar(256) NO
status enum('','new','sent','signed','rejected','expired') NO
Relationships
References: → customers.id (via customer_id)
Referenced by: ← customer_documents_values.id
Sample Data
Loading sample data...

customer_documents_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← customer_documents_values.name
Sample Data
Loading sample data...

customer_documents_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → customer_documents.id (via id), customer_documents_fields.name (via name)
Sample Data
Loading sample data...

customer_info

+
Table Structure (7 columns)
Column Type Null Key Default Extra
customer_id int unsigned NO PRI NULL
birthday varchar(64) NO NULL
passport varchar(32) NO NULL
company_id varchar(32) NO NULL
vat_id varchar(32) NO NULL
contact_person varchar(256) NO
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_notes

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
datetime datetime NO NULL
administrator_id int unsigned NO NULL
type enum('comment','message','call','customer','finance','service','support') NO comment
class varchar(32) NO NULL
title varchar(50) YES NULL
name varchar(255) NO NULL
comment text NO NULL
values text NO NULL
scheduled_send_time datetime YES MUL NULL
assigned_to int NO NULL
is_done enum('0','1') NO 0
is_send enum('0','1') NO 0
deleted enum('0','1') NO 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
is_pinned tinyint unsigned NO 0
pinned_date datetime YES NULL
is_edited tinyint(1) NO 0
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customer_rate_tables

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO
is_tax_included enum('0','1') NO 0
Relationships
Referenced by: ← customer_rates.table_id
Sample Data
Loading sample data...

customer_rates

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
table_id int unsigned NO MUL NULL
name varchar(255) NO
description varchar(512) NO
type enum('call','message','data') NO MUL call
category_id int unsigned YES MUL NULL
prefix varchar(96) NO MUL
price decimal(19,4) NO 0.0000
first_step int unsigned NO 1
tariffication_step int unsigned NO 1
connect_cost decimal(19,4) NO 0.0000
Relationships
References: → voice_categories.id (via category_id), customer_rate_tables.id (via table_id)
Referenced by: ← customer_rates_cache.pair_id
Sample Data
Loading sample data...

customer_rates_cache

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO MUL NULL auto_increment
haystack varchar(48) NO PRI
pair_id int unsigned NO MUL NULL
Relationships
References: → customer_rates.id (via pair_id)
Sample Data
Loading sample data...

customers

+
Table Structure (28 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
billing_type enum('recurring','prepaid','prepaid_monthly') NO NULL
partner_id int unsigned NO NULL
location_id int unsigned NO NULL
parent_id int YES MUL 0
added_by enum('admin','api','widget') NO MUL admin
added_by_id int unsigned NO NULL
status enum('new','active','blocked','disabled') NO MUL new
login varchar(128) NO MUL NULL
category enum('person','company','lead') NO person
password varchar(512) NO NULL
name varchar(256) NO NULL
email varchar(256) NO NULL
billing_email varchar(256) YES NULL
phone varchar(256) NO NULL
street_1 varchar(255) NO NULL
zip_code varchar(32) NO NULL
city varchar(32) NO NULL
subdivision_id int YES NULL
gps varchar(256) YES NULL
gdpr_agreed enum('empty_answer','decline','accept') YES empty_answer
date_add date NO MUL NULL
last_online datetime NO NULL
deleted enum('1','0') NO MUL 0
last_update datetime NO NULL
daily_prepaid_cost decimal(19,4) NO NULL
mrr_total decimal(19,4) unsigned NO 0.0000
conversion_date datetime YES NULL
Relationships
Referenced by: ← accounting_customers.customer_id, acs_device_tr_attributes_values.customer_id, billing_transactions.customer_id, cpe.customer_id, credit_notes.customer_id, crm_activity_log.lead_id, customer_activity_log.customer_id, customer_billing.customer_id, customer_cap.customer_id, customer_disabling.customer_id, customer_documents.customer_id, customer_info.customer_id, customer_notes.customer_id, customers_deleted_info.customer_id, customers_labels.id, customers_values.id, einvoicing_credit_notes.customer_id, einvoicing_invoices.customer_id, incoming_customer.customer_id, inventory_items.customer_id, inventory_items_flow.customer_id, invoices.customer_id, lba_main_config.customer_id, leads_info.customer_id, payment_account_data.customer_id, pending_top_up.customer_id, portal_messages.customer_id, portal_onboarding.customer_id, quotes.customer_id, read_news_to_customer.customer_id, requests.customer_id, services_bundle.customer_id, services_custom.customer_id, services_internet.customer_id, services_voice.customer_id, statuses_pending.customer_id, welcome_message.customer_id
Sample Data
id0billing_type1partner_id2location_id3parent_id4added_by5added_by_id6status7login8category9password10name11email12billing_email13phone14street_115zip_code16city17subdivision_id18gps19gdpr_agreed20date_add21last_online22deleted23last_update24daily_prepaid_cost25mrr_total26conversion_date27
11recurringrecurring33282800adminadmin44activeactivemwinder01mwinder01personperson44OEVhXLOEHM5dx8/cg23YPSxAPUqKtaGq03/IccHd4=44OEVhXLOEHM5dx8/cg23YPSxAPUqKtaGq03/IccHd4=Matthew WinderMatthew Windersanel@rapidnetworks.co.zasanel@rapidnetworks.co.zamatthew@rapidnetworks.co.zamatthew@rapidnetworks.co.za+27794344249+2779434424912 Turquoise Street12 Turquoise Street73577357LangebaanLangebaan-33.05483900906192,18.046803474426266-33.05483900906192,18.046803474426266empty_answerempty_answer2020-08-052020-08-052026-02-27 23:19:562026-02-27 23:19:56002026-02-19 17:48:422026-02-19 17:48:420.00000.000022000.000022000.0000
22recurringrecurring11282800adminadmin44disableddisabledwindstone01windstone01personpersonwr0FlMQkSK74XW7hr1O4Cn2lW5h3pbPN11Fp3NM8iFs=wr0FlMQkSK74XW7hr1O4Cn2lW5h3pbPN11Fp3NM8iFs=Matthew WinderMatthew Windermatthew@windstone.co.zamatthew@windstone.co.zamatthew@windstone.co.zamatthew@windstone.co.za+27634338551+27634338551Windstone Farm, R45 RoadWindstone Farm, R45 Road73807380VredenburgVredenburg-32.944657592946164,18.096252679824826-32.944657592946164,18.096252679824826empty_answerempty_answer2020-08-052020-08-052020-12-23 07:30:482020-12-23 07:30:48112020-12-23 07:32:512020-12-23 07:32:510.00000.00000.00000.0000
33recurringrecurring33292900adminadmin44activeactivejeanpierrejeanpierrepersonpersonQf8X38WKJwG2TZJH2a2jYY+0sB4iR4SfA+bJQZJg2+Y=Qf8X38WKJwG2TZJH2a2jYY+0sB4iR4SfA+bJQZJg2+Y=JP de BruynJP de Bruynjp@rapidnetworks.co.zajp@rapidnetworks.co.zajp@rapidnetworks.co.zajp@rapidnetworks.co.za+27835199068+2783519906809 Bloemhof Street09 Bloemhof Street73807380VredenburgVredenburg99-32.91053187258067,17.984844446182247-32.91053187258067,17.984844446182247empty_answerempty_answer2020-08-062020-08-062026-02-27 23:19:322026-02-27 23:19:32002026-02-19 14:07:452026-02-19 14:07:450.00000.00000.00000.0000

customers_deleted_info

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
related_data json YES NULL
deleted enum('0','1') NO 0
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

customers_fields

+
Table Structure (24 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
category varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← customers_values.name
Sample Data
Loading sample data...

customers_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → customers.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

customers_online

+
Table Structure (26 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO NULL
tariff_id int unsigned NO NULL
partner_id int unsigned NO NULL
nas_id int unsigned NO NULL
nas_ip varchar(45) NO NULL
login varchar(128) NO MUL NULL
username_real varchar(128) NO NULL
in_bytes bigint unsigned NO NULL
out_bytes bigint unsigned NO NULL
start_session datetime NO NULL
ipv4 varbinary(4) NO NULL
ipv6 varbinary(16) NO NULL
ipv6_prefix tinyint NO NULL
mac varchar(32) NO NULL
call_to varchar(32) NO NULL
port varchar(32) NO NULL
price decimal(19,4) NO NULL
time_on int unsigned NO MUL NULL
last_change datetime NO NULL
type enum('radius','mikrotik_api','netflow') NO MUL NULL
login_is enum('user','mac','user-no-traffic') NO NULL
session_id varchar(48) NO MUL NULL
blocked enum('1','0') NO 0
nas_identifier varchar(64) NO NULL
Sample Data
Loading sample data...

customers_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → customers.id (via id), customers_fields.name (via name)
Sample Data
Loading sample data...

dns_domains

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
host varchar(255) NO NULL
ip varchar(39) NO NULL
Sample Data
Loading sample data...

einvoicing_categories

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
einvoicing_id varchar(256) NO NULL
name varchar(255) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← billing_transactions_categories.einvoicing_category_id, billing_transactions_categories.einvoicing_private_person_category_id
Sample Data
Loading sample data...

einvoicing_credit_notes

+
Table Structure (14 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
credit_note_id int unsigned NO MUL NULL
customer_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
einvoicing_id varchar(256) YES NULL
einvoicing_status enum('new','pending','unknown','error','ok') YES new
created_date datetime NO NULL
updated_date datetime NO NULL
field_1 varchar(256) YES NULL
field_2 varchar(256) YES NULL
field_3 varchar(256) YES NULL
field_4 varchar(256) YES NULL
field_5 varchar(256) YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → credit_notes.id (via credit_note_id), customers.id (via customer_id)
Sample Data
Loading sample data...

einvoicing_invoices

+
Table Structure (14 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
invoice_id int unsigned NO MUL NULL
customer_id int unsigned NO MUL NULL
modified enum('0','1') NO 1
einvoicing_id varchar(256) YES NULL
einvoicing_status enum('new','pending','unknown','error','ok') YES new
created_date datetime NO NULL
updated_date datetime NO NULL
field_1 varchar(256) YES NULL
field_2 varchar(256) YES NULL
field_3 varchar(256) YES NULL
field_4 varchar(256) YES NULL
field_5 varchar(256) YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → customers.id (via customer_id), invoices.id (via invoice_id)
Sample Data
Loading sample data...

einvoicing_payment_methods

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
einvoicing_id varchar(256) NO NULL
name varchar(256) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← payments_types.einvoicing_payment_methods_id
Sample Data
Loading sample data...

einvoicing_tax_rates

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
einvoicing_id varchar(256) NO NULL
name varchar(256) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← tax.einvoicing_tax_rates_id
Sample Data
Loading sample data...

einvoicing_types

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
einvoicing_id varchar(256) NO NULL
name varchar(255) NO NULL
additional_1 text YES NULL
additional_2 text YES NULL
additional_3 text YES NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← billing_transactions_categories.einvoicing_private_person_type_id, billing_transactions_categories.einvoicing_type_id
Sample Data
Loading sample data...

entry_points_allows

+
Table Structure (3 columns)
Column Type Null Key Default Extra
module varchar(255) NO NULL
place varchar(255) NO NULL
hide_for_aggr_sub_lba tinyint(1) NO 0
Sample Data
Loading sample data...

error_cards_session

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
card_id int unsigned NO MUL NULL
error tinyint unsigned NO NULL
date date NO NULL
last_time time NO NULL
repeat int NO NULL
Sample Data
Loading sample data...

error_session

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int unsigned NO MUL NULL
error tinyint unsigned NO NULL
date date NO NULL
last_time time NO NULL
repeat int NO NULL
Sample Data
Loading sample data...

export_credit_notes

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int NO NULL
created_at datetime NO NULL
export_status enum('new','process','ready','error') NO new
amount_ready int NO NULL
amount_total int NO NULL
from date NO NULL
to date NO NULL
partners varchar(4096) NO NULL
location int NO NULL
payment int NO NULL
status varchar(32) NO NULL
export_type varchar(32) NO NULL
csv_options text NO NULL
template varchar(256) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
Sample Data
Loading sample data...

export_invoices

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
created_at datetime NO NULL
export_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
from date NO NULL
to date NO NULL
partners varchar(4096) NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
status varchar(32) NO NULL
export_type varchar(32) NO NULL
csv_options text NO NULL
template varchar(256) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
Sample Data
Loading sample data...

export_payments

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
created_at datetime NO NULL
export_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
from date NO NULL
to date NO NULL
partners varchar(4096) NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
payment_types varchar(255) NO 0
export_type varchar(32) NO NULL
csv_options text NO NULL
template varchar(256) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
Sample Data
Loading sample data...

export_requests

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO NULL
created_at datetime NO NULL
export_status enum('new','process','ready','error') NO new
amount_ready int unsigned NO NULL
amount_total int unsigned NO NULL
from date NO NULL
to date NO NULL
partners varchar(4096) NO NULL
location int unsigned NO NULL
payment int unsigned NO NULL
status varchar(32) NO NULL
export_type varchar(32) NO NULL
csv_options text NO NULL
template varchar(256) NO NULL
external_handler varchar(256) NO NULL
params text NO NULL
filename_real varchar(256) NO NULL
filename_download varchar(64) NO NULL
extension varchar(12) NO NULL
Sample Data
Loading sample data...

file_manager

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO NULL
filename varchar(128) NO NULL
size int unsigned NO NULL
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
is_uploading tinyint(1) NO 0
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

files_upload

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
hash_id varchar(32) NO NULL
type varchar(64) NO NULL
filename_original varchar(256) NO NULL
filename_uploaded varchar(256) NO NULL
thumbnail varchar(256) NO
Relationships
Referenced by: ← finance_template_values.file_logo, mail_messages_to_files_upload.file_id, ticket_messages_to_files_upload.file_id
Sample Data
Loading sample data...

finance_history

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
date date NO MUL NULL
created_at datetime YES NULL
partner_ids text YES NULL
transactions int unsigned NO NULL
invoices int unsigned NO NULL
requests int unsigned NO NULL
file varchar(128) NO NULL
voice_file varchar(128) NO NULL
status enum('generating','error','new','unconfirmed','confirmed','processed','canceled','new_canceled','partially_canceled') NO MUL new
message varchar(256) NO
background_task_id int unsigned NO 0
Sample Data
Loading sample data...

finance_template_values

+
Table Structure (29 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
invoice_template_id int unsigned NO NULL
request_template_id int unsigned NO NULL
quote_template_id int NO NULL
receipt_template_id int unsigned NO NULL
reminder_mail_template_id int unsigned NO NULL
reminder_sms_template_id int unsigned NO NULL
report_statements_template_id int unsigned YES NULL
company_name varchar(128) NO NULL
street_1 varchar(128) NO NULL
street_2 varchar(128) NO NULL
zip varchar(24) NO NULL
city varchar(64) NO NULL
country varchar(64) NO NULL
iso_country varchar(64) NO
email varchar(128) NO NULL
phone varchar(64) NO NULL
company_id varchar(64) NO NULL
company_vat varchar(64) NO NULL
vat_percent decimal(6,4) unsigned NO 0.0000
tax_id int unsigned NO NULL
bank_account varchar(128) NO NULL
bank_name varchar(128) NO NULL
bank_id varchar(128) NO NULL
bank_address varchar(128) NO NULL
splynx_url varchar(128) NO NULL
partner_percent decimal(5,2) NO 0.00
file_logo int unsigned YES MUL NULL
credit_note_template_id int unsigned NO NULL
Relationships
References: → files_upload.id (via file_logo)
Sample Data
Loading sample data...

finger_prints

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int NO NULL
device_type varchar(32) NO
os varchar(32) NO
name varchar(64) NO
finger_print_cookies varchar(255) NO NULL
device_info text NO NULL
added_time datetime NO NULL
Sample Data
Loading sample data...

fixed_costs

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
category_id int unsigned NO MUL NULL
description text YES NULL
enabled enum('0','1') NO 1
cost_for_today enum('0','1') NO 0
start_date date NO NULL
end_date date NO NULL
amount decimal(19,4) NO NULL
periodicity enum('monthly','quarterly','half-yearly','yearly') NO monthly
deleted enum('0','1') NO MUL 0
Relationships
References: → cost_categories.id (via category_id)
Sample Data
Loading sample data...

fup_compiled

+
Table Structure (11 columns)
Column Type Null Key Default Extra
service_id int unsigned NO PRI NULL
traffic_accounting enum('0','1') NO 1
time_accounting enum('0','1') NO 1
fup_policy int unsigned YES MUL NULL
blocked enum('0','1') YES 0
restored enum('0','1') YES 0
is_hard enum('0','1') NO NULL
decrease_percent tinyint unsigned YES 0
fixed_up int unsigned NO 0
fixed_down int unsigned NO 0
changed enum('0','1') YES MUL NULL
Relationships
References: → fup_policies.id (via fup_policy), services_internet.id (via service_id)
Sample Data
Loading sample data...

fup_counter

+
Table Structure (19 columns)
Column Type Null Key Default Extra
service_id int unsigned NO PRI NULL
day_up bigint unsigned NO NULL
day_down bigint unsigned NO NULL
day_time int unsigned NO NULL
week_up bigint unsigned NO NULL
week_down bigint unsigned NO NULL
week_time int unsigned NO NULL
month_up bigint unsigned NO NULL
month_down bigint unsigned NO NULL
month_time int unsigned NO NULL
over_usage bigint unsigned NO 0
day_bonus_up bigint unsigned NO 0
day_bonus_down bigint unsigned NO 0
week_bonus_up bigint unsigned NO 0
week_bonus_down bigint unsigned NO 0
month_bonus_up bigint unsigned NO 0
month_bonus_down bigint unsigned NO 0
parent_usage_amount bigint unsigned NO 0
parent_usage_time int unsigned NO 0
Relationships
References: → services_internet.id (via service_id)
Sample Data
Loading sample data...

fup_limits

+
Table Structure (27 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
cap_tariff_id int unsigned YES NULL
traffic_from varchar(5) NO 00:00
online_from varchar(5) NO 00:00
traffic_to varchar(5) NO 24:00
online_to varchar(5) NO 24:00
traffic_days varchar(64) NO 1,2,3,4,5,6,7
online_days varchar(64) NO 1,2,3,4,5,6,7
action enum('decrease','block','set_fixed') NO block
percent int NO 0
fixed_up int unsigned NO 0
fixed_down int unsigned NO 0
traffic_amount bigint NO NULL
traffic_direction enum('up','down','up_down') NO up_down
traffic_in enum('kb','mb','gb','tb') NO gb
bonus_traffic bigint unsigned NO 0
bonus_traffic_in enum('kb','mb','gb','tb') NO gb
bonus_is_unlimited enum('1','0') NO 1
use_bonus_when_normal_ended enum('1','0') NO 0
override_traffic enum('0','1') NO NULL
online_amount int unsigned NO NULL
online_in enum('minutes','hours') NO hours
override_online enum('0','1') NO NULL
rollover_data enum('0','1') NO 0
rollover_time enum('0','1') NO 0
top_up_over_usage enum('0','1') NO 0
top_up_trigger_percent tinyint unsigned NO 10
Sample Data
Loading sample data...

fup_notifications

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
rule_id int unsigned NO MUL NULL
template_id int unsigned YES NULL
type enum('mail_fup','sms_fup') NO mail_fup
send_once enum('0','1') NO 0
deleted enum('0','1') NO 0
Sample Data
Loading sample data...

fup_override

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int unsigned NO MUL NULL
speed_download int NO NULL
speed_upload int NO NULL
start_datetime datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
end_datetime datetime NO NULL
status enum('new','active','used') NO MUL new
Relationships
References: → services_internet.id (via service_id)
Sample Data
Loading sample data...

fup_policies

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariff_id int unsigned NO MUL NULL
sorting int unsigned NO MUL NULL
name varchar(64) NO NULL
accounting_traffic enum('0','1') NO NULL
accounting_online enum('0','1') NO NULL
action enum('increase','decrease','block','set_fixed') NO NULL
percent int NO 0
fixed_up int unsigned NO 0
fixed_down int unsigned NO 0
conditions text NO NULL
Relationships
References: → tariffs_internet.id (via tariff_id)
Referenced by: ← fup_compiled.fup_policy
Sample Data
Loading sample data...

google_account

+
Table Structure (5 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
oauth_id int unsigned YES NULL
email varchar(255) NO NULL
enabled enum('0','1') NO NULL
invalid enum('0','1') YES 0
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

holidays

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
uuid varchar(36) YES MUL NULL
name varchar(255) NO
date varchar(5) NO
date_changed enum('0','1') NO 0
deleted enum('0','1') NO 0
Sample Data
Loading sample data...

hook

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(256) NO NULL
enabled enum('0','1') NO MUL 1
type enum('cli','web','queue') NO cli
path varchar(256) NO NULL
url varchar(256) NO NULL
content_type enum('application/json','application/x-www-form-urlencoded') NO application/x-www-form-urlencoded
secret varchar(512) NO
queue varchar(256) NO NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← hook_events.id
Sample Data
Loading sample data...

hook_events

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
model varchar(128) NO PRI NULL
action varchar(32) NO PRI NULL
Relationships
References: → hook.id (via id)
Sample Data
Loading sample data...

import_data_source

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO UNI NULL
type enum('local','ftp','sftp','ftps') NO ftp
path varchar(500) NO NULL
host varchar(255) NO NULL
port smallint unsigned YES NULL
login varchar(255) YES NULL
password varchar(255) YES NULL
key text YES NULL
Relationships
Referenced by: ← cdr_import_entry_point.import_data_source_id
Sample Data
Loading sample data...

import_history

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
module varchar(64) NO NULL
datetime datetime NO NULL
status varchar(64) NO new
handler varchar(64) YES NULL
file_id int unsigned YES NULL
delimiter varchar(64) NO NULL
names_in_first_row enum('0','1') NO 1
selected_columns text NO NULL
additional_info text NO NULL
Sample Data
Loading sample data...

incoming_customer

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
email varchar(255) NO UNI NULL
name varchar(255) NO NULL
customer_id int unsigned YES MUL NULL
banned enum('1','0') NO 0
is_shared_email enum('0','1') NO 0
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

incoming_email_blackbox

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
location enum('email','subject','message') NO email
type enum('exact','contain','start','end','preg') NO exact
filter varchar(255) NO NULL
filtered_today int unsigned YES NULL
filtered_total int unsigned YES NULL
deleted enum('0','1') YES 0
Sample Data
Loading sample data...

incoming_email_processing

+
Table Structure (6 columns)
Column Type Null Key Default Extra
signature varchar(255) NO PRI NULL
body blob YES NULL
created_date datetime YES MUL NULL
ticket_id int unsigned YES NULL
message_id int unsigned YES NULL
mailbox_id int unsigned YES NULL
Sample Data
Loading sample data...

instant_message

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type varchar(32) NO NULL
status enum('new','processing','sent','cancelled','removed','sent_with_error') NO new
subject varchar(256) NO NULL
message text NO NULL
search_params text NO NULL
customers_ids text NO NULL
created_at datetime NO MUL NULL
deleted enum('1','0') NO MUL 0
Relationships
Referenced by: ← instant_message_values.id
Sample Data
Loading sample data...

instant_message_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← instant_message_values.name
Sample Data
Loading sample data...

instant_message_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → instant_message.id (via id), instant_message_fields.name (via name)
Sample Data
Loading sample data...

inter_partner_invoices

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO NULL
invoice_id int unsigned NO NULL
history_id int unsigned NO NULL
Relationships
Referenced by: ← inter_partner_invoices_items.inter_partner_invoices_id
Sample Data
Loading sample data...

inter_partner_invoices_items

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
inter_partner_invoices_id int unsigned NO MUL NULL
transaction_id int unsigned NO NULL
is_original enum('0','1') NO 0
Relationships
References: → inter_partner_invoices.id (via inter_partner_invoices_id)
Sample Data
Loading sample data...

inventory_activity_log

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
stock_id int unsigned YES NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Sample Data
Loading sample data...

inventory_items

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
supplier_invoices_item_id int unsigned YES MUL NULL
barcode varchar(255) YES MUL NULL
serial_number varchar(255) YES MUL NULL
status varchar(255) YES NULL
mark varchar(255) YES NULL
customer_id int unsigned YES MUL NULL
admin_id int unsigned YES NULL
service_id int unsigned YES NULL
invoice_id int unsigned YES NULL
transaction_id int unsigned YES NULL
product_id int unsigned YES MUL NULL
stock_id int unsigned YES MUL NULL
task_id int unsigned YES NULL
notes varchar(255) YES NULL
filename_original varchar(255) YES NULL
filename varchar(255) YES NULL
cost_price decimal(19,4) NO NULL
deleted enum('0','1') YES MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → customers.id (via customer_id), inventory_products.id (via product_id), inventory_stocks.id (via stock_id), inventory_supplier_invoices_items.id (via supplier_invoices_item_id)
Referenced by: ← inventory_items_flow.item_id, inventory_items_values.id
Sample Data
Loading sample data...

inventory_items_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← inventory_items_values.name
Sample Data
Loading sample data...

inventory_items_flow

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
item_id int unsigned NO MUL NULL
status varchar(255) NO NULL
customer_id int unsigned YES MUL NULL
admin_id int unsigned YES NULL
service_id int unsigned YES NULL
invoice_id int unsigned YES NULL
transaction_id int unsigned YES NULL
stock_id int unsigned YES NULL
task_id int unsigned YES NULL
notes varchar(255) YES NULL
datetime datetime NO NULL
current enum('0','1') YES 1
deleted enum('0','1') YES 0
edited_by int unsigned YES NULL
Relationships
References: → customers.id (via customer_id), inventory_items.id (via item_id)
Sample Data
Loading sample data...

inventory_items_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_items.id (via id), inventory_items_fields.name (via name)
Sample Data
Loading sample data...

inventory_products

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(255) YES NULL
vendor_id int unsigned YES MUL NULL
category_id int unsigned YES NULL
sold_price decimal(19,4) NO 0.0000
rent_price decimal(19,4) NO 0.0000
filename_original varchar(255) YES NULL
filename varchar(255) YES NULL
deleted enum('0','1') YES MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → inventory_vendors.id (via vendor_id)
Referenced by: ← inventory_items.product_id, inventory_products_values.id, inventory_supplier_invoices_items.product_id
Sample Data
Loading sample data...

inventory_products_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
Sample Data
Loading sample data...

inventory_products_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← inventory_products_values.name
Sample Data
Loading sample data...

inventory_products_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_products.id (via id), inventory_products_fields.name (via name)
Sample Data
Loading sample data...

inventory_stocks

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(255) NO NULL
is_base enum('0','1') NO 0
deleted enum('0','1') NO 0
type int unsigned NO 0
admin_ids text NO NULL
Relationships
Referenced by: ← inventory_items.stock_id, inventory_stocks_values.id
Sample Data
Loading sample data...

inventory_stocks_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
disabled enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← inventory_stocks_values.name
Sample Data
Loading sample data...

inventory_stocks_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_stocks.id (via id), inventory_stocks_fields.name (via name)
Sample Data
Loading sample data...

inventory_supplier_invoices

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
supplier_id int unsigned NO NULL
original_invoice_number varchar(255) YES NULL
date date NO NULL
filename_original varchar(255) YES NULL
filename varchar(255) YES NULL
deleted enum('0','1') YES MUL 0
Relationships
Referenced by: ← inventory_supplier_invoices_items.supplier_invoice_id, inventory_supplier_invoices_values.id
Sample Data
Loading sample data...

inventory_supplier_invoices_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← inventory_supplier_invoices_values.name
Sample Data
Loading sample data...

inventory_supplier_invoices_items

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
supplier_invoice_id int unsigned NO MUL NULL
product_id int unsigned NO MUL NULL
quantity int NO NULL
price decimal(19,4) NO NULL
tax decimal(6,4) NO NULL
tax_id int unsigned NO NULL
deleted enum('0','1') YES 0
Relationships
References: → inventory_products.id (via product_id), inventory_supplier_invoices.id (via supplier_invoice_id)
Referenced by: ← inventory_items.supplier_invoices_item_id
Sample Data
Loading sample data...

inventory_supplier_invoices_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_supplier_invoices.id (via id), inventory_supplier_invoices_fields.name (via name)
Sample Data
Loading sample data...

inventory_suppliers

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(255) YES NULL
address varchar(255) YES NULL
contact_name varchar(255) YES NULL
email varchar(255) YES NULL
phone varchar(255) YES NULL
tax_included enum('1','0') NO 0
deleted enum('0','1') YES MUL 0
Relationships
Referenced by: ← inventory_suppliers_values.id
Sample Data
Loading sample data...

inventory_suppliers_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← inventory_suppliers_values.name
Sample Data
Loading sample data...

inventory_suppliers_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_suppliers.id (via id), inventory_suppliers_fields.name (via name)
Sample Data
Loading sample data...

inventory_vendors

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(255) YES NULL
deleted enum('0','1') YES 0
Relationships
Referenced by: ← inventory_products.vendor_id, inventory_vendors_values.id
Sample Data
Loading sample data...

inventory_vendors_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← inventory_vendors_values.name
Sample Data
Loading sample data...

inventory_vendors_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → inventory_vendors.id (via id), inventory_vendors_fields.name (via name)
Sample Data
Loading sample data...

invoice_payers

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
payer_id int NO MUL NULL
type enum('payment','credit_note','transaction') NO NULL
invoice_id int unsigned YES MUL NULL
transaction_id int unsigned YES MUL NULL
amount decimal(19,4) NO NULL
link enum('hard','soft') NO soft
Sample Data
Loading sample data...

invoices

+
Table Structure (21 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
number varchar(64) NO MUL NULL
date_created date NO NULL
real_create_datetime datetime NO NULL
date_updated date NO NULL
date_payment date NO NULL
date_till date NO NULL
total decimal(19,4) NO NULL
due decimal(19,4) NO NULL
status enum('not_paid','paid','deleted','pending') NO not_paid
payment_id int unsigned NO NULL
is_sent enum('0','1') NO 0
payd_from_deposit enum('0','1') NO 0
use_transactions enum('0','1') NO 1
note text NO NULL
memo text NO NULL
added_by enum('system','api','admin') YES NULL
added_by_id int YES NULL
deleted enum('0','1') NO MUL 0
type enum('one_time','recurring') NO MUL one_time
Relationships
References: → customers.id (via customer_id)
Referenced by: ← accounting_invoices.invoice_id, credit_notes_to_invoices.invoice_id, einvoicing_invoices.invoice_id, invoices_cache.invoice_id, invoices_items.invoice_id, invoices_values.id
Sample Data
id0customer_id1number2date_created3real_create_datetime4date_updated5date_payment6date_till7total8due9status10payment_id11is_sent12payd_from_deposit13use_transactions14note15memo16added_by17added_by_id18deleted19type20
89868986332020010000012020010000012020-12-212020-12-212020-12-21 09:03:142020-12-21 09:03:142020-12-212020-12-210000-00-000000-00-002021-01-052021-01-055.75005.75000.00000.0000not_paidnot_paid00110011adminadmin5511recurringrecurring
89878987262026202020010000012020010000012020-12-212020-12-212020-12-21 14:46:442020-12-21 14:46:442020-12-212020-12-210000-00-000000-00-002020-12-262020-12-2660.000060.00000.00000.0000not_paidnot_paid00110011adminadmin5511one_timeone_time
89888988332021030000012021030000012021-01-012021-01-012020-12-21 22:58:202020-12-21 22:58:202020-12-222020-12-220000-00-000000-00-002021-01-162021-01-161757.50001757.50000.00000.0000not_paidnot_paid00110011adminadmin5511one_timeone_time

invoices_cache

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
invoice_id int unsigned NO MUL NULL
date_created datetime NO NULL
version int unsigned NO NULL
html longtext NO NULL
Relationships
References: → invoices.id (via invoice_id)
Sample Data
Loading sample data...

invoices_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← invoices_values.name
Sample Data
Loading sample data...

invoices_items

+
Table Structure (14 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
invoice_id int unsigned NO MUL NULL
sub_account_id int unsigned YES NULL
pos smallint unsigned NO MUL NULL
description varchar(256) NO NULL
quantity int NO NULL
unit varchar(16) NO NULL
price decimal(19,4) NO NULL
tax decimal(6,4) NO NULL
tax_id int unsigned NO NULL
period_from date NO NULL
period_to date NO NULL
transaction_id int unsigned NO MUL NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → invoices.id (via invoice_id)
Sample Data
Loading sample data...

invoices_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → invoices.id (via id), invoices_fields.name (via name)
Sample Data
Loading sample data...

ip_host_categories

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO NULL
icon varchar(32) NO NULL
color varchar(7) NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

ip_network_categories

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

ipv4_networks

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
network varchar(15) NO MUL NULL
mask tinyint unsigned NO NULL
parent int unsigned NO NULL
title varchar(64) NO NULL
comment varchar(256) NO NULL
location_id int unsigned NO MUL NULL
network_category int unsigned NO NULL
network_type enum('rootnet','endnet') NO MUL endnet
type_of_usage enum('pool','static','management') NO MUL static
allow_use_network_and_broadcast enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← ipv4_networks_ip.ipv4_networks_id, ipv4_networks_values.id, routers_to_ipv4_networks.ipv4_network_id
Sample Data
Loading sample data...

ipv4_networks_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← ipv4_networks_values.name
Sample Data
Loading sample data...

ipv4_networks_ip

+
Table Structure (17 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ipv4_networks_id int unsigned NO MUL NULL
ip varbinary(4) NO UNI NULL
hostname varchar(255) NO NULL
location_id int unsigned NO MUL NULL
title varchar(64) NO NULL
comment varchar(255) NO NULL
host_category int unsigned NO NULL
is_used enum('0','1') NO MUL 0
status enum('0','1','2','9') NO 9
last_check int unsigned NO NULL
customer_id int unsigned NO NULL
card_id int unsigned NO NULL
module varchar(64) NO NULL
module_item_id int unsigned NO NULL
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → ipv4_networks.id (via ipv4_networks_id)
Referenced by: ← ipv4_networks_ip_values.id
Sample Data
Loading sample data...

ipv4_networks_ip_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← ipv4_networks_ip_values.name
Sample Data
Loading sample data...

ipv4_networks_ip_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → ipv4_networks_ip.id (via id), ipv4_networks_ip_fields.name (via name)
Sample Data
Loading sample data...

ipv4_networks_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → ipv4_networks.id (via id), ipv4_networks_fields.name (via name)
Sample Data
Loading sample data...

ipv6_networks

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
network varchar(39) NO MUL NULL
prefix tinyint unsigned NO NULL
parent int unsigned NO NULL
title varchar(64) NO NULL
comment varchar(256) NO NULL
location_id int unsigned NO MUL NULL
network_category int unsigned NO NULL
network_type enum('rootnet','endnet') NO MUL endnet
type_of_usage enum('static','management') NO MUL static
range_from binary(16) NO MUL NULL
range_to binary(16) NO NULL
Relationships
Referenced by: ← ipv6_networks_values.id
Sample Data
Loading sample data...

ipv6_networks_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← ipv6_networks_values.name
Sample Data
Loading sample data...

ipv6_networks_ip

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ipv6_networks_id int unsigned NO MUL NULL
ip binary(16) NO UNI NULL
ip_end binary(16) NO NULL
prefix tinyint(1) NO NULL
location_id int unsigned NO MUL NULL
title varchar(64) NO NULL
comment varchar(255) NO NULL
host_category int unsigned NO NULL
customer_id int unsigned NO MUL NULL
service_id int unsigned NO NULL
card_id int unsigned NO NULL
module varchar(64) NO NULL
module_item_id int unsigned NO NULL
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Sample Data
Loading sample data...

ipv6_networks_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → ipv6_networks.id (via id), ipv6_networks_fields.name (via name)
Sample Data
Loading sample data...

keys_values

+
Table Structure (2 columns)
Column Type Null Key Default Extra
key varchar(32) NO PRI NULL
value varchar(256) NO NULL
Sample Data
Loading sample data...

labels

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
module varchar(32) NO MUL NULL
label varchar(64) NO NULL
color varchar(64) NO NULL
Relationships
Referenced by: ← bundle_module_labels.label_id, customers_labels.label_id, scheduling_task_labels.label_id, tariffs_custom_module_labels.label_id, tariffs_internet_module_labels.label_id, tariffs_one_time_module_labels.label_id, tariffs_voice_module_labels.label_id, ticket_labels.label_id
Sample Data
Loading sample data...

lba_main_config

+
Table Structure (2 columns)
Column Type Null Key Default Extra
customer_id int unsigned NO PRI NULL
enable_sub_account_management tinyint(1) NO 0
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

leads_info

+
Table Structure (11 columns)
Column Type Null Key Default Extra
customer_id int unsigned NO PRI NULL
deal_value decimal(19,4) NO NULL
deal_comment text NO NULL
score int NO 1
last_contacted datetime NO NULL
crm_status varchar(255) NO NULL
owner varchar(255) NO 0
source varchar(255) NO NULL
deleted enum('0','1') NO MUL 0
last_status_changed datetime YES NULL
status_due_notification_sent enum('0','1') NO 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← crm_lead_status_logs_changes.lead_id
Sample Data
Loading sample data...

locations

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(128) NO NULL
deleted enum('0','1') NO MUL 0
tax_for_tariff_bundle int NO 0
tax_for_tariff_internet int NO 0
tax_for_tariff_voice int NO 0
tax_for_tariff_recurring int NO 0
tax_for_tariff_onetime int NO 0
tax_for_inventory_items int NO 0
Relationships
Referenced by: ← bundle_to_locations.location_id, locations_values.id, multiple_psk_automation.location_id, tariffs_custom_to_locations.location_id, tariffs_internet_to_locations.location_id, tariffs_one_time_to_locations.location_id, tariffs_voice_to_locations.location_id
Sample Data
id0name1deleted2tax_for_tariff_bundle3tax_for_tariff_internet4tax_for_tariff_voice5tax_for_tariff_recurring6tax_for_tariff_onetime7tax_for_inventory_items8
11MainMain00000000000000
22Diazville 1Diazville 100000000000000
33Diazville 2Diazville 200000000000000

locations_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← locations_values.name
Sample Data
Loading sample data...

locations_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → locations.id (via id), locations_fields.name (via name)
Sample Data
Loading sample data...

log_planned_change_tariff

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO NULL
type enum('internet','voice','custom') NO internet
old_service_id int unsigned NO NULL
new_service_id int unsigned NO NULL
old_tariff_id int unsigned NO NULL
new_tariff_id int unsigned NO NULL
Sample Data
Loading sample data...

logs_admins

+
Table Structure (16 columns)
Column Type Null Key Default Extra
entry_id bigint unsigned NO PRI NULL auto_increment
date date NO PRI NULL
time time NO PRI NULL
administrator_id int unsigned NO MUL NULL
customer_id int unsigned NO MUL NULL
action varchar(64) NO MUL NULL
model varchar(128) NO NULL
result enum('success','failed') NO success
attributes text NO NULL
attributes_additional text NO NULL
changed_attributes text NO NULL
labels text NO NULL
extra text NO NULL
ip varchar(128) NO NULL
errors text YES NULL
attributes_large mediumtext NO NULL
Sample Data
Loading sample data...

logs_api

+
Table Structure (16 columns)
Column Type Null Key Default Extra
entry_id bigint unsigned NO PRI NULL auto_increment
date date NO PRI NULL
time time NO PRI NULL
api_key_id int unsigned NO MUL NULL
customer_id int unsigned NO MUL NULL
action varchar(64) NO MUL NULL
model varchar(128) NO NULL
result enum('success','failed') NO success
attributes text NO NULL
attributes_additional text NO NULL
changed_attributes text NO NULL
labels text NO NULL
extra text NO NULL
ip varchar(128) NO NULL
errors text YES NULL
attributes_large mediumtext NO NULL
Sample Data
Loading sample data...

logs_bonus

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int NO NULL
date_time datetime NO NULL
action varchar(64) NO
status enum('success','failed') NO success
amount bigint unsigned NO NULL
total_amount bigint unsigned NO NULL
extra text NO NULL
Sample Data
Loading sample data...

logs_cap

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int NO NULL
date_time datetime NO NULL
action varchar(64) NO
status enum('success','failed') NO success
amount bigint unsigned NO NULL
total_amount bigint unsigned NO NULL
extra text NO NULL
Sample Data
Loading sample data...

logs_changes

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned YES NULL
old_status varchar(32) YES NULL
new_status varchar(32) YES NULL
date date NO NULL
time time NO NULL
tariff_type varchar(32) YES NULL
old_tariff int unsigned YES NULL
new_tariff int unsigned YES NULL
administrator_id int unsigned YES NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

logs_gps_customer

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
customer_id int NO NULL
address varchar(64) NO NULL
created_at datetime NO NULL
status tinyint NO NULL
Sample Data
Loading sample data...

logs_internal

+
Table Structure (14 columns)
Column Type Null Key Default Extra
entry_id bigint unsigned NO PRI NULL auto_increment
date date NO PRI NULL
time time NO PRI NULL
customer_id int unsigned NO MUL NULL
action varchar(64) NO MUL NULL
model varchar(128) NO NULL
result enum('success','failed') NO success
attributes text NO NULL
attributes_additional text NO NULL
changed_attributes text NO NULL
labels text NO NULL
extra text NO NULL
errors text YES NULL
attributes_large mediumtext NO NULL
Sample Data
Loading sample data...

logs_portal

+
Table Structure (16 columns)
Column Type Null Key Default Extra
entry_id bigint unsigned NO PRI NULL auto_increment
date date NO PRI NULL
time time NO PRI NULL
customer_id int unsigned NO MUL NULL
action varchar(64) NO MUL NULL
model varchar(128) NO NULL
result enum('success','failed') NO success
attributes text NO NULL
attributes_additional text NO NULL
changed_attributes text NO NULL
labels text NO NULL
extra text NO NULL
ip varchar(128) NO NULL
errors text YES NULL
source enum('portal','api') NO portal
attributes_large mediumtext NO NULL
Sample Data
Loading sample data...

logs_services

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO NULL
old_status varchar(32) YES NULL
new_status varchar(32) YES NULL
date date NO NULL
time time NO NULL
tariff_type varchar(32) YES NULL
old_tariff int unsigned YES NULL
new_tariff int unsigned YES NULL
administrator_id int unsigned YES NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

mail_attachments

+
Table Structure (3 columns)
Column Type Null Key Default Extra
mail_id int unsigned NO PRI NULL
type varchar(64) NO PRI NULL
file_id int unsigned NO PRI NULL
Sample Data
Loading sample data...

mail_messages

+
Table Structure (18 columns)
Column Type Null Key Default Extra
signature varchar(255) NO PRI NULL
delivered_to varchar(255) NO
author_type enum('lead','customer','admin','unknown') NO lead
author_id int unsigned YES NULL
author_email varchar(255) NO
original_author_name varchar(255) NO
receiver_type enum('lead','customer','admin','unknown') NO MUL unknown
receiver_id int unsigned YES NULL
receiver_email text NO NULL
cc text NO NULL
bcc text NO NULL
resent_from varchar(255) NO
related_client_type enum('lead','customer','unknown') NO lead
related_client_id int unsigned YES MUL NULL
datetime datetime NO NULL
title varchar(255) NO MUL
unread enum('0','1') NO 1
deleted enum('0','1') NO 0
Relationships
Referenced by: ← mail_messages_clicks.message_signature, mail_messages_content.signature, mail_messages_opens.message_signature, mail_messages_to_files_upload.message_id
Sample Data
Loading sample data...

mail_messages_clicks

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
message_signature varchar(255) NO MUL NULL
email varchar(255) NO NULL
link text NO NULL
datetime datetime NO NULL
Relationships
References: → mail_messages.signature (via message_signature)
Sample Data
Loading sample data...

mail_messages_content

+
Table Structure (2 columns)
Column Type Null Key Default Extra
signature varchar(255) NO PRI
content longblob YES NULL
Relationships
References: → mail_messages.signature (via signature)
Sample Data
Loading sample data...

mail_messages_opens

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
message_signature varchar(255) NO MUL NULL
email varchar(255) NO NULL
datetime datetime NO NULL
Relationships
References: → mail_messages.signature (via message_signature)
Sample Data
Loading sample data...

mail_messages_to_files_upload

+
Table Structure (2 columns)
Column Type Null Key Default Extra
file_id int unsigned NO PRI NULL auto_increment
message_id varchar(255) NO PRI NULL
Relationships
References: → files_upload.id (via file_id), mail_messages.signature (via message_id)
Sample Data
Loading sample data...

mail_pool

+
Table Structure (16 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type varchar(32) NO MUL NULL
message_id int unsigned NO NULL
status enum('new','sending','sent','error','expired','attachment_error') NO MUL new
datetime_added datetime NO PRI NULL
datetime_start_sending datetime NO NULL
datetime_sent datetime NO NULL
recipient varchar(5100) YES NULL
bcc varchar(5100) NO NULL
cc varchar(5100) NO NULL
subject varchar(256) NO NULL
message longtext NO NULL
customer_id int NO MUL NULL
admin_id int YES 0
from varchar(256) YES NULL
priority tinyint unsigned NO 2
Sample Data
Loading sample data...

mailbox

+
Table Structure (22 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
email varchar(255) NO MUL NULL
auth_type varchar(64) NO basic
oauth_id int unsigned YES NULL
username varchar(255) NO NULL
password varchar(255) NO NULL
imap_host varchar(255) YES NULL
imap_port int YES NULL
imap_last_processing_date datetime YES NULL
imap_what_find enum('all','unseen') YES all
imap_chunk_size int NO 1000
imap_mark_as_read enum('0','1') YES 0
imap_receive_unregistered_email enum('1','0') YES 0
imap_address_from enum('from','reply-to','sender') YES from
imap_no_validate_cert enum('0','1') YES 0
encryption enum('none','ssl','tls') YES tls
imap_enabled enum('0','1') YES MUL 0
ticket_group_id int unsigned YES NULL
ticket_type_id int unsigned YES NULL
ticket_priority varchar(255) YES NULL
deleted enum('0','1') YES MUL 0
custom_server_settings tinyint(1) NO 0
Sample Data
Loading sample data...

messages_default

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
category varchar(32) NO MUL NULL
message varchar(512) NO NULL
Relationships
Referenced by: ← messages_translation.id
Sample Data
Loading sample data...

messages_translation

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
language varchar(5) NO PRI NULL
translation text NO NULL
Relationships
References: → messages_default.id (via id)
Sample Data
Loading sample data...

messengers_whatsapp_chats

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
assign_id int unsigned YES NULL
phone varchar(16) NO NULL
profile_name varchar(128) YES NULL
active tinyint(1) NO 1
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← messengers_whatsapp_chats_activity_log.chat_id
Sample Data
Loading sample data...

messengers_whatsapp_chats_activity_log

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
chat_id int unsigned NO MUL NULL
model_class varchar(255) NO NULL
log_datetime datetime NO NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Relationships
References: → messengers_whatsapp_chats.id (via chat_id)
Sample Data
Loading sample data...

messengers_whatsapp_conversations

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
chat_id int unsigned NO MUL NULL
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
closed_at datetime YES NULL
init_customer tinyint(1) NO 0
Sample Data
Loading sample data...

messengers_whatsapp_messages

+
Table Structure (16 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
chat_id int unsigned NO MUL NULL
conversation_id int unsigned NO MUL NULL
external_id varchar(64) YES MUL NULL
customer_id int unsigned YES NULL
admin_id int unsigned YES NULL
ticket_id int unsigned YES NULL
body text YES NULL
status_id enum('queue','sent','delivered','read','failed') NO queue
inbound tinyint(1) NO 1
created_at datetime NO MUL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
error text YES NULL
latitude varchar(50) YES NULL
longitude varchar(50) YES NULL
address varchar(512) YES NULL
Sample Data
Loading sample data...

messengers_whatsapp_messages_attachments

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
message_id int unsigned NO MUL NULL
file_id int unsigned NO NULL
Sample Data
Loading sample data...

messengers_whatsapp_templates

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
provider varchar(36) NO NULL
external_id varchar(64) YES NULL
status varchar(15) NO NULL
title varchar(255) NO NULL
body text NO NULL
error text YES NULL
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
Sample Data
Loading sample data...

migrations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
version varchar(180) NO PRI NULL
apply_time int YES MUL NULL
Sample Data
Loading sample data...

mobile_notification_token

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
user_id int unsigned NO MUL NULL
token varchar(255) NO
device_id varchar(256) NO NULL
application varchar(256) NO MUL NULL
created_at datetime NO NULL
Sample Data
Loading sample data...

mobile_push_tickets

+
Table Structure (3 columns)
Column Type Null Key Default Extra
ticket varchar(255) NO PRI NULL
token varchar(255) NO MUL NULL
created_at datetime NO MUL CURRENT_TIMESTAMP DEFAULT_GENERATED
Sample Data
Loading sample data...

mobile_settings

+
Table Structure (6 columns)
Column Type Null Key Default Extra
application varchar(64) NO PRI NULL
user_id int unsigned NO PRI NULL
path varchar(64) NO PRI NULL
key varchar(64) NO PRI NULL
type varchar(64) NO NULL
value text NO NULL
Sample Data
Loading sample data...

module

+
Table Structure (3 columns)
Column Type Null Key Default Extra
module varchar(32) NO PRI NULL
id int unsigned NO PRI NULL
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → module_config.module (via module)
Referenced by: ← module_values.id, module_values.module
Sample Data
Loading sample data...

module_config

+
Table Structure (9 columns)
Column Type Null Key Default Extra
module varchar(32) NO PRI NULL
title varchar(64) NO NULL
root varchar(128) NO NULL
type varchar(128) NO MUL NULL
icon varchar(64) NO icon-ic_fluent_settings_cog_multiple_24_regular
title_attribute_prefix varchar(32) NO NULL
title_attribute_suffix varchar(32) NO NULL
path varchar(256) NO NULL
status enum('1','0') NO 0
Relationships
Referenced by: ← module.module, module_entry_point.module
Sample Data
Loading sample data...

module_entry_point

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
module varchar(32) NO MUL NULL
place enum('admin','portal','mobile') NO MUL admin
size enum('extra_small','small','medium','large','extra_large') NO large
type enum('menu_link','code','action_link','tab') NO menu_link
title varchar(64) NO NULL
root varchar(128) NO NULL
model varchar(128) NO NULL
payment_account_id varchar(512) YES
icon varchar(64) YES NULL
background varchar(32) NO NULL
url varchar(128) NO NULL
location enum('after_content','before_content') NO after_content
code text NO NULL
partners text NO NULL
location_geo text NO NULL
payment_type varchar(512) YES
name varchar(64) NO NULL
enabled enum('1','0') NO 1
Relationships
References: → module_config.module (via module)
Sample Data
Loading sample data...

module_fields

+
Table Structure (22 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO PRI NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 1
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← module_values.module, module_values.name
Sample Data
Loading sample data...

module_values

+
Table Structure (4 columns)
Column Type Null Key Default Extra
module varchar(32) NO PRI NULL
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → module.id (via id), module.module (via module), module_fields.module (via module), module_fields.name (via name)
Sample Data
Loading sample data...

modules_relations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
from varchar(64) NO PRI NULL
to varchar(64) NO PRI NULL
Sample Data
Loading sample data...

monitoring

+
Table Structure (40 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
parent_id int unsigned NO MUL 0
title varchar(64) NO MUL NULL
network_site_id int YES 0
producer int unsigned NO NULL
model varchar(64) NO NULL
ip varchar(64) NO MUL NULL
snmp_port int NO 161
snmp_community varchar(64) NO public
snmp_version enum('1','2') NO 2
snmp_time int unsigned NO NULL
snmp_uptime int unsigned NO NULL
snmp_status tinyint unsigned NO MUL 9
snmp_status_1 tinyint unsigned NO 9
snmp_status_2 tinyint unsigned NO 9
snmp_status_3 tinyint unsigned NO 9
snmp_status_4 tinyint unsigned NO 9
snmp_status_5 tinyint unsigned NO 9
snmp_state enum('up','down') NO NULL
type int unsigned NO MUL NULL
monitoring_group int unsigned NO NULL
location_id int unsigned NO MUL NULL
address varchar(256) NO NULL
gps varchar(256) YES NULL
gps_area text YES NULL
deleted enum('1','0') NO MUL 0
active enum('1','0') NO 1
send_notifications enum('1','0') NO 0
delay_timer int YES NULL
is_ping enum('0','1') NO 1
ping_0 tinyint unsigned NO MUL 9
ping_1 tinyint unsigned NO 9
ping_2 tinyint unsigned NO 9
ping_3 tinyint unsigned NO 9
ping_4 tinyint unsigned NO 9
ping_5 tinyint unsigned NO 9
ping_time int unsigned NO NULL
ping_state enum('up','down') NO NULL
access_device tinyint(1) NO 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← monitoring_nas_identifier_call_to.monitoring, monitoring_oid.monitoring_id, monitoring_to_partners.monitoring_id, monitoring_values.id
Sample Data
Loading sample data...

monitoring_backup

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
login varchar(64) NO NULL
password varchar(512) NO NULL
port int unsigned NO 22
enabled enum('0','1') NO 0
commands text YES NULL
externalHandler varchar(128) NO NULL
type enum('commands','external_handler') NO commands
hoursForBackup text NO NULL
Sample Data
Loading sample data...

monitoring_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← monitoring_values.name
Sample Data
Loading sample data...

monitoring_graphs

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
monitoring_id int unsigned NO MUL NULL
title varchar(128) NO NULL
vertical_title varchar(32) NO NULL
height int unsigned NO 150
public enum('0','1') NO 1
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

monitoring_graphs_items

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
position tinyint unsigned NO NULL
monitoring_graphs_id int unsigned NO MUL NULL
monitoring_oid_id int unsigned NO NULL
title varchar(64) NO NULL
factor double(8,2) NO 1.00
color varchar(7) NO #00FF00
draw enum('AREA','LINE1','LINE2') NO LINE1
def enum('MIN','MAX','AVERAGE') NO AVERAGE
stack enum('0','1') NO 0
value_in varchar(3) NO Bps
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

monitoring_groups

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
deleted enum('0','1') NO MUL 0
delay_timer int NO 5
panel_notifications enum('0','1') NO 1
email_notifications enum('0','1') NO 0
email_notification_subject varchar(256) NO NULL
email_notifications_template_id int NO 0
notifications_admins text NO NULL
sms_notifications enum('0','1') NO 0
sms_notifications_template_id int NO 0
Sample Data
Loading sample data...

monitoring_log

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
monitoring_id int unsigned NO MUL NULL
type enum('ping','snmp') NO NULL
date datetime NO NULL
status enum('ok','error') NO NULL
is_send enum('1','0') NO 0
Sample Data
Loading sample data...

monitoring_nas_identifier_call_to

+
Table Structure (3 columns)
Column Type Null Key Default Extra
nas_identifier varchar(64) NO PRI NULL
call_to varchar(32) NO PRI NULL
monitoring int unsigned NO MUL NULL
Relationships
References: → monitoring.id (via monitoring)
Sample Data
Loading sample data...

monitoring_oid

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
monitoring_id int unsigned NO MUL NULL
title varchar(64) NO NULL
oid varchar(64) NO MUL NULL
active enum('0','1') NO 1
check_every enum('1','5','10','15','30','60') NO 1
result_0 varchar(256) NO NULL
result_1 varchar(256) NO NULL
result_2 varchar(256) NO NULL
result_3 varchar(256) NO NULL
result_4 varchar(256) NO NULL
result_5 varchar(256) NO NULL
last_check int unsigned NO NULL
rrd_dst enum('NONE','COUNTER','DERIVE','ABSOLUTE','GAUGE') NO NONE
deleted enum('0','1') NO MUL 0
Relationships
References: → monitoring.id (via monitoring_id)
Referenced by: ← monitoring_oid_values.id
Sample Data
Loading sample data...

monitoring_oid_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← monitoring_oid_values.name
Sample Data
Loading sample data...

monitoring_oid_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → monitoring_oid.id (via id), monitoring_oid_fields.name (via name)
Sample Data
Loading sample data...

monitoring_producers

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

monitoring_snmpwalk

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
monitoring_id int unsigned NO MUL NULL
oid varchar(64) NO NULL
oid_type tinyint unsigned NO NULL
oid_value varchar(255) NO NULL
Sample Data
Loading sample data...

monitoring_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
monitoring_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → monitoring.id (via monitoring_id), partners.id (via partner_id)
Sample Data
Loading sample data...

monitoring_types

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

monitoring_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → monitoring.id (via id), monitoring_fields.name (via name)
Sample Data
Loading sample data...

mrr_statistics

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
date date NO PRI 0000-00-00
customer_id int unsigned NO MUL NULL
total decimal(19,4) unsigned NO 0.0000
partner_id int unsigned YES NULL
location_id int unsigned YES NULL
billing_type enum('recurring','prepaid','prepaid_monthly') NO recurring
payment_method int unsigned YES NULL
Sample Data
Loading sample data...

multiple_psk_automation

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ssid varchar(255) NO NULL
full_name_format varchar(255) NO NULL
partner_id int unsigned NO MUL NULL
location_id int unsigned NO MUL NULL
tariff_id int unsigned NO MUL NULL
customers int NO NULL
status enum('creating','partially_done','done','error') NO creating
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → locations.id (via location_id), partners.id (via partner_id), tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

multiple_psk_automation_to_internet_services

+
Table Structure (2 columns)
Column Type Null Key Default Extra
multiple_psk_automation_id int unsigned NO NULL
internet_service_id int unsigned NO NULL
Sample Data
Loading sample data...

multiple_psk_pmks

+
Table Structure (2 columns)
Column Type Null Key Default Extra
service_internet_id int unsigned NO MUL NULL
pmk char(64) NO NULL
Sample Data
Loading sample data...

multiple_psk_ssids

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ssid varchar(128) NO NULL
enabled enum('0','1') NO 1
partner_id int NO 0
location_id int NO 0
Sample Data
Loading sample data...

nas_types

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
mikrotik_api enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

network_site_contacts

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
network_site_id int unsigned NO MUL NULL
contact_name varchar(255) NO NULL
phone varchar(48) YES NULL
email varchar(255) YES NULL
comment text YES NULL
is_default tinyint(1) NO 0
Relationships
References: → network_sites.id (via network_site_id)
Sample Data
Loading sample data...

network_sites

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
location_id int NO 0
title varchar(256) NO NULL
description text YES NULL
address varchar(256) NO NULL
gps text NO NULL
updated_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
deleted enum('1','0') NO 0
Relationships
Referenced by: ← network_site_contacts.network_site_id, network_sites_documents.network_site_id, network_sites_photos.network_site_id, network_sites_to_partners.network_site_id, network_sites_values.id
Sample Data
Loading sample data...

network_sites_documents

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
network_site_id int unsigned NO MUL NULL
hash_id varchar(32) NO NULL
title varchar(256) NO NULL
description varchar(512) NO NULL
filename_original varchar(256) NO NULL
filename_uploaded varchar(256) NO NULL
thumbnail varchar(256) NO
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → network_sites.id (via network_site_id)
Sample Data
Loading sample data...

network_sites_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
disabled enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← network_sites_values.name
Sample Data
Loading sample data...

network_sites_photos

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
network_site_id int unsigned NO MUL NULL
hash_id varchar(32) NO NULL
created_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED
filename_original varchar(256) NO NULL
filename_uploaded varchar(256) NO NULL
thumbnail varchar(256) NO
Relationships
References: → network_sites.id (via network_site_id)
Sample Data
Loading sample data...

network_sites_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
network_site_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → network_sites.id (via network_site_id), partners.id (via partner_id)
Sample Data
Loading sample data...

network_sites_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → network_sites.id (via id), network_sites_fields.name (via name)
Sample Data
Loading sample data...

oauth_accounts

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
server_name varchar(32) NO
app_name varchar(64) NO
status varchar(32) NO new
access_token varchar(4096) NO NULL
refresh_token varchar(4096) NO NULL
date_added datetime NO NULL
scopes text NO NULL
expiration_time int unsigned NO 0
redirect_code varchar(32) NO
error_message varchar(1024) YES NULL
deleted enum('0','1') NO 0
own_app enum('1','0') NO 0
Sample Data
Loading sample data...

order_service_request

+
Table Structure (14 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO NULL
total decimal(19,4) NO 0.0000
status enum('new','processed','on_main_approve','approved_by_main','rejected_by_main','declined','error') NO new
with_pay enum('0','1') NO 0
pay_by_module varchar(64) NO
payment_id int unsigned YES NULL
invoice_id int unsigned YES NULL
requested_tariffs text NO NULL
created_services text NO NULL
datetime datetime NO NULL
process_with_main_approve tinyint(1) NO 0
comment text YES NULL
created_by int YES 0
Sample Data
Loading sample data...

order_service_request_items

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
order_id int unsigned NO NULL
price decimal(19,4) NO 0.0000
tariff_type varchar(255) NO
tariff_id int unsigned NO NULL
service_id int unsigned NO NULL
main_approve_datetime datetime YES NULL
main_reject_datetime datetime YES NULL
provider_approve_datetime datetime YES NULL
provider_reject_datetime datetime YES NULL
status enum('new','main_accepted','provider_accepted','main_rejected','provider_rejected') NO new
Sample Data
Loading sample data...

paired_calendars

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
admin_id int unsigned NO MUL NULL
scheduling_team_id int NO MUL NULL
name varchar(255) NO NULL
google_id varchar(255) NO NULL
color varchar(30) NO NULL
enabled enum('0','1') NO MUL 1
synchronised enum('0','1') NO 0
sync_token varchar(255) YES NULL
Relationships
References: → admins.id (via admin_id)
Referenced by: ← scheduling_task_paired_calendars.paired_calendar_id
Sample Data
Loading sample data...

partners

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(128) NO NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← bundle_to_partners.partner_id, monitoring_to_partners.partner_id, multiple_psk_automation.partner_id, network_sites_to_partners.partner_id, partners_values.id, routers_to_partners.partner_id, scheduling_project_to_partners.partner_id, tariffs_custom_to_partners.partner_id, tariffs_internet_to_partners.partner_id, tariffs_one_time_to_partners.partner_id, tariffs_voice_to_partners.partner_id, voice_devices_to_partners.partner_id
Sample Data
id0name1deleted2
11MainMain00
22Rapid ClientsRapid Clients00
33StaffStaff00

partners_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← partners_values.name
Sample Data
Loading sample data...

partners_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → partners.id (via id), partners_fields.name (via name)
Sample Data
Loading sample data...

payment_account

+
Table Structure (24 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(128) NO NULL
field_1 varchar(128) NO NULL
field_type_1 enum('string','numeric','hidden','email') YES string
field_2 varchar(128) NO NULL
field_type_2 enum('string','numeric','hidden','email') YES string
field_3 varchar(128) NO NULL
field_type_3 enum('string','numeric','hidden','email') YES string
field_4 varchar(128) NO NULL
field_type_4 enum('string','numeric','hidden','email') YES string
field_5 varchar(128) NO NULL
field_type_5 enum('string','numeric','hidden','email') YES string
field_6 varchar(128) NO NULL
field_type_6 enum('string','numeric','hidden','email') YES string
field_7 varchar(128) NO NULL
field_type_7 enum('string','numeric','hidden','email') YES string
field_8 varchar(128) NO NULL
field_type_8 enum('string','numeric','hidden','email') YES string
field_9 varchar(128) NO NULL
field_type_9 enum('string','numeric','hidden','email') YES string
field_10 varchar(128) NO NULL
field_type_10 enum('string','numeric','hidden','email') YES string
validator_php_file varchar(512) YES NULL
deleted enum('1','0') NO MUL 0
Relationships
Referenced by: ← payment_account_data.account_id
Sample Data
Loading sample data...

payment_account_data

+
Table Structure (13 columns)
Column Type Null Key Default Extra
account_id int unsigned NO PRI NULL
customer_id int unsigned NO PRI NULL
field_1 varchar(512) NO NULL
field_2 varchar(512) NO NULL
field_3 varchar(512) NO NULL
field_4 varchar(512) NO NULL
field_5 varchar(512) NO NULL
field_6 varchar(512) NO NULL
field_7 varchar(512) NO NULL
field_8 varchar(512) NO NULL
field_9 varchar(512) NO NULL
field_10 varchar(512) NO NULL
expiration_notification_sent enum('0','1') NO 0
Relationships
References: → payment_account.id (via account_id), customers.id (via customer_id)
Sample Data
Loading sample data...

payments

+
Table Structure (26 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
invoice_id int unsigned YES NULL
request_id int unsigned YES NULL
transaction_id int unsigned NO NULL
payment_type int unsigned NO NULL
receipt_number varchar(32) NO MUL NULL
date date NO NULL
real_create_datetime datetime NO NULL
amount decimal(19,4) NO NULL
remind_amount decimal(19,4) NO NULL
comment varchar(256) NO NULL
is_sent enum('0','1') NO 0
field_1 varchar(512) NO NULL
field_2 varchar(512) NO NULL
field_3 varchar(512) NO NULL
field_4 varchar(512) NO NULL
field_5 varchar(512) NO NULL
note text NO NULL
memo text NO NULL
added_by enum('system','api','admin') YES NULL
added_by_id int YES NULL
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
credit_note_id int YES NULL
payment_statement_id int YES NULL
Relationships
Referenced by: ← accounting_payments.payment_id, payments_values.id
Sample Data
id0customer_id1invoice_id2request_id3transaction_id4payment_type5receipt_number6date7real_create_datetime8amount9remind_amount10comment11is_sent12field_113field_214field_315field_416field_517note18memo19added_by20added_by_id21deleted22updated_at23credit_note_id24payment_statement_id25
44881771517715222020-02-000012020-02-000012020-12-222020-12-222020-12-22 13:51:162020-12-22 13:51:16599.0000599.00000.00000.0000EFTEFT11adminadmin55112021-01-29 10:58:152021-01-29 10:58:15
55881893218932222020-02-000012020-02-000012020-12-222020-12-222020-12-22 14:49:042020-12-22 14:49:04599.0000599.00000.00000.0000EFTEFT11adminadmin55112021-01-29 10:58:152021-01-29 10:58:15
66881893418934222020-02-000012020-02-000012020-12-222020-12-222020-12-22 14:51:292020-12-22 14:51:29599.0000599.00000.00000.0000EFTEFT11adminadmin55112021-01-29 10:58:152021-01-29 10:58:15

payments_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← payments_values.name
Sample Data
Loading sample data...

payments_types

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(128) NO NULL
is_active enum('0','1') NO MUL 1
name_1 varchar(64) NO NULL
name_2 varchar(64) NO NULL
name_3 varchar(64) NO NULL
name_4 varchar(64) NO NULL
name_5 varchar(64) NO NULL
accounting_bank_accounts_id int unsigned YES MUL NULL
einvoicing_payment_methods_id int unsigned YES MUL NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → accounting_bank_accounts.id (via accounting_bank_accounts_id), einvoicing_payment_methods.id (via einvoicing_payment_methods_id)
Sample Data
Loading sample data...

payments_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → payments.id (via id), payments_fields.name (via name)
Sample Data
Loading sample data...

pending_top_up

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
invoice_id int unsigned YES NULL
request_id int unsigned YES NULL
tariff_id int unsigned YES NULL
only_transaction enum('1','0') NO 0
service_id int unsigned YES NULL
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

permissions_administrator

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
controller varchar(128) NO PRI NULL
module varchar(64) NO PRI NULL
action varchar(64) NO PRI NULL
rule enum('allow','deny') NO NULL
Relationships
References: → admins.id (via id)
Sample Data
Loading sample data...

permissions_api_key

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
controller varchar(96) NO PRI NULL
module varchar(64) NO PRI NULL
action varchar(32) NO PRI NULL
rule enum('allow','deny') NO NULL
Relationships
References: → api.id (via id)
Sample Data
Loading sample data...

permissions_role

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id varchar(32) NO PRI NULL
controller varchar(255) NO PRI NULL
module varchar(64) NO PRI NULL
action varchar(64) NO PRI NULL
rule enum('allow','deny') NO NULL
Relationships
References: → roles.name (via id)
Sample Data
Loading sample data...

portal_messages

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
message_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
admin_id int unsigned YES 0
read enum('no','yes') NO no
subject varchar(256) NO NULL
message text NO NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← portal_messages_attachments.message_id
Sample Data
Loading sample data...

portal_messages_attachments

+
Table Structure (3 columns)
Column Type Null Key Default Extra
message_id int unsigned NO PRI NULL
type varchar(32) NO PRI NULL
file_id int unsigned NO PRI NULL
Relationships
References: → portal_messages.id (via message_id)
Sample Data
Loading sample data...

portal_news

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) YES NULL
text longtext YES NULL
deleted enum('0','1') YES 0
description text YES NULL
partners text NO NULL
locations text NO NULL
date date YES NULL
Relationships
Referenced by: ← portal_news_values.id, read_news_to_customer.news_id
Sample Data
Loading sample data...

portal_news_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← portal_news_values.name
Sample Data
Loading sample data...

portal_news_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → portal_news.id (via id), portal_news_fields.name (via name)
Sample Data
Loading sample data...

portal_onboarding

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
onboarding_tour varchar(64) YES NULL
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

portal_profile_additional_attributes

+
Table Structure (2 columns)
Column Type Null Key Default Extra
field varchar(64) NO PRI NULL
values varchar(256) NO NULL
Sample Data
Loading sample data...

prepaid_fup_counter

+
Table Structure (2 columns)
Column Type Null Key Default Extra
service_id int unsigned NO PRI NULL
days int unsigned NO NULL
Sample Data
Loading sample data...

provider_rates

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
provider_id int unsigned NO MUL NULL
name varchar(255) NO
description varchar(512) NO
type enum('call','message','data') NO MUL call
category_id int unsigned YES MUL NULL
prefix varchar(96) NO MUL
price decimal(19,4) NO 0.0000
first_step int unsigned NO 1
tariffication_step int unsigned NO 1
connect_cost decimal(19,4) NO 0.0000
Relationships
References: → voice_categories.id (via category_id), voice_providers.id (via provider_id)
Referenced by: ← provider_rates_cache.pair_id
Sample Data
Loading sample data...

provider_rates_cache

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO MUL NULL auto_increment
haystack varchar(48) NO PRI
pair_id int unsigned NO MUL NULL
Relationships
References: → provider_rates.id (via pair_id)
Sample Data
Loading sample data...

queue

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type varchar(32) NO NULL
type_id int unsigned NO NULL
status enum('new','process') NO MUL NULL
start_time datetime NO NULL
Sample Data
Loading sample data...

quotes

+
Table Structure (20 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
number varchar(100) NO NULL
date_created date NO NULL
real_create_datetime datetime NO NULL
date_updated date NO NULL
date_of_decision date NO NULL
date_till date NO NULL
total decimal(19,4) NO 0.0000
status enum('new','sent','on_review','accepted','denied') NO new
invoice_id int unsigned NO NULL
request_id int unsigned NO NULL
note text NO NULL
memo text NO NULL
signature varchar(64) YES NULL
added_by enum('system','api','admin','widget') YES NULL
added_by_id int YES NULL
is_customers enum('1','0') NO 0
is_sent enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← quotes_items.quote_id, quotes_values.id
Sample Data
Loading sample data...

quotes_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
disabled enum('1','0') NO 0
hidden enum('1','0') NO 0
Relationships
Referenced by: ← quotes_values.name
Sample Data
Loading sample data...

quotes_items

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
quote_id int unsigned NO MUL NULL
tariff varchar(64) YES
pos smallint unsigned NO MUL NULL
description varchar(256) NO NULL
quantity int NO NULL
unit varchar(16) NO NULL
price decimal(19,4) NO 0.0000
tax decimal(6,4) NO NULL
tax_id int unsigned NO NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → quotes.id (via quote_id)
Sample Data
Loading sample data...

quotes_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → quotes.id (via id), quotes_fields.name (via name)
Sample Data
Loading sample data...

radius_failover_servers

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
enabled enum('0','1') NO 0
host varbinary(4) NO NULL
port smallint unsigned NO 22
username varchar(32) NO root
privateKey text NO NULL
last_updated datetime NO NULL
status enum('new','init','syncing','synced','error_init','error_sync','error_remote','error_connection') NO new
last_synced datetime NO NULL
Sample Data
Loading sample data...

read_news_to_customer

+
Table Structure (2 columns)
Column Type Null Key Default Extra
news_id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO PRI NULL
Relationships
References: → customers.id (via customer_id), portal_news.id (via news_id)
Sample Data
Loading sample data...

requests

+
Table Structure (18 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
number varchar(64) NO MUL NULL
date_created date NO NULL
real_create_datetime datetime NO NULL
date_updated date NO NULL
date_payment date NO NULL
date_till date NO NULL
total decimal(19,4) NO NULL
status enum('not_paid','paid','pending') NO not_paid
payment_id int unsigned NO NULL
is_sent enum('0','1') NO 0
is_crm_request enum('0','1') NO 0
note text NO NULL
memo text NO NULL
added_by enum('system','api','admin') YES NULL
added_by_id int YES NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← requests_items.request_id, requests_values.id
Sample Data
Loading sample data...

requests_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← requests_values.name
Sample Data
Loading sample data...

requests_items

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
request_id int unsigned NO MUL NULL
sub_account_id int unsigned YES NULL
pos smallint unsigned NO MUL NULL
description varchar(256) NO NULL
quantity int NO NULL
unit varchar(16) NO NULL
price decimal(19,4) NO NULL
tax decimal(6,4) NO NULL
tax_id int unsigned NO NULL
period_from date NO NULL
period_to date NO NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → requests.id (via request_id)
Sample Data
Loading sample data...

requests_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → requests.id (via id), requests_fields.name (via name)
Sample Data
Loading sample data...

reset_password

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
random_code varchar(90) NO NULL
datetime_added datetime NO MUL NULL
customer_id int NO NULL
Sample Data
Loading sample data...

roles

+
Table Structure (3 columns)
Column Type Null Key Default Extra
name varchar(32) NO PRI NULL
title varchar(32) NO NULL
is_base enum('1','0') NO 0
Relationships
Referenced by: ← admins.role_name, permissions_role.id
Sample Data
Loading sample data...

routers

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
model varchar(128) NO NULL
nas_type int unsigned NO NULL
location_id int unsigned NO MUL NULL
address varchar(128) NO NULL
gps_point varchar(256) YES NULL
gps text YES NULL
ip varchar(128) NO NULL
radius_secret varchar(32) NO NULL
nas_ip varchar(45) NO MUL NULL
authorization_method enum('none','firewall_ip_mac_filter','dhcp_leases','ppp_dhcp_radius','ppp_secrets','hotspot_users','hotspot_radius') NO none
accounting_method enum('none','radius','netflow','mikrotik_api') NO none
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← routers_alternative_ip_addresses.router_id, routers_mikrotik.id, routers_mikrotik_log.router_id, routers_sectors.router_id, routers_to_ipv4_networks.router_id, routers_to_partners.router_id, routers_values.id
Sample Data
id0title1model2nas_type3location_id4address5gps_point6gps7ip8radius_secret9nas_ip10authorization_method11accounting_method12deleted13updated_at14
11RN-R-WS-MSR-Legacy-RRN-R-WS-MSR-Legacy-RCCR1016-12GCCR1016-12G1100Windstone FarmWindstone Farm35.06809935,-81.9540594691010835.06809935,-81.9540594691010810.60.180.25010.60.180.2509cc97650e66f9cc97650e66f10.60.180.25010.60.180.250ppp_dhcp_radiusppp_dhcp_radiusradiusradius002024-03-15 11:26:462024-03-15 11:26:46
22RN-CORE-PPPOE_ServerRN-CORE-PPPOE_ServerCCR1036-8G-2S+CCR1036-8G-2S+1100Windstone FarmWindstone Farm-32.944442631759664,18.095785640180114-32.944442631759664,18.09578564018011410.60.0.210.60.0.258a77ba8116558a77ba8116510.60.0.210.60.0.2ppp_dhcp_radiusppp_dhcp_radiusradiusradius112021-05-25 11:41:172021-05-25 11:41:17
33RN-VLDF1-R-1RN-VLDF1-R-1111919Velddrif1 TowerVelddrif1 Tower-32.88616889403359,18.117161840200424-32.88616889403359,18.11716184020042410.150.254.25410.150.254.254191d913d2a6b191d913d2a6b10.150.0.210.150.0.2ppp_dhcp_radiusppp_dhcp_radiusradiusradius002024-03-15 11:26:462024-03-15 11:26:46

routers_alternative_ip_addresses

+
Table Structure (4 columns)
Column Type Null Key Default Extra
router_id int unsigned NO PRI NULL
address varchar(128) NO PRI NULL
ip_from int unsigned NO NULL
ip_to int unsigned NO NULL
Relationships
References: → routers.id (via router_id)
Sample Data
Loading sample data...

routers_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← routers_values.name
Sample Data
Loading sample data...

routers_mikrotik

+
Table Structure (30 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
api_login varchar(64) NO MUL NULL
api_password varchar(512) NO NULL
api_port int unsigned NO 8728
api_enable enum('0','1') NO MUL 1
api_status enum('ok','error','disabled','unknown') NO unknown
shaper enum('1','0') NO 0
shaper_id int unsigned NO NULL
shaping_type enum('simple','pcq_address_list','simple_tree') NO simple
disabled_to_al enum('0','1') NO 0
wireless_al enum('0','1') NO 0
push_firewall_filter_rules enum('0','1') NO 1
last_status datetime NO NULL
cpu_usage int unsigned NO NULL
platform varchar(30) NO NULL
board_name varchar(30) NO NULL
version varchar(32) NO NULL
connection_error int unsigned NO NULL
last_api_error enum('0','1') NO 0
is_used enum('0','1') NO MUL NULL
pid int unsigned NO 0
used_date_time datetime NO MUL NULL
change_status enum('0','1') NO NULL
change_authorization enum('0','1') NO NULL
change_shaping enum('0','1') NO NULL
last_connect datetime NO NULL
last_accounting datetime NO NULL
ipv6 enum('0','1') NO 0
update_firewall_filter_rules enum('0','1') NO 1
deleted enum('0','1') NO MUL 0
Relationships
References: → routers.id (via id)
Referenced by: ← routers_mikrotik_values.id
Sample Data
Loading sample data...

routers_mikrotik_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← routers_mikrotik_values.name
Sample Data
Loading sample data...

routers_mikrotik_log

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
router_id int unsigned NO MUL NULL
date_time datetime NO NULL
processing_time decimal(6,2) NO NULL
processing_memory int unsigned NO NULL
counters mediumtext NO NULL
ok_count int unsigned NO NULL
error_count int unsigned NO NULL
actions varchar(20) NO NULL
status enum('0','1') NO NULL
Relationships
References: → routers.id (via router_id)
Sample Data
Loading sample data...

routers_mikrotik_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → routers_mikrotik.id (via id), routers_mikrotik_fields.name (via name)
Sample Data
Loading sample data...

routers_sectors

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
router_id int unsigned NO MUL NULL
title varchar(64) NO NULL
speed_down int unsigned NO NULL
speed_up int unsigned NO NULL
limit_at tinyint unsigned NO NULL
deleted enum('0','1') NO MUL 0
Relationships
References: → routers.id (via router_id)
Referenced by: ← routers_sectors_values.id
Sample Data
Loading sample data...

routers_sectors_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← routers_sectors_values.name
Sample Data
Loading sample data...

routers_sectors_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → routers_sectors.id (via id), routers_sectors_fields.name (via name)
Sample Data
Loading sample data...

routers_to_ipv4_networks

+
Table Structure (2 columns)
Column Type Null Key Default Extra
router_id int unsigned NO PRI NULL
ipv4_network_id int unsigned NO PRI NULL
Relationships
References: → ipv4_networks.id (via ipv4_network_id), routers.id (via router_id)
Sample Data
Loading sample data...

routers_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
router_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), routers.id (via router_id)
Sample Data
Loading sample data...

routers_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → routers.id (via id), routers_fields.name (via name)
Sample Data
Loading sample data...

scheduling_checklist_template

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
Sample Data
Loading sample data...

scheduling_checklist_template_item

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
checklist_template_id int unsigned NO NULL
name varchar(64) NO NULL
position int unsigned NO 1
Relationships
Referenced by: ← scheduling_task_checklist_item_status.checklist_template_item_id
Sample Data
Loading sample data...

scheduling_project

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
description tinytext NO NULL
type_id int NO NULL
lead_id int NO NULL
category_id int NO NULL
workflow_id int NO NULL
is_archive enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← scheduling_project_to_partners.project_id, scheduling_project_values.id
Sample Data
Loading sample data...

scheduling_project_category

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
title varchar(64) NO NULL
Sample Data
Loading sample data...

scheduling_project_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← scheduling_project_values.name
Sample Data
Loading sample data...

scheduling_project_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
project_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), scheduling_project.id (via project_id)
Sample Data
Loading sample data...

scheduling_project_type

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
title varchar(64) NO NULL
Sample Data
Loading sample data...

scheduling_project_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → scheduling_project.id (via id), scheduling_project_fields.name (via name)
Sample Data
Loading sample data...

scheduling_task

+
Table Structure (34 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(250) NO NULL
description text NO NULL
partner_id int YES NULL
reporter_id int unsigned YES 0
related_to_id int unsigned YES NULL
parent_task_id int unsigned YES NULL
project_id int NO NULL
location_id int NO 0
related_customer_id int unsigned YES NULL
related_service_type enum('internet','voice','recurring') YES NULL
related_service_id int unsigned YES 0
created_at datetime NO NULL
updated_at datetime NO NULL
resolved_at datetime NO NULL
assigned_to enum('assigned_to_anyone','assigned_to_administrator','assigned_to_team') NO MUL assigned_to_anyone
assignee int unsigned NO NULL
assinged_at datetime NO NULL
priority enum('priority_low','priority_medium','priority_high') NO priority_medium
is_scheduled enum('0','1') NO 0
scheduled_from datetime NO NULL
scheduled_to datetime NO NULL
travel_time_to mediumint NO 0
travel_time_from mediumint NO 0
checklist_template_id int unsigned NO NULL
closed enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
workflow_status_id int unsigned NO NULL
is_archived enum('0','1') NO 0
address varchar(512) YES NULL
gps varchar(512) YES NULL
notification_send_interval int unsigned NO 0
notification_enabled enum('0','1') NO MUL 1
last_status_changed datetime YES NULL
Relationships
Referenced by: ← scheduling_task_activity_log.task_id, scheduling_task_checklist_item_status.task_id, scheduling_task_labels.id, scheduling_task_paired_calendars.scheduling_task_id, scheduling_task_status_logs_changes.task_id, scheduling_task_timer.task_id, scheduling_task_values.id, scheduling_task_worklog.task_id, ticket.task_id
Sample Data
Loading sample data...

scheduling_task_activity_log

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
task_id int unsigned NO MUL NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Relationships
References: → scheduling_task.id (via task_id)
Sample Data
Loading sample data...

scheduling_task_attachment

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
task_id int unsigned NO NULL
file_id int unsigned NO NULL
user_id int unsigned NO NULL
added_at datetime NO NULL
Sample Data
Loading sample data...

scheduling_task_checklist_item_status

+
Table Structure (4 columns)
Column Type Null Key Default Extra
task_id int unsigned NO PRI NULL
checklist_template_item_id int unsigned NO PRI NULL
updated_at datetime NO NULL
checked enum('0','1') NO 0
Relationships
References: → scheduling_checklist_template_item.id (via checklist_template_item_id), scheduling_task.id (via task_id)
Sample Data
Loading sample data...

scheduling_task_comment

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
task_id int unsigned NO NULL
user_id int unsigned NO NULL
comment text YES NULL
created_at datetime NO NULL
is_pinned tinyint unsigned NO 0
pinned_datetime datetime YES NULL
is_edited tinyint(1) NO 0
Sample Data
Loading sample data...

scheduling_task_comment_to_files_upload

+
Table Structure (2 columns)
Column Type Null Key Default Extra
file_id int unsigned YES MUL NULL
comment_id int unsigned YES NULL
Sample Data
Loading sample data...

scheduling_task_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 0
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← scheduling_task_values.name
Sample Data
Loading sample data...

scheduling_task_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → scheduling_task.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

scheduling_task_paired_calendars

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
scheduling_task_id int unsigned NO MUL NULL
paired_calendar_id int unsigned NO MUL NULL
google_id varchar(255) NO NULL
Relationships
References: → paired_calendars.id (via paired_calendar_id), scheduling_task.id (via scheduling_task_id)
Sample Data
Loading sample data...

scheduling_task_status_logs_changes

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
task_id int unsigned NO MUL NULL
old_status int unsigned NO NULL
new_status int unsigned NO NULL
datetime datetime NO NULL
duration_in_previous_status int unsigned NO NULL
changed_by enum('admin','api') NO admin
changed_by_id int unsigned NO NULL
deleted enum('1','0') NO 0
Relationships
References: → scheduling_task.id (via task_id)
Sample Data
Loading sample data...

scheduling_task_template

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
title varchar(250) NO NULL
task_title varchar(250) NO NULL
task_description text NO NULL
task_project_id int unsigned NO NULL
task_assigned_to enum('assigned_to_anyone','assigned_to_administrator','assigned_to_team') NO assigned_to_anyone
task_assigned_to_id int unsigned NO NULL
task_checklist_template_id int unsigned NO NULL
task_priority enum('priority_low','priority_medium','priority_high') NO priority_medium
additional_fields text YES NULL
Sample Data
Loading sample data...

scheduling_task_timer

+
Table Structure (5 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
task_id int unsigned NO PRI NULL
logged_already int unsigned NO NULL
started_at datetime NO NULL
first_started_at datetime NO NULL
Relationships
References: → admins.id (via admin_id), scheduling_task.id (via task_id)
Sample Data
Loading sample data...

scheduling_task_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → scheduling_task.id (via id), scheduling_task_fields.name (via name)
Sample Data
Loading sample data...

scheduling_task_watchers_to_admins

+
Table Structure (2 columns)
Column Type Null Key Default Extra
task_id int unsigned NO MUL NULL
admin_id int unsigned NO MUL NULL
Sample Data
Loading sample data...

scheduling_task_worklog

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
task_id int unsigned YES MUL NULL
user_id int unsigned NO NULL
created_at datetime NO NULL
started_at datetime NO NULL
stopped_at datetime NO NULL
is_manual tinyint(1) NO 0
time_spent int NO NULL
description text YES NULL
Relationships
References: → scheduling_task.id (via task_id)
Sample Data
Loading sample data...

scheduling_tasks_relationships

+
Table Structure (2 columns)
Column Type Null Key Default Extra
from_id int unsigned NO PRI NULL
to_id int unsigned NO PRI NULL
Sample Data
Loading sample data...

scheduling_team

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
title varchar(64) NO NULL
partner_id int unsigned NO NULL
members tinytext NO NULL
calendar_color varchar(50) YES NULL
Sample Data
Loading sample data...

scheduling_workflow

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
title varchar(64) NO NULL
Sample Data
Loading sample data...

scheduling_workflow_items

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
workflow_id int unsigned NO NULL
title varchar(64) NO NULL
position int unsigned NO 1
stage enum('new','in_progress','done') NO new
due_days smallint NO 0
auto_reassign_to enum('assigned_to_anyone','assigned_to_administrator','assigned_to_team') NO assigned_to_anyone
auto_reassign_id int unsigned YES NULL
Sample Data
Loading sample data...

sended_cap_notifications

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
notification_id int unsigned YES MUL NULL
service_id int unsigned YES NULL
Sample Data
Loading sample data...

sended_fup_notifications

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
notification_id int unsigned NO MUL NULL
service_id int unsigned NO NULL
datetime datetime NO NULL
Sample Data
Loading sample data...

service_additional_discount

+
Table Structure (11 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_type enum('bundle','internet','voice','custom') NO MUL NULL
service_id int unsigned NO NULL
enabled enum('1','0') NO 1
percent decimal(5,2) unsigned NO NULL
start_date date NO NULL
end_date date NO NULL
message text NO NULL
created_at datetime NO NULL
updated_at datetime NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

service_geo_data

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
service_id int NO MUL NULL
gps varchar(255) NO NULL
address varchar(250) YES NULL
Sample Data
Loading sample data...

services_bundle

+
Table Structure (29 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
parent_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
bundle_id int unsigned NO NULL
description varchar(512) NO NULL
unit_price decimal(19,4) NO NULL
start_date date NO NULL
end_date date NO NULL
automatic_renewal enum('1','0') NO 0
auto_reactivate enum('1','0') NO 0
activation_fee decimal(19,4) NO NULL
get_activation_fee_when enum('create_service','first_service_billing') NO NULL
issue_invoice_while_service_creation enum('0','1') NO 0
activation_fee_transaction_id int unsigned NO MUL NULL
cancellation_fee decimal(19,4) NO NULL
cancellation_fee_transaction_id int unsigned YES NULL
prior_cancellation_fee decimal(19,4) NO NULL
prior_cancellation_fee_transaction_id int unsigned NO NULL
discount enum('1','0') NO 0
discount_value decimal(19,4) YES NULL
discount_type enum('percent','fixed') NO percent
discount_start_date date NO NULL
discount_end_date date NO NULL
discount_text varchar(512) NO NULL
status varchar(64) NO MUL NULL
deleted enum('0','1') NO MUL 0
period enum('-1','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99') NO -1
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
on_approve enum('1','0') NO 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← services_bundle_values.id
Sample Data
Loading sample data...

services_bundle_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_bundle_values.name
Sample Data
Loading sample data...

services_bundle_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_bundle.id (via id), services_bundle_fields.name (via name)
Sample Data
Loading sample data...

services_custom

+
Table Structure (24 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
parent_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
tariff_id int unsigned NO NULL
bundle_service_id int unsigned NO NULL
description varchar(512) NO NULL
quantity int NO NULL
unit varchar(128) NO NULL
unit_price decimal(19,4) NO NULL
start_date date NO NULL
end_date date NO NULL
status varchar(64) NO MUL NULL
status_new varchar(64) NO NULL
discount enum('1','0') NO 0
discount_value decimal(19,4) YES NULL
discount_type enum('percent','fixed') NO percent
discount_start_date date NO NULL
discount_end_date date NO NULL
discount_text varchar(512) NO NULL
deleted enum('0','1') NO MUL 0
period enum('-1','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99') NO -1
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
old_end_date date NO NULL
on_approve enum('1','0') NO 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← services_custom_values.id
Sample Data
Loading sample data...

services_custom_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_custom_values.name
Sample Data
Loading sample data...

services_custom_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_custom.id (via id), services_custom_fields.name (via name)
Sample Data
Loading sample data...

services_internet

+
Table Structure (41 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
parent_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
tariff_id int unsigned NO NULL
top_up_tariff_id int unsigned YES NULL
bundle_service_id int unsigned NO NULL
router_id int unsigned NO MUL NULL
access_device int NO 0
description varchar(512) NO NULL
quantity int NO NULL
unit varchar(128) NO NULL
unit_price decimal(19,4) NO NULL
start_date date NO NULL
end_date date NO NULL
status varchar(64) NO MUL NULL
status_new varchar(64) NO NULL
discount enum('1','0') NO 0
discount_value decimal(19,4) YES NULL
discount_type enum('percent','fixed') NO percent
discount_start_date date NO NULL
discount_end_date date NO NULL
discount_text varchar(512) NO NULL
deleted enum('0','1') NO MUL 0
login varchar(64) NO MUL NULL
password varchar(512) NO NULL
ipv4_pool_id int unsigned NO NULL
sector_id int unsigned NO NULL
taking_ipv4 enum('0','1','2','3','4') NO MUL 0
taking_ipv6 enum('0','1','2','3') NO 0
ipv4 varchar(18) NO NULL
ipv4_route varchar(255) NO NULL
ipv6 varchar(48) NO NULL
ipv6_delegated varchar(48) NO NULL
ipv6_pool_id int unsigned NO NULL
mac varchar(255) NO MUL NULL
port_id varchar(255) NO MUL NULL
period enum('-1','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99') NO -1
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
old_end_date date NO NULL
on_approve enum('1','0') NO 0
multiple_psk_ssids int unsigned NO 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← capped_data.service_id, fup_compiled.service_id, fup_counter.service_id, fup_override.service_id, services_internet_values.id
Sample Data
id0parent_id1customer_id2tariff_id3top_up_tariff_id4bundle_service_id5router_id6access_device7description8quantity9unit10unit_price11start_date12end_date13status14status_new15discount16discount_value17discount_type18discount_start_date19discount_end_date20discount_text21deleted22login23password24ipv4_pool_id25sector_id26taking_ipv427taking_ipv628ipv429ipv4_route30ipv631ipv6_delegated32ipv6_pool_id33mac34port_id35period36updated_at37old_end_date38on_approve39multiple_psk_ssids40
11001155002200Business Premium - 50M/50MBusiness Premium - 50M/50M110.00000.00002021-01-012021-01-012021-07-142021-07-14disableddisabled000.00000.0000percentpercent0000-00-000000-00-000000-00-000000-00-0011mwinder01mwinder01twxHMD9/hzxpCZ7DmYqXX2Y2X5CkakS7JEPIoqBhwz8=twxHMD9/hzxpCZ7DmYqXX2Y2X5CkakS7JEPIoqBhwz8=0000110041.164.118.16441.164.118.16400-1-12021-07-15 03:43:062021-07-15 03:43:060000-00-000000-00-000000
22002244002200Business Premium - 100M/100MBusiness Premium - 100M/100M1122000.000022000.00002021-01-012021-01-010000-00-000000-00-00disableddisabled000.00000.0000percentpercent0000-00-000000-00-000000-00-000000-00-0000windstone01windstone013XeAdd2TxaTZmfzE0BAEsW70D6N+elcgGEoljl/4D5k=3XeAdd2TxaTZmfzE0BAEsW70D6N+elcgGEoljl/4D5k=0000110041.164.118.16541.164.118.16500-1-12021-01-29 10:58:152021-01-29 10:58:150000-00-000000-00-000000
4400441100111100Rapid_Staff 20M/5MRapid_Staff 20M/5M110.00000.00002021-01-012021-01-012025-11-092025-11-09disableddisabled110.00000.0000percentpercent0000-00-000000-00-000000-00-000000-00-0000blombard01blombard01Y2skoGn1ZDB4GCQZPvbSFT/HJHlf09qi1ljVYw3X/4o=Y2skoGn1ZDB4GCQZPvbSFT/HJHlf09qi1ljVYw3X/4o=0000110010.20.41.1510.20.41.1500-1-12025-11-10 17:36:392025-11-10 17:36:390000-00-000000-00-000000

services_internet_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_internet_values.name
Sample Data
Loading sample data...

services_internet_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_internet.id (via id), services_internet_fields.name (via name)
Sample Data
Loading sample data...

services_phones

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
service_id int unsigned NO MUL NULL
phone varchar(96) NO
mask varchar(255) NO
weight int unsigned NO 0
from bigint unsigned YES NULL
to bigint unsigned YES NULL
prefix varchar(32) NO
deleted enum('0','1') NO 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
References: → services_voice.id (via service_id)
Sample Data
Loading sample data...

services_recurring_geo_data

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
service_id int NO MUL NULL
gps varchar(255) NO NULL
address varchar(250) YES NULL
Sample Data
Loading sample data...

services_voice

+
Table Structure (26 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
parent_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
tariff_id int unsigned NO NULL
bundle_service_id int unsigned NO NULL
voice_device_id int unsigned NO NULL
direction enum('incoming','outgoing') NO outgoing
description varchar(512) NO NULL
quantity int NO NULL
unit varchar(128) NO NULL
unit_price decimal(19,4) NO NULL
start_date date NO NULL
end_date date NO NULL
status varchar(64) NO MUL NULL
status_new varchar(64) NO NULL
discount enum('1','0') NO 0
discount_value decimal(19,4) YES NULL
discount_type enum('percent','fixed') NO percent
discount_start_date date NO NULL
discount_end_date date NO NULL
discount_text varchar(512) NO NULL
deleted enum('0','1') NO MUL 0
period enum('-1','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99') NO -1
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
old_end_date date NO NULL
on_approve enum('1','0') NO 0
Relationships
References: → customers.id (via customer_id)
Referenced by: ← services_phones.service_id, services_voice_cache.pair_id, services_voice_values.id
Sample Data
Loading sample data...

services_voice_cache

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO MUL NULL auto_increment
haystack varchar(48) NO PRI
pair_id int unsigned NO MUL NULL
Relationships
References: → services_voice.id (via pair_id)
Sample Data
Loading sample data...

services_voice_calls

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO MUL NULL
transaction_id int unsigned NO MUL NULL
category int unsigned NO NULL
source varchar(32) NO NULL
start datetime NO PRI NULL
stop datetime NO NULL
call_to varchar(32) NO NULL
direction_type enum('incoming','outgoing') NO outgoing
sell_price decimal(19,6) YES NULL
buy_price decimal(19,6) YES NULL
rate_buy_price decimal(19,6) YES NULL
comment varchar(256) NO NULL
is_price_from_import enum('0','1') NO 0
rate_name varchar(255) NO
deleted enum('0','1') NO MUL 0
import_id int YES MUL NULL
approved enum('0','1') NO 1
Sample Data
Loading sample data...

services_voice_calls_fields

+
Table Structure (24 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
tariff_type varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_voice_calls_values.name
Sample Data
Loading sample data...

services_voice_calls_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_voice_calls_fields.name (via name)
Sample Data
Loading sample data...

services_voice_data

+
Table Structure (17 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO MUL NULL
transaction_id int unsigned NO MUL NULL
category int unsigned NO NULL
source varchar(32) NO NULL
datetime datetime NO PRI NULL
amount bigint unsigned NO NULL
sell_price decimal(19,6) YES NULL
buy_price decimal(19,6) YES NULL
rate_buy_price decimal(19,6) YES NULL
comment varchar(256) NO NULL
is_price_from_import enum('0','1') NO 0
rate_name varchar(255) NO
deleted enum('0','1') NO MUL 0
import_id int YES MUL NULL
approved enum('0','1') NO 1
Sample Data
Loading sample data...

services_voice_data_fields

+
Table Structure (24 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
tariff_type varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_voice_data_values.name
Sample Data
Loading sample data...

services_voice_data_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_voice_data_fields.name (via name)
Sample Data
Loading sample data...

services_voice_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_voice_values.name
Sample Data
Loading sample data...

services_voice_geo_data

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int NO PRI NULL auto_increment
service_id int NO MUL NULL
gps varchar(255) NO NULL
address varchar(250) YES NULL
Sample Data
Loading sample data...

services_voice_messages

+
Table Structure (19 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO MUL NULL
transaction_id int unsigned NO MUL NULL
category int unsigned NO NULL
source varchar(32) NO NULL
send_at datetime NO PRI NULL
destination varchar(32) NO NULL
direction_type enum('incoming','outgoing') NO outgoing
amount int NO NULL
sell_price decimal(19,6) YES NULL
buy_price decimal(19,6) YES NULL
rate_buy_price decimal(19,6) YES NULL
comment varchar(256) NO NULL
is_price_from_import enum('0','1') NO 0
rate_name varchar(255) NO
deleted enum('0','1') NO MUL 0
import_id int YES MUL NULL
approved enum('0','1') NO 1
Sample Data
Loading sample data...

services_voice_messages_fields

+
Table Structure (24 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
tariff_type varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← services_voice_messages_values.name
Sample Data
Loading sample data...

services_voice_messages_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_voice_messages_fields.name (via name)
Sample Data
Loading sample data...

services_voice_phones_index

+
Table Structure (2 columns)
Column Type Null Key Default Extra
phone varchar(48) NO PRI
pair_id int unsigned NO PRI NULL
Sample Data
Loading sample data...

services_voice_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → services_voice.id (via id), services_voice_fields.name (via name)
Sample Data
Loading sample data...

sms_pool

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type varchar(32) NO MUL NULL
message_id int unsigned NO NULL
status enum('new','sending','sent','error','expired') NO MUL new
datetime_added datetime NO PRI NULL
datetime_start_sending datetime NO NULL
datetime_sent datetime NO NULL
recipient varchar(64) NO NULL
message text NO NULL
customer_id int NO NULL
admin_id int unsigned YES 0
priority tinyint unsigned NO 2
Sample Data
Loading sample data...

statistics

+
Table Structure (23 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
service_id int unsigned NO MUL NULL
tariff_id int unsigned NO NULL
partner_id int unsigned NO NULL
nas_id int unsigned NO NULL
login varchar(128) NO NULL
in_bytes bigint unsigned NO NULL
out_bytes bigint unsigned NO NULL
start_date date NO PRI NULL
start_time time NO NULL
end_date date NO NULL
end_time time NO NULL
ipv4 varbinary(4) NO NULL
ipv6 varbinary(16) NO NULL
mac varchar(32) NO NULL
call_to varchar(32) NO NULL
port varchar(32) NO NULL
error tinyint unsigned NO NULL
error_repeat int unsigned NO NULL
price decimal(12,4) NO NULL
session_id varchar(32) NO MUL NULL
terminate_cause tinyint unsigned NO NULL
Sample Data
Loading sample data...

statistics_cache

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
statistics_id int unsigned NO NULL
customer_id int unsigned NO MUL NULL
session_id varchar(48) NO NULL
date_time datetime NO MUL NULL
Sample Data
Loading sample data...

statistics_customers_statuses

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id bigint unsigned NO PRI NULL auto_increment
report_date date NO PRI NULL
partner_id int unsigned NO MUL NULL
location_id int unsigned NO NULL
total int unsigned NO NULL
active int unsigned NO NULL
new int unsigned NO NULL
blocked int unsigned NO NULL
disabled int unsigned NO NULL
Sample Data
Loading sample data...

statuses_pending

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
date date NO NULL
status enum('new','active','blocked','disabled') NO disabled
done enum('0','1') NO MUL 0
administrator_id int unsigned NO NULL
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

subdivisions

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(255) NO
code varchar(10) NO NULL
date_changed date NO NULL
deleted enum('0','1') NO 0
is_default tinyint(1) NO 0
Sample Data
Loading sample data...

tariffs_custom

+
Table Structure (15 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariffs_for_change varchar(512) NO NULL
title varchar(64) NO NULL
available_for_services enum('0','1') NO 1
show_on_customer_portal enum('0','1') NO 0
hide_on_admin_portal enum('0','1') NO 0
service_name varchar(64) NO NULL
price decimal(19,4) NO NULL
billing_days_count smallint unsigned YES NULL
with_vat enum('0','1') NO 1
vat_percent decimal(6,4) NO 0.0000
tax_id int unsigned NO NULL
transaction_category_id int unsigned NO 0
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← bundle_to_tariffs_custom.tariff_id, tariffs_custom_module_labels.id, tariffs_custom_to_billing_types.tariff_id, tariffs_custom_to_customer_categories.tariff_id, tariffs_custom_to_locations.tariff_id, tariffs_custom_to_partners.tariff_id, tariffs_custom_values.id
Sample Data
Loading sample data...

tariffs_custom_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← tariffs_custom_values.name
Sample Data
Loading sample data...

tariffs_custom_module_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → tariffs_custom.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

tariffs_custom_to_billing_types

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
billing_type varchar(255) NO PRI NULL
Relationships
References: → tariffs_custom.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_custom_to_customer_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
customer_category varchar(255) NO PRI NULL
Relationships
References: → tariffs_custom.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_custom_to_locations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
location_id int unsigned NO PRI NULL
Relationships
References: → locations.id (via location_id), tariffs_custom.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_custom_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), tariffs_custom.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_custom_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → tariffs_custom.id (via id), tariffs_custom_fields.name (via name)
Sample Data
Loading sample data...

tariffs_from_import

+
Table Structure (3 columns)
Column Type Null Key Default Extra
origin_id int unsigned NO PRI NULL
type varchar(64) NO PRI NULL
id int unsigned NO PRI NULL
Sample Data
Loading sample data...

tariffs_internet

+
Table Structure (32 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariffs_for_change varchar(512) NO NULL
title varchar(64) NO NULL
available_for_services enum('0','1') NO 1
show_on_customer_portal enum('0','1') NO 0
hide_on_admin_portal enum('0','1') NO 0
service_name varchar(64) NO NULL
price decimal(19,4) NO NULL
billing_days_count smallint unsigned YES NULL
with_vat enum('0','1') NO 1
vat_percent decimal(6,4) NO 0.0000
tax_id int unsigned NO NULL
speed_download int unsigned NO NULL
speed_upload int unsigned NO NULL
speed_limit_type enum('none','percent','fixed') NO percent
speed_limit_at tinyint NO 10
speed_limit_fixed_up int unsigned NO 0
speed_limit_fixed_down int unsigned NO 0
aggregation tinyint unsigned NO 1
burst_type enum('none','percent','fixed') NO none
burst_limit int unsigned YES NULL
burst_limit_fixed_up int unsigned NO 0
burst_limit_fixed_down int unsigned NO 0
burst_threshold int unsigned NO 0
burst_threshold_fixed_up int unsigned NO 0
burst_threshold_fixed_down int unsigned NO 0
burst_time int unsigned NO 0
priority enum('low','normal','high') NO normal
transaction_category_id int unsigned NO 0
exclude_traffic_classes varchar(512) YES NULL
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← bundle_to_tariffs_internet.tariff_id, fup_policies.tariff_id, multiple_psk_automation.tariff_id, tariffs_internet_module_labels.id, tariffs_internet_to_billing_types.tariff_id, tariffs_internet_to_customer_categories.tariff_id, tariffs_internet_to_locations.tariff_id, tariffs_internet_to_partners.tariff_id, tariffs_internet_values.id
Sample Data
id0tariffs_for_change1title2available_for_services3show_on_customer_portal4hide_on_admin_portal5service_name6price7billing_days_count8with_vat9vat_percent10tax_id11speed_download12speed_upload13speed_limit_type14speed_limit_at15speed_limit_fixed_up16speed_limit_fixed_down17aggregation18burst_type19burst_limit20burst_limit_fixed_up21burst_limit_fixed_down22burst_threshold23burst_threshold_fixed_up24burst_threshold_fixed_down25burst_time26priority27transaction_category_id28exclude_traffic_classes29deleted30updated_at31
11Rapid_Staff 20M/5MRapid_Staff 20M/5M110000Rapid_Staff 20M/5MRapid_Staff 20M/5M0.00000.00000015.000015.00001120480204801024010240nonenone100100000011fixedfixed2048020480409604096000102401024020480204806060highhigh00002023-07-25 16:53:052023-07-25 16:53:05
33Rapid Staff 12M/4MRapid Staff 12M/4M000000Rapid Staff 12M/4MRapid Staff 12M/4M0.00000.00001115.000015.000011122881228840964096nonenone00000011percentpercent100100000050500000240240normalnormal00002025-03-17 12:13:162025-03-17 12:13:16
4408 - Business Premium - 100M/100M08 - Business Premium - 100M/100M000000Business Premium - 100M/100MBusiness Premium - 100M/100M22000.000022000.00001115.000015.000011102400102400102400102400nonenone00000011percentpercent1001000000808000006060highhigh146146002025-03-17 12:14:282025-03-17 12:14:28

tariffs_internet_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← tariffs_internet_values.name
Sample Data
Loading sample data...

tariffs_internet_module_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → tariffs_internet.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

tariffs_internet_to_billing_types

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
billing_type varchar(255) NO PRI NULL
Relationships
References: → tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_internet_to_customer_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
customer_category varchar(255) NO PRI NULL
Relationships
References: → tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_internet_to_locations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
location_id int unsigned NO PRI NULL
Relationships
References: → locations.id (via location_id), tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_internet_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), tariffs_internet.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_internet_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → tariffs_internet.id (via id), tariffs_internet_fields.name (via name)
Sample Data
Loading sample data...

tariffs_one_time

+
Table Structure (13 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
service_description varchar(128) NO
enabled enum('0','1') NO 1
price decimal(19,4) NO NULL
with_vat enum('0','1') YES 1
vat_percent decimal(6,4) NO 0.0000
tax_id int unsigned NO NULL
transaction_category_id int unsigned NO 0
show_on_customer_portal enum('0','1') NO 0
hide_on_admin_portal enum('0','1') NO 0
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← tariffs_one_time_module_labels.id, tariffs_one_time_to_customer_categories.tariff_id, tariffs_one_time_to_locations.tariff_id, tariffs_one_time_to_partners.tariff_id, tariffs_one_time_values.id
Sample Data
Loading sample data...

tariffs_one_time_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← tariffs_one_time_values.name
Sample Data
Loading sample data...

tariffs_one_time_module_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → tariffs_one_time.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

tariffs_one_time_to_customer_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
customer_category varchar(255) NO PRI NULL
Relationships
References: → tariffs_one_time.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_one_time_to_locations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
location_id int unsigned NO PRI NULL
Relationships
References: → locations.id (via location_id), tariffs_one_time.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_one_time_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), tariffs_one_time.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_one_time_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → tariffs_one_time.id (via id), tariffs_one_time_fields.name (via name)
Sample Data
Loading sample data...

tariffs_voice

+
Table Structure (22 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariffs_for_change varchar(512) NO NULL
title varchar(64) NO NULL
available_for_services enum('0','1') NO 1
show_on_customer_portal enum('0','1') NO 0
hide_on_admin_portal enum('0','1') NO 0
service_name varchar(64) NO NULL
customer_rate_table_id int unsigned YES NULL
buy_price_increase smallint NO 0
price decimal(19,4) NO NULL
billing_days_count smallint unsigned YES NULL
type enum('voip','mobile','fix') NO voip
connection_cost_included enum('0','1') NO 1
with_vat enum('0','1') NO 1
vat_percent decimal(6,4) NO 0.0000
tax_id int unsigned NO NULL
transaction_category_id int unsigned NO 0
transaction_category_id_for_calls int unsigned NO NULL
transaction_category_id_for_messages int unsigned NO NULL
transaction_category_id_for_data int unsigned NO NULL
deleted enum('0','1') NO MUL 0
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
Relationships
Referenced by: ← bundle_to_tariffs_voice.tariff_id, tariffs_voice_module_labels.id, tariffs_voice_to_billing_types.tariff_id, tariffs_voice_to_customer_categories.tariff_id, tariffs_voice_to_locations.tariff_id, tariffs_voice_to_partners.tariff_id, tariffs_voice_values.id, voice_included_pricing.tariff_id, voice_pricing_groups.tariff_id
Sample Data
Loading sample data...

tariffs_voice_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← tariffs_voice_values.name
Sample Data
Loading sample data...

tariffs_voice_module_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → tariffs_voice.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

tariffs_voice_to_billing_types

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
billing_type varchar(255) NO PRI NULL
Relationships
References: → tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_voice_to_customer_categories

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
customer_category varchar(255) NO PRI NULL
Relationships
References: → tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_voice_to_locations

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
location_id int unsigned NO PRI NULL
Relationships
References: → locations.id (via location_id), tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_voice_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
tariff_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

tariffs_voice_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → tariffs_voice.id (via id), tariffs_voice_fields.name (via name)
Sample Data
Loading sample data...

tax

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
rate decimal(7,4) unsigned NO NULL
name varchar(256) NO NULL
type enum('single','group') NO single
archived enum('1','0') NO 0
einvoicing_tax_rates_id int unsigned YES MUL NULL
accounting_tax_rates_id int unsigned YES MUL NULL
is_system enum('1','0') NO 0
Relationships
References: → accounting_tax_rates.id (via accounting_tax_rates_id), einvoicing_tax_rates.id (via einvoicing_tax_rates_id)
Referenced by: ← tax_to_group.group_id, tax_to_group.tax_id
Sample Data
Loading sample data...

tax_to_group

+
Table Structure (4 columns)
Column Type Null Key Default Extra
group_id int unsigned NO PRI NULL
tax_id int unsigned NO PRI NULL
type enum('net','tax','compound_with_one_previous','compound_with_all_previous') NO net
position int unsigned NO NULL
Relationships
References: → tax.id (via group_id), tax.id (via tax_id)
Sample Data
Loading sample data...

temp

+
Table Structure (7 columns)
Column Type Null Key Default Extra
customer int NO NULL
eft_payment_due varchar(128) NO NULL
debit_order_payment_due varchar(128) NO NULL
suspension_date varchar(128) NO NULL
reminder1 varchar(128) NO NULL
sageone_acc_id varchar(128) NO NULL
inactive_date varchar(128) NO NULL
Sample Data
Loading sample data...

templates

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type varchar(64) NO MUL NULL
title varchar(128) NO NULL
subject varchar(256) YES
description varchar(512) NO NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← templates_values.id
Sample Data
Loading sample data...

templates_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← templates_values.name
Sample Data
Loading sample data...

templates_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → templates.id (via id), templates_fields.name (via name)
Sample Data
Loading sample data...

ticket

+
Table Structure (28 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
reporter_id int unsigned NO 0
reporter_type enum('none','api','admin','customer','incoming') YES none
source enum('api','administration','portal','incoming','widget') YES NULL
customer_id int unsigned NO MUL NULL
incoming_customer_id int unsigned NO MUL NULL
hidden enum('1','0') NO 0
assign_to int unsigned NO NULL
group_id int unsigned YES MUL NULL
status_id int unsigned NO NULL
type_id int unsigned YES MUL NULL
task_id int unsigned YES MUL NULL
subject varchar(256) NO NULL
priority varchar(128) NO NULL
star enum('1','0') NO 0
unread_by_customer enum('1','0') NO NULL
unread_by_admin enum('1','0') NO NULL
closed enum('1','0') NO 0
trash enum('1','0') NO MUL 0
shareable enum('0','1') NO 0
created_at datetime NO MUL NULL
updated_at datetime NO NULL
deleted enum('1','0') NO MUL 0
note text NO NULL
related_account_id int NO 0
related_account_type enum('none','main','sub') NO none
hidden_from_related_account tinyint(1) NO 0
unread_by_related_account tinyint(1) NO 1
Relationships
References: → ticket_groups.id (via group_id), scheduling_task.id (via task_id), ticket_types.id (via type_id)
Referenced by: ← ticket_automation_applied_rules.ticket_id, ticket_history.ticket_id, ticket_labels.id, ticket_messages.ticket_id, ticket_report_list.ticket_id, ticket_values.id
Sample Data
id0reporter_id1reporter_type2source3customer_id4incoming_customer_id5hidden6assign_to7group_id8status_id9type_id10task_id11subject12priority13star14unread_by_customer15unread_by_admin16closed17trash18shareable19created_at20updated_at21deleted22note23related_account_id24related_account_type25hidden_from_related_account26unread_by_related_account27
1155adminadminadministrationadministration00000055111195149514Updated price in plan #27Updated price in plan #27highhigh0011001111002020-10-29 15:09:242020-10-29 15:09:242024-01-29 11:42:022024-01-29 11:42:020000nonenone0011
2255adminadminadministrationadministration000000551111Updated price in plan #27Updated price in plan #27highhigh0011001111002020-10-29 15:14:062020-10-29 15:14:062024-01-29 11:42:022024-01-29 11:42:020000nonenone0011
3331073107customercustomerapiapi310731070000883311Wifi no workWifi no workmediummedium0011001111002020-11-05 15:39:142020-11-05 15:39:142024-01-29 11:42:022024-01-29 11:42:020000nonenone0011

ticket_activity_log

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
model_class varchar(255) NO NULL
log_datetime datetime NO NULL
log_user_id int unsigned YES NULL
log_class enum('log\\models\\LogsAdmins','log\\models\\LogsInternal','log\\models\\LogsApi','log\\models\\LogsPortal') NO log\models\LogsAdmins
log_entry_id int unsigned NO NULL
Sample Data
Loading sample data...

ticket_agent_to_group

+
Table Structure (2 columns)
Column Type Null Key Default Extra
agent_id int unsigned NO PRI NULL
group_id int unsigned NO PRI NULL
Relationships
References: → ticket_agents.admin_id (via agent_id), ticket_groups.id (via group_id)
Sample Data
Loading sample data...

ticket_agents

+
Table Structure (3 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
signature text YES NULL
ticket_scope enum('global','group','restricted','none') YES NULL
Relationships
References: → admins.id (via admin_id)
Referenced by: ← ticket_agent_to_group.agent_id, ticket_canned_response.agent_id, ticket_canned_response_group.agent_id
Sample Data
Loading sample data...

ticket_assignments

+
Table Structure (1 columns)
Column Type Null Key Default Extra
admin_id int unsigned NO PRI NULL
Relationships
References: → admins.id (via admin_id)
Sample Data
Loading sample data...

ticket_automation_applied_rules

+
Table Structure (3 columns)
Column Type Null Key Default Extra
ticket_id int unsigned NO PRI NULL
rule_id int unsigned NO PRI NULL
applied_at datetime NO NULL
Relationships
References: → ticket_automation_rules.id (via rule_id), ticket.id (via ticket_id)
Sample Data
Loading sample data...

ticket_automation_rules

+
Table Structure (18 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
status int unsigned NO NULL
condition enum('all','opened','closed') NO opened
priorities varchar(64) NO
time_passed tinyint unsigned NO NULL
time_unit enum('hours','days','weeks') NO days
recurrently enum('0','1') NO 1
new_status int unsigned YES NULL
new_priority varchar(32) YES NULL
new_state enum('none','close','trash') NO none
notification enum('none','note','reply','mail') NO none
mail_targets varchar(64) NO
mail_target_custom varchar(256) YES NULL
subject varchar(256) NO
template_id int unsigned NO NULL
response_id int unsigned YES NULL
priority int unsigned NO 0
updated_at datetime NO NULL
Relationships
Referenced by: ← ticket_automation_applied_rules.rule_id
Sample Data
Loading sample data...

ticket_automation_rules_to_ticket_group

+
Table Structure (2 columns)
Column Type Null Key Default Extra
rule_id int unsigned NO PRI NULL
ticket_group_id int unsigned NO PRI NULL
Relationships
References: → ticket_groups.id (via ticket_group_id)
Sample Data
Loading sample data...

ticket_canned_response

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
code text YES NULL
canned_group int YES NULL
ticket_group int unsigned YES MUL NULL
agent_id int unsigned YES MUL NULL
visibility varchar(48) NO tickets
deleted enum('0','1') NO 0
Relationships
References: → ticket_agents.admin_id (via agent_id), ticket_groups.id (via ticket_group)
Sample Data
Loading sample data...

ticket_canned_response_group

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
agent_id int unsigned YES MUL NULL
Relationships
References: → ticket_agents.admin_id (via agent_id)
Sample Data
Loading sample data...

ticket_connections

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
connection enum('task','call') YES NULL
connection_id int unsigned NO NULL
ticket_id int unsigned NO NULL
message_id int unsigned NO NULL
Sample Data
Loading sample data...

ticket_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','textarea') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← ticket_values.name
Sample Data
Loading sample data...

ticket_groups

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
description text YES NULL
Relationships
Referenced by: ← ticket.group_id, ticket_agent_to_group.group_id, ticket_automation_rules_to_ticket_group.ticket_group_id, ticket_canned_response.ticket_group
Sample Data
Loading sample data...

ticket_history

+
Table Structure (25 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ticket_id int unsigned NO MUL NULL
meta json YES NULL
is_new_ticket varchar(5) NO MUL NULL VIRTUAL GENERATED
customer_id int unsigned NO NULL
incoming_customer_id int unsigned NO NULL
hidden enum('1','0') NO 0
assign_to int unsigned NO MUL NULL
status_id int unsigned NO MUL NULL
type_id int unsigned YES NULL
subject varchar(256) NO NULL
priority varchar(128) NO NULL
star enum('1','0') NO 0
unread_by_customer enum('1','0') NO NULL
unread_by_admin enum('1','0') NO NULL
closed enum('1','0') NO 0
ticket_deleted enum('1','0') NO 0
ticket_message_id int unsigned YES MUL NULL
ticket_additional_attributes text YES NULL
is_a_send_message enum('1','0') NO 0
datetime datetime NO MUL NULL
admin int unsigned NO NULL
customer int unsigned NO NULL
api int unsigned NO NULL
deleted enum('1','0') NO 0
Relationships
References: → ticket.id (via ticket_id), ticket_messages.id (via ticket_message_id)
Sample Data
Loading sample data...

ticket_labels

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
label_id int unsigned NO PRI NULL
Relationships
References: → ticket.id (via id), labels.id (via label_id)
Sample Data
Loading sample data...

ticket_messages

+
Table Structure (21 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
ticket_id int unsigned NO MUL NULL
customer_id int unsigned NO MUL NULL
incoming_customer_id int unsigned NO NULL
admin_id int unsigned NO MUL NULL
api_id int unsigned NO NULL
source enum('api','administration','portal','incoming','public_form') YES MUL NULL
message_type enum('message','note','change_ticket','link_call','unlink_call') YES NULL
date date NO MUL NULL
time time NO NULL
message longblob YES NULL
is_merged enum('1','0') NO 0
can_be_deleted enum('1','0') NO 1
deleted enum('1','0') NO MUL 0
mail_to text NO NULL
mail_cc text NO NULL
mail_bcc text NO NULL
hide_for_customer enum('1','0') NO 0
author_type enum('admin','customer','system','api') NO system
updated_at datetime YES CURRENT_TIMESTAMP DEFAULT_GENERATED
has_unprocessed_attachments tinyint(1) NO 0
Relationships
References: → ticket.id (via ticket_id)
Referenced by: ← ticket_history.ticket_message_id, ticket_messages_to_files_upload.message_id
Sample Data
Loading sample data...

ticket_messages_to_files_upload

+
Table Structure (2 columns)
Column Type Null Key Default Extra
file_id int unsigned NO PRI NULL
message_id int unsigned NO PRI NULL
Relationships
References: → files_upload.id (via file_id), ticket_messages.id (via message_id)
Sample Data
Loading sample data...

ticket_report_list

+
Table Structure (7 columns)
Column Type Null Key Default Extra
ticket_id int unsigned NO PRI NULL
comment text YES NULL
form enum('0','1') YES NULL
content enum('0','1') YES NULL
timing enum('0','1') YES NULL
feedback enum('0','1') YES NULL
archived enum('0','1') NO 0
Relationships
References: → ticket.id (via ticket_id)
Sample Data
Loading sample data...

ticket_statuses

+
Table Structure (7 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title_for_agent varchar(128) NO NULL
title_for_customer varchar(128) NO NULL
label varchar(128) NO NULL
mark varchar(128) NO NULL
icon varchar(255) YES NULL
view_on_dashboard enum('0','1') YES MUL 0
Sample Data
Loading sample data...

ticket_templates

+
Table Structure (5 columns)
Column Type Null Key Default Extra
type varchar(64) NO PRI NULL
destination_type enum('email','sms') NO PRI email
enabled enum('1','0') NO 0
subject varchar(256) NO NULL
template_id int unsigned NO NULL
Sample Data
Loading sample data...

ticket_types

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
background_color varchar(50) YES NULL
Relationships
Referenced by: ← ticket.type_id
Sample Data
Loading sample data...

ticket_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → ticket.id (via id), ticket_fields.name (via name)
Sample Data
Loading sample data...

ticket_watchers_to_admins

+
Table Structure (2 columns)
Column Type Null Key Default Extra
ticket_id int unsigned NO MUL NULL
admin_id int unsigned NO MUL NULL
Sample Data
Loading sample data...

to_bill_log

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
date date NO NULL
real_date_time datetime NO NULL
max_period_to date YES NULL
transactions_id text YES NULL
invoice_id int YES MUL NULL
request_id int YES NULL
history_id int YES NULL
next_request_before date YES NULL
transactions_sum decimal(19,4) NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

traffic_class

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(64) NO NULL
comment varchar(512) NO NULL
networks text NO NULL
deleted enum('0','1') NO MUL 0
Sample Data
Loading sample data...

traffic_counter

+
Table Structure (4 columns)
Column Type Null Key Default Extra
service_id int unsigned NO PRI NULL
date date NO PRI NULL
up bigint unsigned NO NULL
down bigint unsigned NO NULL
Sample Data
Loading sample data...

trusted_domains

+
Table Structure (2 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
domain varchar(255) NO
Sample Data
Loading sample data...

version

+
Table Structure (2 columns)
Column Type Null Key Default Extra
module varchar(30) NO PRI NULL
version int unsigned NO NULL
Sample Data
Loading sample data...

view_fields_config

+
Table Structure (4 columns)
Column Type Null Key Default Extra
model varchar(128) NO PRI NULL
type enum('main','additional') NO PRI NULL
field_name varchar(255) NO PRI NULL
position smallint NO NULL
Sample Data
Loading sample data...

voice_categories

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
type enum('call','message','data') NO MUL call
title varchar(64) NO NULL
deleted enum('0','1') YES 0
Relationships
Referenced by: ← customer_rates.category_id, provider_rates.category_id
Sample Data
Loading sample data...

voice_devices

+
Table Structure (12 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
title varchar(64) NO NULL
model varchar(128) NO NULL
location_id int unsigned NO MUL NULL
address varchar(128) NO NULL
ip varchar(32) NO NULL
api_login varchar(32) NO NULL
api_password varchar(512) NO NULL
snmp_monitoring enum('0','1') NO 1
snmp_community varchar(32) NO public
authorization_method_id int unsigned NO NULL
deleted enum('0','1') NO MUL 0
Relationships
Referenced by: ← voice_devices_to_partners.voice_device_id, voice_devices_values.id
Sample Data
Loading sample data...

voice_devices_fields

+
Table Structure (23 columns)
Column Type Null Key Default Extra
name varchar(64) NO PRI NULL
module varchar(32) NO NULL
title varchar(64) NO NULL
type enum('string','integer','decimal','numeric','date','datetime','boolean','select','select_multiple','password','file','relation','relation_multiple','add-on','ip','textarea','ipv6') NO string
position int unsigned NO NULL
default_value varchar(64) NO NULL
min_length varchar(12) NO NULL
max_length varchar(12) NO NULL
select_values text NO NULL
decimals tinyint unsigned NO 2
relation_module varchar(64) NO NULL
addon varchar(64) NO NULL
addon_uri varchar(128) NO NULL
addon_input_type enum('','button','text','text_plus_button') NO
deleted enum('0','1') NO MUL 0
show_in_list enum('1','0') NO 0
is_required enum('1','0') NO 0
is_unique enum('1','0') NO 0
is_add enum('1','0') NO 1
searchable enum('1','0') NO 0
readonly enum('1','0') NO 0
hidden enum('1','0') NO 0
disabled enum('1','0') NO 0
Relationships
Referenced by: ← voice_devices_values.name
Sample Data
Loading sample data...

voice_devices_to_partners

+
Table Structure (2 columns)
Column Type Null Key Default Extra
voice_device_id int unsigned NO PRI NULL
partner_id int unsigned NO PRI NULL
Relationships
References: → partners.id (via partner_id), voice_devices.id (via voice_device_id)
Sample Data
Loading sample data...

voice_devices_values

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL
name varchar(64) NO PRI NULL
value text NO NULL
Relationships
References: → voice_devices.id (via id), voice_devices_fields.name (via name)
Sample Data
Loading sample data...

voice_included_pricing

+
Table Structure (9 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariff_id int unsigned NO MUL NULL
type enum('call','message','data') NO call
amount int YES 0
amount_unit enum('b','kb','mb','gb','second','minute','hour','quantity') NO second
categories_ids varchar(512) YES
time_from time NO 00:00:00
time_to time NO 23:59:59
days varchar(56) YES
Relationships
References: → tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

voice_prefixes

+
Table Structure (6 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
prefix varchar(96) NO MUL
destination varchar(128) NO
rate_type enum('call','data','message') NO MUL call
category_id int YES NULL
is_hard enum('0','1') YES 0
Relationships
Referenced by: ← voice_prefixes_cache.pair_id
Sample Data
Loading sample data...

voice_prefixes_cache

+
Table Structure (3 columns)
Column Type Null Key Default Extra
id int unsigned NO MUL NULL auto_increment
haystack varchar(48) NO PRI
pair_id int unsigned NO MUL NULL
Relationships
References: → voice_prefixes.id (via pair_id)
Sample Data
Loading sample data...

voice_pricing_groups

+
Table Structure (10 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
tariff_id int unsigned NO MUL NULL
title varchar(60) YES NULL
type enum('call','message','data') NO call
categories varchar(512) YES
time_from time NO 00:00:00
time_to time NO 23:59:59
days varchar(56) YES NULL
action enum('plus_percent_sell','plus_percent_buy','establishment','tariffication_step','first_tariffication') YES NULL
value varchar(60) NO
Relationships
References: → tariffs_voice.id (via tariff_id)
Sample Data
Loading sample data...

voice_providers

+
Table Structure (5 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
name varchar(128) NO
description varchar(512) NO
is_tax_included enum('0','1') NO 0
calculate_self_price enum('0','1') NO 0
Relationships
Referenced by: ← cdr_import_entry_point.voice_providers_id, provider_rates.provider_id
Sample Data
Loading sample data...

welcome_message

+
Table Structure (4 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
customer_id int unsigned NO MUL NULL
time_change datetime YES NULL
status varchar(255) NO NULL
Relationships
References: → customers.id (via customer_id)
Sample Data
Loading sample data...

wireguard_clients

+
Table Structure (8 columns)
Column Type Null Key Default Extra
id int unsigned NO PRI NULL auto_increment
enabled enum('0','1') NO 1
name varchar(32) NO NULL
ip varchar(32) NO NULL
ip_id int unsigned NO NULL
private_key varchar(255) NO NULL
public_key varchar(255) NO NULL
allow_from text NO NULL
Sample Data
Loading sample data...