tbl_scan_action_user

tbl_web_cashier_order_detail

tbl_scan_action_group

scan_action_user_id BIGINT(20)

web_cashier_order_detail_id BIGINT(20)scan_action_group_id BIGINT(20)user_group_id BIGINT(20)account_id BIGINT(20)user_account_id BIGINT(20)group_id BIGINT(20)printer_group_id BIGINT(20)topup_card_id BIGINT(20)account_transaction_id BIGINT(20)user_id BIGINT(20)

web_cashier_order_id BIGINT(20)group_id BIGINT(20)user_id BIGINT(20)account_type VARCHAR(10)user_id BIGINT(20)group_name VARCHAR(255)group_name VARCHAR(255)batch_id VARCHAR(255)transaction_date DATETIME

scan_action_id BIGINT(20)item_index INT(11)scan_action_id BIGINT(20)group_id BIGINT(20)account_name VARCHAR(255)

account_id BIGINT(20)initial_credit DOUBLE

display_name VARCHAR(255)

card_number VARCHAR(255)transacted_by VARCHAR(50)modified_ticks BIGINT(20)item_name VARCHAR(255)

modified_ticks BIGINT(20)created_date DATETIME

balance DOUBLE

created_date DATETIME

initially_restricted CHAR(1)created_date DATETIME

date_used DATETIME

account_id BIGINT(20)created_date DATETIME

item_quantity INT(11)created_date DATETIMEcreated_by VARCHAR(50)restricted CHAR(1)created_by VARCHAR(50)schedule_period VARCHAR(10)created_by VARCHAR(50)date_loaded DATETIME

usage_log_type VARCHAR(20)created_by VARCHAR(50)item_cost DOUBLE

created_by VARCHAR(50)modified_date DATETIME

overdraft DOUBLE

modified_date DATETIME

schedule_amount DOUBLE

modified_date DATETIME

expiry_date DATETIME

usage_log_id BIGINT(20)modified_date DATETIME

sub_total DOUBLE

modified_date DATETIME

modified_by VARCHAR(50)pin VARCHAR(50)modified_by VARCHAR(50)allow_accum CHAR(1)modified_by VARCHAR(50)value DOUBLE

amount DOUBLE

modified_by VARCHAR(50)modified_ticks BIGINT(20)use_global_overdraft CHAR(1)modified_ticks BIGINT(20)max_accum_balance DOUBLE

modified_ticks BIGINT(20)used_by_user_id BIGINT(20)balance DOUBLE

modified_by VARCHAR(50)Indexes

Indexes

Indexestbl_printertbl_audit_log

tbl_server

tbl_user_groupIndexestbl_accountnotes TEXT

tbl_user_accountIndexestbl_group

reset_statistics CHAR(1)deleted CHAR(1)created_date DATETIME

deleted_date DATETIME

created_by VARCHAR(50)tbl_printer_groupIndexestbl_topup_card

Indexestbl_account_transaction

txn_comment VARCHAR(255)
is_credit CHAR(1)transaction_type VARCHAR(20)tbl_printer_usage_log

created_date DATETIME

tbl_scheduled_report

modified_date DATETIME

tbl_web_cashier_order

tbl_userext_device_id BIGINT(20)Indexes

printer_id BIGINT(20)audit_log_id BIGINT(20)server_id BIGINT(20)printer_usage_log_id BIGINT(20)created_by VARCHAR(50)scheduled_report_id BIGINT(20)modified_by VARCHAR(50)

web_cashier_order_id BIGINT(20)user_id BIGINT(20)server_name VARCHAR(255)

action VARCHAR(20)uuid VARCHAR(255)

usage_date DATETIME

modified_date DATETIME

report_identifier VARCHAR(200)

initial_settings_enabled CHAR(1)receipt_num VARCHAR(255)

user_name VARCHAR(50)printer_name VARCHAR(255)

entity_type VARCHAR(255)

enabled CHAR(1)usage_day DATETIME

modified_by VARCHAR(50)title VARCHAR(100)modified_ticks BIGINT(20)usage_date DATETIME

external_user_name VARCHAR(255)

display_name TEXT

