Skip to content

public.fluxstd

Columns

Name Type Default Nullable Children Parents Comment
fluxstd_id bigint nextval('fluxstd_fluxstd_id_seq'::regclass) false Unique identifier for each flux standard star
obj_id bigint false source_id (e.g., Gaia EDR3, DR3, etc.)
ra double precision false RA (ICRS, degree)
dec double precision false Dec (ICRS, degree)
epoch varchar 'J2000.0'::character varying true Epoch (e.g., J2000.0, J2015.5, etc.)
parallax double precision 0.0000001 true Parallax (mas)
parallax_error double precision true Standard error of parallax (mas)
pmra double precision 0.0 true Proper motion in right ascension direction (mas/yr)
pmra_error double precision true Standard error of pmra (mas/yr)
pmdec double precision 0.0 true Proper motion in declination direction (mas/yr)
pmdec_error double precision true Standard error of pmdec (mas/yr)
tract integer true same definition as HSC-SSP?; can be derived from the coordinate
patch integer true same definition as HSC-SSP?; can be derived from the coordinate; Note that it's defined as an integer
target_type_id integer 3 true public.target_type target_type_id from the target_type table (must be 3 for FLUXSTD)
input_catalog_id integer false public.input_catalog input_catalog_id from the input_catalog table
psf_mag_u double precision true u-band PSF magnitude (AB mag)
psf_mag_v double precision true v-band PSF magnitude (AB mag)
psf_mag_g double precision true g-band PSF magnitude (AB mag)
psf_mag_r double precision true r-band PSF magnitude (AB mag)
psf_mag_i double precision true i-band PSF magnitude (AB mag)
psf_mag_z double precision true z-band PSF magnitude (AB mag)
psf_mag_y double precision true y-band PSF magnitude (AB mag)
psf_mag_j double precision true J band PSF magnitude (AB mag)
psf_mag_error_u double precision true Error in u-band PSF magnitude (AB mag)
psf_mag_error_v double precision true Error in v-band PSF magnitude (AB mag)
psf_mag_error_g double precision true Error in g-band PSF magnitude (AB mag)
psf_mag_error_r double precision true Error in r-band PSF magnitude (AB mag)
psf_mag_error_i double precision true Error in i-band PSF magnitude (AB mag)
psf_mag_error_z double precision true Error in z-band PSF magnitude (AB mag)
psf_mag_error_y double precision true Error in y-band PSF magnitude (AB mag)
psf_mag_error_j double precision true Error in J band PSF magnitude (AB mag)
psf_flux_u double precision true u-band PSF flux (nJy)
psf_flux_v double precision true v-band PSF flux (nJy)
psf_flux_g double precision true g-band PSF flux (nJy)
psf_flux_r double precision true r-band PSF flux (nJy)
psf_flux_i double precision true i-band PSF flux (nJy)
psf_flux_z double precision true z-band PSF flux (nJy)
psf_flux_y double precision true y-band PSF flux (nJy)
psf_flux_j double precision true J band PSF flux (nJy)
psf_flux_error_u double precision true Error in u-band PSF flux (nJy)
psf_flux_error_v double precision true Error in v-band PSF flux (nJy)
psf_flux_error_g double precision true Error in g-band PSF flux (nJy)
psf_flux_error_r double precision true Error in r-band PSF flux (nJy)
psf_flux_error_i double precision true Error in i-band PSF flux (nJy)
psf_flux_error_z double precision true Error in z-band PSF flux (nJy)
psf_flux_error_y double precision true Error in y-band PSF flux (nJy)
psf_flux_error_j double precision true Error in J band PSF flux (nJy)
filter_u varchar true public.filter_name u-band filter (u_sdss, u_cfht, u_skymapper, etc.)
filter_v varchar true public.filter_name v-band filter (v_skymapper, v_splus, etc.)
filter_g varchar true public.filter_name g-band filter (g_hsc, g_ps1, g_sdss, etc.)
filter_r varchar true public.filter_name r-band filter (r_hsc, r_ps1, r_sdss, etc.)
filter_i varchar true public.filter_name i-band filter (i_hsc, i_ps1, i_sdss, etc.)
filter_z varchar true public.filter_name z-band filter (z_hsc, z_ps1, z_sdss, etc.)
filter_y varchar true public.filter_name y-band filter (y_hsc, y_ps1, y_sdss, etc.)
filter_j varchar true public.filter_name j-band filter (j_mko, etc.)
prob_f_star double precision true Probability of being an F-type star
flags_dist boolean true Distance uncertanty flag, True if parallax_error/parallax > 0.2
flags_ebv boolean true E(B-V) uncertainty flag, True if E(B-V) uncertainty is greater than 20%
teff_brutus double precision true Effective temperature from Brutus code [K]
teff_brutus_low double precision true Lower confidence level (16%) of effective temperature from Brutus code [K]
teff_brutus_high double precision true Upper confidence level (84%) of effective temperature from Brutus code [K]
logg_brutus double precision true Surface gravity from Brutus code [log cgs]
logg_brutus_low double precision true Lower confidence level (16%) of surface gravity from Brutus code [log cgs]
logg_brutus_high double precision true Upper confidence level (84%) of surface gravity from Brutus code [log cgs]
teff_gspphot double precision true Effective temperature inferred by GSP-phot Aeneas [K]
teff_gspphot_lower double precision true Lower confidence level (16%) of effective temperature inferred by GSP-phot Aeneas [K]
teff_gspphot_upper double precision true Upper confidence level (84%) of effective temperature inferred by GSP-phot Aeneas [K]
is_fstar_gaia boolean false true Flag for F-star from Gaia (Teff=6000-7500K if True)
is_gc_neighbor boolean false true Flag for globular cluster neighbor
is_dense_region boolean false true Flag for dense stellar region
version varchar false Version string of the F-star selection
created_at timestamp without time zone timezone('utc'::text, CURRENT_TIMESTAMP) true The date and time in UTC when the record was created
updated_at timestamp without time zone true The date and time in UTC when the record was last updated

