{"info":{"_postman_id":"d8645b7e-e5c1-4ed2-9816-95807d417cb7","name":"Daycare Management System","description":"

Daycare API V1.0

This API is for a daycare management system. The API provides access to the following data:

Admin
Caretaker
Child
Daycare
Employee
Parent_guardian
Person
Room

Overview

Authorization Basic Auth
\n
You need a valid username and password to send requests to the API endpoints. There are three main types of security clearance levels: high, medium, and low. The account must have the right privileges to make the call. An account with high privileges can access all three types, a medium can also access low, and an account with low privileges can only access endpoints that require low clearance level.
\n
The request body is of type JSON and the response to every request is also sent in JSON format.
\n
When applicable (i.e. sending GET requests), you can limit the number of records returned from the API call by using the optional parameter, limit, in the endpoint URL. If the optional parameter is not specified, then the max default number of records to return is 100.
\n
The API calls will respond with appropriate HTTP status codes for all requests. A 200 OK indicates all went well. A 201 Created means successfully inserted row, and if there is anything wrong, a 400 Bad Request will be sent. There is also 405 Method Not Allowed if you use the wrong request method, and finally there is 401 Unauthorized if you don't have the right credentials.
\n

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"13545898","collectionId":"d8645b7e-e5c1-4ed2-9816-95807d417cb7","publishedId":"TVmLDe7R","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-12-02T01:03:11.000Z"},"item":[{"name":"Admin","item":[{"name":"Add an Employee","id":"c6541e59-3146-4bf3-830a-1b060408c39b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"DaycareName\": \"Daycare Two\",\n \"DaycareAddress\": \"Other Daycare Street\",\n \"SIN\": \"11122233\",\n \"EmployeeId\": 3009,\n \"WorkHours\": 40,\n \"HourlyRate\": 17.3\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addEmployee.php","description":"

Add an employee to the database.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
DaycareName	varchar(100)	required
DaycareAddress	varchar(100)	required
SIN	varchar(8)	required
EmployeeId	int(11)	required
WorkHours	decimal(4,2)	required
HourlyRate	decimal(5,2)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","addEmployee.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"092dbf2a-7e6b-463d-ab10-b1bfe4d0dbf5","name":"Created - Successfully created employee","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"DaycareName\": \"Daycare Two\",\n \"DaycareAddress\": \"Other Daycare Street\",\n \"SIN\": \"11122233\",\n \"EmployeeId\": 3009,\n \"WorkHours\": 40,\n \"HourlyRate\": 17.3\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addEmployee.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 20:07:04 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"40"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Employee has been added.\"\n}"},{"id":"90df5e88-de10-45ff-869a-566eee718bd7","name":"Bad Request - Failed to Add an Employee (Wrong Length)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"DaycareName\": \"Daycare Two\",\n \"DaycareAddress\": \"Other Daycare Street\",\n \"SIN\": \"11122233888888\",\n \"EmployeeId\": 3009,\n \"WorkHours\": 40,\n \"HourlyRate\": 17.3\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addEmployee.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:33:06 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"85"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add employee. Data length does not match the defined model.\"\n}"},{"id":"cf183dff-a971-441f-9910-951094e54c2c","name":"Bad Request - Failed to Add an Employee (Wrong Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"DaycareName\": \"Daycare Two\",\n \"DaycareAddress\": \"Other Daycare Street\",\n \"SIN\": \"11122233adjdf\",\n \"EmployeeId\": 3009,\n \"WorkHours\": 40,\n \"HourlyRate\": 17.3\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addEmployee.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:34:10 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"65"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add employee. Data type is not correct.\"\n}"},{"id":"dca06520-0561-44e1-9ede-4532da200b24","name":"Method Not Allowed - Failed to Add an Employee","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"DaycareName\": \"Daycare Two\",\n \"DaycareAddress\": \"Other Daycare Street\",\n \"SIN\": \"11122233\",\n \"EmployeeId\": 3009,\n \"WorkHours\": 40,\n \"HourlyRate\": 17.3\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addEmployee.php"},"status":"Method Not Allowed","code":405,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:35:18 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"47"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Request method GET not allowed.\"\n}"}],"_postman_id":"c6541e59-3146-4bf3-830a-1b060408c39b"},{"name":"Update Employee Payroll","id":"7b59164f-2e0d-41ce-ad3e-44e2a51428f8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"PUT","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeSIN\": \"44433222\",\r\n \"WorkHours\": 40,\r\n \"HourlyPay\": 50.25\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/employeePayroll.php","description":"

Admin can update employee payroll information.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
EmployeeSIN	varchar(8)	required
WorkHours	decimal(4,2)	required
HourlyPay	decimal(5,2)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","employeePayroll.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"4010ef50-5542-4f38-a172-03316d48e3ec","name":"OK - Successfully Update Employee Payroll","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeSIN\": \"44433222\",\r\n \"WorkHours\": 40,\r\n \"HourlyPay\": 50.25\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/employeePayroll.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 18:08:33 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"PUT"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"53"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Employee payroll info has been updated.\"\n}"},{"id":"90553ed0-b356-4479-be16-5c6aafe1ccd7","name":"Bad Request - Failed to Update Employee Payroll","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeSIN\": \"abcd\",\r\n \"WorkHours\": 40,\r\n \"HourlyPay\": 50.25\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/employeePayroll.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 18:09:01 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"PUT"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"79"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to update employee payroll info. Data type is not correct.\"\n}"}],"_postman_id":"7b59164f-2e0d-41ce-ad3e-44e2a51428f8"},{"name":"Remove an Employee","id":"735b51d1-3ed8-4c69-9995-f3801b0e9f64","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": 3009\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/removeEmployee.php","description":"

Remove an employee from the database.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
EmployeeId	int(11)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","removeEmployee.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"6ed30e9e-db33-45f2-a5a5-b189e64f59b1","name":"OK - Successfully Remove an Employee","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": 3009\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/removeEmployee.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 19:32:16 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"DELETE"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"42"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Employee has been removed.\"\n}"},{"id":"e4621d31-d9eb-46ad-8a8f-faa6a1906c59","name":"Bad Request - Failed to Remove an Employee (Wrong Data Type)","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/removeEmployee.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 19:33:25 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"DELETE"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"68"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to remove employee. Data type is not correct.\"\n}"}],"_postman_id":"735b51d1-3ed8-4c69-9995-f3801b0e9f64"},{"name":"Create Bill","id":"a1d00b5c-7341-400a-8704-b857df50874f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"BillId\": 1001,\n \"CreatedById\": 1234,\n \"PaymentMethod\": \"Cash\",\n \"AmountPending\": 1000.00\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addBill.php","description":"

The admin creates bills for parents when they enroll their child in the daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
BillId	int(11)	required
CreatedById	int(11)	required
PaymentMethod	varchar(30)	optional
AmountPending	decimal(6,2)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","addBill.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"1ec02057-940e-4566-8d0a-bbe2f52906bd","name":"Bad Request - Failed to Create Bill (Wrong Data Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"BillId\": \"abcd\",\n \"CreatedById\": 1234,\n \"PaymentMethod\": \"Cash\",\n \"AmountPending\": 1000.00\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addBill.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 19:37:03 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"64"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to create bill. Data type is not correct.\"\n}"},{"id":"6249882d-439e-4811-bfea-2f2f826aae1f","name":"Created - Successfully Create Bill (Optional Parameter)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"BillId\": 1002,\n \"CreatedById\": 1234,\n \"AmountPending\": 1000.00\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addBill.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 19:36:24 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"38"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Bill has been created.\"\n}"},{"id":"82c9259c-38fe-4c68-8794-763add41cc02","name":"Created - Successfully Created Bill","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"BillId\": 1001,\n \"CreatedById\": 1234,\n \"PaymentMethod\": \"Cash\",\n \"AmountPending\": 1000.00\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/addBill.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 20:46:36 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"38"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Bill has been created.\"\n}"}],"_postman_id":"a1d00b5c-7341-400a-8704-b857df50874f"},{"name":"Update Bill","id":"9e20d676-aa78-416b-8f97-975f8449fd51","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"PUT","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434,\r\n \"AmountPending\": 0\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/updateBill.php","description":"

The admin can update billing info for the parent.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
BillId	int(11)	required
AmountPending	decimal(6,2)	optional

If AmountPending is not included in the parameters then it means the amount is 0.

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","updateBill.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"22cba3a5-fd58-43c1-a9a2-8196c1fca8ee","name":"OK - Successfully Update Bill","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434,\r\n \"AmountPending\": 0\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/updateBill.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 17:41:31 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"PUT"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"36"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Bill has been updated.\"\n}"},{"id":"66029670-f848-48c5-aea9-2f6e33b6afc3","name":"Bad Request - Failed to Update Bill","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": \"abcd\",\r\n \"AmountPending\": 0\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/updateBill.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 17:41:59 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"PUT"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"62"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to update bill. Data type is not correct.\"\n}"},{"id":"808d9fba-c6a1-427c-bcfb-8ad5ed7af1ed","name":"OK - Successfully Update Bill (No Optional Parameters)","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/updateBill.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Fri, 04 Dec 2020 00:49:28 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"PUT"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"36"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Bill has been updated.\"\n}"}],"_postman_id":"9e20d676-aa78-416b-8f97-975f8449fd51"},{"name":"Add Child to Waitlist","id":"b752ad6e-4eeb-4aaa-a734-9f5f7c907398","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"ChildFirstName\": \"Allan\",\n \"ChildLastName\": \"Johnson\",\n \"SubmittedById\": 1234 \n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/waitlist.php","description":"

The admin manages the daycare child waitlist and adds children to it.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildFirstName	varchar(30)	required
ChildLastName	varchar(30)	required
SubmittedById	int(11)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","admin","waitlist.php"],"host":["localhost"],"query":[{"disabled":true,"key":"","value":null}],"variable":[]}},"response":[{"id":"67ab9ffa-015b-46ab-b9d2-dc2f0ece3ac0","name":"Created - Successfully Added Child to Waitlist","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"ChildFirstName\": \"Allan\",\n \"ChildLastName\": \"Johnson\",\n \"SubmittedById\": 1234 \n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/waitlist.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 20:47:13 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"40"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Child added to waitlist.\"\n}"},{"id":"e8036f68-c210-4bf0-8f0b-e4aec47ff9cf","name":"Bad Request - Failed to Add Child to Waitlist (Missing Data)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"ChildFirstName\": \"Allan\",\n \"ChildLastName\": \"Johnson\"\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/admin/waitlist.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 18:16:25 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"62"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add to waitlist. Data is incomplete.\"\n}"}],"_postman_id":"b752ad6e-4eeb-4aaa-a734-9f5f7c907398"}],"id":"9913c030-1453-4897-b0ba-a0548e7ed7c7","description":"

