| Contains details of external products imported into archive |
| This table contains details of product sets that are imported into the VSA from an external group, to be used by the VSA. Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| programmeID | int | 4 | the unique programme ID | meta.id | ||
| productType | varchar | 16 | The product type within the imported directory | ?? | ||
| description | varchar | 256 | Description of the product set | ?? | ||
| institution | varchar | 256 | Name of the institution that created the product | ?? | ||
| creator | varchar | 32 | Name of the individual that created the product | ?? | ||
| releaseNum | smallint | 2 | Release number of deep stack frame (or intermediate stack if used as a deep stack). | -9999 | ||
| directory | varchar | 32 | Name of directory which these data reside in | |||
| fileNameRoot | varchar | 32 | File name root of the products | |||
| zeroPoint | real | 4 | Zeropoint of each product | -0.9999995e9 | ||
| zpSystem | varchar | 16 | System of zeropoint (Vega/AB) | 'NONE' | ||
| sqlSchemaFile | varchar | 32 | Relative path of the schema file containing the table description that the data will be ingested into if necessary | 'NONE' | ||
| tableName | varchar | 32 | Name of the table that the data will be ingested into if necessary | 'NONE' | ||
| sourceMatched | tinyint | 1 | Does the main ID of the table have an exact 1 - 1 match with the source table | 0 | ||
| reference | varchar | 64 | Reference paper describing the data | NONE | ||
| Total length | 779 |