entity_id BIGINT(20)deleted CHAR(1)used_by_user_id BIGINT(20)parent_id BIGINT(20)data_params TEXT

usage_day DATETIME

full_name VARCHAR(255)

location VARCHAR(255)

entity_name VARCHAR(255)

deleted_date DATETIME

charged_to_account_id BIGINT(20)account_name_lower VARCHAR(255)schedule_period VARCHAR(30)used_by_user_id BIGINT(20)email VARCHAR(255)

notes TEXT

modified_date DATETIME

server_name VARCHAR(255)

usage_cost DOUBLE

sub_name VARCHAR(255)

export_type VARCHAR(30)assoc_with_account_id BIGINT(20)notes TEXT

charge_type VARCHAR(20)property_name VARCHAR(255)server_type VARCHAR(10)usage_allowed CHAR(1)sub_name_lower VARCHAR(255)

recipients TEXT

total_cost DOUBLE

total_jobs INT(11)default_cost DOUBLE

previous_value TEXT

server_state VARCHAR(20)printer_id BIGINT(20)disabled CHAR(1)created_date DATETIME

transacted_by VARCHAR(50)total_pages INT(11)deleted CHAR(1)modified_value TEXT

location VARCHAR(200)

job_id VARCHAR(255)

disabled_until DATETIME

created_by VARCHAR(50)wc_comment VARCHAR(255)

total_sheets INT(11)deleted_date DATETIME

modified_by_id BIGINT(20)notes TEXT

document_name VARCHAR(255)comments VARCHAR(20)modified_date DATETIME

payment_type VARCHAR(50)reset_by VARCHAR(50)disabled CHAR(1)modified_by_name VARCHAR(255)major_version INT(11)client_machine VARCHAR(255)

invoicing VARCHAR(20)modified_by VARCHAR(50)minor_version INT(11)total_pages INT(11)sub_pin VARCHAR(50)delivery_method VARCHAR(50)tbl_refund_request

modified_ticks BIGINT(20)append_datestamp CHAR(1)refund_request_id BIGINT(20)property_name VARCHAR(100)deleted_date DATETIME

log_id BIGINT(20)method_name VARCHAR(128)disabled_until DATETIME

Indexestbl_account_groupIndexes

Indexestbl_config

reset_date DATETIME
deleted CHAR(1)total_jobs INT(11)account_group_id BIGINT(20)build_id VARCHAR(20)total_sheets INT(11)total_pages INT(11)group_id BIGINT(20)sync_ticks BIGINT(20)copies INT(11)file_name VARCHAR(100)request_date DATETIME

property_value TEXT

created_date DATETIME

total_sheets INT(11)account_id BIGINT(20)created_date DATETIME

paper_size VARCHAR(20)centralized CHAR(1)status VARCHAR(6)created_date DATETIME

created_by VARCHAR(50)reset_by VARCHAR(50)created_date DATETIME

created_by VARCHAR(50)paper_height_mm INT(11)modified_ticks BIGINT(20)request_user_id BIGINT(20)created_by VARCHAR(50)modified_date DATETIME

reset_date DATETIME

created_by VARCHAR(50)modified_date DATETIME

paper_width_mm INT(11)request_reason TEXT

modified_date DATETIME

modified_by VARCHAR(50)created_date DATETIME

modified_date DATETIME

modified_by VARCHAR(50)printer_language VARCHAR(50)request_amount DOUBLE

modified_by VARCHAR(50)department VARCHAR(200)created_by VARCHAR(50)modified_by VARCHAR(50)modified_ticks BIGINT(20)document_size_kb INT(11)response_date DATETIME

modified_ticks BIGINT(20)office VARCHAR(200)modified_date DATETIMEmodified_ticks BIGINT(20)display_name VARCHAR(255)

denied_reason VARCHAR(30)response_username VARCHAR(50)propagate CHAR(1)card_number VARCHAR(100)network_address VARCHAR(255)

duplex CHAR(1)response_reason TEXT

gray_scale CHAR(1)refunded_amount DOUBLE

modified_by VARCHAR(50)Indexes

Indexescolor_detection_mode VARCHAR(20)device_type VARCHAR(20)Indexes

