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

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