vw_user_print_logs
user_iduser_nameuser_full_nameprinter_server_nameprinter_nameprinter_display_nameprinter_location
printer_usage_log_id
usage_date
usage_day
used_by_user_id
charged_to_account_id
usage_cost
usage_allowed
printer_id
original_printer_id
job_iddocument_nameclient_machine
total_pages
total_sheets
copiespaper_size
paper_height_mm
paper_width_mm
printer_language
document_size_kb
denied_reason
duplexgray_scale
printedcancelledrefundedassoc_with_account_id
total_color_pages
color_pages_estimatedjob_type
invoiced
job_commentprotocol
original_usage_cost
refund_status
refund_request_id
replayedsignature
hardware_check_status
hardware_check_id
job_uidarchive_path
duplex_pages
offline_usage
print_queue_id[view]
int8
varchar(50)varchar(255)varchar(255)varchar(255)varchar(510)varchar(255)
int8
timestamp
timestamp
int8
int8
float8(17, 17)bpchar(1)int8
int8
varchar(255)varchar(255)varchar(255)
int4
int4
int4
varchar(20)
int4
int4
varchar(50)int4varchar(30)bpchar(1)bpchar(1)bpchar(1)bpchar(1)bpchar(1)int8
int4
bpchar(1)varchar(10)bpchar(1)varchar(255)varchar(20)float8(17, 17)varchar(6)int8bpchar(1)varchar(50)varchar(6)int8varchar(40)varchar(30)int4bpchar(1)int8

tbl_web_cashier_item[table]web_cashier_item_id int8 not null
item_namevarchar(255) not null
item_cost
float8(17, 17) not null
tbl_server
server_id
uuid
enableddeleteddeleted_date
server_nameserver_type
server_state
locationnotes
major_version
minor_version
build_id
sync_ticks
created_datecreated_bymodified_date
modified_bymodified_ticks
display_namenetwork_address
patch_version[table]int8 not nullvarchar(255) not nullbpchar(1) not nullbpchar(1) not nulltimestamp
varchar(255) not nullvarchar(10) not nullvarchar(20) not nullvarchar(200)varchar(2000)
int4 not null
int4 not nullvarchar(20) not null
int8 not nulltimestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not null
int8 not nullvarchar(255) not nullvarchar(255)
int8

tbl_sequences[table]sequence_namevarchar(255)
sequence_next_hi_value int4
tbl_scheduled_reportscheduled_report_id
report_identifier
title
data_params
schedule_period
export_type
recipients
created_datecreated_bymodified_date
modified_by
delivery_method
append_datestamp
file_name
centralized
modified_ticks
custom_report_identifier
localetbl_account_attribute[table]account_id
int8 not null
attrib_value
varchar(255)
modified_ticks
int8 not null
propagatebpchar(1) not null
attrib_namevarchar(255) not null

tbl_accountaccount_id
account_type
account_namebalance
restricted
overdraftpin
use_global_overdraft
notes
deleteddeleted_datecreated_datecreated_bymodified_date
modified_by
parent_id
account_name_lower
sub_name
sub_name_lower
disabled
disabled_untilcomments
invoicing
sub_pinmodified_ticks[table]int8 not nullvarchar(10) not nullvarchar(255) not null
float8(17, 17) not nullbpchar(1) not null
float8(17, 17) not nullvarchar(50)bpchar(1) not nullvarchar(2000)
bpchar(1) not nulltimestamp
timestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not null
int8
varchar(255) not nullvarchar(255)varchar(255)bpchar(1) not nulltimestamp
varchar(20) not nullvarchar(20) not nullvarchar(50)int8 not null

