-- Created dem 5jan06.

-- Map_data: bin->mapbin->map->mapdata
-- Map: bin->mapbin->map

-- ?Bin
create table bin (
	id integer auto_increment primary key,
	name varchar(255)
) ENGINE=InnoDB;
create index name_index on bin (name);

-- ?Bin Locus
create table binlocus (
        id integer auto_increment primary key,
	binid integer,
	locusid integer
) ENGINE=InnoDB;
create index binid_index on binlocus (binid);
create index locusid_index on binlocus (locusid);

-- ?Bin Bin_locus
create table binbinlocus (
        id integer auto_increment primary key,
	binid integer,
	locusid integer
) ENGINE=InnoDB;
create index binid_index on binbinlocus (binid);
create index locusid_index on binbinlocus (locusid);

-- ?Bin Bin_marker
create table binbinmarker (
        id integer auto_increment primary key,
	binid integer,
	locusid integer
) ENGINE=InnoDB;
create index binid_index on binbinmarker (binid);
create index locusid_index on binbinmarker (locusid);

-- ?Bin Data_source ?Colleague Text  // Text is date, eg 2006.01
create table bindatasource (
        id integer auto_increment primary key,
        binid integer,
        -- Data_curated
        colleagueid integer,
        date varchar(25)
) ENGINE=InnoDB;
create index binid_index on bindatasource (binid);
create index colleagueid_index on bindatasource (colleagueid);