sh relations
User Relations in Database with pathname  _CDD$TOP.BASSETT.GOLF.GOLFRDB
     COURSE_STATISTICS               
     GOLF_COURSES                    
     MENU                            
     PLAYERS                         
     SCORES                          
     SECURITY                        
SH FIELDS FOR GOLF_COURSES
 Fields for relation  GOLF_COURSES
     COURSE_NAME                      text size is  30
       based on global field  NAME                           
     ADDRESS_1                        text size is  30
       based on global field  ADDRESS                        
     ADDRESS_2                        text size is  30
       based on global field  ADDRESS                        
     CITY                             text size is  20
     STATE                            text size is  2
     ZIP                              signed longword scale  0
     PHONE                            text size is  10
     COURSE_PRO                       text size is  30
       based on global field  NAME                           
     GREEN_FEE_WEEKDAY                F_floating 
       based on global field  FEES                           
     GREEN_FEE_WEEKEND                F_floating 
       based on global field  FEES                           
     CART_FEE_WEEKDAY                 F_floating 
       based on global field  FEES                           
     CART_FEE_WEEKEND                 F_floating 
       based on global field  FEES                           
     FOOD                             text size is  1
       based on global field  SERVICE_FLAGS                  
     BAR                              text size is  1
       based on global field  SERVICE_FLAGS                  
     PRO_SHOP                         text size is  1
       based on global field  SERVICE_FLAGS                  
     DRIVING_RANGE                    text size is  1
       based on global field  SERVICE_FLAGS                  
     PUTTING_GREEN                    text size is  1
       based on global field  SERVICE_FLAGS                  
     LIGHTS                           text size is  1
       based on global field  SERVICE_FLAGS                  
     PUBLIC                           text size is  1
       based on global field  SERVICE_FLAGS                  
SH FIELDS FOR COURSE_STATISTICS
 Fields for relation  COURSE_STATISTICS
     COURSE_NAME                      text size is  30
       based on global field  NAME                           
     TEES_TYPE                        text size is  15
     PAR_1_9                          signed word scale  0
       based on global field  PAR                            
     PAR_10_18                        signed word scale  0
       based on global field  PAR                            
     PAR                              signed word scale  0
     RATING                           F_floating 
     YARDAGE_1_9                      signed word scale  0
       based on global field  YARDS                          
     YARDAGE_10_18                    signed word scale  0
       based on global field  YARDS                          
     TOTAL_YARDAGE                    signed word scale  0
       based on global field  YARDS                          
     METERS_1_9                       signed word scale  0
       based on global field  METERS                         
     METERS_10_18                     signed word scale  0
       based on global field  METERS                         
     TOTAL_METERS                     signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_1                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_1                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_1                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_1                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_2                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_2                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_2                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_2                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_3                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_3                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_3                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_3                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_4                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_4                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_4                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_4                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_5                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_5                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_5                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_5                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_6                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_6                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_6                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_6                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_7                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_7                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_7                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_7                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_8                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_8                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_8                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_8                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_9                       signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_9                  signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_9                   signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_9                    signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_10                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_10                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_10                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_10                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_11                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_11                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_11                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_11                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_12                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_12                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_12                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_12                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_13                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_13                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_13                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_13                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_14                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_14                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_14                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_14                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_15                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_15                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_15                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_15                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_16                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_16                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_16                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_16                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_17                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_17                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_17                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_17                   signed word scale  0
       based on global field  METERS                         
     PAR_HOLE_18                      signed word scale  0
       based on global field  PAR                            
     HANDICAP_HOLE_18                 signed word scale  0
       based on global field  HANDICAP                       
     YARDAGE_HOLE_18                  signed word scale  0
       based on global field  YARDS                          
     METERS_HOLE_18                   signed word scale  0
       based on global field  METERS                         
SH FIELDS FOR PLAYERS
 Fields for relation  PLAYERS
     PLAYER_NAME                      text size is  30
       based on global field  NAME                           
     ADDRESS_1                        text size is  30
       based on global field  ADDRESS                        
     ADDRESS_2                        text size is  30
       based on global field  ADDRESS                        
     CITY                             text size is  20
     STATE                            text size is  2
     ZIP                              signed longword scale  0
     PHONE                            text size is  10
     HANDICAP                         signed word scale  0
     PLAYER_SEX                       text size is  1
SH FIELDS FOR SCORES
 Fields for relation  SCORES
     PLAYER_NAME                      text size is  30
       based on global field  NAME                           
     COURSE_NAME                      text size is  30
       based on global field  NAME                           
     TEES_TYPE                        text size is  15
     SCORE                            signed word scale  0
     DATE                             Date 
     RATING                           F_floating 
     ADJ_SCORE                        signed word scale  0
     HANDICAP_SCORE                   F_floating 
       based on global field  RDB$0001600009                 
       edit string     zz9.9
       computed        by adj_score - rating 
     OLD_HANDICAP                     signed word scale  0
       based on global field  HANDICAP                       
     NEW_HANDICAP                     signed word scale  0
       based on global field  HANDICAP                       
SH FIELDS FOR MENU
 Fields for relation  MENU
     MENU_CODE                        text size is  2
     MENU_DESC                        text size is  50
     MENU_COMMAND                     text size is  20
     SECURITY_LEVEL                   text size is  1
SH FIELDS FOR SECURITY
 Fields for relation  SECURITY
     USERNAME                         text size is  12
     SECURITY_LEVEL                   text size is  1
SH INDEXES
User Indexes in Database with pathname  _CDD$TOP.BASSETT.GOLF.GOLFRDB
 
 Indexes for relation  COURSE_STATISTICS              
STATISTICS_IDX                   with field  COURSE_NAME                    
                                  and field  TEES_TYPE                      
                                 No duplicates allowed  
 
 Indexes for relation  GOLF_COURSES                   
GOLF_COURSE_IDX                  with field  COURSE_NAME                    
                                 No duplicates allowed  
 
 Indexes for relation  MENU                           
MENU_IDX                         with field  MENU_CODE                      
                                 No duplicates allowed  
 
 Indexes for relation  PLAYERS                        
PLAYER_IDX                       with field  PLAYER_NAME                    
                                 No duplicates allowed  
 
 Indexes for relation  SCORES                         
PLAYER_SCORE_IDX                 with field  PLAYER_NAME                    
                                  and field  DATE                           
                                 Duplicates are allowed  
 
 Indexes for relation  SECURITY                       
SECURITY_IDX                     with field  USERNAME                       
                                 No duplicates allowed  
EXIT
