Methods - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: Methods

A Method refers to how a quantitative or qualitative data values of an attribute where created or generated and by whom. A Method helps users understand the procedure that was used to create data and realize its limitations.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

MethodIDInteger

Primary key identifier
MethodNameVarChar(255) Full text name of the method
MethodWebpageVarChar(255)

A URL to a full description of the method
MethodCitationVarChar(500)

a text of the proper citation of the method
MethodTypeCVVarChar(255)

CV term of the method type used to report or generate a data value

DataQualityText

Document the quality of data and any associated uncertainty
PersonIDInteger Foreign key identifier for a person

DescriptionText

Full text description of the method

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_Methods_CV_MethodTypeCVs.CV_MethodTypeMetadata.MethodsNameMethodTypeCV
fk_Methods_PeopleMetadata.PeopleMetadata.MethodsPersonIDPersonID

Triggers

(none)


Used in Diagrams

Diagram Name
01_WaMDaM
02_WaMDaM_WCVs