An Admin is an employee with more privileges than other users of the daycare system. They manage simple administrative daycare operations such adding or removing employees, and updating costs for childcare.

Contains the following requests:

Add an employee
Update employee payroll
Remove an employee
Create a bill
Update bill
Add child to waitlist

\n","_postman_id":"9913c030-1453-4897-b0ba-a0548e7ed7c7"},{"name":"Caretaker","item":[{"name":"Add Report","id":"40f42b02-163a-4988-af95-acefccd03cf1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportId\": 161,\r\n \"EmployeeId\": 5555,\r\n \"ReportDate\": \"2020-12-01\",\r\n \"ScheduleStartTime\": \"12:00:00\",\r\n \"ScheduleEndTime\": \"17:30:00\",\r\n \"ReportComment\": \"Was with child the entire day. Child ate on time. Made fun of other kids.\",\r\n \"LessonsLearned\": \"Knows what a kinkajou is.\",\r\n \"ActionRequired\": \"Needs bladder training.\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/caretaker/addReport.php","description":"

Create a daily report for a child and comment any special event worth mentioning. This also includes the child, their caretaker, and the times the caretaker was with them.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required
ReportId	int(11)	required
EmployeeId	int(11)	required
ReportDate	date	required
ScheduleStartTime	time	required
ScheduleEndTime	time	required
ReportComment	varchar(1000)	optional
LessonsLearned	varchar(100)	optional
ActionRequired	varchar(100)	optional

