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