| The AamLedger holds details of all the astrophysical analysis methods. |
| The AamLedger holds details of all the astrophysical analysis methods (AAMs) used to derive astrophysical parameters for stars observed in the GES survey. The basis of an astrophysical analysis method is a software item identified by the softwareId column. Note that different versions of a given software item have their own software identifiers. Thus AAM identifiers implictly mimic the same versioning scheme. TODO Determine if any additional columns are required. Required constraints:
|
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| aamID | bigint | 8 | Unique astrophysical analysis method (AAM) identifier | -99999999 | ||
| softwareID | bigint | 8 | Software (version) identifier | -99999999 | ||
| aamName | varchar | 20 | Name of the AAM | |||
| aamVersion | varchar | 10 | Version of the AAM | |||
| description | varchar | 80 | Brief description of the AAM | |||
| institution | varchar | 20 | Institution responsible for supporting the AAM | |||
| workGroup | varchar | 20 | GES working group responsible for the AAM | |||
| reference | varchar | 40 | Bibliographic reference to a publication decribing the AAM | 'NONE' | ||
| url | varchar | 80 | URL for a Web page describing the AAM | 'NONE' | ||
| aamTable | varchar | 40 | Name of the table holding results of the AAM | |||
| aamDdlFile | varchar | 40 | Name of the DDL file for the AAM file | |||
| aaltExist | tinyint | 1 | Flag: does an AALT (astrophysical analysis line table) exist for this AAM (0 = no, 1 = yes) | 1 | ||
| aaltTable | varchar | 40 | Name of the AALT (astrophysical analysis line table) | 'NONE' | ||
| aaltDdlFile | varchar | 40 | Name of the DDL file for the AALT | |||
| aamfExist | tinyint | 1 | Flag: does an AAMF (astrophysical analysis molecular feature table) exist for this AAM (0 = no, 1 = yes) | 0 | ||
| aamfTable | varchar | 40 | Name of the AAMF (astrophysical analysis molecular feature table) | 'NONE' | ||
| aamfDdlFile | varchar | 40 | Name of the DDL file for the AAMF | |||
| deprecated | tinyint | 1 | Deprecated flag: coded as current=0 or deprecated !=0 | 0 | meta.code | |
| cuEventID | int | 4 | UID of curation event giving rise to this record | meta.bib | ||
| Total length | 533 |