o
    "Ći˘  ă                   @   sL   d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
ddd„Zdd	d
„ZdS )zjInitial expert training models

Revision ID: 001_expert_training_models
Revises:
Create Date: 2026-03-13

é    )ÚopN)Ú
postgresqlÚ001_expert_training_modelsÚreturnc                   C   sf  t  dˇ t jdtjdt ˇ ddŤtjdt ˇ ddŤtjdt t ˇ ˇddŤtjdt t ˇ ˇddŤtjd	t ˇ d
dŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt 	ˇ ddŤtjdt ˇ ddŤtjdt 
ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ d
dŤtjdt ˇ d
dŤt dˇddŤ t jdddgddŤ t jdddgd
ddŤ t jdtjdt ˇ ddŤtjdt ˇ ddŤtjd t d!ˇddŤtjd"t ˇ ddŤtjd#t 	ˇ d
dŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ d
dŤtjdt ˇ d
dŤt dˇddŤ t jd$ddgddŤ t jd%tjdt ˇ ddŤtjd&t d'ˇddŤtjd(t ˇ d
dŤtjd)t ˇ ddŤtjd*t d!ˇddŤtjd+t d!ˇd,dŤtjd-t d!ˇd.dŤtjd/t ˇ d
dŤtjd0t ˇ d
dŤtjd1t ˇ d
dŤtjd2t ˇ d
dŤtjd3t ˇ d
dŤtjd4t ˇ d
dŤtjd#t 	ˇ d
dŤtjd5t ˇ d
dŤtjd6t 
ˇ d
dŤtjdt 
ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ d
dŤtjdt ˇ d
dŤt dˇddŤ t jd7d%d+gddŤ t jd8d%d0gddŤ t jd9tjdt ˇ ddŤtjd:t d'ˇddŤtjd(t ˇ d
dŤtjd;t d!ˇddŤtjd<t ˇ d=dŤtjd>t ˇ d
dŤtjd?t ˇ ddŤtjd@t ˇ ddŤtjdAt ˇ ddŤtjdBt ˇ ddŤtjd2t ˇ d
dŤtjdt 
ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ d
dŤtjdt ˇ d
dŤt dˇddŤ t jdCtjdt ˇ ddŤtjdDt ˇ ddŤtjd)t ˇ ddŤtjdEt d'ˇddŤtjdFt d!ˇdGdŤtjdHt ˇ d
dŤtjdt 
ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ ddŤtjdt ˇ d
dŤtjdt ˇ d
dŤt dˇt dDgdIgˇddŤ d S )JNz&CREATE SCHEMA IF NOT EXISTS hub_globalÚexpert_profilesÚidF)ÚnullableÚuser_idÚexpertise_areasÚskillsÚbioTÚtotal_annotationsÚ0)Úserver_defaultÚtotal_reviewsÚavg_quality_scorez0.0Úreputation_scoreÚ	meta_dataz{}Ú
created_atÚ
updated_atÚ
is_deletedÚfalseÚ
deleted_atÚ
deleted_byÚ
hub_global©ÚschemaÚix_expert_profiles_idÚix_expert_profiles_user_id)Úuniquer   Úexpert_contributionsÚcontribution_typeé2   Útask_idÚquality_scoreÚix_expert_contributions_user_idÚannotation_tasksÚtitleé˙   ÚdescriptionÚcontentÚ	task_typeÚstatusÚpendingÚpriorityÚmediumÚdeadlineÚassigned_toÚassigned_byÚ
created_byÚcompleted_atÚreviewed_byÚreviewer_feedbackÚannotation_dataÚix_annotation_tasks_statusÚix_annotation_tasks_assigned_toÚtraining_datasetsÚnameÚdataset_typeÚversionÚ1Úparent_version_idÚtotal_samplesÚtrain_samplesÚvalidation_samplesÚtest_samplesÚdataset_samplesÚ
dataset_idÚlabelÚsplitÚtrainÚsource_task_idzhub_global.training_datasets.id)r   ÚexecuteÚcreate_tableÚsaÚColumnÚIntegerr   ÚARRAYÚTextÚFloatÚJSONBÚDateTimeÚBooleanÚPrimaryKeyConstraintÚcreate_indexÚStringÚForeignKeyConstraint© rY   rY   úe/lsinfo/ai/hellotax_ai/training_center/backend/alembic/versions/001_initial_expert_training_models.pyÚupgrade   sŘ   
îóçě
đr[   c                   C   sJ   t jdddŤ t jdddŤ t jdddŤ t jdddŤ t jdddŤ d S )NrD   r   r   r:   r&   r    r   )r   Ú
drop_tablerY   rY   rY   rZ   Ú	downgrade‹   s
   r]   )r   N)Ú__doc__Úalembicr   Ú
sqlalchemyrL   Úsqlalchemy.dialectsr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr[   r]   rY   rY   rY   rZ   Ú<module>   s    
y