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)

 

 

 

 

CodedColor PhotoStudio © 2023 1STEIN GmbH

CodedColor PhotoStudio by 1STEIN is an award-winning Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, stich panoramas, convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), burn digital watermarks, correct colors, batch convert and correct images and generate a web album in HTML5. The software is easier to use than Photoshop, but more versatile than ACDSee, Picasa, Irfanview or Gimp. Many magazines consider it to be the Swiss Knife of Image Editing. Have a look at our Before / After tutorials to get an idea of the powerful capabilities. The software comes with a detailed handbook and a fast database to store EXIF/IPTC data and color information. CodedColor PhotoStudio is the ideal image editing tool for every-day and professional digital camera users. The user friendly interface combines features like expert photo editing & printing, layer editing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, batch conversion, database keyword searching, red eye removal, color/sharpness/brightness & contrast correction, artifact removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel) and layers, gamma correction, screen shows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, HEIC, HEIF, AVIF and all current RAW formats. The installation includes our the CodedColor Publisher, a versatile photo layout and DTP tool to create individual and rich photo books.