DARTS Astrophysical Data Search
[ English | Japanese ]
Schema of Tables about ASCA
| Satelite/Project | Abstract of the data product |
Database table name (Jump to description of table columns) |
Number of entries in the database | Searhcable with Basic Search | Searchable with SQL/ADQL Search | Name in the previous query system |
|---|---|---|---|---|---|---|
| ASCA | Observation log based on the observation list provided by the ASCA team. Last updated on 2000-10-26. | asca_observation_log | 3,079 | Yes | Yes | OBS |
| ASCA | Processing version of each sequence of ASCA observations. | asca_processing_info | 3,079 | No | Yes | PUBD |
| ASCA | Abstracts of ASCA proposals. | asca_proposal | 3,497 | Yes | Yes | PROPOSAL |
asca_observation_log
Observation log based on the observation list provided by the ASCA team. Last updated on 2000-10-26.
| No. | Column Name | Type | Unit | Description | Former Column Name | Former Type | Former Unit |
|---|---|---|---|---|---|---|---|
| 1 | observation_id | bigint | The sequence number of the observation. | SEQ_NO | bigint(11) | ||
| 2 | object_name | character varying(25) | The name of the target provided by the Principal Investigator (PI) of the observation. | TARGET_NAME | char(25) | ||
| 3 | proposal_ra | double precision | degree | The target position provided by the PI for observation, Right Ascension J2000. | TARGET_RA | double | degree |
| 4 | proposal_dec | double precision | degree | The target position provided by the PI for observation, Declination J2000. | TARGET_DEC | double | degree |
| 5 | euler_angle_1 | double precision | degree | The 1st euler angles of the observation. | EULER_1 | double | degree |
| 6 | euler_angle_2 | double precision | degree | The 2nd euler angles of the observation. | EULER_2 | double | degree |
| 7 | euler_angle_3 | double precision | degree | The 3rd euler angles of the observation. | EULER_3 | double | degree |
| 8 | center_ra | double precision | degree | The center of the field of view, Right Ascension J2000. (0,0) in the operational coordinate. | FOV_RA | double | degree |
| 9 | center_dec | double precision | degree | The center of the field of view, Declination J2000. (0,0) in the operational coordinate. | FOV_DEC | double | degree |
| 10 | center_ra_b1950 | double precision | degree | The center of the field of view, Right Ascension B1950. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 11 | center_dec_b1950 | double precision | degree | The center of the field of view, Declination B1950. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 12 | center_ecliptic_lon | double precision | degree | The center of the field of view, Ecliptic Longitude. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 13 | center_ecliptic_lat | double precision | degree | The center of the field of view, Ecliptic Latitude. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 14 | center_galactic_lon | double precision | degree | The center of the field of view, Galactic Longitude. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 15 | center_galactic_lat | double precision | degree | The center of the field of view, Galactic Latitude. Calculated from (center_ra, center_dec). | ― | ― | ― |
| 16 | offset_x | double precision | mm | The offset distance of the target position from the the center of the field of view. (X,Y) are the satellite axis. | OFFSET_X | double | mm |
| 17 | offset_y | double precision | mm | The offset distance of the target position from the the center of the field of view. (X,Y) are the satellite axis. | OFFSET_Y | double | mm |
| 18 | observation_start_time | timestamp without timezone | UTC | The start time of the observation (FRF start time) in UTC. | STARTTIME | date | UTC |
| 19 | observation_start_time_mjd | double precision | MJD | The start time of the observation (FRF start time) in MJD. | ― | ― | ― |
| 20 | observation_end_time | timestamp without timezone | UTC | The end time of the observation (FRF stop time) in UTC. | ENDTIME | date | UTC |
| 21 | observation_end_time_mjd | double precision | MJD | The end time of the observation (FRF stop time) in MJD. | ― | ― | ― |
| 22 | gis_exposure | double precision | ksec | The exposure times of the GIS. | EXPT_GIS | double | ks |
| 23 | sis_exposure | double precision | ksec | The exposure times of the SIS. | EXPT_SIS | double | ks |
| 24 | pi_name | character varying(255) | The last name of the PI of the observation. | PI_NAME | char(27) | ||
| 25 | db_create_date | timestamp without timezone | UTC | The registration date to this table. (UTC) | ENTRY_DATE | date | UTC |
| 26 | db_create_date_mjd | double precision | MJD | The registration date to this table. (MJD) | ― | ― | ― |
| 27 | data_access_url | character varying(255) | URL to the dataset | ― | ― | ― |
asca_processing_info
Processing version of each sequence of ASCA observations.
| No. | Column Name | Type | Unit | Description | Former Column Name | Former Type | Former Unit |
|---|---|---|---|---|---|---|---|
| 1 | observation_id | bigint | The sequence number of the observation. | SEQ_NO | bigint(11) | ||
| 2 | product_revision | smallint | Product Revision | REVISION | double | ||
| 3 | processing_version | smallint | Latest processing version | LATEST_PROC_VER | double | ||
| 4 | expect_public_date | timestamp without timezone | UTC | Expected Public Date in UTC | EXPECT_DATE | date | UTC |
| 5 | expect_public_date_mjd | double precision | MJD | Expected Public Date in MJD | ― | ― | ― |
| 6 | public_date | timestamp without timezone | UTC | Public Date in UTC | ACTUAL_PUBLIC_DATE | date | UTC |
| 7 | public_date | double precision | MJD | Public Date in MJD | ― | ― | |
| 8 | db_create_date | timestamp without timezone | UTC | The registration date to this table. (UTC) | ENTRY_DATE | date | |
| 9 | db_create_date_mjd | double precision | MJD | The registration date to this table. (MJD) | ― | ― | ― |
| 10 | data_access_url | character varying(255) | URL to the dataset | ― | ― | ― |
asca_proposal
Abstracts of ASCA proposals.
| No. | Column Name | Type | Unit | Description | Former Column Name | Former Type | Former Unit |
|---|---|---|---|---|---|---|---|
| 1 | observation_id | bigint | The sequence number of the observation. | SEQ_NO | bigint(11) | ||
| 2 | proposal_id | integer | The proposal number. | PRNB | int(7) | ||
| 3 | collabo_type | smallint | The type of the collaboration of the observation. [ 0(=no setting), 1(=JPN), 2(=US), 3(=Joint Japan/US, ie Japan PI with US cois), 4(=Joint US/Japan, ie US PI with Japan cois), 7(=Merged Japan/US, ie Japan PPI and US co-PI), 8(=Merged US/Japan, ie US PPI and Japan co-PI), 11(=ESA/Japan) ] | TYPE | smallint(3) | ||
| 4 | proposal_ra | double precision | degree | The target position provided by the PI for observation, Right Ascension J2000. | RA | double | degree |
| 5 | proposal_dec | double precision | degree | The target position provided by the PI for observation, Declination J2000. | DEC | double | degree |
| 6 | proposal_ra_b1950 | double precision | degree | The target position provided by the PI for observation, Right Ascension B1950. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 7 | proposal_dec_b1950 | double precision | degree | The target position provided by the PI for observation, Declination B1950. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 8 | proposal_ecliptic_lon | double precision | degree | The target position provided by the PI for observation, Ecliptic Longitude. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 9 | proposal_ecliptic_lat | double precision | degree | The target position provided by the PI for observation, Ecliptic Latitude. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 10 | proposal_galactic_lon | double precision | degree | The target position provided by the PI for observation, Galactic Longitude. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 11 | proposal_galactic_lat | double precision | degree | The target position provided by the PI for observation, Galactic Latitude. Calculated from (proposal_ra, proposal_dec). | ― | ― | ― |
| 12 | object_name | character varying(20) | The name of the target provided by the PI of the observation. | TAR_NAME | char(20) | ||
| 13 | awarded_exposure | double precision | ksec | The total accepted observation time. | TOT_OBS_TIME | double(8,2) | ks |
| 14 | is_time_critical | character(1) | Whether the observation is time-critical or not. [ Y (=yes) or N (=no) ] | TIMCR | char(1) | ||
| 15 | has_special_request | character(1) | Whether the observation has special request or not. [ Y (=yes) or N (=no) ] | SPEC_REQ | char(1) | ||
| 16 | is_offset | character(1) | Whether the observation is off-set poing or nor. [ Y (=yes) or N (=no) ] | OFFSET | char(1) | ||
| 17 | object_category | smallint | The target category of the observations. | SUB_CAT | smallint(2) | ||
| 18 | proposal_priority | smallint | The priority of the selection. | INT_PRIOR | smallint(2) | ||
| 19 | pi_name_jpn | character varying(255) | The names of the PI of the observation at Japan side. | JAPAN_PI_LNAME | char(27) | ||
| JAPAN_PI_FNAME | char(12) | ||||||
| 20 | pi_name_us | character varying(255) | The names of the PI of the observation at U.S. side. | US_PI_LNAME | char(27) | ||
| US_PI_FNAME | char(12) | ||||||
| 21 | proposal_affiliated_country | character varying(10) | The nationallity of the PI. | JAPAN_COUNTRY | char(10) | ||
| 22 | gis_observation_mode | character varying(4) | The GIS mode proposed by the PI. | GIS_MODE | char(4) | ||
| 23 | sis0_observation_mode | character varying(11) | The SIS (S0) observation mode proposed by the PI. | SIS0_DATA | char(11) | ||
| 24 | sis0_clock_mode | smallint | The SIS (S0) read-out mode proposed by the PI. | SIS0_CLOCK | smallint(2) | ||
| 25 | sis1_observation_mode | character varying(11) | The SIS (S1) observation mode proposed by the PI. | SIS1_DATA | char(11) | ||
| 26 | sis1_clock_mode | smallint | The SIS (S1) read-out mode proposed by the PI. | SIS1_CLOCK | smallint(2) | ||
| 27 | recorder_bit_rate | character(1) | The bit-rate of the data recorder proposed by the PI. | BIT_RATE | char(1) | ||
| 28 | predicted_sis_count_rate | double precision | The predicted SIS count rate in (c/s/SIS). | PRED_SIS_CTS | double | ||
| 29 | db_create_date | timestamp without timezone | UTC | The registration date to the ODB(Observation Data Base) which was managed by X-ray group. | ENTRY_DATE | date | |
| 30 | db_create_date_mjd | double precision | MJD | The registration date to the ODB(Observation Data Base) which was managed by X-ray group. | ― | ― | ― |
| 31 | data_access_url | character varying(255) | URL to the dataset | ― | ― | ― |