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

tbl_group_attributeint8 not null

float8(17, 17) not null

max_accum_balance

float8(17, 17) not nullgroup_id

int8 not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullcreated_date

timestamp not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullcreated_byvarchar(50) not nullmodified_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not null

int8 not nullmodified_ticks

float8(17, 17) not null

used_by_user_id

int8 not null

sub_total

float8(17, 17) not null

assoc_with_account_id

int8 not null

initial_settings_enabledtransacted_byvarchar(50) not null

wc_comment

varchar(255)

tbl_account[table]payment_type

varchar(50)account_id

int8 not nullaccount_type

varchar(10) not nullaccount_namevarchar(255) not nullbalancefloat8(17, 17) not null[table]account_id

int8 not null

restrictedbpchar(1) not null

attrib_value

varchar(255)

overdraftfloat8(17, 17) not nullmodified_ticks

int8 not null

propagate
attrib_namebpchar(1) not nullvarchar(255) not null

tbl_account_transaction[table]account_transaction_id

int8 not nullpinvarchar(50)use_global_overdraft

bpchar(1) not nullnotes

varchar(2000)

deletedbpchar(1) not null

deleted_date

timestamp

created_date

timestamp not nullcreated_byvarchar(50) not nulltransaction_date

timestamp not nullmodified_date

timestamp not nulltransacted_byvarchar(50) not nullmodified_byvarchar(50) not nullaccount_id

int8 not nullparent_id

usage_log_type

varchar(20)account_name_lower

usage_log_id

int8

varchar(255)

sub_name_lower

balancefloat8(17, 17) not nulldisabledvarchar(255)

is_credit

bpchar(1) not nulltransaction_type

varchar(20) not null

ext_device_id

int8

tbl_printer_usage_log[table]printer_usage_log_id

int8 not nullvarchar(255) not nullvarchar(255)

float8(17, 17) not null

txn_comment

int8

sub_nameamountbpchar(1) not nulldisabled_until

timestampcommentsvarchar(20) not nullinvoicingvarchar(20) not null

sub_pinvarchar(50)modified_ticks

int8 not nullusage_date

timestamp not nullusage_daytimestamp not null

tbl_printerused_by_user_id

int8 not null[table]printer_id

charged_to_account_id

int8 not null

int8 not nullserver_namevarchar(255)

printer_namevarchar(255) not null

display_namevarchar(510) not nullusage_cost

float8(17, 17) not nullmethod_namevarchar(128) not nullusage_allowed

payloadvarchar(4000) not null

printer_id

bpchar(1) not null
int8 not null

original_printer_id

int8

job_idvarchar(255)

document_namevarchar(255)client_machinevarchar(255)

total_pages

int4 not null

total_sheets

int4 not null

copiesint4 not null

paper_size

varchar(20) not null

paper_height_mm

int4 not null

tbl_scheduled_report[table]paper_width_mm

int4 not nullscheduled_report_id

int8 not null

printer_language

varchar(50)document_size_kb

int4 not nullvarchar(100)denied_reason

varchar(30)varchar(2000)

duplexbpchar(1) not nullvarchar(30) not null

gray_scalebpchar(1) not nullvarchar(30) not null

printedbpchar(1) not nullvarchar(1000)

cancelled

bpchar(1) not nullcreated_date

timestamp not nullrefundedbpchar(1) not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullcolor_pages_estimateddelivery_methodvarchar(50) not null

job_type

varchar(10)append_datestamp

bpchar(1) not nullinvoicedbpchar(1) not null

assoc_with_account_id

int8 not null

total_color_pages

int4 not nullbpchar(1) not null

job_comment

varchar(255)

protocolvarchar(20)original_usage_costfloat8(17, 17) not nullrefund_statusvarchar(6) not nullrefund_request_id

int8

replayedbpchar(1) not nullsignaturevarchar(50)hardware_check_statusvarchar(6) not null

hardware_check_id

int8

job_uidvarchar(40)archive_path

varchar(30)duplex_pages

int4 not nulloffline_usage

bpchar(1) not null

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 nullvarchar(1000)

created_date

timestamp not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullmodified_ticks
propagatebpchar(1) not nullvarchar(2000) not null

float8(17, 17) not null

item_namevarchar(255) not nullbpchar(1) not null

item_cost

float8(17, 17) not null

deleteddeleted_date

timestamp

disabled

bpchar(1) not nulldisabled_until

timestamp

total_jobs

int4 not null

total_pages

int4 not null

total_sheets

int4 not null

reset_byvarchar(50)reset_date

timestamp

created_date

timestamp not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullcolor_detection_mode

varchar(20) not nulldevice_type

varchar(20) not null

ext_device_function

varchar(30)physical_printer_id

varchar(100)printer_type

varchar(200)serial_number

varchar(100)web_print_enabledcustom1

varchar(50)custom2

varchar(50)custom3

varchar(50)custom4

varchar(50)custom5

varchar(50)custom6

varchar(50)last_usage_date

varchar(100)gcp_enabledbpchar(1) not nullmodified_ticks

int8 not nullserver_uuid

varchar(255)tbl_print_hardware_check[table]

print_hardware_check_id

int8 not nullcheck_date

timestamp not nullstatusvarchar(6) not nullcheck_methodvarchar(20) not nullcheck_message

varchar(255)check_total_pages

int4 not nullcheck_color_pages

int4 not null
int4 not null

orig_color_pages

int4 not nullserver_id

int8 not nullvarchar(255) not nullenabledbpchar(1) not null

deletedbpchar(1) not null

deleted_date

timestamp

server_namevarchar(255) not nullserver_type

varchar(10) not nullserver_statevarchar(20) not null

locationvarchar(200)notesvarchar(2000)

major_version

int4 not null

minor_version

int4 not nullvarchar(20) not null

sync_ticks

int8 not nullcreated_date

timestamp not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullmodified_ticks

int8 not null

display_namevarchar(255) not null

network_address

float8(17, 17) not null

orig_total_pages[table]build_id

timestamp

gcp_printer_id

tbl_server
uuidbpchar(1) not nullbpchar(1) not null
float8(17, 17) not nullvarchar(255)

tbl_audit_log[table]audit_log_id

int8 not nullactionvarchar(20) not null

entity_type

varchar(255) not null

entity_id

timestamp
varchar(50)int8 not null

entity_namevarchar(255) not nullmodified_date

timestamp not nullproperty_namevarchar(255) not null

tbl_net_usage_log[table]previous_value

varchar(1000)

net_usage_log_id

int8 not nullmodified_value

varchar(1000)

usage_date

timestamp not nullmodified_by_id

int8 not nullusage_daytimestamp not nullmodified_by_nameusage_cost

float8(17, 17) not nullhours_usedfloat8(17, 17) not nullmegabytes_received

float8(17, 17) not nullmegabytes_sent

float8(17, 17) not nullcached_megabytes_received

float8(17, 17) not null

tbl_topup_card[table]topup_card_id

int8 not null

tbl_user[table]user_id

int8 not nulluser_namevarchar(50) not nullvarchar(255) not nullbatch_idvarchar(255) not null

external_user_namecard_number

varchar(255) not null

full_namevarchar(255)

timestampemailvarchar(255)

date_loaded

timestamp not nullnotes

varchar(2000)

expiry_date

timestamp not null

total_jobs

int4 not null

float8(17, 17) not null

total_pages

int4 not null

int8

total_sheets

int4 not null

reset_byvarchar(50)reset_date

timestamp[table]deletedint8 not nullvarchar(1000)

modified_ticks

int8 not null

propagate
attrib_namebpchar(1) not nullvarchar(255) not null

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)bpchar(1) not null

deleted_date

timestamp

created_date

timestamp not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not null

department

varchar(200)officevarchar(200)card_number

varchar(100)disabled_printing

bpchar(1) not nulldisabled_printing_until

varchar(50)net_reset_date

timestamp

net_total_megabytes

float8(17, 17) not null

net_total_time_hours

float8(17, 17) not nullbpchar(1) not nulldisabled_net_until

tbl_user_field_history[table]user_field_history_id

int8 not nullinternal

user_id

int8 not null

last_user_activity

field_type

varchar(20) not null

field_value

varchar(200)start_date

timestamp not null

end_datetimestamp not null

tbl_refund_request[table]refund_request_id

int8 not null

request_date

timestamp not nullstatusvarchar(6) not null

request_user_id

int8

request_reason

varchar(1000)

request_amountfloat8(17, 17) not null

response_date

timestamp

timestampbpchar(1) not nulltimestamp

card_number2

varchar(100)secondary_user_namevarchar(50)modified_ticks

int8 not nullvarchar(50)response_reason

varchar(1000)

refunded_amountfloat8(17, 17)

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

timestamp

net_reset_by

disabled_net

response_username

varchar(255) not null

int8 not null

attrib_value

int8 not nullmessagedefault_cost

user_id

printer_group_id

varchar(20) not null

int8 not null

tbl_user_attributeint8 not null

log_level

web_cashier_item_id

used_by_user_id

printer_id

varchar(255)varchar(20) not null"value"[table]server_namecharge_type

date_used

tbl_printer_printer_group

timestamp not null[table]used_by_user_id

int8 not null

log_date

tbl_web_cashier_item

adjustment_applied_byproperty_value

int8 not nullvarchar(2000)

adjustment_applied_date

varchar(100) not null

application_log_id

notes

orig_cost

property_name[table]varchar(255)

orig_color_pages_estimated[table]tbl_application_log

locationcheck_cost

tbl_config

int8 not null

int8 not null

float8(17, 17) not null

tbl_account_attributebpchar(1) not nullmodified_ticks

total_cost

int4bpchar(1) not nullvarchar(50) not null

item_costsequence_next_hi_value

schedule_amountcreated_bytimestamp not nullvarchar(255)varchar(10) not nulltimestamp not nullusage_day

sequence_nameschedule_period

created_date

int4 not null[table]varchar(255) not null

int8 not nulltimestamp not null

tbl_sequences

bpchar(1) not nulluser_id

usage_date

int8 not null

initially_restricted

timestamp not nullvarchar(255) not nullmodified_ticks

bpchar(1) not nullcreated_date

item_namebpchar(1) not null

propagate
attrib_namebpchar(1) not nullvarchar(255) not null

centralized

float8(17, 17) not null

reset_statistics

receipt_num

varchar(100)initial_credit

int8 not null

int4 not null

file_nameint8 not nulluser_group_id

item_index

recipientsmodified_ticks

int8 not null

int8 not null

export_type

varchar(255) not nullaccount_id

web_cashier_order_id

schedule_periodgroup_name[table]int8 not null

data_params

varchar(255)

tbl_user_group

web_cashier_order_id

title

attrib_value

int8 not null[table]varchar(200) not null

int8 not nulluser_idtbl_web_cashier_orderreport_identifiergroup_idallow_accum

int8 not null

int8 not null

int8 not null

int8 not null

web_cashier_order_detail_id

log_idgroup_iduser_account_id[table][table][table][table]tbl_web_cashier_order_detailtbl_job_log_journal

tbl_group

tbl_user_accountmodified_ticks

item_quantity[table]int8 not null
Generated by: SchemaCrawler 10.08.05
Generated on: 09/09/2015 12:39 PM
Database: PostgreSQL 9.2.3
Driver: PostgreSQL Native Driver PostgreSQL 9.3 JDBC4.1 (build 1101)