tbl_web_cashier_order_detail

tbl_account_grouptbl_web_cashier_order

tbl_printer_usage_log

group_id BIGINT(20)tbl_group

property_name VARCHAR(100)tbl_config

web_cashier_order_detail_id BIGINT(20)account_group_id BIGINT(20)

web_cashier_order_id BIGINT(20)printer_usage_log_id BIGINT(20)group_name VARCHAR(255)

property_value TEXT

web_cashier_order_id BIGINT(20)group_id BIGINT(20)receipt_num VARCHAR(255)

usage_date DATETIME

initial_credit DOUBLE

created_date DATETIME

item_index INT(11)account_id BIGINT(20)usage_date DATETIME

usage_day DATETIMEinitially_restricted CHAR(1)created_by VARCHAR(50)item_name VARCHAR(255)

created_date DATETIME

usage_day DATETIME

used_by_user_id BIGINT(20)schedule_period VARCHAR(10)modified_date DATETIME

item_quantity INT(11)created_by VARCHAR(50)used_by_user_id BIGINT(20)charged_to_account_id BIGINT(20)schedule_amount DOUBLE

modified_by VARCHAR(50)item_cost DOUBLE

modified_date DATETIME

assoc_with_account_id BIGINT(20)usage_cost DOUBLE

allow_accum CHAR(1)modified_ticks BIGINT(20)sub_total DOUBLE

modified_by VARCHAR(50)total_cost DOUBLE

usage_allowed CHAR(1)max_accum_balance DOUBLE

propagate CHAR(1)modified_ticks BIGINT(20)transacted_by VARCHAR(50)printer_id BIGINT(20)wc_comment VARCHAR(255)

original_printer_id BIGINT(20)payment_type VARCHAR(50)job_id VARCHAR(255)

reset_statistics CHAR(1)Indexes

Indexes

Indexescreated_date DATETIME

Indexescreated_by VARCHAR(50)document_name VARCHAR(255)

modified_date DATETIME

client_machine VARCHAR(255)

modified_by VARCHAR(50)total_pages INT(11)initial_settings_enabled CHAR(1)modified_ticks BIGINT(20)Indexestbl_printer_printer_groupprinter_id BIGINT(20)printer_group_id BIGINT(20)Indexestbl_web_cashier_item
web_cashier_item_id BIGINT(20)tbl_audit_log
audit_log_id BIGINT(20)item_name VARCHAR(255)

action VARCHAR(20)item_cost DOUBLE

entity_type VARCHAR(255)

Indexes

entity_id BIGINT(20)entity_name VARCHAR(255)
modified_date DATETIME
property_name VARCHAR(255)
previous_value TEXT
modified_value TEXT

tbl_printer_grouptbl_net_usage_log

printer_group_id BIGINT(20)net_usage_log_id BIGINT(20)user_id BIGINT(20)group_name VARCHAR(255)

usage_date DATETIME

attrib_value TEXT

display_name VARCHAR(255)

usage_day DATETIME

modified_ticks BIGINT(20)created_date DATETIME

used_by_user_id BIGINT(20)propagate CHAR(1)created_by VARCHAR(50)modified_date DATETIME
modified_by VARCHAR(50)modified_ticks BIGINT(20)Indexes

usage_cost DOUBLE
hours_used DOUBLE

tbl_user_attributeattrib_name VARCHAR(255)
Indexes

megabytes_received DOUBLE
megabytes_sent DOUBLE
cached_megabytes_received DOUBLE
Indexestbl_scan_action
scan_action_id BIGINT(20)action_type VARCHAR(20)label VARCHAR(255)
target VARCHAR(1000)

tbl_job_log_journal
log_id BIGINT(20)method_name VARCHAR(128)payload VARCHAR(4000)

tbl_notification_subscriber
subscription_id BIGINT(20)email VARCHAR(255)
Indexes

Indexesdeleted CHAR(1)modified_ticks BIGINT(20)created_date DATETIME
created_by VARCHAR(50)tbl_scan_action_attributemodified_date DATETIME

scan_action_id BIGINT(20)modified_by VARCHAR(50)attrib_value TEXT

deleted_date DATETIME

modified_ticks BIGINT(20)Indexesuser_field_history_id BIGINT(20)user_id BIGINT(20)field_type VARCHAR(20)field_value VARCHAR(200)start_date DATETIME
end_date DATETIME
Indexes

total_sheets INT(11)topup_card_id BIGINT(20)copies INT(11)batch_id VARCHAR(255)

paper_size VARCHAR(20)card_number VARCHAR(255)

paper_height_mm INT(11)date_used DATETIME

