The lookup table containing dam purpose descriptions.
| Field Name | Field Description | Data Type | Field Size* | DamPurposeID | The primary key for table DamPurpose | tinyint | 1 | DamPurpose | The uses or purposes of the project (hydropower, water supply, recreation, etc.) | varchar | 50 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.