MyVideos48
Table "directorlinktvshow"
Previous topic Chapter index Next topic

System:

Fields
Field Data type PK FK Not Null Default Collate Check On Conflict
idDirector integer              
idShow integer              

Indexes
Index Fields Primary Unique
ix_directorlinktvshow_1 idDirector, idShow  
ix_directorlinktvshow_2 idShow, idDirector  

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

Checks
      There are no checks for table "directorlinktvshow"

Triggers
      There are no triggers for table "directorlinktvshow"

References
      There are no references for table "directorlinktvshow"

Definition:
CREATE TABLE directorlinktvshow (
  idDirector  integer,
  idShow      integer
);

CREATE UNIQUE INDEX ix_directorlinktvshow_1
  ON directorlinktvshow
  (idDirector, idShow);

CREATE UNIQUE INDEX ix_directorlinktvshow_2
  ON directorlinktvshow
  (idShow, idDirector);


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