tbl_account_group[table]account_group_id int8 not nullgroup_id
int8 not nullaccount_id
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not nullmodified_ticks
int8 not null
tbl_web_cashier_order[table]web_cashier_order_id int8 not nullreceipt_num
varchar(255) not nullusage_date
timestamp not nullusage_daytimestamp not null
used_by_user_id
int8 not null
assoc_with_account_id int8 not nulltotal_cost
float8(17, 17) not nulltransacted_byvarchar(50) not null
wc_comment
varchar(255)
payment_type
varchar(50)tbl_job_log_journal[table]log_idint8 not nullmethod_namevarchar(128) not null
tbl_web_cashier_order_detail[table]web_cashier_order_detail_id int8 not null
web_cashier_order_id
int8 not null
item_index
int4 not null
item_namevarchar(255) not null
item_quantity
int4 not null
item_cost
float8(17, 17) not null
sub_total
float8(17, 17) not null

int8 not nullvarchar(200) not nullvarchar(100)varchar(2000)
varchar(30) not nullvarchar(30) not nullvarchar(1000)
timestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not nullvarchar(50) not nullbpchar(1) not nullvarchar(100)bpchar(1) not null
int8 not nullvarchar(200)varchar(16)tbl_job_log_journal_payload[table]log_idint8 not nullsegment
int4 not null
payloadvarchar(4000)

tbl_ha_active_server[table]activevarchar(256)last_update
timestamp

tbl_databasechangeloglock[table]id
int4 not null
lockedbool not null
lockgranted
timestamplockedby
varchar(255)tbl_group_attribute[table]group_id
int8 not null
attrib_value
varchar(255)
modified_ticks
int8 not null
propagatebpchar(1) not null
attrib_namevarchar(255) not null
tbl_groupgroup_id
group_nameinitial_credit
initially_restrictedschedule_period
schedule_amountallow_accum
max_accum_balance
reset_statistics
created_datecreated_bymodified_date
modified_by
initial_settings_enabledmodified_ticks[table][table]int8 not nullvarchar(255) not null
float8(17, 17) not nullbpchar(1) not nullvarchar(10) not null
float8(17, 17) not nullbpchar(1) not null
float8(17, 17) not nullbpchar(1) not nulltimestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not nullbpchar(1) not null
int8 not null

tbl_scan_action[table]scan_action_id int8 not nullaction_type
varchar(20) not nulllabelvarchar(255) not nulltargetvarchar(1000) not null
deletedbpchar(1) not nullmodified_ticks
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not null
deleted_datetimestamp

tbl_user_account[table]user_account_id int8 not nulluser_id
int8 not nullaccount_id
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not nullmodified_ticks
int8 not null
tbl_scan_action_group[table]scan_action_group_id int8 not nullgroup_id
int8 not null
scan_action_id
int8 not nullmodified_ticks
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not null
tbl_scan_action_attribute[table]scan_action_id
int8 not null
attrib_value
varchar(1000)
modified_ticks
int8 not null
propagatebpchar(1) not null
attrib_namevarchar(255) not null
tbl_user_group[table]user_group_id int8 not nulluser_id
int8 not nullgroup_id
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date timestamp not nullmodified_byvarchar(50) not nullmodified_ticks int8 not null
tbl_scan_action_user[table]scan_action_user_id int8 not nulluser_id
int8 not nullscan_action_id
int8 not nullmodified_ticks
int8 not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not null

tbl_printerprinter_id
server_nameprinter_namedisplay_namelocationnotes
charge_type
default_cost
deleteddeleted_date
disabled
disabled_until
total_jobs
total_pages
total_sheets
reset_by
reset_datecreated_datecreated_bymodified_date
modified_bycolor_detection_mode
device_type
ext_device_function
physical_printer_id
printer_type
serial_number
web_print_enabledcustom1
custom2
custom3
custom4
custom5
custom6
last_usage_date
gcp_printer_id
gcp_enabledmodified_ticks
server_uuid
parent_id