Constraints

Name Type Definition
fluxstd_filter_g_fkey FOREIGN KEY FOREIGN KEY (filter_g) REFERENCES filter_name(filter_name)
fluxstd_filter_i_fkey FOREIGN KEY FOREIGN KEY (filter_i) REFERENCES filter_name(filter_name)
fluxstd_filter_j_fkey FOREIGN KEY FOREIGN KEY (filter_j) REFERENCES filter_name(filter_name)
fluxstd_filter_r_fkey FOREIGN KEY FOREIGN KEY (filter_r) REFERENCES filter_name(filter_name)
fluxstd_filter_u_fkey FOREIGN KEY FOREIGN KEY (filter_u) REFERENCES filter_name(filter_name)
fluxstd_filter_v_fkey FOREIGN KEY FOREIGN KEY (filter_v) REFERENCES filter_name(filter_name)
fluxstd_filter_y_fkey FOREIGN KEY FOREIGN KEY (filter_y) REFERENCES filter_name(filter_name)
fluxstd_filter_z_fkey FOREIGN KEY FOREIGN KEY (filter_z) REFERENCES filter_name(filter_name)
fluxstd_input_catalog_id_fkey FOREIGN KEY FOREIGN KEY (input_catalog_id) REFERENCES input_catalog(input_catalog_id)
fluxstd_target_type_id_fkey FOREIGN KEY FOREIGN KEY (target_type_id) REFERENCES target_type(target_type_id)
fluxstd_pkey PRIMARY KEY PRIMARY KEY (fluxstd_id)
uq_obj_id_input_catalog_id_version UNIQUE UNIQUE (obj_id, input_catalog_id, version)

Indexes

