2.6 Database Schema for Mask Design

 

2.6.1 Legend

 

MemeName (Context) RW Sybase_Type F77_fmt C_fmt [Units]

The attributes displayed here if available are: the Meme name, context, access (read/write/both), datatype, FORTRAN format, C format, and the value's units and legitimate range (if any). A table may also have a FITS EXTNAME. This text is the Semantics.

2.6.2 Regular Memes

 

BluSlits (DEIMOS.mask) table table (EXTNAME = 'BluSlits')

Defines the RDB and FITS tables containing characteristics of slitlets in a mask blueprint. BluSlits consists of elements:

 

bSlitPK (DEIMOS.mask) int I6 %d

The primary key into the table of slitlets in a mask blueprint. This will be converted into a bSlitId upon data ingest.  

BluId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask blueprint.  

dSlitPK (DEIMOS.mask) int I6 %d

The primary key into the table of slitlets in a mask design. This will be converted into a dSlitId upon data ingest.  

slitX1 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint X coordinate of perimeter point 1.  

slitY1 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint Y coordinate of perimeter point 1.  

slitX2 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint X coordinate of perimeter point 2.  

slitY2 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint Y coordinate of perimeter point 2.  

slitX3 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint X coordinate of perimeter point 3.  

slitY3 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint Y coordinate of perimeter point 3.  

slitX4 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint X coordinate of perimeter point 4.  

slitY4 (DEIMOS.mask) float F9.6 %.6f [m]

The slitmask blueprint Y coordinate of perimeter point 4.

 

DesiSlits (DEIMOS.mask) table table (EXTNAME = 'DesiSlits')

Defines the RDB and FITS tables containing the lists of slitlets in mask designs. DesiSlits consists of elements:

 

dSlitPK (DEIMOS.mask) int I6 %d

The primary key into the table of slitlets in a mask design. This will be converted into a dSlitId upon data ingest.  

DesId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask design.  

slitRA (DEIMOS.mask) float F12.7 %.7f [deg] (-180.0 to 360.0)

Right Ascension of the center of the slitlet.  

slitDec (DEIMOS.mask) float F11.7 %.7f [deg] (-90.0 to 90.0)

Declination of the center of the slitlet.  

slitTyp (DEIMOS.mask) char(1) A1 %s

The type of the slitlet in a mask design (or FITS blueprint). Valid values of slitTyp are:

• P : parallelogram
• E : ellipse (circle)
• A : Alignment box (parallelogram)
• S : Scratch (parallelogram)
• G : Guide (ghost)

 

slitLen (DEIMOS.mask) real F11.3 %.3f [arcsec]

Projected length of a slitlet on the sky.  

slitLPA (DEIMOS.mask) real F8.3 %.3f [deg] (-180.0 to 360.0)

Projected position angle of the length direction of a slitlet on the sky.  

slitWid (DEIMOS.mask) real F11.3 %.3f [arcsec]

Projected width of a slitlet on the sky.  

slitWPA (DEIMOS.mask) real F8.3 %.3f [deg] (-180.0 to 360.0)

Projected position angle of the width direction of a slitlet on the sky.

 

ExtendObj (DEIMOS.mask) table table (EXTNAME = 'ExtendObj')

Defines the RDB table containing the lists of extended objects. ExtendObj consists of elements:

 

ObjPKey (CATALOG) int I6 %d

A unique key value assigned to each object in the catalog table. In the context of a FITS HDU this has no permanent significance, but serves to permit cross indexing from other tables.  

MajAxPA (CATALOG) real F7.3 %.3f [deg] (-180.0 to 360.0)

Position angle of Major axis of an extended object in the RA/Dec system measured from North towards East.  

MinAxis (CATALOG) real F11.3 %.3f [arcsec] (0.0 to 648000.0)

Length of minor axis of an extended object.

 

MaskBlu (DEIMOS.mask) table table (EXTNAME = 'MaskBlu')

Defines the RDB table containing characteristics of a mask blueprint. MaskBlu consists of elements:

 

BluId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask blueprint.  

DesId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask design.  

BluPId (DEIMOS.mask) int I11

Unique ID of a Person or Vendor who creates a slitmask blueprint. This will designate the 'owner' of a milled slitmask. Is an instance of pid:

pid (DataBase) int I11 %d

Unique ID of a Person or Vendor  

BluName (DEIMOS.mask) varchar(68) A %s

Observer's pet name for a slitmask blueprint. This will be visible in the GUI which permits selection of the active slitmask. Typically it will be a design name with an added date.  

BluAgent (DEIMOS.mask) int I11

Unique ID of the agent used to convert a slitmask design into a slitmask blueprint. This will be inferred from the FITS meme BluTool. Is an instance of agentid:

