Date: Fri, 29 Mar 2024 07:22:54 +0000 (UTC) Message-ID: <77241041.10955.1711696974935@911f0a1bad02> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10954_143743137.1711696974935" ------=_Part_10954_143743137.1711696974935 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Column definitions include several metadata properties, which st= ore information that is used both in development and at runtime.
The Title property of a column is simply the human-readable nam= e for a column. When a field is placed on a form with the Place with la= bels option, the label's text property will be initialized to= the title property for the column to reach the field is bound. Fo= r multilingual applications, it is ideal to populate a column's title= em> property with an i18n message key, thus allowing field labels = to default to message key, which is translated at runtime.
The Default Format property of a column will enforce the format= ting that is used when the column is bound to a field element. The field el= ement's format property will assume the default format of the colu= mn unless it is overridden in the element.
This is a simple metadata property to indicate that a column is a foreig= n key to another table in the same database. One can set the Foreign Type p= roperty to the target table. This provides metadata so developers will know= that a column is used as a foreign key. Servoy will use this information w= hen new relations are created between the tables and auto-fill the keys. Th= is property is also used by the mergeRecords method of th= e databaseManager API to up= date any affected related records, such that they'll reference a new key.= p>
Enabling a column's Excluded Flag will completel= y exclude a column from the Servoy runtime environment. This means that Ser= voy will exclude this column for every query that it issues. This option is= ideal to enforce that certain columns are never available in a Servoy appl= ication.
Servoy supports the use of Univ= ersally Unique Identifiers (UUID). A UUID is a 16-byte number whic= h can be (practically) guaranteed to be unique across computing environment= s, making it ideal to use for sequences in scenarios where traditional nume= ric sequences are not adequate, for example when syncing data which is gene= rated offline. It is generally not feasible to store UUIDs as numeric data = types because the number is so large. Rather UUIDs are most easily stored a= s 36-character strings. When using a text column to store UUIDs, one should= mark the column's UUID flag. Thus, Servoy will provide programmatic access= to this column in the form of a built-in U= UID data type, which allows both string and byte representation.
A column's description property is a simple container for addit= ional metadata, such as programmer notes about the column's purpose, etc.= p>