///
The `sd-webui-infinite-image-browsing` application uses an SQLite database (`iib.db` by default) to store metadata, tags, and cached information for efficient image browsing and search. Below is a det
19 views
~19 views from guests
Guest views are estimated from total page views. These include anonymous visitors and users who weren't logged in when they viewed the page.
The sd-webui-infinite-image-browsing application uses an SQLite database (iib.db by default) to store metadata, tags, and cached information for efficient image browsing and search. Below is a detailed description of its schema.
imageid: INTEGER, PRIMARY KEY AUTOINCREMENTpath: TEXT, UNIQUE - Absolute path to the media file.exif: TEXT - Raw generation information (EXIF/metadata) extracted from the file.size: INTEGER - File size in bytes.date: TEXT - Last modified date of the file (formatted as YYYY-MM-DD HH:MM:SS).image_idx_path on image(path)tagid: INTEGER, PRIMARY KEY AUTOINCREMENTname: TEXT - The tag's name (e.g., "masterpiece", "sdxl", "like").score: INTEGER - (Currently unused in code, default 0).type: TEXT - Category of the tag (e.g., "custom", "pos", "lora", "Model", "Sampler", "size", "Media Type").count: INTEGER - Frequency of the tag's use.color: TEXT, DEFAULT '' - Custom color for the tag (added via ALTER TABLE).name, type) ON CONFLICT REPLACEtag_idx_name on tag(name)("like", 0, "custom", 0) tag if not exists.image_tagimage records to tag records.image_id: INTEGER - Foreign key referencing image.id.tag_id: INTEGER - Foreign key referencing tag.id.created_at: TIMESTAMP - Timestamp when the tag was associated with the image.image_id, tag_id)image_id) REFERENCES image(id)tag_id) REFERENCES tag(id)foldersid: INTEGER, PRIMARY KEY AUTOINCREMENTpath: TEXT - Absolute path to the folder.modified_date: TEXT - Last modified date of the folder (formatted as YYYY-MM-DD HH:MM:SS).folders_idx_path on folders(path)extra_pathpath: TEXT, PRIMARY KEY - Absolute path.type: TEXT, NOT NULL - Comma-separated string of types (e.g., "scanned+walk").alias: TEXT, DEFAULT '' - User-defined alias for the path.dir_cover_cachefolder_path: TEXT, PRIMARY KEYmodified_time: TEXT - Last modified time of the folder when cache was generated (ISO format).media_files: TEXT - JSON string containing a list of top media file info.global_settingname: TEXT, PRIMARY KEY - Setting name (key).setting_json: TEXT - JSON string representing the setting's value.created_time: TEXT - Creation timestamp (ISO format).modified_time: TEXT - Last modification timestamp (ISO format).image_embeddingimage_id: INTEGER, PRIMARY KEY - Foreign key referencing image.id.model: TEXT, NOT NULL - The embedding model used (e.g., "text-embedding-3-small").dim: INTEGER, NOT NULL - Dimensionality of the embedding vector.text_hash: TEXT, NOT NULL - SHA256 hash of the normalized prompt text, used for incremental updates.vec: BLOB, NOT NULL - The embedding vector stored as a float32 byte array.updated_at: TEXT, NOT NULL - Last update timestamp (ISO format).image_id) REFERENCES image(id)image_embedding_idx_model_hash on image_embedding(model, text_hash)image_embedding_failimage_id: INTEGER, NOT NULL - Foreign key referencing image.id.model: TEXT, NOT NULL - The embedding model attempted.text_hash: TEXT, NOT NULL - SHA256 hash of the prompt text.error: TEXT, NOT NULL - Error message from the failed attempt.updated_at: TEXT, NOT NULL - Last update timestamp (ISO format).image_id, model, text_hash)image_embedding_fail_idx_model on image_embedding_fail(model)topic_title_cachecluster_hash: TEXT, PRIMARY KEY - A hash identifying the specific cluster and parameters.title: TEXT, NOT NULL - The LLM-generated cluster title.keywords: TEXT, NOT NULL - JSON string of LLM-generated keywords.model: TEXT, NOT NULL - The LLM model used for title generation.updated_at: TEXT, NOT NULL - Last update timestamp (ISO format).topic_title_cache_idx_model on topic_title_cache(model)topic_cluster_cachecache_key: TEXT, PRIMARY KEY - A hash identifying the specific clustering parameters and input folders.folders: TEXT, NOT NULL - JSON string of the input folders used for clustering.model: TEXT, NOT NULL - The embedding model used for clustering.params: TEXT, NOT NULL - JSON string of clustering parameters (e.g., threshold, min_cluster_size).embeddings_count: INTEGER, NOT NULL - Number of embeddings processed for this cache.embeddings_max_updated_at: TEXT, NOT NULL - Max updated_at from image_embedding records, used to detect staleness.result: TEXT, NOT NULL - JSON string of the full clustering result (clusters, noise, etc.).updated_at: TEXT, NOT NULL - Last update timestamp (ISO format).topic_cluster_cache_idx_model on topic_cluster_cache(model)