agentid (DataBase) int I11 %d

Unique Agent ID number  

BluDate (DEIMOS.mask) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

The FITS DATE of creation of the mask blueprint HDU. It shall be expressed using the new Y2K FITS date format.  

LST_Use (DEIMOS.mask) real F7.3 %.3f [deg]

The Local Sidereal Time of the intended use of the slitmask.  

DateUse (DEIMOS.mask) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

The UT date(/time)of the intended use of the slitmask. It shall be expressed using the new Y2K FITS date format.  

TeleId (DEIMOS.mask) int I11 %d

Unique ID of a telescope.  

RefrId (DEIMOS.mask) int I11 %d

Unique ID of an algorithm for atmospheric refraction.  

AtmTempC (ATMOSPHERE) real F5.1 %.1f [degC] (-100.0 to 50.0)

The ambient atmospheric temperature at the telescope in Celsius.  

AtmPres (ATMOSPHERE) real F5.1 %.1f [mbar] (0.0 to 1100.0)

The atmospheric pressure at the telescope. This should be the actual pressure, not the pressure reduced to sea level.  

AtmHumid (ATMOSPHERE) real F5.3 %.3f (0.0 to 1.2000000000000002)

The ambient relative humidity at the telescope (as a fraction).  

AtmTTLap (ATMOSPHERE) real F7.5 %.5f [K/m]

The adiabatic temperature lapse rate in the troposphere above the observatory.  

RefWave (REFRACTION) real F12.10 %.10f [m] (0.0 to 1000.0)

The atmospheric refraction model is applied for a specific observation wavelength. The value should be within, and p ossibly towards the blue end of, the desired spectral bandpass.  

DistId (DEIMOS.mask) int I11 %d

Unique ID of an algorithm for image distortion at the DEIMOS slitmask.

 

MaskDesign (DEIMOS.mask) table table (EXTNAME = 'MaskDesign')

Defines the RDB table containing the lists of mask designs. MaskDesign consists of elements:

 

DesId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask design.  

DesPId (DEIMOS.mask) int I11

Unique ID of a Person or Vendor who creates a slitmask design. This may differ from the subsequent blueprint creator who will own the slitmask. Is an instance of pid:

pid (DataBase) int I11 %d

Unique ID of a Person or Vendor  

DesName (DEIMOS.mask) varchar(68) A %s

Observer's pet name for a slitmask design. This will typically have a date appended to it when the slitmask blueprint is created from the slitmask design.  

DesAgent (DEIMOS.mask) int I11

Unique ID of the agent used to create a slitmask design. This will be inferred from the FITS meme DesTool. Is an instance of agentid:

agentid (DataBase) int I11 %d

Unique Agent ID number  

DesDate (DEIMOS.mask) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

The FITS DATE of creation of the mask design HDU. It shall be expressed using the new Y2K FITS date format.  

CatAuth (DEIMOS.mask) varchar(68) A %s

FITS AUTHOR of a catalog.  

CatName (DEIMOS.mask) varchar(68) A %s

Observer's pet name for a catalog.  

CatDate (DEIMOS.mask) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

Date of construction of FITS HDU containing a catalog.  

RA_PNT (HFWG_R3) float F12.7 %.7f [deg] (-180.0 to 360.0)

Right Ascension of the telescope pointing axis.  

DEC_PNT (HFWG_R3) float F11.7 %.7f [deg] (-90.0 to 90.0)

Declination of the telescope pointing axis.  

RADECPNT (SLA) char(8) A8

The RADECSYS in which the telescope pointing coordinates are expressed. Is an instance of RADECSYS:

• FK4
• FK5
• GAPPT
• FK4-NO-E

RADECSYS (WCS95) char(8) A8 %s

Specifies the frame of reference of the equatorial coordinates; default = 'FK4' for EQUINOX 1950.0 and 'FK5' for 2000.0. Other values are 'GAPPT' and 'FK4-NO-E'. Valid values of RADECSYS are:

• GAPPT : Geocentric Apparent
• FK4 : 4th Fundamental Catalog
• FK5 : 5th Fundamental Catalog
• FK4-NO-E : without E-terms

 

PA_PNT (DEIMOS.mask) float F12.7 %.7f [deg] (-180.0 to 360.0)

The position angle of the DEIMOS mask on the sky.  

EQUINPNT (SLA) real F13.6 %.6f [annum] (1855.0 to 2100.0)

The EQUINOX in which the telescope pointing axis coordinates are expressed.  

MJD_PNT (SLA) float F17.9 %.9f [diem] (0.0 to 100000.0)

The MJD_WCS applying to the reference frame in which the telescope pointing axis coordinates are expressed.  

LST_Des (DEIMOS.mask) real F7.3 %.3f [deg]

