System: |
|
Fields
idGenre |
integer |
|
|
|
|
|
|
|
idMovie |
integer |
|
|
|
|
|
|
|
sorting |
integer |
|
|
|
|
|
|
|
Indexes
Foreign keys
There are no foreign keys for table "genrelinkmovie"
Checks
There are no checks for table "genrelinkmovie"
Triggers
There are no triggers for table "genrelinkmovie"
References
There are no references for table "genrelinkmovie"
Definition:
CREATE TABLE genrelinkmovie (
idGenre integer,
idMovie integer,
sorting integer
);
CREATE UNIQUE INDEX ix_genrelinkmovie_1
ON genrelinkmovie
(idGenre, idMovie);
CREATE UNIQUE INDEX ix_genrelinkmovie_2
ON genrelinkmovie
(idMovie, idGenre);