Acknowledgements

If you use this database in your work, please cite the Zenodo record of the appropriate release.

This project was made possible by the generous allocation of the Director's Discretionary Research Fund at the Space Telescope Science Institute. The authors include:


History

Version Release Date Description
0.2 2018-06-06 Preliminary release with over 11,000 sources, photometry, parallaxes, and spectral types only.
0.1-beta 2017-11-30 Initial release of the ONCdb which contains photometry exclusively from Robberto et al. 2013

Schema

Table Number of Records
changelog 0
ignore 0
images 0
instruments 9
modes 0
parallaxes 2266
photometry 76467
proper_motions 0
publications 7
radial_velocities 0
sources 11633
spectra 1
spectral_types 414
systems 2
telescopes 6
versions 0

changelog

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 date TEXT 0 None 0
2 user TEXT 0 None 0
3 machine_name TEXT 0 None 0
4 modified_tables TEXT 0 None 0
5 user_description TEXT 0 None 0
6 filename TEXT 0 None 0

Back to top

ignore

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 id1 INTEGER 1 None 0
2 id2 INTEGER 1 None 0
3 tablename TEXT 1 None 0

Back to top

images

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 image IMAGE 1 None 0
3 band TEXT 1 None 0
4 regime TEXT 0 None 0
5 publication_shortname TEXT 0 None 0
6 obs_date TEXT 0 None 0
7 instrument_id INTEGER 0 None 0
8 telescope_id INTEGER 0 None 0
9 mode_id INTEGER 0 None 0
10 filename TEXT 0 None 0
11 comments TEXT 0 None 0
12 best INTEGER 0 None 0
13 version REAL 0 None 0
14 record TEXT 0 None 0

Back to top

instruments

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 name TEXT 1 None 0
2 publication_shortname TEXT 0 None 0

Back to top

modes

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 mode TEXT 1 None 0

Back to top

parallaxes

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 parallax REAL 1 None 0
3 parallax_unc REAL 0 None 0
4 publication_shortname TEXT 0 None 0
5 adopted INTEGER 0 None 0
6 comments TEXT 0 None 0
7 version REAL 0 None 0
8 record TEXT 0 None 0

Back to top

photometry

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 band TEXT 1 None 0
3 magnitude REAL 1 None 0
4 magnitude_unc REAL 0 None 0
5 flags TEXT 0 None 0
6 system_id INTEGER 0 None 0
7 telescope_id INTEGER 0 None 0
8 instrument_id INTEGER 0 None 0
9 publication_shortname TEXT 0 None 0
10 epoch TEXT 0 None 0
11 ra REAL 0 None 0
12 dec REAL 0 None 0
13 comments TEXT 0 None 0
14 version REAL 0 None 0
15 record TEXT 0 None 0

Back to top

proper_motions

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 proper_motion_ra REAL 1 None 0
3 proper_motion_ra_unc REAL 0 None 0
4 proper_motion_dec REAL 1 None 0
5 proper_motion_dec_unc REAL 0 None 0
6 V_tan REAL 0 None 0
7 V_tan_unc REAL 0 None 0
8 publication_shortname TEXT 0 None 0
9 comments TEXT 0 None 0
10 version REAL 0 None 0
11 record TEXT 0 None 0

Back to top

publications

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 bibcode TEXT 0 None 0
2 shortname TEXT 1 None 2
3 DOI TEXT 0 None 0
4 description TEXT 0 None 0

Back to top

radial_velocities

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 radial_velocity REAL 1 None 0
3 radial_velocity_unc REAL 0 None 0
4 spectrum_id INTEGER 0 None 0
5 publication_shortname TEXT 0 None 0
6 comments TEXT 0 None 0
7 version REAL 0 None 0
8 record TEXT 0 None 0

Back to top

sources

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 ra REAL 0 None 0
2 dec REAL 0 None 0
3 designation TEXT 0 None 0
4 publication_shortname TEXT 0 None 0
5 unum TEXT 0 None 0
6 shortname TEXT 0 None 0
7 names TEXT 0 None 0
8 components TEXT 0 None 0
9 companions TEXT 0 None 0
10 comments TEXT 0 None 0
11 version REAL 0 None 0
12 record TEXT 0 None 0

Back to top

spectra

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 spectrum SPECTRUM 1 None 0
3 wavelength_units TEXT 0 None 0
4 flux_units TEXT 0 None 0
5 wavelength_order INTEGER 0 None 0
6 regime TEXT 0 None 0
7 publication_shortname TEXT 0 None 0
8 obs_date TEXT 0 None 0
9 instrument_id INTEGER 0 None 0
10 telescope_id INTEGER 0 None 0
11 mode_id INTEGER 0 None 0
12 filename TEXT 0 None 0
13 comments TEXT 0 None 0
14 best INTEGER 0 None 0
15 version REAL 0 None 0
16 local_spectrum SPECTRUM 0 None 0
17 record TEXT 0 None 0

Back to top

spectral_types

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id INTEGER 1 None 0
2 spectral_type REAL 1 None 0
3 spectral_type_unc REAL 0 None 0
4 luminosity_class TEXT 0 None 0
5 gravity TEXT 0 None 0
6 suffix TEXT 0 None 0
7 regime TEXT 0 None 0
8 publication_shortname TEXT 0 None 0
9 adopted INTEGER 0 None 0
10 comments TEXT 0 None 0
11 version REAL 0 None 0
12 gravity_publication TEXT 0 None 0
13 record TEXT 0 None 0

Back to top

systems

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 name TEXT 1 None 0

Back to top

telescopes

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 name TEXT 1 None 0
2 publication_shortname TEXT 0 None 0

Back to top

versions

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 version REAL 1 None 0
2 date_published TEXT 0 None 0
3 publication_shortname TEXT 0 None 0
4 comment TEXT 0 None 0

Back to top