northwind.cphrase

Here you can browse the full pim.phrase.

<?xml version="1.0" encoding="UTF-8"?>
<config id="northwind" db="postgresql:dbname=northwind host=44.202.44.37 user=readonly password=db123 port=5432" language="english" version="1.0.0411" description="">

  <table id="categories">
    <column id="categoryid" type="int" notnull="true"/>
    <column id="categoryname" type="text"/>
    <column id="description" type="text"/>

    <primary_key key="categoryid"/>
  </table>

  <table id="customers">
    <column id="customerid" type="text" notnull="true"/>
    <column id="companyname" type="text"/>
    <column id="contactname" type="text"/>
    <column id="contacttitle" type="text"/>
    <column id="address" type="text"/>
    <column id="city" type="text"/>
    <column id="region" type="text"/>
    <column id="postalcode" type="text"/>
    <column id="country" type="text"/>
    <column id="phone" type="text"/>
    <column id="fax" type="text"/>

    <primary_key key="customerid"/>
  </table>

  <table id="employees">
    <column id="employeeid" type="int" notnull="true"/>
    <column id="lastname" type="text"/>
    <column id="firstname" type="text"/>
    <column id="title" type="text"/>
    <column id="titleofcourtesy" type="text"/>
    <column id="birthdate" type="date"/>
    <column id="hiredate" type="date"/>
    <column id="address" type="text"/>
    <column id="city" type="text"/>
    <column id="region" type="text"/>
    <column id="postalcode" type="text"/>
    <column id="country" type="text"/>
    <column id="homephone" type="text"/>
    <column id="extension" type="text"/>
    <column id="photo" type="text"/>
    <column id="notes" type="text"/>
    <column id="reportsto" type="int"/>

    <primary_key key="employeeid"/>
  </table>

  <table id="orderdetails">
    <column id="orderid" type="int" notnull="true"/>
    <column id="productid" type="int" notnull="true"/>
    <column id="unitprice" type="int"/>
    <column id="quantity" type="int"/>
    <column id="discount" type="real"/>

    <primary_key key="orderid,productid"/>
    <foreign_key from="orderid" to="orders"/>
    <foreign_key from="productid" to="products"/>
  </table>

  <table id="orders">
    <column id="orderid" type="int" notnull="true"/>
    <column id="customerid" type="text"/>
    <column id="employeeid" type="int"/>
    <column id="orderdate" type="date"/>
    <column id="requireddate" type="date"/>
    <column id="shippeddate" type="date"/>
    <column id="shipvia" type="int"/>
    <column id="freight" type="int"/>
    <column id="shipname" type="text"/>
    <column id="shipaddress" type="text"/>
    <column id="shipcity" type="text"/>
    <column id="shipregion" type="text"/>
    <column id="shippostalcode" type="text"/>
    <column id="shipcountry" type="text"/>

    <primary_key key="orderid"/>
    <foreign_key from="customerid" to="customers"/>
    <foreign_key from="employeeid" to="employees"/>
    <foreign_key from="shipvia" to="shippers"/>
  </table>

  <table id="products">
    <column id="productid" type="int" notnull="true"/>
    <column id="productname" type="text"/>
    <column id="supplierid" type="int"/>
    <column id="categoryid" type="int"/>
    <column id="quantityperunit" type="text"/>
    <column id="unitprice" type="int"/>
    <column id="unitsinstock" type="int"/>
    <column id="unitsonorder" type="int"/>
    <column id="reorderlevel" type="int"/>
    <column id="discontinued" type="text"/>

    <primary_key key="productid"/>
    <foreign_key from="supplierid" to="suppliers"/>
    <foreign_key from="categoryid" to="categories"/>
  </table>

  <table id="shippers">
    <column id="shipperid" type="int" notnull="true"/>
    <column id="companyname" type="text"/>
    <column id="phone" type="text"/>

    <primary_key key="shipperid"/>
  </table>

  <table id="suppliers">
    <column id="supplierid" type="int" notnull="true"/>
    <column id="companyname" type="text"/>
    <column id="contactname" type="text"/>
    <column id="contacttitle" type="text"/>
    <column id="address" type="text"/>
    <column id="city" type="text"/>
    <column id="region" type="text"/>
    <column id="postalcode" type="text"/>
    <column id="country" type="text"/>
    <column id="phone" type="text"/>
    <column id="fax" type="text"/>
    <column id="homepage" type="text"/>

    <primary_key key="supplierid"/>
  </table>

</config>