The status of tables
No. Table Name Status Count Description
1 PKGINFO Updating 24436   AKARI package file information.
2 OBSLOG Updating 24436   AKARI observation log.
3 PROGRAM Updating 149   AKARI observation program.
4 PFILES Updating 344265   AKARI pointing observation files.
5 REMARKS   7   Remarks.


The details of column data

Table Name: PKGINFO
No. Column Name Type Unit Description
1 DATE date     Observation Date
2 TIME time     Observation Time
3 OBSID varchar(11)     TargetID-SubID
4 OBJECT varchar(63)     Object name
5 OBSERVER varchar(35)     PI Name (Observer's ID)
6 PROPOSAL varchar(7)     Proposal ID
7 OBJ_RA double degree   [degree] Target position
8 OBJ_DEC double degree   [degree] Target position
9 AOT varchar(11)     Observation AOT
10 AOTPARAM varchar(15)     AOT Parameter
11 STATUS varchar(31)     Observation Status
12 OBS_MODE varchar(11)     Observation Mode
13 AOT_TYPE varchar(15)     AOT Type
14 TARGETID int(11)     Target ID
15 SUBID int(11)     Sub ID
16 PNTNG_ID int(11)     Pointing ID
17 OBJ_LII double degree   [degree] Galactic Longitude
  Calculated from (OBJ_RA, OBJ_DEC)
18 OBJ_BII double degree   [degree] Galactic Latitude
  Calculated from (OBJ_RA, OBJ_DEC)
19 OBJ_ECL_LONG double degree   [degree] Ecliptic Longitude
  Calculated from (OBJ_RA, OBJ_DEC)
20 OBJ_ECL_LATI double degree   [degree] Ecliptic Latitude
  Calculated from (OBJ_RA, OBJ_DEC)
21 PUBLIC_DATE date     Public Date
22 PKGPATH varchar(63)     Package Path
23 PKGFSIZE int(11) Byte   Package File Size
24 PKGMTIME datetime     Package Modification Time
25 REMIDS varchar(31)     Remark ID
26 REMNAMES varchar(255)     Remark Name
27 REMHREFS text     Remark Name with HREF


Back to top

Table Name: OBSLOG
No. Column Name Type Unit Description
1 DATE date     Observation Start Date
2 TIME time     Observation Start Time
3 TARGETID int(11)     Target ID
4 SUBID int(11)     Sub ID
5 OBJECT varchar(63)     Object name
6 OBSERVER varchar(35)     PI Name (Observer's ID)
7 PROPOSAL varchar(7)     Proposal ID
8 AOT varchar(11)     Observation AOT
9 AOTPARAM varchar(15)     AOT Parameter
10 STATUS varchar(31)     Observation Status


Back to top

Table Name: PROGRAM
No. Column Name Type Unit Description
1 IDCODE int(11)     ID code
2 PROPOSAL varchar(7)     Proposal ID
3 PROPOSALID varchar(31)     Proposal ID with PI name
4 OBSERVER varchar(35)     PI Name (Observer's ID)
5 OBS_CAT varchar(11)     Observation Category
6 TITLE_FULL text     Title


Back to top

Table Name: PFILES
No. Column Name Type Unit Description
1 FILENAME varchar(39)     FITS File Name
2 PKGNAME varchar(23)     Package Name
3 VERSION varchar(7)     Version of Package
4 PKGPATH varchar(23)     Path to Package
5 PKGFMT varchar(11)     Extension of Package File
6 FMTTYPE varchar(19)     Type of Format in FITS file
7 FTYPEVER int(11)     Version of FMTTYPE
8 CNTTYPE varchar(11)     Type of data content
9 DATE datetime     File Creation Date
10 CRTRVER varchar(11)     Version of CREATOR
11 PIPELINE varchar(47)     Data Processing Pipeline name
12 DATASTAT varchar(11)     Data status
13 ORIGIN varchar(11)     Organization creating FITS file
14 INSTRUME varchar(7)     Identifier of the instrument
15 DETECTOR varchar(7)     Detector name
16 OBSERVER varchar(35)     PI Name (Observer's ID)
17 OBS_CAT varchar(11)     Observation Category
18 PROPOSAL varchar(7)     Proposal ID
19 TARGETID int(11)     Target ID
20 SUBID int(11)     Sub ID
21 PNTNG_ID int(11)     Pointing ID
22 OBJECT varchar(63)     Object name
23 OBJ_RA double degree   [degree] Target position
24 OBJ_DEC double degree   [degree] Target position
25 AOT varchar(11)     Observation AOT
26 AOTPARAM varchar(15)     AOT Parameter
27 INSTMODE varchar(7)     Instrument operation mode
28 DATE_OBS datetime     Observation start date+time
29 DATE_END datetime     Observation end date+time
30 DATE_REF datetime     Reference time in the Observation
31 AFTM_OBS double sec   DATE-OBS in ASTRO-F Time
32 AFTM_END double sec   DATE-END in ASTRO-F Time
33 AFTM_REF double sec   DATE-REF in ASTRO-F Time
34 PIMTIOBS bigint(20)     DATE-OBS in PIM-TI (36bits DHUTI)
35 PIMTIEND bigint(20)     DATE-END in PIM-TI (36bits DHUTI)
36 PIMTIREF bigint(20)     DATE-REF in PIM-TI (36bits DHUTI)
37 RA double degree   [degree] Target position at DATE-REF
38 DEC double degree   [degree] Target position at DATE-REF
39 ROLL double degree   [degree] Roll angle at DATE-REF
40 AA_SOL double degree   [degree] Solar avoidance angle at DATE-REF
41 AA_EAR double degree   [degree] Earth avoidance angle at DATE-REF
42 AA_LUN double degree   [degree] Lunar avoidance angle at DATE-REF
43 TM_SAA double sec   [sec] Duration since last SAA at DATE-REF
44 SAT_POSX double km   [km] Satellite position at DATE-REF
45 SAT_POSY double km   [km] Satellite position at DATE-REF
46 SAT_POSZ double km   [km] Satellite position at DATE-REF
47 DAYNIGHT varchar(7)     day/night status at DATE-REF
48 STTA_NUM int(11)     number of tracked stars in STT-A at DATE-REF
49 STTB_NUM int(11)     number of tracked stars in STT-B at DATE-REF
50 STTA_MOD varchar(7)     STT-A Mode status at DATE-REF
51 STTB_MOD varchar(7)     STT-B Mode status at DATE-REF


Back to top

Table Name: REMARKS
No. Column Name Type Unit Description
1 REMID int(11)     Remark ID
2 REMNAME varchar(31)     Remark Name
3 REMHREF varchar(255)     Reference
4 REMDESC text     Description


Back to top