Customization > Customization Tutorial > Allocate Database Columns for Local Attributes
Allocate Database Columns for Local Attributes
You can create local attributes to store additional information about parts. However, you need to first allocate space for the attributes in the database. You can add columns for each type of attribute for the required data type in the database tables. For future requirements, you can allocate more space than you plan to use immediately.
In this example, we will add five Long type columns to the WTPart table.
Place the SchemaConfig.xml file in the CCD package structure at the following location: <customizationRootDirectory>/generated/db/conf. For more information, see CCD Package Structure.
<?xml version="1.0" encoding="UTF-8"?>
<SchemaConfig>
<!-- AddColumns Utility -->
<StandardAttributeColumns>
<ClassName name="wt.part.WTPart">
<Long count='5'/>
</ClassName>
</StandardAttributeColumns>
</SchemaConfig>
Deploy Customization on Development Environment
For information on the CCD process for deployment, see Deploy Your Customizations on Your Development Environment
Prepare CCD Package for Promotion
For information on the CCD process for promotion, see Deploying Code and Configuration Package.
The new columns are created in the WTPart table. To use them, restart the Windchill Method Server.
Was this helpful?