summaryrefslogtreecommitdiff
path: root/doc/database/ledgersmb.dot
diff options
context:
space:
mode:
Diffstat (limited to 'doc/database/ledgersmb.dot')
-rw-r--r--doc/database/ledgersmb.dot114
1 files changed, 93 insertions, 21 deletions
diff --git a/doc/database/ledgersmb.dot b/doc/database/ledgersmb.dot
index 96c7749e..9913c1c1 100644
--- a/doc/database/ledgersmb.dot
+++ b/doc/database/ledgersmb.dot
@@ -13,67 +13,99 @@ edge [
"acc_trans" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > source </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > cleared </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > fx_transaction </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > memo </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > invoice_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> </TABLE>> ];
-"ap" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
+"ap" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
-"ar" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
+"ar" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
"assembly" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > bom </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > adj </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ];
-"audittrail" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > tablename </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > action </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > transdate </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+"audittrail" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > tablename </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > action </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > transdate </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
-"business" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+"business" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
-"chart" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > charttype </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > category </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > link </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > contra </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+"chart" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > charttype </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > category </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > link </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > contra </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+
+"company" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > legal_name </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > entity_class_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > primary_location_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > tax_id </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ];
+
+"company_to_contact" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > company_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > contact_class_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > contact </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"company_to_entity" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > company_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > related_how </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > created </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+
+"company_to_location" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > location_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > company_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"contact_class" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > class </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"country" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > short_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > itu </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
"custom_field_catalog" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > field_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > table_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > field_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
"custom_table_catalog" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > table_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > extends </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > table_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
-"customer" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > contact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > phone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > fax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > customernumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > taxnumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> <TR><TD PORT="ltcol28" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol28"> </TD></TR> <TR><TD PORT="ltcol29" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol29"> </TD></TR> <TR><TD PORT="ltcol30" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol30"> </TD></TR> <TR><TD PORT="ltcol31" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol31"> </TD></TR> </TABLE>> ];
+"customer" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > customernumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > invoice_notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> </TABLE>> ];
"customertax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
"defaults" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > setting_key </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"department" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > role </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+"department" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > role </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
"dpt_trans" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"employee" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > login </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > workphone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > homephone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > role </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > sales </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > ssn </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > managerid </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > employeenumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > dob </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> </TABLE>> ];
+"employee" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > login </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > role </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > sales </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > ssn </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > managerid </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > employeenumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > dob </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> </TABLE>> ];
+
+"entity" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > entity_class </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"entity_class" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > class </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > active </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"entity_class_to_entity" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > entity_class_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"entity_other_name" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > other_name </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
"exchangerate" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > buy </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > sell </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
"gifi" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > accno </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"gl" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+"gl" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
-"inventory" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > warehouse_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > orderitems_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > shippingdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+"inventory" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > warehouse_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > orderitems_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > shippingdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
-"invoice" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > discount </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > assemblyitem </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > deliverydate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> </TABLE>> ];
+"invoice" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > discount </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > assemblyitem </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > deliverydate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> </TABLE>> ];
-"jcitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > checkedin </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > checkedout </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+"jcitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > checkedin </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > checkedout </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
"language" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+"location" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > line_one </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > line_two </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > line_three </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > city_province </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > country_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > mail_code </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+
"makemodel" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > make </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > model </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
-"oe" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > closed </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > quotation </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> </TABLE>> ];
+"oe" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > closed </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > quotation </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > oe_class_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol22"> </TD></TR> </TABLE>> ];
-"orderitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > ship </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+"oe_class" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > oe_class </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"parts" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > listprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > priceupdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > weight </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > onhand </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > makemodel </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > assembly </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > alternate </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > rop </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > inventory_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > income_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > expense_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > bin </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > obsolete </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > bom </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > image </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > drawing </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > microfiche </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > partsgroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > avgcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> </TABLE>> ];
+"orderitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > ship </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+
+"parts" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > listprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > priceupdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > weight </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > onhand </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > makemodel </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > assembly </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > alternate </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > rop </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > inventory_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > income_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > expense_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > bin </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > obsolete </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > bom </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > image </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > drawing </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > microfiche </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > partsgroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > avgcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> </TABLE>> ];
"partscustomer" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > pricebreak </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > validfrom </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > validto </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
-"partsgroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partsgroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+"partsgroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partsgroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
"partstax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > taxcategory_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
-"partsvendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > leadtime </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+"partsvendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > leadtime </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+
+"person" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > salutation_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > first_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > middle_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > last_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > primary_location_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
-"pricegroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > pricegroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+"person_to_company" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > location_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"project" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > projectnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > production </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > completed </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
+"person_to_contact" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > contact_class_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > contact </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"person_to_entity" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > person_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > related_how </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > created </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+
+"pricegroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > pricegroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"project" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > projectnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > production </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > completed </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
"recurring" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > nextdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > repeat </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > howmany </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > payment </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
@@ -81,6 +113,8 @@ edge [
"recurringprint" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > format </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > printer </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+"salutation" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > salutation </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
"shipto" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > shiptoname </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > shiptoaddress1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > shiptoaddress2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > shiptocity </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > shiptostate </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > shiptozipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > shiptocountry </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > shiptocontact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > shiptophone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > shiptofax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > shiptoemail </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
"sic" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > sictype </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
@@ -97,22 +131,60 @@ edge [
"translation" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
-"vendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > contact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > phone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > fax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > vendornumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > character varying(30) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > taxnumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> <TR><TD PORT="ltcol28" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol28"> </TD></TR> <TR><TD PORT="ltcol29" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol29"> </TD></TR> <TR><TD PORT="ltcol30" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol30"> </TD></TR> <TR><TD PORT="ltcol31" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol31"> </TD></TR> <TR><TD PORT="ltcol32" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol32"> </TD></TR> </TABLE>> ];
+"vendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > entity_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > vendornumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > character varying(30) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > taxnumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> </TABLE>> ];
"vendortax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
-"warehouse" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+"warehouse" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
"yearend" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
"acc_trans":rtcol2 -> "chart":ltcol1 [label="acc_trans_chart_id_fkey"];
+"ap":rtcol4 -> "entity":ltcol1 [label="ap_entity_id_fkey"];
+"ap":rtcol15 -> "person":ltcol1 [label="ap_person_id_fkey"];
+"ar":rtcol4 -> "entity":ltcol1 [label="ar_entity_id_fkey"];
+"ar":rtcol17 -> "person":ltcol1 [label="ar_person_id_fkey"];
+"audittrail":rtcol7 -> "person":ltcol1 [label="audittrail_person_id_fkey"];
+"company":rtcol2 -> "entity":ltcol1 [label="company_entity_id_fkey"];
+"company":rtcol4 -> "entity_class":ltcol1 [label="company_entity_class_id_fkey"];
+"company":rtcol5 -> "location":ltcol1 [label="company_primary_location_id_fkey"];
+"company_to_contact":rtcol1 -> "company":ltcol1 [label="company_to_contact_company_id_fkey"];
+"company_to_contact":rtcol2 -> "contact_class":ltcol1 [label="company_to_contact_contact_class_id_fkey"];
+"company_to_entity":rtcol1 -> "company":ltcol1 [label="company_to_entity_company_id_fkey"];
+"company_to_entity":rtcol2 -> "entity":ltcol1 [label="company_to_entity_entity_id_fkey"];
+"company_to_location":rtcol1 -> "location":ltcol1 [label="company_to_location_location_id_fkey"];
+"company_to_location":rtcol2 -> "company":ltcol1 [label="company_to_location_company_id_fkey"];
"custom_field_catalog":rtcol2 -> "custom_table_catalog":ltcol1 [label="custom_field_catalog_table_id_fkey"];
+"customer":rtcol2 -> "entity":ltcol1 [label="customer_entity_id_fkey"];
+"employee":rtcol2 -> "entity":ltcol1 [label="employee_entity_id_fkey"];
+"entity":rtcol3 -> "entity_class":ltcol1 [label="entity_entity_class_fkey"];
+"entity_class_to_entity":rtcol1 -> "entity_class":ltcol1 [label="entity_class_to_entity_entity_class_id_fkey"];
+"entity_class_to_entity":rtcol2 -> "entity":ltcol1 [label="entity_class_to_entity_entity_id_fkey"];
+"entity_other_name":rtcol1 -> "entity":ltcol1 [label="entity_other_name_entity_id_fkey"];
+"gl":rtcol5 -> "person":ltcol1 [label="gl_person_id_fkey"];
+"inventory":rtcol7 -> "person":ltcol1 [label="inventory_person_id_fkey"];
+"jcitems":rtcol12 -> "person":ltcol1 [label="jcitems_person_id_fkey"];
+"location":rtcol6 -> "country":ltcol1 [label="location_country_id_fkey"];
+"oe":rtcol4 -> "entity":ltcol1 [label="oe_entity_id_fkey"];
+"oe":rtcol12 -> "person":ltcol1 [label="oe_person_id_fkey"];
+"oe":rtcol22 -> "oe_class":ltcol1 [label="oe_oe_class_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"];
+"partsvendor":rtcol1 -> "entity":ltcol1 [label="partsvendor_entity_id_fkey"];
+"person":rtcol2 -> "entity":ltcol1 [label="person_entity_id_fkey"];
+"person":rtcol3 -> "salutation":ltcol1 [label="person_salutation_id_fkey"];
+"person":rtcol7 -> "location":ltcol1 [label="person_primary_location_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_contact":rtcol1 -> "person":ltcol1 [label="person_to_contact_person_id_fkey"];
+"person_to_contact":rtcol2 -> "contact_class":ltcol1 [label="person_to_contact_contact_class_id_fkey"];
+"person_to_entity":rtcol1 -> "person":ltcol1 [label="person_to_entity_person_id_fkey"];
+"person_to_entity":rtcol2 -> "entity":ltcol1 [label="person_to_entity_entity_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"];
+"vendor":rtcol2 -> "entity":ltcol1 [label="vendor_entity_id_fkey"];
}
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-22 10:59:21 +0000