-- created 8apr04 DEM
-- updated 040423 DDH

-- Probe: gel->probe

-- TABLE: removed

create table gel (
	id integer auto_increment primary key,
	name varchar(50)
) ENGINE=InnoDB;
create index name_index on gel (name);

create table gelpolymorphism (
	id integer auto_increment primary key,
	gelid integer,
	-- Polymorphism
	polymorphismid integer
) ENGINE=InnoDB;
create index gelid_index on gelpolymorphism (gelid);
create index polymorphismid_index on gelpolymorphism (polymorphismid);

--        Band ?Restriction Float UNIQUE Int UNIQUE Text  // many/many
--			// There may be multiple Float's per ?Restriction. 
--			// Example, Gel "PSR112 Gale"
create table gelband (
	id integer auto_increment primary key,
	gelid integer,
	-- Band
	restrictionenzymeid integer,
	size float,
	intensity int,
	chromosomearm varchar(10)
) ENGINE=InnoDB;       
create index gelid_index on gelband (gelid);
create index restrictionenzymeid_index on gelband (restrictionenzymeid);

create table geldatasource (
	id integer auto_increment primary key,
	gelid integer,
	-- Data_source
	colleagueid integer,
	date varchar(25)
) ENGINE=InnoDB;
create index gelid_index on geldatasource (gelid);
create index colleagueid_index on geldatasource (colleagueid);