Difference between revisions of "Task Child Tables"

From IMSMA Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
|- valign="top"
 
|- valign="top"
 
|
 
|
[[Image:Uncategorised.png|100px]]
+
[[Image:Task category.png|100px]]
 +
|
 +
{| class="wikitable sortable"
 +
! colspan="5" | task_has_objective
 +
|-
 +
! Function !! Data type !! Database column name !! Enumcategory !! Pojo name
 +
|-
 +
| - || String ||  hazard_guid||  ||
 +
|-
 +
| - || Parent ||  task_guid ||  ||
 +
|}
 +
|}
 +
{|
 +
|- valign="top"
 +
|
 +
[[Image:Task category.png|100px]]
 
|
 
|
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
Line 26: Line 41:
 
|- valign="top"
 
|- valign="top"
 
|
 
|
[[Image:Uncategorised.png|100px]]
+
[[Image:Task category.png|100px]]
 
|
 
|
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
Line 41: Line 56:
 
| - || Parent ||  task_guid ||  || Task
 
| - || Parent ||  task_guid ||  || Task
 
|}
 
|}
 +
|}
 +
 +
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 11:17, 16 March 2016

Note.jpg The child tables of Task are not visible in the Data Inventory Manager.

Task category.png

task_has_objective
Function Data type Database column name Enumcategory Pojo name
- String hazard_guid
- Parent task_guid

Task category.png

task_related_item
Function Data type Database column name Enumcategory Pojo name
- String guid Guid
Reference String reference_guid ReferenceGuid
Pojo name String reference_type ReferenceType
Note Text relationship_notes RelationshipNotes
- Parent task_guid Task

Task category.png

task_status_history
Function Data type Database column name Enumcategory Pojo name
- String guid Guid
Reason Text reason Reason
Status Single-select status_guid Task Status Status
- Parent task_guid Task