src/hg/lib/immuno.sql 1.1

1.1 2009/09/29 15:28:39 fanhsu
Created immuno.sql for GSID immuno data.
Index: src/hg/lib/immuno.sql
===================================================================
RCS file: src/hg/lib/immuno.sql
diff -N src/hg/lib/immuno.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/immuno.sql	29 Sep 2009 15:28:39 -0000	1.1
@@ -0,0 +1,15 @@
+CREATE TABLE immuno (
+subjId          char(40),	# GSID ID 
+InjPriInf       int(10), 	# Injections Prior to Infection 
+SDayLastPTest   int(10), 	# Study Day of Last Peak Test 
+LastPVisit      float,		# Last Peak Visit (Month) 
+LastPCD4Blk     float,	 	# Last Peak CD4 Blocking 
+LastPMNNeutral  int(10),	# Last Peak MN Neutralization 
+LastPAntiGP120  float,		# Last Peak anti-gp120 
+SDayLastTrTest  int(10),	# Study Day of Last Trough Test 
+LastTrVisit     int(10),	# Last Trough Visit (Month) 
+LastTrCD4Blk    float,		# Last Trough CD4 Blocking 
+LastTrMnNeutral int(10), 	# Last Trough MN Neutralization 
+LastTrAntiGP120 float,		# Last Trough anti-gp120 
+KEY subjId(subjId)
+) TYPE=MyISAM;