##########################################################################
# Genes.sql:  MySQL source file for the Simcal1 module.                  #
# Copyright (c) 2004 Daniel Dvorkin.                                     #
# Distributed under the Artistic License, WITHOUT "optional clause 8"    #
# (see http://www.opensource.org/licenses/artistic-license.php).         #
# All rights not granted in this license are reserved by the author.     #
##########################################################################

drop table if exists Genes;
create table Genes
(
	# common DbEntity attributes
	Id					int			not null,
	Exp1				double		not null, # 0:30 time point
	Exp2				double		not null, # 2:00 time point
	Exp3				double		not null, # 8:30 time point
	Variability			double		not null,
	UserAnnotation		text		not null,
	
	# table-specific attributes
	Reliability			double		not null,
	AffyName			text		not null,
	AffyAnnotation		text		not null,
	
	# key definition
	primary key(Id)	
);
	
	