List:General Discussion« Previous MessageNext Message »
From:Ayman Haidar Date:March 21 1999 5:27pm
Subject:design question
View as plain text  
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.			|
 -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

Thread
design questionAyman Haidar21 Mar
Re: design questionFred Lindberg21 Mar