Please enable JavaScript.
Coggle requires JavaScript to display documents.
Observation Reports System (features (Obs report history (Officer can see…
Observation Reports System
Database
Tables
observation_reports
id
auto_increment
primary_key
user_id
varchar
key
constructive_feedback
text
skills
json_string
example
{{
"id": 1,
"score": 3
},
{
"id": 2,
"score": 1
},
{
"id": 3,
"score": 5
}}
score
int
adding up each skill's score
user_rank
int
same as user
duration
int
0 (<30mins)
1 (<60mins)
2 (<90mins)
3 (>90mins)
summary
text
date
supervisor_id
varchar
key
observation_skills
id
int
question
varchar
features
Obs report history
Officer can see their own
feedback
Only RTU / Patrol command
can see
full
report.
New ob report
Checklist
generates score
Rated out of 5 on each topic
Summary of patrol
Management page
Patrol / RTU command
See
edit
supervisor
can see only those that he's submitted
edit
User XP
Supervisor
Submit new report
profile page
provide information
constructive feedback
date
duration
skills
add skill
choose from provided
rate with score
summary
manage submitted reports
see
edit
Officer
profile page
own
Observation Reports tab
table
constructive feedback
supervisor name
date
others
none
Command
manage all reports
see
edit
wireframe
submit
https://image.prntscr.com/image/wbcwwGaBTbe7dyRDBbV7KA.png