# Generated by Django 6.0 on 2026-02-26 11:32

import django.utils.timezone
import masters.models
import uuid
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('masters', '0018_assignjd_created_at_assignjd_updated_at'),
    ]

    operations = [
        migrations.CreateModel(
            name='PublicLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('token', models.CharField(max_length=20, unique=True)),
                ('resume_id', models.CharField(blank=True, max_length=100, null=True)),
                ('jd_id', models.CharField(blank=True, max_length=100, null=True)),
                ('link_type', models.CharField(max_length=50)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='TblMatchedProfilesCandidate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('resume_id', models.IntegerField()),
                ('jd_id', models.IntegerField()),
                ('overall_score', models.FloatField()),
                ('primaryskill_score', models.FloatField(null=True)),
                ('technicalskill_score', models.FloatField(null=True)),
                ('experience_score', models.BooleanField()),
                ('responsibilities_score', models.FloatField(null=True)),
                ('tech_framework_score', models.FloatField(null=True)),
                ('created_date', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.AlterModelOptions(
            name='tblcandidateprofile',
            options={'ordering': ['-id']},
        ),
        migrations.AlterModelOptions(
            name='tblclient',
            options={'ordering': ['-client_id']},
        ),
        migrations.AlterModelOptions(
            name='tbldepartment',
            options={'ordering': ['-department_id']},
        ),
        migrations.AlterModelOptions(
            name='tblimpdepartment',
            options={'ordering': ['-imp_department_id']},
        ),
        migrations.AlterModelOptions(
            name='tbljobdescription',
            options={'ordering': ['-jd_id']},
        ),
        migrations.AlterModelOptions(
            name='tblvendor',
            options={'ordering': ['-vendor_id']},
        ),
        migrations.AddField(
            model_name='tblcandidateresume',
            name='l0_interview_summary',
            field=models.JSONField(blank=True, default=list, null=True),
        ),
        migrations.AddField(
            model_name='tblcandidateresume',
            name='public_id',
            field=models.CharField(default=masters.models.generate_public_id, max_length=20, unique=True),
        ),
        migrations.AddField(
            model_name='tbljobdescription',
            name='client_job_id',
            field=models.CharField(blank=True, max_length=200, null=True),
        ),
        migrations.AddField(
            model_name='tbljobdescription',
            name='public_id',
            field=models.CharField(default=masters.models.generate_public_id, max_length=20, unique=True),
        ),
        migrations.AddField(
            model_name='tbljobdescription',
            name='public_token',
            field=models.UUIDField(default=uuid.uuid4, editable=False, unique=True),
        ),
        migrations.AddField(
            model_name='tblmatchedprofiles',
            name='remarks',
            field=models.TextField(blank=True, max_length=4000, null=True),
        ),
        migrations.AddField(
            model_name='tblmatchedprofiles',
            name='status_updated_at',
            field=models.DateTimeField(default=django.utils.timezone.now),
        ),
    ]