# Generated by Django 4.1 on 2026-06-24 18:10

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('app_venin_web_new1', '0128_detordenprodingreso_total_detordenprodsalida_total'),
    ]

    operations = [
        migrations.CreateModel(
            name='AfpTasasMensuales',
            fields=[
                ('id_tasa', models.AutoField(primary_key=True, serialize=False)),
                ('periodo', models.CharField(max_length=7)),
                ('comision_fija', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)),
                ('comision_sobre_flujo', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('comision_mixta_sobre_flujo', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)),
                ('comision_mixta_sobre_saldo', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)),
                ('comision_anual_sobre_saldo', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('prima_de_seguro', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('aporte_obligatorio', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('remuneracion_maxima_asegurable', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
            ],
            options={
                'db_table': 'afp_tasas_mensuales',
            },
        ),
        migrations.CreateModel(
            name='Cargo',
            fields=[
                ('id_cargo', models.AutoField(primary_key=True, serialize=False)),
                ('nombre', models.CharField(max_length=100)),
                ('jornal_base', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
            ],
            options={
                'db_table': 'cargo',
            },
        ),
        migrations.CreateModel(
            name='Departamento',
            fields=[
                ('id_departamento', models.AutoField(primary_key=True, serialize=False)),
                ('nombre', models.CharField(max_length=100)),
            ],
            options={
                'db_table': 'departamento',
            },
        ),
        migrations.CreateModel(
            name='Empleado',
            fields=[
                ('id_empleado', models.AutoField(primary_key=True, serialize=False)),
                ('dni', models.CharField(max_length=15, unique=True)),
                ('apellido_paterno', models.CharField(max_length=100)),
                ('apellido_materno', models.CharField(max_length=100)),
                ('nombres', models.CharField(max_length=100)),
                ('fecha_ingreso', models.DateField()),
                ('fecha_cese', models.DateField(blank=True, null=True)),
                ('asignacion_familiar', models.BooleanField(default=False)),
                ('cuspp', models.CharField(blank=True, max_length=25, null=True)),
                ('remuneracion', models.DecimalField(decimal_places=2, max_digits=10)),
                ('nro_cuenta', models.CharField(blank=True, max_length=50, null=True)),
                ('situacion', models.CharField(choices=[('CONTRATADO', 'CONTRATADO'), ('ESTABLE', 'ESTABLE')], default='CONTRATADO', max_length=15)),
                ('estado_civil', models.CharField(choices=[('SOLTERO', 'SOLTERO'), ('CASADO', 'CASADO'), ('VIUDO', 'VIUDO'), ('DIVORCIADO', 'DIVORCIADO')], default='SOLTERO', max_length=15)),
            ],
            options={
                'db_table': 'empleado',
            },
        ),
        migrations.CreateModel(
            name='Planilla',
            fields=[
                ('id_planilla', models.AutoField(primary_key=True, serialize=False)),
                ('periodo', models.CharField(max_length=7)),
                ('fecha_inicio', models.DateField()),
                ('fecha_fin', models.DateField()),
                ('fecha_generacion', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'db_table': 'planilla',
            },
        ),
        migrations.CreateModel(
            name='PlanillaDetalle',
            fields=[
                ('id_detalle', models.AutoField(primary_key=True, serialize=False)),
                ('jornal_diario', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('remuneracion_base', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('dias_trabajados', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_libres_ganados', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_faltas_sin_goce', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_feriados', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_permiso_con_goce', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_licencia_pat_fall', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_descanso_medico', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('dias_vacaciones', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('compra_vacaciones', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('total_dias', models.DecimalField(decimal_places=2, default=0.0, max_digits=5)),
                ('monto_trabajado', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_libres_ganados', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_faltas_sin_goce', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_feriados', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_permiso_con_goce', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_licencia_pat_fall', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_descanso_medico', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_compra_dias', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_vacaciones', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_sobretasa', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('subtotal_montos', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_asignacion_familiar', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_montos', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_snp', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_afp', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_comision', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_prima', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_aporte', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_renta_5ta', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('monto_fcjmms', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('adelantos', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_descuentos', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_sueldo_neto', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('aporte_essalud', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('aporte_pensionario_2', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('cstr_salud', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('vida_ley', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('cstr_pensiones', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_salud', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('bono_fijo_pasajes', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('otros_condicion', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('condicion_trabajo_total', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('cts', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('gratificaciones', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('bonificacion', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_otros', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('total_a_pagar', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)),
                ('fecha_creacion_detalle', models.DateTimeField(auto_now_add=True)),
                ('fecha_modificacion_detalle', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'planilla_detalle',
            },
        ),
        migrations.CreateModel(
            name='RegimenPensionario',
            fields=[
                ('id_afp', models.AutoField(primary_key=True, serialize=False)),
                ('nombre', models.CharField(max_length=100)),
                ('tipo', models.CharField(choices=[('AFP', 'AFP'), ('ONP', 'ONP')], max_length=3)),
            ],
            options={
                'db_table': 'regimen_pensionario',
            },
        ),
        migrations.RemoveField(
            model_name='ajuste',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='aprobacion',
            name='aprobador',
        ),
        migrations.RemoveField(
            model_name='aprobacion',
            name='content_type',
        ),
        migrations.RemoveField(
            model_name='aprobacion',
            name='nivel',
        ),
        migrations.RemoveField(
            model_name='articulos',
            name='clase3',
        ),
        migrations.RemoveField(
            model_name='articulos',
            name='idclase',
        ),
        migrations.RemoveField(
            model_name='articulos',
            name='idsubcla',
        ),
        migrations.RemoveField(
            model_name='articulos',
            name='unidad',
        ),
        migrations.DeleteModel(
            name='BajaDocumento',
        ),
        migrations.DeleteModel(
            name='Catalogo03',
        ),
        migrations.DeleteModel(
            name='Catalogo07',
        ),
        migrations.DeleteModel(
            name='Catalogo10',
        ),
        migrations.DeleteModel(
            name='Catalogo17',
        ),
        migrations.DeleteModel(
            name='Catalogo54',
        ),
        migrations.DeleteModel(
            name='CatalogProduct',
        ),
        migrations.RemoveField(
            model_name='chofer',
            name='idvehiculo',
        ),
        migrations.RemoveField(
            model_name='cliendire',
            name='idcliente',
        ),
        migrations.RemoveField(
            model_name='compras',
            name='idprovee',
        ),
        migrations.RemoveField(
            model_name='compras',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='cotizacion',
            name='idcliente',
        ),
        migrations.RemoveField(
            model_name='cotizacion',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='cotizacion',
            name='idvende',
        ),
        migrations.RemoveField(
            model_name='detajuste',
            name='idajuste',
        ),
        migrations.RemoveField(
            model_name='detajuste',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detcajaing',
            name='idfactura',
        ),
        migrations.RemoveField(
            model_name='detcajaing',
            name='idingreso',
        ),
        migrations.RemoveField(
            model_name='detcompra',
            name='idcompra',
        ),
        migrations.RemoveField(
            model_name='detcompra',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detcompradoc',
            name='idcompra',
        ),
        migrations.RemoveField(
            model_name='detcompradoc',
            name='proveedor',
        ),
        migrations.RemoveField(
            model_name='detcotiza',
            name='idcotiza',
        ),
        migrations.RemoveField(
            model_name='detcotiza',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detcotiza',
            name='idunidad',
        ),
        migrations.RemoveField(
            model_name='detfactu',
            name='idfactura',
        ),
        migrations.RemoveField(
            model_name='detfactu',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detfactu',
            name='idunidad',
        ),
        migrations.RemoveField(
            model_name='detguia',
            name='idguiar',
        ),
        migrations.RemoveField(
            model_name='detguia',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detordenprodingreso',
            name='idorden',
        ),
        migrations.RemoveField(
            model_name='detordenprodingreso',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='detordenprodsalida',
            name='idorden',
        ),
        migrations.RemoveField(
            model_name='detordenprodsalida',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='doccredito',
            name='idfactura',
        ),
        migrations.RemoveField(
            model_name='docguiarelaci',
            name='idguiar',
        ),
        migrations.RemoveField(
            model_name='docrelaci',
            name='idfactura',
        ),
        migrations.RemoveField(
            model_name='estrategialiberacion',
            name='tipo_doc',
        ),
        migrations.RemoveField(
            model_name='factura',
            name='idcliente',
        ),
        migrations.RemoveField(
            model_name='factura',
            name='idcotiza',
        ),
        migrations.RemoveField(
            model_name='factura',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='factura',
            name='idvende',
        ),
        migrations.RemoveField(
            model_name='guiacompra',
            name='idcompra',
        ),
        migrations.DeleteModel(
            name='GuiaMotivo',
        ),
        migrations.RemoveField(
            model_name='guiarem',
            name='idcliente',
        ),
        migrations.RemoveField(
            model_name='guiarem',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='guiarem',
            name='idsucursal_destino',
        ),
        migrations.RemoveField(
            model_name='guiarem',
            name='idtrans',
        ),
        migrations.RemoveField(
            model_name='ingreso',
            name='idcliente',
        ),
        migrations.RemoveField(
            model_name='ingreso',
            name='idsucursal',
        ),
        migrations.DeleteModel(
            name='Motivo',
        ),
        migrations.RemoveField(
            model_name='nivelaprobacion',
            name='estrategia',
        ),
        migrations.RemoveField(
            model_name='nivelaprobacion',
            name='idaprobador',
        ),
        migrations.DeleteModel(
            name='Numero',
        ),
        migrations.RemoveField(
            model_name='ordencompra',
            name='idestrategia',
        ),
        migrations.RemoveField(
            model_name='ordencompra',
            name='idpersonal',
        ),
        migrations.RemoveField(
            model_name='ordencompra',
            name='idproveedor',
        ),
        migrations.RemoveField(
            model_name='ordencompra',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='ordencompradetalle',
            name='idorden',
        ),
        migrations.RemoveField(
            model_name='ordencompradetalle',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='ordenproduccion',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='ordenproduccion',
            name='operador',
        ),
        migrations.DeleteModel(
            name='OtrasTasas',
        ),
        migrations.RemoveField(
            model_name='precios',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='precios',
            name='moneda',
        ),
        migrations.RemoveField(
            model_name='precios',
            name='unidad',
        ),
        migrations.RemoveField(
            model_name='salida',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='solicitudcompradetalle',
            name='idproduct',
        ),
        migrations.RemoveField(
            model_name='solicitudcompradetalle',
            name='idsolicitud',
        ),
        migrations.RemoveField(
            model_name='solicitudrequerimiento',
            name='idestrategia',
        ),
        migrations.RemoveField(
            model_name='solicitudrequerimiento',
            name='idpersonal',
        ),
        migrations.RemoveField(
            model_name='solicitudrequerimiento',
            name='idproveedor',
        ),
        migrations.RemoveField(
            model_name='solicitudrequerimiento',
            name='idsucursal',
        ),
        migrations.RemoveField(
            model_name='ssgrupo',
            name='idclase',
        ),
        migrations.AlterUniqueTogether(
            name='stocksucursal',
            unique_together=None,
        ),
        migrations.RemoveField(
            model_name='stocksucursal',
            name='producto',
        ),
        migrations.RemoveField(
            model_name='stocksucursal',
            name='sucursal',
        ),
        migrations.RemoveField(
            model_name='subclase',
            name='idclase',
        ),
        migrations.DeleteModel(
            name='TarjetaCre',
        ),
        migrations.DeleteModel(
            name='Tbl1_tipoope',
        ),
        migrations.DeleteModel(
            name='Tbl2Tipdoc',
        ),
        migrations.DeleteModel(
            name='Tip_exitbl05',
        ),
        migrations.DeleteModel(
            name='Tip_opetbl12',
        ),
        migrations.DeleteModel(
            name='Ubigeo',
        ),
        migrations.RemoveField(
            model_name='valorcaracteristica',
            name='idcaracteristica',
        ),
        migrations.RemoveField(
            model_name='valorcaracteristica',
            name='idestrategia',
        ),
        migrations.DeleteModel(
            name='Zonas',
        ),
        migrations.DeleteModel(
            name='CabezeraImpresion',
        ),
        migrations.DeleteModel(
            name='DetalleImpresion',
        ),
        migrations.RemoveConstraint(
            model_name='banco',
            name='banco_list_pkey',
        ),
        migrations.RemoveField(
            model_name='banco',
            name='cod_banco',
        ),
        migrations.AddField(
            model_name='banco',
            name='id_banco',
            field=models.AutoField(default=1, primary_key=True, serialize=False),
            preserve_default=False,
        ),
        migrations.AlterField(
            model_name='banco',
            name='nombre',
            field=models.CharField(max_length=100),
        ),
        migrations.AlterModelTable(
            name='banco',
            table='banco',
        ),
        migrations.DeleteModel(
            name='Ajuste',
        ),
        migrations.DeleteModel(
            name='Aprobacion',
        ),
        migrations.DeleteModel(
            name='Articulos',
        ),
        migrations.DeleteModel(
            name='Caracteristica',
        ),
        migrations.DeleteModel(
            name='Chofer',
        ),
        migrations.DeleteModel(
            name='ClienDire',
        ),
        migrations.DeleteModel(
            name='Clientes',
        ),
        migrations.DeleteModel(
            name='Compras',
        ),
        migrations.DeleteModel(
            name='Cotizacion',
        ),
        migrations.DeleteModel(
            name='Detajuste',
        ),
        migrations.DeleteModel(
            name='DetCajaIng',
        ),
        migrations.DeleteModel(
            name='Detcompra',
        ),
        migrations.DeleteModel(
            name='DetCompraDoc',
        ),
        migrations.DeleteModel(
            name='DetCotiza',
        ),
        migrations.DeleteModel(
            name='Detfactu',
        ),
        migrations.DeleteModel(
            name='Detguia',
        ),
        migrations.DeleteModel(
            name='DetOrdenProdIngreso',
        ),
        migrations.DeleteModel(
            name='DetOrdenProdSalida',
        ),
        migrations.DeleteModel(
            name='DocCredito',
        ),
        migrations.DeleteModel(
            name='DocGuiaRelaci',
        ),
        migrations.DeleteModel(
            name='Docrelaci',
        ),
        migrations.DeleteModel(
            name='EstrategiaLiberacion',
        ),
        migrations.DeleteModel(
            name='Factura',
        ),
        migrations.DeleteModel(
            name='GuiaCompra',
        ),
        migrations.DeleteModel(
            name='Guiarem',
        ),
        migrations.DeleteModel(
            name='Ingreso',
        ),
        migrations.DeleteModel(
            name='Lineas',
        ),
        migrations.DeleteModel(
            name='NivelAprobacion',
        ),
        migrations.DeleteModel(
            name='OrdenCompra',
        ),
        migrations.DeleteModel(
            name='OrdenCompraDetalle',
        ),
        migrations.DeleteModel(
            name='OrdenProduccion',
        ),
        migrations.DeleteModel(
            name='Precios',
        ),
        migrations.DeleteModel(
            name='Proveedor',
        ),
        migrations.DeleteModel(
            name='Salida',
        ),
        migrations.DeleteModel(
            name='SolicitudCompraDetalle',
        ),
        migrations.DeleteModel(
            name='SolicitudRequerimiento',
        ),
        migrations.DeleteModel(
            name='Ssgrupo',
        ),
        migrations.DeleteModel(
            name='StockSucursal',
        ),
        migrations.DeleteModel(
            name='Subclase',
        ),
        migrations.DeleteModel(
            name='Transporte',
        ),
        migrations.DeleteModel(
            name='Unidades',
        ),
        migrations.DeleteModel(
            name='ValorCaracteristica',
        ),
        migrations.DeleteModel(
            name='Vehiculo',
        ),
        migrations.AddField(
            model_name='planilladetalle',
            name='empleado',
            field=models.ForeignKey(db_column='id_empleado', on_delete=django.db.models.deletion.CASCADE, to='app_venin_web_new1.empleado'),
        ),
        migrations.AddField(
            model_name='planilladetalle',
            name='planilla',
            field=models.ForeignKey(db_column='id_planilla', on_delete=django.db.models.deletion.CASCADE, to='app_venin_web_new1.planilla'),
        ),
        migrations.AddField(
            model_name='empleado',
            name='afp',
            field=models.ForeignKey(db_column='id_afp', on_delete=django.db.models.deletion.RESTRICT, to='app_venin_web_new1.regimenpensionario'),
        ),
        migrations.AddField(
            model_name='empleado',
            name='banco',
            field=models.ForeignKey(blank=True, db_column='id_banco', null=True, on_delete=django.db.models.deletion.SET_NULL, to='app_venin_web_new1.banco'),
        ),
        migrations.AddField(
            model_name='empleado',
            name='cargo',
            field=models.ForeignKey(db_column='id_cargo', on_delete=django.db.models.deletion.RESTRICT, to='app_venin_web_new1.cargo'),
        ),
        migrations.AddField(
            model_name='empleado',
            name='departamento',
            field=models.ForeignKey(db_column='id_departamento', on_delete=django.db.models.deletion.RESTRICT, to='app_venin_web_new1.departamento'),
        ),
        migrations.AddField(
            model_name='afptasasmensuales',
            name='afp',
            field=models.ForeignKey(db_column='id_afp', on_delete=django.db.models.deletion.CASCADE, to='app_venin_web_new1.regimenpensionario'),
        ),
        migrations.AlterUniqueTogether(
            name='afptasasmensuales',
            unique_together={('afp', 'periodo')},
        ),
    ]