Database Schema


In more detail, the following tables are part of the database: changelog data_requests ignore instruments modes parallaxes photometry proper_motions publications radial_velocities sources spectra spectral_types systems telescopes versions


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

data_requests

cid name type notnull dflt_value pk
0 id INTEGER 1 None 1
1 source_id NUMERIC 1 None 0
2 source TEXT 0 None 0
3 data_request TEXT 0 None 0
4 purpose 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

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

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 system_id INTEGER 0 None 0
6 telescope_id INTEGER 0 None 0
7 instrument_id INTEGER 0 None 0
8 publication_shortname TEXT 0 None 0
9 epoch TEXT 0 None 0
10 comments TEXT 0 None 0
11 version REAL 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

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

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

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

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 gravity TEXT 0 None 0
5 suffix TEXT 0 None 0
6 regime TEXT 0 None 0
7 publication_shortname TEXT 0 None 0
8 adopted INTEGER 0 None 0
9 comments TEXT 0 None 0
10 version REAL 0 None 0
11 gravity_publication 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

Return to query