| date | DATE | NOT NULL | Available dBusinessate |
| start_time | TIME | NOT NULL | Start time of availability |
| end_time | TIME | NOT NULL | End time of availability |
| is_booked | BOOLEAN | DEFAULT false | Marks if slot is already booked |
@@ 608,7 618,7 @@
- `idx_job_managers_job_id` on `job_id`
- `idx_job_managers_manager_id` on `manager_id`
---
-
##### Table: communication
+
##### Table: communicationBusiness
**Purpose:** Stores all communication exchanges between the system, candidates, and managers- including interview invites, responses, and final confirmations.
@@ 713,8 723,10 @@
---
#### 4.4 pgvector Configuration
+
### 9. Phase Two Enhancements (AI-assisted Interview Scheduler)
+
824
-
**Extension Setup:**
+
**Extension Setup:** Business
```sql
CREATE EXTENSION IF NOT EXISTS vector;
```
@@ 817,3 829,53 @@
### 8. Flow Diagram
---
+
+
### 9. Phase Two Enhancements
+
#### AI-assisted interview scheduler
+
- 🧑💼 1. Manager & Availability Setup
+
+
- HR assigns one or more managers to each job.
+
+
- Managers define their available time slots for interviews.
+
+
- System ensures no overlapping interview slots.
+
+
- 🎯 2. Candidate Invitation
+
+
- HR shortlists candidates for interviews.
+
+
- AI automatically drafts and sends invitation emails with available time slots.
+
+
- Each invitation is recorded for tracking and status updates.
+
+
- 📬 3. Candidate Response
+
+
- The system listens for candidate replies.
+
+
- AI interprets their response (acceptance, decline, or preferred slot).
+
+
- Once confirmed, the selected slot is blocked to prevent double booking.
+
+
- 👨💼 4. Manager Confirmation
+
+
- The system notifies the respective manager about the candidate’s selected slot.
+
+
- Manager confirms or reschedules based on their convenience.
+
+
- Their response is automatically updated in the system.
+
+
- 🗓️ 5. Interview Scheduling
+
+
- Once both sides confirm, the interview is officially scheduled.
+
+
- A meeting link (Google Meet / Zoom) is generated automatically.
+
+
- Confirmation emails are sent to all participants — HR, Manager, and Candidate.
+
+
- 📊 6. Post-Interview Actions
+
+
- After the interview, HR can mark it as completed.
+
+
- Feedback and notes can be added for future reference.
+
+
- The system reopens or manages availability slots for upcoming interviews.