MyVideos48
Table "art"
Previous topic Chapter index Next topic

System:

Fields
Field Data type PK FK Not Null Default Collate Check On Conflict
art_id integer            
media_id integer              
media_type text              
type text              
url text              

Indexes
Index Fields Primary Unique
ix_art media_id, media_type, type    

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

Checks
      There are no checks for table "art"

Triggers
      There are no triggers for table "art"

References
      There are no references for table "art"

Definition:
CREATE TABLE art (
  art_id      integer PRIMARY KEY,
  media_id    integer,
  media_type  text,
  type        text,
  url         text
);

CREATE INDEX ix_art
  ON art
  (media_id, media_type, type);


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