WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
It is a bridge tables that allow associating many Object Types with many attributes. Users also can share the same native attribute across different object types like Capital Cost attribute that is shared for all the WEAP Objects
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AttributeID | Integer |
| Primary key identifier | |||
| AttributeName | VarChar(255) | The name of the attribute | |||||
| AttributeName_Abstract | VarChar(255) |
| An optional field that binds any different attribute implementations that include units and datatypes such as “storage_AF” and “storage-gallons” into a general concept “storage”. Attribute name as-is in the model without adding abbrto it as in WEAP to count for different versions of the same attribute that have different unit or data type | ||||
| AttributeNameCV | VarChar(255) |
| CV term for a universal attribute name |
|
|||
| ObjectTypeID | Integer | Foreign key identifier to the ObjectType that the attribute belongs to |
|
||||
| UnitName | VarChar(255) | Unit name as used negatively in the dataset | |||||
| UnitNameCV | VarChar(255) |
| CV term for a universal unit name |
|
|||
| AttributeScale | Integer |
| 1 | A multiplier of the attribute values as used in WEAP. The default is 1. It takes values like 1000000 for a million. | |||
| AttributeDataTypeCV | VarChar(255) | CV term for a list of supported data types in WaMDAM: DualValue, NumericValue, SeasonalNumericValues, DescriptorValue, ElectronicFiles, TimeSeries, and MultAttributeSeries |
|
||||
| AttributeCategoryID | Integer |
| Foreign key identifier to the category that the ObjectType belongs to |
|
|||
| ModelInputOrOutput | Char(50) |
| Distinguishs input and output attributes in models | ||||
| Description | Text |
| Full text description of the attribute |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Attributes_CV_AttributeName | CVs.CV_AttributeName | ResourceStruct.Attributes | Name | AttributeNameCV |
| fk_Attributes_CV_AttributeType | CVs.CV_AttributeDataType | ResourceStruct.Attributes | Name | AttributeDataTypeCV |
| fk_Attributes_CV_Units | CVs.CV_Units | ResourceStruct.Attributes | Name | UnitNameCV |
| fk_Attributes_ObjectTypes | ResourceStruct.ObjectTypes | ResourceStruct.Attributes | ObjectTypeID | ObjectTypeID |
| fk_ObjectAttributes_AttributeCategory | ResourceStruct.AttributeCategories | ResourceStruct.Attributes | AttributeCategoryID | AttributeCategoryID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |