This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11450861 | 0CE448B6-E909-49F0-B97C-1F2408D08970 | 23587 | 2056 | 0 | CB116D1C-DE9A-4924-AE00-1BB8DE61678B-7318-000005F706526CE5_photo.jpg | cb116d1c-de9a-4924-ae00-1bb8de61678b-7318-000005f706526ce5_photo.jpg |
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]);