2.7 Database Schema for Mask Fabrication

 

2.7.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.7.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.

 

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

2.7.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.