Account clearance level required to use this endpoint: Medium.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","caretaker","addReport.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"13b0604f-a852-4849-b1a8-96d67cebd0e5","name":"Created - Successfully Added Report","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportId\": 161,\r\n \"EmployeeId\": 5555,\r\n \"ReportDate\": \"2020-12-01\",\r\n \"ScheduleStartTime\": \"12:00:00\",\r\n \"ScheduleEndTime\": \"17:30:00\",\r\n \"ReportComment\": \"Was with child the entire day. Child ate on time. Made fun of other kids.\",\r\n \"LessonsLearned\": \"Knows what a kinkajou is.\",\r\n \"ActionRequired\": \"Needs bladder training.\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/caretaker/addReport.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:17:45 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"38"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Report has been added.\"\n}"},{"id":"abbb0138-cfec-4e97-a108-3fce74d91a45","name":"Bad Request - Failed to Add Report (Wrong Data Length)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"abcd\",\r\n \"ReportId\": 161,\r\n \"EmployeeId\": 5555,\r\n \"ReportDate\": \"2020-12-01\",\r\n \"ScheduleStartTime\": \"12:00:00\",\r\n \"ScheduleEndTime\": \"17:30:00\",\r\n \"ReportComment\": \"Was with child the entire day. Child ate on time. Made fun of other kids.\",\r\n \"LessonsLearned\": \"Knows what a kinkajou is.\",\r\n \"ActionRequired\": \"Needs bladder training.\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/caretaker/addReport.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:18:28 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"83"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add report. Data length does not match the defined model.\"\n}"}],"_postman_id":"40f42b02-163a-4988-af95-acefccd03cf1"},{"name":"Get Report","id":"0d6394dc-e86e-4739-842e-81b472ce0f57","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"CaretakerEmployeeId\": 5555,\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportDate\": \"2020-01-01\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/caretaker/getReport.php?limit=10","description":"

A caretaker can view the daily report for a child they previously submitted.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
CaretakerEmployeeId	int(11)	required
ChildSIN	varchar(8)	required
ReportDate	date	required

Account clearance level required to use this endpoint: Medium.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","caretaker","getReport.php"],"host":["localhost"],"query":[{"key":"limit","value":"10"}],"variable":[]}},"response":[{"id":"5427c56b-7317-4234-8dea-eb46d2ce8be3","name":"OK - Successfully Get Report (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"CaretakerEmployeeId\": 5555,\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportDate\": \"2020-01-01\"\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/caretaker/getReport.php?limit=10","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","caretaker","getReport.php"],"query":[{"key":"limit","value":"10"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:14:34 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"265"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"ChildSIN\": \"11111111\",\n \"ReportDate\": \"2020-01-01\",\n \"ScheduleStartTime\": \"10:00:00\",\n \"ScheduleEndTime\": \"13:00:00\",\n \"ReportComment\": \"Child took medication at 2pm. All day child did a good job!\",\n \"LessonsLearned\": \"Learned about space and aliens\",\n \"ActionRequired\": null\n }\n]"},{"id":"e12489dd-1e07-4cf5-8a47-ac1382a3e250","name":"OK - Successfully Get Report","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"CaretakerEmployeeId\": 5555,\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportDate\": \"2020-01-01\"\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/caretaker/getReport.php","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","caretaker","getReport.php"],"query":[{"key":"limit","value":"10","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:32:57 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"69"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"ChildSIN\": \"11111111\",\n \"ReportDate\": \"2020-01-01\",\n \"ScheduleStartTime\": \"10:00:00\",\n \"ScheduleEndTime\": \"13:00:00\",\n \"ReportComment\": \"Child took medication at 2pm. All day child did a good job!\",\n \"LessonsLearned\": \"Learned about space and aliens\",\n \"ActionRequired\": null\n }\n]"},{"id":"ed8eb95a-fb21-492c-9bce-9b4eacfb95b8","name":"Bad Request - Failed to Get Report (Wrong Data Type)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"CaretakerEmployeeId\": \"abcd\",\r\n \"ChildSIN\": \"11111111\",\r\n \"ReportDate\": \"2020-12-01\"\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/caretaker/getReport.php?limit=10","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","caretaker","getReport.php"],"query":[{"key":"limit","value":"10","type":"text"}]}},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:34:16 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"64"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get reports. Data type is not correct.\"\n}"}],"_postman_id":"0d6394dc-e86e-4739-842e-81b472ce0f57"}],"id":"a937cb95-f555-42d9-8006-9100d579cc71","description":"

A caretaker is an employee who takes care of the children. A caretaker has privileges to create and get the daily reports for each child. A caretaker takes care of children and keeps track of their special restrictions and general behaviour.

Contains the following requests:

Add report
Get report

\n","_postman_id":"a937cb95-f555-42d9-8006-9100d579cc71"},{"name":"Child","item":[{"name":"Add Special Condition","id":"c667b3a3-f4c8-4147-80ad-9d87ded5993b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"55566777\",\r\n \"ConditionName\": \"Crohn’s Disease\",\r\n \"ConditionTreatment\": \"Carbohydrate Diet\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/child/addCondition.php","description":"

