Simple Data Dictionary

	A	B	C	D	E	F	J	K	L
1
2
3
4	This sheet enumerates the tables of Simple Server's data model. It lists each 's meaning, type, possible values, and other useful information. These datas are the building blocks that power Simple's dashboard and reporting capabilities.
5
6
7	Model	Field	Type	Constraints	Definition	Sample data

8
9	addresses				Patient address details
10		id	uuid		Unique patient address ID	61dbab2c-ee15-43c7-9abe-6ce28a4c72a5
11		street_address	string		Patient street address	45 Marigold Lane
12		village_or_colony	string		Patient village, colony, etc.	Riverside Village
13		district	string		Patient district, upazila, etc.	Darjeeling
14		zone	string		Patient zone, block, etc.	Pulbazar
15		state	string		Patient state	West Bengal
16		country	string		Patient country	India
17		pin	string		Patient pin, zip code, postal code, etc.	40537
18		created_at	datetime	null: false	When the address was first created on the server	February 14, 2020, 1:34 PM
19		updated_at	datetime	null: false	When the address was last updated on the server	February 14, 2020, 1:34 PM
20		device_created_at	datetime	null: false	When the address was first created in the mobile app	February 14, 2020, 1:34 PM
21		device_updated_at	datetime	null: false	When the address was last updated in the mobile app	February 14, 2020, 1:34 PM
22		deleted_at	datetime		When the address was deleted. Blank if not deleted.
23
24	appointments				Appointments when patients are expected to return for follow up
25		id	uuid		Unique patient appointment ID	8d22600f-33c2-4331-a0a3-35880ab0de31		High	Low
26		patient_id	uuid	null: false	Appointment for this patient ID	0fb55418-3613-466f-8310-6cf40c373c02	High
27		facility_id	uuid	null: false	Appointment to show up at this facility ID	f3d6dd5c-628e-418b-b1be-de8e786a49fc	Low
28		scheduled_date	date	null: false	When the appointment is scheduled	4/15/2020
29		status	string		Appointment status ("scheduled", "canceled", "visited")	scheduled
30		cancel_reason	string		Why the appointment was canceled. Blank if not canceled.
31		remind_on	date		When to start reminding patients to return	4/18/2020
32		agreed_to_visit	boolean		Whether or not the patient agreed to visit (after being reminded)
33		appointment_type	string	null: false	How the appointment was created ("manual" or "automatic")	manual
34		user_id	uuid		User ID who created the appointment	6cdb78a9-7b77-4c80-90b5-bb85b70430f7
35		creation_facility_id	uuid		Facility ID where the appointment was created	f3d6dd5c-628e-418b-b1be-de8e786a49fc
36		created_at	datetime	null: false	When the appointment was first created on the server	February 14, 2020, 1:34 PM
37		updated_at	datetime	null: false	When the appointment was last updated on the server	February 14, 2020, 1:34 PM
38		device_created_at	datetime	null: false	When the appointment was first created in the mobile app	February 14, 2020, 1:22 PM
39		device_updated_at	datetime	null: false	When the appointment was last updated in the mobile app	February 14, 2020, 1:22 PM
40		deleted_at	datetime		When the appointment was deleted. Blank if not deleted.
41
42
43
44
45	audit_logs				DEPRECATED
46		id	uuid		Deprecated
47		action	string	null: false	Deprecated
48		auditable_type	string	null: false	Deprecated
49		auditable_id	uuid	null: false	Deprecated
50		user_id	uuid	null: false	Deprecated
51		created_at	datetime	null: false	Deprecated
52		updated_at	datetime	null: false	Deprecated
53		deleted_at	datetime		Deprecated
54
55	blood_pressures				Blood pressure recording for a patient
56		id	uuid		Unique blood pressure recording ID	63361c3f-aad6-497b-a52b-11255196a07c
57		systolic	integer	null: false	Systolic BP	160
58		diastolic	integer	null: false	Diastolic BP	100
59		patient_id	uuid	null: false	Blood pressure for this patient ID	0fb55418-3613-466f-8310-6cf40c373c02
60		facility_id	uuid	null: false	Facility ID where the blood pressure was recorded	f3d6dd5c-628e-418b-b1be-de8e786a49fc
61		user_id	uuid		User ID that recorded the blood pressure	6cdb78a9-7b77-4c80-90b5-bb85b70430f7
62		recorded_at	datetime		When the blood pressure was actually measured	February 14, 2020, 1:22 PM
63		created_at	datetime	null: false	When the blood pressure was first created on the server	February 14, 2020, 1:34 PM
64		updated_at	datetime	null: false	When the blood pressure was last updated on the server	February 14, 2020, 1:34 PM
65		device_created_at	datetime	null: false	When the blood pressure was first created in the mobile app	February 14, 2020, 1:22 PM
66		device_updated_at	datetime	null: false	When the blood pressure was last updated in the mobile app	February 14, 2020, 1:22 PM
67		deleted_at	datetime		When the blood pressure was deleted. Blank if not deleted.
68
69	blood_sugars				Blood sugar recording for a patient
70		id	uuid		Unique blood sugar recording ID	75e54e9e-b876-454a-b43f-f4d7ca9cb483
71		blood_sugar_type	string	null: false	Type of blood sugar measurement ("random", "post-prandial", "fasting", "hba1c")	random
72		blood_sugar_value	decimal	null: false	Value of blood sugar measurement (in mg/dL if random, post-prandial or fasting, DCCT % if hba1c)	220
73		patient_id	uuid	null: false	Blood sugar for this patient ID	0fb55418-3613-466f-8310-6cf40c373c02
74		user_id	uuid	null: false	User ID that recorded the blood sugar	6cdb78a9-7b77-4c80-90b5-bb85b70430f7
75		facility_id	uuid	null: false	Facility ID where the blood sugar was recorded	f3d6dd5c-628e-418b-b1be-de8e786a49fc
76		device_created_at	datetime	null: false	When the blood sugar was first created in the mobile app	February 14, 2020, 1:22 PM
77		device_updated_at	datetime	null: false	When the blood sugar was last updated in the mobile app	February 14, 2020, 1:22 PM
78		created_at	datetime	null: false	When the blood sugar was first created on the server	February 14, 2020, 1:34 PM
79		updated_at	datetime	null: false	When the blood sugar was last updated on the server	February 14, 2020, 1:34 PM
80		recorded_at	datetime	null: false	When the blood sugar was actually measured	February 14, 2020, 1:22 PM
81		deleted_at	datetime		When the blood sugar was deleted. Blank if not deleted.
82
83	call_logs				Logs of phone calls made by Simple App users to patients
84		id	integer	null: false
85		session_id	string		Exotel session ID for the call
86		result	string		The result of the call ('queued', 'ringing', 'in_progress', 'completed', 'failed', 'busy', 'no_answer', 'canceled', 'unknown')
87		duration	integer		The duration of the phone call
88		callee_phone_number	string	null: false	Phone number of the patient that received the call
89		caller_phone_number	string	null: false	Phone number of the Simple user that initiated the call
90		start_time	datetime		When the phone call started
91		end_time	datetime		When the phone call ended
92		created_at	datetime	null: false	When the call log was first created on the server
93		updated_at	datetime	null: false	When the call log was last updated on the server
94		deleted_at	datetime		When the call log was deleted. Blank if not deleted.
95
96	communications
97		id	uuid		Unique communication ID	3069d916-057a-493f-9c0d-6014bd756aaf
98		appointment_id	uuid	null: false	Appointment ID of the appointment that the user was following up with the patient for	8d22600f-33c2-4331-a0a3-35880ab0de31
99		user_id	uuid		User ID of the Simple user that made the communication
100		communication_type	string		The type of communication made to the patient ('voip_call', 'manual_call', 'missed_visit_sms_reminder')	missed_visit_sms_reminder