-- ----------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2011 Brian Bruns and others.
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-- ----------------------------------------------------------

-- That file uses encoding UTF-8

CREATE TABLE [REFERENCES]
 (
	[REF_ID]			Integer, 
	[CITE_SHORT]			Text (510), 
	[CITE_Long]			Memo/Hyperlink (255), 
	[AUTHORS]			Text (510), 
	[YEAR]			Integer, 
	[TITLE]			Text (510), 
	[LINK_to_PDF]			Memo/Hyperlink (255), 
	[Scans_Reference_No]			Long Integer
);

CREATE TABLE [PROFILES_simple]
 (
	[ID]			Long Integer, 
	[LOCATION_ID]			Integer, 
	[HZN_SEQ_NO]			Integer, 
	[HORIZON]			Text (510), 
	[UPPER_HZN_LIMIT]			Single, 
	[HZN_THICKNESS]			Single, 
	[BULK_DENSITY]			Single, 
	[BD_MeasEst]			Text (40), 
	[BD_CFcorrected]			Boolean NOT NULL, 
	[Coarse_Fragments_Class]			Text (510), 
	[CF_VOLPCT]			Single, 
	[pH]			Single, 
	[pH_H2O_CACL2]			Text (20), 
	[CARBONATE_CARBON_PCT]			Single, 
	[ORG_CARBON_PCT]			Single, 
	[Carbon_Method]			Text (510), 
	[ORGC_DENSITY]			Single, 
	[Hzn_CF_Corr_Factor]			Single, 
	[Hzn_OrgMin]			Text (14), 
	[OrgHzn_OrgC]			Single, 
	[MinHzn_OrgC_notCFcorr]			Single, 
	[MinHzn_OrgC_withCFcorr]			Single
);

CREATE TABLE [SITES_simple]
 (
	[LOCATION_ID]			Integer, 
	[RELEASE_SOURCE]			Text (510), 
	[RELEASE_SOURCE_SITEID]			Text (510), 
	[REF_ID]			Long Integer, 
	[CSSC_CODE]			Text (510), 
	[ORDER]			Text (510), 
	[Great_Group]			Text (510), 
	[GGSG]			Text (510), 
	[SCMC]			Text (510), 
	[ORG_C_tha]			Single, 
	[MIN_C_tha]			Single, 
	[Total_C_tha]			Single, 
	[COARSE_FRAGMENTS]			Text (510), 
	[MINC_CF_diff]			Single, 
	[CACO3]			Boolean NOT NULL, 
	[Depth_to_Rx]			Long Integer, 
	[VEG_TYPE]			Text (510), 
	[CBM_FOREST_TYPE]			Text (510), 
	[LEAD_SPECIES]			Text (510), 
	[CBM_LEAD_SP]			Text (510), 
	[LEAD_SW]			Text (510), 
	[CBM_LEAD_SW]			Text (510), 
	[LEAD_HW]			Text (510), 
	[CBM_LEAD_HW]			Text (510), 
	[PROVINCE]			Text (510), 
	[ECOBOUND]			Text (510), 
	[RU]			Text (510), 
	[LATITUDE]			Single, 
	[LONGITUDE]			Single, 
	[Loc_accuracy]			Text (510), 
	[ELEVATION]			Single
);

CREATE TABLE [Ecoboun_lookup]
 (
	[ECOBOUN]			Text (510), 
	[ecoboundary_full_name]			Text (510)
);