Creating The DB
Use the psql -U development
command to login to the PostgreSQL server
username development
password development
To create database use, CREATE DATABASE scheduler_development;
.
Api
Days
GET /api/days
Response
[
{
"id": 1,
"name": "Monday",
"appointments": [1, 2],
"interviewers": [1, 2],
"spots": 0
}
]
Appointments
GET /api/appointments
Response:
{
"1": {
"id": 1,
"time": "12pm",
"interview": {
"student": "Aishwarya Singh",
"interviewer": 1
}
},
"2": {
"id": 2,
"time": "1pm",
"interview": {
"student": "Sandeep Painuly",
"interviewer": 2
}
}
}
PUT /api/appointments/:id
Body:
{
"interview": {
"student": String,
"interviewer": Number
}
}
DELETE /api/appointments/:id
Interviewers
GET /api/interviewers
Response:
{
"1": {
"id": 1,
"name": "Sonia",
"avatar": "https://i.imgur.com/twYrpay.jpg"
},
"2": {
"id": 2,
"name": "Anshi",
"avatar": "https://i.imgur.com/twYrpay.jpg"
}
}