Digikam database relations

[Maik Qualmann]

17 tables are described in DBSCHEMA.ODS. The ODS file has multiple Sheets, 
Albums, Images, Tags, Internal, Metadata mapping, Thumbnail, Face and Others.

Maik

Am Sonntag, 16. Juli 2023, 21:55:39 CEST schrieben Sie:
> Thanks
> but my DBSCHEMA.ODS only contains 5 tables. I would also be nice to know
> the purpose of the different tables.
> This is what my DBSCHEMA.ODS in its entirety looks like:
> 
> 
> *Table « Searches »*
> /
> /
> *NAME* 	*TYPE* 	*DESCRIPTION* 	*READ FROM* 	*WRITTEN TO* 	
*CHANGED BY*
> id 	INTEGER (PRIMARY KEY) 	auto incremented id
> 
> 
> type 	INTEGER 	type of search query
> 
> 
> name 	LONGTEXT 	name of search
> 
> 
> query 	LONGTEXT 	search query to use
> 
> 
> 
> 
> 
> 
> 
> 
> NOTE : There’re 7 types of searches. For more information, look in
> coredbconstants.h file in
> digikam-software-compilation/core/libs/database/coredb folder.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *Table « Settings »*
> /
> /
> *NAME* 	*TYPE* 	*DESCRIPTION* 	*READ FROM* 	*WRITTEN TO* 	
*CHANGED BY*
> keyword 	LONGTEXT 	includes database version rule
> 
> 
> value 	LONGTEXT 	value of the associated setting
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *Table « UniqueHashes »*
> /
> /
> *NAME* 	*TYPE* 	*DESCRIPTION* 	*READ FROM* 	*WRITTEN TO* 	
*CHANGED BY*
> uniqueHash 	VARCHAR 	hash value
> 
> 
> fileSize 	INTEGER 	size of the file (in bytes)
> 
> 
> thumbId 	INTEGER (FOREIGN KEY) 	id of the thumbnail
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *Table « FilePaths »*
> /
> /
> *NAME* 	*TYPE* 	*DESCRIPTION* 	*READ FROM* 	*WRITTEN TO* 	
*CHANGED BY*
> path 	VARCHAR 	complete path of the thumbnail
> 
> 
> thumbId 	INTEGER (FOREIGN KEY) 	associated thumbnail id
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *Table « VideoMetadata»*
> /
> /
> *NAME* 	*TYPE* 	*DESCRIPTION* 	*READ FROM* 	*WRITTEN TO* 	
*CHANGED BY*
> imageid 	INTEGER (FOREIGN KEY)
> 
> 
> 
> aspectRatio 	TEXT
> 
> 
> 
> audioBitRate 	TEXT
> 
> 
> 
> audioChannelType 	TEXT
> 
> 
> 
> audioCompressor 	TEXT
> 
> 
> 
> duration 	TEXT
> 
> 
> 
> frameRate 	TEXT
> 
> 
> 
> exposureProgram 	INTEGER
> 
> 
> 
> videoCodec 	TEXT
> 
> 
> 
> 
> 
> and here is the output from my mariadb:
> 
> MariaDB [(none)]> show tables from digikam;
> +--------------------+
> 
> | Tables_in_digikam  |
> 
> +--------------------+
> 
> | AlbumRoots         |
> | Albums             |
> | CustomIdentifiers  |
> | DownloadHistory    |
> | FaceMatrices       |
> | FaceSettings       |
> | FilePaths          |
> | Identities         |
> | IdentityAttributes |
> | ImageComments      |
> | ImageCopyright     |
> | ImageHaarMatrix    |
> | ImageHistory       |
> | ImageInformation   |
> | ImageMetadata      |
> | ImagePositions     |
> | ImageProperties    |
> | ImageRelations     |
> | ImageSimilarity    |
> | ImageTagProperties |
> | ImageTags          |
> | Images             |
> | KDTree             |
> | Searches           |
> | Settings           |
> | SimilaritySettings |
> | TagProperties      |
> | Tags               |
> | TagsTree           |
> | ThumbSettings      |
> | Thumbnails         |
> | UniqueHashes       |
> | VideoMetadata      |
> 
> +--------------------+
> 33 rows in set (0,001 sec)
> 
> Den 2023-07-16 kl. 21:37, skrev Maik Qualmann:
> > The core database currently has 20 tables, 17 of which are described in
> > the
> > DBSCHEMA.ODS, so only 3 are missing, possibly 1-2 columns that have been
> > added recently are still missing. There are several tables under Albums
> > and Images.
> > 
> > Maik
> > 
> > Am Sonntag, 16. Juli 2023, 18:41:02 CEST schrieb Håkan Elmqvist:
> >> Den 2023-07-14 kl. 16:52, skrev Håkan Elmqvist:
> >>> I am using digiKam with mysql and I would like to dig into the
> >>> database with my MySQL tools. To that end I need to understand the
> >>> relationship between and use of the different tables.
> >>> 
> >>> In DBSCHEMA.ODS only 5 tables are listed. In my digiKam database I
> >>> find 20+ tables.
> >>> 
> >>> Can someone please point me to more information on the digiKam
> >>> database and its tables.
> >>> 
> >>> Thanks in advance
> >>> 
> >>> Håkan