Indexes

Indexes

net_reset_by VARCHAR(50)tbl_user_field_history

tbl_scan_action

cancelled CHAR(1)tbl_net_usage_log

physical_printer_id VARCHAR(100)user_field_history_id BIGINT(20)scan_action_id BIGINT(20)refunded CHAR(1)net_usage_log_id BIGINT(20)user_id BIGINT(20)group_id BIGINT(20)scan_action_id BIGINT(20)net_total_megabytes DOUBLE

print_hardware_check_id BIGINT(20)printer_type VARCHAR(200)user_id BIGINT(20)action_type VARCHAR(20)assoc_with_account_id BIGINT(20)usage_date DATETIME

attrib_value TEXT

attrib_value VARCHAR(255)

attrib_value TEXT

net_total_time_hours DOUBLE

check_date DATETIME

serial_number VARCHAR(100)field_type VARCHAR(20)label VARCHAR(255)

total_color_pages INT(11)usage_day DATETIME

attrib_name VARCHAR(255)

attrib_name VARCHAR(255)

modified_ticks BIGINT(20)disabled_net CHAR(1)status VARCHAR(6)web_print_enabled CHAR(1)field_value VARCHAR(200)target VARCHAR(1000)

color_pages_estimated CHAR(1)used_by_user_id BIGINT(20)modified_ticks BIGINT(20)modified_ticks BIGINT(20)propagate CHAR(1)disabled_net_until DATETIME

check_method VARCHAR(20)custom1 VARCHAR(50)start_date DATETIME

deleted CHAR(1)job_type VARCHAR(10)usage_cost DOUBLE

propagate CHAR(1)propagate CHAR(1)attrib_name VARCHAR(255)internal CHAR(1)check_message VARCHAR(255)

custom2 VARCHAR(50)

end_date DATETIME

modified_ticks BIGINT(20)invoiced CHAR(1)hours_used DOUBLE

last_user_activity DATETIME

check_total_pages INT(11)Indexes

Indexescreated_date DATETIME
created_by VARCHAR(50)14 more...

Indexesmodified_date DATETIME

Indexestbl_group_attributedisabled_printing CHAR(1)ext_device_function VARCHAR(30)

9 more...

tbl_user_attribute

payload VARCHAR(4000)
Indexesdisabled_printing_until DATETIME

Indexes

printed CHAR(1)tbl_job_log_journal

Indexestbl_scan_action_attribute

Indexes

megabytes_received DOUBLE

4 more...

Indexes

megabytes_sent DOUBLE
cached_megabytes_received DOUBLE

tbl_printer_printer_groupIndexestbl_account_attributetbl_application_log

tbl_web_cashier_item

tbl_user_email_address

printer_id BIGINT(20)sequence_name VARCHAR(255)

account_id BIGINT(20)application_log_id BIGINT(20)

web_cashier_item_id BIGINT(20)user_email_address_id BIGINT(20)attrib_value TEXT

printer_group_id BIGINT(20)sequence_next_hi_value INT(11)attrib_value VARCHAR(255)

log_date DATETIME

item_name VARCHAR(255)

user_id BIGINT(20)attrib_name VARCHAR(255)server_name VARCHAR(255)

item_cost DOUBLE

email_address VARCHAR(255)

modified_ticks BIGINT(20)modified_ticks BIGINT(20)log_level VARCHAR(20)propagate CHAR(1)propagate CHAR(1)message TEXT

Indexes

Indexescheck_cost DOUBLE

orig_color_pages_estimated CHAR(1)tbl_sequences

printer_id BIGINT(20)attrib_name VARCHAR(255)check_color_pages INT(11)orig_color_pages INT(11)deleted_date DATETIME

tbl_printer_attribute

tbl_print_hardware_check

orig_total_pages INT(11)Indexesmodified_by VARCHAR(50)net_reset_date DATETIME

Indexes

Indexes

Indexesemail_status VARCHAR(30)verification_sent_time DATETIME
verification_code VARCHAR(20)Indexesorig_cost DOUBLE
adjustment_applied_date DATETIME
adjustment_applied_by VARCHAR(50)Indexes