MyVideos48
Table "gueststarlinkepisode"
Previous topic Chapter index Next topic

System:

Fields
Field Data type PK FK Not Null Default Collate Check On Conflict
idActor integer              
idEpisode integer              
strRole text              
iOrder integer              

Indexes
Index Fields Primary Unique
ix_gueststarlinkepisode_1 idActor, idEpisode  
ix_gueststarlinkepisode_2 idEpisode, idActor  

Foreign keys
      There are no foreign keys for table "gueststarlinkepisode"

Checks
      There are no checks for table "gueststarlinkepisode"

Triggers
      There are no triggers for table "gueststarlinkepisode"

References
      There are no references for table "gueststarlinkepisode"

Definition:
CREATE TABLE gueststarlinkepisode (
  idActor    integer,
  idEpisode  integer,
  strRole    text,
  iOrder     integer
);

CREATE UNIQUE INDEX ix_gueststarlinkepisode_1
  ON gueststarlinkepisode
  (idActor, idEpisode);

CREATE UNIQUE INDEX ix_gueststarlinkepisode_2
  ON gueststarlinkepisode
  (idEpisode, idActor);


Previous topic Chapter index Next topic
Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20