.-.-.-.-.-

## 📦 Table: `tbl_candidate_source`

**Module:** `recruitment`  
**Schema:** `public`  
**Purpose:** Stores candidate sources (e.g., job portal, referral, walk-in) for job applications.  
**Created By:** Mahendran T  
**Created On:** 2025-07-31  
**Last Modified:** 2025-07-31

---

## 🧩 Columns

| Column Name   | Data Type     | Nullable | Default | Description                                 |
|---------------|--------------|----------|---------|---------------------------------------------|
| `id`          | SERIAL       | NO       | auto-increment | Primary key                            |
| `source_name` | VARCHAR(100) | NO       | NULL    | Name of the candidate source (e.g., LinkedIn, Referral) |

---

## 🗂️ Constraints & Indexes

* **Primary Key:** `id`  
* **Indexes:**  
  * `tbl_candidate_source_pkey` on `id` (UNIQUE, BTREE)  
  * Consider index on `source_name` if searching/filtering frequently

---

## 🔗 Relationships

| Related Table   | Relationship Type | Foreign Key                                    | Description                                  |
|-----------------|------------------|-----------------------------------------------|----------------------------------------------|
| `tbl_applied_jobs` | One-to-Many    | `tbl_applied_jobs.candidate_source_id → tbl_candidate_source.id` | Each source can have many applied jobs |

---

## 🧬 ER Diagram (optional)

```dbml
Table tbl_candidate_source {
  id serial [pk]
  source_name varchar(100)
}
Ref: tbl_applied_jobs.candidate_source_id > tbl_candidate_source.id

---
```

## 🛠️ Sample SQL

```sql
CREATE TABLE tbl_candidate_source (
    id SERIAL PRIMARY KEY,
    source_name VARCHAR(100) NOT NULL
);
```

---

## 🕓 Change History

| Date       | Author      | Change Description          |
| ---------- | ----------- | --------------------------- |
| 2025-07-31 | Mahendran | Initial documentation draft |

/var/www/krbed.in/../yapcute.com/../talentgenesis_admin_backend/docs/db/tbl_candidate_source.md