|
back to main page - contents -
top
previous topic: Help texts next topic: Fields registry table |
Fields in the tables table
| Key | Database field | Header | Description |
|---|---|---|---|
| NUMID | NUMID | NUMID | The numerical id. |
| ID | ID | ID | The name of the table. |
| Owner | OWNER | Owner | The owner of the table properties entry set (admin). |
| Dat | DAT | Last update | The date on which the table definition was last changed. |
| Str | STR | View header | The name of the objects (displayed in list views). |
| DspStr | DSPSTR | Display header | The name of the objects of this table in edit windows. |
| Module | MODULE | Module | The module which this table belongs to. |
| Actions | ACTIONS | Actions | Allowed actions and their repective permission requirements for this table. |
| SpecAcc | SPECACC | Special access permission required | If set to yes access to this table requires the user to have an academic affiliation. |
| DefViewOwner | DEFVIEWOWNER | Default owner in view windows | This switch controls which objects are shown by default in list views. If the parameters submitted along the link do not include an owner or other limiting parameters then either all accessible objects (no default), only objects, which the current user owns, all objects, which are owned by the current user plus all shared objects or all admin-owned objects are are shown. |
| ReverseSort | REVERSESORT | Reverse sort | This flag is set to 1, if the objects shall be reverse sorted. The sort order can be changed by clicking on the column header. |
| RequiredParameters | REQPARS | Required parameters | The required parameters for this table. These parameters must be available when a new object in the table is created. |
| AllowedParameters | ALLOWEDPARS | Additional allowed parameters | This is a list of parameters, which are allowed for this table. This list is used, when html links are constructed. |
| DisAllowedParameters | DISALLOWEDPARAMETERS | Disallowed parameters | This list contains parameters, which are not allowed for this table. For instance the owner is not an allowed parameter for the molecular weights table (all entries in this table are owned by the admin user). |
| SortFld | SORTFLD | Sort field | The ID of the field by which a list is sorted by default. |
| EditWd | EDITWD | Where are objects displayed ? | Set to 1, if objects are edited in the edit window, if set to 0 objects can only be edited in the list view. |
| UniqueFields | UNIQUEFIELDS | Unique fields | A list of fields that uniquely define the object. |
| SortGroup | SORTGROUP | Sort group | If objects in this table are sorted by a number (order field), then the order field is only updated if objects have the same value for the fields listed in the sort group field. |
| NewOwner | NEWOWNER | New owner | The default owner of new objects within the table. |
| IDType | IDTYPE | ID type of new object | This fields controls how the ID of new objects is set. The setting 'name' means that the ID is constructed using the table name. If the ID already exists, a name new name {oldname}_{num} is constructed (with num being incrementally increased). |
| Install | INSTALL | Export option for program installation | This parameter controls whether and how this table is exported in a new distribution. |
| ParentTable | PARENTTABLE | Parent table | This entry contains a reference to another table which this table depends on. If the owner or the share permissions of the parent table are changed or if the parent table is deleted the child table does also change owner or share permissions or it is also deleted. |
| Description | DESCRIPTION | Description | A description of the table. |
| HeadText | HEADTEXT | Header text | A header text to be displayed on the top of the object list. |
| Dbcollation | DBCOLLATION | The Collation (font) of the table | |
| 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 tables table
| Icon | Description |
|---|---|
 | display (and edit) the table |
 | create a new table |
 | copy the current table |
 | view tables |
 | delete the table |
 | update the table |