05) Database Schema

Schema Definition

Appointments

• first_name: String
• last_name: String
• phone_number: String
• date: Date
• provider_name: String
• company_id: ObjectId Company the appointment is related to

Company

• email: String unique
• name: String unique
• phone_number: String
• paid_time: Date

Employee

• first_name: String
• last_name: String
• email: String unique
• password: String
• phone_number: String
• role: String see roles for possible values
• company_id: ObjectId Company the employee works for

Visitor (found within VisitorList)

• company_id: ObjectId Company the visitor is visiting
• first_name: String
• last_name: String
• lname: String
• phone_number: String
• checkin_time: Date
• appointments: Appointment
• additional_info 'Dictionary' (optional)

VisitorList

• company_id: ObjectId Company the visitors are visiting
• visitors: Visitor list of visitors

roles

1. c_admin: Company administrator
2. c_employee: Company employee
3. a_admin: Application administrator (administrator of Emissary)