# Generated by Django 4.2.3 on 2026-05-20 15:00 from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='models_addresses', fields=[ ('id_address', models.CharField(max_length=16, primary_key=True, serialize=False)), ('address_last_modification_date', models.CharField(max_length=16)), ('address_last_modification_user', models.CharField(max_length=16)), ('address_title', models.CharField(max_length=200)), ('address_type', models.CharField(max_length=200)), ('address_number', models.CharField(max_length=20)), ('address_street_name_1', models.CharField(max_length=1000)), ('address_street_name_2', models.CharField(max_length=1000)), ('address_floor', models.CharField(max_length=20)), ('address_postal_code', models.CharField(max_length=20)), ('address_city', models.CharField(max_length=1000)), ('address_country', models.CharField(max_length=1000)), ('address_digicode_1', models.CharField(max_length=20)), ('address_digicode_2', models.CharField(max_length=20)), ], options={ 'db_table': 'table_addresses', }, ), migrations.CreateModel( name='models_alerts', fields=[ ('id_alert', models.CharField(max_length=16, primary_key=True, serialize=False)), ('alert_last_modification_date', models.CharField(max_length=16)), ('alert_last_modification_user', models.CharField(max_length=16)), ('alert_date', models.CharField(max_length=16)), ('alert_content', models.TextField(max_length=60000)), ('alert_contact_id', models.CharField(max_length=16)), ('alert_project_id', models.CharField(max_length=16)), ], options={ 'db_table': 'table_alerts', }, ), migrations.CreateModel( name='models_companies', fields=[ ('id_company', models.CharField(max_length=16, primary_key=True, serialize=False)), ('company_last_modification_date', models.CharField(max_length=16)), ('company_last_modification_user', models.CharField(max_length=16)), ('company_all_company_id', models.CharField(max_length=200)), ('company_name', models.CharField(max_length=200)), ('company_members_id', models.TextField(blank=True)), ('company_projects_id', models.TextField(blank=True)), ('company_addresses_id', models.TextField(blank=True)), ('company_vat_number', models.CharField(max_length=200)), ('company_type', models.CharField(max_length=200)), ('company_head_quarter_address_id', models.CharField(max_length=16)), ], options={ 'db_table': 'table_companies', }, ), migrations.CreateModel( name='models_contacts', fields=[ ('id_contact', models.CharField(max_length=16, primary_key=True, serialize=False)), ('contact_last_modification_date', models.CharField(max_length=16)), ('contact_last_modification_user', models.CharField(max_length=16)), ('contact_all_contact_id', models.CharField(max_length=200)), ('contact_language', models.CharField(max_length=20)), ('contact_gender', models.CharField(max_length=20)), ('contact_last_name', models.CharField(max_length=100)), ('contact_first_name', models.CharField(max_length=100)), ('contact_phone_1', models.CharField(max_length=100)), ('contact_phone_2', models.CharField(max_length=100)), ('contact_email_1', models.CharField(max_length=500)), ('contact_email_2', models.CharField(max_length=100)), ('test', models.JSONField(max_length=500)), ], options={ 'db_table': 'table_contacts', }, ), migrations.CreateModel( name='models_interactions', fields=[ ('id_interaction', models.CharField(max_length=16, primary_key=True, serialize=False)), ('interaction_full_date', models.CharField(max_length=16)), ('interaction_date', models.CharField(max_length=50)), ('interaction_time', models.CharField(max_length=5)), ('interaction_user', models.CharField(max_length=100)), ('interaction_contact_id', models.CharField(max_length=16)), ('interaction_company_id', models.CharField(max_length=5000)), ('interaction_project_id', models.CharField(max_length=16)), ('interaction_content', models.TextField(max_length=60000)), ('interaction_type', models.CharField(max_length=20)), ('interaction_mode', models.CharField(max_length=20)), ], options={ 'db_table': 'table_interactions', }, ), migrations.CreateModel( name='models_products', fields=[ ('id_product', models.CharField(max_length=50, primary_key=True, serialize=False)), ('product_last_modification_date', models.CharField(max_length=16)), ('product_last_modification_user', models.CharField(max_length=16)), ('product_category', models.CharField(max_length=200)), ('product_reference', models.CharField(max_length=200)), ('product_denomination', models.CharField(max_length=200)), ('product_prix_achat', models.CharField(max_length=50)), ('product_prix_vente', models.CharField(max_length=50)), ('product_prix_location', models.CharField(max_length=100)), ('product_poids', models.CharField(max_length=100)), ('product_volume', models.CharField(max_length=500)), ('product_dimensions', models.CharField(max_length=100)), ('product_consommation', models.JSONField(max_length=500)), ('product_quantite_colis', models.JSONField(max_length=500)), ('product_sous_traitant', models.JSONField(max_length=500)), ('product_vat', models.CharField(max_length=3)), ], options={ 'db_table': 'table_products', }, ), migrations.CreateModel( name='models_projects', fields=[ ('id_project', models.CharField(max_length=16, primary_key=True, serialize=False)), ('project_last_modification_date', models.CharField(max_length=16)), ('project_last_modification_user', models.CharField(max_length=16)), ('project_denomination', models.CharField(max_length=200)), ('project_sales_document', models.CharField(max_length=500)), ('project_maturity', models.CharField(max_length=30)), ('project_credibility', models.CharField(max_length=30)), ], options={ 'db_table': 'table_projects', }, ), migrations.CreateModel( name='models_sales_documents', fields=[ ('id_sales_documents', models.CharField(max_length=16, primary_key=True, serialize=False)), ('sales_documents_denomination', models.CharField(max_length=200)), ('sales_documents_last_modification_date', models.CharField(max_length=16)), ('sales_documents_last_modification_user', models.CharField(max_length=16)), ('sales_documents_rent_or_sale', models.CharField(max_length=5)), ('sales_documents_expiration_date', models.CharField(max_length=20)), ('sales_documents_timeline_step', models.CharField(max_length=20)), ('sales_documents_quote_id', models.CharField(max_length=20)), ('sales_documents_quote_number', models.CharField(max_length=20)), ('sales_documents_purchase_order_id', models.CharField(max_length=20)), ('sales_documents_purchase_order_number', models.CharField(max_length=20)), ('sales_documents_delivery_note_id', models.CharField(max_length=20)), ('sales_documents_delivery_note_number', models.CharField(max_length=20)), ('sales_documents_invoice_id', models.CharField(max_length=20)), ('sales_documents_invoice_number', models.CharField(max_length=20)), ('sales_documents_ref_contact_id', models.CharField(max_length=200)), ('sales_documents_billing_address_id', models.CharField(max_length=16)), ('sales_documents_delivery_address_id', models.CharField(max_length=16)), ('sales_documents_payment_conditions', models.CharField(max_length=200)), ('sales_documents_payment_due_date', models.CharField(max_length=200)), ('sales_documents_deposit_id', models.CharField(max_length=200)), ('sales_documents_deposit_number', models.CharField(max_length=200)), ('sales_documents_deposit_date', models.CharField(max_length=200)), ('sales_documents_deposit_amount', models.CharField(max_length=200)), ('sales_documents_deposit_method', models.CharField(max_length=200)), ('sales_documents_index_line_1', models.CharField(max_length=2)), ('sales_documents_quantity_1', models.CharField(max_length=4)), ('sales_documents_description_1', models.CharField(max_length=200)), ('sales_documents_description_free_1', models.CharField(max_length=200)), ('sales_documents_price_1', models.CharField(max_length=10)), ('sales_documents_discount_1', models.CharField(max_length=10)), ('sales_documents_calculated_price_1', models.CharField(max_length=100)), ('sales_documents_discounted_price_1', models.CharField(max_length=10)), ('sales_documents_vat_1', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_2', models.CharField(max_length=2)), ('sales_documents_quantity_2', models.CharField(max_length=4)), ('sales_documents_description_2', models.CharField(max_length=200)), ('sales_documents_description_free_2', models.CharField(max_length=200)), ('sales_documents_price_2', models.CharField(max_length=10)), ('sales_documents_discount_2', models.CharField(max_length=10)), ('sales_documents_calculated_price_2', models.CharField(max_length=100)), ('sales_documents_discounted_price_2', models.CharField(max_length=10)), ('sales_documents_vat_2', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_3', models.CharField(max_length=2)), ('sales_documents_quantity_3', models.CharField(max_length=4)), ('sales_documents_description_3', models.CharField(max_length=200)), ('sales_documents_description_free_3', models.CharField(max_length=200)), ('sales_documents_price_3', models.CharField(max_length=10)), ('sales_documents_discount_3', models.CharField(max_length=10)), ('sales_documents_calculated_price_3', models.CharField(max_length=100)), ('sales_documents_discounted_price_3', models.CharField(max_length=10)), ('sales_documents_vat_3', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_4', models.CharField(max_length=2)), ('sales_documents_quantity_4', models.CharField(max_length=4)), ('sales_documents_description_4', models.CharField(max_length=200)), ('sales_documents_description_free_4', models.CharField(max_length=200)), ('sales_documents_price_4', models.CharField(max_length=10)), ('sales_documents_discount_4', models.CharField(max_length=10)), ('sales_documents_calculated_price_4', models.CharField(max_length=100)), ('sales_documents_discounted_price_4', models.CharField(max_length=10)), ('sales_documents_vat_4', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_5', models.CharField(max_length=2)), ('sales_documents_quantity_5', models.CharField(max_length=4)), ('sales_documents_description_5', models.CharField(max_length=200)), ('sales_documents_description_free_5', models.CharField(max_length=200)), ('sales_documents_price_5', models.CharField(max_length=10)), ('sales_documents_discount_5', models.CharField(max_length=10)), ('sales_documents_calculated_price_5', models.CharField(max_length=100)), ('sales_documents_discounted_price_5', models.CharField(max_length=10)), ('sales_documents_vat_5', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_6', models.CharField(max_length=2)), ('sales_documents_quantity_6', models.CharField(max_length=4)), ('sales_documents_description_6', models.CharField(max_length=200)), ('sales_documents_description_free_6', models.CharField(max_length=200)), ('sales_documents_price_6', models.CharField(max_length=10)), ('sales_documents_discount_6', models.CharField(max_length=10)), ('sales_documents_calculated_price_6', models.CharField(max_length=100)), ('sales_documents_discounted_price_6', models.CharField(max_length=10)), ('sales_documents_vat_6', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_7', models.CharField(max_length=2)), ('sales_documents_quantity_7', models.CharField(max_length=4)), ('sales_documents_description_7', models.CharField(max_length=200)), ('sales_documents_description_free_7', models.CharField(max_length=200)), ('sales_documents_price_7', models.CharField(max_length=10)), ('sales_documents_discount_7', models.CharField(max_length=10)), ('sales_documents_calculated_price_7', models.CharField(max_length=100)), ('sales_documents_discounted_price_7', models.CharField(max_length=10)), ('sales_documents_vat_7', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_8', models.CharField(max_length=2)), ('sales_documents_quantity_8', models.CharField(max_length=4)), ('sales_documents_description_8', models.CharField(max_length=200)), ('sales_documents_description_free_8', models.CharField(max_length=200)), ('sales_documents_price_8', models.CharField(max_length=10)), ('sales_documents_discount_8', models.CharField(max_length=10)), ('sales_documents_calculated_price_8', models.CharField(max_length=100)), ('sales_documents_discounted_price_8', models.CharField(max_length=10)), ('sales_documents_vat_8', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_9', models.CharField(max_length=2)), ('sales_documents_quantity_9', models.CharField(max_length=4)), ('sales_documents_description_9', models.CharField(max_length=200)), ('sales_documents_description_free_9', models.CharField(max_length=200)), ('sales_documents_price_9', models.CharField(max_length=10)), ('sales_documents_discount_9', models.CharField(max_length=10)), ('sales_documents_calculated_price_9', models.CharField(max_length=100)), ('sales_documents_discounted_price_9', models.CharField(max_length=10)), ('sales_documents_vat_9', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_10', models.CharField(max_length=2)), ('sales_documents_quantity_10', models.CharField(max_length=4)), ('sales_documents_description_10', models.CharField(max_length=200)), ('sales_documents_description_free_10', models.CharField(max_length=200)), ('sales_documents_price_10', models.CharField(max_length=10)), ('sales_documents_discount_10', models.CharField(max_length=10)), ('sales_documents_calculated_price_10', models.CharField(max_length=100)), ('sales_documents_discounted_price_10', models.CharField(max_length=10)), ('sales_documents_vat_10', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_11', models.CharField(max_length=2)), ('sales_documents_quantity_11', models.CharField(max_length=4)), ('sales_documents_description_11', models.CharField(max_length=200)), ('sales_documents_description_free_11', models.CharField(max_length=200)), ('sales_documents_price_11', models.CharField(max_length=10)), ('sales_documents_discount_11', models.CharField(max_length=10)), ('sales_documents_calculated_price_11', models.CharField(max_length=100)), ('sales_documents_discounted_price_11', models.CharField(max_length=10)), ('sales_documents_vat_11', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_12', models.CharField(max_length=2)), ('sales_documents_quantity_12', models.CharField(max_length=4)), ('sales_documents_description_12', models.CharField(max_length=200)), ('sales_documents_description_free_12', models.CharField(max_length=200)), ('sales_documents_price_12', models.CharField(max_length=10)), ('sales_documents_discount_12', models.CharField(max_length=10)), ('sales_documents_calculated_price_12', models.CharField(max_length=100)), ('sales_documents_discounted_price_12', models.CharField(max_length=10)), ('sales_documents_vat_12', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_13', models.CharField(max_length=2)), ('sales_documents_quantity_13', models.CharField(max_length=4)), ('sales_documents_description_13', models.CharField(max_length=200)), ('sales_documents_description_free_13', models.CharField(max_length=200)), ('sales_documents_price_13', models.CharField(max_length=10)), ('sales_documents_discount_13', models.CharField(max_length=10)), ('sales_documents_calculated_price_13', models.CharField(max_length=100)), ('sales_documents_discounted_price_13', models.CharField(max_length=10)), ('sales_documents_vat_13', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_14', models.CharField(max_length=2)), ('sales_documents_quantity_14', models.CharField(max_length=4)), ('sales_documents_description_14', models.CharField(max_length=200)), ('sales_documents_description_free_14', models.CharField(max_length=200)), ('sales_documents_price_14', models.CharField(max_length=10)), ('sales_documents_discount_14', models.CharField(max_length=10)), ('sales_documents_calculated_price_14', models.CharField(max_length=100)), ('sales_documents_discounted_price_14', models.CharField(max_length=10)), ('sales_documents_vat_14', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_15', models.CharField(max_length=2)), ('sales_documents_quantity_15', models.CharField(max_length=4)), ('sales_documents_description_15', models.CharField(max_length=200)), ('sales_documents_description_free_15', models.CharField(max_length=200)), ('sales_documents_price_15', models.CharField(max_length=10)), ('sales_documents_discount_15', models.CharField(max_length=10)), ('sales_documents_calculated_price_15', models.CharField(max_length=100)), ('sales_documents_discounted_price_15', models.CharField(max_length=10)), ('sales_documents_vat_15', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_16', models.CharField(max_length=2)), ('sales_documents_quantity_16', models.CharField(max_length=4)), ('sales_documents_description_16', models.CharField(max_length=200)), ('sales_documents_description_free_16', models.CharField(max_length=200)), ('sales_documents_price_16', models.CharField(max_length=10)), ('sales_documents_discount_16', models.CharField(max_length=10)), ('sales_documents_calculated_price_16', models.CharField(max_length=100)), ('sales_documents_discounted_price_16', models.CharField(max_length=10)), ('sales_documents_vat_16', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_17', models.CharField(max_length=2)), ('sales_documents_quantity_17', models.CharField(max_length=4)), ('sales_documents_description_17', models.CharField(max_length=200)), ('sales_documents_description_free_17', models.CharField(max_length=200)), ('sales_documents_price_17', models.CharField(max_length=10)), ('sales_documents_discount_17', models.CharField(max_length=10)), ('sales_documents_calculated_price_17', models.CharField(max_length=100)), ('sales_documents_discounted_price_17', models.CharField(max_length=10)), ('sales_documents_vat_17', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_18', models.CharField(max_length=2)), ('sales_documents_quantity_18', models.CharField(max_length=4)), ('sales_documents_description_18', models.CharField(max_length=200)), ('sales_documents_description_free_18', models.CharField(max_length=200)), ('sales_documents_price_18', models.CharField(max_length=10)), ('sales_documents_discount_18', models.CharField(max_length=10)), ('sales_documents_calculated_price_18', models.CharField(max_length=100)), ('sales_documents_discounted_price_18', models.CharField(max_length=10)), ('sales_documents_vat_18', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_19', models.CharField(max_length=2)), ('sales_documents_quantity_19', models.CharField(max_length=4)), ('sales_documents_description_19', models.CharField(max_length=200)), ('sales_documents_description_free_19', models.CharField(max_length=200)), ('sales_documents_price_19', models.CharField(max_length=10)), ('sales_documents_discount_19', models.CharField(max_length=10)), ('sales_documents_calculated_price_19', models.CharField(max_length=100)), ('sales_documents_discounted_price_19', models.CharField(max_length=10)), ('sales_documents_vat_19', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_20', models.CharField(max_length=2)), ('sales_documents_quantity_20', models.CharField(max_length=4)), ('sales_documents_description_20', models.CharField(max_length=200)), ('sales_documents_description_free_20', models.CharField(max_length=200)), ('sales_documents_price_20', models.CharField(max_length=10)), ('sales_documents_discount_20', models.CharField(max_length=10)), ('sales_documents_calculated_price_20', models.CharField(max_length=100)), ('sales_documents_discounted_price_20', models.CharField(max_length=10)), ('sales_documents_vat_20', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_21', models.CharField(max_length=2)), ('sales_documents_quantity_21', models.CharField(max_length=4)), ('sales_documents_description_21', models.CharField(max_length=200)), ('sales_documents_description_free_21', models.CharField(max_length=200)), ('sales_documents_price_21', models.CharField(max_length=10)), ('sales_documents_discount_21', models.CharField(max_length=10)), ('sales_documents_calculated_price_21', models.CharField(max_length=100)), ('sales_documents_discounted_price_21', models.CharField(max_length=10)), ('sales_documents_vat_21', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_22', models.CharField(max_length=2)), ('sales_documents_quantity_22', models.CharField(max_length=4)), ('sales_documents_description_22', models.CharField(max_length=200)), ('sales_documents_description_free_22', models.CharField(max_length=200)), ('sales_documents_price_22', models.CharField(max_length=10)), ('sales_documents_discount_22', models.CharField(max_length=10)), ('sales_documents_calculated_price_22', models.CharField(max_length=100)), ('sales_documents_discounted_price_22', models.CharField(max_length=10)), ('sales_documents_vat_22', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_23', models.CharField(max_length=2)), ('sales_documents_quantity_23', models.CharField(max_length=4)), ('sales_documents_description_23', models.CharField(max_length=200)), ('sales_documents_description_free_23', models.CharField(max_length=200)), ('sales_documents_price_23', models.CharField(max_length=10)), ('sales_documents_discount_23', models.CharField(max_length=10)), ('sales_documents_calculated_price_23', models.CharField(max_length=100)), ('sales_documents_discounted_price_23', models.CharField(max_length=10)), ('sales_documents_vat_23', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_24', models.CharField(max_length=2)), ('sales_documents_quantity_24', models.CharField(max_length=4)), ('sales_documents_description_24', models.CharField(max_length=200)), ('sales_documents_description_free_24', models.CharField(max_length=200)), ('sales_documents_price_24', models.CharField(max_length=10)), ('sales_documents_discount_24', models.CharField(max_length=10)), ('sales_documents_calculated_price_24', models.CharField(max_length=100)), ('sales_documents_discounted_price_24', models.CharField(max_length=10)), ('sales_documents_vat_24', models.PositiveSmallIntegerField(default=0)), ('sales_documents_index_line_25', models.CharField(max_length=2)), ('sales_documents_quantity_25', models.CharField(max_length=4)), ('sales_documents_description_25', models.CharField(max_length=200)), ('sales_documents_description_free_25', models.CharField(max_length=200)), ('sales_documents_price_25', models.CharField(max_length=10)), ('sales_documents_discount_25', models.CharField(max_length=10)), ('sales_documents_calculated_price_25', models.CharField(max_length=100)), ('sales_documents_discounted_price_25', models.CharField(max_length=10)), ('sales_documents_vat_25', models.PositiveSmallIntegerField(default=0)), ], options={ 'db_table': 'table_sales_documents', }, ), migrations.CreateModel( name='models_sales_document_lines', fields=[ ('id_sales_document_line', models.BigAutoField(primary_key=True, serialize=False)), ('sales_documents_line_number', models.PositiveSmallIntegerField()), ('sales_documents_line_position', models.PositiveSmallIntegerField()), ('sales_documents_quantity', models.CharField(blank=True, max_length=4)), ('sales_documents_description_free', models.CharField(blank=True, max_length=200)), ('sales_documents_price', models.CharField(blank=True, max_length=10)), ('sales_documents_discount', models.CharField(blank=True, max_length=10)), ('sales_documents_calculated_price', models.CharField(blank=True, max_length=100)), ('sales_documents_discounted_price', models.CharField(blank=True, max_length=10)), ('sales_documents_vat', models.PositiveSmallIntegerField(default=0)), ('product', models.ForeignKey(blank=True, db_column='product_id', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='sales_document_lines', to='app_files.models_products')), ('sales_document', models.ForeignKey(db_column='sales_document_id', on_delete=django.db.models.deletion.CASCADE, related_name='sales_document_lines', to='app_files.models_sales_documents')), ], options={ 'db_table': 'table_sales_document_lines', 'ordering': ['sales_documents_line_position', 'sales_documents_line_number'], }, ), migrations.CreateModel( name='models_sales_document_deposits', fields=[ ('id_sales_document_deposit', models.BigAutoField(primary_key=True, serialize=False)), ('sales_documents_deposit_id', models.CharField(blank=True, max_length=20)), ('sales_documents_deposit_number', models.CharField(blank=True, max_length=200)), ('sales_documents_deposit_date', models.CharField(blank=True, max_length=200)), ('sales_documents_deposit_amount', models.CharField(blank=True, max_length=200)), ('sales_documents_deposit_method', models.CharField(blank=True, max_length=200)), ('sales_documents_deposit_created_at', models.DateTimeField(auto_now_add=True)), ('sales_document', models.ForeignKey(db_column='sales_document_id', on_delete=django.db.models.deletion.CASCADE, related_name='sales_document_deposits', to='app_files.models_sales_documents')), ], options={ 'db_table': 'table_sales_document_deposits', }, ), migrations.CreateModel( name='models_interaction_companies', fields=[ ('id_interaction_company', models.BigAutoField(primary_key=True, serialize=False)), ('company', models.ForeignKey(db_column='company_id', on_delete=django.db.models.deletion.CASCADE, related_name='interaction_companies', to='app_files.models_companies')), ('interaction', models.ForeignKey(db_column='interaction_id', on_delete=django.db.models.deletion.CASCADE, related_name='interaction_companies', to='app_files.models_interactions')), ], options={ 'db_table': 'table_interaction_companies', }, ), migrations.CreateModel( name='models_company_contacts', fields=[ ('id_company_contact', models.BigAutoField(primary_key=True, serialize=False)), ('company_contact_role', models.CharField(blank=True, max_length=100)), ('company_contact_is_main', models.BooleanField(default=False)), ('company_contact_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_contacts', to='app_files.models_companies')), ('contact', models.ForeignKey(db_column='contact_id', on_delete=django.db.models.deletion.CASCADE, related_name='company_contacts', to='app_files.models_contacts')), ], options={ 'db_table': 'table_company_contacts', }, ), migrations.CreateModel( name='models_add_contacts', fields=[ ], options={ 'verbose_name': 'models_add_contacts', 'verbose_name_plural': 'models_add_contacts', 'proxy': True, 'indexes': [], 'constraints': [], }, bases=('app_files.models_contacts',), ), migrations.AddConstraint( model_name='models_sales_document_lines', constraint=models.UniqueConstraint(fields=('sales_document', 'sales_documents_line_number'), name='unique_sales_document_line_number'), ), migrations.AddConstraint( model_name='models_sales_document_lines', constraint=models.UniqueConstraint(fields=('sales_document', 'sales_documents_line_position'), name='unique_sales_document_line_position'), ), migrations.AddConstraint( model_name='models_interaction_companies', constraint=models.UniqueConstraint(fields=('interaction', 'company'), name='unique_interaction_company'), ), migrations.AddConstraint( model_name='models_company_contacts', constraint=models.UniqueConstraint(fields=('company', 'contact'), name='unique_company_contact'), ), ]