System: |
|
Fields
idActor |
integer |
|
|
|
|
|
|
|
idEpisode |
integer |
|
|
|
|
|
|
|
strRole |
text |
|
|
|
|
|
|
|
iOrder |
integer |
|
|
|
|
|
|
|
Indexes
Foreign keys
There are no foreign keys for table "actorlinkepisode"
Checks
There are no checks for table "actorlinkepisode"
Triggers
There are no triggers for table "actorlinkepisode"
References
There are no references for table "actorlinkepisode"
Definition:
CREATE TABLE actorlinkepisode (
idActor integer,
idEpisode integer,
strRole text,
iOrder integer
);
CREATE UNIQUE INDEX ix_actorlinkepisode_1
ON actorlinkepisode
(idActor, idEpisode);
CREATE UNIQUE INDEX ix_actorlinkepisode_2
ON actorlinkepisode
(idEpisode, idActor);