summaryrefslogtreecommitdiff
path: root/doc/database/ledgersmb.neato
blob: 278993c7dd738237b5eb15a5f25b47a37017bcc1 (plain) 
    

  1. digraph g {
    2. 

  2. node [ fontsize = "10", shape = record ];
    3. 

  3. edge [];
    4. 

  4. 

  5. "acc_trans" [shape = record, label = "{<col0> \N| trans_id:  integer\lchart_id:  integer\lamount:  numeric\ltransdate:  date\lsource:  text\lcleared:  boolean\lfx_transaction:  boolean\lproject_id:  integer\lmemo:  text\linvoice_id:  integer\lentry_id:  serial\l}" ];
    6. 

  6. 

  7. "ap" [shape = record, label = "{<col0> \N| id:  integer\linvnumber:  text\ltransdate:  date\lvendor_id:  integer\ltaxincluded:  boolean\lamount:  numeric\lnetamount:  numeric\lpaid:  numeric\ldatepaid:  date\lduedate:  date\linvoice:  boolean\lordnumber:  text\lcurr:  character(3)\lnotes:  text\lemployee_id:  integer\ltill:  character varying(20)\lquonumber:  text\lintnotes:  text\ldepartment_id:  integer\lshipvia:  text\llanguage_code:  character varying(6)\lponumber:  text\lshippingpoint:  text\lterms:  smallint\l}" ];
    8. 

  8. 

  9. "ar" [shape = record, label = "{<col0> \N| id:  integer\linvnumber:  text\ltransdate:  date\lcustomer_id:  integer\ltaxincluded:  boolean\lamount:  numeric\lnetamount:  numeric\lpaid:  numeric\ldatepaid:  date\lduedate:  date\linvoice:  boolean\lshippingpoint:  text\lterms:  smallint\lnotes:  text\lcurr:  character(3)\lordnumber:  text\lemployee_id:  integer\ltill:  character varying(20)\lquonumber:  text\lintnotes:  text\ldepartment_id:  integer\lshipvia:  text\llanguage_code:  character varying(6)\lponumber:  text\l}" ];
    10. 

  10. 

  11. "assembly" [shape = record, label = "{<col0> \N| id:  integer\lparts_id:  integer\lqty:  numeric\lbom:  boolean\ladj:  boolean\l}" ];
    12. 

  12. 

  13. "audittrail" [shape = record, label = "{<col0> \N| trans_id:  integer\ltablename:  text\lreference:  text\lformname:  text\laction:  text\ltransdate:  timestamp without time zone\lemployee_id:  integer\lentry_id:  bigserial\l}" ];
    14. 

  14. 

  15. "business" [shape = record, label = "{<col0> \N| id:  integer\ldescription:  text\ldiscount:  numeric\l}" ];
    16. 

  16. 

  17. "chart" [shape = record, label = "{<col0> \N| id:  integer\laccno:  text\ldescription:  text\lcharttype:  character(1)\lcategory:  character(1)\llink:  text\lgifi_accno:  text\lcontra:  boolean\l}" ];
    18. 

  18. 

  19. "custom_field_catalog" [shape = record, label = "{<col0> \N| field_id:  serial\ltable_id:  integer\lfield_name:  text\l}" ];
    20. 

  20. 

  21. "custom_table_catalog" [shape = record, label = "{<col0> \N| table_id:  serial\lextends:  text\ltable_name:  text\l}" ];
    22. 

  22. 

  23. "customer" [shape = record, label = "{<col0> \N| id:  integer\lname:  character varying(64)\laddress1:  character varying(32)\laddress2:  character varying(32)\lcity:  character varying(32)\lstate:  character varying(32)\lzipcode:  character varying(10)\lcountry:  character varying(32)\lcontact:  character varying(64)\lphone:  character varying(20)\lfax:  character varying(20)\lemail:  text\lnotes:  text\ldiscount:  numeric\ltaxincluded:  boolean\lcreditlimit:  numeric\lterms:  smallint\lcustomernumber:  character varying(32)\lcc:  text\lbcc:  text\lbusiness_id:  integer\ltaxnumber:  character varying(32)\lsic_code:  character varying(6)\liban:  character varying(34)\lbic:  character varying(11)\lemployee_id:  integer\llanguage_code:  character varying(6)\lpricegroup_id:  integer\lcurr:  character(3)\lstartdate:  date\lenddate:  date\l}" ];
    24. 

  24. 

  25. "customertax" [shape = record, label = "{<col0> \N| customer_id:  integer\lchart_id:  integer\l}" ];
    26. 

  26. 

  27. "defaults" [shape = record, label = "{<col0> \N| setting_key:  text\lvalue:  text\l}" ];
    28. 

  28. 

  29. "department" [shape = record, label = "{<col0> \N| id:  integer\ldescription:  text\lrole:  character(1)\l}" ];
    30. 

  30. 

  31. "dpt_trans" [shape = record, label = "{<col0> \N| trans_id:  integer\ldepartment_id:  integer\l}" ];
    32. 

  32. 

  33. "employee" [shape = record, label = "{<col0> \N| id:  integer\llogin:  text\lname:  character varying(64)\laddress1:  character varying(32)\laddress2:  character varying(32)\lcity:  character varying(32)\lstate:  character varying(32)\lzipcode:  character varying(10)\lcountry:  character varying(32)\lworkphone:  character varying(20)\lhomephone:  character varying(20)\lstartdate:  date\lenddate:  date\lnotes:  text\lrole:  character varying(20)\lsales:  boolean\lemail:  text\lssn:  character varying(20)\liban:  character varying(34)\lbic:  character varying(11)\lmanagerid:  integer\lemployeenumber:  character varying(32)\ldob:  date\l}" ];
    34. 

  34. 

  35. "exchangerate" [shape = record, label = "{<col0> \N| curr:  character(3)\ltransdate:  date\lbuy:  numeric\lsell:  numeric\l}" ];
    36. 

  36. 

  37. "gifi" [shape = record, label = "{<col0> \N| accno:  text\ldescription:  text\l}" ];
    38. 

  38. 

  39. "gl" [shape = record, label = "{<col0> \N| id:  integer\lreference:  text\ldescription:  text\ltransdate:  date\lemployee_id:  integer\lnotes:  text\ldepartment_id:  integer\l}" ];
    40. 

  40. 

  41. "inventory" [shape = record, label = "{<col0> \N| warehouse_id:  integer\lparts_id:  integer\ltrans_id:  integer\lorderitems_id:  integer\lqty:  numeric\lshippingdate:  date\lemployee_id:  integer\lentry_id:  serial\l}" ];
    42. 

  42. 

  43. "invoice" [shape = record, label = "{<col0> \N| id:  integer\ltrans_id:  integer\lparts_id:  integer\ldescription:  text\lqty:  integer\lallocated:  integer\lsellprice:  numeric\lfxsellprice:  numeric\ldiscount:  real\lassemblyitem:  boolean\lunit:  character varying(5)\lproject_id:  integer\ldeliverydate:  date\lserialnumber:  text\lnotes:  text\l}" ];
    44. 

  44. 

  45. "jcitems" [shape = record, label = "{<col0> \N| id:  integer\lproject_id:  integer\lparts_id:  integer\ldescription:  text\lqty:  numeric\lallocated:  numeric\lsellprice:  numeric\lfxsellprice:  numeric\lserialnumber:  text\lcheckedin:  timestamp with time zone\lcheckedout:  timestamp with time zone\lemployee_id:  integer\lnotes:  text\l}" ];
    46. 

  46. 

  47. "language" [shape = record, label = "{<col0> \N| code:  character varying(6)\ldescription:  text\l}" ];
    48. 

  48. 

  49. "makemodel" [shape = record, label = "{<col0> \N| parts_id:  integer\lmake:  text\lmodel:  text\l}" ];
    50. 

  50. 

  51. "oe" [shape = record, label = "{<col0> \N| id:  integer\lordnumber:  text\ltransdate:  date\lvendor_id:  integer\lcustomer_id:  integer\lamount:  numeric\lnetamount:  numeric\lreqdate:  date\ltaxincluded:  boolean\lshippingpoint:  text\lnotes:  text\lcurr:  character(3)\lemployee_id:  integer\lclosed:  boolean\lquotation:  boolean\lquonumber:  text\lintnotes:  text\ldepartment_id:  integer\lshipvia:  text\llanguage_code:  character varying(6)\lponumber:  text\lterms:  smallint\l}" ];
    52. 

  52. 

  53. "orderitems" [shape = record, label = "{<col0> \N| id:  integer\ltrans_id:  integer\lparts_id:  integer\ldescription:  text\lqty:  numeric\lsellprice:  numeric\ldiscount:  numeric\lunit:  character varying(5)\lproject_id:  integer\lreqdate:  date\lship:  numeric\lserialnumber:  text\lnotes:  text\l}" ];
    54. 

  54. 

  55. "parts" [shape = record, label = "{<col0> \N| id:  integer\lpartnumber:  text\ldescription:  text\lunit:  character varying(5)\llistprice:  numeric\lsellprice:  numeric\llastcost:  numeric\lpriceupdate:  date\lweight:  numeric\lonhand:  numeric\lnotes:  text\lmakemodel:  boolean\lassembly:  boolean\lalternate:  boolean\lrop:  real\linventory_accno_id:  integer\lincome_accno_id:  integer\lexpense_accno_id:  integer\lbin:  text\lobsolete:  boolean\lbom:  boolean\limage:  text\ldrawing:  text\lmicrofiche:  text\lpartsgroup_id:  integer\lproject_id:  integer\lavgcost:  numeric\l}" ];
    56. 

  56. 

  57. "partscustomer" [shape = record, label = "{<col0> \N| parts_id:  integer\lcustomer_id:  integer\lpricegroup_id:  integer\lpricebreak:  numeric\lsellprice:  numeric\lvalidfrom:  date\lvalidto:  date\lcurr:  character(3)\lentry_id:  serial\l}" ];
    58. 

  58. 

  59. "partsgroup" [shape = record, label = "{<col0> \N| id:  integer\lpartsgroup:  text\l}" ];
    60. 

  60. 

  61. "partstax" [shape = record, label = "{<col0> \N| parts_id:  integer\lchart_id:  integer\ltaxcategory_id:  integer\l}" ];
    62. 

  62. 

  63. "partsvendor" [shape = record, label = "{<col0> \N| vendor_id:  integer\lparts_id:  integer\lpartnumber:  text\lleadtime:  smallint\llastcost:  numeric\lcurr:  character(3)\lentry_id:  serial\l}" ];
    64. 

  64. 

  65. "pricegroup" [shape = record, label = "{<col0> \N| id:  integer\lpricegroup:  text\l}" ];
    66. 

  66. 

  67. "project" [shape = record, label = "{<col0> \N| id:  integer\lprojectnumber:  text\ldescription:  text\lstartdate:  date\lenddate:  date\lparts_id:  integer\lproduction:  numeric\lcompleted:  numeric\lcustomer_id:  integer\l}" ];
    68. 

  68. 

  69. "recurring" [shape = record, label = "{<col0> \N| id:  integer\lreference:  text\lstartdate:  date\lnextdate:  date\lenddate:  date\lrepeat:  smallint\lunit:  character varying(6)\lhowmany:  integer\lpayment:  boolean\l}" ];
    70. 

  70. 

  71. "recurringemail" [shape = record, label = "{<col0> \N| id:  integer\lformname:  text\lformat:  text\lmessage:  text\l}" ];
    72. 

  72. 

  73. "recurringprint" [shape = record, label = "{<col0> \N| id:  integer\lformname:  text\lformat:  text\lprinter:  text\l}" ];
    74. 

  74. 

  75. "shipto" [shape = record, label = "{<col0> \N| trans_id:  integer\lshiptoname:  character varying(64)\lshiptoaddress1:  character varying(32)\lshiptoaddress2:  character varying(32)\lshiptocity:  character varying(32)\lshiptostate:  character varying(32)\lshiptozipcode:  character varying(10)\lshiptocountry:  character varying(32)\lshiptocontact:  character varying(64)\lshiptophone:  character varying(20)\lshiptofax:  character varying(20)\lshiptoemail:  text\lentry_id:  serial\l}" ];
    76. 

  76. 

  77. "sic" [shape = record, label = "{<col0> \N| code:  character varying(6)\lsictype:  character(1)\ldescription:  text\l}" ];
    78. 

  78. 

  79. "status" [shape = record, label = "{<col0> \N| trans_id:  integer\lformname:  text\lprinted:  boolean\lemailed:  boolean\lspoolfile:  text\l}" ];
    80. 

  80. 

  81. "tax" [shape = record, label = "{<col0> \N| chart_id:  integer\lrate:  numeric\ltaxnumber:  text\lvalidto:  date\lpass:  integer\ltaxmodule_id:  integer\l}" ];
    82. 

  82. 

  83. "taxcategory" [shape = record, label = "{<col0> \N| taxcategory_id:  serial\ltaxcategoryname:  text\ltaxmodule_id:  integer\l}" ];
    84. 

  84. 

  85. "taxmodule" [shape = record, label = "{<col0> \N| taxmodule_id:  serial\ltaxmodulename:  text\l}" ];
    86. 

  86. 

  87. "transactions" [shape = record, label = "{<col0> \N| id:  integer\ltable_name:  text\l}" ];
    88. 

  88. 

  89. "translation" [shape = record, label = "{<col0> \N| trans_id:  integer\llanguage_code:  character varying(6)\ldescription:  text\l}" ];
    90. 

  90. 

  91. "vendor" [shape = record, label = "{<col0> \N| id:  integer\lname:  character varying(64)\laddress1:  character varying(32)\laddress2:  character varying(32)\lcity:  character varying(32)\lstate:  character varying(32)\lzipcode:  character varying(10)\lcountry:  character varying(32)\lcontact:  character varying(64)\lphone:  character varying(20)\lfax:  character varying(20)\lemail:  text\lnotes:  text\lterms:  smallint\ltaxincluded:  boolean\lvendornumber:  character varying(32)\lcc:  text\lbcc:  text\lgifi_accno:  character varying(30)\lbusiness_id:  integer\ltaxnumber:  character varying(32)\lsic_code:  character varying(6)\ldiscount:  numeric\lcreditlimit:  numeric\liban:  character varying(34)\lbic:  character varying(11)\lemployee_id:  integer\llanguage_code:  character varying(6)\lpricegroup_id:  integer\lcurr:  character(3)\lstartdate:  date\lenddate:  date\l}" ];
    92. 

  92. 

  93. "vendortax" [shape = record, label = "{<col0> \N| vendor_id:  integer\lchart_id:  integer\l}" ];
    94. 

  94. 

  95. "warehouse" [shape = record, label = "{<col0> \N| id:  integer\ldescription:  text\l}" ];
    96. 

  96. 

  97. "yearend" [shape = record, label = "{<col0> \N| trans_id:  integer\ltransdate:  date\l}" ];
    98. 

  98. 

  99. 

  100. "acc_trans" -> "chart" [label="acc_trans_chart_id_fkey"];
    101. 

  101. "custom_field_catalog" -> "custom_table_catalog" [label="custom_field_catalog_table_id_fkey"];
    102. 

  102. "partstax" -> "parts" [label="partstax_parts_id_fkey"];
    103. 

  103. "partstax" -> "chart" [label="partstax_chart_id_fkey"];
    104. 

  104. "partstax" -> "taxcategory" [label="partstax_taxcategory_id_fkey"];
    105. 

  105. "tax" -> "chart" [label="tax_chart_id_fkey"];
    106. 

  106. "tax" -> "taxmodule" [label="tax_taxmodule_id_fkey"];
    107. 

  107. "taxcategory" -> "taxmodule" [label="taxcategory_taxmodule_id_fkey"];
    108. 

  108. }
    109. 

  109. 

  110.
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-22 10:57:59 +0000