Hi There,
Maybe a table MEDIA_OBJECT with a ID column that will be exported as
FK to other tables and as many columns as media types you want to
store or a single column where you'll store the bytes of your media
file.
Hope it works!
__
Michael Lourant
"Let's warm them all...&qu
favourite_colour IN ('red', 'blue', 'yellow', 'purple'))
);
INSERT INTO person(personid, favourite_colour) VALUES (1, 'red');
INSERT 0 1
Now for something not in the list:
INSERT INTO person(personid, favourite_colour) VALUES (2, 'green');
ERROR: new row for relation "person" violates check constraint
"person_favourite_colour_check"
--
Michael Lourant
"All you need is love"
