MIPS_genes (
	orf			VARCHAR PRIMARY KEY,
	gene_name		VARCHAR,
	coordinates		VARCHAR,
	classification		INTEGER,
	description		VARCHAR
);

MIPS_interaction (
	id			INTEGER,
	orf1			VARCHAR,
	gene1			VARCHAR,
	relationship		VARCHAR,
	orf2			VARCHAR,
	gene2			VARCHAR,
	description		VARCHAR,
	reference		VARCHAR,
	evidence		VARCHAR,
	FOREIGN KEY (orf1, gene1) REFERENCES MIPS_genes (orf, gene_name),
	FOREIGN KEY (orf2, gene2) REFERENCES MIPS_genes (orf, gene_name)
);

MIPS_gene_alias (
	orf			VARCHAR,
	gene			VARCHAR,
	alias			VARCHAR
);

MIPS_complex_category (
	cid			VARCHAR,
	name			VARCHAR
);

MIPS_complex (
	complex		VARCHAR
REFERENCES MIPS_complex_category (cid),
	entry			VARCHAR,
	ref			VARCHAR,
	evidence		VARCHAR
);