# Generated by Django 4.1.6 on 2023-02-23 14:43

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Assinantes',
            fields=[
                ('assinante_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('nome', models.CharField(default=None, max_length=100, null=True)),
                ('sobrenome', models.CharField(default=None, max_length=100, null=True)),
                ('email', models.EmailField(default=None, max_length=254, null=True)),
                ('data_nascimento', models.DateField(default=None, null=True)),
                ('razao_social', models.CharField(default=None, max_length=100, null=True)),
                ('nome_fantasia', models.CharField(default=None, max_length=100, null=True)),
            ],
            options={
                'db_table': 'fatoAssinantes',
            },
        ),
        migrations.CreateModel(
            name='Assinaturas',
            fields=[
                ('assinatura_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('assinatura_data', models.DateTimeField(default=None, null=True)),
                ('status', models.CharField(default=None, max_length=50, null=True)),
                ('early_adopter', models.IntegerField(default=None, null=True)),
                ('cancelamento', models.IntegerField(default=None, null=True)),
                ('contrato', models.IntegerField(default=None, null=True)),
                ('assinante', models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.assinantes')),
            ],
            options={
                'db_table': 'fatoAssinaturas',
            },
        ),
        migrations.CreateModel(
            name='EstadosCivis',
            fields=[
                ('estado_civil_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('estado_civil', models.CharField(default=None, max_length=100, null=True)),
            ],
            options={
                'db_table': 'dimEstadosCivis',
            },
        ),
        migrations.CreateModel(
            name='FormasdePagamento',
            fields=[
                ('forma_pagamento_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('forma_pagamento', models.CharField(default=None, max_length=100, null=True)),
            ],
            options={
                'db_table': 'dimFormasdePagamento',
            },
        ),
        migrations.CreateModel(
            name='Planos',
            fields=[
                ('plano_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('plano', models.CharField(default=None, max_length=100, null=True)),
            ],
            options={
                'db_table': 'dimPlanos',
            },
        ),
        migrations.CreateModel(
            name='Regioes',
            fields=[
                ('regiao_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('bairro', models.CharField(default=None, max_length=100, null=True)),
                ('cidade', models.CharField(default=None, max_length=100, null=True)),
                ('estado', models.CharField(default=None, max_length=100, null=True)),
            ],
            options={
                'db_table': 'dimRegioes',
            },
        ),
        migrations.CreateModel(
            name='Pagamentos',
            fields=[
                ('pagamento_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('pagamento_data', models.DateTimeField(default=None, null=True)),
                ('valor', models.DecimalField(decimal_places=2, max_digits=6)),
                ('assinante', models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.assinantes')),
                ('assinatura', models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.assinaturas')),
                ('forma_pagamento', models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.formasdepagamento')),
            ],
            options={
                'db_table': 'fatoPagamentos',
            },
        ),
        migrations.AddField(
            model_name='assinaturas',
            name='plano',
            field=models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.planos'),
        ),
        migrations.AddField(
            model_name='assinantes',
            name='estado_civil',
            field=models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.estadoscivis'),
        ),
        migrations.AddField(
            model_name='assinantes',
            name='regiao',
            field=models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.regioes'),
        ),
        migrations.CreateModel(
            name='Acessos',
            fields=[
                ('acesso_id', models.IntegerField(default=None, primary_key=True, serialize=False, unique=True)),
                ('acesso_data', models.DateTimeField(default=None, null=True)),
                ('assinante', models.ForeignKey(default=None, on_delete=django.db.models.deletion.PROTECT, to='MaxHunterAPI.assinantes')),
            ],
            options={
                'db_table': 'fatoAcessos',
            },
        ),
    ]