DATABASE STRUCTURE -- DBLicense (H:\Licenses\D) 10/04/2001 21:05

Table: Command.DB
  Fields                    Type(Size)  Required
    IDCommand                 +            No 
    IDCustomer                Integer      Yes
  Indexes
    (no name)   IDCommand                 [Primary,Unique]
    xIDCustomer: IDCustomer                [CaseInsens]

Table: CommandLigne.DB
  Fields                    Type(Size)  Required
    IDlcCommand               Integer      No 
    IDlcComLigne              +            No 
    IDProduct                 Integer      No 
    Quantity                  Short        No 
    Price                     Money        No 
  Indexes
    (no name)   IDlcCommand;IDlcComLigne  [Primary,Unique]

Table: Customer.db
  Fields                    Type(Size)  Required
    IDCustomer                +            No 
    LastName                  A(40)        No 
    FirstName                 A(40)        No 
    Company                   A(60)        No 
    Status                    A(4)         No 
    Email                     A(100)       No 
    Address1                  A(20)        No 
    Address2                  A(20)        No 
    City                      A(30)        No 
    State                     A(30)        No 
    Zip                       A(30)        No 
    Country                   A(30)        No 
    Phone                     A(30)        No 
    Fax                       A(30)        No 
    Comments                  A(255)       No 
  Indexes
    (no name)   IDCustomer                [Primary,Unique]
    ixNomPrenom: LastName;FirstName        [CaseInsens]

Table: Product.DB
  Fields                    Type(Size)  Required
    IDProduct                 +            No 
    ProdName                  A(50)        No 
    ProdCategory              A(5)         No 
    ProdPrice                 Money        No 
  Indexes
    (no name)   IDProduct                 [Primary,Unique]
