DamXDamType Table

This table contains information about the defined types of the dam. There is a many to one relationship with the Dam table via the DamXDamType table.

Field Name Field Description Data Type Field Size*
DamID The dam ID, foreign key to table Dam int 4
DamTypeID The damtype ID, foreign key to table DamType tinyint 1
UpdDate The date and time the record was created or updated by agency compiler. smalldatetime 4

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.


Revised Wednesday September 28 2005