# Generated by Django 4.2.3 on 2026-05-20 15:47

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


class Migration(migrations.Migration):

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

    operations = [
        migrations.CreateModel(
            name='models_project_sales_documents',
            fields=[
                ('id_project_sales_document', models.BigAutoField(primary_key=True, serialize=False)),
                ('project_sales_document_created_at', models.DateTimeField(auto_now_add=True)),
                ('project', models.ForeignKey(db_column='project_id', on_delete=django.db.models.deletion.CASCADE, related_name='project_sales_documents_links', to='app_files.models_projects')),
                ('sales_document', models.ForeignKey(db_column='sales_document_id', on_delete=django.db.models.deletion.CASCADE, related_name='project_sales_documents_links', to='app_files.models_sales_documents')),
            ],
            options={
                'db_table': 'table_project_sales_documents',
            },
        ),
        migrations.CreateModel(
            name='models_company_projects',
            fields=[
                ('id_company_project', models.BigAutoField(primary_key=True, serialize=False)),
                ('company_project_created_at', models.DateTimeField(auto_now_add=True)),
                ('company', models.ForeignKey(db_column='company_id', on_delete=django.db.models.deletion.CASCADE, related_name='company_projects_links', to='app_files.models_companies')),
                ('project', models.ForeignKey(db_column='project_id', on_delete=django.db.models.deletion.CASCADE, related_name='company_projects_links', to='app_files.models_projects')),
            ],
            options={
                'db_table': 'table_company_projects',
            },
        ),
        migrations.CreateModel(
            name='models_company_addresses',
            fields=[
                ('id_company_address', models.BigAutoField(primary_key=True, serialize=False)),
                ('company_address_created_at', models.DateTimeField(auto_now_add=True)),
                ('address', models.ForeignKey(db_column='address_id', on_delete=django.db.models.deletion.CASCADE, related_name='company_addresses_links', to='app_files.models_addresses')),
                ('company', models.ForeignKey(db_column='company_id', on_delete=django.db.models.deletion.CASCADE, related_name='company_addresses_links', to='app_files.models_companies')),
            ],
            options={
                'db_table': 'table_company_addresses',
            },
        ),
        migrations.AddConstraint(
            model_name='models_project_sales_documents',
            constraint=models.UniqueConstraint(fields=('project', 'sales_document'), name='unique_project_sales_document'),
        ),
        migrations.AddConstraint(
            model_name='models_company_projects',
            constraint=models.UniqueConstraint(fields=('company', 'project'), name='unique_company_project'),
        ),
        migrations.AddConstraint(
            model_name='models_company_addresses',
            constraint=models.UniqueConstraint(fields=('company', 'address'), name='unique_company_address'),
        ),
    ]