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

initially_restrictedbpchar(1) not nullvarchar(255) not nullschedule_periodvarchar(10) not nullschedule_amountfloat8(17, 17) not nullcreated_date

timestamp not nullcreated_byvarchar(50) 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 null

int4 not nullusage_daytimestamp not nullmodified_ticks

item_cost

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 nullvarchar(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 nullaccount_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 null

tbl_scheduled_report[table]created_byvarchar(50) not nullscheduled_report_id

int8 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

int8

disabled

bpchar(1) not nulldisabled_until

timestamp

modified_byvarchar(50) not null

int8

sub_pinvarchar(50)delivery_methodvarchar(50) not nullmodified_ticks

int8 not nullappend_datestamp

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

float8(17, 17) not nullbpchar(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 nullvarchar(20) not null

paper_height_mm

int4 not null

paper_width_mm

int4 not null

printer_language

varchar(50)document_size_kb

int4 not nulldenied_reason

varchar(30)duplexbpchar(1) not null

gray_scalebpchar(1) not null

printedbpchar(1) not nullcancelled

bpchar(1) not nullrefundedbpchar(1) not null

assoc_with_account_id

int8 not null

total_color_pages

int4 not nullbpchar(1) not null

job_type

varchar(10)invoicedbpchar(1) not null

job_comment

varchar(255)

protocolvarchar(20)float8(17, 17) not nullvarchar(6) not nullrefund_request_id

int8

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

hardware_check_id

int8

job_uidvarchar(40)archive_path

varchar(30)duplex_pages

int4 not nulloffline_usage

bpchar(1) not null

item_namevarchar(255) not null

tbl_printer_attributeitem_cost

float8(17, 17) not null

printer_id

int8 not null

attrib_value

varchar(1000)[table]modified_ticks

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

locationvarchar(255)notes

varchar(2000)

charge_typevarchar(20) not nulldefault_cost

float8(17, 17) not null

deleteddeleted_date
disabledbpchar(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

varchar(4000) not nullvarchar(50) not nullcolor_detection_mode

varchar(20) not nulldevice_type

varchar(20) not null

tbl_server

ext_device_function

varchar(30)[table]server_id

physical_printer_id

varchar(100)int8 not null

printer_type

varchar(200)serial_number

varchar(100)web_print_enabled

uuidbpchar(1) not nullcustom1

varchar(50)custom2varchar(50)custom3

varchar(50)custom4

varchar(50)custom5

varchar(50)custom6

varchar(50)last_usage_date

timestamp

gcp_printer_id

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 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)notes

varchar(2000)

major_version

int4 not null

minor_version

int4 not nullbuild_idvarchar(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

varchar(255)tbl_sequences[table]sequence_namevarchar(255)

float8(17, 17) not null

orig_total_pages

int4 not null

orig_color_pages

int4 not nullbpchar(1) not nullsequence_next_hi_value

float8(17, 17) not nulladjustment_applied_date

timestamp

adjustment_applied_byvarchar(50)modified_date

timestamp not null

net_usage_log_id

int8 not nullmodified_byvarchar(50) not nullusage_date

timestamp not null

int8 not nullusage_daytimestamp not null

used_by_user_id
usage_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 nulltotal_pages

int4 not null

int8

total_sheets

int4 not null

reset_byvarchar(50)reset_date

timestamp"value"used_by_user_id

tbl_user_attribute[table]user_id

deletedint8 not null

attrib_value

varchar(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
disabled_printing_until
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[table]user_field_history_id

int8 not nullinternal

user_id

int8 not null

last_user_activity

varchar(20) not null

field_valuevarchar(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
varchar(50)tbl_user_field_history

field_typebpchar(1) not null

net_reset_by

disabled_net

response_username

int4

int8 not null

date_used

int8 not null

payloadmodified_by[table]printer_group_id

varchar(128) not nulltimestamp not null

tbl_net_usage_log

int8 not nullmethod_name

modified_date

varchar(50) not null

printer_id

int8 not nullvarchar(50) not nullcreated_by[table][table]created_bytimestamp not null

tbl_printer_printer_group

int8 not nulltimestamp not nullcreated_date

bpchar(1) not nullbpchar(1) not nullcreated_date

orig_costpropagate

centralized

log_idtimestamp

orig_color_pages_estimatedmodified_ticks

varchar(100)tbl_job_log_journal

bpchar(1) not nullcheck_cost[table]file_namemodified_ticks

timestamp not null

printer_id

varchar(1000)

varchar(50) not nullvarchar(20) not nullusage_day

attrib_namecreated_by

invoicingtimestamp not nullpropagate

timestamp not nullvarchar(20) not nullusage_date

hardware_check_status

created_date

timestamp not null

int8 not nullrefund_statusvarchar(1000)

modified_date

printer_usage_log_id

original_usage_cost

varchar(30) not nullvarchar(20) not null[table]color_pages_estimatedvarchar(30) not nullcomments

tbl_printer_usage_log

paper_size

schedule_periodbpchar(1) not null

ext_device_id

usage_allowed

varchar(2000)

recipients

float8(17, 17) not nullusage_cost

data_params

varchar(255)balancetransaction_type

varchar(255) not nullvarchar(100)export_type

sub_name_lower

is_credit

int8

varchar(200) not nulltitle

varchar(255)

float8(17, 17) not nullvarchar(255)

report_identifier

sub_nameamounttxn_comment

int8 not null

int8 not nulltransacted_by[table]bpchar(1) not nullmodified_ticks

float8(17, 17) not nullusage_log_id

property_value

initial_settings_enabled

total_cost

tbl_account_attributevarchar(100) not null

float8(17, 17) not null

int8 not nulltimestamp not nullproperty_namemax_accum_balanceuser_id

usage_date

tbl_config

bpchar(1) not nulltimestamp not nullvarchar(255) not null

int8 not nullbpchar(1) not nullcreated_date

item_nameweb_cashier_item_id

propagate
attrib_namebpchar(1) not nullvarchar(255) not null[table]float8(17, 17) not null

reset_statistics

receipt_num

tbl_web_cashier_item

initial_credit

int8 not null

int4 not nullvarchar(2000) not null

int8 not nulluser_group_id

item_index

messagemodified_ticks

int8 not null

int8 not nullvarchar(20) not nullvarchar(255) not nullaccount_id

web_cashier_order_id

log_levelgroup_name[table]int8 not nullvarchar(255)varchar(255)

tbl_user_group

web_cashier_order_id

server_nameattrib_value

int8 not null[table]timestamp not null

int8 not nulluser_idtbl_web_cashier_order

log_dategroup_idallow_accum

int8 not null

int8 not null

int8 not null

int8 not null

web_cashier_order_detail_id

application_log_id

group_iduser_account_id[table][table][table][table]tbl_web_cashier_order_detail

tbl_application_log

tbl_group

tbl_user_accountmodified_ticks

item_quantity[table]int8 not null
Generated by: SchemaCrawler 10.08.05
Generated on: 02/03/2015 9:32 AM
Database: PostgreSQL 9.2.3
Driver: PostgreSQL Native Driver PostgreSQL 9.3 JDBC4.1 (build 1101)