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. |
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
