Media Gallery

Tables (10)

Copy Of Item (Item)

  • Key (hash) — TEXT — Primary key — NOT NULL
  • Field (title) — TEXT — NOT NULL
  • Field2 (description) — TEXT — NOT NULL
  • Field3 (memo) — TEXT — NOT NULL
  • Field (primeTimeUses) — TEXT ("ADD" | "TAG") — NOT NULL
  • Field2 (primeTimeString) — TEXT — NOT NULL
  • Field3 (addedTimeString) — TEXT — NOT NULL
  • Field (taggedTimeString) — TEXT
  • Field (taggedTimeOffset) — TEXT
  • Field2 (type) — TEXT ("IMAGE" | "VIDEO") — NOT NULL
  • Key (size) — INTEGER — NOT NULL
  • Field3 (width) — INTEGER — NOT NULL
  • Field4 (height) — INTEGER — NOT NULL
  • Field (pixelsCount) — INTEGER — NOT NULL
  • Field2 (rotation) — INTEGER (0 | 90 | 180 | 270) — NOT NULL
  • Field3 (flip) — BOOLEAN — NOT NULL
  • Field (duration) — INTEGER — NOT NULL

Item (ItemOld)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (title) — TEXT — NOT NULL
  • Field2 (description) — TEXT — NOT NULL
  • Field3 (memo) — TEXT — NOT NULL
  • Field (primeTimeUses) — TEXT — NOT NULL — "ADD" | "TAG"
  • Field2 (primeTimeString) — TEXT — NOT NULL
  • Field3 (addedTimeString) — TEXT — NOT NULL
  • Field4 (fileStatus) — TEXT — NOT NULL — "OK" | "LOST" | "DIFF
  • Field5 (filePosixDirectory) — TEXT — NOT NULL
  • Field6 (fileName) — TEXT — NOT NULL
  • Field7 (fileSize) — TEXT — NOT NULL
  • Field8 (fileMtime) — DATE — NOT NULL
  • Field9 (fileCtime) — DATE — NOT NULL
  • Field (fileContentHash) — TEXT — NOT NULL
  • Field2 (fileContentType) — TEXT — NOT NULL — "IMAGE" | "VIDEO"
  • Field3 (fileContentWidth) — INTEGER — NOT NULL
  • Field4 (fileContentHeight) — INTEGER — NOT NULL
  • Field5 (fileContentShortSize) — INTEGER — NOT NULL
  • Field (fileContentPixelsCount) — INTEGER — NOT NULL
  • Field2 (fileContentRotated) — INTEGER — NOT NULL — 0 | 90 | 180 | 270
  • Field3 (fileContentFlipped) — BOOLEAN — NOT NULL
  • Field (fileContentDuration) — INTEGER — NOT NULL
  • Field (fileContentTaggedTimeString) — TEXT
  • Field (fileContentTaggedTimeOffset) — TEXT

Tag

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Key (typeId) — INTEGER — Foreign key → TagGroup.Key
  • Field (title) — TEXT — NOT NULL
  • Field (description) — TEXT — NOT NULL
  • Field (memo) — TEXT — NOT NULL
  • Field2 (color) — TEXT
  • Field3 (icon) — TEXT

TagGroup (TagType)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (title) — TEXT — NOT NULL
  • Field2 (description) — TEXT — NOT NULL
  • Field3 (memo) — TEXT — NOT NULL
  • Field4 (color) — TEXT
  • Field5 (icon) — TEXT

Untitled (Collection)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (title) — TEXT — NOT NULL
  • Field2 (description) — TEXT — NOT NULL
  • Field (memo) — TEXT — NOT NULL

Untitled (ItemAndCollection)

  • Key (itemHash) — TEXT — Foreign key → Copy Of Item.Key — NOT NULL
  • Key (collectionId) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (ItemAndTag)

  • Key (itemHash) — TEXT — Foreign key → Copy Of Item.Key — NOT NULL
  • Key (tagId) — INTEGER — Foreign key → Tag.Key — NOT NULL
  • Field (numberValue) — NUMBER
  • Field (stringValue) — TEXT

Untitled (Setting)

  • Key (name) — TEXT — Primary key — NOT NULL
  • Field2 (value) — TEXT — NOT NULL

Untitled (File)

  • Field (posixDirectory) — TEXT — Primary key — NOT NULL
  • Field (name) — TEXT — Primary key — NOT NULL
  • Key (hash) — TEXT — Foreign key → Copy Of Item.Key — NOT NULL — ON DEL NO ACTION ON UPD NO ACTION
  • Field (size) — INTEGER — NOT NULL
  • Field (mtime) — DATE — NOT NULL
  • Field (ctime) — DATE — NOT NULL

User

  • id (name) — TEXT — Primary key — NOT NULL
  • password — TEXT — NOT NULL