Add any medical condition, concerns, or social restrictions a child may have so that the caretaker can treat the child appropriately.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required
ConditionName	varchar(100)	required
ConditionTreatment	varchar(100)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","child","addCondition.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"046ba360-ca1f-4ebd-9ce8-9cf229ce17d4","name":"Created - Successfully Add Medical Condition","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"55566777\",\r\n \"ConditionName\": \"Crohn’s Disease\",\r\n \"ConditionTreatment\": \"Carbohydrate Diet\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/addCondition.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 16:40:42 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"45"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Child condition has been added.\"\n}"},{"id":"1c68673b-86a2-4e0e-abda-0ba0bc6016e0","name":"Bad Request - Failed to Add Medical Condition (Wrong Data Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"abcd\",\r\n \"ConditionName\": \"Crohn’s Disease\",\r\n \"ConditionTreatment\": \"Carbohydrate Diet\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/addCondition.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 16:41:07 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"65"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add conditions. Data type is not correct.\"\n}"}],"_postman_id":"c667b3a3-f4c8-4147-80ad-9d87ded5993b"},{"name":"Get Condition","id":"e046d393-51ed-49b2-8f06-39d3dbb52816","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"55566777\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/child/getCondition.php?limit=10","description":"

Get the condition or restriction (if any) for a child.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","child","getCondition.php"],"host":["localhost"],"query":[{"key":"limit","value":"10"}],"variable":[]}},"response":[{"id":"3bc35944-a604-4deb-932d-890613a4eb33","name":"Bad Request - Failed to Get Condition (Wrong Data Type)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/getCondition.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:42:12 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"67"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get conditions. Data type is not correct.\"\n}"},{"id":"cf0fc6de-ea02-4cb6-9eec-01c8da67a898","name":"OK - Successfully Get Condition","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"55566777\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/getCondition.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:41:46 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"242"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"Asthma\",\n \"ConditionTreatment\": \"Inhaler\"\n },\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"Crohn’s Disease\",\n \"ConditionTreatment\": \"Carbohydrate Diet\"\n },\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"OCD\",\n \"ConditionTreatment\": \"Monitor Actions\"\n }\n]"},{"id":"fd1a0300-ceae-44ea-b952-b95f975c65e5","name":"OK - Successfully Get Condition (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"55566777\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/child/getCondition.php?limit=10","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","child","getCondition.php"],"query":[{"key":"limit","value":"10"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:23:24 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"381"},{"key":"Keep-Alive","value":"timeout=5, max=97"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"Asthma\",\n \"ConditionTreatment\": \"Inhaler\"\n },\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"Crohn’s Disease\",\n \"ConditionTreatment\": \"Carbohydrate Diet\"\n },\n {\n \"SIN\": \"55566777\",\n \"FirstName\": \"A Child\",\n \"LastName\": \"Person\",\n \"ConditionName\": \"OCD\",\n \"ConditionTreatment\": \"Monitor Actions\"\n }\n]"}],"_postman_id":"e046d393-51ed-49b2-8f06-39d3dbb52816"},{"name":"Get Daily Report","id":"8ca22bb2-5198-459c-9dfc-8125c2e236f9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/child/report.php?limit=3","description":"

A child can view their daily report.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","child","report.php"],"host":["localhost"],"query":[{"key":"limit","value":"3"}],"variable":[]}},"response":[{"id":"03b549f9-a0ea-43c1-adee-7e036bc27704","name":"OK - Successfully Get Daily Report","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/report.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:45:35 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"336"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"11111111\",\n \"FirstName\": \"First\",\n \"LastName\": \"Child\",\n \"ReportId\": \"1\",\n \"CaretakerEmployeeId\": \"5555\",\n \"ReportDate\": \"2020-01-01\",\n \"ScheduleStartTime\": \"10:00:00\",\n \"ScheduleEndTime\": \"13:00:00\",\n \"ReportComment\": \"Child took medication at 2pm. All day child did a good job!\",\n \"LessonsLearned\": \"Learned about space and aliens\",\n \"ActionRequired\": null\n },\n {\n \"SIN\": \"11111111\",\n \"FirstName\": \"First\",\n \"LastName\": \"Child\",\n \"ReportId\": \"161\",\n \"CaretakerEmployeeId\": \"5555\",\n \"ReportDate\": \"2020-12-01\",\n \"ScheduleStartTime\": \"12:00:00\",\n \"ScheduleEndTime\": \"17:30:00\",\n \"ReportComment\": \"Was with child the entire day. Child ate on time. Made fun of other kids.\",\n \"LessonsLearned\": \"Knows what a kinkajou is.\",\n \"ActionRequired\": \"Needs bladder training.\"\n }\n]"},{"id":"3aa96714-71f7-4a71-96a4-aeb54f07b91a","name":"Bad Request - Failed to Get Daily Report (Wrong Data Length)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111123\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/report.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:46:03 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"84"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get reports. Data length does not match the defined model.\"\n}"},{"id":"9b7d7437-48c4-4938-9158-43dc00538ee0","name":"OK - Successfully Get Daily Report (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/child/report.php?limit=3","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","child","report.php"],"query":[{"key":"limit","value":"3"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:26:46 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"895"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\"SIN\":\"11111111\",\"FirstName\":\"First\",\"LastName\":\"Child\",\"ReportId\":\"7\",\"CaretakerEmployeeId\":\"5555\",\"ReportDate\":\"2020-07-01\",\"ScheduleStartTime\":\"12:45:00\",\"ScheduleEndTime\":\"20:00:00\",\"ReportComment\":\"Childs parent was late to pick him up.\",\"LessonsLearned\":null,\"ActionRequired\":\"Child was upset that his parent was late\"}{\"SIN\":\"11111111\",\"FirstName\":\"First\",\"LastName\":\"Child\",\"ReportId\":\"6\",\"CaretakerEmployeeId\":\"5555\",\"ReportDate\":\"2020-07-01\",\"ScheduleStartTime\":\"12:12:00\",\"ScheduleEndTime\":\"12:45:00\",\"ReportComment\":\"Child took a lunch break\",\"LessonsLearned\":\"Child can cook!\",\"ActionRequired\":null}{\"SIN\":\"11111111\",\"FirstName\":\"First\",\"LastName\":\"Child\",\"ReportId\":\"3\",\"CaretakerEmployeeId\":\"5555\",\"ReportDate\":\"2020-07-01\",\"ScheduleStartTime\":\"09:00:00\",\"ScheduleEndTime\":\"12:00:00\",\"ReportComment\":\"Child played well\",\"LessonsLearned\":\"Studied computers\",\"ActionRequired\":null}"}],"_postman_id":"8ca22bb2-5198-459c-9dfc-8125c2e236f9"},{"name":"Get Room","id":"0daca63b-a62d-47b0-bf86-4bba3ca5a3b5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/child/room.php?limit=1","description":"

Get the specific room a child is assigned in a daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","child","room.php"],"host":["localhost"],"query":[{"key":"limit","value":"1"}],"variable":[]}},"response":[{"id":"3c815af3-2360-4ffe-896c-cf27e1ecc4f3","name":"OK - Successfully Get Room","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/room.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:48:07 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"200"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"11111111\",\n \"RoomId\": \"1\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\"\n }\n]"},{"id":"623353e9-c9bf-464b-ae1a-658723c3ae2e","name":"OK - Successfully Get Room (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/child/room.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","child","room.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:28:28 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"96"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"SIN\": \"11111111\",\n \"RoomId\": \"1\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\"\n}"},{"id":"b242ceb1-7dab-4ff0-9236-4390d65a7732","name":"Bad Request - Failed to Get Room (Wrong Data length)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"111111112\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/child/room.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:48:25 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"81"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get room. Data length does not match the defined model.\"\n}"}],"_postman_id":"0daca63b-a62d-47b0-bf86-4bba3ca5a3b5"}],"id":"ce1cddcd-35dd-47e8-bace-48a52d0f743c","description":"

