DB question ... thanks

Suppose that I have the basic db structure as follow:

imgnum varchar(16)
description text
imagecode varchar(16)
note text
photographer varchar(16)
date date
location varchar(50)

The <imgnum> format is as follows(and its unique):
J-1 ... J-200
K-1 ... K-250
V-1 ... V-128

But some they have a few sub-images e.g: J-1 has say, J-J-1a, J-1b, J-1c
which represent the same pic but more details views; and the same with the
K-, and V- as well.

How do I structure the following in MySQL?

Thanks in advanceUseko Netsumi wrote:

>Suppose that I have the basic db structure as follow:
>imgnum varchar(16)
>description text
>imagecode varchar(16)
>note text
>photographer varchar(16)
>date date
>location varchar(50)
>The <imgnum> format is as follows(and its unique):
> J-1 ... J-200
> K-1 ... K-250
> V-1 ... V-128
>But some they have a few sub-images e.g: J-1 has say, J-J-1a, J-1b, J-1c
>which represent the same pic but more details views; and the same with the
>K-, and V- as well.
>How do I structure the following in MySQL?
>Thanks in advance
>
Suppose you explain why you posted this in just about every usenet group
you could spell.
You posted in groups for Sybase, SQL Server, Access, Dreamweaver,
Oracle, etc.
when your question has absolutely nothing to do with any of them.

Please do not post in usenet groups unless you are on-topic. And please
read the FAQ for a
group in the future before wasting everyone's time.

Thank you.

--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||sorry for your trouble. perhaps you can tell me where should I post for this
type of question.

thanks

"Daniel Morgan" <damorgan@.x.washington.edu> wrote in message
news:1066675699.814023@.yasure...
> Useko Netsumi wrote:
> >Suppose that I have the basic db structure as follow:
> >imgnum varchar(16)
> >description text
> >imagecode varchar(16)
> >note text
> >photographer varchar(16)
> >date date
> >location varchar(50)
> >The <imgnum> format is as follows(and its unique):
> > J-1 ... J-200
> > K-1 ... K-250
> > V-1 ... V-128
> >But some they have a few sub-images e.g: J-1 has say, J-J-1a, J-1b, J-1c
> >which represent the same pic but more details views; and the same with
the
> >K-, and V- as well.
> >How do I structure the following in MySQL?
> >Thanks in advance
> Suppose you explain why you posted this in just about every usenet group
> you could spell.
> You posted in groups for Sybase, SQL Server, Access, Dreamweaver,
> Oracle, etc.
> when your question has absolutely nothing to do with any of them.
> Please do not post in usenet groups unless you are on-topic. And please
> read the FAQ for a
> group in the future before wasting everyone's time.
> Thank you.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/...oad/oad_crs.asp
> http://www.outreach.washington.edu/...aoa/aoa_crs.asp
> damorgan@.x.washington.edu
> (replace 'x' with a 'u' to reply)|||Useko Netsumi wrote:

>sorry for your trouble. perhaps you can tell me where should I post for this
>type of question.
>thanks
>"Daniel Morgan" <damorgan@.x.washington.edu> wrote in message
>news:1066675699.814023@.yasure...
>
>>Useko Netsumi wrote:
>>
>>
>>
>>>Suppose that I have the basic db structure as follow:
>>>
>>>imgnum varchar(16)
>>>description text
>>>imagecode varchar(16)
>>>note text
>>>photographer varchar(16)
>>>date date
>>>location varchar(50)
>>>
>>>The <imgnum> format is as follows(and its unique):
>>> J-1 ... J-200
>>> K-1 ... K-250
>>> V-1 ... V-128
>>>
>>>But some they have a few sub-images e.g: J-1 has say, J-J-1a, J-1b, J-1c
>>>which represent the same pic but more details views; and the same with
>>>
>>>
>the
>
>>>K-, and V- as well.
>>>
>>>How do I structure the following in MySQL?
>>>
>>>Thanks in advance
>>>
>>>
>>>
>>>
>>>
>>Suppose you explain why you posted this in just about every usenet group
>>you could spell.
>>You posted in groups for Sybase, SQL Server, Access, Dreamweaver,
>>Oracle, etc.
>>when your question has absolutely nothing to do with any of them.
>>
>>Please do not post in usenet groups unless you are on-topic. And please
>>read the FAQ for a
>>group in the future before wasting everyone's time.
>>
>>Thank you.
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/...oad/oad_crs.asp
>>http://www.outreach.washington.edu/...aoa/aoa_crs.asp
>>damorgan@.x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>
>>
>>
You could start by going to http://www.google.com and looking up the
product you are working with.

--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)