---
title: Candidate Explorer
emoji: 🔍
colorFrom: purple
colorTo: gray
sdk: docker
app_port: 7860
---

Check out the configuration reference at https://huggingface.co/docs/hub/spaces-config-reference

## Schemas
```plain
1. Build Schema
    a. table: cv_users ✅
        - user_id
        - username
        - hashed_password
        - email
        - full_name
        - role
        - is_active
        - tenant_id
        - created_at
        - date_modified
        - notes
    b. table: cv_tenant ✅
        - tenant_id
        - tenant_name
        - created_at
        - date_modified
        - notes
    c. table: cv_file ✅
        - file_id
        - file_type
        - filename
        - url
        - is_extracted
        - uploaded_at
        - date_modified
    d. table: cv_profile ✅
        - profile_id
        - fullname
        - gpa_edu_1
        - univ_edu_1
        - major_edu_1
        - gpa_edu_2
        - univ_edu_2
        - major_edu_2
        - gpa_edu_3
        - univ_edu_3
        - major_edu_3
        - domicile
        - yoe
        - hardskills
        - softskills
        - certifications
        - business_domain
        - filename
        - file_id
        - created_at
    e. table: cv_filter
        - criteria_id
        - gpa_edu_1
        - gpa_edu_2
        - gpa_edu_3
        - univ_edu_1
        - univ_edu_2
        - univ_edu_3
        - major_edu_1
        - major_edu_2
        - major_edu_3
        - domicile
        - yoe
        - hardskills
        - softskills
        - certifications
        - business_domain
        - created_at
    f. table: cv_weight ✅
        - weight_id
        - gpa_edu_1
        - gpa_edu_2
        - gpa_edu_3
        - univ_edu_1
        - univ_edu_2
        - univ_edu_3
        - major_edu_1
        - major_edu_2
        - major_edu_3
        - domicile
        - yoe
        - hardskills
        - softskills
        - certifications
        - business_domain
        - created_at
    g. table: cv_matching ✅
        - matching_id
        - profile_id
        - criteria_id
        - gpa_edu_1
        - gpa_edu_2
        - gpa_edu_3
        - univ_edu_1
        - univ_edu_2
        - univ_edu_3
        - major_edu_1
        - major_edu_2
        - major_edu_3
        - domicile
        - yoe
        - hardskills
        - softskills
        - certifications
        - business_domain
        - created_at
    g. table: profile_scores ✅
        - score_id
        - matching_id
        - score
        - created_at
```


## List API
### User
```plain
1. create user ✅
2. get user by username ✅
3. login #TODO
```
### Tenant
```plain
1. create tenant ✅
2. get tenant by tenant_name ✅
```

## Create User Example
Input:
{
  "username": "harryyanto.ia@bukittechnology.com",
  "password": "Test12345$!",
  "email": "harryyanto.ia@bukittechnology.com",
  "full_name": "Harryyanto Ishaq Agasi",
  "role": "Admin",
  "tenant_id": "03ce53dd-9fc8-43e0-b047-c927602304a9",
  "notes": "admin"
}

Output:
{
  "user_id": "eb3de1ed-2e3f-4c95-b29b-b31f85f01730",
  "username": "harryyanto.ia@bukittechnology.com",
  "email": "harryyanto.ia@bukittechnology.com",
  "full_name": "Harryyanto Ishaq Agasi",
  "role": "Admin",
  "is_active": true,
  "tenant_id": "03ce53dd-9fc8-43e0-b047-c927602304a9",
  "created_at": "2026-02-19T15:42:05.726988Z"
}



## How To 
1. Init schema on DB
`uv run python -m externals.databases.pg_schema_up`

2. Drop schema on DB
`uv run python -m externals.databases.pg_schema_down`


Compile pyproject.toml to requirements.txt
`uv pip compile pyproject.toml -o requirements.txt`