Structure of the Database

1. DEEPSKY 2000 Object Database
Deepsky 2000 supports two object databases.  DeepPro13000.mdb contains 13,000 deepsky objects from the NGC, Messier, and IC catalogs.  DeepPro400000.mdb contains over 400,000 deepsky objects from many different catalogs.   Both databases reside in Access 2000 format and can be directly accessed using Access 2000.  Both databases contain the same structure (ie. fields).  A separate table called CatalogLookup is included in the database for identifying which catalogs are available.

Table Name: deepskytable - Stores data on Deepsky Objects

Field Name            Data Type              Description
ID                             AutoNumber            Unique Identifier
ObjectID		Text		NGC or IC Object	
OtherID		Texr		Other name 	
ObjectType	Text		Type of Object
RAhours		Number		Right Ascension hours
RAminutes	Number		Right Ascension minutes
DeclinationDegrees	Number		Declination Degrees
DeclinationMinutes	Number 		Declination Minutes
Epoch		Number 		Epoch for coordinates
GalacticLongitude	Number		Galactic Longitude
GalacticLatitude	Number	 	Galactic Latitude
Constellation	Text		Constellation
ObjectSize	Number		Size of Object in arc minutes
Magnitude1	Number		Magnitude of primary 
Magnitude2	Number		Magnitude of secondary
MCode		Text		Magnitude Code
PositionAngle	Text		Position Angle if binary star
Separation	Number		Separation if binary star
Description	Text		Description
Catalog		Text     		Source Catalog Name
ImageFile		Text		Location of Image on your system
MessierNumber	Number		Messier Number
Observed		Yes/No		You have observed this object
Hobject  		Text		Herschel Designation
DeepskySup            Yes/No                   Deepsky 2000 supplied object

The DeepskyTable is the main Deepsky Database containing either 413,000 or 13,000 deepsky objects.  When you use the SQL command line you should reference the table name as DeepskyTable and the fields as listed above.  Make sure you key the information exactly as shown since SQL is case sensitive.  The ID field is an internal record number that the database uses.  Here are some SQL examples using the above table.

Select * From DeepskyTable Where Magnitude < 8.5 Order By Constellation, Magnitude
Select * From DeepskyTable Where Constellation = "Ori" or Constellation = "Tau" Order By ObjectSize

Table Name: CatalogLookup - Stores Catalog Information

Field Name            Data Type              Description
ID                           AutoNumber            Unique Identifier
CatalogName	Text		Name of the catalog
CatalogDescription   Text		Descriptive catalog name
URLADC		Text		Website from ADC for catalog

2. DEEPSKY 2000 Observer's Logbook
Deepsky 2000's logbook is kept in the Access 2000 database called Logbook2000.mdb.  The Logbook database contain other tables as well that are used in Deepsky 2000.  Some tables store the image references while others contain CCD log information.  The Logbook table is where you store your general observing information.  The ObservationNumber field is a unique identifier that is used internally by Deepsky 2000 to link tables together.

Table Name: Logbook  - Primary Logbook

Field Name               	 Data Type              Description
ObservationNumber    	AutoNumber            Unique Identifier
ObjectID		   	Text	            	Object ID that links to the object database
Catalog			Text		Source Catalog Name
DateObserved		Date/Time		Observation Date
TimeObserved		Date/Time		Observation Time
LocationObserved		Text		Location of the observation
Transparency		Text		Transparency conditions
Seeing			Text		Seeing conditions
EquipmentUsed		Text		Primary Equipment (ie. Scope)
OtherEquipment		Memo		Additional Equipment
Rating			Text		How good the object looked 
ShortDescription		Text		Short description of observation
ObservationText		Memo		Text of Observation
DataRec			Number 		Unique ID
LogType			Text		Type of Logbook

An SQL example to retrieve data from this table might look like :
  Select * From Logbook Order By DateObserved
  Select * From Logbook Where DateObserved > 01/01/1998

Table Name: CCDLog - Stores CCD Logbook Information

Field Name               	 Data Type              Description
ID		    	AutoNumber            Unique Identifer
ObservationNumber		Number		ID to link to Logbook table
ImageName		Text		Image Name
ExposureTime		Text		Length of exposure
ExposureMode		Text		Exposure Mode
Telescope			Text		Telescope used
CCDcamera		Text		Camera name
FocalDistance		Text		Focal Distance
FieldOfView		Text		Field of View
CoolingRate		Text		Cooling Rate
Dark Frame		Yes/No		Dark Frame
FlatField			Yes/No		Flat Field
Picture Rating		Text		Picture Rating
Notes			Memo		Notes

Table Name: ImageLog - Stores Image Path Locations

Field Name               	 Data Type              Description
Sequence	    		AutoNumber            Unique Identifer
ObservationNumber		Number		ID to link to Logbook table
ImageDescription		Text		Description of the image
ImagePath		Text		Location on Hard drive

Table Name: SessionLog - Stores General Session Notes

Field Name               	 Data Type              Description
ID		    	AutoNumber            Unique Identifer
SessionDate		Date/Time	Date of the observing session
SessionText		Memo		Notes of the session

Table Name: UserCatalog - Stores Other Amateur Log Notes

Field Name               	 Data Type              Description
ID		    	AutoNumber            Unique Identifer
ObjectID			Text		Object Observed
Notes			Memo		Observing Notes
Author			Text		Author who made notes