Spaces:
Running
Running
| 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 | |
| - 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` |