Database definition
Top  Previous  Next


The following list describes the database fields available as of version 2.7 of CodedColor. The list is subject to change in later versions. Some fields like "UserData" are currently not used and reserved for later versions. The database can be exported into XML, so the data can be viewed in the Microsoft Internet Explorer.

Extract of the field definition file Workdirectory\Data\Files.tdf

[FID]  
DataType=ftAutoInc  
Description_EN=Unique record identifier  
Description_DE=Primärschlüssel   
 
[Checked]  
DataType=ftBoolean  
Description_EN=Include in albums and printing  
Description_DE=Bilder ausgewählt (z.B. für Alben, Export, Druck)  
 
[Volume]  
DataType=ftString  
Description_EN=Volume or CD label  
Description_DE=Datenträger Bezeichung  
 
[VolumeID]  
DataType=ftInteger  
Description_EN=Volume or CD serial number  
Description_DE=Datenträger Seriennummer  
 
[DrvType]  
DataType=ftInteger  
Description_EN=Removable: 2; fixed: 3; remote: 4; CD drive: 5  
Description_DE=Wechselspeicher: 2; Festplatte: 3; Netz: 4; CD: 5  
 
[FilePath]  
DataType=ftString  
Description_EN=Path and name of local file  
Description_DE=Dateiname inkl. Pfadangabe  
 
[FileSize]  
DataType=ftFloat  
Description_EN=Filesize in bytes  
Description_DE=Größe der Datei in Byte  
 
[FileDate]  
DataType=ftDateTime  
Description_EN=date when file was last modified  
Description_DE=Letzte Änderungsdatum der Datei  
 
[FileAttr]  
DataType=ftInteger  
Description_EN=File attributes  
Description_DE=Attribute der Datei  
 
[Created]  
DataType=ftDateTime  
Description_EN=Creation time of filesystem  
Description_DE=Erstelldatum der Datei  
 
[FileUrl]  
DataType=ftString  
Description_EN=Adress of remote file  
Description_DE=Verknüpfungsziel der Datei oder Internetadresse  
 
[OrgDate]  
DataType=ftDateTime  
Description_EN=Time of photo or file creation stamp  
Description_DE=Aufnahmedatum des Fotos oder Erstelldatum der Datei  
 
[Title]  
DataType=ftDropdown  
Description_EN=Titel  
Description_DE=Titel des Fotos bzw. der Datei  
 
[Description]  
DataType=ftMemo  
Description_EN=File annotation  
Description_DE=Beschreibung des Fotos bzw. der Datei   
 
[Keywords]  
DataType=ftCheckList  
Description_EN=List of words for searching  
Description_DE=Liste von Schlagwörtern zum katalogisieren des Fotos bzw. der Datei   
 
[UserData]  
DataType=ftMemo  
Description_EN=Additional user fields (IPTC)  
Description_DE=Weitere Felder (IPTC)  
 
[ImageData]  
DataType=ftMemo  
Description_EN=EXIF image information  
Description_DE=EXIF Informationen (z.B. von der Kamera)  

2004 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a powerful and versatile photo organizer and image editing software for digital camera users. Features include photo editing & printing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF display, thumbnail generation, resize & resample images, jp2000, batch conversion, database keyword searching, red eye removal, color / sharpness / brightness & contrast correction, artefacts removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, gamma correction and screenshows with transition effects, panorama stitch, RAW, photo books and layouts, collages, histograms, white balance, PDF export, watermarks, etc. Please visit the CodedColor FotoStudio homepage to learn more or download a free copy!