A child is part of a daycare who is taken care of by a caretaker. A child may have special needs that the caretaker would need to pay attention to and deal with appropriately.

Contains the following requests:

Add special condition
Get condition
Get daily report
Get room

\n","_postman_id":"ce1cddcd-35dd-47e8-bace-48a52d0f743c"},{"name":"Daycare","item":[{"name":"Get Employee","id":"d791e6cc-1e58-4bc7-9796-dd61793a6424","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/employee.php?limit=2","description":"

Get the employees working at a specific daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
DaycareName	varchar(100)	required
DaycareAddress	varchar(100)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","daycare","employee.php"],"host":["localhost"],"query":[{"key":"limit","value":"2"}],"variable":[]}},"response":[{"id":"0179ea5a-b3a0-42f3-a0dd-c22dd4668f5b","name":"OK - Successfully Get Employee","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/employee.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:06:38 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"297"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"12345678\",\n \"EmployeeId\": \"5555\",\n \"FirstName\": \"Erin\",\n \"LastName\": \"Employee\",\n \"WorkHours\": \"8.00\",\n \"HourlyRate\": \"25.00\"\n },\n {\n \"SIN\": \"44433222\",\n \"EmployeeId\": \"5550\",\n \"FirstName\": \"Dr\",\n \"LastName\": \"Employee\",\n \"WorkHours\": \"12.00\",\n \"HourlyRate\": \"30.00\"\n },\n {\n \"SIN\": \"99988877\",\n \"EmployeeId\": \"1234\",\n \"FirstName\": \"Admin\",\n \"LastName\": \"Lady\",\n \"WorkHours\": \"10.00\",\n \"HourlyRate\": \"100.00\"\n }\n]"},{"id":"6f6e9b5c-adf0-4094-9b4c-c5b372eb59d2","name":"Bad Request - Failed to Get Employee (Incomplete Data)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/employee.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:07:06 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"60"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get employees. Data is incomplete.\"\n}"},{"id":"9926b967-e6f2-4b12-bf66-9fa7cbe8e334","name":"OK - Successfully Get Employee (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/daycare/employee.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","daycare","employee.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:29:22 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"119"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"SIN\": \"12345678\",\n \"EmployeeId\": \"5555\",\n \"FirstName\": \"Erin\",\n \"LastName\": \"Employee\",\n \"WorkHours\": \"8.00\",\n \"HourlyRate\": \"25.00\"\n}"}],"_postman_id":"d791e6cc-1e58-4bc7-9796-dd61793a6424"},{"name":"Get Room","id":"b9196490-69a7-416f-9daf-b5407550a93e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/room.php?limit=1","description":"

Get all the rooms in the daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
DaycareName	varchar(100)	required
DaycareAddress	varchar(100)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","daycare","room.php"],"host":["localhost"],"query":[{"key":"limit","value":"1"}],"variable":[]}},"response":[{"id":"7769a952-b3c4-4e8b-961f-e8315d1cc0bc","name":"OK - Successfully Get Room","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/room.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:08:44 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"297"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"RoomId\": \"1\",\n \"SeatsAvailable\": \"4\"\n },\n {\n \"RoomId\": \"2\",\n \"SeatsAvailable\": \"1\"\n }\n]"},{"id":"cf4e1785-2ab2-43f7-b5e2-af22117094b7","name":"OK - Successfully Get Room (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/daycare/room.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","daycare","room.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:31:19 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"35"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"RoomId\": \"1\",\n \"SeatsAvailable\": \"4\"\n}"},{"id":"da821b52-1d97-4d54-8a07-d2b91cbc9ab5","name":"Bad Request - Get Room (Incomplete Data Type)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/daycare/room.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:09:39 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"60"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get room. Data is incomplete.\"\n}"}],"_postman_id":"b9196490-69a7-416f-9daf-b5407550a93e"}],"id":"0cf5c1ca-9585-46b4-bbfe-17a92d8e326e","description":"

A daycare is a facility which admins, caretakers, parents, and children interact with. Parents have children that may attend the daycare, who is then taken care of by a caretaker. The admins manage the daycare system and the administrative tasks.

Contains the following requests:

Get employee
Get room

\n","_postman_id":"0cf5c1ca-9585-46b4-bbfe-17a92d8e326e"},{"name":"Employee","item":[{"name":"Get Daycare","id":"d434d68e-bca8-4a06-aa15-c6ef7c88c738","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": 1234\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/employee/daycare.php?limit=1","description":"

Get the daycare an employee works at.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
EmployeeId	int(11)	required

Account clearance level required to use this endpoint: Medium.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","employee","daycare.php"],"host":["localhost"],"query":[{"key":"limit","value":"1"}],"variable":[]}},"response":[{"id":"84877dd2-13ba-4e0b-810b-06c033ce26c6","name":"Bad Request - Failed to Get Daycare (Wrong Data Type)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/employee/daycare.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:52:52 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"64"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get daycare. Data type is not correct.\"\n}"},{"id":"b860e1be-1713-4d7e-85e4-4e440ee1edfd","name":"OK - Successfully Get Daycare (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": 1234\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/employee/daycare.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","employee","daycare.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:32:53 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"66"},{"key":"Keep-Alive","value":"timeout=5, max=99"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\"\n}"},{"id":"f3de297d-aa54-4861-a2f1-54d323337d90","name":"OK - Successfully Get Daycare","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"EmployeeId\": 1234\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/employee/daycare.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 21:07:14 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"70"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\"\n }\n]"}],"_postman_id":"d434d68e-bca8-4a06-aa15-c6ef7c88c738"}],"id":"dd8633a6-7952-4731-9ed1-5353d4aeb37f","description":"

An employee is a worker at the daycare. An employee can either be an admin or a caretaker, and they both have more privileges than a parent

Contains the following requests:

Get daycare

\n","_postman_id":"dd8633a6-7952-4731-9ed1-5353d4aeb37f"},{"name":"Parent_guardian","item":[{"name":"Get Caretaker","id":"d7ed8b16-ccd1-4200-971a-7fd58eeff5fc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"limit","value":"1","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/caretaker.php?limit=1","description":"

View all caretakers working at a daycare and their info.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
DaycareName	varchar(100)	required
DaycareAddress	varchar(100)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","parent_guardian","caretaker.php"],"host":["localhost"],"query":[{"key":"limit","value":"1"}],"variable":[]}},"response":[{"id":"7e64bc22-e921-40a0-97ad-33d9869fd2a3","name":"OK - Successfully Get Caretaker","originalRequest":{"method":"GET","header":[{"key":"","value":"","type":"text"},{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/caretaker.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:52:02 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"658"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"FirstName\": \"Erin\",\n \"LastName\": \"Employee\",\n \"Gender\": \"Female\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\",\n \"StartDay\": \"9\",\n \"StartMonth\": \"7\",\n \"StartYear\": \"2003\",\n \"PastIncidents\": \"Slept during shift once.\",\n \"Availability\": \"1\",\n \"SpecializationType\": \"Eating Disorders\"\n },\n {\n \"FirstName\": \"Erin\",\n \"LastName\": \"Employee\",\n \"Gender\": \"Female\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\",\n \"StartDay\": \"9\",\n \"StartMonth\": \"7\",\n \"StartYear\": \"2003\",\n \"PastIncidents\": \"Slept during shift once.\",\n \"Availability\": \"1\",\n \"SpecializationType\": \"Healthy Eating\"\n },\n {\n \"FirstName\": \"Dr\",\n \"LastName\": \"Employee\",\n \"Gender\": \"Male\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\",\n \"StartDay\": \"10\",\n \"StartMonth\": \"10\",\n \"StartYear\": \"2010\",\n \"PastIncidents\": null,\n \"Availability\": \"1\",\n \"SpecializationType\": \"OCD\"\n },\n {\n \"FirstName\": \"Dr\",\n \"LastName\": \"Employee\",\n \"Gender\": \"Male\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\",\n \"StartDay\": \"10\",\n \"StartMonth\": \"10\",\n \"StartYear\": \"2010\",\n \"PastIncidents\": null,\n \"Availability\": \"1\",\n \"SpecializationType\": \"Trauma\"\n }\n]"},{"id":"b3d5bec7-0612-43d0-b3ef-29e3d9450958","name":"OK - Successfully Get Caretaker (Limit)","originalRequest":{"method":"GET","header":[{"key":"","value":"","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\",\r\n \"DaycareAddress\": \"Daycare Street NW\"\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/caretaker.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","parent_guardian","caretaker.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:33:55 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"278"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"FirstName\": \"Erin\",\n \"LastName\": \"Employee\",\n \"Gender\": \"Female\",\n \"DaycareName\": \"Daycare One\",\n \"DaycareAddress\": \"Daycare Street NW\",\n \"StartDay\": \"9\",\n \"StartMonth\": \"7\",\n \"StartYear\": \"2003\",\n \"PastIncidents\": \"Slept during shift once.\",\n \"Availability\": \"1\",\n \"SpecializationType\": \"Eating Disorders\"\n}"},{"id":"e88f5905-3afe-4bd1-afa3-68b78cc3852e","name":"Bad Request - Failed to Get Caretaker (Incomplete Data)","originalRequest":{"method":"GET","header":[{"key":"","value":"","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"DaycareName\": \"Daycare One\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/caretaker.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 20:08:48 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"60"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get caretaker. Data is incomplete.\"\n}"}],"_postman_id":"d7ed8b16-ccd1-4200-971a-7fd58eeff5fc"},{"name":"Get Child","id":"6fa1783f-ce24-4800-92cf-02dec1eaff6b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11122233\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/child.php?limit=2","description":"

Get child(ren) for a parent.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ParentSIN	varchar(8)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","parent_guardian","child.php"],"host":["localhost"],"query":[{"key":"limit","value":"2"}],"variable":[]}},"response":[{"id":"2c3105b3-4a10-4416-bfa5-b88ad79a7db3","name":"OK - No Child","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"1\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/child.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:54:22 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"49"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"No children.\"\n}"},{"id":"828ea3ec-0196-43c7-b180-7b8aa6c80685","name":"OK - Successfully Get Child (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11122233\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/child.php?limit=2","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","parent_guardian","child.php"],"query":[{"key":"limit","value":"2"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:34:51 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"86"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"11111111\",\n \"FirstName\": \"First\",\n \"LastName\": \"Child\",\n \"DateOfBirth\": \"2005-10-12\"\n }\n]"},{"id":"a41e7eda-f40b-4e2e-8121-db2180aac054","name":"OK - Successfully Get Child","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11122233\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/child.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:54:02 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"88"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"11111111\",\n \"FirstName\": \"First\",\n \"LastName\": \"Child\",\n \"DateOfBirth\": \"2005-10-12\"\n }\n]"},{"id":"d3ebcc79-72e1-40fa-b664-2a60be0a2525","name":"Bad Request - Failed to Get Child (Incomplete Data)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/child.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:54:59 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"60"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to retrive child. Data is incomplete.\"\n}"}],"_postman_id":"6fa1783f-ce24-4800-92cf-02dec1eaff6b"},{"name":"Get Bill","id":"9f069d0c-5390-4485-be8c-9f6bcec4bb3b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11111112\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/viewBill.php?limit=10","description":"

A parent can view a bill that is outstanding.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ParentSIN	varchar(8)	required

Account clearance level required to use this endpoint: Medium.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","parent_guardian","viewBill.php"],"host":["localhost"],"query":[{"key":"limit","value":"10"}],"variable":[]}},"response":[{"id":"53a325ab-2f5d-422b-a958-d481b849e2c6","name":"Unauthorized - Failed to Get Bill (Wrong Credentials)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11111112\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/viewBill.php?limit=0","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","parent_guardian","viewBill.php"],"query":[{"key":"limit","value":"0"}]}},"status":"Unauthorized","code":401,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 06 Dec 2020 02:45:24 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"WWW-Authenticate","value":"Basic realm=\"My Realm\""},{"key":"Content-Length","value":"49"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Messsage\": \"Username or password is incorrect.\"\n}"},{"id":"5dd99277-95ce-44ef-8597-04b4a67e3e2d","name":"OK - Successfully Get Bill","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11111112\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/viewBill.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 15:46:24 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"44"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"SIN\": \"11111112\",\n \"AmountPending\": \"30.00\"\n }\n]"},{"id":"676a715e-3e9e-41aa-af48-ef3d11ec0941","name":"Bad Request - Failed to Get Bill (Wrong Data Type)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/viewBill.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Thu, 03 Dec 2020 15:47:25 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"59"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to get bill. Data type is not correct.\"\n}"},{"id":"cceee6dd-28fb-4cf5-abb2-6615bf211e88","name":"OK - Successfully Get Bill (Limit)","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ParentSIN\": \"11111112\"\r\n}"},"url":{"raw":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/viewBill.php?limit=1","protocol":"http","host":["localhost"],"path":["CPSC471-DatabaseProject","api","parent_guardian","viewBill.php"],"query":[{"key":"limit","value":"1"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sat, 05 Dec 2020 21:36:04 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"GET"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"42"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"SIN\": \"11111112\",\n \"AmountPending\": \"30.00\"\n}"}],"_postman_id":"9f069d0c-5390-4485-be8c-9f6bcec4bb3b"},{"name":"Pay Bill","id":"d7ede7e1-d9ff-49f2-909e-64a74aece58e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434,\r\n \"AmountPending\": 100,\r\n \"PaymentMethod\": \"Cash\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/payBill.php","description":"

A parent can pay their outstanding bill. They can either pay the full payment or part of the bill.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
BillId	int(11)	required
AmountPending	decimal(6,2)	optional
PaymentMethod	varchar(30)	optional

If AmountPending is not included in the parameters then it means the amount is 0.

Account clearance level required to use this endpoint: Medium.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","parent_guardian","payBill.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"0b92a56b-0679-41a0-b13b-fa9ef6798aaf","name":"OK - Successfully Pay Bill","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434,\r\n \"AmountPending\": 10,\r\n \"PaymentMethod\": \"Cash\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/payBill.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 02:06:09 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"35"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Payment Succesfull.\"\n}"},{"id":"75c4133e-be29-4832-9174-2c5e1b1de720","name":"OK - Successfully Pay Bill (Optional Parameter)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": 43434\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/payBill.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 20:18:53 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"35"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Payment Succesfull.\"\n}"},{"id":"a50b330c-e87a-4f8b-a092-f9594d66900a","name":"Bad Request - Failed to Pay Bill (Wrong Data Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"BillId\": \"abcd\",\r\n \"AmountPending\": 100,\r\n \"PaymentMethod\": \"Cash\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/parent_guardian/payBill.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 20:20:24 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"63"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Payment unsuccesfull. Data type is not correct.\"\n}"}],"_postman_id":"d7ede7e1-d9ff-49f2-909e-64a74aece58e"}],"id":"d93b23d0-7c03-4f4d-b45b-5856d8a81671","description":"