The anticipated Local Sidereal Time used during the design of the slitmask.  

DateDes (DEIMOS.mask) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

The anticipated UT date(/time) of the observation which was used during the design of the slitmask. It shall be expressed using the new Y2K FITS date format.  

uid (DataBase) smallint I5 %d

(Sybase) ID code of database Key Entry person. This tells us who entered the record in the table. The stamp field tells us when.  

stamp (DataBase) smalldatetime A20 %s

date on which record was entered (or updated) in database

 

NearObj (DEIMOS.mask) table table (EXTNAME = 'NearObj')

Defines the RDB table containing the lists of nearby objects. NearObj consists of elements:

 

ObjPKey (CATALOG) int I6 %d

A unique key value assigned to each object in the catalog table. In the context of a FITS HDU this has no permanent significance, but serves to permit cross indexing from other tables.  

PM_RA (CATALOG) real F9.4 %.4f [arcsec/annum]

Proper motion of an object in right ascension. The annum is Besselian if RADECSYS is FK4 and Julian if RADECSYS is FK5.  

PM_Dec (CATALOG) real F9.4 %.4f [arcsec/annum]

Proper motion of an object in declination. The annum is Besselian if RADECSYS is FK4 and Julian if RADECSYS is FK5.  

Parallax (CATALOG) real F7.4 %.4f [arcsec] (0.0 to 10.0)

(Trigonometric) Parallax of an object

 

Objects (DEIMOS.mask) table table (EXTNAME = 'Objects')

Defines the RDB table containing the lists of objects used in slitlets. (Compare with FITS table ObjectCat.) Objects consists of elements:

 

ObjPKey (CATALOG) int I6 %d

A unique key value assigned to each object in the catalog table. In the context of a FITS HDU this has no permanent significance, but serves to permit cross indexing from other tables.  

DesId (DEIMOS.mask) int I11 %d

Unique ID of a slitmask design.  

OBJECT (NOST1) rw varchar(68) A %s

The value field shall contain a character string giving the name of the object observed.  

RA_OBJ (HFWG_R3) float F12.7 %.7f [deg] (-180.0 to 360.0)

Right Ascension of an object.  

DEC_OBJ (HFWG_R3) float F11.7 %.7f [deg] (-90.0 to 90.0)

Declination of an object.  

RADECSYS (WCS95) char(8) A8 %s

Specifies the frame of reference of the equatorial coordinates; default = 'FK4' for EQUINOX 1950.0 and 'FK5' for 2000.0. Other values are 'GAPPT' and 'FK4-NO-E'. Valid values of RADECSYS are:

• GAPPT : Geocentric Apparent
• FK4 : 4th Fundamental Catalog
• FK5 : 5th Fundamental Catalog
• FK4-NO-E : without E-terms

 

EQUINOX (NOST1) float F13.6 %.6f [annum] (1500.0 to 3000.0)

The value field shall contain a floating point number giving the equinox in years for the celestial coordinate system in which positions given in either the header or data are expressed.  

MJD-OBS (WCS95) float F17.9 %.9f [diem] (0.0 to 100000.0)

The Modified Julian Date of the time of the observation measured in TAI. Note that this specification of the WCS draft precludes encoding of images obtained prior to the year 1955.  

mag (CATALOG) real F7.3 %.3f (-99.0 to 99.0)

Magnitude of an object.  

pBand (DEIMOS.mask) char(6) A6 %s

photometric passband used to measure mag.  

RadVel (CATALOG) float F14.3 %.3f [m/s] (-299792458.0 to 299792458.0)

Radial Velocity of an object.  

MajAxis (CATALOG) real F11.3 %.3f [arcsec] (0.0 to 648000.0)

Length of major axis of an extended object.

 

SlitObjMap (DEIMOS.mask) table table (EXTNAME = 'SlitObjMap')

Defines the RDB and FITS tables containing the map of objects which fall into each slitlet. SlitObjMap consists of elements:

 

dSlitPK (DEIMOS.mask) int I6 %d

The primary key into the table of slitlets in a mask design. This will be converted into a dSlitId upon data ingest.  

ObjPKey (CATALOG) int I6 %d

A unique key value assigned to each object in the catalog table. In the context of a FITS HDU this has no permanent significance, but serves to permit cross indexing from other tables.

2.6.3 Map Definitions

 

ForeignKey (MapTypes) map map

A map meme which indicates that its meme can be used as a foreign key into another table. The foreign occurrence of the meme is indicated by the isa_mid.

 

Identity (MapTypes) map map

A map meme which indicates that its meme has all the characteristics (min, max, legal values, ...) of another meme. In actuality this is probably an abuse of our current understanding of memes schema.

 

ISOdateFmt (MapTypes) map A19

This is a format for an ISO date/time string to the precision of seconds.