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* | *description* | *Remarques* |
|dataproduct_type|text| D |D |D |D| |opticalInterferometryData|High level scientific classification of the data product,     taken from an enumeration| |  
|calib_level|smallint| 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|TBD| 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|TBD|N/A | N/A |N/A | M | |2012A&A...544A..91M|Bibcode| |  
|data_rights|TBD|N/A | MD  | MD | N/A| | public |TBD| |  
|access_url|text| D | 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| D | D | D | D |  ||MIME type of the resource at access_url| |  
|access_estsize|bigint| D | D | D | D | ||Estimated size of data product| |  
|s_rapos.eq.ra|TBD| MD | MD | MD | MD | X |0|TBD| |  
|s_decpos.eq.dec|TBD| MD | MD | MD | MD | X |0|TBD| |  
|s_fov|double precision|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|double precision| O | OD | OD | OD |X| |Best spatial resolution within the data set| |  
|t_min|double precision| O | MD | MD | MD | X |2455141|Lower bound of times represented in the data set, as MJD| |  
|t_max|double precision| 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|double precision| MD | MD | MD | MD | X |6.54085e-07|Minimal wavelength represented within the data set| |  
|em_max|double precision| MD | MD | MD | MD |X |6.585352e-07|Maximal wavelength represented within the data set| |  
|em_res_power|double precision| D | D | D | D | |400|Spectral resolving power delta lambda/lamda, page 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 | |CHARA|Name of the facility at which data was taken| To be confirmed with the submission report|  
|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|smallint| D | D | D | D | X |90|TBD| |  
|nb_vis|smallint| N/A |D | D | D | X |90|TBD| |  
|nb_vis2|smallint|N/A | D | D | D | X |0|TBD|  | 
|nb_t3|smallint| 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|smallint | O | M | M | M |  | 2  | Information about t_0, r_0 for L0. For L1,L2,L3: manually filled | |
|Telescope configuration| text | M | D  | D | D  |X | UT1-UT2 | | |
|Instrument mode| text | M  | M  | M  | M | |LR |Dispersion mode, filters | add camera mode ? |


---+ 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: r2 - 2014-05-05 - GuillaumeMella