/* test.ddl */

prefix ABC;     /* Unique 4 character prefix for all database files.    */
                /* Any prefix can be chosen.                            */


struct Customer
    {
    connect             Address;
    connect             Invoice;
    key long            acctNbr;
    key char            company[31];
    double              balance;
    };

struct Address
    {
    char                street[31];
    char                city[21];
    char                state[3];
    key char            zip[10];
    key char            telephone[11];
    };

struct Invoice
    {
    connect             InvoiceLine;
    key long            invNbr;
    double              tax;
    double              total;
    };

struct InvoiceLine
    {
    long                productNbr;
    long                nbrUnits;
    char                description[31];
    double              total;
    };