| Purpose | This element carries the mapping information for
a node in the XML sub-tree that is mapped to a single SQL column. To be used to
specify mapping for logical child nodes of a logical node mapped via
tsd:subTreeSQL.
|
| Parent element | tsd:map |
| Child elements | None |
| Attributes | column |
| Name | Type | Description |
|---|---|---|
column |
xs:string |
This attribute specifies the column in an SQL database to which an element or attribute in the Tamino database is mapped. |
The following code fragment of a Tamino schema definition shows the code necessary to define a mapping of an element to an SQL column "Last Name" via X-Node:
<xs:element name = "lastname" type = "xs:string">
<xs:annotation>
<xs:appinfo>
<tsd:elementInfo>
<tsd:logical>
.
.
.
</tsd:logical>
<tsd:physical>
<tsd:map>
<tsd:nodeSQL column = "Last Name"></tsd:nodeSQL>
</tsd:map>
</tsd:physical>
</tsd:elementInfo
</xs:appinfo>
</xs:annotation>
</xs:element>