tbl_useruser_iduser_nameexternal_user_namefull_name
email
notes
total_jobs
total_pages
total_sheets
reset_by
reset_datedeleteddeleted_datecreated_datecreated_bymodified_date
modified_by
department
officecard_number
disabled_printing
disabled_printing_until
net_reset_by
net_reset_date
net_total_megabytes
net_total_time_hours
disabled_net
disabled_net_untilinternal
last_user_activity
card_number2
secondary_user_name
modified_ticks
home_directory
primary_user_source_type
secondary_user_source_type
secondary_external_user_nametbl_account_transaction[table]account_transaction_id int8 not nulltransaction_date
timestamp not nulltransacted_byvarchar(50) not nullaccount_id
int8 not nullusage_log_type
varchar(20)usage_log_id
int8
amountfloat8(17, 17) not nullbalancefloat8(17, 17) not null
txn_comment
varchar(255)
is_credit
bpchar(1) not nulltransaction_type
varchar(20) not null
ext_device_id
int8

tbl_databasechangelog[table]idvarchar(255) not nullauthorvarchar(255) not null
filenamevarchar(255) not null
dateexecuted
timestamp not nullorderexecuted
int4 not null
exectype
varchar(10) not null
md5sumvarchar(35)description
varchar(255)comments
varchar(255)
tagvarchar(255)liquibasevarchar(20)contexts
varchar(255)labelsvarchar(255)
deployment_id
varchar(10)[table]int8 not nullvarchar(50) not nullvarchar(255) not nullvarchar(255)varchar(255)varchar(2000)
int4 not null
int4 not null
int4 not nullvarchar(50)timestampbpchar(1) not nulltimestamp
timestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not nullvarchar(200)varchar(200)varchar(100)bpchar(1) not nulltimestamp
varchar(50)timestamp
float8(17, 17) not null
float8(17, 17) not nullbpchar(1) not nulltimestampbpchar(1) not nulltimestamp
varchar(100)varchar(50)int8 not nullvarchar(255)varchar(30)varchar(30)varchar(255)[table]int8 not nullvarchar(255)varchar(255) not nullvarchar(510) not nullvarchar(255)varchar(2000)
varchar(20) not null
float8(17, 17) not nullbpchar(1) not nulltimestampbpchar(1) not nulltimestamp
int4 not null
int4 not null
int4 not nullvarchar(50)timestamp
timestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not nullvarchar(20) not nullvarchar(100) not nullvarchar(30)varchar(100)varchar(200)varchar(100)bpchar(1) not nullvarchar(50)varchar(50)varchar(50)varchar(50)varchar(50)varchar(50)timestamp
varchar(100)bpchar(1) not null
int8 not nullvarchar(255)
int8

tbl_user_email_address[table]user_email_address_id int8 not nulluser_id
int8
email_address
varchar(255) not nullemail_statusvarchar(30) not nullverification_sent_time
timestamp
verification_code
varchar(20)tbl_printer_usage_log
printer_usage_log_id
usage_date
usage_day
used_by_user_id
charged_to_account_id
usage_cost
usage_allowed
printer_id
original_printer_id
job_iddocument_nameclient_machine
total_pages
total_sheets
copiespaper_size
paper_height_mm
paper_width_mm
printer_language
document_size_kb
denied_reason
duplexgray_scale
printedcancelledrefundedassoc_with_account_id
total_color_pages
color_pages_estimatedjob_type
invoiced
job_comment
protocoloriginal_usage_cost
refund_status
refund_request_id
replayedsignature
hardware_check_status
hardware_check_id
job_uidarchive_path
duplex_pages
offline_usage
print_queue_id[table]int8 not nulltimestamp not nulltimestamp not null
int8 not null
int8 not null
float8(17, 17) not nullbpchar(1) not null
int8 not null
int8
varchar(255)varchar(255)varchar(255)
int4 not null
int4 not null
int4 not nullvarchar(20) not null
int4 not null
int4 not nullvarchar(50)int4 not nullvarchar(30)bpchar(1) not nullbpchar(1) not nullbpchar(1) not nullbpchar(1) not nullbpchar(1) not null
int8 not null
int4 not nullbpchar(1) not nullvarchar(10)bpchar(1) not nullvarchar(255)varchar(20)float8(17, 17) not nullvarchar(6) not null
int8
bpchar(1) not nullvarchar(50)varchar(6) not null
int8
varchar(40)varchar(30)int4 not nullbpchar(1) not null
int8

