next up previous index
Next: 2.5 Database Schema for Up: 2 DEIMOS Database Schema Previous: 2.3 Database Schema for

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.


next up previous index
Next: 2.5 Database Schema for Up: 2 DEIMOS Database Schema Previous: 2.3 Database Schema for

DEIMOS Software Team <deimos@ucolick.org>
1997-06-14T06:59:55 UTC