--############################################################################## -- -- Auth: Paul Brown -- -- -- $Header: /usr/local/devel/montage/contrib/BigSur/Schema/RCS/bigsur_cellstruct.msql,v 1.1 1994/12/05 22:39:23 pbrown Exp pbrown $ -- --##################################################################### -- --##################################################################### -- -- CellValues = -- -- name + Name by convention. (Barometric Air Pressure) -- -- units + Units of measure for the content. ( Millabars ) -- -- instanceType + size of the thing. (float4, float8) -- -- elementsPerValue + number of instancePrimitives (1 in most cases) -- -- NOTE: This structure copes with several different structures for -- file lay-outs. -- CREATE TABLE CellValue OF NEW TYPE CellValue_t ( name text, units text, instanceType text, elementsPerValue integer ) UNDER Description; -- -- CellVector - This is the abstract of the values present -- at every Cell in the Grid. This combines -- with Grid and BigSurObject to define what's in -- a 'data granule'. -- CREATE TABLE CellVector OF NEW TYPE CellVector_t UNDER Description; -- -- CellResolution - Resolution table to associate CellValues into -- Vectors. -- -- CellVector - This is the description of the vector of -- values at each cell in the file. -- -- CellValue - A component of the CellVector. -- -- seqNum - Sequence of the content within the -- CellResolution. -- -- CREATE TABLE CellResolution OF NEW TYPE CellResolution_t ( CellVector ref(CellVector_t) NOT NULL, CellValue ref(CellValue_t) NOT NULL, seqNum integer ); -- -- GRANT ALL ON CellValue TO PUBLIC; GRANT USAGE ON TYPE CellValue_t TO PUBLIC; GRANT ALL ON CellVector TO PUBLIC; GRANT USAGE ON TYPE CellVector_t TO PUBLIC; GRANT ALL ON CellResolution TO PUBLIC; GRANT USAGE ON CellResolution_t TO PUBLIC; --