public.target¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| target_id | bigint | nextval('target_target_id_seq'::regclass) | false | public.cluster | Unique identifier for each target | |
| proposal_id | varchar | true | public.proposal | |||
| obj_id | bigint | false | Object ID as specified by the observer at Phase 2 (can be same as the input_catalog_object_id) | |||
| ra | double precision | false | RA (ICRS, degree) | |||
| dec | double precision | false | Dec (ICRS, degree) | |||
| epoch | varchar | true | Epoch (default: J2000.0) | |||
| parallax | double precision | true | Parallax (mas) | |||
| pmra | double precision | true | Proper motion in right ascension direction (mas/yr) | |||
| pmdec | double precision | true | Proper motion in declination direction (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 | true | public.target_type | target type ID (default: 1 = SCIENCE) | ||
| input_catalog_id | integer | false | public.input_catalog | Input catalog ID from the input_catalog table | ||
| fiber_mag_g | double precision | true | g-band magnitude within a fiber (AB mag) | |||
| fiber_mag_r | double precision | true | r-band magnitude within a fiber (AB mag) | |||
| fiber_mag_i | double precision | true | i-band magnitude within a fiber (AB mag) | |||
| fiber_mag_z | double precision | true | z-band magnitude within a fiber (AB mag) | |||
| fiber_mag_y | double precision | true | y-band magnitude within a fiber (AB mag) | |||
| fiber_mag_j | double precision | true | J band magnitude within a fiber (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_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) | |||
| priority | double precision | true | Priority of the target specified by the observer within the proposal | |||
| effective_exptime | double precision | false | Requested effective exposure time (s) | |||
| is_medium_resolution | boolean | true | True if the medium resolution mode is requested | |||
| qa_relative_throughput | double precision | true | Relative throughput to the reference value requested by the observer (default: 1.0) | |||
| qa_relative_noise | double precision | true | Relative noise to the reference value requested by the observer (default: 1.0) | |||
| qa_reference_lambda | double precision | true | Reference wavelength to evaluate effective exposure time (angstrom or nm?) | |||
| is_cluster | boolean | true | True if it is a cluster of multiple targets. | |||
| 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 | |||
| 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.) | ||
| 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_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) | |||
| ob_code | varchar | false | Identifer for a combination of a target, observing mode, and exposure time in a program. | |||
| single_exptime | double precision | false | Individual exposure time (s) | |||
| qa_reference_arm | varchar | true | public.pfs_arm | Reference arm to evaluate effective exposure time ('b', 'r', 'n', 'm') | ||
| total_flux_g | double precision | true | g-band total flux (nJy) | |||
| total_flux_r | double precision | true | r-band total flux (nJy) | |||
| total_flux_i | double precision | true | i-band total flux (nJy) | |||
| total_flux_z | double precision | true | z-band total flux (nJy) | |||
| total_flux_y | double precision | true | y-band total flux (nJy) | |||
| total_flux_j | double precision | true | J band total flux (nJy) | |||
| total_flux_error_g | double precision | true | Error in g-band total flux (nJy) | |||
| total_flux_error_r | double precision | true | Error in r-band total flux (nJy) | |||
| total_flux_error_i | double precision | true | Error in i-band total flux (nJy) | |||
| total_flux_error_z | double precision | true | Error in z-band total flux (nJy) | |||
| total_flux_error_y | double precision | true | Error in y-band total flux (nJy) | |||
| total_flux_error_j | double precision | true | Error in J band total flux (nJy) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| target_filter_g_fkey | FOREIGN KEY | FOREIGN KEY (filter_g) REFERENCES filter_name(filter_name) |
| target_filter_i_fkey | FOREIGN KEY | FOREIGN KEY (filter_i) REFERENCES filter_name(filter_name) |
| target_filter_j_fkey | FOREIGN KEY | FOREIGN KEY (filter_j) REFERENCES filter_name(filter_name) |
| target_filter_r_fkey | FOREIGN KEY | FOREIGN KEY (filter_r) REFERENCES filter_name(filter_name) |
| target_filter_y_fkey | FOREIGN KEY | FOREIGN KEY (filter_y) REFERENCES filter_name(filter_name) |
| target_filter_z_fkey | FOREIGN KEY | FOREIGN KEY (filter_z) REFERENCES filter_name(filter_name) |
| target_input_catalog_id_fkey | FOREIGN KEY | FOREIGN KEY (input_catalog_id) REFERENCES input_catalog(input_catalog_id) |
| target_qa_reference_arm_fkey | FOREIGN KEY | FOREIGN KEY (qa_reference_arm) REFERENCES pfs_arm(name) |
| target_proposal_id_fkey | FOREIGN KEY | FOREIGN KEY (proposal_id) REFERENCES proposal(proposal_id) |
| target_target_type_id_fkey | FOREIGN KEY | FOREIGN KEY (target_type_id) REFERENCES target_type(target_type_id) |
| target_pkey | PRIMARY KEY | PRIMARY KEY (target_id) |
| target_propid_obcode_catid_objid_resolution_key | UNIQUE | UNIQUE (proposal_id, ob_code, input_catalog_id, obj_id, is_medium_resolution) |
| target_propid_obcode_key | UNIQUE | UNIQUE (proposal_id, ob_code) |
Indexes¶
| Name | Definition |
|---|---|
| target_pkey | CREATE UNIQUE INDEX target_pkey ON public.target USING btree (target_id) |
| target_propid_obcode_catid_objid_resolution_key | CREATE UNIQUE INDEX target_propid_obcode_catid_objid_resolution_key ON public.target USING btree (proposal_id, ob_code, input_catalog_id, obj_id, is_medium_resolution) |
| target_propid_obcode_key | CREATE UNIQUE INDEX target_propid_obcode_key ON public.target USING btree (proposal_id, ob_code) |
| target_q3c_ang2ipix_idx | CREATE INDEX target_q3c_ang2ipix_idx ON public.target USING btree (q3c_ang2ipix(ra, "dec")) |
| target_input_catalog_id_idx | CREATE INDEX target_input_catalog_id_idx ON public.target USING btree (input_catalog_id) |
| target_obj_id_input_catalog_id_idx | CREATE INDEX target_obj_id_input_catalog_id_idx ON public.target USING btree (obj_id, input_catalog_id) |
| target_proposal_id_idx | CREATE INDEX target_proposal_id_idx ON public.target USING btree (proposal_id) |
| target_proposal_id_obj_id_idx | CREATE INDEX target_proposal_id_obj_id_idx ON public.target USING btree (proposal_id, obj_id) |
Relations¶
erDiagram
"public.cluster" }o--|| "public.target" : "FOREIGN KEY (target_id) REFERENCES target(target_id)"
"public.target" }o--o| "public.proposal" : "FOREIGN KEY (proposal_id) REFERENCES proposal(proposal_id)"
"public.target" }o--o| "public.target_type" : "FOREIGN KEY (target_type_id) REFERENCES target_type(target_type_id)"
"public.target" }o--|| "public.input_catalog" : "FOREIGN KEY (input_catalog_id) REFERENCES input_catalog(input_catalog_id)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_g) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_r) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_i) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_z) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_y) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.filter_name" : "FOREIGN KEY (filter_j) REFERENCES filter_name(filter_name)"
"public.target" }o--o| "public.pfs_arm" : "FOREIGN KEY (qa_reference_arm) REFERENCES pfs_arm(name)"
"public.target" {
bigint target_id
varchar proposal_id FK
bigint obj_id
double_precision ra
double_precision dec
varchar epoch
double_precision parallax
double_precision pmra
double_precision pmdec
integer tract
integer patch
integer target_type_id FK
integer input_catalog_id FK
double_precision fiber_mag_g
double_precision fiber_mag_r
double_precision fiber_mag_i
double_precision fiber_mag_z
double_precision fiber_mag_y
double_precision fiber_mag_j
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_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 priority
double_precision effective_exptime
boolean is_medium_resolution
double_precision qa_relative_throughput
double_precision qa_relative_noise
double_precision qa_reference_lambda
boolean is_cluster
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
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 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_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 ob_code
double_precision single_exptime
varchar qa_reference_arm FK
double_precision total_flux_g
double_precision total_flux_r
double_precision total_flux_i
double_precision total_flux_z
double_precision total_flux_y
double_precision total_flux_j
double_precision total_flux_error_g
double_precision total_flux_error_r
double_precision total_flux_error_i
double_precision total_flux_error_z
double_precision total_flux_error_y
double_precision total_flux_error_j
}
"public.cluster" {
bigint cluster_id
bigint target_id FK
integer n_targets
double_precision ra_cluster
double_precision dec_cluster
double_precision d_ra
double_precision d_dec
integer input_catalog_id FK
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
}
"public.proposal" {
varchar proposal_id
varchar group_id
varchar pi_first_name
varchar pi_last_name
varchar pi_middle_name
double_precision rank
varchar grade
double_precision allocated_time_total
integer proposal_category_id FK
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
double_precision allocated_time_lr
double_precision allocated_time_mr
boolean is_too
integer partner_id FK
}
"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" {
varchar input_catalog_name
varchar input_catalog_description
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
varchar_16_ upload_id
integer input_catalog_id
boolean active
boolean is_classical
boolean is_user_pointing
}
"public.filter_name" {
varchar filter_name
varchar filter_name_description
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
}
"public.pfs_arm" {
varchar name
varchar description
timestamp_without_time_zone created_at
timestamp_without_time_zone updated_at
}Generated by tbls