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