src/hg/instinct/raToDb/raDb.sql 1.1

Index: src/hg/instinct/raToDb/raDb.sql
===================================================================
RCS file: src/hg/instinct/raToDb/raDb.sql
diff -N src/hg/instinct/raToDb/raDb.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/instinct/raToDb/raDb.sql	9 Apr 2010 19:31:15 -0000	1.1
@@ -0,0 +1,39 @@
+# ra.sql was originally generated by the autoSql program, which also 
+# generated ra.c and ra.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 ra (
+    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
+    group varchar(255),	# Group for organization
+    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
+    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)
+);