-- updated 040423 DDH

-- Map_data: breakpoint->mapbreakpoint->map->mapdata
-- Map: breakpoint->mapbreakpoint->map
-- Germplasm: breakpoint->germplasmbreakpoint->germplasm
-- Correct_name: removed
-- Other_name: removed
-- Linkage_data: removed
-- Fraction_length[1]: removed
-- Distal_deletion_in: removed
-- Distal_rearrangement: removed
-- Proximal_rearrangement: removed
-- In_chrom_band: removed
-- Not_in_chrom_band: removed

create table breakpoint (
	id integer auto_increment primary key,
	name varchar(255),
	-- Fraction_length[0]
	fractionlength float
) ENGINE=InnoDB;
create index name_index on breakpoint (name);

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

create table breakpointreference (
	id integer auto_increment primary key,
	breakpointid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index breakpointid_index on breakpointreference (breakpointid);
create index referenceid_index on breakpointreference (referenceid);

create table breakpointremark (
	id integer auto_increment primary key,
	breakpointid integer,
	-- Remark
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index breakpointid_index on breakpointremark (breakpointid);