doc/database/ledgersmb.html



<!-- $Header: /cvsroot/autodoc/autodoc/html.tmpl,v 1.4 2006/05/16 19:01:27 rbt Exp $ -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
   "http://www.w3.org/TR/html4/strict.dtd">

<html>
  <head>
    <title>Index for ledgersmb</title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <style type="text/css">
    BODY {
        color:  #000000;
        background-color: #FFFFFF;
        font-family: Helvetica, sans-serif;
    }

    P {
        margin-top: 5px;
        margin-bottom: 5px;
    }

    P.w3ref {
        font-size: 8pt;
        font-style: italic;
        text-align: right;
    }

    P.detail {
        font-size: 10pt;
    }

    .error {
        color: #FFFFFF;
        background-color: #FF0000;
    }

    H1, H2, H3, H4, H5, H6 {
    }

    OL {
        list-style-type: upper-alpha;
    }

    UL.topic {
        list-style-type: upper-alpha;
    }

    LI.topic {
        font-weight : bold;
    }

    HR {
        color: #00FF00;
        background-color: #808080;
    }

    TABLE {
        border-width: medium;
        padding: 3px;
        background-color: #000000;
        width: 90%;
    }

    CAPTION {
        text-transform: capitalize;
        font-weight : bold;
        font-size: 14pt;
    }

    TH {
        color: #FFFFFF;
        background-color: #000000;
        text-align: left;
    }

    TR {
        color: #000000;
        background-color: #000000;
        vertical-align: top;
    }

    TR.tr0 {
        background-color: #F0F0F0;
    }

    TR.tr1 {
        background-color: #D8D8D8;
    }

    TD {
        font-size: 12pt;
    }

    TD.col0 {
        font-weight : bold;
        width: 20%;
    }

    TD.col1 {
        font-style: italic;
        width: 15%;
    }

    TD.col2 {
        font-size: 12px;
    }
    </style>
    <link rel="stylesheet" type="text/css" media="all" href="all.css">
    <link rel="stylesheet" type="text/css" media="screen" href="screen.css">
    <link rel="stylesheet" type="text/css" media="print" href="print.css">
    <meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
  </head>
  <body>

    <!-- Primary Index -->
    <p><br><br>Dumped on 2007-03-22</p>
<h1><a name="index">Index of database - ledgersmb</a></h1>
<ul>
    
    <li><a name="public.schema">public</a></li><ul>
        <li><a href="#public.table.acc-trans">acc_trans</a></li><li><a href="#public.table.ap">ap</a></li><li><a href="#public.table.ar">ar</a></li><li><a href="#public.table.assembly">assembly</a></li><li><a href="#public.table.audittrail">audittrail</a></li><li><a href="#public.table.business">business</a></li><li><a href="#public.table.chart">chart</a></li><li><a href="#public.table.custom-field-catalog">custom_field_catalog</a></li><li><a href="#public.table.custom-table-catalog">custom_table_catalog</a></li><li><a href="#public.table.customer">customer</a></li><li><a href="#public.table.customertax">customertax</a></li><li><a href="#public.table.defaults">defaults</a></li><li><a href="#public.table.department">department</a></li><li><a href="#public.table.dpt-trans">dpt_trans</a></li><li><a href="#public.table.employee">employee</a></li><li><a href="#public.table.exchangerate">exchangerate</a></li><li><a href="#public.table.gifi">gifi</a></li><li><a href="#public.table.gl">gl</a></li><li><a href="#public.table.inventory">inventory</a></li><li><a href="#public.table.invoice">invoice</a></li><li><a href="#public.table.jcitems">jcitems</a></li><li><a href="#public.table.language">language</a></li><li><a href="#public.table.makemodel">makemodel</a></li><li><a href="#public.table.oe">oe</a></li><li><a href="#public.table.orderitems">orderitems</a></li><li><a href="#public.table.parts">parts</a></li><li><a href="#public.table.partscustomer">partscustomer</a></li><li><a href="#public.table.partsgroup">partsgroup</a></li><li><a href="#public.table.partstax">partstax</a></li><li><a href="#public.table.partsvendor">partsvendor</a></li><li><a href="#public.table.pricegroup">pricegroup</a></li><li><a href="#public.table.project">project</a></li><li><a href="#public.table.recurring">recurring</a></li><li><a href="#public.table.recurringemail">recurringemail</a></li><li><a href="#public.table.recurringprint">recurringprint</a></li><li><a href="#public.table.shipto">shipto</a></li><li><a href="#public.table.sic">sic</a></li><li><a href="#public.table.status">status</a></li><li><a href="#public.table.tax">tax</a></li><li><a href="#public.table.taxcategory">taxcategory</a></li><li><a href="#public.table.taxmodule">taxmodule</a></li><li><a href="#public.table.transactions">transactions</a></li><li><a href="#public.table.translation">translation</a></li><li><a href="#public.table.vendor">vendor</a></li><li><a href="#public.table.vendortax">vendortax</a></li><li><a href="#public.table.warehouse">warehouse</a></li><li><a href="#public.table.yearend">yearend</a></li>
    <li><a href="#public.function.add-custom-field-character-varying-character-varying-character-varying">add_custom_field( character varying, character varying, character varying )</a></li><li><a href="#public.function.avgcost-integer">avgcost( integer )</a></li><li><a href="#public.function.check-department">check_department(  )</a></li><li><a href="#public.function.check-inventory">check_inventory(  )</a></li><li><a href="#public.function.del-customer">del_customer(  )</a></li><li><a href="#public.function.del-department">del_department(  )</a></li><li><a href="#public.function.del-exchangerate">del_exchangerate(  )</a></li><li><a href="#public.function.del-recurring">del_recurring(  )</a></li><li><a href="#public.function.del-vendor">del_vendor(  )</a></li><li><a href="#public.function.del-yearend">del_yearend(  )</a></li><li><a href="#public.function.drop-custom-field-character-varying-character-varying">drop_custom_field( character varying, character varying )</a></li><li><a href="#public.function.lastcost-integer">lastcost( integer )</a></li><li><a href="#public.function.trigger-parts-short">trigger_parts_short(  )</a></li><li><a href="#public.function.update-user-integer-text">update_user( integer, text )</a></li>
    </ul>
    
