|
back to main page - contents -
top
previous topic: Table properties next topic: Links |
Fields in the fields table
| Key | Database field | Header | Description |
|---|---|---|---|
| NUMID | NUMID | NUMID | The numerical id. |
| ID | ID | ID | The short name of the field. |
| Owner | OWNER | Owner | The owner of the field properties entry set (admin). |
| Dat | DAT | Last update | The date on which the field definition was last changed. |
| Table | TBL | Table | The table which this field belongs to. |
| Template | TEMPLATE | Template | This template text is only used for the template fieldtype. <*value*> in this text is replaced by the value of the field. |
| Description | DESCRIPTION | Description | The description of the field. |
| Actions | ACTIONS | Actions | Allowed actions and their repective permission requirements for this field. |
| Str | STR | Header | The header text of this field to be displayed in list and edit views. |
| Options | OPTIONS | Options | The options for this field separated by vertical bars |. |
| Type | TYPE | Type | The type of the field. Field types in Xtalbase are an extension of the HTML form field types. In many cases fields can contain multiple values (like in the multiple_select field type) or composite values like the stocks field type. |
| Valid | VALID | Valid | The valid parameter encodes validity checks for this field. Possible values are 'ne' for 'not empty', min=x (not smaller than x), max=x (not larger than x), maxl=x (not longerthan x bytes), num (is a number), regex=x (follows regular expression x), invregex=x (does not follow regular expression x). |
| RegexDesc | REGEXDESC | Regular expression descriptive text | This is a description of the regular expression in valid field. This text is displayed in a javascript alert, when the value does not match the regular expression. |
| Dsp | DSP | Display | This flag determines whether this field is shown in the object list. |
| Search | SEARCH | search enabled | This flag determines whether the field is searchable or not. |
| Order | SEQ | Order | The order by which the objects shall be displayed in the list view or in select form fields. |
| CrossRef | CROSSREF | Cross reference | The cross reference is an instruction for where the options for the field shall be taken from. The cross reference refers to a table and a field which contains the possible values and tells the system whether an empty option shall be included or not. |
| Fld | FLD | Dbase field name | The name of the field in the MySQL database. |
| DbSize | DBSIZE | Dbase field size | The database field size. This value is not needed for certain data types (text, enum etc). |
| DBnull | DBNULL | Dbase field NULL flag | This setting directly corresponds to the NULL value in MySQL and tells whether an undefined field is indicated by a NULL value. The default is no, i.e. the empty string (or 0 for numbers) is interpreted as undefined. |
| DBkey | DBKEY | Dbase field key | This value can be either 'PRI' or 'MUL' or empty depending whether the field is a primary index, a multiple index or no index at all. |
| DBdefault | DBDEFAULT | Dbase field default | This value is the default value for the field. |
| DBextra | DBEXTRA | Dbase field extra | This value is either empty or 'auto_increment', depending on whether the value of the field should be incremented when a new object is created or not. The only field, which is set to 'auto_increment' is NUMID, which is generally also the primary index. |
| Dbcollation | DBCOLLATION | The Collation (font) of the field | |
| Share | SHARE | Shares | The Share field is used to give other users viewing or modifying rights for a certain object. Permissions can be given to specific users, to the group to which the object owner belongs to and to all users. |
Actions in the fields table
| Icon | Description |
|---|---|
 | display (and edit) the field |
 | create a new field |
 | copy the current field |
 | view fields |
 | delete the field |
 | update the field |