tbl_account_attribute[table]account_id

int8 not null

attrib_value
attrib_namevarchar(255)varchar(255) not null[table]account_group_id

account_id

int8 not null

int8 not nullgroup_id

int8 not nullaccount_type

varchar(10) not nullaccount_id

int8 not nullaccount_namevarchar(255) not nullbalancefloat8(17, 17) not nullcreated_date

timestamp not nullcreated_byvarchar(50) not nullmodified_date

timestamp not nullmodified_byvarchar(50) not nullvarchar(255)varchar(255) not nullmodified_byvarchar(50) not nullinvoicingvarchar(20) not null

sub_pinvarchar(50)[table]int8 not null

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 null

total_cost

float8(17, 17) not nulltransacted_byvarchar(50) not null

wc_comment

varchar(255)

payment_type

varchar(50)modified_date

timestamp not nullemail_statusvarchar(30) not nullmodified_byvarchar(50) not nullverification_sent_time

delivery_methodvarchar(50) not nullverification_code

append_datestamp

bpchar(1) not null

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 nullcolor_pages_estimatedtimestamp
varchar(20)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_net_usage_log[table]net_usage_log_id

int8 not nullvarchar(255) not null

full_namevarchar(255)

emailvarchar(255)notes

varchar(2000)

property_namevarchar(100) not nullproperty_value

varchar(1000)

created_date

timestamp not null

application_log_id

int8 not null

reset_byvarchar(50)log_date

reset_date

timestamp

varchar(20) not null

deleted_date

timestamp

messagevarchar(2000) not nullcreated_date

timestamp not nullcreated_byvarchar(50) not nullvarchar(100)megabytes_received

float8(17, 17) not nulldisabled_printing

megabytes_sent

float8(17, 17) not nulldisabled_printing_until

cached_megabytes_received

float8(17, 17) not null

net_reset_byvarchar(50)net_reset_date

timestamp

net_total_time_hours

float8(17, 17) not nulldisabled_net
disabled_net_untilinternal
last_user_activity

usage_log_type

varchar(20)card_number2

float8(17, 17) not nullbalancefloat8(17, 17) not null

txn_comment

timestamp
varchar(100)varchar(20) not null

ext_device_id

int8

batch_idvarchar(255) not nullvarchar(255) not null

tbl_sequences[table]sequence_namevarchar(255)

sequence_next_hi_value

int4

timestamp

float8(17, 17) not null

date_loaded

timestamp not nullvarchar(6) not null

expiry_date

timestamp not null"value"bpchar(1) not nullbpchar(1) not nulltransaction_type

date_used

timestamp

varchar(255)

is_creditvarchar(20)bpchar(1) not null

int8

amountprotocoltimestamp

float8(17, 17) not null

int8 not null

card_number

bpchar(1) not null

net_total_megabytes

account_id

varchar(255)varchar(255)

log_level

card_number

usage_log_id

server_nametimestamp not nullbpchar(1) not null

float8(17, 17) not nullvarchar(50) not null

float8(17, 17) not null

int4 not nullhours_used

transacted_by

item_cost

total_sheets

varchar(200)timestamp not nullvarchar(255) not null[table]officetransaction_date

item_nametbl_application_log

float8(17, 17) not null

int8 not null

int8 not null

int4 not nullusage_cost

account_transaction_id

web_cashier_item_id

total_pages

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

department

tbl_account_transaction

tbl_web_cashier_item

total_jobs

int8 not null

used_by_user_id

job_comment

float8(17, 17) not null

used_by_user_id

int8

int8

tbl_refund_request[table]job_uidvarchar(40)refund_request_id

int8 not nullarchive_path

varchar(30)request_date

timestamp not null

duplex_pages

int4 not nullstatusvarchar(6) not null

hardware_check_id

external_user_namevarchar(50) not nullbpchar(1) not null

hardware_check_statusvarchar(50) not nullmodified_by

invoicedvarchar(50)user_nametimestamp not null

int8 not nullsignature

int8 not nullusage_day

topup_card_id

bpchar(1) not nulluser_idtimestamp not nullvarchar(10)replayed[table]modified_date

job_type

int8

tbl_usertimestamp not null[table]refund_request_id

bpchar(1) not nullusage_date

tbl_topup_card

refund_statusvarchar(50) not null

int8 not null

deletedbpchar(1) not null

original_usage_cost

config_id

int8
varchar(255) not null

document_size_kb

timestamp not null

int8 not nullemail_address

varchar(50)modified_date[table][table]varchar(50) not null

printer_language

tbl_config

varchar(50) not nullcreated_by

int4 not nullvarchar(50) not nullmodified_by

user_id

paper_width_mm

created_byvarchar(50) not nulltimestamp not null