</ul>

    <!-- Schema Creation -->
    <!-- publicpublic -->

        
        <hr>
        <h2>Table:
            <a name="public.table.acc-trans">acc_trans</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>acc_trans Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                  <a href="#public.table.chart">chart.id</a>
                  
                
                </td>
                <td>chart_id</td>
                <td>integer</td>
                <td><i>
                
                    
                NOT NULL
                
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>amount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>source</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>cleared</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>fx_transaction</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>project_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>memo</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>invoice_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>entry_id</td>
                <td>serial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       acc_trans_chart_id_key chart_id
    
       acc_trans_source_key lower(source)
    
       acc_trans_trans_id_key trans_id
    
       acc_trans_transdate_key transdate
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.ap">ap</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>ap Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>invnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>vendor_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>taxincluded</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>amount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>netamount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>paid</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>datepaid</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>duedate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>invoice</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ordnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>till</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>quonumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>intnotes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>department_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>shipvia</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>language_code</td>
                <td>character varying(6)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ponumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>shippingpoint</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>terms</td>
                <td>smallint</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       ap_employee_id_key employee_id
    
       ap_id_key id
    
       ap_invnumber_key invnumber
    
       ap_ordnumber_key ordnumber
    
       ap_quonumber_key quonumber
    
       ap_transdate_key transdate
    
       ap_vendor_id_key vendor_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.ar">ar</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>ar Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>invnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>customer_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>taxincluded</td>
                <td>boolean</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>amount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>netamount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>paid</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>datepaid</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>duedate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>invoice</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>shippingpoint</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>terms</td>
                <td>smallint</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ordnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>till</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>quonumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>intnotes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>department_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>shipvia</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>language_code</td>
                <td>character varying(6)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ponumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       ar_customer_id_key customer_id
    
       ar_employee_id_key employee_id
    
       ar_id_key id
    
       ar_invnumber_key invnumber
    
       ar_ordnumber_key ordnumber
    
       ar_quonumber_key quonumber
    
       ar_transdate_key transdate
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.assembly">assembly</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>assembly Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>qty</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>bom</td>
                <td>boolean</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>adj</td>
                <td>boolean</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       assembly_id_key id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.audittrail">audittrail</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>audittrail Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>tablename</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>reference</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>formname</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>action</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>transdate</td>
                <td>timestamp without time zone</td>
                <td><i>
                

                DEFAULT now()
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                </td>
                <td>entry_id</td>
                <td>bigserial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       audittrail_trans_id_key trans_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.business">business</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>business Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>discount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.chart">chart</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>chart Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>accno</td>
                <td>text</td>
                <td><i>
                

                NOT NULL
                
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>charttype</td>
                <td>character(1)</td>
                <td><i>
                

                DEFAULT &#39;A&#39;::bpchar
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>category</td>
                <td>character(1)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>link</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>gifi_accno</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>contra</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        
            <p>Tables referencing this one via Foreign Key Constraints:</p>
        
            <ul>
                <li><a href="#public.table.acc-trans">acc_trans</a></li>
            </ul>
        
            <ul>
                <li><a href="#public.table.partstax">partstax</a></li>
            </ul>
        
            <ul>
                <li><a href="#public.table.tax">tax</a></li>
            </ul>
        
        
    <!-- Indexes -->
    
       chart_category_key category
    
       chart_gifi_accno_key gifi_accno
    
       chart_id_key id
    
       chart_link_key link
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.custom-field-catalog">custom_field_catalog</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>custom_field_catalog Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>field_id</td>
                <td>serial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                  <a href="#public.table.custom-table-catalog">custom_table_catalog.table_id</a>
                  
                
                </td>
                <td>table_id</td>
                <td>integer</td>
                <td><i>
                
                    
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>field_name</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.custom-table-catalog">custom_table_catalog</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>custom_table_catalog Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>table_id</td>
                <td>serial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>extends</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>table_name</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        
            <p>Tables referencing this one via Foreign Key Constraints:</p>
        
            <ul>
                <li><a href="#public.table.custom-field-catalog">custom_field_catalog</a></li>
            </ul>
        
        
    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.customer">customer</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>customer Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>name</td>
                <td>character varying(64)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>address1</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>address2</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>city</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>state</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>zipcode</td>
                <td>character varying(10)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>country</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>contact</td>
                <td>character varying(64)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>phone</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>fax</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>email</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>discount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>taxincluded</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>creditlimit</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>terms</td>
                <td>smallint</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>customernumber</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>cc</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>bcc</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>business_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>taxnumber</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>sic_code</td>
                <td>character varying(6)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>iban</td>
                <td>character varying(34)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>bic</td>
                <td>character varying(11)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>language_code</td>
                <td>character varying(6)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>pricegroup_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>startdate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>enddate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       customer_contact_key lower((contact)::text)
    
       customer_customernumber_key customernumber
    
       customer_id_key id
    
       customer_name_key lower((name)::text)
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.customertax">customertax</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>customertax Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>customer_id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                </td>
                <td>chart_id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       customer_customer_id_key customer_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.defaults">defaults</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>defaults Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>setting_key</td>
                <td>text</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>value</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.department">department</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>department Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>role</td>
                <td>character(1)</td>
                <td><i>
                

                DEFAULT &#39;P&#39;::bpchar
                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       department_id_key id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.dpt-trans">dpt_trans</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>dpt_trans Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>department_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.employee">employee</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>employee Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>login</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>name</td>
                <td>character varying(64)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>address1</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>address2</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>city</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>state</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>zipcode</td>
                <td>character varying(10)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>country</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>workphone</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>homephone</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>startdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>enddate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>role</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>sales</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>email</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ssn</td>
                <td>character varying(20)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>iban</td>
                <td>character varying(34)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>bic</td>
                <td>character varying(11)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>managerid</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>employeenumber</td>
                <td>character varying(32)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>dob</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       employee_id_key id
    
       employee_name_key lower((name)::text)
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.exchangerate">exchangerate</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>exchangerate Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>buy</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>sell</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       exchangerate_ct_key curr, transdate
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.gifi">gifi</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>gifi Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>accno</td>
                <td>text</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.gl">gl</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>gl Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>reference</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>department_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       gl_description_key lower(description)
    
       gl_employee_id_key employee_id
    
       gl_id_key id
    
       gl_reference_key reference
    
       gl_transdate_key transdate
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.inventory">inventory</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>inventory Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>warehouse_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>orderitems_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>qty</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>shippingdate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                  
                </td>
                <td>entry_id</td>
                <td>serial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.invoice">invoice</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>invoice Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;invoiceid&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>qty</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>allocated</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>sellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>fxsellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>discount</td>
                <td>real</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>assemblyitem</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>unit</td>
                <td>character varying(5)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>project_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>deliverydate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>serialnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       invoice_id_key id
    
       invoice_trans_id_key trans_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.jcitems">jcitems</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>jcitems Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;jcitemsid&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>project_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>qty</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>allocated</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>sellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>fxsellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>serialnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>checkedin</td>
                <td>timestamp with time zone</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>checkedout</td>
                <td>timestamp with time zone</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       jcitems_id_key id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.language">language</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>language Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>code</td>
                <td>character varying(6)</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.makemodel">makemodel</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>makemodel Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>make</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>model</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       makemodel_make_key lower(make)
    
       makemodel_model_key lower(model)
    
       makemodel_parts_id_key parts_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.oe">oe</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>oe Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>ordnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>transdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>vendor_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>customer_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>amount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>netamount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>reqdate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>taxincluded</td>
                <td>boolean</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>shippingpoint</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>employee_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>closed</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>quotation</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>quonumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>intnotes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>department_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>shipvia</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>language_code</td>
                <td>character varying(6)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>ponumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>terms</td>
                <td>smallint</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       oe_employee_id_key employee_id
    
       oe_id_key id
    
       oe_ordnumber_key ordnumber
    
       oe_transdate_key transdate
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.orderitems">orderitems</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>orderitems Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;orderitemsid&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>trans_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>qty</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>sellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>discount</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>unit</td>
                <td>character varying(5)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>project_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>reqdate</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>ship</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>serialnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    
       orderitems_id_key id
    
       orderitems_trans_id_key trans_id
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.parts">parts</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>parts Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>partnumber</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>description</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>unit</td>
                <td>character varying(5)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>listprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>sellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>lastcost</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>priceupdate</td>
                <td>date</td>
                <td><i>
                

                DEFAULT (&#39;now&#39;::text)::date
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>weight</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>onhand</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>notes</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>makemodel</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>assembly</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>alternate</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>rop</td>
                <td>real</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>inventory_accno_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>income_accno_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>expense_accno_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>bin</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>obsolete</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>bom</td>
                <td>boolean</td>
                <td><i>
                

                DEFAULT false
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>image</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>drawing</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>microfiche</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>partsgroup_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>project_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>avgcost</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        
            <p>Tables referencing this one via Foreign Key Constraints:</p>
        
            <ul>
                <li><a href="#public.table.partstax">partstax</a></li>
            </ul>
        
        
    <!-- Indexes -->
    
       parts_description_key lower(description)
    
       parts_id_key id
    
       parts_partnumber_key lower(partnumber)
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.partscustomer">partscustomer</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>partscustomer Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>parts_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>customer_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>pricegroup_id</td>
                <td>integer</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>pricebreak</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>sellprice</td>
                <td>numeric</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>validfrom</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                </td>
                <td>validto</td>
                <td>date</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>curr</td>
                <td>character(3)</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>entry_id</td>
                <td>serial</td>
                <td><i>
                
                    PRIMARY KEY
                    

                </i>
                
                </td>
             </tr>
            
        </table>

        <!-- Inherits -->
        

        <!-- Constraint List -->
        

        <!-- Foreign Key Discovery -->
        

    <!-- Indexes -->
    

    <!-- View Definition -->
    

    <!-- List off permissions -->
    

    <p>
        <a href="#index">Index</a> -
        <a href="#public.schema">Schema public</a>
    </p>
    
        <hr>
        <h2>Table:
            <a name="public.table.partsgroup">partsgroup</a>
        </h2>
        

        <table width="100%" cellspacing="0" cellpadding="3">
                <caption>partsgroup Structure</caption>
                <tr>
                <th>F-Key</th>
                <th>Name</th>
                <th>Type</th>
                <th>Description</th>
                </tr>
            
            <tr class="tr0">
                <td>
                
                  
                </td>
                <td>id</td>
                <td>integer</td>
                <td><i>
                
                    PRIMARY KEY
                    

                DEFAULT nextval(&#39;id&#39;::regclass)
                </i>
                
                </td>
             </tr>
            
            <tr class="tr1">
                <td>
                
                </td>
                <td>partsgroup</td>
                <td>text</td>
                <td><i>
                

                </i>
                
                </td>
             </tr>