digraph g { graph [ rankdir = "LR", concentrate = true, ratio = auto ]; node [ fontsize = "10", shape = record ]; edge [ ]; "acc_trans" [shape = plaintext, label = <
\N
trans_id integer
chart_id integer FK
amount numeric
transdate date
source text
cleared boolean
fx_transaction boolean
project_id integer
memo text
invoice_id integer
entry_id serial PK
> ]; "ap" [shape = plaintext, label = <
\N
id integer PK
invnumber text
transdate date
vendor_id integer
taxincluded boolean
amount numeric
netamount numeric
paid numeric
datepaid date
duedate date
invoice boolean
ordnumber text
curr character(3)
notes text
employee_id integer
till character varying(20)
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
shippingpoint text
terms smallint
> ]; "ar" [shape = plaintext, label = <
\N
id integer PK
invnumber text
transdate date
customer_id integer
taxincluded boolean
amount numeric
netamount numeric
paid numeric
datepaid date
duedate date
invoice boolean
shippingpoint text
terms smallint
notes text
curr character(3)
ordnumber text
employee_id integer
till character varying(20)
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
> ]; "assembly" [shape = plaintext, label = <
\N
id integer PK
parts_id integer PK
qty numeric
bom boolean
adj boolean
> ]; "audittrail" [shape = plaintext, label = <
\N
trans_id integer
tablename text
reference text
formname text
action text
transdate timestamp without time zone
employee_id integer
entry_id bigserial PK
> ]; "business" [shape = plaintext, label = <
\N
id integer PK
description text
discount numeric
> ]; "chart" [shape = plaintext, label = <
\N
id integer PK
accno text
description text
charttype character(1)
category character(1)
link text
gifi_accno text
contra 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
> ]; "customer" [shape = plaintext, label = <
\N
id integer PK
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
contact character varying(64)
phone character varying(20)
fax character varying(20)
email text
notes text
discount numeric
taxincluded boolean
creditlimit numeric
terms smallint
customernumber character varying(32)
cc text
bcc text
business_id integer
taxnumber character varying(32)
sic_code character varying(6)
iban character varying(34)
bic character varying(11)
employee_id integer
language_code character varying(6)
pricegroup_id integer
curr character(3)
startdate date
enddate date
> ]; "customertax" [shape = plaintext, label = <
\N
customer_id integer PK
chart_id integer PK
> ]; "defaults" [shape = plaintext, label = <
\N
setting_key text PK
value text
> ]; "department" [shape = plaintext, label = <
\N
id integer PK
description text
role character(1)
> ]; "dpt_trans" [shape = plaintext, label = <
\N
trans_id integer PK
department_id integer
> ]; "employee" [shape = plaintext, label = <
\N
id integer PK
login text
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
workphone character varying(20)
homephone character varying(20)
startdate date
enddate date
notes text
role character varying(20)
sales boolean
email text
ssn character varying(20)
iban character varying(34)
bic character varying(11)
managerid integer
employeenumber character varying(32)
dob date
> ]; "exchangerate" [shape = plaintext, label = <
\N
curr character(3) PK
transdate date PK
buy numeric
sell numeric
> ]; "gifi" [shape = plaintext, label = <
\N
accno text PK
description text
> ]; "gl" [shape = plaintext, label = <
\N
id integer PK
reference text
description text
transdate date
employee_id integer
notes text
department_id integer
> ]; "inventory" [shape = plaintext, label = <
\N
warehouse_id integer
parts_id integer
trans_id integer
orderitems_id integer
qty numeric
shippingdate date
employee_id integer
entry_id serial PK
> ]; "invoice" [shape = plaintext, label = <
\N
id integer PK
trans_id integer
parts_id integer
description text
qty integer
allocated integer
sellprice numeric
fxsellprice numeric
discount real
assemblyitem boolean
unit character varying(5)
project_id integer
deliverydate date
serialnumber text
notes text
> ]; "jcitems" [shape = plaintext, label = <
\N
id integer PK
project_id integer
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
employee_id integer
notes text
> ]; "language" [shape = plaintext, label = <
\N
code character varying(6) PK
description text
> ]; "makemodel" [shape = plaintext, label = <
\N
parts_id integer PK
make text
model text
> ]; "oe" [shape = plaintext, label = <
\N
id integer PK
ordnumber text
transdate date
vendor_id integer
customer_id integer
amount numeric
netamount numeric
reqdate date
taxincluded boolean
shippingpoint text
notes text
curr character(3)
employee_id integer
closed boolean
quotation boolean
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
terms smallint
> ]; "orderitems" [shape = plaintext, label = <
\N
id integer PK
trans_id integer
parts_id integer
description text
qty numeric
sellprice numeric
discount numeric
unit character varying(5)
project_id integer
reqdate date
ship numeric
serialnumber text
notes text
> ]; "parts" [shape = plaintext, label = <
\N
id integer 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 real
inventory_accno_id integer
income_accno_id integer
expense_accno_id integer
bin text
obsolete boolean
bom boolean
image text
drawing text
microfiche text
partsgroup_id integer
project_id integer
avgcost numeric
> ]; "partscustomer" [shape = plaintext, label = <
\N
parts_id integer
customer_id integer
pricegroup_id integer
pricebreak numeric
sellprice numeric
validfrom date
validto date
curr character(3)
entry_id serial PK
> ]; "partsgroup" [shape = plaintext, label = <
\N
id integer PK
partsgroup 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
vendor_id integer
parts_id integer
partnumber text
leadtime smallint
lastcost numeric
curr character(3)
entry_id serial PK
> ]; "pricegroup" [shape = plaintext, label = <
\N
id integer PK
pricegroup text
> ]; "project" [shape = plaintext, label = <
\N
id integer PK
projectnumber text
description text
startdate date
enddate date
parts_id integer
production numeric
completed numeric
customer_id integer
> ]; "recurring" [shape = plaintext, label = <
\N
id integer PK
reference text
startdate date
nextdate date
enddate date
repeat smallint
unit character varying(6)
howmany integer
payment boolean
> ]; "recurringemail" [shape = plaintext, label = <
\N
id integer PK
formname text
format text
message text
> ]; "recurringprint" [shape = plaintext, label = <
\N
id integer PK
formname text
format text
printer text
> ]; "shipto" [shape = plaintext, label = <
\N
trans_id integer
shiptoname character varying(64)
shiptoaddress1 character varying(32)
shiptoaddress2 character varying(32)
shiptocity character varying(32)
shiptostate character varying(32)
shiptozipcode character varying(10)
shiptocountry character varying(32)
shiptocontact character varying(64)
shiptophone character varying(20)
shiptofax character varying(20)
shiptoemail text
entry_id serial PK
> ]; "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
printed boolean
emailed boolean
spoolfile text
> ]; "tax" [shape = plaintext, label = <
\N
chart_id integer PK FK
rate numeric
taxnumber text
validto date
pass integer
taxmodule_id integer 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
> ]; "transactions" [shape = plaintext, label = <
\N
id integer PK
table_name text
> ]; "translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; "vendor" [shape = plaintext, label = <
\N
id integer PK
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
contact character varying(64)
phone character varying(20)
fax character varying(20)
email text
notes text
terms smallint
taxincluded boolean
vendornumber character varying(32)
cc text
bcc text
gifi_accno character varying(30)
business_id integer
taxnumber character varying(32)
sic_code character varying(6)
discount numeric
creditlimit numeric
iban character varying(34)
bic character varying(11)
employee_id integer
language_code character varying(6)
pricegroup_id integer
curr character(3)
startdate date
enddate date
> ]; "vendortax" [shape = plaintext, label = <
\N
vendor_id integer PK
chart_id integer PK
> ]; "warehouse" [shape = plaintext, label = <
\N
id integer PK
description text
> ]; "yearend" [shape = plaintext, label = <
\N
trans_id integer PK
transdate date
> ]; "acc_trans":rtcol2 -> "chart":ltcol1 [label="acc_trans_chart_id_fkey"]; "custom_field_catalog":rtcol2 -> "custom_table_catalog":ltcol1 [label="custom_field_catalog_table_id_fkey"]; "partstax":rtcol1 -> "parts":ltcol1 [label="partstax_parts_id_fkey"]; "partstax":rtcol2 -> "chart":ltcol1 [label="partstax_chart_id_fkey"]; "partstax":rtcol3 -> "taxcategory":ltcol1 [label="partstax_taxcategory_id_fkey"]; "tax":rtcol1 -> "chart":ltcol1 [label="tax_chart_id_fkey"]; "tax":rtcol6 -> "taxmodule":ltcol1 [label="tax_taxmodule_id_fkey"]; "taxcategory":rtcol3 -> "taxmodule":ltcol1 [label="taxcategory_taxmodule_id_fkey"]; }