digraph g { graph [ rankdir = "LR", concentrate = true, ratio = auto ]; node [ fontsize = "10", shape = record ]; edge [ ]; "ac_tax_form" [shape = plaintext, label = <
\N
entry_id integer PK FK
reportable boolean
> ]; "acc_trans" [shape = plaintext, label = <
\N
trans_id integer FK
chart_id integer FK
amount numeric
transdate date
source text
cleared boolean
fx_transaction boolean
memo text
invoice_id integer FK
approved boolean
cleared_on date
reconciled_on date
voucher_id integer FK
entry_id serial PK
> ]; "account" [shape = plaintext, label = <
\N
id serial
accno text PK
description text
is_temp boolean
category character(1)
gifi_accno text
heading integer FK
contra boolean
tax boolean
obsolete boolean
> ]; "account_checkpoint" [shape = plaintext, label = <
\N
end_date date PK
account_id integer PK FK
amount numeric
id serial
debits numeric
credits numeric
> ]; "account_heading" [shape = plaintext, label = <
\N
id serial
accno text PK
parent_id integer FK
description text
category character(1)
> ]; "account_heading_translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "account_link" [shape = plaintext, label = <
\N
account_id integer PK FK
description text PK FK
> ]; "account_link_description" [shape = plaintext, label = <
\N
description text PK
summary boolean
custom boolean
> ]; "account_translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "ap" [shape = plaintext, label = <
\N
id integer PK FK
invnumber text
transdate date
entity_id integer FK
taxincluded boolean
amount numeric
netamount numeric
duedate date
invoice boolean
ordnumber text
curr character(3)
notes text
person_id integer FK
till character varying(20)
quonumber text
intnotes text
shipvia text
language_code character varying(6)
ponumber text
shippingpoint text
on_hold boolean
approved boolean
reverse boolean
terms smallint
description text
force_closed boolean
crdate date
is_return boolean
entity_credit_account integer FK
> ]; "ar" [shape = plaintext, label = <
\N
id integer PK FK
invnumber text
transdate date
entity_id integer FK
taxincluded boolean
amount numeric
netamount numeric
duedate date
invoice boolean
shippingpoint text
terms smallint
notes text
curr character(3)
ordnumber text
person_id integer FK
till character varying(20)
quonumber text
intnotes text
shipvia text
language_code character varying(6)
ponumber text
on_hold boolean
reverse boolean
approved boolean
entity_credit_account integer FK
force_closed boolean
description text
is_return boolean
crdate date
setting_sequence text
> ]; "assembly" [shape = plaintext, label = <
\N
id integer PK FK
parts_id integer PK FK
qty numeric
bom boolean
adj boolean
> ]; "asset_class" [shape = plaintext, label = <
\N
id serial
label text PK
asset_account_id integer FK
dep_account_id integer FK
method integer FK
> ]; "asset_dep_method" [shape = plaintext, label = <
\N
id serial
method text PK
sproc text
unit_label text
short_name text
unit_class integer FK
> ]; "asset_disposal_method" [shape = plaintext, label = <
\N
label text PK
id serial
multiple integer
short_label character(1)
> ]; "asset_item" [shape = plaintext, label = <
\N
id serial PK
description text
tag text
purchase_value numeric
salvage_value numeric
usable_life numeric
purchase_date date
start_depreciation date
location_id integer FK
department_id integer FK
invoice_id integer FK
asset_account_id integer FK
dep_account_id integer FK
exp_account_id integer FK
obsolete_by integer FK
asset_class_id integer FK
> ]; "asset_note" [shape = plaintext, label = <
\N
id integer
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
> ]; "asset_report" [shape = plaintext, label = <
\N
id serial PK
report_date date
gl_id bigint FK
asset_class bigint FK
report_class integer FK
entered_by bigint FK
approved_by bigint FK
entered_at timestamp without time zone
approved_at timestamp without time zone
depreciated_qty numeric
dont_approve boolean
submitted boolean
> ]; "asset_report_class" [shape = plaintext, label = <
\N
id integer
class text PK
> ]; "asset_report_line" [shape = plaintext, label = <
\N
asset_id bigint PK FK
report_id bigint PK
amount numeric
department_id integer FK
warehouse_id integer FK
> ]; "asset_rl_to_disposal_method" [shape = plaintext, label = <
\N
report_id integer PK
asset_id integer PK FK
disposal_method_id integer PK FK
percent_disposed numeric
> ]; "asset_unit_class" [shape = plaintext, label = <
\N
id integer
class text PK
> ]; "audittrail" [shape = plaintext, label = <
\N
trans_id integer
tablename text
reference text
formname text
action text
transdate timestamp without time zone
person_id integer FK
entry_id bigserial PK
rolname text
> ]; "batch" [shape = plaintext, label = <
\N
id serial PK
batch_class_id integer FK
control_code text
description text
default_date date
approved_on date
approved_by integer FK
created_by integer FK
locked_by integer FK
created_on date
> ]; "batch_class" [shape = plaintext, label = <
\N
id serial
class character varying PK
> ]; "bu_class_to_module" [shape = plaintext, label = <
\N
bu_class_id integer PK FK
module_id integer PK FK
> ]; "budget_info" [shape = plaintext, label = <
\N
id serial
start_date date
end_date date
reference text PK
description text
entered_by integer FK
approved_by integer FK
obsolete_by integer FK
entered_at timestamp without time zone
approved_at timestamp without time zone
obsolete_at timestamp without time zone
> ]; "budget_line" [shape = plaintext, label = <
\N
budget_id integer PK FK
account_id integer PK FK
description text
amount numeric
> ]; "budget_note" [shape = plaintext, label = <
\N
id integer PK
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
> ]; "budget_to_business_unit" [shape = plaintext, label = <
\N
budget_id integer PK FK
bu_id integer FK
bu_class integer PK FK
> ]; "business" [shape = plaintext, label = <
\N
id serial PK
description text
discount numeric
> ]; "business_unit" [shape = plaintext, label = <
\N
id serial PK
class_id integer
control_code text
description text
start_date date
end_date date
parent_id integer FK
credit_id integer FK
> ]; "business_unit_ac" [shape = plaintext, label = <
\N
entry_id integer PK FK
class_id integer PK FK
bu_id integer PK FK
> ]; "business_unit_class" [shape = plaintext, label = <
\N
id serial
label text PK
active boolean
ordering integer
> ]; "business_unit_inv" [shape = plaintext, label = <
\N
entry_id integer PK FK
class_id integer PK FK
bu_id integer PK FK
> ]; "business_unit_jl" [shape = plaintext, label = <
\N
entry_id integer PK FK
bu_class integer PK FK
bu_id integer FK
> ]; "business_unit_oitem" [shape = plaintext, label = <
\N
entry_id integer PK FK
class_id integer PK FK
bu_id integer PK FK
> ]; "business_unit_translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "company" [shape = plaintext, label = <
\N
id serial
entity_id integer PK FK
legal_name text PK
tax_id text
sales_tax_id text
license_number text
sic_code character varying
created date
> ]; "contact_class" [shape = plaintext, label = <
\N
id serial
class text PK
> ]; "country" [shape = plaintext, label = <
\N
id serial PK
name text
short_name text
itu text
> ]; "country_tax_form" [shape = plaintext, label = <
\N
country_id integer PK FK
form_name text PK
id serial
default_reportable boolean
is_accrual boolean
> ]; "cr_coa_to_account" [shape = plaintext, label = <
\N
chart_id integer PK FK
account text
> ]; "cr_report" [shape = plaintext, label = <
\N
id bigserial PK
chart_id integer FK
their_total numeric
approved boolean
submitted boolean
end_date date
updated timestamp without time zone
entered_by integer FK
entered_username text
deleted boolean
deleted_by integer FK
approved_by integer FK
approved_username text
recon_fx boolean
max_ac_id integer FK
> ]; "cr_report_line" [shape = plaintext, label = <
\N
id bigserial PK
report_id integer FK
scn text
their_balance numeric
our_balance numeric
errorcode integer
user integer FK
clear_time date
insert_time timestamp with time zone
trans_type text
post_date date
ledger_id integer FK
voucher_id integer
overlook boolean
cleared boolean
> ]; "custom_field_catalog" [shape = plaintext, label = <
\N
field_id serial PK
table_id integer FK
field_name text
> ]; "custom_table_catalog" [shape = plaintext, label = <
\N
table_id serial PK
extends text
table_name text
> ]; "db_patch_log" [shape = plaintext, label = <
\N
when_applied timestamp without time zone PK
path text
sha text
sqlstate text
error text
> ]; "db_patches" [shape = plaintext, label = <
\N
sha text PK
path text
last_updated timestamp without time zone
> ]; "defaults" [shape = plaintext, label = <
\N
setting_key text PK
value text
> ]; "eca_invoice" [shape = plaintext, label = <
\N
order_id integer
journal_id integer PK FK
on_hold boolean
reverse boolean
credit_id integer FK
due date
language_code character(6) FK
force_closed boolean
order_number text
> ]; "eca_note" [shape = plaintext, label = <
\N
id integer PK
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
> ]; "eca_tax" [shape = plaintext, label = <
\N
eca_id integer PK FK
chart_id integer PK FK
> ]; "eca_to_contact" [shape = plaintext, label = <
\N
credit_id integer PK FK
contact_class_id integer PK FK
contact text PK
description text
> ]; "eca_to_location" [shape = plaintext, label = <
\N
location_id integer PK FK
location_class integer PK FK
credit_id integer PK FK
> ]; "employee_class" [shape = plaintext, label = <
\N
label text PK
id serial
> ]; "employee_to_ec" [shape = plaintext, label = <
\N
employee_id integer PK FK
ec_id integer FK
> ]; "entity" [shape = plaintext, label = <
\N
id serial PK
name text
entity_class integer FK
created date
control_code text
country_id integer FK
> ]; "entity_bank_account" [shape = plaintext, label = <
\N
id serial
entity_id integer PK FK
bic character varying PK
iban character varying PK
remark character varying
> ]; "entity_class" [shape = plaintext, label = <
\N
id serial PK
class text
active boolean
> ]; "entity_credit_account" [shape = plaintext, label = <
\N
id serial
entity_id integer PK FK
entity_class integer PK FK
pay_to_name text
discount numeric
description text
discount_terms integer
discount_account_id integer FK
taxincluded boolean
creditlimit numeric
terms smallint
meta_number character varying(32) PK
business_id integer FK
language_code character varying(6) FK
pricegroup_id integer FK
curr character(3)
startdate date
enddate date
threshold numeric
employee_id integer FK
primary_contact integer FK
ar_ap_account_id integer FK
cash_account_id integer FK
bank_account integer FK
taxform_id integer FK
> ]; "entity_employee" [shape = plaintext, label = <
\N
entity_id integer PK FK
startdate date
enddate date
role character varying(20)
ssn text
sales boolean
manager_id integer FK
employeenumber character varying(32)
dob date
is_manager boolean
> ]; "entity_note" [shape = plaintext, label = <
\N
id integer PK
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
entity_id integer FK
> ]; "entity_other_name" [shape = plaintext, label = <
\N
entity_id integer PK FK
other_name text PK
> ]; "entity_to_contact" [shape = plaintext, label = <
\N
entity_id integer PK FK
contact_class_id integer PK FK
contact text PK
description text
> ]; "entity_to_location" [shape = plaintext, label = <
\N
location_id integer PK FK
location_class integer PK FK
entity_id integer PK FK
> ]; "exchangerate" [shape = plaintext, label = <
\N
curr character(3) PK
transdate date PK
buy numeric
sell numeric
> ]; "file_base" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer FK
file_name text PK
description text
uploaded_by integer FK
uploaded_at timestamp without time zone
id serial
ref_key integer PK
file_class integer PK FK
> ]; "file_class" [shape = plaintext, label = <
\N
id serial
class text PK
> ]; "file_eca" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_entity" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_incoming" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_internal" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_order" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_order_to_order" [shape = plaintext, label = <
\N
file_id integer PK FK
source_class integer PK
ref_key integer PK
dest_class integer PK
attached_by integer
attached_at timestamp without time zone
> ]; "file_order_to_tx" [shape = plaintext, label = <
\N
file_id integer PK FK
source_class integer PK
ref_key integer PK
dest_class integer PK
attached_by integer
attached_at timestamp without time zone
> ]; "file_part" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_secondary_attachment" [shape = plaintext, label = <
\N
file_id integer PK
source_class integer PK
ref_key integer PK
dest_class integer PK FK
attached_by integer FK
attached_at timestamp without time zone
> ]; "file_transaction" [shape = plaintext, label = <
\N
content bytea
mime_type_id integer
file_name text PK
description text
uploaded_by integer
uploaded_at timestamp without time zone
id integer
ref_key integer PK
file_class integer PK
> ]; "file_tx_to_order" [shape = plaintext, label = <
\N
file_id integer PK FK
source_class integer PK
ref_key integer PK
dest_class integer PK
attached_by integer
attached_at timestamp without time zone
> ]; "file_view_catalog" [shape = plaintext, label = <
\N
file_class integer PK FK
view_name text
> ]; "fixes" [shape = plaintext, label = <
\N
checksum text PK
path text
stdout text
stderr text
applied_at timestamp without time zone
> ]; "gifi" [shape = plaintext, label = <
\N
accno text PK
description text
> ]; "gl" [shape = plaintext, label = <
\N
id integer PK FK
reference text
description text
transdate date
person_id integer FK
notes text
approved boolean
trans_type_code character(2) FK
> ]; "inventory_report" [shape = plaintext, label = <
\N
id serial PK
transdate date
source text
trans_id integer FK
> ]; "inventory_report_line" [shape = plaintext, label = <
\N
adjust_id integer PK FK
parts_id integer PK FK
counted numeric
expected numeric
variance numeric
> ]; "invoice" [shape = plaintext, label = <
\N
id serial PK
trans_id integer FK
parts_id integer FK
description text
qty numeric
allocated numeric
sellprice numeric
precision integer
fxsellprice numeric
discount numeric
assemblyitem boolean
unit character varying
deliverydate date
serialnumber text
vendor_sku text
notes text
> ]; "invoice_note" [shape = plaintext, label = <
\N
id integer PK
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
> ]; "invoice_tax_form" [shape = plaintext, label = <
\N
invoice_id integer PK FK
reportable boolean
> ]; "jcitems" [shape = plaintext, label = <
\N
id serial PK
business_unit_id integer FK
parts_id integer
description text
qty numeric
allocated numeric
sellprice numeric
fxsellprice numeric
serialnumber text
checkedin timestamp with time zone
checkedout timestamp with time zone
person_id integer FK
notes text
total numeric
non_billable numeric
jctype integer
curr character(3)
> ]; "jctype" [shape = plaintext, label = <
\N
id integer
label text PK
description text
is_service boolean
is_timecard boolean
> ]; "job" [shape = plaintext, label = <
\N
bu_id integer PK FK
parts_id integer
production numeric
completed numeric
> ]; "journal_entry" [shape = plaintext, label = <
\N
id serial PK
reference text
description text
locked_by integer FK
journal integer FK
post_date date
effective_start date
effective_end date
currency character(3)
approved boolean
is_template boolean
entered_by integer FK
approved_by integer FK
> ]; "journal_line" [shape = plaintext, label = <
\N
id serial PK
account_id integer FK
journal_id integer FK
amount numeric
cleared boolean
reconciliation_report integer FK
line_type text FK
> ]; "journal_note" [shape = plaintext, label = <
\N
id integer PK
note_class integer
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer FK
subject text
internal_only boolean
> ]; "journal_type" [shape = plaintext, label = <
\N
id serial
name text PK
> ]; "language" [shape = plaintext, label = <
\N
code character varying(6) PK
description text
> ]; "location" [shape = plaintext, label = <
\N
id serial PK
line_one text
line_two text
line_three text
city text
state text
country_id integer FK
mail_code text
created date
inactive_date timestamp without time zone
active boolean
> ]; "location_class" [shape = plaintext, label = <
\N
id serial
class text PK
authoritative boolean PK
> ]; "location_class_to_entity_class" [shape = plaintext, label = <
\N
id serial
location_class integer FK
entity_class integer FK
> ]; "lsmb_group" [shape = plaintext, label = <
\N
role_name text PK
> ]; "lsmb_group_grants" [shape = plaintext, label = <
\N
group_name text PK FK
granted_role text PK
> ]; "lsmb_module" [shape = plaintext, label = <
\N
id integer
label text PK
> ]; "lsmb_sequence" [shape = plaintext, label = <
\N
label text PK
setting_key text FK
prefix text
suffix text
sequence text
accept_input boolean
> ]; "makemodel" [shape = plaintext, label = <
\N
parts_id integer PK FK
barcode text
make text PK
model text PK
> ]; "menu_acl" [shape = plaintext, label = <
\N
id serial
role_name character varying PK
acl_type character varying
node_id integer PK FK
> ]; "menu_attribute" [shape = plaintext, label = <
\N
node_id integer PK FK
attribute character varying PK
value character varying
id serial
> ]; "menu_node" [shape = plaintext, label = <
\N
id serial PK
label character varying
parent integer FK
position integer
> ]; "mfg_lot" [shape = plaintext, label = <
\N
id serial
lot_number text
parts_id integer FK
qty numeric
stock_date date
> ]; "mfg_lot_item" [shape = plaintext, label = <
\N
id serial
mfg_lot_id integer FK
parts_id integer FK
qty numeric
> ]; "mime_type" [shape = plaintext, label = <
\N
id serial
mime_type text PK
invoice_include boolean
> ]; "new_shipto" [shape = plaintext, label = <
\N
id serial PK
trans_id integer FK
oe_id integer FK
location_id integer FK
> ]; "note" [shape = plaintext, label = <
\N
id serial PK
note_class integer FK
note text
vector tsvector
created timestamp without time zone
created_by text
ref_key integer
subject text
> ]; "note_class" [shape = plaintext, label = <
\N
id serial PK
class text
> ]; "oe" [shape = plaintext, label = <
\N
id serial PK
ordnumber text
transdate date
entity_id integer FK
amount numeric
netamount numeric
reqdate date
taxincluded boolean
shippingpoint text
notes text
curr character(3)
person_id integer FK
closed boolean
quotation boolean
quonumber text
intnotes text
shipvia text
language_code character varying(6)
ponumber text
terms smallint
entity_credit_account integer FK
oe_class_id integer FK
> ]; "oe_class" [shape = plaintext, label = <
\N
id smallint
oe_class text PK
> ]; "open_forms" [shape = plaintext, label = <
\N
id serial PK
session_id integer FK
form_name character varying(100)
last_used timestamp without time zone
> ]; "orderitems" [shape = plaintext, label = <
\N
id serial PK
trans_id integer
parts_id integer FK
description text
qty numeric
sellprice numeric
precision integer
discount numeric
unit character varying(5)
reqdate date
ship numeric
serialnumber text
notes text
> ]; "parts" [shape = plaintext, label = <
\N
id serial PK
partnumber text
description text
unit character varying(5)
listprice numeric
sellprice numeric
lastcost numeric
priceupdate date
weight numeric
onhand numeric
notes text
makemodel boolean
assembly boolean
alternate boolean
rop numeric
inventory_accno_id integer FK
income_accno_id integer FK
expense_accno_id integer FK
returns_accno_id integer FK
bin text
obsolete boolean
bom boolean
image text
drawing text
microfiche text
partsgroup_id integer
avgcost numeric
> ]; "parts_translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "partscustomer" [shape = plaintext, label = <
\N
parts_id integer FK
credit_id integer FK
pricegroup_id integer FK
pricebreak numeric
sellprice numeric
validfrom date
validto date
curr character(3)
entry_id serial PK
qty numeric
> ]; "partsgroup" [shape = plaintext, label = <
\N
id serial PK
partsgroup text
parent integer FK
> ]; "partsgroup_translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "partstax" [shape = plaintext, label = <
\N
parts_id integer PK FK
chart_id integer PK FK
taxcategory_id integer FK
> ]; "partsvendor" [shape = plaintext, label = <
\N
credit_id integer FK
parts_id integer
partnumber text
leadtime smallint
lastcost numeric
curr character(3)
entry_id serial PK
> ]; "payment" [shape = plaintext, label = <
\N
id serial PK
reference text
gl_id integer FK
payment_class integer
payment_date date
closed boolean
entity_credit_id integer FK
employee_id integer FK
currency character(3)
notes text
> ]; "payment_links" [shape = plaintext, label = <
\N
payment_id integer FK
entry_id integer FK
type integer
> ]; "payment_map" [shape = plaintext, label = <
\N
line_id integer PK FK
pays integer FK
> ]; "payment_type" [shape = plaintext, label = <
\N
id serial
label text PK
> ]; "payroll_deduction" [shape = plaintext, label = <
\N
entry_id serial
entity_id integer PK FK
type_id integer PK
rate numeric
> ]; "payroll_deduction_class" [shape = plaintext, label = <
\N
id integer
country_id integer PK FK
label text PK
stored_proc_name name
> ]; "payroll_deduction_type" [shape = plaintext, label = <
\N
id serial
account_id integer FK
pdc_id integer FK
country_id integer FK
label text
unit text
default_amount numeric
calc_percent boolean
> ]; "payroll_employee_class" [shape = plaintext, label = <
\N
id serial
label text PK
> ]; "payroll_employee_class_to_income_type" [shape = plaintext, label = <
\N
ec_id integer PK FK
it_id integer PK FK
> ]; "payroll_income_category" [shape = plaintext, label = <
\N
id serial
label text
> ]; "payroll_income_class" [shape = plaintext, label = <
\N
id integer
country_id integer PK FK
label text PK
> ]; "payroll_income_type" [shape = plaintext, label = <
\N
id serial
account_id integer FK
pic_id integer FK
country_id integer FK
label text
unit text
default_amount numeric
> ]; "payroll_paid_timeoff" [shape = plaintext, label = <
\N
employee_id integer FK
pto_class_id integer FK
report_id integer FK
amount numeric
> ]; "payroll_pto_class" [shape = plaintext, label = <
\N
id serial
label text PK
> ]; "payroll_report" [shape = plaintext, label = <
\N
id serial PK
ec_id integer FK
payment_date date
created_by integer FK
approved_by integer FK
> ]; "payroll_report_line" [shape = plaintext, label = <
\N
id serial
report_id integer PK
employee_id integer PK FK
it_id integer PK FK
qty numeric
rate numeric
description text
> ]; "payroll_wage" [shape = plaintext, label = <
\N
entry_id serial
entity_id integer PK FK
type_id integer PK
rate numeric
> ]; "person" [shape = plaintext, label = <
\N
id serial PK
entity_id integer FK
salutation_id integer FK
first_name text
middle_name text
last_name text
created date
birthdate date
personal_id text
> ]; "person_to_company" [shape = plaintext, label = <
\N
location_id integer PK FK
person_id integer PK FK
company_id integer FK
> ]; "pricegroup" [shape = plaintext, label = <
\N
id serial PK
pricegroup text
> ]; "recurring" [shape = plaintext, label = <
\N
id integer FK
reference text
startdate date
nextdate date
enddate date
recurring_interval interval
howmany integer
payment boolean
> ]; "recurringemail" [shape = plaintext, label = <
\N
id integer PK FK
formname text PK
format text
message text
> ]; "recurringprint" [shape = plaintext, label = <
\N
id integer PK FK
formname text PK
format text
printer text
> ]; "robot" [shape = plaintext, label = <
\N
id serial PK
entity_id integer FK
first_name text
middle_name text
last_name text
created date
> ]; "salutation" [shape = plaintext, label = <
\N
id serial
salutation text PK
> ]; "session" [shape = plaintext, label = <
\N
session_id serial PK
token character varying(32)
last_used timestamp without time zone
ttl integer
users_id integer FK
notify_pasword interval
> ]; "sic" [shape = plaintext, label = <
\N
code character varying(6) PK
sictype character(1)
description text
> ]; "status" [shape = plaintext, label = <
\N
trans_id integer PK
formname text PK
printed boolean
emailed boolean
spoolfile text
> ]; "tax" [shape = plaintext, label = <
\N
chart_id integer PK FK
rate numeric
minvalue numeric
maxvalue numeric
taxnumber text
validto timestamp without time zone PK
pass integer
taxmodule_id integer FK
> ]; "tax_extended" [shape = plaintext, label = <
\N
tax_basis numeric
rate numeric
entry_id integer PK FK
> ]; "taxcategory" [shape = plaintext, label = <
\N
taxcategory_id serial PK
taxcategoryname text
taxmodule_id integer FK
> ]; "taxmodule" [shape = plaintext, label = <
\N
taxmodule_id serial PK
taxmodulename text
> ]; "template" [shape = plaintext, label = <
\N
id serial
template_name text
language_code character varying(6) FK
template text
format text
last_modified timestamp with time zone
> ]; "trans_type" [shape = plaintext, label = <
\N
code character(2) PK
description character varying(1000)
> ]; "transactions" [shape = plaintext, label = <
\N
id integer PK
table_name text
locked_by integer FK
approved boolean
approved_by integer FK
approved_at timestamp without time zone
> ]; "translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "trial_balance__yearend_types" [shape = plaintext, label = <
\N
type text PK
> ]; "user_preference" [shape = plaintext, label = <
\N
id integer PK FK
language character varying(6) FK
stylesheet text
printer text
dateformat text
numberformat text
> ]; "users" [shape = plaintext, label = <
\N
id serial
username character varying(30) PK
notify_password interval
entity_id integer FK
> ]; "voucher" [shape = plaintext, label = <
\N
trans_id integer FK
batch_id integer FK
id serial PK
batch_class integer FK
> ]; "warehouse" [shape = plaintext, label = <
\N
id serial PK
description text
> ]; "warehouse_inventory" [shape = plaintext, label = <
\N
entity_id integer FK
warehouse_id integer
parts_id integer
trans_id integer
orderitems_id integer
qty numeric
shippingdate date
entry_id serial PK
> ]; "yearend" [shape = plaintext, label = <
\N
trans_id integer PK
reversed boolean
transdate date
> ]; "ac_tax_form":rtcol1 -> "acc_trans":ltcol14 [label="ac_tax_form_entry_id_fkey"]; "acc_trans":rtcol1 -> "transactions":ltcol1 [label="acc_trans_trans_id_fkey"]; "acc_trans":rtcol2 -> "account":ltcol1 [label="acc_trans_chart_id_fkey"]; "acc_trans":rtcol9 -> "invoice":ltcol1 [label="acc_trans_invoice_id_fkey"]; "acc_trans":rtcol13 -> "voucher":ltcol3 [label="acc_trans_voucher_id_fkey"]; "account":rtcol7 -> "account_heading":ltcol1 [label="account_heading_fkey"]; "account_checkpoint":rtcol2 -> "account":ltcol1 [label="account_checkpoint_account_id_fkey"]; "account_heading":rtcol3 -> "account_heading":ltcol1 [label="account_heading_parent_id_fkey"]; "account_heading_translation":rtcol1 -> "account_heading":ltcol1 [label="account_heading_translation_trans_id_fkey"]; "account_heading_translation":rtcol1 -> "account_heading":ltcol1 [label="account_heading_translation_trans_id_fkey1"]; "account_link":rtcol1 -> "account":ltcol1 [label="account_link_account_id_fkey"]; "account_link":rtcol2 -> "account_link_description":ltcol1 [label="account_link_description_fkey"]; "account_translation":rtcol1 -> "account":ltcol1 [label="account_translation_trans_id_fkey"]; "account_translation":rtcol1 -> "account":ltcol1 [label="account_translation_trans_id_fkey1"]; "ap":rtcol1 -> "transactions":ltcol1 [label="ap_id_fkey"]; "ap":rtcol4 -> "entity":ltcol1 [label="ap_entity_id_fkey"]; "ap":rtcol15 -> "entity_employee":ltcol1 [label="ap_person_id_fkey"]; "ap":rtcol31 -> "entity_credit_account":ltcol1 [label="ap_entity_credit_account_fkey"]; "ar":rtcol1 -> "transactions":ltcol1 [label="ar_id_fkey"]; "ar":rtcol4 -> "entity":ltcol1 [label="ar_entity_id_fkey"]; "ar":rtcol17 -> "entity_employee":ltcol1 [label="ar_person_id_fkey"]; "ar":rtcol27 -> "entity_credit_account":ltcol1 [label="ar_entity_credit_account_fkey"]; "assembly":rtcol1 -> "parts":ltcol1 [label="assembly_id_fkey"]; "assembly":rtcol2 -> "parts":ltcol1 [label="assembly_parts_id_fkey"]; "asset_class":rtcol3 -> "account":ltcol1 [label="asset_class_asset_account_id_fkey"]; "asset_class":rtcol4 -> "account":ltcol1 [label="asset_class_dep_account_id_fkey"]; "asset_class":rtcol5 -> "asset_dep_method":ltcol1 [label="asset_class_method_fkey"]; "asset_dep_method":rtcol6 -> "asset_unit_class":ltcol1 [label="asset_dep_method_unit_class_fkey"]; "asset_item":rtcol9 -> "warehouse":ltcol1 [label="asset_item_location_id_fkey"]; "asset_item":rtcol10 -> "business_unit":ltcol1 [label="asset_item_department_id_fkey"]; "asset_item":rtcol11 -> "eca_invoice":ltcol2 [label="asset_item_invoice_id_fkey"]; "asset_item":rtcol12 -> "account":ltcol1 [label="asset_item_asset_account_id_fkey"]; "asset_item":rtcol13 -> "account":ltcol1 [label="asset_item_dep_account_id_fkey"]; "asset_item":rtcol14 -> "account":ltcol1 [label="asset_item_exp_account_id_fkey"]; "asset_item":rtcol15 -> "asset_item":ltcol1 [label="asset_item_obsolete_by_fkey"]; "asset_item":rtcol16 -> "asset_class":ltcol1 [label="asset_item_asset_class_id_fkey"]; "asset_note":rtcol7 -> "asset_item":ltcol1 [label="asset_note_ref_key_fkey"]; "asset_report":rtcol3 -> "gl":ltcol1 [label="asset_report_gl_id_fkey"]; "asset_report":rtcol4 -> "asset_class":ltcol1 [label="asset_report_asset_class_fkey"]; "asset_report":rtcol5 -> "asset_report_class":ltcol1 [label="asset_report_report_class_fkey"]; "asset_report":rtcol6 -> "entity":ltcol1 [label="asset_report_entered_by_fkey"]; "asset_report":rtcol7 -> "entity":ltcol1 [label="asset_report_approved_by_fkey"]; "asset_report_line":rtcol1 -> "asset_item":ltcol1 [label="asset_report_line_asset_id_fkey"]; "asset_report_line":rtcol2 -> "asset_report":ltcol1 [label="asset_report_line_report_id_fkey"]; "asset_report_line":rtcol4 -> "business_unit":ltcol1 [label="asset_report_line_department_id_fkey"]; "asset_report_line":rtcol5 -> "warehouse":ltcol1 [label="asset_report_line_warehouse_id_fkey"]; "asset_rl_to_disposal_method":rtcol1 -> "asset_report":ltcol1 [label="asset_rl_to_disposal_method_report_id_fkey"]; "asset_rl_to_disposal_method":rtcol2 -> "asset_item":ltcol1 [label="asset_rl_to_disposal_method_asset_id_fkey"]; "asset_rl_to_disposal_method":rtcol3 -> "asset_disposal_method":ltcol2 [label="asset_rl_to_disposal_method_disposal_method_id_fkey"]; "audittrail":rtcol7 -> "person":ltcol2 [label="audittrail_person_id_fkey"]; "batch":rtcol2 -> "batch_class":ltcol1 [label="batch_batch_class_id_fkey"]; "batch":rtcol7 -> "entity_employee":ltcol1 [label="batch_approved_by_fkey"]; "batch":rtcol8 -> "entity_employee":ltcol1 [label="batch_created_by_fkey"]; "batch":rtcol9 -> "session":ltcol1 [label="batch_locked_by_fkey"]; "bu_class_to_module":rtcol1 -> "business_unit_class":ltcol1 [label="bu_class_to_module_bu_class_id_fkey"]; "bu_class_to_module":rtcol2 -> "lsmb_module":ltcol1 [label="bu_class_to_module_module_id_fkey"]; "budget_info":rtcol6 -> "entity":ltcol1 [label="budget_info_entered_by_fkey"]; "budget_info":rtcol7 -> "entity":ltcol1 [label="budget_info_approved_by_fkey"]; "budget_info":rtcol8 -> "entity":ltcol1 [label="budget_info_obsolete_by_fkey"]; "budget_line":rtcol1 -> "budget_info":ltcol1 [label="budget_line_budget_id_fkey"]; "budget_line":rtcol2 -> "account":ltcol1 [label="budget_line_account_id_fkey"]; "budget_note":rtcol7 -> "budget_info":ltcol1 [label="budget_note_ref_key_fkey"]; "budget_to_business_unit":rtcol1 -> "budget_info":ltcol1 [label="budget_to_business_unit_budget_id_fkey"]; "budget_to_business_unit":rtcol2 -> "business_unit":ltcol1 [label="budget_to_business_unit_bu_id_fkey"]; "budget_to_business_unit":rtcol3 -> "business_unit_class":ltcol1 [label="budget_to_business_unit_bu_class_fkey"]; "business_unit":rtcol2 -> "business_unit_class":ltcol1 [label="business_unit_class_id_fkey"]; "business_unit":rtcol7 -> "business_unit":ltcol1 [label="business_unit_parent_id_fkey"]; "business_unit":rtcol8 -> "entity_credit_account":ltcol1 [label="business_unit_credit_id_fkey"]; "business_unit_ac":rtcol1 -> "acc_trans":ltcol14 [label="business_unit_ac_entry_id_fkey"]; "business_unit_ac":rtcol0 -> "business_unit":ltcol0 [label="business_unit_ac_class_id_bu_id_fkey"]; "business_unit_ac":rtcol2 -> "business_unit_class":ltcol1 [label="business_unit_ac_class_id_fkey"]; "business_unit_inv":rtcol1 -> "invoice":ltcol1 [label="business_unit_inv_entry_id_fkey"]; "business_unit_inv":rtcol0 -> "business_unit":ltcol0 [label="business_unit_inv_class_id_bu_id_fkey"]; "business_unit_inv":rtcol2 -> "business_unit_class":ltcol1 [label="business_unit_inv_class_id_fkey"]; "business_unit_jl":rtcol1 -> "journal_line":ltcol1 [label="business_unit_jl_entry_id_fkey"]; "business_unit_jl":rtcol2 -> "business_unit_class":ltcol1 [label="business_unit_jl_bu_class_fkey"]; "business_unit_jl":rtcol3 -> "business_unit":ltcol1 [label="business_unit_jl_bu_id_fkey"]; "business_unit_oitem":rtcol1 -> "orderitems":ltcol1 [label="business_unit_oitem_entry_id_fkey"]; "business_unit_oitem":rtcol0 -> "business_unit":ltcol0 [label="business_unit_oitem_class_id_bu_id_fkey"]; "business_unit_oitem":rtcol2 -> "business_unit_class":ltcol1 [label="business_unit_oitem_class_id_fkey"]; "business_unit_translation":rtcol1 -> "business_unit":ltcol1 [label="business_unit_translation_trans_id_fkey"]; "company":rtcol2 -> "entity":ltcol1 [label="company_entity_id_fkey"]; "country_tax_form":rtcol1 -> "country":ltcol1 [label="country_tax_form_country_id_fkey"]; "cr_coa_to_account":rtcol1 -> "account":ltcol1 [label="cr_coa_to_account_chart_id_fkey"]; "cr_report":rtcol2 -> "account":ltcol1 [label="cr_report_chart_id_fkey"]; "cr_report":rtcol8 -> "entity":ltcol1 [label="cr_report_entered_by_fkey"]; "cr_report":rtcol11 -> "entity":ltcol1 [label="cr_report_deleted_by_fkey"]; "cr_report":rtcol12 -> "entity":ltcol1 [label="cr_report_approved_by_fkey"]; "cr_report":rtcol15 -> "acc_trans":ltcol14 [label="cr_report_max_ac_id_fkey"]; "cr_report_line":rtcol2 -> "cr_report":ltcol1 [label="cr_report_line_report_id_fkey"]; "cr_report_line":rtcol7 -> "entity":ltcol1 [label="cr_report_line_user_fkey"]; "cr_report_line":rtcol12 -> "acc_trans":ltcol14 [label="cr_report_line_ledger_id_fkey"]; "custom_field_catalog":rtcol2 -> "custom_table_catalog":ltcol1 [label="custom_field_catalog_table_id_fkey"]; "eca_invoice":rtcol2 -> "journal_entry":ltcol1 [label="eca_invoice_journal_id_fkey"]; "eca_invoice":rtcol5 -> "entity_credit_account":ltcol1 [label="eca_invoice_credit_id_fkey"]; "eca_invoice":rtcol7 -> "language":ltcol1 [label="eca_invoice_language_code_fkey"]; "eca_note":rtcol7 -> "entity_credit_account":ltcol1 [label="eca_note_ref_key_fkey"]; "eca_tax":rtcol1 -> "entity_credit_account":ltcol1 [label="eca_tax_eca_id_fkey"]; "eca_tax":rtcol2 -> "account":ltcol1 [label="eca_tax_chart_id_fkey"]; "eca_to_contact":rtcol1 -> "entity_credit_account":ltcol1 [label="eca_to_contact_credit_id_fkey"]; "eca_to_contact":rtcol2 -> "contact_class":ltcol1 [label="eca_to_contact_contact_class_id_fkey"]; "eca_to_location":rtcol1 -> "location":ltcol1 [label="eca_to_location_location_id_fkey"]; "eca_to_location":rtcol2 -> "location_class":ltcol1 [label="eca_to_location_location_class_fkey"]; "eca_to_location":rtcol3 -> "entity_credit_account":ltcol1 [label="eca_to_location_credit_id_fkey"]; "employee_to_ec":rtcol1 -> "entity_employee":ltcol1 [label="employee_to_ec_employee_id_fkey"]; "employee_to_ec":rtcol2 -> "employee_class":ltcol2 [label="employee_to_ec_ec_id_fkey"]; "entity":rtcol3 -> "entity_class":ltcol1 [label="entity_entity_class_fkey"]; "entity":rtcol6 -> "country":ltcol1 [label="entity_country_id_fkey"]; "entity_bank_account":rtcol2 -> "entity":ltcol1 [label="entity_bank_account_entity_id_fkey"]; "entity_credit_account":rtcol2 -> "entity":ltcol1 [label="entity_credit_account_entity_id_fkey"]; "entity_credit_account":rtcol3 -> "entity_class":ltcol1 [label="entity_credit_account_entity_class_fkey"]; "entity_credit_account":rtcol8 -> "account":ltcol1 [label="entity_credit_account_discount_account_id_fkey"]; "entity_credit_account":rtcol13 -> "business":ltcol1 [label="entity_credit_account_business_id_fkey"]; "entity_credit_account":rtcol14 -> "language":ltcol1 [label="entity_credit_account_language_code_fkey"]; "entity_credit_account":rtcol15 -> "pricegroup":ltcol1 [label="entity_credit_account_pricegroup_id_fkey"]; "entity_credit_account":rtcol20 -> "entity_employee":ltcol1 [label="entity_credit_account_employee_id_fkey"]; "entity_credit_account":rtcol21 -> "person":ltcol1 [label="entity_credit_account_primary_contact_fkey"]; "entity_credit_account":rtcol22 -> "account":ltcol1 [label="entity_credit_account_ar_ap_account_id_fkey"]; "entity_credit_account":rtcol23 -> "account":ltcol1 [label="entity_credit_account_cash_account_id_fkey"]; "entity_credit_account":rtcol24 -> "entity_bank_account":ltcol1 [label="entity_credit_account_bank_account_fkey"]; "entity_credit_account":rtcol25 -> "country_tax_form":ltcol3 [label="entity_credit_account_taxform_id_fkey"]; "entity_employee":rtcol1 -> "entity":ltcol1 [label="entity_employee_entity_id_fkey"]; "entity_employee":rtcol7 -> "entity":ltcol1 [label="entity_employee_manager_id_fkey"]; "entity_note":rtcol7 -> "entity":ltcol1 [label="entity_note_ref_key_fkey"]; "entity_note":rtcol9 -> "entity":ltcol1 [label="entity_note_entity_id_fkey"]; "entity_other_name":rtcol1 -> "entity":ltcol1 [label="entity_other_name_entity_id_fkey"]; "entity_to_contact":rtcol1 -> "entity":ltcol1 [label="entity_to_contact_entity_id_fkey"]; "entity_to_contact":rtcol2 -> "contact_class":ltcol1 [label="entity_to_contact_contact_class_id_fkey"]; "entity_to_location":rtcol1 -> "location":ltcol1 [label="entity_to_location_location_id_fkey"]; "entity_to_location":rtcol2 -> "location_class":ltcol1 [label="entity_to_location_location_class_fkey"]; "entity_to_location":rtcol3 -> "entity":ltcol1 [label="entity_to_location_entity_id_fkey"]; "file_base":rtcol2 -> "mime_type":ltcol1 [label="file_base_mime_type_id_fkey"]; "file_base":rtcol5 -> "entity":ltcol1 [label="file_base_uploaded_by_fkey"]; "file_base":rtcol9 -> "file_class":ltcol1 [label="file_base_file_class_fkey"]; "file_eca":rtcol8 -> "entity_credit_account":ltcol1 [label="file_eca_ref_key_fkey"]; "file_entity":rtcol8 -> "entity":ltcol1 [label="file_entity_ref_key_fkey"]; "file_order":rtcol8 -> "oe":ltcol1 [label="file_order_ref_key_fkey"]; "file_order_to_order":rtcol1 -> "file_order":ltcol7 [label="file_order_to_order_file_id_fkey"]; "file_order_to_order":rtcol3 -> "oe":ltcol1 [label="file_order_to_order_ref_key_fkey"]; "file_order_to_tx":rtcol1 -> "file_order":ltcol7 [label="file_order_to_tx_file_id_fkey"]; "file_order_to_tx":rtcol3 -> "gl":ltcol1 [label="file_order_to_tx_ref_key_fkey"]; "file_part":rtcol8 -> "parts":ltcol1 [label="file_part_ref_key_fkey"]; "file_secondary_attachment":rtcol2 -> "file_class":ltcol1 [label="file_secondary_attachment_source_class_fkey"]; "file_secondary_attachment":rtcol4 -> "file_class":ltcol1 [label="file_secondary_attachment_dest_class_fkey"]; "file_secondary_attachment":rtcol5 -> "entity":ltcol1 [label="file_secondary_attachment_attached_by_fkey"]; "file_transaction":rtcol8 -> "transactions":ltcol1 [label="file_transaction_ref_key_fkey"]; "file_tx_to_order":rtcol1 -> "file_transaction":ltcol7 [label="file_tx_to_order_file_id_fkey"]; "file_tx_to_order":rtcol3 -> "oe":ltcol1 [label="file_tx_to_order_ref_key_fkey"]; "file_view_catalog":rtcol1 -> "file_class":ltcol1 [label="file_view_catalog_file_class_fkey"]; "gl":rtcol1 -> "transactions":ltcol1 [label="gl_id_fkey"]; "gl":rtcol5 -> "person":ltcol1 [label="gl_person_id_fkey"]; "gl":rtcol8 -> "trans_type":ltcol1 [label="gl_trans_type_code_fkey"]; "inventory_report":rtcol6 -> "gl":ltcol1 [label="inventory_report_trans_id_fkey"]; "inventory_report_line":rtcol1 -> "inventory_report":ltcol1 [label="inventory_report_line_adjust_id_fkey"]; "inventory_report_line":rtcol2 -> "parts":ltcol1 [label="inventory_report_line_parts_id_fkey"]; "invoice":rtcol2 -> "transactions":ltcol1 [label="invoice_trans_id_fkey"]; "invoice":rtcol3 -> "parts":ltcol1 [label="invoice_parts_id_fkey"]; "invoice_note":rtcol7 -> "invoice":ltcol1 [label="invoice_note_ref_key_fkey"]; "invoice_tax_form":rtcol1 -> "invoice":ltcol1 [label="invoice_tax_form_invoice_id_fkey"]; "jcitems":rtcol2 -> "business_unit":ltcol1 [label="jcitems_business_unit_id_fkey"]; "jcitems":rtcol12 -> "person":ltcol1 [label="jcitems_person_id_fkey"]; "job":rtcol1 -> "business_unit":ltcol1 [label="job_bu_id_fkey"]; "journal_entry":rtcol4 -> "session":ltcol1 [label="journal_entry_locked_by_fkey"]; "journal_entry":rtcol5 -> "journal_type":ltcol1 [label="journal_entry_journal_fkey"]; "journal_entry":rtcol12 -> "entity":ltcol1 [label="journal_entry_entered_by_fkey"]; "journal_entry":rtcol13 -> "entity":ltcol1 [label="journal_entry_approved_by_fkey"]; "journal_line":rtcol2 -> "account":ltcol1 [label="journal_line_account_id_fkey"]; "journal_line":rtcol3 -> "journal_entry":ltcol1 [label="journal_line_journal_id_fkey"]; "journal_line":rtcol6 -> "cr_report":ltcol1 [label="journal_line_reconciliation_report_fkey"]; "journal_line":rtcol7 -> "account_link_description":ltcol1 [label="journal_line_line_type_fkey"]; "journal_note":rtcol7 -> "journal_entry":ltcol1 [label="journal_note_ref_key_fkey"]; "location":rtcol7 -> "country":ltcol1 [label="location_country_id_fkey"]; "location_class_to_entity_class":rtcol2 -> "location_class":ltcol1 [label="location_class_to_entity_class_location_class_fkey"]; "location_class_to_entity_class":rtcol3 -> "entity_class":ltcol1 [label="location_class_to_entity_class_entity_class_fkey"]; "lsmb_group_grants":rtcol1 -> "lsmb_group":ltcol1 [label="lsmb_group_grants_group_name_fkey"]; "lsmb_sequence":rtcol2 -> "defaults":ltcol1 [label="lsmb_sequence_setting_key_fkey"]; "makemodel":rtcol1 -> "parts":ltcol1 [label="makemodel_parts_id_fkey"]; "menu_acl":rtcol4 -> "menu_node":ltcol1 [label="menu_acl_node_id_fkey"]; "menu_attribute":rtcol1 -> "menu_node":ltcol1 [label="menu_attribute_node_id_fkey"]; "menu_node":rtcol3 -> "menu_node":ltcol1 [label="menu_node_parent_fkey"]; "mfg_lot":rtcol3 -> "parts":ltcol1 [label="mfg_lot_parts_id_fkey"]; "mfg_lot_item":rtcol2 -> "mfg_lot":ltcol1 [label="mfg_lot_item_mfg_lot_id_fkey"]; "mfg_lot_item":rtcol3 -> "parts":ltcol1 [label="mfg_lot_item_parts_id_fkey"]; "new_shipto":rtcol2 -> "transactions":ltcol1 [label="new_shipto_trans_id_fkey"]; "new_shipto":rtcol3 -> "oe":ltcol1 [label="new_shipto_oe_id_fkey"]; "new_shipto":rtcol4 -> "location":ltcol1 [label="new_shipto_location_id_fkey"]; "note":rtcol2 -> "note_class":ltcol1 [label="note_note_class_fkey"]; "oe":rtcol4 -> "entity":ltcol1 [label="oe_entity_id_fkey"]; "oe":rtcol12 -> "person":ltcol1 [label="oe_person_id_fkey"]; "oe":rtcol21 -> "entity_credit_account":ltcol1 [label="oe_entity_credit_account_fkey"]; "oe":rtcol22 -> "oe_class":ltcol1 [label="oe_oe_class_id_fkey"]; "open_forms":rtcol2 -> "session":ltcol1 [label="open_forms_session_id_fkey"]; "orderitems":rtcol3 -> "parts":ltcol1 [label="orderitems_parts_id_fkey"]; "parts":rtcol16 -> "account":ltcol1 [label="parts_inventory_accno_id_fkey"]; "parts":rtcol17 -> "account":ltcol1 [label="parts_income_accno_id_fkey"]; "parts":rtcol18 -> "account":ltcol1 [label="parts_expense_accno_id_fkey"]; "parts":rtcol19 -> "account":ltcol1 [label="parts_returns_accno_id_fkey"]; "parts_translation":rtcol1 -> "parts":ltcol1 [label="parts_translation_trans_id_fkey"]; "partscustomer":rtcol1 -> "parts":ltcol1 [label="partscustomer_parts_id_fkey"]; "partscustomer":rtcol2 -> "entity_credit_account":ltcol1 [label="partscustomer_credit_id_fkey"]; "partscustomer":rtcol3 -> "pricegroup":ltcol1 [label="partscustomer_pricegroup_id_fkey"]; "partsgroup":rtcol3 -> "partsgroup":ltcol1 [label="partsgroup_parent_fkey"]; "partsgroup_translation":rtcol1 -> "partsgroup":ltcol1 [label="partsgroup_translation_trans_id_fkey"]; "partstax":rtcol1 -> "parts":ltcol1 [label="partstax_parts_id_fkey"]; "partstax":rtcol2 -> "account":ltcol1 [label="partstax_chart_id_fkey"]; "partstax":rtcol3 -> "taxcategory":ltcol1 [label="partstax_taxcategory_id_fkey"]; "partsvendor":rtcol1 -> "entity_credit_account":ltcol1 [label="partsvendor_credit_id_fkey"]; "payment":rtcol3 -> "gl":ltcol1 [label="payment_gl_id_fkey"]; "payment":rtcol7 -> "entity_credit_account":ltcol1 [label="payment_entity_credit_id_fkey"]; "payment":rtcol8 -> "person":ltcol1 [label="payment_employee_id_fkey"]; "payment_links":rtcol1 -> "payment":ltcol1 [label="payment_links_payment_id_fkey"]; "payment_links":rtcol2 -> "acc_trans":ltcol14 [label="payment_links_entry_id_fkey"]; "payment_map":rtcol1 -> "journal_line":ltcol1 [label="payment_map_line_id_fkey"]; "payment_map":rtcol2 -> "eca_invoice":ltcol2 [label="payment_map_pays_fkey"]; "payroll_deduction":rtcol2 -> "entity":ltcol1 [label="payroll_deduction_entity_id_fkey"]; "payroll_deduction":rtcol3 -> "payroll_deduction_type":ltcol1 [label="payroll_deduction_type_id_fkey"]; "payroll_deduction_class":rtcol2 -> "country":ltcol1 [label="payroll_deduction_class_country_id_fkey"]; "payroll_deduction_type":rtcol2 -> "account":ltcol1 [label="payroll_deduction_type_account_id_fkey"]; "payroll_deduction_type":rtcol0 -> "payroll_deduction_class":ltcol0 [label="payroll_deduction_type_pdc_id_country_id_fkey"]; "payroll_employee_class_to_income_type":rtcol1 -> "payroll_employee_class":ltcol1 [label="payroll_employee_class_to_income_type_ec_id_fkey"]; "payroll_employee_class_to_income_type":rtcol2 -> "payroll_income_type":ltcol1 [label="payroll_employee_class_to_income_type_it_id_fkey"]; "payroll_income_class":rtcol2 -> "country":ltcol1 [label="payroll_income_class_country_id_fkey"]; "payroll_income_type":rtcol2 -> "account":ltcol1 [label="payroll_income_type_account_id_fkey"]; "payroll_income_type":rtcol0 -> "payroll_income_class":ltcol0 [label="payroll_income_type_pic_id_country_id_fkey"]; "payroll_paid_timeoff":rtcol1 -> "entity":ltcol1 [label="payroll_paid_timeoff_employee_id_fkey"]; "payroll_paid_timeoff":rtcol2 -> "payroll_pto_class":ltcol1 [label="payroll_paid_timeoff_pto_class_id_fkey"]; "payroll_paid_timeoff":rtcol3 -> "payroll_report":ltcol1 [label="payroll_paid_timeoff_report_id_fkey"]; "payroll_report":rtcol2 -> "payroll_employee_class":ltcol1 [label="payroll_report_ec_id_fkey"]; "payroll_report":rtcol4 -> "entity_employee":ltcol1 [label="payroll_report_created_by_fkey"]; "payroll_report":rtcol5 -> "entity_employee":ltcol1 [label="payroll_report_approved_by_fkey"]; "payroll_report_line":rtcol2 -> "payroll_report":ltcol1 [label="payroll_report_line_report_id_fkey"]; "payroll_report_line":rtcol3 -> "entity":ltcol1 [label="payroll_report_line_employee_id_fkey"]; "payroll_report_line":rtcol4 -> "payroll_income_type":ltcol1 [label="payroll_report_line_it_id_fkey"]; "payroll_wage":rtcol2 -> "entity":ltcol1 [label="payroll_wage_entity_id_fkey"]; "payroll_wage":rtcol3 -> "payroll_income_type":ltcol1 [label="payroll_wage_type_id_fkey"]; "person":rtcol2 -> "entity":ltcol1 [label="person_entity_id_fkey"]; "person":rtcol3 -> "salutation":ltcol1 [label="person_salutation_id_fkey"]; "person_to_company":rtcol1 -> "location":ltcol1 [label="person_to_company_location_id_fkey"]; "person_to_company":rtcol2 -> "person":ltcol1 [label="person_to_company_person_id_fkey"]; "person_to_company":rtcol3 -> "company":ltcol1 [label="person_to_company_company_id_fkey"]; "recurring":rtcol1 -> "transactions":ltcol1 [label="recurring_id_fkey"]; "recurringemail":rtcol1 -> "recurring":ltcol1 [label="recurringemail_id_fkey"]; "recurringprint":rtcol1 -> "recurring":ltcol1 [label="recurringprint_id_fkey"]; "robot":rtcol2 -> "entity":ltcol1 [label="robot_entity_id_fkey"]; "session":rtcol5 -> "users":ltcol1 [label="session_users_id_fkey"]; "tax":rtcol1 -> "account":ltcol1 [label="tax_chart_id_fkey"]; "tax":rtcol8 -> "taxmodule":ltcol1 [label="tax_taxmodule_id_fkey"]; "tax_extended":rtcol3 -> "acc_trans":ltcol14 [label="tax_extended_entry_id_fkey"]; "taxcategory":rtcol3 -> "taxmodule":ltcol1 [label="taxcategory_taxmodule_id_fkey"]; "template":rtcol3 -> "language":ltcol1 [label="template_language_code_fkey"]; "transactions":rtcol3 -> "session":ltcol1 [label="transactions_locked_by_fkey"]; "transactions":rtcol5 -> "entity":ltcol1 [label="transactions_approved_by_fkey"]; "user_preference":rtcol1 -> "users":ltcol1 [label="user_preference_id_fkey"]; "user_preference":rtcol2 -> "language":ltcol1 [label="user_preference_language_fkey"]; "users":rtcol4 -> "entity":ltcol1 [label="users_entity_id_fkey"]; "voucher":rtcol1 -> "transactions":ltcol1 [label="voucher_trans_id_fkey"]; "voucher":rtcol2 -> "batch":ltcol1 [label="voucher_batch_id_fkey"]; "voucher":rtcol4 -> "batch_class":ltcol1 [label="voucher_batch_class_fkey"]; "warehouse_inventory":rtcol1 -> "entity_employee":ltcol1 [label="warehouse_inventory_entity_id_fkey"]; "yearend":rtcol1 -> "gl":ltcol1 [label="yearend_trans_id_fkey"]; }