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