Schema Maps - What data and how it is stored in a directory varies from directory to directory, therefore we need to give the user a list of the attributes we are interested in and ask them how these attributes map to their directory. This table holds the details of those mappings.
Each row in the schema map table using the same UUID represents one mapped attribute for that particular schema. This way you can add any number of mappings dynamically
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dir_schema_uuid | byte(16) | not null | UUID of a directory schema definition |
| dir_schema_map_name | nvarchar(255) | with null | Map name |
| itrm_attrib | nvarchar(255) | with null | Itrm's attribute name |
| dir_attrib | nvarchar(255) | with null | Directory attribute name |
| creation_user | nvarchar(64) | with null | Creation user |
| creation_date | integer | with null | Creation date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date. |
| version_number | integer | with null | Last version number |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| dir_schema_uuid | ca_link_dir_details_map | dir_schema_uuid |