WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
It is the central table in WaM-DaM which maps out data values to their attributes, metadata, and organizing structure (i.e., MasterNetworks, Scenarios, ObjectTypes, Instances, and Dataset). Therefore the Mapping table is often used to query data from WaMDaM database.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| MappingID | Integer |
| Primary key identifier | |||
| AttributeID | Integer | Foreign key identifier for an Attribute |
|
||||
| InstanceID | Integer | Foreign key identifier for an Instance |
|
||||
| SourceID | Integer | Foreign key identifier for a Source |
|
||||
| MethodID | Integer | Foreign key identifier for a Method |
|
||||
| ValuesMapperID | Integer |
| Foreign key identifier for a Value Mapper record |
|
|||
| Verified | VarChar(5) |
| Verified or not. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Mappings_Attributes | ResourceStruct.Attributes | NetScen.Mappings | AttributeID | AttributeID |
| fk_Mappings_Instances | NetScen.Instances | NetScen.Mappings | InstanceID | InstanceID |
| fk_Mappings_Methods | Metadata.Methods | NetScen.Mappings | MethodID | MethodID |
| fk_Mappings_Sources | Metadata.Sources | NetScen.Mappings | SourceID | SourceID |
| fk_Mappings_ValuesMapper | DataValues.ValuesMapper | NetScen.Mappings | ValuesMapperID | ValuesMapperID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |