src/hg/instinct/raToDb/raDb.sql 1.3
1.3 2010/04/09 23:56:03 jsanborn
updated
Index: src/hg/instinct/raToDb/raDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/raToDb/raDb.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/hg/instinct/raToDb/raDb.sql 9 Apr 2010 22:58:36 -0000 1.2
+++ src/hg/instinct/raToDb/raDb.sql 9 Apr 2010 23:56:03 -0000 1.3
@@ -1,41 +1,42 @@
# raDb.sql was originally generated by the autoSql program, which also
# generated raDb.c and raDb.h. This creates the database representation of
# an object which can be loaded and saved from RAM in a fairly
# automatic way.
#ra info
CREATE TABLE raDb (
id int unsigned, # Unique id
name varchar(255), # Table name for genomic data
accessTable varchar(255), # Down-sampled table
shortLabel varchar(255), # Short label
longLabel varchar(255), # Long label
expCount int unsigned, # Number of samples
+ height int unsigned, # Image Height (only for bed 4)
groupName varchar(255), # Group name
raFile varchar(255), # RA file containing clinical info
patDb varchar(255), # Clinical info db
sampleField varchar(255), # Sample field
patTable varchar(255), # Patient to sample mapping
patField varchar(255), # Patient field
aliasTable varchar(255), # Probe to gene mapping
displayNameTable varchar(255), # Display names for aliases
dataType varchar(255), # data type (bed 15)
platform varchar(255), # Expression, SNP, etc.
expScale float, # Scaling factor
gainFull float, # Gain Full
gainSet float, # Gain Set
type varchar(255), # Unknown
visibility varchar(255), # Default visibility
priority float, # Priority for sorting
url varchar(255), # Pubmed URL
security varchar(255), # Security setting (public, private)
local_url varchar(255), # URL to local details page
profile varchar(255), # Database profile
wrangler varchar(255), # Wrangler
citation varchar(255), # Citation
article_title longblob, # Title of publication
author_list longblob, # Author list
wrangling_procedure longblob, # Wrangling
#Indices
PRIMARY KEY(id)
);