-- updated 040504 DDH

-- Map_data: breakpointinterval->mapbreakpointinterval->map->mapdata
-- Map: breakpointinterval->mapbreakpointinterval->map
-- Correct_name: removed
-- Other_name: removed
-- Linkage_data: removed
-- Reference_stocks[1]: removed
-- Phenotype: removed
-- Does_not_contain: removed (see D.M. e-mail 040429)

create table breakpointinterval (
	id integer auto_increment primary key,
	name varchar(255),
	-- Reference_stocks[0]
	referencestock_germplasmid integer,
	-- Location
	location_colleagueid integer
) ENGINE=InnoDB;
create index name_index on breakpointinterval (name);
create index referencestock_germplasmid_index on breakpointinterval (referencestock_germplasmid);
create index location_colleagueid_index on breakpointinterval (location_colleagueid);

create table breakpointintervalnearbybreakpoint (
	id integer auto_increment primary key,
	breakpointintervalid integer,
	-- Distal_breakpoint, Proximal_breakpoint
	type varchar(100),
	breakpointid integer
) ENGINE=InnoDB;
create index breakpointintervalid_index on breakpointintervalnearbybreakpoint (breakpointintervalid);
create index breakpointid_index on breakpointintervalnearbybreakpoint (breakpointid);

create table breakpointintervalcontainslocus (
	id integer auto_increment primary key,
	breakpointintervalid integer,
	-- Contains
	locusid integer
) ENGINE=InnoDB;
create index breakpointintervalid_index on breakpointintervalcontainslocus (breakpointintervalid);
create index locusid_index on breakpointintervalcontainslocus (locusid);

create table breakpointintervalreference (
	id integer auto_increment primary key,
	breakpointintervalid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index breakpointintervalid_index on breakpointintervalreference (breakpointintervalid);
create index referenceid_index on breakpointintervalreference (referenceid);

create table breakpointintervalremark (
	id integer auto_increment primary key,
	breakpointintervalid integer,
	-- Remark
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index breakpointintervalid_index on breakpointintervalremark (breakpointintervalid);