This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
340760 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 3513 | 2056 | 0 | IMG_3079.HEIC | img_3079.heic | |
11552602 | 3A19DB48-E962-4B82-9E26-57BDA6F34B8C | 3513 | 2056 | 0 | IMG_3079.HEIC | img_3079.heic |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [labels] ( [id] INTEGER PRIMARY KEY, [uuid] TEXT, [groupid] INTEGER, [category] INTEGER, [owning_groupid] INTEGER, [content_string] TEXT, [normalized_string] TEXT, [lookup_identifier] TEXT ); CREATE INDEX [idx_labels_uuid] ON [labels] ([uuid]); CREATE INDEX [idx_labels_normalized_string] ON [labels] ([normalized_string]);