| The role table holds all possible roles which data items may adopt in the data processing. |
| There is a single role table for all data items, notably including 1D spectra and 2D frames. Obviously the valid roles for a spectrum are different from the valid roles for a 2D frame. Obsolete roles should be flagged as deprecated. Note that the table is called 'roleGes' rather than 'role' to avoid a clash with a SQL reserved word. Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| roleID | bigint | 8 | Role identifier: unique identifier for each role | -99999999 | ||
| roleName | varchar | 10 | Name of the role | 'NONE' | ||
| description | varchar | 80 | Brief description of the role | 'NONE' | ||
| deprecated | tinyint | 1 | Deprecated flag: coded as current=0 or deprecated !=0 | 0 | meta.code | |
| Total length | 99 |