web commit by NicolasDuboc - ikiwiki-upstream - Unnamed repository; edit this file to name it for gitweb.

diff options

author	joey <joey@0fa5a96a-9a0e-0410-b3b2-a0fd24251071>	2006-10-24 12:16:54 +0000
committer	joey <joey@0fa5a96a-9a0e-0410-b3b2-a0fd24251071>	2006-10-24 12:16:54 +0000
commit	df2354b0092efa4c03be6d9ee4b2509359f6bbc4 (patch)
tree	48cc1b66a7bc3ceaa4e74a1e4a331792da904fd5 /IkiWiki/Plugin/orphans.pm
parent	6d514b7b33cecf43440b9564ae804a0ba2aea93e (diff)

web commit by NicolasDuboc

Diffstat (limited to 'IkiWiki/Plugin/orphans.pm')

0 files changed, 0 insertions, 0 deletions

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>

    <p><br><br>Dumped on 2007-06-13</p>

<h1><a name="index">Index of database - lsmb13-new</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.company">company</a></li><li><a href="#public.table.company-to-contact">company_to_contact</a></li><li><a href="#public.table.company-to-entity">company_to_entity</a></li><li><a href="#public.table.company-to-location">company_to_location</a></li><li><a href="#public.table.contact-class">contact_class</a></li><li><a href="#public.table.country">country</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.entity">entity</a></li><li><a href="#public.table.entity-class">entity_class</a></li><li><a href="#public.table.entity-class-to-entity">entity_class_to_entity</a></li><li><a href="#public.table.entity-other-name">entity_other_name</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.location">location</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.oe-class">oe_class</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.person">person</a></li><li><a href="#public.table.person-to-company">person_to_company</a></li><li><a href="#public.table.person-to-contact">person_to_contact</a></li><li><a href="#public.table.person-to-entity">person_to_entity</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.salutation">salutation</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>

<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>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>trans_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.chart">chart.id</a>

</td>

<td>chart_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>source</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>cleared</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>fx_transaction</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>project_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invoice_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>entry_id</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

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

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.ap">ap</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>ap Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity">entity.id</a>

</td>

<td>entity_id</td>

<td>integer</td>

<td>

Used to be customer_id, but customer is now metadata. You need to push to entity

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>taxincluded</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>netamount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>datepaid</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>duedate</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>invoice</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ordnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

                <td>character(3)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>notes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.person">person.id</a>

</td>

<td>person_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

</td>

                <td>character varying(20)</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>quonumber</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>intnotes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>department_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>shipvia</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>language_code</td>

                <td>character varying(6)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ponumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>shippingpoint</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>terms</td>

<td>smallint</td>

<td>

</td>

</tr>

</table>

ap_id_key id

ap_invnumber_key invnumber

ap_ordnumber_key ordnumber

ap_quonumber_key quonumber

ap_transdate_key transdate

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.ar">ar</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>ar Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity">entity.id</a>

</td>

<td>entity_id</td>

<td>integer</td>

<td>

Used to be customer_id, but customer is now metadata. You need to push to entity

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>taxincluded</td>

<td>boolean</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>netamount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>datepaid</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>duedate</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>invoice</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>shippingpoint</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>terms</td>

<td>smallint</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>notes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

                <td>character(3)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ordnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.person">person.id</a>

</td>

<td>person_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

</td>

                <td>character varying(20)</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>quonumber</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>intnotes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>department_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>shipvia</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>language_code</td>

                <td>character varying(6)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ponumber</td>

<td>

</td>

</tr>

</table>

ar_id_key id

ar_invnumber_key invnumber

ar_ordnumber_key ordnumber

ar_quonumber_key quonumber

ar_transdate_key transdate

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.assembly">assembly</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>assembly Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>parts_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>boolean</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>boolean</td>

<td>

</td>

</tr>

</table>

assembly_id_key id

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.audittrail">audittrail</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>audittrail Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>trans_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>tablename</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>reference</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>formname</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>action</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>transdate</td>

<td>timestamp without time zone</td>

<td>

DEFAULT now()

</td>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.person">person.id</a>

</td>

<td>person_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>entry_id</td>

<td>bigserial</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

audittrail_trans_id_key trans_id

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.business">business</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>business Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>description</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>discount</td>

<td>numeric</td>

<td>

</td>

</tr>

</table>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.chart">chart</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>chart Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>accno</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>description</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>charttype</td>

                <td>character(1)</td>

<td>

DEFAULT 'A'::bpchar

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>category</td>

                <td>character(1)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>gifi_accno</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>contra</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

</table>

Tables referencing this one via Foreign Key Constraints:

<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>

chart_category_key category

chart_gifi_accno_key gifi_accno

chart_id_key id

chart_link_key link

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.company">company</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

UNIQUE

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity">entity.id</a>

</td>

<td>entity_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>legal_name</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity-class">entity_class.id</a>

</td>

<td>entity_class_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.location">location.id</a>

</td>

<td>primary_location_id</td>

<td>integer</td>

<td>

PRIMARY KEY

This is the location that should show up by default for any forms

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>

In the US this would be a EIN.

</td>

</tr>

</table>

        <p>&nbsp;</p>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company Constraints</caption>

<tr>

<th>Constraint</th>

</tr>

            <tr class="tr0">

<td>company_legal_name_check</td>

                <td>CHECK ((legal_name ~ &#39;[[:alnum:]_]&#39;::text))</td>

</tr>

</table>

Tables referencing this one via Foreign Key Constraints:

<ul>

                <li><a href="#public.table.company-to-contact">company_to_contact</a></li>

</ul>

<ul>

                <li><a href="#public.table.company-to-entity">company_to_entity</a></li>

</ul>

<ul>

                <li><a href="#public.table.company-to-location">company_to_location</a></li>

</ul>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.company-to-contact">company_to_contact</a>

</h2>

To keep track of the relationship between multiple contact methods and a single company

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company_to_contact Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.company">company.id</a>

</td>

<td>company_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.contact-class">contact_class.id</a>

</td>

<td>contact_class_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>contact</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

        <p>&nbsp;</p>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company_to_contact Constraints</caption>

<tr>

<th>Constraint</th>

</tr>

            <tr class="tr0">

<td>company_to_contact_contact_check</td>

                <td>CHECK ((contact ~ &#39;[[:alnum:]_]&#39;::text))</td>

</tr>

</table>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.company-to-entity">company_to_entity</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company_to_entity Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.company">company.id</a>

</td>

<td>company_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity">entity.id</a>

</td>

<td>entity_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>related_how</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>created</td>

<td>

NOT NULL

DEFAULT ('now'::text)::date

</td>

</tr>

</table>

        <p>&nbsp;</p>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company_to_entity Constraints</caption>

<tr>

<th>Constraint</th>

</tr>

            <tr class="tr0">

<td>company_to_entity_check</td>

                <td>CHECK ((entity_id &lt;&gt; company_id))</td>

</tr>

</table>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.company-to-location">company_to_location</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>company_to_location Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

                  <a href="#public.table.location">location.id</a>

</td>

<td>location_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.company">company.id</a>

</td>

<td>company_id</td>

<td>integer</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.contact-class">contact_class</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>contact_class Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

UNIQUE

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>class</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

        <p>&nbsp;</p>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>contact_class Constraints</caption>

<tr>

<th>Constraint</th>

</tr>

            <tr class="tr0">

<td>contact_class_class_check</td>

                <td>CHECK ((&quot;class&quot; ~ &#39;[[:alnum:]_]&#39;::text))</td>

</tr>

</table>

Tables referencing this one via Foreign Key Constraints:

<ul>

                <li><a href="#public.table.company-to-contact">company_to_contact</a></li>

</ul>

<ul>

                <li><a href="#public.table.person-to-contact">person_to_contact</a></li>

</ul>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.country">country</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>country Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>short_name</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>

                <br><br> The ITU Telecommunication Standardization Sector code for calling internationally. For example, the US is 1, Great Britain is 44 

</td>

</tr>

</table>

        <p>&nbsp;</p>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>country Constraints</caption>

<tr>

<th>Constraint</th>

</tr>

            <tr class="tr0">

<td>country_name_check</td>

                <td>CHECK ((name ~ &#39;[[:alnum:]_]&#39;::text))</td>

</tr>

            <tr class="tr1">

<td>country_short_name_check</td>

                <td>CHECK ((short_name ~ &#39;[[:alnum:]_]&#39;::text))</td>

</tr>

</table>

Tables referencing this one via Foreign Key Constraints:

<ul>

                <li><a href="#public.table.location">location</a></li>

</ul>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<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>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>field_id</td>

<td>serial</td>

<td>

PRIMARY KEY

</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>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>field_name</td>

<td>

</td>

</tr>

</table>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<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>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>table_id</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>extends</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>table_name</td>

<td>

</td>

</tr>

</table>

Tables referencing this one via Foreign Key Constraints:

<ul>

                <li><a href="#public.table.custom-field-catalog">custom_field_catalog</a></li>

</ul>

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.customer">customer</a>

</h2>

This is now a metadata table that holds information specific to customers. Source info is not part of the entity management

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>customer Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.entity">entity.id</a>

</td>

<td>entity_id</td>

<td>integer</td>

<td>

This is the relationship between entities and customers

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>discount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>taxincluded</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>creditlimit</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>terms</td>

<td>smallint</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>


context:
space:
mode: