-- updated 040423 DDH

-- Other_name: removed
-- Contents: removed
-- Mail: removed
-- Phone: removed
-- E_mail: removed
-- Fax: removed

create table source (
	id integer auto_increment primary key,
	name varchar(255),
	-- Remarks
	remark text,
	-- Contact
	contact_colleagueid integer,
	-- Reference
	referenceid integer,
	-- Journal
	journalid integer
) ENGINE=InnoDB;
create index name_index on source (name);
create index contact_colleagueid_index on source (contact_colleagueid);
create index referenceid_index on source (referenceid);
create index journalid_index on source (journalid);