int4 not nulltimestamp not nullmodified_bycreated_date

paper_height_mm

created_date

timestamp not null

int8 not nullvarchar(20) not nullbpchar(1) not nullmodified_date

user_email_address_id

paper_size

reset_statistics

timestamp not nullvarchar(1000)

int4 not null

float8(17, 17) not nullmodified_date[table]copiesmax_accum_balancebpchar(1) not nullvarchar(50) not null

tbl_user_email_address

int4 not nullallow_accum

created_byvarchar(30) not null

total_sheets

float8(17, 17) not nullvarchar(50) not null

export_type

int4 not nullschedule_amountcreated_byvarchar(30) not null

total_pages

varchar(10) not nulltimestamp not nullschedule_periodvarchar(255)schedule_period

created_date

varchar(2000)

client_machinebpchar(1) not null

int8 not null

data_params

varchar(255)

initially_restrictedgroup_idvarchar(255) not null

document_namefloat8(17, 17) not null

initial_settings_enabledattrib_namevarchar(255)

initial_credit

int8 not nullvarchar(100)job_idvarchar(255) not nulluser_id

title

int8 not nullgroup_name

modified_byvarchar(1000)

printer_id

int8 not null

int8 not nulluser_idbpchar(1) not nullgroup_iduser_group_id

attrib_value

usage_allowed[table][table]tbl_user_attribute

float8(17, 17) not null

tbl_group

tbl_user_groupvarchar(200) not nullusage_cost

timestamp
varchar(20) not nulltimestamp not null

int8 not nullbpchar(1) not nullcomments

usage_daycharged_to_account_id

varchar(255) not nulltimestamp not null

int4 not null

int8 not null

int8

modified_date

timestamp not null

used_by_user_id

varchar(50) not nullvarchar(50) not nullusage_date

timestamp not nullmodified_bycreated_byvarchar(255) not nullusage_daytimestamp not nulldisabled_until

item_nametimestamp not nullmodified_date

disabled

timestamp not nullvarchar(255) not nullusage_date

varchar(50) not null

int8 not nullreceipt_num

int8 not nullcreated_byvarchar(255)

int4 not null

printer_usage_log_id

timestamp not null

sub_name_lower

item_index[table]created_date

varchar(255)

int8 not null

tbl_printer_usage_log

timestamp

sub_name

web_cashier_order_id

bpchar(1) not null

deleted_date

int8 not null

web_cashier_order_id

centralizedbpchar(1) not nulluser_idtbl_web_cashier_ordervarchar(100)deletedaccount_name_lower

int8 not null

file_namevarchar(2000)

int8 not null

web_cashier_order_detail_id

recipientsbpchar(1) not nulluser_account_id[table]report_identifier

varchar(50)notesparent_id

tbl_web_cashier_order_detail

int8 not null

float8(17, 17) not null[table]created_date

scheduled_report_id

overdraft

tbl_user_accountaccount_id[table]bpchar(1) not null

use_global_overdraft

int8 not null

attrib_valueattrib_namerestrictedpin[table]group_idtbl_scheduled_report[table]tbl_account_grouptbl_group_attributeitem_quantity

tbl_accountvarchar(6) not null

request_user_id

int8

request_reason

varchar(1000)

request_amountfloat8(17, 17) not null

response_date

timestamp

response_username

varchar(50)response_reason

varchar(1000)

refunded_amountfloat8(17, 17)

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 nullcheck_cost

float8(17, 17) not null

orig_total_pages

int4 not null

orig_color_pages

int4 not null

orig_color_pages_estimatedorig_costbpchar(1) not null
float8(17, 17) not nulladjustment_applied_date

timestamp

adjustment_applied_byvarchar(50)tbl_printer_attribute[table]printer_id
attrib_value
attrib_nameint8 not nullvarchar(1000)
varchar(255) not null

tbl_printer[table]printer_id

int8 not nullserver_namevarchar(255)

printer_namevarchar(255) not null

display_namevarchar(510) not null

locationvarchar(255)notes

varchar(2000)

charge_type

varchar(20) not nulldefault_cost

float8(17, 17) not null

deleteddeleted_date
disabled[table]printer_id

int8 not null

printer_group_id

int8 not nulltimestampbpchar(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_enabled

tbl_printer_printer_groupbpchar(1) not nullbpchar(1) not nullcustom1

varchar(50)custom2

varchar(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 null

tbl_printer_group[table]printer_group_idint8 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 null
Generated by: SchemaCrawler 10.08.05
Generated on: 15/05/2014 4:49 PM
Database: PostgreSQL 9.2.3
Driver: PostgreSQL Native Driver PostgreSQL 9.3 JDBC4.1 (build 1101)