Many to one to relationship with the MitDetails table. This table is for future use, to allow for additional data fields to be added to the database.
| Field Name | Field Description | Data Type | Field Size* | ProjID | StreamNet project ID. Cross reference to MitProject table | int | 4 | WLID | ID code unique to each work type by location, within a project. Cross reference to MitDetails table. | tinyint | 1 | DetailsID | Treatment type details | smallint | 2 | ParticipantID | Refer to MitParticipant table information | smallint | 2 | Quantity | Quantity or measure of treatment identified in the DetailID field which was conducted by participant | real | 4 | Units | Unit of measure in Quantity field | varchar | 20 | Comments | Comments related to a participant's detailed activities | text | 16 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.