simple association/ordering table
From: rollingstone <rollingstone_at_email.com>
Date: Wed, 24 Mar 2004 23:01:19 +0100
Message-ID: <c3t0fh$2ar1ev$1_at_ID-203138.news.uni-berlin.de>
Hi all,
I am working on a small application to allow the user to group photos in an album with the functionalities to order the photos within each album and to associate each photo to more albums (many-to-many relationship).
);
);
Received on Wed Mar 24 2004 - 23:01:19 CET
Date: Wed, 24 Mar 2004 23:01:19 +0100
Message-ID: <c3t0fh$2ar1ev$1_at_ID-203138.news.uni-berlin.de>
Hi all,
I am working on a small application to allow the user to group photos in an album with the functionalities to order the photos within each album and to associate each photo to more albums (many-to-many relationship).
Here are the two tables to store the albums and the photos (I've removed some columns for simplicity reasons):
CREATE TABLE Album (
AlbumID INTEGER NOT NULL, AlbumName VARCHAR2(20) NOT NULL, CONSTRAINT PRIMARY KEY (AlbumID)
);
CREATE TABLE Photo (
PhotoID INTEGER NOT NULL, PhotoName VARCHAR2(20) NOT NULL, CONSTRAINT PRIMARY KEY (PhotoID)
);
Received on Wed Mar 24 2004 - 23:01:19 CET