General ISA and Foreign Key
| От | BOUCHPAN-LERUST-JUERY Lionel |
|---|---|
| Тема | General ISA and Foreign Key |
| Дата | |
| Msg-id | 20010507204632.A24888@pc48.ie2.u-psud.fr обсуждение исходный текст |
| Ответы |
Re: General ISA and Foreign Key
|
| Список | pgsql-sql |
I have a problem concerning an University assignment
in SQL. I am running PostgreSQL. Below part of the E/R diagram
in ASCII art.
( #VisaExploitation ) |-------- //\\ --------
| | // \\ | |
| 1 |<------------// \\---------| copy |
| | \\ from// | |
-------- \\ // -------- | \\// | | | /\
(#copy ) /ISA\ ------
| |
| |
---- ----
| | | |
| 2 | | 3 |
----- -----
1: Film
2: SpecialFilm
3: HistoricalFilm
2 and 3 inherits from film :
In SQL I have the following tables
CREATE TABLE film(
VisaExploitation INTEGER NOT NULL,
DureeTournage INTEGER NOT NULL,
Titre VARCHAR( 50 ),
PRIMARY KEY ( VisaExploitation ) );
CREATE TABLE filmHistorique(
NbCostume INTEGER
) INHERITS ( film );
create table filmDocumentaire() INHERITS ( film );
I have a weak entity:
CREATE TABLE copie(
NumCopie INTEGER NOT NULL,
VisaExploitation INTEGER NOT NULL,
PRIMARY KEY( VisaExploitation, NumCopie ),
FOREIGN KEY( VisaExploitation ) REFERENCES film ON DELETE CASCADE );
The problem is I have to be able to have the constraint on
both 2 and 3 and I can't figure how to implement this.
Thanking you in Advance,
Lionel
В списке pgsql-sql по дате отправления: