Database configuration
The database schema is held in a series of files in the tables directory. There is one per file (table/collection). For example, the Content Management Software for this web site uses the webages file.
The file contains the the following information:
- Friendly name, Used in the database report
- Description, Used in the database report.
- Permission: Permission sets for different operations (view, edit, delete, all, none)
- List: configures a normal table list. The columns array lists the fields to be included.
- In a structured record, only the top level fields are included. The subsidiary fields will be listed in a column - example here.. Results details are all in the results column..
- Stringify: When any record is described. this column will be used to characterise it. This can be a function to combine columns. Defaults to the primary key.
- Groups: Divides the fields into groups for presentation and editing. Any fields not included get included in an 'other' group.
- Columns: The fields in the group
- Static: (true/false) This group is 'above the fold' and does not change as you switch groups.
- Record types: Optionally indicates that this group is only relevent to the stated record types..
- Subschema
- Key: The name of the field that determines which subschema record is used.
- Standard Header: Every record will have a standard set of fields.
- Attributes: This is a list of objects to describe the columns in the table.