PROGRESS-PLUS.com logo   DATABASE TABLE STRUCTURE

Customer

 LABEL:  
DESCRIPTION: Customer information

TABLE STRUCTURE
  key  Name   Label   Datatype   Format   Extent  Mnd.  Default   View-As
  Customer            
PK n/m  Cust-Num     integer  >>>>9  0 no  0  ?
 Address     character  x(20)  0 no     ?
 Address2     character  x(20)  0 no     ?
 Balance     decimal  ->,>>>,>>9.99  0 no  0  ?
 City     character  x(12)  0 no     ?
 Comments     character  x(60)  0 no     ?
 Contact     character  x(20)  0 no     ?
 Country  Country Name  character  x(20)  0 no  USA  ?
Maximum credit  Credit-Limit     decimal  ->,>>>,>>9  0 no  1500  ?
 Discount     integer  >>9%  0 no  0  ?
 ext  Extent Field  character  X(8)  5 no     ?
 Name     character  x(20)  0 no     ?
Format/Label/Help based on status of NON-US field.  Phone     character  x(20)  0 no     ?
Format/Label/Help Message based on status of NON-US field.  Postal-Code     character  x(10)  0 no     ?
FK  Sales-Rep     character  X(4)  0 no     ?
Label/Valexp/Valmsg/Help are set based on value of NON-US field! FK  State     character  x(20)  0 no     ?
 Terms     character  x(20)  0 no  Net30  ?
 Comments  Active ** Index is not used. [112]
 Comments  Ascending
 Country-Post  Active ** Index is not used. [112]
 Country  Ascending
 Postal-Code  Ascending
PK  Cust-Num  Unique Active  ** Redundant Index. [114] (by iCustNum-Name)
 Cust-Num  Ascending
 iCustNum-Name  Active ** Index is not used. [112]
 Cust-Num  Ascending
 Name  Ascending
 iName2  Active 
 Name  Ascending
 Phone  Ascending
 Name  Active  ** Redundant Index. [114] (by iName2)** Index is not used. [112]
 Name  Ascending
 Sales-Rep  Active ** Index is not used. [112]
 Sales-Rep  Ascending

TABLE RELATIONS
CHILD TABLES (Child Table OF Customer)
Customer information  Customer
This contains transactions for the Receivables system  Invoice  
 Cust-Num  
Order header information  Order  
 Cust-Num  
 Ref-Call  
 Cust-Num  
 
PARENT TABLES (Customer OF Parent Table)
Customer information  Customer
Sales representative information  Salesrep  
 Sales-Rep  
Table of state abbreviation with sales regions  State  
 State  

TABLE TRIGGERS
EVENT TRIGGER FILE NAME OVERRIDE
CREATE sports/crcust.p no
DELETE sports/delcust.p no
WRITE sports/wrcust.p no

FOREIGN KEYS NOT DEFINED
# FIELD NAME POSSIBLE RELATION NOTES
Customer
1 State State.State  

TABLE USAGE ANALYSIS
MODULE NAME ACCESS CREATE DELETE REFERENCE SORT-ACCESS UPDATE NOTES
flex.w 24     6 1 8 ** File is not used. [100]
dtable.w 15            
dbgrid.w 6     3     ** File is not used. [100]
mail-lbl.p 4     1 1   ** File is not used. [100]
GetCust.p 1     2     ** File is not used. [100]
SetCust.p       1     ** File is not used. [100]
runSDO.p       1     ** File is not used. [100]
runServerSDO.p       1     ** File is not used. [100]
psval.p 2     2     ** File is not used. [100]
example15.p       1     ** File is not used. [100]
example8.p 2           ** File is not used. [100]
customers.p 1     2      

FIELDS USAGE ANALYSIS
FIELD NAME ACCESS REFERENCE SORT-ACCESS UPDATE NOTES
Customer.Address        
Customer.Address2        
Customer.Balance      
Customer.City  
Customer.Comments        
Customer.Contact        
Customer.Country        
Customer.Credit-Limit        
Customer.Cust-Num      
Customer.Discount        
Customer.ext         ** Field is not used. [113]
Customer.Name    
Customer.Phone      
Customer.Postal-Code      
Customer.Sales-Rep        
Customer.State    
Customer.Terms        

INDEXES USAGE ANALYSIS
INDEX NAME MODULES USING NOTES
Comments   ** Index is not used. [112]
Country-Post   ** Index is not used. [112]
Cust-Num    
iCustNum-Name   ** Index is not used. [112]
iName2    
Name   ** Index is not used. [112]
Sales-Rep   ** Index is not used. [112]


Last updated 05/05/2003 6:47:39 pm
Generated by PRO4m v3.02.00.