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