paper_width_mm INT(11)date_loaded DATETIME

printer_language VARCHAR(50)expiry_date DATETIME

document_size_kb INT(11)value DOUBLE

denied_reason VARCHAR(30)used_by_user_id BIGINT(20)duplex CHAR(1)Indexesgray_scale CHAR(1)tbl_refund_request
refund_request_id BIGINT(20)sequence_name VARCHAR(255)check_date DATETIMErequest_date DATETIME

sequence_next_hi_value INT(11)status VARCHAR(6)status VARCHAR(6)check_method VARCHAR(20)request_user_id BIGINT(20)check_message VARCHAR(255)

request_reason TEXT

check_total_pages INT(11)request_amount DOUBLE

check_color_pages INT(11)response_date DATETIME

check_cost DOUBLE

response_username VARCHAR(50)orig_total_pages INT(11)response_reason TEXT

orig_color_pages INT(11)refunded_amount DOUBLE

orig_color_pages_estimated CHAR(1)amount DOUBLE
balance DOUBLE
txn_comment VARCHAR(255)
is_credit CHAR(1)transaction_type VARCHAR(20)tbl_group_attribute

Indexes

assoc_with_account_id BIGINT(20)full_name VARCHAR(255)

total_color_pages INT(11)email VARCHAR(255)server_id BIGINT(20)color_pages_estimated CHAR(1)notes TEXT

uuid VARCHAR(255)

job_type VARCHAR(10)total_jobs INT(11)enabled CHAR(1)invoiced CHAR(1)total_pages INT(11)deleted CHAR(1)job_comment VARCHAR(255)

total_sheets INT(11)deleted_date DATETIME

protocol VARCHAR(20)reset_by VARCHAR(50)server_name VARCHAR(255)

original_usage_cost DOUBLE

reset_date DATETIME

server_type VARCHAR(10)refund_status VARCHAR(6)deleted CHAR(1)server_state VARCHAR(20)refund_request_id BIGINT(20)deleted_date DATETIME

location VARCHAR(200)replayed CHAR(1)created_date DATETIME

notes TEXT

signature VARCHAR(50)created_by VARCHAR(50)major_version INT(11)hardware_check_status VARCHAR(6)modified_date DATETIME

minor_version INT(11)hardware_check_id BIGINT(20)modified_by VARCHAR(50)build_id VARCHAR(20)job_uid VARCHAR(40)department VARCHAR(200)sync_ticks BIGINT(20)archive_path VARCHAR(30)office VARCHAR(200)created_date DATETIME

duplex_pages INT(11)card_number VARCHAR(100)created_by VARCHAR(50)

offline_usage CHAR(1)disabled_printing CHAR(1)modified_date DATETIME

print_queue_id BIGINT(20)disabled_printing_until DATETIME

tbl_scheduled_report

net_reset_date DATETIME

display_name VARCHAR(255)

net_total_megabytes DOUBLE

network_address VARCHAR(255)

net_total_time_hours DOUBLE

restricted CHAR(1)modified_date DATETIME

overdraft DOUBLE

modified_by VARCHAR(50)pin VARCHAR(50)color_detection_mode VARCHAR(20)use_global_overdraft CHAR(1)device_type VARCHAR(100)notes TEXT

ext_device_function VARCHAR(30)deleted CHAR(1)physical_printer_id VARCHAR(100)deleted_date DATETIME

printer_type VARCHAR(200)created_date DATETIME

serial_number VARCHAR(100)created_by VARCHAR(50)

web_print_enabled CHAR(1)modified_date DATETIME

custom1 VARCHAR(50)modified_by VARCHAR(50)custom2 VARCHAR(50)parent_id BIGINT(20)custom3 VARCHAR(50)account_name_lower VARCHAR(255)

custom4 VARCHAR(50)sub_name VARCHAR(255)

custom5 VARCHAR(50)sub_name_lower VARCHAR(255)

custom6 VARCHAR(50)disabled CHAR(1)last_usage_date DATETIME

disabled_until DATETIME

gcp_printer_id VARCHAR(100)comments VARCHAR(20)gcp_enabled CHAR(1)invoicing VARCHAR(20)sub_pin VARCHAR(50)tbl_notification_settings

tbl_notification_subscription

printer_group_id BIGINT(20)data_params TEXT

threshold INT(11)schedule_period VARCHAR(30)schedule_type VARCHAR(8)export_type VARCHAR(30)enabled CHAR(1)recipients TEXT

max_age_days INT(11)created_date DATETIME

only_send_if_new CHAR(1)Indexes

Indexesmodified_date DATETIME

tbl_printer_attribute

