mob_odm2.odm2 contains 765 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
actions	actiondescription	varchar	5000	√		null
actions	actionfilelink	varchar	255	√		null
affiliations	affiliationenddate	date	13	√		null
dataloggerfilecolumns	aggregationstatisticcv	varchar	255	√		null
annotations	annotationcode	varchar	50	√		null
annotations	annotationdatetime	timestamp	29,6	√		null
annotations	annotationlink	varchar	255	√		null
annotations	annotationutcoffset	int4	10	√		null
annotations	annotatorid	int4	10	√		null
specimenbatchpostions	batchpositionlabel	varchar	255	√		null
calibrationactions	calibrationcheckvalue	float8	17,17	√		null
calibrationactions	calibrationequation	varchar	255	√		null
cv_actiontype	category	varchar	255	√		null
cv_aggregationstatistic	category	varchar	255	√		null
cv_annotationtype	category	varchar	255	√		null
cv_censorcode	category	varchar	255	√		null
cv_dataqualitytype	category	varchar	255	√		null
cv_datasettype	category	varchar	255	√		null
cv_directivetype	category	varchar	255	√		null
cv_elevationdatum	category	varchar	255	√		null
cv_equipmenttype	category	varchar	255	√		null
cv_medium	category	varchar	255	√		null
cv_methodtype	category	varchar	255	√		null
cv_organizationtype	category	varchar	255	√		null
cv_propertydatatype	category	varchar	255	√		null
cv_qualitycode	category	varchar	255	√		null
cv_relationshiptype	category	varchar	255	√		null
cv_resulttype	category	varchar	255	√		null
cv_samplingfeaturegeotype	category	varchar	255	√		null
cv_samplingfeaturetype	category	varchar	255	√		null
cv_sitetype	category	varchar	255	√		null
cv_spatialoffsettype	category	varchar	255	√		null
cv_speciation	category	varchar	255	√		null
cv_specimentype	category	varchar	255	√		null
cv_status	category	varchar	255	√		null
cv_taxonomicclassifiertype	category	varchar	255	√		null
cv_unitstype	category	varchar	255	√		null
cv_variablename	category	varchar	255	√		null
cv_variabletype	category	varchar	255	√		null
citationexternalidentifiers	citationexternalidentifieruri	varchar	255	√		null
annotations	citationid	int4	10	√		null
referencematerialvalues	citationid	int4	10	√		null
specimentaxonomicclassifiers	citationid	int4	10	√		null
citations	citationlink	varchar	255	√		null
dataloggerfilecolumns	columndescription	varchar	5000	√		null
dataloggerfiles	dataloggerfiledescription	varchar	5000	√		null
dataloggerfiles	dataloggerfilelink	varchar	255	√		null
dataquality	dataqualitydescription	varchar	5000	√		null
dataquality	dataqualitylink	varchar	255	√		null
dataquality	dataqualityvalue	float8	17,17	√		null
dataquality	dataqualityvalueunitsid	int4	10	√		null
cv_actiontype	definition	varchar	5000	√		null
cv_aggregationstatistic	definition	varchar	5000	√		null
cv_annotationtype	definition	varchar	5000	√		null
cv_censorcode	definition	varchar	5000	√		null
cv_dataqualitytype	definition	varchar	5000	√		null
cv_datasettype	definition	varchar	5000	√		null
cv_directivetype	definition	varchar	5000	√		null
cv_elevationdatum	definition	varchar	5000	√		null
cv_equipmenttype	definition	varchar	5000	√		null
cv_medium	definition	varchar	5000	√		null
cv_methodtype	definition	varchar	5000	√		null
cv_organizationtype	definition	varchar	5000	√		null
cv_propertydatatype	definition	varchar	5000	√		null
cv_qualitycode	definition	varchar	5000	√		null
cv_relationshiptype	definition	varchar	5000	√		null
cv_resulttype	definition	varchar	5000	√		null
cv_samplingfeaturegeotype	definition	varchar	5000	√		null
cv_samplingfeaturetype	definition	varchar	5000	√		null
cv_sitetype	definition	varchar	5000	√		null
cv_spatialoffsettype	definition	varchar	5000	√		null
cv_speciation	definition	varchar	5000	√		null
cv_specimentype	definition	varchar	5000	√		null
cv_status	definition	varchar	5000	√		null
cv_taxonomicclassifiertype	definition	varchar	5000	√		null
cv_unitstype	definition	varchar	5000	√		null
cv_variablename	definition	varchar	5000	√		null
cv_variabletype	definition	varchar	5000	√		null
processinglevels	definition	varchar	5000	√		null
actions	enddatetime	timestamp	29,6	√		null
actions	enddatetimeutcoffset	int4	10	√		null
equipment	equipmentdescription	varchar	5000	√		null
equipment	equipmentdocumentationlink	varchar	255	√		null
equipment	equipmentpurchaseordernumber	varchar	50	√		null
processinglevels	explanation	varchar	5000	√		null
externalidentifiersystems	externalidentifiersystemdescription	varchar	5000	√		null
externalidentifiersystems	externalidentifiersystemurl	varchar	255	√		null
simulations	inputdatasetid	int4	10	√		null
instrumentoutputvariables	instrumentaccuracy	varchar	255	√		null
instrumentoutputvariables	instrumentresolution	varchar	255	√		null
profileresults	intendedtimespacing	float8	17,17	√		null
sectionresults	intendedtimespacing	float8	17,17	√		null
timeseriesresults	intendedtimespacing	float8	17,17	√		null
trajectoryresults	intendedtimespacing	float8	17,17	√		null
transectresults	intendedtimespacing	float8	17,17	√		null
profileresults	intendedtimespacingunitsid	int4	10	√		null
sectionresults	intendedtimespacingunitsid	int4	10	√		null
timeseriesresults	intendedtimespacingunitsid	int4	10	√		null
trajectoryresults	intendedtimespacingunitsid	int4	10	√		null
transectresults	intendedtimespacingunitsid	int4	10	√		null
trajectoryresults	intendedtrajectoryspacing	float8	17,17	√		null
trajectoryresults	intendedtrajectoryspacingunitsid	int4	10	√		null
transectresults	intendedtransectspacing	float8	17,17	√		null
transectresults	intendedtransectspacingunitsid	int4	10	√		null
spectraresults	intendedwavelengthspacing	float8	17,17	√		null
spectraresults	intendedwavelengthspacingunitsid	int4	10	√		null
pointcoverageresults	intendedxspacing	float8	17,17	√		null
sectionresults	intendedxspacing	float8	17,17	√		null
pointcoverageresults	intendedxspacingunitsid	int4	10	√		null
sectionresults	intendedxspacingunitsid	int4	10	√		null
pointcoverageresults	intendedyspacing	float8	17,17	√		null
pointcoverageresults	intendedyspacingunitsid	int4	10	√		null
profileresults	intendedzspacing	float8	17,17	√		null
sectionresults	intendedzspacing	float8	17,17	√		null
profileresults	intendedzspacingunitsid	int4	10	√		null
sectionresults	intendedzspacingunitsid	int4	10	√		null
affiliations	isprimaryorganizationcontact	bool	1	√		null
maintenanceactions	maintenancecode	varchar	50	√		null
maintenanceactions	maintenancereason	varchar	500	√		null
dataloggerfilecolumns	measurementequation	varchar	255	√		null
methods	methoddescription	varchar	5000	√		null
methodexternalidentifiers	methodexternalidentifieruri	varchar	255	√		null
methods	methodlink	varchar	255	√		null
equipmentmodels	modeldescription	varchar	5000	√		null
models	modeldescription	varchar	5000	√		null
equipmentmodels	modellink	varchar	255	√		null
models	modellink	varchar	255	√		null
equipmentmodels	modelpartnumber	varchar	50	√		null
equipmentmodels	modelspecificationsfilelink	varchar	255	√		null
spatialoffsets	offset2unitid	int4	10	√		null
spatialoffsets	offset2value	float8	17,17	√		null
spatialoffsets	offset3unitid	int4	10	√		null
spatialoffsets	offset3value	float8	17,17	√		null
organizations	organizationdescription	varchar	5000	√		null
affiliations	organizationid	int4	10	√		null
methods	organizationid	int4	10	√		null
organizations	organizationlink	varchar	255	√		null
organizations	parentorganizationid	int4	10	√		null
taxonomicclassifiers	parenttaxonomicclassifierid	int4	10	√		null
personexternalidentifiers	personexternalidentifieruri	varchar	255	√		null
affiliations	personlink	varchar	255	√		null
people	personmiddlename	varchar	255	√		null
affiliations	primaryaddress	varchar	255	√		null
affiliations	primaryphone	varchar	50	√		null
dataloggerprogramfiles	programdescription	varchar	5000	√		null
dataloggerprogramfiles	programfilelink	varchar	255	√		null
dataloggerprogramfiles	programversion	varchar	50	√		null
extensionproperties	propertydescription	varchar	5000	√		null
extensionproperties	propertyunitsid	int4	10	√		null
dataloggerfilecolumns	recordinginterval	float8	17,17	√		null
dataloggerfilecolumns	recordingintervalunitsid	int4	10	√		null
referencematerialvalues	referencematerialaccuracy	float8	17,17	√		null
referencematerials	referencematerialcertificatelink	varchar	255	√		null
referencematerials	referencematerialexpirationdate	timestamp	29,6	√		null
referencematerialexternalidentifiers	referencematerialexternalidentifieruri	varchar	255	√		null
referencematerials	referencemateriallotcode	varchar	255	√		null
referencematerials	referencematerialpurchasedate	timestamp	29,6	√		null
relatedresults	relatedresultsequencenumber	int4	10	√		null
relatedequipment	relationshipenddatetime	timestamp	29,6	√		null
relatedequipment	relationshipenddatetimeutcoffset	int4	10	√		null
results	resultdatetime	timestamp	29,6	√		null
results	resultdatetimeutcoffset	int8	19	√		null
dataloggerfilecolumns	resultid	int8	19	√		null
actionby	roledescription	varchar	5000	√		null
modelaffiliations	roledescription	varchar	5000	√		null
samplingfeatureexternalidentifiers	samplingfeatureexternalidentifieruri	varchar	255	√		null
referencematerials	samplingfeatureid	int4	10	√		null
dataloggerfilecolumns	scaninterval	float8	17,17	√		null
dataloggerfilecolumns	scanintervalunitsid	int4	10	√		null
simulations	simulationdescription	varchar	5000	√		null
cv_actiontype	sourcevocabularyuri	varchar	255	√		null
cv_aggregationstatistic	sourcevocabularyuri	varchar	255	√		null
cv_annotationtype	sourcevocabularyuri	varchar	255	√		null
cv_censorcode	sourcevocabularyuri	varchar	255	√		null
cv_dataqualitytype	sourcevocabularyuri	varchar	255	√		null
cv_datasettype	sourcevocabularyuri	varchar	255	√		null
cv_directivetype	sourcevocabularyuri	varchar	255	√		null
cv_elevationdatum	sourcevocabularyuri	varchar	255	√		null
cv_equipmenttype	sourcevocabularyuri	varchar	255	√		null
cv_medium	sourcevocabularyuri	varchar	255	√		null
cv_methodtype	sourcevocabularyuri	varchar	255	√		null
cv_organizationtype	sourcevocabularyuri	varchar	255	√		null
cv_propertydatatype	sourcevocabularyuri	varchar	255	√		null
cv_qualitycode	sourcevocabularyuri	varchar	255	√		null
cv_relationshiptype	sourcevocabularyuri	varchar	255	√		null
cv_resulttype	sourcevocabularyuri	varchar	255	√		null
cv_samplingfeaturegeotype	sourcevocabularyuri	varchar	255	√		null
cv_samplingfeaturetype	sourcevocabularyuri	varchar	255	√		null
cv_sitetype	sourcevocabularyuri	varchar	255	√		null
cv_spatialoffsettype	sourcevocabularyuri	varchar	255	√		null
cv_speciation	sourcevocabularyuri	varchar	255	√		null
cv_specimentype	sourcevocabularyuri	varchar	255	√		null
cv_status	sourcevocabularyuri	varchar	255	√		null
cv_taxonomicclassifiertype	sourcevocabularyuri	varchar	255	√		null
cv_unitstype	sourcevocabularyuri	varchar	255	√		null
cv_variablename	sourcevocabularyuri	varchar	255	√		null
cv_variabletype	sourcevocabularyuri	varchar	255	√		null
relatedfeatures	spatialoffsetid	int4	10	√		null
spatialreferenceexternalidentifiers	spatialreferenceexternalidentifieruri	varchar	255	√		null
categoricalresults	spatialreferenceid	int4	10	√		null
measurementresults	spatialreferenceid	int4	10	√		null
pointcoverageresults	spatialreferenceid	int4	10	√		null
profileresults	spatialreferenceid	int4	10	√		null
sectionresults	spatialreferenceid	int4	10	√		null
spectraresults	spatialreferenceid	int4	10	√		null
timeseriesresults	spatialreferenceid	int4	10	√		null
trajectoryresults	spatialreferenceid	int4	10	√		null
transectresults	spatialreferenceid	int4	10	√		null
variables	speciationcv	varchar	255	√		null
spatialreferences	srscode	varchar	50	√		null
spatialreferences	srsdescription	varchar	5000	√		null
spatialreferences	srslink	varchar	255	√		null
results	statuscv	varchar	255	√		null
taxonomicclassifiers	taxonomicclassifiercommonname	varchar	255	√		null
taxonomicclassifiers	taxonomicclassifierdescription	varchar	5000	√		null
taxonomicclassifierexternalidentifiers	taxonomicclassifierexternalidentifieruri	varchar	255	√		null
results	taxonomicclassifierid	int4	10	√		null
units	unitslink	varchar	255	√		null
results	validdatetime	timestamp	29,6	√		null
results	validdatetimeutcoffset	int8	19	√		null
variables	variabledefinition	varchar	5000	√		null
variableexternalidentifiers	variableexternalidentifieruri	varchar	255	√		null
models	version	varchar	255	√		null
relateddatasets	versioncode	varchar	50	√		null
relatedresults	versioncode	varchar	50	√		null
categoricalresults	xlocation	float8	17,17	√		null
measurementresults	xlocation	float8	17,17	√		null
profileresults	xlocation	float8	17,17	√		null
spectraresults	xlocation	float8	17,17	√		null
timeseriesresults	xlocation	float8	17,17	√		null
categoricalresults	xlocationunitsid	int4	10	√		null
measurementresults	xlocationunitsid	int4	10	√		null
profileresults	xlocationunitsid	int4	10	√		null
spectraresults	xlocationunitsid	int4	10	√		null
timeseriesresults	xlocationunitsid	int4	10	√		null
categoricalresults	ylocation	float8	17,17	√		null
measurementresults	ylocation	float8	17,17	√		null
profileresults	ylocation	float8	17,17	√		null
sectionresults	ylocation	float8	17,17	√		null
spectraresults	ylocation	float8	17,17	√		null
timeseriesresults	ylocation	float8	17,17	√		null
categoricalresults	ylocationunitsid	int4	10	√		null
measurementresults	ylocationunitsid	int4	10	√		null
profileresults	ylocationunitsid	int4	10	√		null
sectionresults	ylocationunitsid	int4	10	√		null
spectraresults	ylocationunitsid	int4	10	√		null
timeseriesresults	ylocationunitsid	int4	10	√		null
categoricalresults	zlocation	float8	17,17	√		null
measurementresults	zlocation	float8	17,17	√		null
pointcoverageresults	zlocation	float8	17,17	√		null
spectraresults	zlocation	float8	17,17	√		null
timeseriesresults	zlocation	float8	17,17	√		null
transectresults	zlocation	float8	17,17	√		null
categoricalresults	zlocationunitsid	int4	10	√		null
measurementresults	zlocationunitsid	int4	10	√		null
pointcoverageresults	zlocationunitsid	int4	10	√		null
spectraresults	zlocationunitsid	int4	10	√		null
timeseriesresults	zlocationunitsid	int4	10	√		null
transectresults	zlocationunitsid	int4	10	√		null
actionannotations	actionid	int4	10
actionby	actionid	int4	10
actiondirectives	actionid	int4	10
actionextensionpropertyvalues	actionid	int4	10
actions	actionid	serial	10		√	nextval('odm2.actions_actionid_seq'::regclass)
calibrationactions	actionid	int4	10
calibrationreferenceequipment	actionid	int4	10
calibrationstandards	actionid	int4	10
equipmentused	actionid	int4	10
featureactions	actionid	int4	10
maintenanceactions	actionid	int4	10
relatedactions	actionid	int4	10
simulations	actionid	int4	10
actions	actiontypecv	varchar	255
actionby	affiliationid	int4	10
affiliations	affiliationid	serial	10		√	nextval('odm2.affiliations_affiliationid_seq'::regclass)
dataloggerprogramfiles	affiliationid	int4	10
modelaffiliations	affiliationid	int4	10
affiliations	affiliationstartdate	date	13
measurementresults	aggregationstatisticcv	varchar	255
pointcoverageresults	aggregationstatisticcv	varchar	255
profileresults	aggregationstatisticcv	varchar	255
sectionresults	aggregationstatisticcv	varchar	255
sectionresultvalues	aggregationstatisticcv	varchar	255
spectraresults	aggregationstatisticcv	varchar	255
timeseriesresults	aggregationstatisticcv	varchar	255
trajectoryresults	aggregationstatisticcv	varchar	255
transectresults	aggregationstatisticcv	varchar	255
transectresultvalues	aggregationstatisticcv	varchar	255
actionannotations	annotationid	int4	10
annotations	annotationid	serial	10		√	nextval('odm2.annotations_annotationid_seq'::regclass)
categoricalresultvalueannotations	annotationid	int4	10
equipmentannotations	annotationid	int4	10
measurementresultvalueannotations	annotationid	int4	10
methodannotations	annotationid	int4	10
pointcoverageresultvalueannotations	annotationid	int4	10
profileresultvalueannotations	annotationid	int4	10
relatedannotations	annotationid	int4	10
resultannotations	annotationid	int4	10
samplingfeatureannotations	annotationid	int4	10
sectionresultvalueannotations	annotationid	int4	10
spectraresultvalueannotations	annotationid	int4	10
timeseriesresultvalueannotations	annotationid	int4	10
trajectoryresultvalueannotations	annotationid	int4	10
transectresultvalueannotations	annotationid	int4	10
annotations	annotationtext	varchar	500
annotations	annotationtypecv	varchar	255
authorlists	authororder	int4	10
specimenbatchpostions	batchpositionnumber	int4	10
actions	begindatetime	timestamp	29,6
resultannotations	begindatetime	timestamp	29,6
actions	begindatetimeutcoffset	int4	10
actionannotations	bridgeid	serial	10		√	nextval('odm2.actionannotations_bridgeid_seq'::regclass)
actionby	bridgeid	serial	10		√	nextval('odm2.actionby_bridgeid_seq'::regclass)
actiondirectives	bridgeid	serial	10		√	nextval('odm2.actiondirectives_bridgeid_seq'::regclass)
actionextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.actionextensionpropertyvalues_bridgeid_seq'::regclass)
authorlists	bridgeid	serial	10		√	nextval('odm2.authorlists_bridgeid_seq'::regclass)
calibrationreferenceequipment	bridgeid	serial	10		√	nextval('odm2.calibrationreferenceequipment_bridgeid_seq'::regclass)
calibrationstandards	bridgeid	serial	10		√	nextval('odm2.calibrationstandards_bridgeid_seq'::regclass)
categoricalresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.categoricalresultvalueannotations_bridgeid_seq'::regclass)
citationextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.citationextensionpropertyvalues_bridgeid_seq'::regclass)
citationexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.citationexternalidentifiers_bridgeid_seq'::regclass)
datasetcitations	bridgeid	serial	10		√	nextval('odm2.datasetcitations_bridgeid_seq'::regclass)
datasetsresults	bridgeid	serial	10		√	nextval('odm2.datasetsresults_bridgeid_seq'::regclass)
equipmentannotations	bridgeid	serial	10		√	nextval('odm2.equipmentannotations_bridgeid_seq'::regclass)
equipmentused	bridgeid	serial	10		√	nextval('odm2.equipmentused_bridgeid_seq'::regclass)
measurementresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.measurementresultvalueannotations_bridgeid_seq'::regclass)
methodannotations	bridgeid	serial	10		√	nextval('odm2.methodannotations_bridgeid_seq'::regclass)
methodcitations	bridgeid	serial	10		√	nextval('odm2.methodcitations_bridgeid_seq'::regclass)
methodextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.methodextensionpropertyvalues_bridgeid_seq'::regclass)
methodexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.methodexternalidentifiers_bridgeid_seq'::regclass)
modelaffiliations	bridgeid	serial	10		√	nextval('odm2.modelaffiliations_bridgeid_seq'::regclass)
personexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.personexternalidentifiers_bridgeid_seq'::regclass)
pointcoverageresultvalueannotations	bridgeid	bigserial	19		√	nextval('odm2.pointcoverageresultvalueannotations_bridgeid_seq'::regclass)
profileresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.profileresultvalueannotations_bridgeid_seq'::regclass)
referencematerialexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.referencematerialexternalidentifiers_bridgeid_seq'::regclass)
resultannotations	bridgeid	serial	10		√	nextval('odm2.resultannotations_bridgeid_seq'::regclass)
resultextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.resultextensionpropertyvalues_bridgeid_seq'::regclass)
resultsdataquality	bridgeid	serial	10		√	nextval('odm2.resultsdataquality_bridgeid_seq'::regclass)
samplingfeatureannotations	bridgeid	serial	10		√	nextval('odm2.samplingfeatureannotations_bridgeid_seq'::regclass)
samplingfeatureextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.samplingfeatureextensionpropertyvalues_bridgeid_seq'::regclass)
samplingfeatureexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.samplingfeatureexternalidentifiers_bridgeid_seq'::regclass)
sectionresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.sectionresultvalueannotations_bridgeid_seq'::regclass)
spatialreferenceexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.spatialreferenceexternalidentifiers_bridgeid_seq'::regclass)
specimentaxonomicclassifiers	bridgeid	serial	10		√	nextval('odm2.specimentaxonomicclassifiers_bridgeid_seq'::regclass)
spectraresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.spectraresultvalueannotations_bridgeid_seq'::regclass)
taxonomicclassifierexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.taxonomicclassifierexternalidentifiers_bridgeid_seq'::regclass)
timeseriesresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.timeseriesresultvalueannotations_bridgeid_seq'::regclass)
trajectoryresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.trajectoryresultvalueannotations_bridgeid_seq'::regclass)
transectresultvalueannotations	bridgeid	serial	10		√	nextval('odm2.transectresultvalueannotations_bridgeid_seq'::regclass)
variableextensionpropertyvalues	bridgeid	serial	10		√	nextval('odm2.variableextensionpropertyvalues_bridgeid_seq'::regclass)
variableexternalidentifiers	bridgeid	serial	10		√	nextval('odm2.variableexternalidentifiers_bridgeid_seq'::regclass)
measurementresults	censorcodecv	varchar	255
pointcoverageresultvalues	censorcodecv	varchar	255
profileresultvalues	censorcodecv	varchar	255
sectionresultvalues	censorcodecv	varchar	255
spectraresultvalues	censorcodecv	varchar	255
timeseriesresultvalues	censorcodecv	varchar	255
trajectoryresultvalues	censorcodecv	varchar	255
transectresultvalues	censorcodecv	varchar	255
citationexternalidentifiers	citationexternalidentifier	varchar	255
authorlists	citationid	int4	10
citationextensionpropertyvalues	citationid	int4	10
citationexternalidentifiers	citationid	int4	10
citations	citationid	serial	10		√	nextval('odm2.citations_citationid_seq'::regclass)
datasetcitations	citationid	int4	10
methodcitations	citationid	int4	10
relatedcitations	citationid	int4	10
dataloggerfilecolumns	columnlabel	varchar	50
dataloggerfilecolumns	dataloggerfilecolumnid	serial	10		√	nextval('odm2.dataloggerfilecolumns_dataloggerfilecolumnid_seq'::regclass)
dataloggerfilecolumns	dataloggerfileid	int4	10
dataloggerfiles	dataloggerfileid	serial	10		√	nextval('odm2.dataloggerfiles_dataloggerfileid_seq'::regclass)
dataloggerfiles	dataloggerfilename	varchar	255
dataquality	dataqualitycode	varchar	255
dataquality	dataqualityid	int4	10
resultsdataquality	dataqualityid	int4	10
dataquality	dataqualitytypecv	varchar	255
datasets	datasetabstract	varchar	5000
datasets	datasetcode	varchar	50
datasetcitations	datasetid	int4	10
datasets	datasetid	serial	10		√	nextval('odm2.datasets_datasetid_seq'::regclass)
datasetsresults	datasetid	int4	10
relateddatasets	datasetid	int4	10
datasets	datasettitle	varchar	255
datasets	datasettypecv	varchar	255
datasets	datasetuuid	uuid	2147483647
categoricalresultvalues	datavalue	varchar	255
measurementresultvalues	datavalue	float8	17,17
pointcoverageresultvalues	datavalue	float8	17,17
profileresultvalues	datavalue	float8	17,17
sectionresultvalues	datavalue	float8	17,17
spectraresultvalues	datavalue	float8	17,17
timeseriesresultvalues	datavalue	float8	17,17
trajectoryresultvalues	datavalue	float8	17,17
transectresultvalues	datavalue	float8	17,17
derivationequations	derivationequation	varchar	255
derivationequations	derivationequationid	serial	10		√	nextval('odm2.derivationequations_derivationequationid_seq'::regclass)
resultderivationequations	derivationequationid	int4	10
directives	directivedescription	varchar	5000
actiondirectives	directiveid	int4	10
directives	directiveid	serial	10		√	nextval('odm2.directives_directiveid_seq'::regclass)
directives	directivetypecv	varchar	255
spectraresultvalues	emissionwavelength	float8	17,17
resultannotations	enddatetime	timestamp	29,6
equipment	equipmentcode	varchar	50
calibrationreferenceequipment	equipmentid	int4	10
equipment	equipmentid	serial	10		√	nextval('odm2.equipment_equipmentid_seq'::regclass)
equipmentannotations	equipmentid	int4	10
equipmentused	equipmentid	int4	10
relatedequipment	equipmentid	int4	10
equipment	equipmentmodelid	int4	10
equipmentmodels	equipmentmodelid	serial	10		√	nextval('odm2.equipmentmodels_equipmentmodelid_seq'::regclass)
equipment	equipmentname	varchar	255
equipment	equipmentownerid	int4	10
equipment	equipmentpurchasedate	timestamp	29,6
equipment	equipmentserialnumber	varchar	50
equipment	equipmenttypecv	varchar	255
equipment	equipmentvendorid	int4	10
spectraresultvalues	excitationwavelength	float8	17,17
citationexternalidentifiers	externalidentifiersystemid	int4	10
externalidentifiersystems	externalidentifiersystemid	serial	10		√	nextval('odm2.externalidentifiersystems_externalidentifiersystemid_seq'::regclass)
methodexternalidentifiers	externalidentifiersystemid	int4	10
personexternalidentifiers	externalidentifiersystemid	int4	10
referencematerialexternalidentifiers	externalidentifiersystemid	int4	10
samplingfeatureexternalidentifiers	externalidentifiersystemid	int4	10
spatialreferenceexternalidentifiers	externalidentifiersystemid	int4	10
taxonomicclassifierexternalidentifiers	externalidentifiersystemid	int4	10
variableexternalidentifiers	externalidentifiersystemid	int4	10
externalidentifiersystems	externalidentifiersystemname	varchar	255
featureactions	featureactionid	serial	10		√	nextval('odm2.featureactions_featureactionid_seq'::regclass)
results	featureactionid	int4	10
specimenbatchpostions	featureactionid	int4	10
externalidentifiersystems	identifiersystemorganizationid	int4	10
instrumentoutputvariables	instrumentmethodid	int4	10
calibrationactions	instrumentoutputvariableid	int4	10
dataloggerfilecolumns	instrumentoutputvariableid	int4	10
instrumentoutputvariables	instrumentoutputvariableid	serial	10		√	nextval('odm2.instrumentoutputvariables_instrumentoutputvariableid_seq'::regclass)
instrumentoutputvariables	instrumentrawoutputunitsid	int4	10
actionby	isactionlead	bool	1
maintenanceactions	isfactoryservice	bool	1
specimens	isfieldspecimen	bool	1
equipmentmodels	isinstrument	bool	1
modelaffiliations	isprimary	bool	1
sites	latitude	float8	17,17
sites	longitude	float8	17,17
methods	methodcode	varchar	50
methodexternalidentifiers	methodexternalidentifier	varchar	255
actions	methodid	int4	10
methodannotations	methodid	int4	10
methodcitations	methodid	int4	10
methodextensionpropertyvalues	methodid	int4	10
methodexternalidentifiers	methodid	int4	10
methods	methodid	serial	10		√	nextval('odm2.methods_methodid_seq'::regclass)
methods	methodname	varchar	255
methods	methodtypecv	varchar	255
models	modelcode	varchar	50
instrumentoutputvariables	modelid	int4	10
modelaffiliations	modelid	int4	10
models	modelid	serial	10		√	nextval('odm2.models_modelid_seq'::regclass)
relatedmodels	modelid	int4	10
simulations	modelid	int4	10
equipmentmodels	modelmanufacturerid	int4	10
equipmentmodels	modelname	varchar	255
models	modelname	varchar	255
cv_actiontype	name	varchar	255
cv_aggregationstatistic	name	varchar	255
cv_annotationtype	name	varchar	255
cv_censorcode	name	varchar	255
cv_dataqualitytype	name	varchar	255
cv_datasettype	name	varchar	255
cv_directivetype	name	varchar	255
cv_elevationdatum	name	varchar	255
cv_equipmenttype	name	varchar	255
cv_medium	name	varchar	255
cv_methodtype	name	varchar	255
cv_organizationtype	name	varchar	255
cv_propertydatatype	name	varchar	255
cv_qualitycode	name	varchar	255
cv_relationshiptype	name	varchar	255
cv_resulttype	name	varchar	255
cv_samplingfeaturegeotype	name	varchar	255
cv_samplingfeaturetype	name	varchar	255
cv_sitetype	name	varchar	255
cv_spatialoffsettype	name	varchar	255
cv_speciation	name	varchar	255
cv_specimentype	name	varchar	255
cv_status	name	varchar	255
cv_taxonomicclassifiertype	name	varchar	255
cv_unitstype	name	varchar	255
cv_variablename	name	varchar	255
cv_variabletype	name	varchar	255
variables	nodatavalue	float8	17,17
resultnormalizationvalues	normalizedbyreferencematerialvalueid	int4	10
spatialoffsets	offset1unitid	int4	10
spatialoffsets	offset1value	float8	17,17
organizations	organizationcode	varchar	50
organizations	organizationid	serial	10		√	nextval('odm2.organizations_organizationid_seq'::regclass)
organizations	organizationname	varchar	255
organizations	organizationtypecv	varchar	255
personexternalidentifiers	personexternalidentifier	varchar	255
people	personfirstname	varchar	255
affiliations	personid	int4	10
authorlists	personid	int4	10
people	personid	serial	10		√	nextval('odm2.people_personid_seq'::regclass)
personexternalidentifiers	personid	int4	10
people	personlastname	varchar	255
affiliations	primaryemail	varchar	255
processinglevels	processinglevelcode	varchar	50
processinglevels	processinglevelid	serial	10		√	nextval('odm2.processinglevels_processinglevelid_seq'::regclass)
results	processinglevelid	int4	10
dataloggerfiles	programid	int4	10
dataloggerprogramfiles	programid	serial	10		√	nextval('odm2.dataloggerprogramfiles_programid_seq'::regclass)
dataloggerprogramfiles	programname	varchar	255
extensionproperties	propertydatatypecv	varchar	255
actionextensionpropertyvalues	propertyid	int4	10
citationextensionpropertyvalues	propertyid	int4	10
extensionproperties	propertyid	serial	10		√	nextval('odm2.extensionproperties_propertyid_seq'::regclass)
methodextensionpropertyvalues	propertyid	int4	10
resultextensionpropertyvalues	propertyid	int4	10
samplingfeatureextensionpropertyvalues	propertyid	int4	10
variableextensionpropertyvalues	propertyid	int4	10
extensionproperties	propertyname	varchar	255
actionextensionpropertyvalues	propertyvalue	varchar	255
citationextensionpropertyvalues	propertyvalue	varchar	255
methodextensionpropertyvalues	propertyvalue	varchar	255
resultextensionpropertyvalues	propertyvalue	varchar	255
samplingfeatureextensionpropertyvalues	propertyvalue	varchar	255
variableextensionpropertyvalues	propertyvalue	varchar	255
citations	publicationyear	int4	10
citations	publisher	varchar	255
categoricalresults	qualitycodecv	varchar	255
measurementresults	qualitycodecv	varchar	255
pointcoverageresultvalues	qualitycodecv	varchar	255
profileresultvalues	qualitycodecv	varchar	255
sectionresultvalues	qualitycodecv	varchar	255
spectraresultvalues	qualitycodecv	varchar	255
timeseriesresultvalues	qualitycodecv	varchar	255
trajectoryresultvalues	qualitycodecv	varchar	255
transectresultvalues	qualitycodecv	varchar	255
referencematerials	referencematerialcode	varchar	50
referencematerialexternalidentifiers	referencematerialexternalidentifier	varchar	255
calibrationstandards	referencematerialid	int4	10
referencematerialexternalidentifiers	referencematerialid	int4	10
referencematerials	referencematerialid	serial	10		√	nextval('odm2.referencematerials_referencematerialid_seq'::regclass)
referencematerialvalues	referencematerialid	int4	10
referencematerials	referencematerialmediumcv	varchar	255
referencematerials	referencematerialorganizationid	int4	10
referencematerialvalues	referencematerialvalue	float8	17,17
referencematerialvalues	referencematerialvalueid	serial	10		√	nextval('odm2.referencematerialvalues_referencematerialvalueid_seq'::regclass)
relatedactions	relatedactionid	int4	10
relatedannotations	relatedannotationid	int4	10
relatedcitations	relatedcitationid	int4	10
relateddatasets	relateddatasetid	int4	10
relatedequipment	relatedequipmentid	int4	10
relatedfeatures	relatedfeatureid	int4	10
relatedmodels	relatedid	serial	10		√	nextval('odm2.relatedmodels_relatedid_seq'::regclass)
relatedmodels	relatedmodelid	int4	10
relatedresults	relatedresultid	int8	19
relatedactions	relationid	serial	10		√	nextval('odm2.relatedactions_relationid_seq'::regclass)
relatedannotations	relationid	serial	10		√	nextval('odm2.relatedannotations_relationid_seq'::regclass)
relatedcitations	relationid	serial	10		√	nextval('odm2.relatedcitations_relationid_seq'::regclass)
relateddatasets	relationid	serial	10		√	nextval('odm2.relateddatasets_relationid_seq'::regclass)
relatedequipment	relationid	serial	10		√	nextval('odm2.relatedequipment_relationid_seq'::regclass)
relatedfeatures	relationid	serial	10		√	nextval('odm2.relatedfeatures_relationid_seq'::regclass)
relatedresults	relationid	serial	10		√	nextval('odm2.relatedresults_relationid_seq'::regclass)
relatedequipment	relationshipstartdatetime	timestamp	29,6
relatedequipment	relationshipstartdatetimeutcoffset	int4	10
datasetcitations	relationshiptypecv	varchar	255
methodcitations	relationshiptypecv	varchar	255
relatedactions	relationshiptypecv	varchar	255
relatedannotations	relationshiptypecv	varchar	255
relatedcitations	relationshiptypecv	varchar	255
relateddatasets	relationshiptypecv	varchar	255
relatedequipment	relationshiptypecv	varchar	255
relatedfeatures	relationshiptypecv	varchar	255
relatedmodels	relationshiptypecv	varchar	255
relatedresults	relationshiptypecv	varchar	255
categoricalresults	resultid	int8	19
categoricalresultvalues	resultid	int8	19
datasetsresults	resultid	int8	19
measurementresults	resultid	int8	19
measurementresultvalues	resultid	int8	19
pointcoverageresults	resultid	int8	19
pointcoverageresultvalues	resultid	int8	19
profileresults	resultid	int8	19
profileresultvalues	resultid	int8	19
relatedresults	resultid	int8	19
resultannotations	resultid	int8	19
resultderivationequations	resultid	int8	19
resultextensionpropertyvalues	resultid	int8	19
resultnormalizationvalues	resultid	int8	19
results	resultid	bigserial	19		√	nextval('odm2.results_resultid_seq'::regclass)
resultsdataquality	resultid	int8	19
sectionresults	resultid	int8	19
sectionresultvalues	resultid	int8	19
spectraresults	resultid	int8	19
spectraresultvalues	resultid	int8	19
timeseriesresults	resultid	int8	19
timeseriesresultvalues	resultid	int8	19
trajectoryresults	resultid	int8	19
trajectoryresultvalues	resultid	int8	19
transectresults	resultid	int8	19
transectresultvalues	resultid	int8	19
results	resulttypecv	varchar	255
results	resultuuid	uuid	2147483647
results	sampledmediumcv	varchar	255
samplingfeatureexternalidentifiers	samplingfeatureexternalidentifier	varchar	255
featureactions	samplingfeatureid	int4	10
relatedfeatures	samplingfeatureid	int4	10
samplingfeatureannotations	samplingfeatureid	int4	10
samplingfeatureextensionpropertyvalues	samplingfeatureid	int4	10
samplingfeatureexternalidentifiers	samplingfeatureid	int4	10
sites	samplingfeatureid	int4	10
specimens	samplingfeatureid	int4	10
specimentaxonomicclassifiers	samplingfeatureid	int4	10
simulations	simulationenddatetime	timestamp	29,6
simulations	simulationenddatetimeutcoffset	int4	10
simulations	simulationid	serial	10		√	nextval('odm2.simulations_simulationid_seq'::regclass)
simulations	simulationname	varchar	255
simulations	simulationstartdatetime	timestamp	29,6
simulations	simulationstartdatetimeutcoffset	int4	10
sites	sitetypecv	varchar	255
spatialoffsets	spatialoffsetid	serial	10		√	nextval('odm2.spatialoffsets_spatialoffsetid_seq'::regclass)
spatialoffsets	spatialoffsettypecv	varchar	255
spatialreferenceexternalidentifiers	spatialreferenceexternalidentifier	varchar	255
sites	spatialreferenceid	int4	10
spatialreferenceexternalidentifiers	spatialreferenceid	int4	10
spatialreferences	spatialreferenceid	serial	10		√	nextval('odm2.spatialreferences_spatialreferenceid_seq'::regclass)
specimens	specimenmediumcv	varchar	255
specimens	specimentypecv	varchar	255
spatialreferences	srsname	varchar	255
taxonomicclassifierexternalidentifiers	taxonomicclassifierexternalidentifier	varchar	255
specimentaxonomicclassifiers	taxonomicclassifierid	int4	10
taxonomicclassifierexternalidentifiers	taxonomicclassifierid	int4	10
taxonomicclassifiers	taxonomicclassifierid	serial	10		√	nextval('odm2.taxonomicclassifiers_taxonomicclassifierid_seq'::regclass)
taxonomicclassifiers	taxonomicclassifiername	varchar	255
taxonomicclassifiers	taxonomicclassifiertypecv	varchar	255
cv_actiontype	term	varchar	255
cv_aggregationstatistic	term	varchar	255
cv_annotationtype	term	varchar	255
cv_censorcode	term	varchar	255
cv_dataqualitytype	term	varchar	255
cv_datasettype	term	varchar	255
cv_directivetype	term	varchar	255
cv_elevationdatum	term	varchar	255
cv_equipmenttype	term	varchar	255
cv_medium	term	varchar	255
cv_methodtype	term	varchar	255
cv_organizationtype	term	varchar	255
cv_propertydatatype	term	varchar	255
cv_qualitycode	term	varchar	255
cv_relationshiptype	term	varchar	255
cv_resulttype	term	varchar	255
cv_samplingfeaturegeotype	term	varchar	255
cv_samplingfeaturetype	term	varchar	255
cv_sitetype	term	varchar	255
cv_spatialoffsettype	term	varchar	255
cv_speciation	term	varchar	255
cv_specimentype	term	varchar	255
cv_status	term	varchar	255
cv_taxonomicclassifiertype	term	varchar	255
cv_unitstype	term	varchar	255
cv_variablename	term	varchar	255
cv_variabletype	term	varchar	255
measurementresults	timeaggregationinterval	float8	17,17
pointcoverageresults	timeaggregationinterval	float8	17,17
profileresultvalues	timeaggregationinterval	float8	17,17
sectionresultvalues	timeaggregationinterval	float8	17,17
spectraresultvalues	timeaggregationinterval	float8	17,17
timeseriesresultvalues	timeaggregationinterval	float8	17,17
trajectoryresultvalues	timeaggregationinterval	float8	17,17
transectresultvalues	timeaggregationinterval	float8	17,17
measurementresults	timeaggregationintervalunitsid	int4	10
pointcoverageresults	timeaggregationintervalunitsid	int4	10
profileresultvalues	timeaggregationintervalunitsid	int4	10
sectionresultvalues	timeaggregationintervalunitsid	int4	10
spectraresultvalues	timeaggregationintervalunitsid	int4	10
timeseriesresultvalues	timeaggregationintervalunitsid	int4	10
trajectoryresultvalues	timeaggregationintervalunitsid	int4	10
transectresultvalues	timeaggregationintervalunitsid	int4	10
simulations	timestepunitsid	int4	10
simulations	timestepvalue	float8	17,17
citations	title	varchar	255
trajectoryresultvalues	trajectorydistance	float8	17,17
trajectoryresultvalues	trajectorydistanceaggregationinterval	float8	17,17
trajectoryresultvalues	trajectorydistanceunitsid	int4	10
transectresultvalues	transectdistance	float8	17,17
transectresultvalues	transectdistanceaggregationinterval	float8	17,17
transectresultvalues	transectdistanceunitsid	int4	10
units	unitsabbreviation	varchar	50
referencematerialvalues	unitsid	int4	10
results	unitsid	int4	10
units	unitsid	serial	10		√	nextval('odm2.units_unitsid_seq'::regclass)
units	unitsname	varchar	255
units	unitstypecv	varchar	255
results	valuecount	int4	10
categoricalresultvalues	valuedatetime	timestamp	29,6
measurementresultvalues	valuedatetime	timestamp	29,6
pointcoverageresultvalues	valuedatetime	timestamp	29,6
profileresultvalues	valuedatetime	timestamp	29,6
sectionresultvalues	valuedatetime	timestamp	29,6
spectraresultvalues	valuedatetime	timestamp	29,6
timeseriesresultvalues	valuedatetime	timestamp	29,6
trajectoryresultvalues	valuedatetime	timestamp	29,6
transectresultvalues	valuedatetime	timestamp	29,6
categoricalresultvalues	valuedatetimeutcoffset	int4	10
measurementresultvalues	valuedatetimeutcoffset	int4	10
pointcoverageresultvalues	valuedatetimeutcoffset	int4	10
profileresultvalues	valuedatetimeutcoffset	int4	10
sectionresultvalues	valuedatetimeutcoffset	int4	10
spectraresultvalues	valuedatetimeutcoffset	int4	10
timeseriesresultvalues	valuedatetimeutcoffset	int4	10
trajectoryresultvalues	valuedatetimeutcoffset	int4	10
transectresultvalues	valuedatetimeutcoffset	int4	10
categoricalresultvalueannotations	valueid	int8	19
categoricalresultvalues	valueid	bigserial	19		√	nextval('odm2.categoricalresultvalues_valueid_seq'::regclass)
measurementresultvalueannotations	valueid	int8	19
measurementresultvalues	valueid	bigserial	19		√	nextval('odm2.measurementresultvalues_valueid_seq'::regclass)
pointcoverageresultvalueannotations	valueid	int8	19
pointcoverageresultvalues	valueid	bigserial	19		√	nextval('odm2.pointcoverageresultvalues_valueid_seq'::regclass)
profileresultvalueannotations	valueid	int8	19
profileresultvalues	valueid	bigserial	19		√	nextval('odm2.profileresultvalues_valueid_seq'::regclass)
sectionresultvalueannotations	valueid	int8	19
sectionresultvalues	valueid	bigserial	19		√	nextval('odm2.sectionresultvalues_valueid_seq'::regclass)
spectraresultvalueannotations	valueid	int8	19
spectraresultvalues	valueid	bigserial	19		√	nextval('odm2.spectraresultvalues_valueid_seq'::regclass)
timeseriesresultvalueannotations	valueid	int8	19
timeseriesresultvalues	valueid	bigserial	19		√	nextval('odm2.timeseriesresultvalues_valueid_seq'::regclass)
trajectoryresultvalueannotations	valueid	int8	19
trajectoryresultvalues	valueid	bigserial	19		√	nextval('odm2.trajectoryresultvalues_valueid_seq'::regclass)
transectresultvalueannotations	valueid	int8	19
transectresultvalues	valueid	bigserial	19		√	nextval('odm2.transectresultvalues_valueid_seq'::regclass)
variables	variablecode	varchar	50
variableexternalidentifiers	variableexternalidentifer	varchar	255
instrumentoutputvariables	variableid	int4	10
referencematerialvalues	variableid	int4	10
results	variableid	int4	10
variableextensionpropertyvalues	variableid	int4	10
variableexternalidentifiers	variableid	int4	10
variables	variableid	serial	10		√	nextval('odm2.variables_variableid_seq'::regclass)
variables	variablenamecv	varchar	255
variables	variabletypecv	varchar	255
spectraresultvalues	wavelengthunitsid	int4	10
sectionresultvalues	xaggregationinterval	float8	17,17
pointcoverageresultvalues	xlocation	float8	17,17
sectionresultvalues	xlocation	float8	17,17
trajectoryresultvalues	xlocation	float8	17,17
transectresultvalues	xlocation	float8	17,17
pointcoverageresultvalues	xlocationunitsid	int4	10
sectionresultvalues	xlocationunitsid	int4	10
trajectoryresultvalues	xlocationunitsid	int4	10
transectresultvalues	xlocationunitsid	int4	10
pointcoverageresultvalues	ylocation	float8	17,17
trajectoryresultvalues	ylocation	float8	17,17
transectresultvalues	ylocation	float8	17,17
pointcoverageresultvalues	ylocationunitsid	int4	10
trajectoryresultvalues	ylocationunitsid	int4	10
transectresultvalues	ylocationunitsid	int4	10
profileresultvalues	zaggregationinterval	float8	17,17
sectionresultvalues	zaggregationinterval	float8	17,17
profileresultvalues	zlocation	float8	17,17
sectionresultvalues	zlocation	int8	19
trajectoryresultvalues	zlocation	float8	17,17
profileresultvalues	zlocationunitsid	int4	10
sectionresultvalues	zlocationunitsid	int4	10
trajectoryresultvalues	zlocationunitsid	int4	10