Difference between revisions of "Accident Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
Line 12: Line 12:
 
| Accident Description||Text|| accidentdescription||||AccidentDescription
 
| Accident Description||Text|| accidentdescription||||AccidentDescription
 
|-
 
|-
−
| Accident ID||String|| Accident_LocalID||||LocalId
+
| Accident ID||String|| accident_localid||||LocalId
 
|-
 
|-
−
| Accident Type||Single-select|| AccidentTypeEnum_GUID||Accident Type||Type
+
| Accident Type||Single-select|| accidenttypeenum_guid||Accident Type||Type
 
|-
 
|-
 
| Area Marked||Single-select|| areamarked_guid||Yes No Answer||AreaMarked
 
| Area Marked||Single-select|| areamarked_guid||Yes No Answer||AreaMarked
Line 24: Line 24:
 
| Confirmed||Single-select|| confirm_guid||Yes No Answer||Confirm
 
| Confirmed||Single-select|| confirm_guid||Yes No Answer||Confirm
 
|-
 
|-
−
| Date of Accident||Date|| DateOfAccident||||DateOfAccident
+
| Date of Accident||Date|| dateofaccident||||DateOfAccident
 
|-
 
|-
 
| Description of ref area||Text|| hazardrefdescription||||HazardRefDescription
 
| Description of ref area||Text|| hazardrefdescription||||HazardRefDescription
Line 52: Line 52:
 
| Number of Persons Involved||Integer|| numberpersoninvolved||||NumberPersonInvolved
 
| Number of Persons Involved||Integer|| numberpersoninvolved||||NumberPersonInvolved
 
|-
 
|-
−
| Organisation||Organisation|| Org_GUID||||Organisation
+
| Organisation||Organisation|| org_guid||||Organisation
 
|-
 
|-
 
| Reliability of Information||Single-select|| inforeliability_guid||InformationReliability||InfoReliability
 
| Reliability of Information||Single-select|| inforeliability_guid||InformationReliability||InfoReliability

Revision as of 12:13, 15 October 2016

Note.jpg The table is called accident and the entity type is called Accident.

Uncategorised.png

DIM Label Data type Database column name Enumcategory Pojo name
Accident Cause Multi-select AccidentCause AccidentCauses
Accident Description Text accidentdescription AccidentDescription
Accident ID String accident_localid LocalId
Accident Type Single-select accidenttypeenum_guid Accident Type Type
Area Marked Single-select areamarked_guid Yes No Answer AreaMarked
Area Officer String areaofficer AreaOfficer
Clearance In Progress? Single-select clearanceinprogress_guid Yes No Answer ClearanceInProgress
Confirmed Single-select confirm_guid Yes No Answer Confirm
Date of Accident Date dateofaccident DateOfAccident
Description of ref area Text hazardrefdescription HazardRefDescription
Direction From Nearest Town Single-select directionfromnearesttown_guid DirectionFromCity DirectionFromNearestTown
Distance from Nearest Town String distancefromnearesttown DistanceFromNearestTown
How Ordnance Activated Single-select how_ordnance_activated How Ordnance Activated HowOrdnanceActivated
Inactive Text directionfromnearesttown DirectionFromNearestTownOther
Inactive String hazardref_guid HazardRef
Inactive String macid Macid
Inactive varchar maactivityother MaActivityOther
Inactive String maactivityref_guid MaActivityRef
Inactive Text comments
Inquiry Report Reference Text inquiryreportreference InquiryReportReference
Municipality String municipality Municipality
Number of Persons Involved Integer numberpersoninvolved NumberPersonInvolved
Organisation Organisation org_guid Organisation
Reliability of Information Single-select inforeliability_guid InformationReliability InfoReliability
Reliability of Source Single-select sourcereliability_guid SourceReliability SourceReliability
Source String source Source
Time of Accident Single-select time_of_accident Time Of Accident TimeOfAccident
Type of Area Single-select areatype_guid AreaType AreaType
Type of Hazardous Area Single-select dangerousareatype_guid DangerAreaType DangerousAreaType
Was the Ordnance Moved Before the Accident? Single-select was_the_ordnance_moved_before_the_accident Yes No Answer WasTheOrdnanceMovedBeforeTheAccident
Item Data
DEFs
Geo data
Task
Auxiliary Data
Other
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Accident_Uncategorised&oldid=22284"