--############################################################################## -- -- Auth: Paul Brown -- -- $Header: /usr/local/devel/montage/contrib/BigSur/Schema/RCS/bigsur_section2.msql,v 1.3 1994/12/05 22:39:31 pbrown Exp pbrown $ -- --##################################################################### -- -- Citation = -- 1{Originator}n + -- Publication_Date + -- (Publication_Time) + -- Title + -- 0{Edition}1 + -- 0{Geospatial_Data_Representation_Form}1 + -- 0{Seried_Information}1 + -- 0{Publication_Information}1 + -- 0{Other_Citation_Details}1 + -- (1{Online_Linkage}n) + -- 0{Larger_Work_Citation}1; -- -- -- Citation - FGDC Section 8 -- CREATE TABLE Citation OF NEW TYPE Citation_t ( Originator text NOT NULL, -- 8.1 Publication_DateTime timestamp, -- 8.2/ 8.3 Title text NOT NULL, -- 8.4 Edition text, -- 8.5 Geospatial_Data_Form text, -- 8.6 Series_Name text, -- 8.7.1 Issue_Identification text, -- 8.7.2 Publication_Place text, -- 8.8.1 Publisher text, -- 8.8.2 Other_Citation_Details text, -- 8.9 Online_Linkage text, -- 8.10 primary key (Originator, Title) ); -- -- BigSur does not have any X_Ref at this level. Cross references -- are maintained at the Identification_Information level. Such functionality -- may be added in application schemas, and if it proves popular we'll -- haul it back into the base. -- GRANT ALL ON Citation TO PUBLIC; GRANT USAGE ON TYPE Citation_t TO PUBLIC; --