| |
Property name | Effect |
---|
AccentSensitive | Take the accented characters into account when performing searches on the item |
CalculatedDefaultValue | Define the SQL expression returning the default value of the item. |
CalculatedItemExpression | Define the SQL expression that returns the value of a calculated item (Expression item). |
CaseSensitive | Take the case (uppercase/lowercase characters) into account when performing searches on the item |
Component | Modify a component of a composite key |
DecimalPart | Define the number of digits in the decimal part of a Numeric item. |
DefaultValue | Default value of an item. |
GDPR | Determine if the item contains GPDR-relevant data. |
IntegerPart | Define the number of digits in the integer part of a Numeric item. |
KeyExpression | Define the components of a composite key. |
KeySize | Size of the section to index in the text memo. |
KeyType | Characteristics of a key item. |
Language | Define the parameters of the language used to perform the comparisons and the sort for a Unicode item. |
LanguageDescribed | Define the parameters of the language used to perform the comparisons and the sort for a Unicode item. |
MaxThumbnailHeight | Define the maximum height of an item thumbnail. |
MaxThumbnailWidth | Define the maximum width of an item thumbnail. |
Name ( * ) | Name of item. |
NbArrayElement | Number of elements in an array item. |
Null | Take the "NULL by default" option into account for the item. |
NullAllowed | Define whether the NULL value is allowed (or not) for the item. |
PersistedCalculatedItem | Define whether the value of a calculated item (Expression type) is stored in the data file. |
PunctuationSensitive | Take the punctuation characters (comma, period, ...) into account when performing searches on the item |
Size(* required depending on the specified type) | Size of a text item (character string, text memo, character) Size of a Time item. |
SortType | Characteristics of the sort on an item. |
spDerivation | Define the key derivation function used for hashing ("Password" item). |
spHash | Define the algorithm used for salting ("Password" item). |
spIterationCount | Define the iteration count of the hash algorithm ("Password" item). |
spLength | Defining the hash output length ("Password" item). |
TimestampType | Define the type of timestamp for the item. |
TimestampUTC | Define whether the time of a timestamp item is UTC or not. |
Type (* ) | Identifies and modifies the type of an item. |
TypeDescription | Specify the type associated with an Enumeration or Combination item. |