Switch to: V12V11V10V9V8V7V6V5

Property Inspector: Table

This page describes properties listed for a Table object.

Category "Object"

  • Class - Specifies the class of the selected object.
  • Name - The name of the selected table.
  • ID - The internal ID of the object.
  • Table Kind - Indicates wether the table is permanent or temporary.
  • Storage Type - Indicates wether the table is stored on disk or in RAM.

Category "Encryption"

  • Data encrypted - Indicates wether the content data is encrypted.

Category "Collation Settings"

Valentina database engine uses IBM ICU - the most powerful unicode library. This library provides very reach set of collator parameters that are listed in this category. You can read more details in Valentina engine docs here and IBM ICU docs here.

  • Locale Name - Displays the name of the used locale (language and country specifications).
  • Storage Encoding - Encoding used to store strings on the disk.
  • Alternate Handling - The Alternate attribute is used to control the handling of the so-called variable characters in the UCA: whitespace, punctuation and symbols. The default for most locales is Non-Ignorable.
  • Case First - is used to control whether uppercase letters come before lowercase letters or vice versa, in the absence of other differences in the strings.
  • Case Level - is used when ignoring accents but not case. In such a situation, set Strength to be Primary, and Case_Level to be On. In most locales, this setting is Off by default.
  • French Collation - The French sort strings with different accents from the back of the string. This attribute is automatically set to On for the French locales and a few others. Users normally would not need to explicitly set this attribute.
  • Quaternary Mode -
  • Normalization Mode -
  • Strength - Specifies the level of string comparison:
    • Primary Level: Typically, this is used to denote differences between base characters (for example, “a” < “b”).
    • Secondary Level: Accents in the characters are considered secondary differences (for example, “as” < “às” < “at”).
    • Tertiary Level: Upper and lower case differences in characters are distinguished at the tertiary level (for example, “ao” < “Ao” < “aò”).
    • Quaternary Level: When punctuation is ignored (for example, “ab” < “a-b” < “aB”).
    • Identical Level: When all other levels are equal, the identical level is used as a tiebreaker. The Unicode code point values of the NFD form of each string are compared at this level, just in case there is no difference at levels 1-4 .

See also: Collation Settings page.

Category "Information"

  • Field Count - The number of fields in the table.
  • Method Count - The number of methods in the table.
  • Link Count - The number of links connecting this table with others or recursively with itself.
  • Trigger Count - The number of triggers created on this table.
  • Index Count - The number of indexes built for this table and its fields.
  • Unique Count - The number of UNIQUE constraints defined on this table.
  • Check Count - The number of CHECK constraints defined on this table.
  • Record Count - The number of records in this table.
  • Physical Record Count - The number of physical records in the table.
  • Check Count - The number of CHECK constraints defined on this table.
  • Property Count - The number of properties defined for this this table.
  • Size - The size of this table on disk/in RAM.