Orders

The Orders sample database is a simple flat file database that is used in many of the examples throughout this documentation. It is also shipped with every server software installation and can be used to test an installation.

ENVIRONMENT ORDERS

DATABASE "ORDERS"
TYPE FLATFILE
INDEXPREFIX "C:\demos\env\ffl\orders\idx\ord"

TABLE "CUSTOMERS"
PHYSICAL "C:\demos\data\ffl\orders\customers.flat"
PARENT KEY "CUSTOMER_NO"

COLUMN "CUSTOMER_NO" DATATYPE INTEGER
COLUMN "COMPANY" DATATYPE CHAR(40)
COLUMN "CONTACT" DATATYPE CHAR(24)
COLUMN "TITLE" DATATYPE CHAR(30)
COLUMN "SALUTATION" DATATYPE CHAR(24)
COLUMN "ADDRESS1" DATATYPE CHAR(30)
COLUMN "ADDRESS2" DATATYPE CHAR(30)
COLUMN "CITY" DATATYPE CHAR(20)
COLUMN "STATE" DATATYPE CHAR(2)
COLUMN "POSTAL_CODE" DATATYPE CHAR(10)
COLUMN "COUNTRY" DATATYPE CHAR(20)
COLUMN "PHONE_NO" DATATYPE CHAR(18)
COLUMN "FAX_NO" DATATYPE CHAR(20)
COLUMN "AKA_COMPANY" DATATYPE CHAR(20)
COLUMN "COMMENTS" DATATYPE CHAR(60)
COLUMN "LICENSEE" DATATYPE INTEGER
column "PH_ZP2" datatype C STRING(16)
as "substring(PHONE_no from 4 for 7) || POSTAL_CODE"
column "PHONE2" datatype C STRING(7) cardinality 4418
as "substring(PHONE_NO from 4 for 7)"

TABLE "PRODUCTS"
PHYSICAL "C:\demos\data\ffl\orders\products.flat"
PARENT KEY "PRODUCT_NO"

COLUMN "PRODUCT_NO" DATATYPE CHAR(12)
COLUMN "PRODUCT_CLASS" DATATYPE CHAR(20)
COLUMN "PRODUCT_NAME" DATATYPE CHAR(40)
COLUMN "SALES_PRICE" DATATYPE INTEGER
COLUMN "PRODUCT_COST" DATATYPE INTEGER

TABLE "ACTIVITY"
PHYSICAL "C:\demos\data\ffl\orders\activity.flat"
CHILD KEY "CUSTOMER_NO" REFERENCES CUSTOMERS(CUSTOMER_NO)

COLUMN "CUSTOMER_NO" DATATYPE INTEGER
COLUMN "DATE_TICKLER" DATATYPE ASCII DATE(6)
COLUMN "TICKLER" DATATYPE CHAR(2)
COLUMN "INITIALS" DATATYPE CHAR(4)
COLUMN "ACTION_INFO" DATATYPE CHAR(60)

TABLE "CUST_NOTES"
PHYSICAL "C:\demos\data\ffl\orders\custnote.flat"
CHILD KEY "CUSTOMER_NO" REFERENCES CUSTOMERS(CUSTOMER_NO)

COLUMN "CUSTOMER_NO" DATATYPE INTEGER
COLUMN "DATE_ENTERED" DATATYPE ASCII DATE(6)
COLUMN "ENTERED_BY" DATATYPE CHAR(4)
COLUMN "DESC_LINES1" DATATYPE CHAR(60)
COLUMN "DESC_LINES2" DATATYPE CHAR(60)
COLUMN "DESC_LINES3" DATATYPE CHAR(60)
COLUMN "DESC_LINES4" DATATYPE CHAR(60)
COLUMN "DESC_LINES5" DATATYPE CHAR(60)

TABLE "ORDERS"
PHYSICAL "C:\demos\data\ffl\orders\orders.flat"
CHILD KEY "CUSTOMER_NO" REFERENCES CUSTOMERS(CUSTOMER_NO)
CHILD KEY "PRODUCT_NO" REFERENCES PRODUCTS(PRODUCT_NO)

COLUMN "CUSTOMER_NO" DATATYPE INTEGER
COLUMN "PRODUCT_NO" DATATYPE CHAR(12)
COLUMN "ORDER_DATE" DATATYPE ASCII DATE(6)
COLUMN "STATUS" DATATYPE CHAR(4)
COLUMN "QUANTITY" DATATYPE INTEGER
COLUMN "AMOUNT" DATATYPE INTEGER

TABLE "INVENTORY"
PHYSICAL "C:\demos\data\ffl\orders\inventory.flat"

COLUMN "PRODUCT_NO" DATATYPE CHAR(12)
COLUMN "INV_DATE" DATATYPE ASCII DATE(6)
COLUMN "INV_QTY" DATATYPE SMALLINT
COLUMN "INV_COST" DATATYPE INTEGER
COLUMN "INV_LOC" DATATYPE CHAR(16)

Top