# Generated by Django 4.2.28 on 2026-02-23 13:42

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='VISysRefVerbrauchsDS',
            fields=[
                ('RefVerBrDatID', models.IntegerField(primary_key=True, serialize=False)),
                ('RefVerBrSD', models.DateField(blank=True, null=True)),
                ('RefVerBrED', models.DateField(blank=True, null=True)),
                ('RefVerBrWert', models.FloatField(blank=True, null=True)),
                ('RefVerBrID', models.IntegerField(blank=True, null=True)),
                ('RefVerBrWertNormA', models.FloatField(blank=True, null=True)),
            ],
            options={
                'db_table': 'tbl_v_i_sys_ref_ver_daten',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='VISysVerbrauchArt',
            fields=[
                ('VISysVerbrauchsArtID', models.AutoField(primary_key=True, serialize=False)),
                ('VAName', models.CharField(blank=True, max_length=60, null=True)),
            ],
            options={
                'db_table': 'tbl_v_i_sys_ver_arten',
                'managed': False,  # bleibt False in 0001
            },
        ),
        migrations.CreateModel(
            name='VISysVerbrauchRahmen',
            fields=[
                ('VISysVerbrauchsID', models.AutoField(primary_key=True, serialize=False)),
                ('MietVID', models.IntegerField(blank=True, null=True)),
                ('Jahr', models.IntegerField(blank=True, null=True)),
                ('VISysVerbrauchsArtID', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'tbl_v_i_sys_ver_rahmen',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='VISysVerbrauchsDS',
            fields=[
                ('VerBrDatID', models.IntegerField(primary_key=True, serialize=False)),
                ('VerBrSD', models.DateField(blank=True, null=True)),
                ('VerBrED', models.DateField(blank=True, null=True)),
                ('VerBrWert', models.FloatField(blank=True, null=True)),
                ('VerBrID', models.IntegerField(blank=True, null=True)),
                ('VerBrWertNormA', models.FloatField(blank=True, null=True)),
            ],
            options={
                'db_table': 'tbl_v_i_sys_verbrauchs_daten',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='VISysRefVerbrauchRahmen',
            fields=[
                ('VISysRefVerbrID', models.AutoField(primary_key=True, serialize=False)),
                ('REID', models.IntegerField(blank=True, null=True)),
                ('Jahr', models.IntegerField(blank=True, null=True)),
                ('VISysVerbrauchsArtID', models.IntegerField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True, null=True)),
                ('updated_at', models.DateTimeField(auto_now=True, null=True)),
            ],
            options={
                'db_table': 'tbl_v_i_sys_ref_ver_rahmen',
                'managed': True,
            },
        ),
    ]