Table mob_odm2.odm2.extensionproperties Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
propertyid serial 10  √  nextval('odm2.extensionproperties_propertyid_seq'::regclass)
actionextensionpropertyvalues.propertyid fk_actionextensionpropertyvalues_extensionproperties C
citationextensionpropertyvalues.propertyid fk_citationextensionpropertyvalues_extensionproperties C
methodextensionpropertyvalues.propertyid fk_methodextensionpropertyvalues_extensionproperties C
resultextensionpropertyvalues.propertyid fk_resultextensionpropertyvalues_extensionproperties C
samplingfeatureextensionpropertyvalues.propertyid fk_samplingfeatureextensionpropertyvalues_extensionproperties C
variableextensionpropertyvalues.propertyid fk_variableextensionpropertyvalues_extensionproperties C
propertyname varchar 255
propertydescription varchar 5000  √  null
propertydatatypecv varchar 255
cv_propertydatatype.name fk_extensionproperties_cv_propertydatatype C
propertyunitsid int4 10  √  null
units.unitsid fk_extensionproperties_units C

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
propertyid Primary key Asc extensionproperties_pkey

Close relationships  within of separation: