Home A - Z
Page Index

Commit 2febd4

2025-10-13 16:59:42 Vinay Deokar: Added "blocked" column in the "candidates" table
Projects/HireGenius/Technical Document (LLD+HLD)).md ..
@@ 413,7 413,7 @@
### 4. Database Design
#### 4.1 Entity Relationship Diagram (ERD)
- ![](./image-1759931553297.png)
+ ![](./image-1760374732983.png)
---
#### 4.2 Table Specifications
@@ 474,6 474,7 @@
| parsed_data | JSONB | | Structured resume data (skills, experience, education) |
| resume_hash | VARCHAR(64) | UNIQUE, NOT NULL | SHA-256 hash for deduplication |
| source | VARCHAR(50) | DEFAULT 'email' | Source of resume (email, upload) |
+ | blocked | BOOLEAN | DEFAULT FALSE | Candidate-job status |
| created_at | TIMESTAMP | DEFAULT CURRENT_TIMESTAMP | Resume received time |
| updated_at | TIMESTAMP | DEFAULT CURRENT_TIMESTAMP | Last update time |
0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9