--##############################################################################
--
--  Auth:  Paul Brown
--
--  $Header: /usr/local/devel/montage/contrib/BigSur/Schema/RCS/bigsur_section1.msql,v 1.4 1994/12/06 22:36:36 pbrown Exp pbrown $
--
--#####################################################################
--
--#####################################################################
--
--  Section 1. FGDC Spatial MetaData Transfer Standards.
--
--  Identification_Information =
--                               Citation +
--                               Description +
--                               Time_Period_of_Content +
--                               Status +
--                               Spatial_Domain +
--                               Keywords +
--                               Access_Constraints +
--                               Use_Constraints +
--                               (Point_of_Contact) +
--                               (1{Browse_Graphic}n) +
--                               (Data_Set_Credit) +
--                               (Security_Information) +
--                               (Native_Data_Set_Environment) +
--                               (1{Cross_Reference}n);
--
--   PB: Adding the Data_Set_Id stuff. Using ref() now, rather than
--       the surrogate id stuff.
--
--   Possible Enhancement: 1. Add a reference table for Status type attributes.
--
CREATE TABLE Identification_Information
OF NEW TYPE Identification_Information_t
(
   Data_Set_Id		   text       		NOT NULL PRIMARY KEY,
   Citation		   ref(Citation_t)	NOT NULL, -- 1.1
--
--  1.2 see inherited relation, Description.
--
   Beginning               timestamp , -- 1.3.1/2
   Ending                  timestamp,                    -- 1.3.3/4
   Status_Progress         text,                         -- 1.4.1
   Status_Update_Frequency text,                         -- 1.4.2
   Spatial_Domain          Poly,                         -- 1.5
--
--  1.6 is handled by the Keyword_Instances table etc.
--
   Access_Constraints      text,                         -- 1.7
   Use_Constraints         text,                         -- 1.8
   Contact_Information     ref(Contact_Information_t),   -- 1.9
--
-- 1.10 is handled by the Identification_Graphic table below
--
   Data_Set_Credit         text,                         -- 1.11
   Security_Code           text,                         -- 1.12 (Surr Key)
   Native_Data_Set_Environment text,                     -- 1.13
--
--  Lineage Information. There will be as many 
--
   Process_Date                  timestamp ,
   Process_Contact               text    ,
   Process			 ref(Process_t)  NOT NULL
) UNDER Description;                                    -- 1.2 etc
--
--  Keywords         - 1.6
--
CREATE TABLE Keyword_Instance
OF NEW TYPE Keyword_Instance_t
(
  Keyword 			text   ,
  Thesaurus_Code		text   ,
  Identification_Information	ref(Identification_Information_t) NOT NULL
);
--
--  Browse_Graphic   - 1.10
--
CREATE TABLE Identification_Graphic
OF NEW TYPE Identification_Graphic_t
(
  Identification_Information	ref(Identification_Information_t) NOT NULL
) UNDER Graphic;
--
--
--   MetaData - This is the table which will be inherited in the
--              various objects.
--
--              This corresponds to FGDC Section 0. These are the
--              only two relations mandatory at the top level.
--
CREATE TABLE MetaData
OF NEW TYPE MetaData_t
(
  Identification_Information	 ref(Identification_Information_t) NOT NULL,
  Metadata_Reference_Information ref(Metadata_Reference_Information_t) NOT NULL
);
--
--  BigSurAssoc - 1.14
--
--         This is the relation in which we perform cross references.
--
CREATE TABLE BigSurAssoc
OF NEW TYPE BigSurAssoc_t
(
   Set_MetaData			ref(MetaData_t) 	NOT NULL,
   Member_MetaData		ref(MetaData_t)		NOT NULL
) UNDER Description;
--
GRANT ALL ON Identification_Information TO PUBLIC;
GRANT USAGE ON TYPE Identification_Information_t TO PUBLIC;
GRANT ALL ON Keyword_Instance TO PUBLIC;
GRANT USAGE ON TYPE Keyword_Instance_t TO PUBLIC;
GRANT ALL ON Identification_Graphic TO PUBLIC;
GRANT USAGE ON TYPE Identification_Graphic_t TO PUBLIC;
GRANT ALL ON BigSurAssoc TO PUBLIC;
GRANT USAGE ON TYPE BigSurAssoc_t TO PUBLIC;
GRANT ALL ON MetaData TO PUBLIC;
GRANT USAGE ON TYPE MetaData_t TO PUBLIC;
--