Field types

From DAYDA Wiki
Jump to: navigation, search

The currently available field types are:

Module ID DBType Selected values Composite values Multiple values Single line Numeric Description
core amount double 0 0 0 1 1 Amount in mg/ml
core bigint bigint 0 0 0 1 1 Large integer (0 to 18446744073709551615)
core boolean tinyint 1 0 0 1 1 A boolean value (1 or 0)
core checkbox varchar 1 0 1 1 0 the checkbox type directly corresponds to the checkbox button in html forms. This type requires options (either explicit or by crossreference).
core color varchar 0 0 0 1 0 Color in hexadecimal digits (e.g. #f4da3c)
wetlab component varchar 1 1 0 1 0 the component type includes the component name, the concentration, the concentration unit and the pH. In the database these values are separated by colons ':'.
wetlab componentvol varchar 1 1 0 1 1 the componentvol type includes the component name, the volume of the stock in ul and the pH. This type is not actually used in the database, but exists rather to simplify editing of component volumes. componentvol data are transformed to concentration based data.
core counter tinyint 0 0 0 1 1 Tiny integer (0 to 127).
core date varchar 0 0 0 1 0 The date type comprises the year, the month and the day of the month.
core double double 0 0 0 1 1 double precision floating number
core dropdownchecklist varchar 1 0 1 1 0 The drop down checkbox list is equivalent to the checkbox field type, but options are presented as dropdown list instead of floating text.
core email varchar 0 0 0 1 0 An e-mail address. If the value is not displayed in edit mode, a 'mailto:' link is displayed.
core files varchar 0 0 1 1 0 the files type contains names of files, which were uploaded into the file storage area.
core float float 0 0 0 1 1 single precision floating number
core fromfld text A field which takes its characteristics from the values of the dataset (used for preferences).
core html varchar 0 0 0 1 0 A link (including http://). If the value is not displayed in edit mode, a link to this address is displayed.
core images varchar 0 0 1 1 0 Contains names of image files, which were uploaded into the file storage area.
core int int 0 0 0 1 1 Integer (0 to 4294967295).
core jqdate varchar 0 0 0 1 0 As 'date', but selected via date picker
core json varchar 0 0 0 1 0 json encoded hash
core list varchar 0 0 1 1 0 List of freely chosen values.
core lookup text Lookup field parameters in a specified entry of the fields table (used in defaults).
wetlab multiple_components varchar 1 1 1 1 0 The multiple_components type describes fields, which contain informatinon abouyt the composition of a solution. The value consists of subvalues of the 'component' type joined by vertical bars.
wetlab multiple_componentsvol varchar 1 1 1 1 0 Contains information about the composition of a solution. The value consists of subvalues of the 'componentvol' type joined by vertical bars.
core multiple_dates varchar 0 0 1 1 0 Several dates of type 'year/month/day'
core multiple_jqdates varchar 0 0 1 1 0 Several dates of type 'year/month/day'
core multiple_select varchar 1 0 1 1 0 Lets the user choose one or more values from a list of options.
core options varchar 0 1 1 1 0 Pairs of internal option/displayed text pairs.
core password varchar 0 0 0 1 0 Password. The password is never displayed.
core radio varchar 1 0 0 1 0 Radio button as in HTML forms. This type requires options.
core select varchar 1 0 0 1 0 Select button as in HTML forms. This type requires options.
core template varchar 0 0 0 1 0 The template string is displayed after all occurences of <*value*> are replaced by the current field value.
core text varchar 0 0 0 1 0 Text (up to 255 characters)
core textarea text 0 0 0 0 0 Textarea input field as in HTML forms. A click on the value switches to the edit mode. If you want to make clickable links in the text work use the textspec type instead.
core textspec text 0 0 0 0 0 Textarea input field as in HTML forms. In this type links are clickable.
core tinyint tinyint 0 0 0 1 1 Very small integer (0 to 255)
core volume float 0 0 0 1 1 Volume in ml
Selected values 
Values are selected from fixed options or from data of another table
Composite values 
Values consist of an array of strings separated by a colon
Multiple values 
Values consist of an array of strings or composite values separated by vertical bar
Single line 
Values do not contain a newline character
Numeric 
Values contain only 0-9, '.' and '-'