-- updated 24jan05 dem

-- Publishes_as: colleague->author
-- Institution: removed

create table colleague (
	id integer auto_increment primary key,
	name varchar(255),
	-- Last_update
	lastupdate varchar(25)
) ENGINE=InnoDB;
create index name_index on colleague (name);

create table colleagueaddress (
	id integer auto_increment primary key,
	colleagueid integer,
	-- Mail
	mail varchar(255),
	-- Country
	country varchar(100),
	-- Phone
	phone varchar(100),
	-- Fax
	fax varchar(100),
	-- Telex
	telex varchar(100)
) ENGINE=InnoDB;
create index colleagueid_index on colleagueaddress (colleagueid);

create table colleagueemail (
	id integer auto_increment primary key,
	colleagueid integer,
	-- E_mail
	email varchar(100)
) ENGINE=InnoDB;
create index colleagueid_index on colleagueemail (colleagueid);

create table colleagueremark (
        id integer auto_increment primary key,
	colleagueid integer,
	-- Position, Profession, WWW_page, Background
	-- Research_interest, Remark
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index colleagueid_index on colleagueremark (colleagueid);

create table colleagueimage (
	id integer auto_increment primary key,
	colleagueid integer,
	-- Image
	imageid integer
) ENGINE=InnoDB;
create index colleagueid_index on colleagueimage (colleagueid);
create index imageid_index on colleagueimage (imageid);

create table colleagueobtainedfrom (
	id integer auto_increment primary key,
	colleagueid integer,
	-- Obtained_from
	sourceid integer,
	date varchar(25)
) ENGINE=InnoDB;
create index colleagueid_index on colleagueobtainedfrom (colleagueid);
create index sourceid_index on colleagueobtainedfrom (sourceid);