tbl_user_accountprinter_id BIGINT(20)user_account_id BIGINT(20)modified_ticks BIGINT(20)attrib_value TEXT

user_id BIGINT(20)server_uuid VARCHAR(255)

modified_ticks BIGINT(20)account_id BIGINT(20)parent_id BIGINT(20)propagate CHAR(1)created_date DATETIME

attrib_name VARCHAR(255)

created_by VARCHAR(50)Indexesmodified_date DATETIME
modified_by VARCHAR(50)modified_ticks BIGINT(20)Indexestbl_scan_action_groupdisabled_net CHAR(1)disabled_net_until DATETIME

user_id BIGINT(20)user_id BIGINT(20)group_id BIGINT(20)internal CHAR(1)email_address VARCHAR(255)

scan_action_id BIGINT(20)scan_action_id BIGINT(20)server_name VARCHAR(255)

account_id BIGINT(20)last_user_activity DATETIME

email_status VARCHAR(30)modified_ticks BIGINT(20)modified_ticks BIGINT(20)log_level VARCHAR(20)attrib_value VARCHAR(255)

card_number2 VARCHAR(100)verification_sent_time DATETIME

created_date DATETIME

created_date DATETIME

modified_ticks BIGINT(20)secondary_user_name VARCHAR(5…

verification_code VARCHAR(20)created_by VARCHAR(50)created_by VARCHAR(50)propagate CHAR(1)modified_ticks BIGINT(20)modified_date DATETIME

modified_date DATETIMEattrib_name VARCHAR(255)

home_directory VARCHAR(255)application_log_id BIGINT(20)log_date DATETIME

message TEXT
Indexestbl_account_attribute

Indexes

Indexes

Indexestbl_accountbalance DOUBLE

scan_action_group_id BIGINT(20)attrib_name VARCHAR(255)

total_jobs INT(11)created_by VARCHAR(50)tbl_scan_action_user

Indexesdisabled_until DATETIME

attrib_name VARCHAR(255)

scan_action_user_id BIGINT(20)tbl_application_log

modified_ticks BIGINT(20)Indexes

account_name VARCHAR(255)

tbl_user_email_address

Indexesdisabled CHAR(1)modified_by VARCHAR(50)created_date DATETIME

net_reset_by VARCHAR(50)modified_ticks BIGINT(20)deleted_date DATETIME

modified_date DATETIME

propagate CHAR(1)message_template VARCHAR(1000)

Indexesdeleted CHAR(1)created_by VARCHAR(50)account_type VARCHAR(10)title VARCHAR(100)modified_ticks BIGINT(20)default_cost DOUBLE

created_date DATETIME

reset_date DATETIME

notification_settings_id BIGINT(20)centralized CHAR(1)charge_type VARCHAR(20)group_id BIGINT(20)reset_by VARCHAR(50)type_name VARCHAR(64)file_name VARCHAR(100)notes TEXT

user_id BIGINT(20)modified_ticks BIGINT(20)report_identifier VARCHAR(200)append_datestamp CHAR(1)location VARCHAR(255)

attrib_value VARCHAR(255)

id BIGINT(20)delivery_method VARCHAR(50)display_name TEXT

tbl_user_groupuser_group_id BIGINT(20)account_id BIGINT(20)

id BIGINT(20)modified_by VARCHAR(50)printer_name VARCHAR(255)

total_sheets INT(11)scheduled_report_id BIGINT(20)created_by VARCHAR(50)server_name VARCHAR(255)

total_pages INT(11)tbl_userexternal_user_name VARCHAR(255)tbl_printerprinter_id BIGINT(20)group_id BIGINT(20)Indexesrefunded CHAR(1)Indexes

usage_log_id BIGINT(20)ext_device_id BIGINT(20)Indexesuser_name VARCHAR(50)modified_by VARCHAR(50)transaction_date DATETIME

usage_log_type VARCHAR(20)Indexesadjustment_applied_by VARCHAR(50)cancelled CHAR(1)tbl_server

account_transaction_id BIGINT(20)account_id BIGINT(20)adjustment_applied_date DATETIME

user_id BIGINT(20)Indexestbl_account_transaction

transacted_by VARCHAR(50)orig_cost DOUBLE

printed CHAR(1)modified_by_name VARCHAR(255)tbl_sequencesuser_email_address_id BIGINT(20)propagate CHAR(1)tbl_user_field_history

modified_by_id BIGINT(20)tbl_topup_card

tbl_print_hardware_checkprint_hardware_check_id BIGINT(20)modified_by VARCHAR(50)Indexesmodified_by VARCHAR(50)Indexes

Indexesmodified_ticks BIGINT(20)Indexes