tbl_printer_attribute[table]printer_id
int8 not null
attrib_value
varchar(1000)
modified_ticks
int8 not null
propagatebpchar(1) not null
attrib_namevarchar(255) not null

tbl_config
property_nameproperty_value
created_datecreated_bymodified_date
modified_bymodified_ticks
propagate[table]varchar(100) not nullvarchar(1000)
timestamp not nullvarchar(50) not nulltimestamp not nullvarchar(50) not null
int8 not nullbpchar(1) not null

tbl_audit_log
audit_log_id
actionentity_type
entity_id
entity_name
modified_date
property_nameprevious_value
modified_value
modified_by_id
modified_by_name[table]int8 not nullvarchar(20) not nullvarchar(255) not null
int8 not nullvarchar(255) not nulltimestamp not nullvarchar(255) not nullvarchar(1000)
varchar(1000)
int8 not nullvarchar(255) not null

tbl_user_field_history[table]user_field_history_id int8 not nulluser_id
int8 not null
field_type
varchar(20) not null
field_value
varchar(200)start_date
timestamp not null
end_datetimestamp not null
tbl_refund_request
refund_request_id
request_date
statusrequest_user_id
request_reason
request_amount
response_date
response_username
response_reason
refunded_amount[table]int8 not nulltimestamp not nullvarchar(6) not null
int8
varchar(1000)
float8(17, 17) not nulltimestamp
varchar(50)varchar(1000)
float8(17, 17)

tbl_net_usage_log
net_usage_log_id
usage_date
usage_day
used_by_user_id
usage_cost
hours_usedmegabytes_received
megabytes_sent
cached_megabytes_received
tbl_topup_card
topup_card_idbatch_id
card_number
date_used
date_loaded
expiry_date"value"used_by_user_id[table]int8 not nulltimestamp not nulltimestamp not null
int8 not null
float8(17, 17) not null
float8(17, 17) not null
float8(17, 17) not null
float8(17, 17) not null
float8(17, 17) not null[table]int8 not nullvarchar(255) not nullvarchar(255) not nulltimestamp
timestamp not nulltimestamp not null
float8(17, 17) not null
int8

tbl_printer_printer_group[table]printer_id
int8 not null
printer_group_id
int8 not null

tbl_user_attribute[table]user_id
int8 not null
attrib_value
varchar(1000)
modified_ticks
int8 not null
propagatebpchar(1) not null
attrib_namevarchar(255) not null
tbl_print_hardware_checkprint_hardware_check_id
check_date
statuscheck_method
check_message
check_total_pages
check_color_pages
check_cost
orig_total_pages
orig_color_pages
orig_color_pages_estimatedorig_costadjustment_applied_date
adjustment_applied_by[table]int8 not nulltimestamp not nullvarchar(6) not nullvarchar(20) not nullvarchar(255)
int4 not null
int4 not null
float8(17, 17) not null
int4 not null
int4 not nullbpchar(1) not null
float8(17, 17) not nulltimestamp
varchar(50)tbl_notification_settings[table]id
int8 not null
type_namevarchar(64) not nullmessage_templatevarchar(1000)
thresholdint4
max_age_days
int4
only_send_if_new
bpchar(1)schedule_type
varchar(8)enabledbpchar(1) not null
tbl_printer_group[table]printer_group_id int8 not nullgroup_namevarchar(255) not null
display_namevarchar(255) not nullcreated_date
timestamp not nullcreated_byvarchar(50) not nullmodified_date
timestamp not nullmodified_byvarchar(50) not nullmodified_ticks
int8 not null

tbl_application_log[table]application_log_id int8 not null
log_datetimestamp not nullserver_namevarchar(255)log_levelvarchar(20) not nullmessagevarchar(2000) not null

tbl_notification_subscription[table]id
int8 not null
notification_settings_id
int8 not null
printer_group_id
int8

tbl_notification_subscriber[table]subscription_id
int8 not nullemailvarchar(255) not nullgenerated by SchemaCrawler 16.19.7
generated on 2023-07-05 07:04:19