Table "files"

System:

Fields

Field	Data type	PK	FK	Not Null	Default	Collate	Check	On Conflict
idFile	integer
strFilename	text

Indexes

Index	Fields	Primary	Unique
UniqueFilename	strFilename

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

Checks
      There are no checks for table "files"

Triggers
      There are no triggers for table "files"

References
      There are no references for table "files"

Definition:

CREATE TABLE files (
  idFile       integer PRIMARY KEY AUTOINCREMENT,
  strFilename  text NOT NULL
);

CREATE UNIQUE INDEX UniqueFilename
  ON files
  (strFilename);

Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20