
CREATE TABLE enzyme (
	id INTEGER, 
	name TEXT, 
	"Location" TEXT, 
	"Product" TEXT, 
	"Chromosome" TEXT, 
	"OMIM" INTEGER, 
	"Porphyria" TEXT, 
	PRIMARY KEY (id)
)


CREATE TABLE medicine (
	id INTEGER, 
	name TEXT, 
	"Trade_Name" TEXT, 
	"FDA_approved" TEXT, 
	PRIMARY KEY (id)
)


CREATE TABLE medicine_enzyme_interaction (
	enzyme_id INTEGER, 
	medicine_id INTEGER, 
	interaction_type TEXT, 
	PRIMARY KEY (enzyme_id, medicine_id), 
	FOREIGN KEY(medicine_id) REFERENCES medicine (id), 
	FOREIGN KEY(enzyme_id) REFERENCES enzyme (id)
)

CREATE TABLE enzyme (
	id INTEGER, 
	name TEXT, 
	"Location" TEXT, 
	"Product" TEXT, 
	"Chromosome" TEXT, 
	"OMIM" INTEGER, 
	"Porphyria" TEXT, 
	PRIMARY KEY (id)
)

/*
2 rows from enzyme table:
id	name	Location	Product	Chromosome	OMIM	Porphyria
1	ALA synthase	Mitochondrion	δ-Aminolevulinic acid	3p21.1	125290	none
2	ALA dehydratase	Cytosol	Porphobilinogen	9q34	125270	ALA-Dehydratase deficiency
*/


CREATE TABLE medicine (
	id INTEGER, 
	name TEXT, 
	"Trade_Name" TEXT, 
	"FDA_approved" TEXT, 
	PRIMARY KEY (id)
)

/*
2 rows from medicine table:
id	name	Trade_Name	FDA_approved
1	Amisulpride	Solian	No
2	Aripiprazole	Abilify	Yes
*/


CREATE TABLE medicine_enzyme_interaction (
	enzyme_id INTEGER, 
	medicine_id INTEGER, 
	interaction_type TEXT, 
	PRIMARY KEY (enzyme_id, medicine_id), 
	FOREIGN KEY(medicine_id) REFERENCES medicine (id), 
	FOREIGN KEY(enzyme_id) REFERENCES enzyme (id)
)

/*
2 rows from medicine_enzyme_interaction table:
enzyme_id	medicine_id	interaction_type
1	1	inhibitor
1	2	inhibitor
*/
What is the product, chromosome, and porphyria of the enzymes located at 'Cytosol'?
SELECT product ,  chromosome ,  porphyria FROM enzyme WHERE LOCATION  =  'Cytosol'
[{'Product': 'Porphobilinogen', 'Chromosome': '9q34', 'Porphyria': 'ALA-Dehydratase deficiency'}, {'Product': 'Hydroxymethyl bilane', 'Chromosome': '11q23.3', 'Porphyria': 'acute intermittent porphyria'}, {'Product': 'Uroporphyrinogen III', 'Chromosome': '10q25.2-q26.3', 'Porphyria': 'congenital erythropoietic porphyria'}, {'Product': 'Coproporphyrinogen III', 'Chromosome': '1p34', 'Porphyria': 'porphyria cutanea tarda'}]