DB question ... thanks

From: Useko Netsumi <_no-spam_usenets_at_nyc.rr.com>
Date: Mon, 20 Oct 2003 13:13:19 -0400
Message-ID: <bn153h$rukds$1@ID-205437.news.uni-berlin.de>

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 Received on Mon Oct 20 2003 - 12:13:19 CDT