Name Definition
fluxstd_pkey CREATE UNIQUE INDEX fluxstd_pkey ON public.fluxstd USING btree (fluxstd_id)
uq_obj_id_input_catalog_id_version CREATE UNIQUE INDEX uq_obj_id_input_catalog_id_version ON public.fluxstd USING btree (obj_id, input_catalog_id, version)
fluxstd_q3c_ang2ipix_idx CREATE INDEX fluxstd_q3c_ang2ipix_idx ON public.fluxstd USING btree (q3c_ang2ipix(ra, "dec"))
ix_fluxstd_version CREATE INDEX ix_fluxstd_version ON public.fluxstd USING btree (version)
ix_fluxstd_input_catalog_fluxstdid CREATE INDEX ix_fluxstd_input_catalog_fluxstdid ON public.fluxstd USING btree (input_catalog_id, fluxstd_id)
ix_fluxstd_version_fluxstdid CREATE INDEX ix_fluxstd_version_fluxstdid ON public.fluxstd USING btree (version, fluxstd_id)

Relations

erDiagram

"public.fluxstd" }o--o| "public.target_type" : "FOREIGN KEY (target_type_id) REFERENCES target_type(target_type_id)"
"public.fluxstd" }o--|| "public.input_catalog" : "FOREIGN KEY (input_catalog_id) REFERENCES input_catalog(input_catalog_id)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_u) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_v) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_g) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_r) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_i) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_z) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_y) REFERENCES filter_name(filter_name)"
"public.fluxstd" }o--o| "public.filter_name" : "FOREIGN KEY (filter_j) REFERENCES filter_name(filter_name)"

"public.fluxstd" {
  bigint fluxstd_id
  bigint obj_id
  double_precision ra
  double_precision dec
  varchar epoch
  double_precision parallax
  double_precision parallax_error
  double_precision pmra
  double_precision pmra_error
  double_precision pmdec
  double_precision pmdec_error
  integer tract
  integer patch
  integer target_type_id FK
  integer input_catalog_id FK
  double_precision psf_mag_u
  double_precision psf_mag_v
  double_precision psf_mag_g
  double_precision psf_mag_r
  double_precision psf_mag_i
  double_precision psf_mag_z
  double_precision psf_mag_y
  double_precision psf_mag_j
  double_precision psf_mag_error_u
  double_precision psf_mag_error_v
  double_precision psf_mag_error_g
  double_precision psf_mag_error_r
  double_precision psf_mag_error_i
  double_precision psf_mag_error_z
  double_precision psf_mag_error_y
  double_precision psf_mag_error_j
  double_precision psf_flux_u
  double_precision psf_flux_v
  double_precision psf_flux_g
  double_precision psf_flux_r
  double_precision psf_flux_i
  double_precision psf_flux_z
  double_precision psf_flux_y
  double_precision psf_flux_j
  double_precision psf_flux_error_u
  double_precision psf_flux_error_v
  double_precision psf_flux_error_g
  double_precision psf_flux_error_r
  double_precision psf_flux_error_i
  double_precision psf_flux_error_z
  double_precision psf_flux_error_y
  double_precision psf_flux_error_j
  varchar filter_u FK
  varchar filter_v FK
  varchar filter_g FK
  varchar filter_r FK
  varchar filter_i FK
  varchar filter_z FK
  varchar filter_y FK
  varchar filter_j FK
  double_precision prob_f_star
  boolean flags_dist
  boolean flags_ebv
  double_precision teff_brutus
  double_precision teff_brutus_low
  double_precision teff_brutus_high
  double_precision logg_brutus
  double_precision logg_brutus_low
  double_precision logg_brutus_high
  double_precision teff_gspphot
  double_precision teff_gspphot_lower
  double_precision teff_gspphot_upper
  boolean is_fstar_gaia
  boolean is_gc_neighbor
  boolean is_dense_region
  varchar version
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
}
"public.target_type" {
  integer target_type_id
  varchar target_type_name
  varchar target_type_description
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
}
"public.input_catalog" {
  integer input_catalog_id
  varchar input_catalog_name
  varchar input_catalog_description
  varchar_16_ upload_id
  boolean active
  boolean is_classical
  boolean is_user_pointing
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
}
"public.filter_name" {
  varchar filter_name
  varchar filter_name_description
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
}

Generated by tbls