Data retrieval: Fields Information
Previous  Next



Fields Information is a report summarizing the structure of fields of the SNPs and Samples tables:

Time: 14 : 32 : 07 
Date: 16 / 08 / 2005
User: advanced                         
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Study: sample 1    
--------------------------------------------------------------------------------


------------------------------------------------------------------------------------------
        SNPs Attributes                    Types                        Values           
------------------------------------------------------------------------------------------
code                                    varchar(32)        
dbsnp                                   varchar(32)        
build                                   varchar(32)        
celera                                  varchar(32)        
chromosome                                char(2)          
position                                bigint(20)         
alleles                                 varchar(16)        
region                                  varchar(32)        
gene                                    varchar(32)        
pool                                    varchar(32)        
frequency                              double(25,4)        


------------------------------------------------------------------------------------------
      Samples Attributes                   Types                        Values           
------------------------------------------------------------------------------------------
code                                    varchar(32)        
family                                  varchar(32)        
father                                  varchar(32)        
mother                                  varchar(32)        
sex                                       char(1)          
age                                       int(11)          
afection                                  char(1)          
category                                varchar(32)        
disease                                 varchar(64)        
alcoholic                                 list(1)                       n, u, y          
ppp                                       text(3)          

You may want to use this report to keep track of the structure changes and Descriptor additions that the Study may undergo.