A parent or guardian has children attending the daycare. The parent can view a list of caretakers that are available for their child and can also pay their outstanding bill.

Contains the following requests:

Get caretaker
Get child
Get bill
Pay bill

\n","_postman_id":"d93b23d0-7c03-4f4d-b45b-5856d8a81671"},{"name":"Person","item":[{"name":"Add Person","id":"22d6de6f-b56d-4619-9c58-3e3416ca6ede","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"20032879\",\r\n \"FirstName\": \"Kate\",\r\n \"LastName\": \"Bender\",\r\n \"Gender\": \"Female\",\r\n \"AddrUnitNum\": 121,\r\n \"AddrStreet\": \"Bowness Rd\",\r\n \"AddrCity\": \"Calgary\",\r\n \"AddrPostalCode\": \"T3B 0G1\",\r\n \"StartDay\": 1,\r\n \"StartMonth\": 12,\r\n \"StartYear\": 2020,\r\n \"PhoneNum\": \"587-500-0041\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/person/addPerson.php","description":"

Add a new person to the database table. This person could be an employee, parent or guardian, or a child. The StartDay, StartMonth, and StartYear attributes are for employees when they start work, and for children when they are registered in the daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
SIN	varchar(8)	required
FirstName	varchar(30)	required
LastName	varchar(30)	required
Gender	varchar(30)	required
AddrUnitNum	int(11)	required
AddrStreet	varchar(50)	required
AddrCity	varchar(20)	required
AddrPostalCode	varchar(20)	required
StartDay	int(2)	optional
StartMonth	int(2)	optional
StartYear	int(4)	optional
PhoneNum	varchar(20)	required

