From: Ayman Haidar
Date: March 21 1999 5:27pm
Subject: design question
List-Archive: http://lists.mysql.com/mysql/715
Message-Id: <19990321122705.B13020@usol.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hello:

I would like to design a table for medicines, as you know they come in
different dosages and different frequency. I was woindering what is the
best way to create the table, I was thinking like this;

create table meds (
	ID int,
	name varchar(30),
	generic_name varchar(50),
	doses (text or varchar..)
	.
	..
	.
);

as you can see I can insert doeses as 30,45,60...

do you think this is the best design or you have other ideas.

thanks in advance.

-- 
 -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
|		Ayman Haidar						|
|		haidar@stripped						|
|		just another linux and vi lover.			|
 -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-