home *** CD-ROM | disk | FTP | other *** search
/ Power-Programmierung / CD2.mdf / c / library / dos / database / cdb / test.ddl < prev    next >
Encoding:
Text File  |  1991-03-09  |  952 b   |  40 lines
  1. /* test.ddl */
  2.  
  3. prefix ABC;     /* Unique 4 character prefix for all database files.    */
  4.                 /* Any prefix can be chosen.                            */
  5.  
  6.  
  7. struct Customer
  8.     {
  9.     connect             Address key zip;
  10.     connect             Invoice;
  11.     key long            acctNbr;
  12.     key char            company[31];
  13.     double              balance;
  14.     };
  15.  
  16. struct Address
  17.     {
  18.     char                street[31];
  19.     char                city[21];
  20.     char                state[3];
  21.     key char            zip[10];
  22.     key char            telephone[11];
  23.     };
  24.  
  25. struct Invoice
  26.     {
  27.     connect             InvoiceLine;
  28.     key long            invNbr;
  29.     double              tax;
  30.     double              total;
  31.     };
  32.  
  33. struct InvoiceLine
  34.     {
  35.     long                productNbr;
  36.     long                nbrUnits;
  37.     char                description[31];
  38.     double              total;
  39.     };
  40.