Difference between revisions of "Education Details Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "{{Note | The Education child table for Education details is called ''mredetail'' and the entity type is called ''MRE_DETAIL''. }} {| |- valign="top" | Image:Uncategorised.pn...")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Note | The Education child table for Education details is called ''mredetail'' and the entity type is called ''MRE_DETAIL''. }}
+
{{Note | The Education child table for Education details is called ''mredetail'', the target is called ''Mredetailversion'' and the entity type is called ''MRE_DETAIL''. }}
 
{|
 
{|
 
|- valign="top"
 
|- valign="top"
Line 8: Line 8:
 
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name'
 
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name'
 
|-
 
|-
| Audience Age Info || Single-select ||  AgeRangeEnum_GUID || Age Range || AgeRange
+
| Audience Age Info || Single-select ||  agerangeenum_guid|| Age Range || AgeRange
 
|-
 
|-
 
| Military Audience || Single-select ||  audiencemilitary_guid || AudienceMilitary || AudienceMilitary
 
| Military Audience || Single-select ||  audiencemilitary_guid || AudienceMilitary || AudienceMilitary
Line 14: Line 14:
 
| Mine Action Personnel Audience || Single-select ||  audiencepersonnel_guid || AudiencePersonnel || AudiencePersonnel
 
| Mine Action Personnel Audience || Single-select ||  audiencepersonnel_guid || AudiencePersonnel || AudiencePersonnel
 
|-
 
|-
| Audience || Single-select ||  AudienceTypeEnum_GUID || Audience Type || AudienceType
+
| Audience || Single-select ||  audiencetypeenum_guid|| Audience Type || AudienceType
 
|-
 
|-
| Inactive || - ||  audiencetypeother ||  || AudienceTypeOther
+
| ''Inactive'' || - ||  audiencetypeother ||  || AudienceTypeOther
 
|-
 
|-
| % Female || Numeric ||  FemalePercentage ||  || FemalePercentage
+
| % Female || Numeric ||  femalepercentage||  || FemalePercentage
 
|-
 
|-
| % Male || Numeric ||  MalePercentage ||  || MalePercentage
+
| % Male || Numeric ||  malepercentage||  || MalePercentage
 
|-
 
|-
| - || Parent ||  MRE_GUID ||  || Mre
+
| - || Parent ||  mre_guid||  || Mre
 
|-
 
|-
| - || String ||  MREDetail_GUID ||  || Guid
+
| - || String ||  mredetail_guid||  || Guid
 
|-
 
|-
 
| Education Sub Type || Single-select ||  mresubtypeenum_guid || MRESubType || MreSubType
 
| Education Sub Type || Single-select ||  mresubtypeenum_guid || MRESubType || MreSubType
 
|-
 
|-
| Education Type || Single-select ||  MRETypeEnum_GUID || MRE Type || MreType
+
| Education Type || Single-select ||  mretypeenum_guid|| MRE Type || MreType
 
|-
 
|-
| Where did the activity take place? || Place ||  Place_GUID ||  || Place
+
| Where did the activity take place? || Place ||  place_guid||  || Place
 
|-
 
|-
| Total Audience Number || Integer ||  TotalAudience ||  || TotalAudience
+
| Total Audience Number || Integer ||  totalaudience||  || TotalAudience
 
|}
 
|}
  

Latest revision as of 10:18, 1 November 2018

Note.jpg The Education child table for Education details is called mredetail, the target is called Mredetailversion and the entity type is called MRE_DETAIL.

Uncategorised.png

DIM Label Data type Database column name Enumcategory Pojo name'
Audience Age Info Single-select agerangeenum_guid Age Range AgeRange
Military Audience Single-select audiencemilitary_guid AudienceMilitary AudienceMilitary
Mine Action Personnel Audience Single-select audiencepersonnel_guid AudiencePersonnel AudiencePersonnel
Audience Single-select audiencetypeenum_guid Audience Type AudienceType
Inactive - audiencetypeother AudienceTypeOther
 % Female Numeric femalepercentage FemalePercentage
 % Male Numeric malepercentage MalePercentage
- Parent mre_guid Mre
- String mredetail_guid Guid
Education Sub Type Single-select mresubtypeenum_guid MRESubType MreSubType
Education Type Single-select mretypeenum_guid MRE Type MreType
Where did the activity take place? Place place_guid Place
Total Audience Number Integer totalaudience TotalAudience