summaryrefslogtreecommitdiff
path: root/doc/database/ledgersmb.neato
blob: cea533cc87a45a37fd0877c4bbfc0212f18737b2 (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:  serial\linvnumber:  text\ltransdate:  date\lentity_id:  integer\ltaxincluded:  boolean\lamount:  numeric\lnetamount:  numeric\lpaid:  numeric\ldatepaid:  date\lduedate:  date\linvoice:  boolean\lordnumber:  text\lcurr:  character(3)\lnotes:  text\lperson_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:  serial\linvnumber:  text\ltransdate:  date\lentity_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\lperson_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\lperson_id:  integer\lentry_id:  bigserial\l}" ];
    14. 

  14. 

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

  16. 

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

  18. 

  19. "company" [shape = record, label = "{<col0> \N| id:  serial\lentity_id:  integer\llegal_name:  text\lentity_class_id:  integer\lprimary_location_id:  integer\ltax_id:  text\l}" ];
    20. 

  20. 

  21. "company_to_contact" [shape = record, label = "{<col0> \N| company_id:  integer\lcontact_class_id:  integer\lcontact:  text\l}" ];
    22. 

  22. 

  23. "company_to_entity" [shape = record, label = "{<col0> \N| company_id:  integer\lentity_id:  integer\lrelated_how:  text\lcreated:  date\l}" ];
    24. 

  24. 

  25. "company_to_location" [shape = record, label = "{<col0> \N| location_id:  integer\lcompany_id:  integer\l}" ];
    26. 

  26. 

  27. "contact_class" [shape = record, label = "{<col0> \N| id:  serial\lclass:  text\l}" ];
    28. 

  28. 

  29. "country" [shape = record, label = "{<col0> \N| id:  serial\lname:  text\lshort_name:  text\litu:  text\l}" ];
    30. 

  30. 

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

  32. 

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

  34. 

  35. "customer" [shape = record, label = "{<col0> \N| id:  serial\lentity_id:  integer\ldiscount:  numeric\ltaxincluded:  boolean\lcreditlimit:  numeric\lterms:  smallint\lcustomernumber:  character varying(32)\lcc:  text\lbcc:  text\lbusiness_id:  integer\lsic_code:  character varying(6)\liban:  character varying(34)\lbic:  character varying(11)\llanguage_code:  character varying(6)\lpricegroup_id:  integer\lcurr:  character(3)\lstartdate:  date\lenddate:  date\linvoice_notes:  text\l}" ];
    36. 

  36. 

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

  38. 

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

  40. 

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

  42. 

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

  44. 

  45. "employee" [shape = record, label = "{<col0> \N| id:  serial\lentity_id:  integer\llogin:  text\lstartdate:  date\lenddate:  date\lnotes:  text\lrole:  character varying(20)\lsales:  boolean\lssn:  character varying(20)\liban:  character varying(34)\lbic:  character varying(11)\lmanagerid:  integer\lemployeenumber:  character varying(32)\ldob:  date\l}" ];
    46. 

  46. 

  47. "entity" [shape = record, label = "{<col0> \N| id:  serial\lname:  text\lentity_class:  integer\l}" ];
    48. 

  48. 

  49. "entity_class" [shape = record, label = "{<col0> \N| id:  serial\lclass:  text\lactive:  boolean\l}" ];
    50. 

  50. 

  51. "entity_class_to_entity" [shape = record, label = "{<col0> \N| entity_class_id:  integer\lentity_id:  integer\l}" ];
    52. 

  52. 

  53. "entity_other_name" [shape = record, label = "{<col0> \N| entity_id:  integer\lother_name:  text\l}" ];
    54. 

  54. 

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

  56. 

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

  58. 

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

  60. 

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

  62. 

  63. "invoice" [shape = record, label = "{<col0> \N| id:  serial\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}" ];
    64. 

  64. 

  65. "jcitems" [shape = record, label = "{<col0> \N| id:  serial\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\lperson_id:  integer\lnotes:  text\l}" ];
    66. 

  66. 

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

  68. 

  69. "location" [shape = record, label = "{<col0> \N| id:  serial\lline_one:  text\lline_two:  text\lline_three:  text\lcity_province:  text\lcountry_id:  integer\lmail_code:  text\l}" ];
    70. 

  70. 

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

  72. 

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

  74. 

  75. "oe_class" [shape = record, label = "{<col0> \N| id:  smallint\loe_class:  text\l}" ];
    76. 

  76. 

  77. "orderitems" [shape = record, label = "{<col0> \N| id:  serial\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}" ];
    78. 

  78. 

  79. "parts" [shape = record, label = "{<col0> \N| id:  serial\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}" ];
    80. 

  80. 

  81. "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}" ];
    82. 

  82. 

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

  84. 

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

  86. 

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

  88. 

  89. "person" [shape = record, label = "{<col0> \N| id:  serial\lentity_id:  integer\lsalutation_id:  integer\lfirst_name:  text\lmiddle_name:  text\llast_name:  text\lprimary_location_id:  integer\l}" ];
    90. 

  90. 

  91. "person_to_company" [shape = record, label = "{<col0> \N| location_id:  integer\lperson_id:  integer\l}" ];
    92. 

  92. 

  93. "person_to_contact" [shape = record, label = "{<col0> \N| person_id:  integer\lcontact_class_id:  integer\lcontact:  text\l}" ];
    94. 

  94. 

  95. "person_to_entity" [shape = record, label = "{<col0> \N| person_id:  integer\lentity_id:  integer\lrelated_how:  text\lcreated:  date\l}" ];
    96. 

  96. 

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

  98. 

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

  100. 

  101. "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}" ];
    102. 

  102. 

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

  104. 

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

  106. 

  107. "salutation" [shape = record, label = "{<col0> \N| id:  serial\lsalutation:  text\l}" ];
    108. 

  108. 

  109. "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}" ];
    110. 

  110. 

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

  112. 

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

  114. 

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

  116. 

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

  118. 

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

  120. 

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

  122. 

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

  124. 

  125. "vendor" [shape = record, label = "{<col0> \N| id:  serial\lentity_id:  integer\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)\llanguage_code:  character varying(6)\lpricegroup_id:  integer\lcurr:  character(3)\lstartdate:  date\lenddate:  date\l}" ];
    126. 

  126. 

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

  128. 

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

  130. 

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

  132. 

  133. 

  134. "acc_trans" -> "chart" [label="acc_trans_chart_id_fkey"];
    135. 

  135. "ap" -> "entity" [label="ap_entity_id_fkey"];
    136. 

  136. "ap" -> "person" [label="ap_person_id_fkey"];
    137. 

  137. "ar" -> "entity" [label="ar_entity_id_fkey"];
    138. 

  138. "ar" -> "person" [label="ar_person_id_fkey"];
    139. 

  139. "audittrail" -> "person" [label="audittrail_person_id_fkey"];
    140. 

  140. "company" -> "entity" [label="company_entity_id_fkey"];
    141. 

  141. "company" -> "entity_class" [label="company_entity_class_id_fkey"];
    142. 

  142. "company" -> "location" [label="company_primary_location_id_fkey"];
    143. 

  143. "company_to_contact" -> "company" [label="company_to_contact_company_id_fkey"];
    144. 

  144. "company_to_contact" -> "contact_class" [label="company_to_contact_contact_class_id_fkey"];
    145. 

  145. "company_to_entity" -> "company" [label="company_to_entity_company_id_fkey"];
    146. 

  146. "company_to_entity" -> "entity" [label="company_to_entity_entity_id_fkey"];
    147. 

  147. "company_to_location" -> "location" [label="company_to_location_location_id_fkey"];
    148. 

  148. "company_to_location" -> "company" [label="company_to_location_company_id_fkey"];
    149. 

  149. "custom_field_catalog" -> "custom_table_catalog" [label="custom_field_catalog_table_id_fkey"];
    150. 

  150. "customer" -> "entity" [label="customer_entity_id_fkey"];
    151. 

  151. "employee" -> "entity" [label="employee_entity_id_fkey"];
    152. 

  152. "entity" -> "entity_class" [label="entity_entity_class_fkey"];
    153. 

  153. "entity_class_to_entity" -> "entity_class" [label="entity_class_to_entity_entity_class_id_fkey"];
    154. 

  154. "entity_class_to_entity" -> "entity" [label="entity_class_to_entity_entity_id_fkey"];
    155. 

  155. "entity_other_name" -> "entity" [label="entity_other_name_entity_id_fkey"];
    156. 

  156. "gl" -> "person" [label="gl_person_id_fkey"];
    157. 

  157. "inventory" -> "person" [label="inventory_person_id_fkey"];
    158. 

  158. "jcitems" -> "person" [label="jcitems_person_id_fkey"];
    159. 

  159. "location" -> "country" [label="location_country_id_fkey"];
    160. 

  160. "oe" -> "entity" [label="oe_entity_id_fkey"];
    161. 

  161. "oe" -> "person" [label="oe_person_id_fkey"];
    162. 

  162. "oe" -> "oe_class" [label="oe_oe_class_id_fkey"];
    163. 

  163. "partstax" -> "parts" [label="partstax_parts_id_fkey"];
    164. 

  164. "partstax" -> "chart" [label="partstax_chart_id_fkey"];
    165. 

  165. "partstax" -> "taxcategory" [label="partstax_taxcategory_id_fkey"];
    166. 

  166. "partsvendor" -> "entity" [label="partsvendor_entity_id_fkey"];
    167. 

  167. "person" -> "entity" [label="person_entity_id_fkey"];
    168. 

  168. "person" -> "salutation" [label="person_salutation_id_fkey"];
    169. 

  169. "person" -> "location" [label="person_primary_location_id_fkey"];
    170. 

  170. "person_to_company" -> "location" [label="person_to_company_location_id_fkey"];
    171. 

  171. "person_to_company" -> "person" [label="person_to_company_person_id_fkey"];
    172. 

  172. "person_to_contact" -> "person" [label="person_to_contact_person_id_fkey"];
    173. 

  173. "person_to_contact" -> "contact_class" [label="person_to_contact_contact_class_id_fkey"];
    174. 

  174. "person_to_entity" -> "person" [label="person_to_entity_person_id_fkey"];
    175. 

  175. "person_to_entity" -> "entity" [label="person_to_entity_entity_id_fkey"];
    176. 

  176. "tax" -> "chart" [label="tax_chart_id_fkey"];
    177. 

  177. "tax" -> "taxmodule" [label="tax_taxmodule_id_fkey"];
    178. 

  178. "taxcategory" -> "taxmodule" [label="taxcategory_taxmodule_id_fkey"];
    179. 

  179. "vendor" -> "entity" [label="vendor_entity_id_fkey"];
    180. 

  180. }
    181. 

  181. 

  182.
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-22 10:55:18 +0000