Account clearance level required to use this endpoint: Low.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","person","addPerson.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"9d47c457-8b8a-4c2e-93b5-140f2e5321d4","name":"Bad Request - Failed to Add Person (Wrong Data Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"abcd\",\r\n \"FirstName\": \"Kate\",\r\n \"LastName\": \"Bender\",\r\n \"Gender\": \"Female\",\r\n \"AddrUnitNum\": 121,\r\n \"AddrStreet\": \"Bowness Rd\",\r\n \"AddrCity\": \"Calgary\",\r\n \"AddrPostalCode\": \"T3B 0G1\",\r\n \"StartDay\": 1,\r\n \"StartMonth\": 12,\r\n \"StartYear\": 2020,\r\n \"PhoneNum\": \"587-500-0041\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/person/addPerson.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:55:09 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"63"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to add person. Data type is not correct.\"\n}"},{"id":"a3f2d101-c9b5-426b-aff9-deb6ec236732","name":"Created - Successfully Added Person (as Employee)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"20032879\",\r\n \"FirstName\": \"Kate\",\r\n \"LastName\": \"Bender\",\r\n \"Gender\": \"Female\",\r\n \"AddrUnitNum\": 121,\r\n \"AddrStreet\": \"Bowness Rd\",\r\n \"AddrCity\": \"Calgary\",\r\n \"AddrPostalCode\": \"T3B 0G1\",\r\n \"StartDay\": 1,\r\n \"StartMonth\": 12,\r\n \"StartYear\": 2020,\r\n \"PhoneNum\": \"587-500-0041\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/person/addPerson.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 21:27:41 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"38"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Person has been added.\"\n}"},{"id":"a6e7d657-97a3-4938-9337-238fd0370df7","name":"Created - Successfully Added Parent","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"30020123\",\r\n \"FirstName\": \"Harold\",\r\n \"LastName\": \"Shipman\",\r\n \"Gender\": \"Male\",\r\n \"AddrUnitNum\": 580,\r\n \"AddrStreet\": \"Acadia Dr\",\r\n \"AddrCity\": \"Calgary\",\r\n \"AddrPostalCode\": \"T2J 1M6\",\r\n \"PhoneNum\": \"587-707-1324\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/person/addPerson.php"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 21:24:30 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"38"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Person has been added.\"\n}"}],"_postman_id":"22d6de6f-b56d-4619-9c58-3e3416ca6ede"},{"name":"Remove Person","id":"ed2fc29c-9624-406d-bc11-64dccb6aa10e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"20032879\"\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/person/removePerson.php","description":"

Remove a person from the database.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
SIN	varchar(8)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","person","removePerson.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"707da7df-0fa9-4d2e-8986-f9b95823c0e4","name":"OK - Successfully Removed Person","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"30020123\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/person/removePerson.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 21:33:07 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"DELETE"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"40"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Person has been removed.\"\n}"},{"id":"f73fa0cd-7a1c-4c66-b5d6-745303a5fe45","name":"Bad Request - Failed to Remove Person (Wrong Data Type)","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"SIN\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/person/removePerson.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 00:57:37 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"DELETE"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"66"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to remove person. Data type is not correct.\"\n}"}],"_postman_id":"ed2fc29c-9624-406d-bc11-64dccb6aa10e"}],"id":"e63c08af-d9d7-4a7d-ba87-8b53b10dd564","description":"

A person is a superclass of employee, parent, and child.

Contains the following requests:

Add person
Remove person

\n","_postman_id":"e63c08af-d9d7-4a7d-ba87-8b53b10dd564"},{"name":"Room","item":[{"name":"Assign Child","id":"ea8819ad-0223-413f-931f-21e2e8f747f3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":false},"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\",\r\n \"RoomId\": 2\r\n}"},"url":"http://localhost/CPSC471-DatabaseProject/api/room/child.php","description":"

Assign a room to a child in the daycare.

This is a table of parameters that work with this endpoint and whether it is required or optional:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Attribute	Data Type	Required/Optional
ChildSIN	varchar(8)	required
RoomId	int(11)	required

Account clearance level required to use this endpoint: High.

\n","urlObject":{"protocol":"http","path":["CPSC471-DatabaseProject","api","room","child.php"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"ded47766-9d09-4a3c-9804-f4584f5769df","name":"OK - Successfully Assigned Child to Room","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\",\r\n \"RoomId\": 2\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/room/child.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Tue, 01 Dec 2020 21:15:59 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"48"},{"key":"Keep-Alive","value":"timeout=5, max=100"},{"key":"Connection","value":"Keep-Alive"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Child has been assigned to room.\"\n}"},{"id":"f02710c1-fd17-43fd-aa5c-db88792cc699","name":"Bad Request - Failed to Assign Room to Child (Wrong Data Type)","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"ChildSIN\": \"11111111\",\r\n \"RoomId\": \"abcd\"\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost/CPSC471-DatabaseProject/api/room/child.php"},"status":"Bad Request","code":400,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Wed, 02 Dec 2020 01:00:47 GMT"},{"key":"Server","value":"Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.10"},{"key":"X-Powered-By","value":"PHP/7.3.10"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Access-Control-Allow-Methods","value":"POST"},{"key":"Access-Control-Max-Age","value":"3600"},{"key":"Access-Control-Allow-Headers","value":"Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With"},{"key":"Content-Length","value":"73"},{"key":"Connection","value":"close"},{"key":"Content-Type","value":"application/json; charset=UTF-8"}],"cookie":[],"responseTime":null,"body":"{\n \"Message\": \"Unable to assign child to room. Data type is not correct.\"\n}"}],"_postman_id":"ea8819ad-0223-413f-931f-21e2e8f747f3"}],"id":"d96910dd-f644-4614-b924-40f6b6146bb7","description":"

A room is part of a daycare. Each child is assigned a room.

Contains the following requests:

Assign child

\n","_postman_id":"d96910dd-f644-4614-b924-40f6b6146bb7"}],"event":[{"listen":"prerequest","script":{"id":"d81b328b-016f-463e-8573-8d5bc40b9d7a","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"229d72a7-28ad-428a-a815-08eded17bb3c","type":"text/javascript","exec":[""]}}]}