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.