OiDbColumns < Jmmc/Software

-- Main.XavierHaubois - 02 May 2014

---+ Data model table for main datasets: 
---++ M = mandatory, O = optionnal, D = deduced from the oifits keywords or from the other metadata

| *field* | *datatype* | *L0* | *L1* | *L2* | *L3* | *inOifits* | *sample ([[http://cdsarc.u-strasbg.fr/vizier/ftp/cats/J/A+A/544/A91/fits/HA2009.11.05.12.51.fits][Oifits file]])* | *description* | *remarques* |
|dataproduct_type| text | D |D |D |D| | spectrum? visibility? |High level scientific classification of the data product, taken from an enumeration| Predefined enumeration: image, cube, spectrum, sed, timeseries, visibility, event |
|dataproduct_subtype| text | D |D |D |D| |opticalInterferometryData|Data product specific type| |  
|calib_level| integer | 0 | 1 | 2 | 3 | |3|Amount of data processing that has been     applied to the data| |  
|target_name| text | M | M | MD | MD | X |HD31964|Object a targeted observation | |  
|obs_id| text | M | M | M |M | | | eg: 089.C-0605 a unique identifier for an run/program | We should allow several obs_id.|
|obs_collection|text| N/A | N/A | N/A | O | |J/A+A/544/A91|Name of a data collection (e.g., project name) this data belongs to| |  
|obs_creator_name| text | MD (Instrument PI) | M (dataPI) | M (dataPI)  | M (dataPI/1st author of the paper) | | Mourard, D.| | |  
|obs_release_date|TBD| M | MD |MD |MD| | | Observation Date| |
|obs_publisher_did|TBD|MD  | MD | MD | MD | | 007  |Instrument PI ID|TBD, deduced from the name |  
|bib_reference| text |N/A | N/A |N/A | M | |2012A&A...544A..91M|Bibcode| |  
|data_rights| text | M | M | M | public | | public |TBD| private, proprietary, public. L0 metadata are public but data access may be restricted |
|access_url| text | N/A | M/D | M/D |M/D | |HA2009.11.05.12.51.fits|The URL at which to obtain the data set.| L0: page url of  these L0 metadata|  
|access_format| text | N/A | D | D | D | | application/fits |MIME type of the resource at access_url| |  
|access_estsize| integer | N/A | D | D | D | | 34560 |Estimated size of data product| |  
|s_ra | real | MD | MD | MD | MD | X | 0 | Right ascension of (center of) observation, ICRS | |  
|s_dec | real | MD | MD | MD | MD | X | 0 | Declination of (center of) observation, ICRS | |  
|s_fov| real |O| OD | OD | OD |X||Approximate spatial extent for the region covered by the observation| |  
|s_region|spoly| O | OD | OD | OD |X ||Region covered by the observation, as a polygon| |  
|s_resolution| real | O | OD | OD | OD |X| |Best spatial resolution within the data set| |  
|t_min| real | O | MD | MD | MD | X |2455141|Lower bound of times represented in the data set, as MJD| |  
|t_max| real | O | MD | MD | MD | X |2455141|Upper bound of times represented in the data set, as MJD| |  
|t_exptime|real| O | MD | OD | OD | X |0.05|Total exposure time (seconds)| |  
|t_resolution|real| O | OD | OD | OD | X |0.5|Minimal significant time interval along the time axis| |  
|em_min| real | MD | MD | MD | MD | X |6.54085e-07|Minimal wavelength represented within the data set| |  
|em_max| real | MD | MD | MD | MD |X |6.585352e-07|Maximal wavelength represented within the data set| |  
|em_res_power| real | D | D | D | D | |400|Spectral resolving power delta lambda/lamda | page [[http://apps.jmmc.fr/~swmgr/AsproOIConfigurations/ASPRO2-CONF_2014_0403/][ASPRO2]] |  
|o_ucd|text| | | | | ||UCD for the product's observable| |
|pol_states| text |O | O | O | O | |Horiz. |List of polarization states in the data set| |
|facility_name| text |MD | D | D | D | | !MtW.CHARA |Name of the facility at which data was taken| To be confirmed with the submission report, [[http://vo.ads.harvard.edu/dv/facilities.txt]]|
|instrument_name| text | M |MD | MD | MD | X |VEGA|Name of the instrument (detector) that produced the data | mainly deduced from OIWAVELENGTH.INSNAME. This column can be linked to the associated instrument page |  
|nb_channels| integer | D | D | D | D | X |90|TBD| |  
|nb_vis| integer | N/A |D | D | D | X |90|TBD| |  
|nb_vis2| integer |N/A | D | D | D | X |0|TBD|  | 
|nb_t3| integer | N/A | D | D | D |X |0|TBD| | 
|subdate|text|D | D |D|D| |2014-02-18 23:38:41.0|submission date| generated automatically by !OiDB portal| 
|quality_flag| integer | O | M | M | M |  | 2  | Information about t_0, r_0 for L0. For L1,L2,L3: manually filled | Integer from 1 (low) to 5 (high). TBC by Vega team |
|Telescope configuration| text | M | D  | D | D  |X | UT1-UT2 | | |
|Instrument mode| text | M  | M  | M  | M | |LR |Dispersion mode, filters | add camera mode ? |
|keywords | text | O | O | O | OD | | stars: individual: epsilon Aurigae, binaries: eclipsing, stars: massive, stars: AGB and post-AGB, circumstellar matter | Astrophysical keywords | ADS / OLBIN keywords |
|comments | text | O | O | O | O | | | List of user comments | Added through web interface. Provided by TAP? |

---+ TODO define dataModel to store instrument informations:
   * with instrument name, instrument_id, instrument_piId , instrument_piId, instrument_mainUrl... facility link?
This topic: Jmmc/Software > WebHome > OiDb > OiDbReunion28-30Avr2014 > OiDbColumns
Topic revision: r3 - 2014-05-05 - PatrickBernaud