/*
-- crobjects.sql

-- version 1.0

-- SQL file to create the OBJECTS table

-- Programmed by Snehavadan Macwan

-- Table 		OBJECTS

-- Number of Columns:	2

-- Primary Key:		OBJECT

-- Last Update:		4 APRIL	1996, VERSION 1.0

-- Description:

The OBJECTS table constains a list of the different solar objects 
which might be observed by the SOHO spacecraft.
*/
CREATE TABLE objects
(
-- Table Constraints Follow 
-- Column Definitions Follow
object		VARCHAR2 (3)		-- three letter object code	
	CONSTRAINT nn_object_ob		NOT NULL
	CONSTRAINT pk_object_ob		PRIMARY KEY,
obj_desc	VARCHAR2 (30)	-- expanded out name of object
	CONSTRAINT nn_obj_desc_ob	NOT NULL
) ;

-- -----------------------------------------------------------------------------
-- Add values to into OBJECTS table.
-- -----------------------------------------------------------------------------

INSERT INTO objects VALUES ('ARC',	'Arcade') ;
INSERT INTO objects VALUES ('AFS',	'Arch Filament System') ;
INSERT INTO objects VALUES ('ANE',	'Anemone') ;
INSERT INTO objects VALUES ('AR',	'Active Region') ;
INSERT INTO objects VALUES ('BP',	'Bright Point') ;
INSERT INTO objects VALUES ('CR',	'Coronal Rain') ;
INSERT INTO objects VALUES ('CH',	'Coronal Hole') ;
INSERT INTO objects VALUES ('COM',	'Comet') ;
INSERT INTO objects VALUES ('COR',	'Coronal') ;
INSERT INTO objects VALUES ('CHR',	'Chromosphere') ;
INSERT INTO objects VALUES ('CS',	'Coronal streamer') ;
INSERT INTO objects VALUES ('CT',	'Coronal Transient') ;
INSERT INTO objects VALUES ('CUS',	'Cusp') ;
INSERT INTO objects VALUES ('DB',	'Disparation Brusque') ;
INSERT INTO objects VALUES ('DC',	'Disk Center') ;
INSERT INTO objects VALUES ('DFL',	'Disappearing Filament') ;
INSERT INTO objects VALUES ('DFX',	'Disappearing Flux') ;
INSERT INTO objects VALUES ('DF',	'Downflow') ;
INSERT INTO objects VALUES ('EFL',	'Emerging Flux') ;
INSERT INTO objects VALUES ('EPR',	'Eruptive Prominence') ;
INSERT INTO objects VALUES ('EFI',	'Erupting Filament') ;
INSERT INTO objects VALUES ('EVF',	'Evershed Flow') ;
INSERT INTO objects VALUES ('FAC',	'Faculae') ;
INSERT INTO objects VALUES ('FC',	'Filament Channel') ;
INSERT INTO objects VALUES ('FLC',	'Flux Cancellation') ;
INSERT INTO objects VALUES ('FLG',	'Filigree') ;
INSERT INTO objects VALUES ('FIL',	'Filament') ;
INSERT INTO objects VALUES ('FLR',	'Flare') ;
INSERT INTO objects VALUES ('FP',	'Footpoint') ;
INSERT INTO objects VALUES ('FS',	'Full Sun') ;
INSERT INTO objects VALUES ('FL',	'Flow') ;
INSERT INTO objects VALUES ('GR',	'Granulation') ;
INSERT INTO objects VALUES ('HR',	'Hedge Row') ;
INSERT INTO objects VALUES ('JET',	'Jet') ;
INSERT INTO objects VALUES ('LB',	'Loop Brightening') ;
INSERT INTO objects VALUES ('LE',	'Loop Evacuation') ;
INSERT INTO objects VALUES ('LMB',	'Solar Limb') ;
INSERT INTO objects VALUES ('LO',	'Loop') ;
INSERT INTO objects VALUES ('CME',	'Coronal Mass Ejection') ;
INSERT INTO objects VALUES ('MS',	'Magnetic Shear') ;
INSERT INTO objects VALUES ('MT',	'Mercury Transition') ;
INSERT INTO objects VALUES ('MW',	'Moreton Wave') ;
INSERT INTO objects VALUES ('NET',	'Network') ;
INSERT INTO objects VALUES ('NL',	'Neutral Line') ;
INSERT INTO objects VALUES ('PC',	'Polar Crown') ;
INSERT INTO objects VALUES ('PCH',	'Polar Coronal Hole') ;
INSERT INTO objects VALUES ('PEN',	'Sunspot Penumbra') ;
INSERT INTO objects VALUES ('PFL',	'Postflare Loops') ;
INSERT INTO objects VALUES ('PHO',	'Photosphere') ;
INSERT INTO objects VALUES ('PLG',	'Plage') ;
INSERT INTO objects VALUES ('POR',	'Pore') ;
INSERT INTO objects VALUES ('PP',	'Polar Plume') ;
INSERT INTO objects VALUES ('PR',	'Prominence') ;
INSERT INTO objects VALUES ('PLT',	'Planet') ;
INSERT INTO objects VALUES ('QS',	'Quiet Sun') ;
INSERT INTO objects VALUES ('RIB',	'Two-Ribbon Flare') ;
INSERT INTO objects VALUES ('SPR',	'Spray') ;
INSERT INTO objects VALUES ('SG',	'Supergranulation') ;
INSERT INTO objects VALUES ('SPI',	'Spicule') ;
INSERT INTO objects VALUES ('SR',	'Surge') ;
INSERT INTO objects VALUES ('SS',	'Sunspot') ;
INSERT INTO objects VALUES ('ST',	'Star') ;
INSERT INTO objects VALUES ('SW',	'Solar Wind') ;
INSERT INTO objects VALUES ('SYN',	'Synoptic Observation') ;
INSERT INTO objects VALUES ('TR',	'Transition Region') ;
INSERT INTO objects VALUES ('UF',	'Upflow') ;
INSERT INTO objects VALUES ('UMB',	'Sunspot Umbra') ;
INSERT INTO objects VALUES ('VT',	'Venus Transition') ;
INSERT INTO objects VALUES ('WAV',	'Wave') ;
INSERT INTO objects VALUES ('WLF',	'White Light Flare') ;

