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