2.4 Database Schema for Glass

 

2.4.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.4.2 Regular Memes

 

Filters (DEIMOS.glass) table table (EXTNAME = 'Filters')

Table of Filters Filters consists of elements:

 

filtid (DEIMOS.glass) int I5 %d [recid] (0.0 to 999999.0)

Unique numeric ID of a record in the Filters table, hence unique ID of a filter  

FilName (DEIMOS.glass) varchar(20) A20 %s

Human-readable name of a filter  

FilType (DEIMOS.glass) char(2) A2 %s

Type of filter Valid values of FilType are:

• LP : long pass (blue block)
• SP : short pass (red block)
• W : wide band
• N : narrow band
• M : medium band

 

Xdim (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

x dimension of an optic. For non-rectangular optics this is a characteristic value.  

Ydim (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

y dimension of an optic. For non-rectangular optics this is a characteristic value.  

Zdim (DEIMOS.glass) real F8.6 %.6f [m] (0.0 to 9.0)

z dimension (thickness) of an optic  

OffsetX (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

x offset of filter from optical axis  

OffsetY (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

y offset of filter from optical axis  

CoatingI (DEIMOS.glass) varchar(20) A20 %s

Coating on the incident side of a filter. Possibly an index into a table of coating types and characteristics  

CoatingE (DEIMOS.glass) varchar(20) A20 %s

Coating on the emergent face of a filter. Possibly an index into a table of coating types and characteristics.  

ScanURI (DEIMOS.glass) varchar(255) A %s

URI of a FITS file containing efficiency curve(s) for an optic. Transmission for filters, reflection for mirrors, efficiency for gratings, etc. Different orders and polarizations will all be in the same file, in different HDUs or table columns.  

CWave (DEIMOS.glass) real F13.11 %.11f [m] (0.0 to 1.0)

Characteristic wavelength for the filter. The middle of the band for pass and stop filters, and the location of the cutoff for blocking filters.  

FWHM (DEIMOS.glass) real F13.11 %.11f [m] (0.0 to 1.0)

Full Width at Half Max for bandpass filters.  

ZeroPoint (DEIMOS.glass) real E6.3 %.3E

A photometric zero point used in the conversion from DN through this filter to a standard magnitude system.  

ZeroURI (DEIMOS.glass) varchar(255) A %s

URI of a reference containing description of the calibrations used to calculate ZeroRef.  

FocalShift (DEIMOS.glass) real F10.7 %.7f [m]

A canonical value for the amount of camera refocus required when this filter is inserted.  

RcvDate (DEIMOS.glass) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

Date filter was received and stocked at observatory  

OwnerId (DEIMOS.glass) int I11

Unique ID of the observer who obtained the filter. Is an instance of pid:

pid (DataBase) int I11 %d

Unique ID of a Person or Vendor  

VendorId (DEIMOS.rdb) int I11

Unique ID of Vendor who supplied the item. Is an instance of pid:

pid (DataBase) int I11 %d

Unique ID of a Person or Vendor  

nid (DataBase) int I11 %d

Unique ID of a PostIt Note.  

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

 

Gratings (DEIMOS.glass) table table (EXTNAME = 'Gratings')

RDB table of grating characteristics. Mirrors which sit in the same position as gratings are included here. Gratings consists of elements:

 

gratid (DEIMOS.glass) int I11 %d

Unique Id of a grating  

GratingName (DEIMOS.glass) varchar(20) A20 %s

Name of a grating.  

GroovDens (DEIMOS.glass) float F8.0 %.0f [1/m]

Density of grooves on a grating. A mirror has a groove density of zero.  

BlazeAng (DEIMOS.glass) real F7.4 %.4f [deg] (0.0 to 90.0)

Blaze angle of a grating.  

RefCoat (DEIMOS.glass) varchar(20) A20 %s

Reflective coating on the surface of an optic. Possibly an index into a table of coating types and characteristics.  

TransCoat (DEIMOS.glass) varchar(20) A20 %s

Transmissive coating on the surface of an optic. Possibly an index into a table of coating types and characteristics.  

ScanURI (DEIMOS.glass) varchar(255) A %s

URI of a FITS file containing efficiency curve(s) for an optic. Transmission for filters, reflection for mirrors, efficiency for gratings, etc. Different orders and polarizations will all be in the same file, in different HDUs or table columns.  

XdimR (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

x dimension of the ruled portion of a grating.  

YdimR (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

y dimension of the ruled portion of a grating.  

Xdim (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

x dimension of an optic. For non-rectangular optics this is a characteristic value.  

Ydim (DEIMOS.glass) real F9.6 %.6f [m] (0.0 to 99.0)

y dimension of an optic. For non-rectangular optics this is a characteristic value.  

Zdim (DEIMOS.glass) real F8.6 %.6f [m] (0.0 to 9.0)

z dimension (thickness) of an optic  

VendorId (DEIMOS.rdb) int I11

Unique ID of Vendor who supplied the item. Is an instance of pid:

pid (DataBase) int I11 %d

Unique ID of a Person or Vendor  

VendorPart (DEIMOS.glass) varchar(20) A20 %s

Vendor part number for the item.  

RcvDate (DEIMOS.glass) smalldatetime A19 %04d-%02d-%02dT%02d:%02d:%02d

Date filter was received and stocked at observatory  

nid (DataBase) int I11 %d

Unique ID of a PostIt Note.  

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

 

Layers (DEIMOS.glass) table table (EXTNAME = 'Layers')

Table of Layers in filters Layers consists of elements:

 

layid (DEIMOS.glass) int I11 %d (0.0 to 999999.0)

Unique numeric ID of a layer in a filter  

filtid (DEIMOS.glass) int I5 %d [recid] (0.0 to 999999.0)

Unique numeric ID of a record in the Filters table, hence unique ID of a filter  

LayNum (DEIMOS.glass) smallint I5 %d (0.0 to 100.0)

Number of layer in filter  

GlassType (DEIMOS.glass) varchar(20) A %s

Short code for a type of filter glass, possibly an index into a table of longer descriptions of filter glass types and characteristics  

Thickness (DEIMOS.glass) real F8.6 %.6f [m] (0.0 to 10.0)

spatial thickness of the filter (layer)  

nid (DataBase) int I11 %d

Unique ID of a PostIt Note.  

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

 

Mirrors (DEIMOS.glass) table table (EXTNAME = 'Mirrors')

RDB table of mirror characteristics. This does not include mirrors which sit in the same place as gratings. Mirrors consists of elements:

 

mirid (DEIMOS.glass) int I11 %d

Unique Id of a mirror  

MirName (DEIMOS.glass) varchar(20) A20 %s

Name of a mirror.  

RefCoat (DEIMOS.glass) varchar(20) A20 %s

Reflective coating on the surface of an optic. Possibly an index into a table of coating types and characteristics.  

TransCoat (DEIMOS.glass) varchar(20) A20 %s

Transmissive coating on the surface of an optic. Possibly an index into a table of coating types and characteristics.  

nid (DataBase) int I11 %d

Unique ID of a PostIt Note.  

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

 

ISOdateFmt (MapTypes) map A19

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