Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
track_anything_type_id | BIGINT | 19 | √ | null |
|
|
||||||||
name | VARCHAR | 255 | √ | null |
|
|
The name of the type of the data element being tracked |
|||||||
description | VARCHAR | 255 | √ | null |
|
|
Description of the data element type being tracked |
|||||||
parent | BIGINT | 19 | √ | null |
|
|
This is a reference to a parent form_track_anything_type element. 0=There is no parent, if !0 then it is the track_anything_type_id for the parent element |
|||||||
position | INT | 10 | √ | null |
|
|
The order this element should be filled out in the track anything population mechanism |
|||||||
active | INT | 10 | √ | null |
|
|
1=The element is active and allows for data entry, 0=data entry is disabled and the element is not displayed to the user |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | track_anything_type_id |