The status of tables
No. Table Name Status Count Description
1 OBS Completed 3079   This table contains data on the ASCA observation. This was created based on an observation log table prodived by the ASCA team (http://www.astro.isas.jaxa.jp/asca/operation/obslog/index-e.html). There was no change since 2000-10-26.
2 PROPOSAL   3497   


The details of column data

Table Name: OBS
No. Column Name Type Unit Description
1 SEQ_NO bigint(11)     The sequence number of the observation.
2 TARGET_NAME char(25)     The name of the target provided by the Principal Investigator (PI) of the observation.
3 TARGET_RA double degree   The right ascension of the target provided by the PI of the observation. (J2000.0).
4 TARGET_DEC double degree   The declination of the target provided by the PI of the observation. (J2000.0).
5 EULER_1 double degree   The 1st euler angles of the observation.
6 EULER_2 double degree   The 2nd euler angles of the observation.
7 EULER_3 double degree   The 3rd euler angles of the observation.
8 FOV_RA double     The right ascension of the center [(0,0) in the operational coordinate] of the field of view.
9 FOV_DEC double     The declination of the center [(0,0) in the operational coordinate] of the field of view.
10 OFFSET_X double mm   The offset distance of the target position from the the center [(0,0) in the operational coordinate] of the field of view.
  (X,Y) are the satellite axis.
11 OFFSET_Y double mm   The offset distance of the target position from the the center [(0,0) in the operational coordinate] of the field of view.
  (X,Y) are the satellite axis.
12 STARTTIME date     The start time of the observation (FRF start time).
13 ENDTIME date     The end time of the observation (FRF start time).
14 EXPT_GIS double ks   The exposure times of the GIS.
15 EXPT_SIS double ks   The exposure times of the SIS.
16 PI_NAME char(27)     The last name of the PI of the observation.
17 ENTRY_DATE date     The date when the record was stored in this table.


Back to top

Table Name: PROPOSAL
No. Column Name Type Unit Description
1 SEQ_NO bigint(11)     The sequence number of the observation.
2 PRNB int(7)     The proposal number.
3 TYPE smallint(3)     The type of the collaboration of the observation.
4 RA double degree   The right ascension of the target provided by the Principal Investigator (PI) of the observation. (J2000.0).
5 DEC double degree   The declination of the target provided by the Principal Investigator (PI) of the observation. (J2000.0).
6 TAR_NAME char(20)     The name of the target provided by the PI of the observation.
7 TOT_OBS_TIME double(8,2) ks   The total accepted observation time.
8 TIMCR char(1)     Whether the observation is time-critical or not.
9 SPEC_REQ char(1)     Whether the observation has special request or not.
10 OFFSET char(1)     Whether the observation is off-set poing or nor.
11 SUB_CAT smallint(2)     The target category of the observations.
12 INT_PRIOR smallint(2)     The priority of the selection.
13 JAPAN_PI_LNAME char(27)     
14 JAPAN_PI_FNAME char(12)     
15 US_PI_LNAME char(27)     The last (L) names of the PI of the observation.
16 US_PI_FNAME char(12)     The first (F) names of the PI of the observation.
17 JAPAN_COUNTRY char(10)     The nationallity of the PI.
18 GIS_MODE char(4)     The GIS mode proposed by the PI.
19 SIS0_DATA char(11)     The SIS (S0) observation mode proposed by the PI.
20 SIS0_CLOCK smallint(2)     The SIS (S0) read-out mode proposed by the PI.
21 SIS1_DATA char(11)     
22 SIS1_CLOCK smallint(2)     
23 BIT_RATE char(1)     The bit-rate of the data recorder proposed by the PI.
24 PRED_SIS_CTS double     The predicted SIS count rate in (c/s/SIS).
25 ENTRY_DATE date     The data when the data was stored to the original database (not the DARTS).


Back to top