# Generated by Django 3.2.5 on 2021-07-26 15:34

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('departamentos', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Cobros',
            fields=[
                ('cobro_id', models.AutoField(db_column='cobro_id', primary_key=True, serialize=False)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('user_perfil_id_anula', models.IntegerField(blank=True, null=True)),
                ('motivo_anula', models.CharField(blank=True, max_length=250, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros',
            },
        ),
        migrations.CreateModel(
            name='CobrosDetallesAnulados',
            fields=[
                ('cobro_detalle_anulado_id', models.AutoField(db_column='cobro_detalle_anulado_id', primary_key=True, serialize=False)),
                ('cobro_detalle_id', models.IntegerField(default=0)),
                ('cobro_id', models.IntegerField(default=0)),
                ('lectura_id', models.IntegerField(blank=True, default=0, null=True)),
                ('cobro_cobro_mensual_id', models.IntegerField(blank=True, default=0, null=True)),
                ('cobro_cobro_manual_id', models.IntegerField(blank=True, default=0, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('detalle', models.CharField(max_length=250)),
                ('observacion', models.CharField(max_length=250)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
            ],
            options={
                'db_table': 'cobros_detalles_anulados',
            },
        ),
        migrations.CreateModel(
            name='LecturasAnulados',
            fields=[
                ('lectura_anulado_id', models.AutoField(db_column='lectura_anulado_id', primary_key=True, serialize=False)),
                ('lectura_id', models.IntegerField(default=0)),
                ('periodo', models.CharField(max_length=20)),
                ('lectura', models.IntegerField()),
                ('costo_m3', models.DecimalField(decimal_places=2, max_digits=12)),
                ('consumo', models.DecimalField(decimal_places=2, max_digits=12)),
                ('observacion', models.CharField(max_length=250)),
                ('metros2', models.DecimalField(decimal_places=2, max_digits=12)),
                ('costo_expensas_m2', models.DecimalField(decimal_places=2, max_digits=12)),
                ('total_expensas', models.DecimalField(decimal_places=2, max_digits=12)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(default=0)),
                ('caja_id', models.IntegerField(default=0)),
                ('user_perfil_id_anula', models.IntegerField(blank=True, null=True)),
                ('motivo_anula', models.CharField(blank=True, max_length=250, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'lecturas_anulados',
            },
        ),
        migrations.CreateModel(
            name='Lecturas',
            fields=[
                ('lectura_id', models.AutoField(db_column='lectura_id', primary_key=True, serialize=False)),
                ('periodo', models.CharField(max_length=20)),
                ('lectura', models.IntegerField()),
                ('costo_m3', models.DecimalField(decimal_places=2, max_digits=12)),
                ('consumo', models.DecimalField(decimal_places=2, max_digits=12)),
                ('observacion', models.CharField(max_length=250)),
                ('metros2', models.DecimalField(decimal_places=2, max_digits=12)),
                ('costo_expensas_m2', models.DecimalField(decimal_places=2, max_digits=12)),
                ('total_expensas', models.DecimalField(decimal_places=2, max_digits=12)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(default=0)),
                ('caja_id', models.IntegerField(default=0)),
                ('user_perfil_id_anula', models.IntegerField(blank=True, null=True)),
                ('motivo_anula', models.CharField(blank=True, max_length=250, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'lecturas',
            },
        ),
        migrations.CreateModel(
            name='CobrosMensualesPeriodos',
            fields=[
                ('cobro_mensual_periodo_id', models.AutoField(db_column='cobro_mensual_periodo_id', primary_key=True, serialize=False)),
                ('periodo', models.CharField(max_length=20)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_mensual_id', models.ForeignKey(db_column='cobro_mensual_id', on_delete=django.db.models.deletion.PROTECT, to='configuraciones.cobrosmensuales')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_mensuales_periodos',
            },
        ),
        migrations.CreateModel(
            name='CobrosDetalles',
            fields=[
                ('cobro_detalle_id', models.AutoField(db_column='cobro_detalle_id', primary_key=True, serialize=False)),
                ('lectura_id', models.IntegerField(blank=True, default=0, null=True)),
                ('cobro_cobro_mensual_id', models.IntegerField(blank=True, default=0, null=True)),
                ('cobro_cobro_manual_id', models.IntegerField(blank=True, default=0, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('detalle', models.CharField(max_length=250)),
                ('observacion', models.CharField(max_length=250)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_id', models.ForeignKey(db_column='cobro_id', on_delete=django.db.models.deletion.PROTECT, to='lecturas.cobros')),
            ],
            options={
                'db_table': 'cobros_detalles',
            },
        ),
        migrations.CreateModel(
            name='CobrosCobrosMensualesAnulados',
            fields=[
                ('cobro_cobro_mensual_anulado_id', models.AutoField(db_column='cobro_cobro_mensual_anulado_id', primary_key=True, serialize=False)),
                ('cobro_cobro_mensual_id', models.IntegerField(default=0)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_mensual_id', models.ForeignKey(db_column='cobro_mensual_id', on_delete=django.db.models.deletion.PROTECT, to='configuraciones.cobrosmensuales')),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_cobros_mensuales_anulados',
            },
        ),
        migrations.CreateModel(
            name='CobrosCobrosMensuales',
            fields=[
                ('cobro_cobro_mensual_id', models.AutoField(db_column='cobro_cobro_mensual_id', primary_key=True, serialize=False)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_mensual_id', models.ForeignKey(db_column='cobro_mensual_id', on_delete=django.db.models.deletion.PROTECT, to='configuraciones.cobrosmensuales')),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_cobros_mensuales',
            },
        ),
        migrations.CreateModel(
            name='CobrosCobrosManualesAnulados',
            fields=[
                ('cobro_cobro_manual_anulado_id', models.AutoField(db_column='cobro_cobro_manual_anulado_id', primary_key=True, serialize=False)),
                ('cobro_cobro_manual_id', models.IntegerField(default=0)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_manual_id', models.ForeignKey(db_column='cobro_manual_id', on_delete=django.db.models.deletion.PROTECT, to='configuraciones.cobrosmanuales')),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_cobros_manuales_anulados',
            },
        ),
        migrations.CreateModel(
            name='CobrosCobrosManuales',
            fields=[
                ('cobro_cobro_manual_id', models.AutoField(db_column='cobro_cobro_manual_id', primary_key=True, serialize=False)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('cobro_manual_id', models.ForeignKey(db_column='cobro_manual_id', on_delete=django.db.models.deletion.PROTECT, to='configuraciones.cobrosmanuales')),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_cobros_manuales',
            },
        ),
        migrations.CreateModel(
            name='CobrosAnulados',
            fields=[
                ('cobro_anulado_id', models.AutoField(db_column='cobro_anulado_id', primary_key=True, serialize=False)),
                ('cobro_id', models.IntegerField(default=0)),
                ('fecha_cobro', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('monto_bs', models.DecimalField(decimal_places=2, max_digits=12)),
                ('periodo', models.CharField(max_length=20)),
                ('observacion', models.CharField(max_length=250)),
                ('user_perfil_id_cobro', models.IntegerField(blank=True, default=0, null=True)),
                ('punto_id', models.IntegerField(blank=True, default=0, null=True)),
                ('caja_id', models.IntegerField(blank=True, default=0, null=True)),
                ('user_perfil_id_anula', models.IntegerField(blank=True, null=True)),
                ('motivo_anula', models.CharField(blank=True, max_length=250, null=True)),
                ('created_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('updated_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('deleted_at', utils.custome_db_types.DateTimeFieldCustome(blank=True, null=True)),
                ('departamento_id', models.ForeignKey(db_column='departamento_id', on_delete=django.db.models.deletion.PROTECT, to='departamentos.departamentos')),
                ('status_id', models.ForeignKey(db_column='status_id', on_delete=django.db.models.deletion.PROTECT, to='status.status')),
                ('user_perfil_id', models.ForeignKey(db_column='user_perfil_id', on_delete=django.db.models.deletion.PROTECT, to='permisos.usersperfiles')),
            ],
            options={
                'db_table': 'cobros_anulados',
            },
        ),
    ]
