Table mob_odm2.odm2.methods 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
methodid serial 10  √  nextval('odm2.methods_methodid_seq'::regclass)
actions.methodid fk_actions_methods C
instrumentoutputvariables.instrumentmethodid fk_instrumentoutputvariables_methods C
methodannotations.methodid fk_methodannotations_methods C
methodcitations.methodid fk_methodcitations_methods C
methodextensionpropertyvalues.methodid fk_methodextensionpropertyvalues_methods C
methodexternalidentifiers.methodid fk_methodexternalidentifiers_methods C
methodtypecv varchar 255
cv_methodtype.name fk_methods_cv_methodtype C
methodcode varchar 50
methodname varchar 255
methoddescription varchar 5000  √  null
methodlink varchar 255  √  null
organizationid int4 10  √  null
organizations.organizationid fk_methods_organizations C

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

Indexes:
Column(s) Type Sort Constraint Name
methodid Primary key Asc methods_pkey
methodcode Must be unique Asc methods_methodcode_key

Close relationships  within of separation: