METHODS - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: METHODS

Columns

PKNameData TypeNULLAutoDefaultCommentFK

METHOD_IDInteger Method used to determine the metric, calculation or estimate.
METHOD_CONTEXTVarChar(20)

The owner of the method. Methods should be registered with the exchange which is managed by ????.
METHOD_NAMEVarChar(20)
METHOD_DESCText

STATEVarChar(10)

METHOD_DATEDateTime

METHOD_TYPEVarChar(10)

TIME_SCALEInteger

METHOD_LINKVarChar(50)

SOURCE_IDInteger

RESOURCE_TYPEVarChar(20)

LOCATION_NAMEVarChar(50)

LAST_CHANGE_DATEDateTime

RETIRED_FLAGVarChar(20)


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_METHODS_DATA_SOURCESMetadata.DATA_SOURCESMetadata.METHODSSOURCE_IDSOURCE_ID

Triggers

(none)


Used in Diagrams

Diagram Name
WaDE_Schema