environment             "ORDERS"

database                "ORDERS"
 type                    FLATFILE
 indexprefix            "idx/orders"


 table                  "CUSTOMERS"
  physical              "dat/customers.dat"
  primary key           "CUSTOMER_NO"

  column "CUSTOMER_NO"                      datatype INTEGER
  column "COMPANY"                          datatype CHARACTER(40)
  column "CONTACT"                          datatype CHARACTER(24)
  column "TITLE"                            datatype CHARACTER(30)
  column "SALUTATION"                       datatype CHARACTER(24)
  column "ADDRESS1"                         datatype CHARACTER(30)
  column "ADDRESS2"                         datatype CHARACTER(30)
  column "CITY"                             datatype CHARACTER(20)
  column "STATE"                            datatype CHARACTER(2)
  column "POSTAL_CODE"                      datatype CHARACTER(10)
  column "COUNTRY"                          datatype CHARACTER(20)
  column "PHONE_NO"                         datatype CHARACTER(18)
  column "FAX_NO"                           datatype CHARACTER(20)
  column "AKA_COMPANY"                      datatype CHARACTER(20)
  column "COMMENTS"                         datatype CHARACTER(60)
  column "LICENSEE"                         datatype INTEGER


 table                  "PRODUCTS"
  physical              "dat/products.dat"
  primary key           "PRODUCT_NO"

  column "PRODUCT_NO"                       datatype CHARACTER(12)
  column "PRODUCT_CLASS"                    datatype CHARACTER(20)
  column "PRODUCT_NAME"                     datatype CHARACTER(40)
  column "SALES_PRICE"                      datatype INTEGER
  column "PRODUCT_COST"                     datatype INTEGER


 table                  "ACTIVITY"
  physical              "dat/activity.dat"
  foreign key           "CUSTOMER_NO"
   references           "CUSTOMERS" ("CUSTOMER_NO")

  column "CUSTOMER_NO"                      datatype INTEGER
  column "DATE_TICKLER"                     datatype ASCII DATE(6)
  column "TICKLER"                          datatype CHARACTER(2)
  column "INITIALS"                         datatype CHARACTER(4)
  column "ACTION_INFO"                      datatype CHARACTER(60)


 table                  "CUST_NOTES"
  physical              "dat/custnote.dat"
  foreign key           "CUSTOMER_NO"
   references           "CUSTOMERS" ("CUSTOMER_NO")

  column "CUSTOMER_NO"                      datatype INTEGER
  column "DATE_ENTERED"                     datatype ASCII DATE(6)
  column "ENTERED_BY"                       datatype CHARACTER(4)
  column "DESC_LINES1"                      datatype CHARACTER(60)
  column "DESC_LINES2"                      datatype CHARACTER(60)
  column "DESC_LINES3"                      datatype CHARACTER(60)
  column "DESC_LINES4"                      datatype CHARACTER(60)
  column "DESC_LINES5"                      datatype CHARACTER(60)


 table                  "ORDERS"
  physical              "dat/orders.dat"
  foreign key           "CUSTOMER_NO"
   references           "CUSTOMERS" ("CUSTOMER_NO")
  foreign key           "PRODUCT_NO"
   references           "PRODUCTS" ("PRODUCT_NO")

  column "CUSTOMER_NO"                      datatype INTEGER
  column "PRODUCT_NO"                       datatype CHARACTER(12)
  column "ORDER_DATE"                       datatype ASCII DATE(6)
  column "STATUS"                           datatype CHARACTER(4)
  column "QUANTITY"                         datatype INTEGER
  column "AMOUNT"                           datatype INTEGER


 table                  "INVENTORY"
  physical              "dat/inventory.dat"

  column "PRODUCT_NO"                       datatype CHARACTER(12)
  column "INV_DATE"                         datatype ASCII DATE(6)
  column "INV_QTY"                          datatype SMALLINT
  column "INV_COST"                         datatype INTEGER
  column "INV_LOC"                          datatype CHARACTER(16)



