# Generated by Django 5.2.12 on 2026-09-06 17:40 import django.db.models.deletion from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('core', '0001_initial'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='PriceLevel', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('is_deleted', models.BooleanField(default=False)), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('ext_data', models.JSONField(blank=True, default=dict)), ('source_channel', models.CharField(blank=True, default='manual', max_length=32)), ('code', models.CharField(max_length=32)), ('name', models.CharField(max_length=64)), ('discount_rate', models.DecimalField(decimal_places=4, default=0, help_text='默认折扣率', max_digits=6)), ('sort_order', models.IntegerField(default=0)), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('org', models.ForeignKey(blank=True, help_text='所属组织(多机构预留)', null=True, on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.org')), ('tenant', models.ForeignKey(help_text='所属租户', on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.tenant')), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name_plural': '价格等级', 'db_table': 'partner_price_level', 'ordering': ['sort_order', 'code'], 'unique_together': {('tenant', 'code')}, }, ), migrations.CreateModel( name='Customer', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('is_deleted', models.BooleanField(default=False)), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('ext_data', models.JSONField(blank=True, default=dict)), ('source_channel', models.CharField(blank=True, default='manual', max_length=32)), ('code', models.CharField(help_text='客户编码(租户内唯一)', max_length=64)), ('name', models.CharField(max_length=128)), ('kind', models.CharField(choices=[('individual', '个人'), ('company', '企业')], default='company', max_length=16)), ('contact_name', models.CharField(blank=True, default='', max_length=64)), ('phone', models.CharField(blank=True, default='', max_length=32)), ('email', models.EmailField(blank=True, default='', max_length=254)), ('address', models.CharField(blank=True, default='', max_length=255)), ('tax_number', models.CharField(blank=True, default='', help_text='税号', max_length=64)), ('bank_account', models.CharField(blank=True, default='', max_length=64)), ('credit_limit', models.DecimalField(decimal_places=4, default=0, help_text='信用额度', max_digits=18)), ('initial_receivable', models.DecimalField(decimal_places=4, default=0, help_text='期初应收', max_digits=18)), ('is_active', models.BooleanField(default=True)), ('remark', models.TextField(blank=True, default='')), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('org', models.ForeignKey(blank=True, help_text='所属组织(多机构预留)', null=True, on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.org')), ('tenant', models.ForeignKey(help_text='所属租户', on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.tenant')), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('price_level', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='customers', to='partner.pricelevel')), ], options={ 'verbose_name_plural': '客户', 'db_table': 'partner_customer', 'ordering': ['code'], }, ), migrations.CreateModel( name='Supplier', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('is_deleted', models.BooleanField(default=False)), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('ext_data', models.JSONField(blank=True, default=dict)), ('source_channel', models.CharField(blank=True, default='manual', max_length=32)), ('code', models.CharField(max_length=64)), ('name', models.CharField(max_length=128)), ('contact_name', models.CharField(blank=True, default='', max_length=64)), ('phone', models.CharField(blank=True, default='', max_length=32)), ('email', models.EmailField(blank=True, default='', max_length=254)), ('address', models.CharField(blank=True, default='', max_length=255)), ('tax_number', models.CharField(blank=True, default='', max_length=64)), ('bank_account', models.CharField(blank=True, default='', max_length=64)), ('initial_payable', models.DecimalField(decimal_places=4, default=0, help_text='期初应付', max_digits=18)), ('is_active', models.BooleanField(default=True)), ('remark', models.TextField(blank=True, default='')), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('org', models.ForeignKey(blank=True, help_text='所属组织(多机构预留)', null=True, on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.org')), ('tenant', models.ForeignKey(help_text='所属租户', on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.tenant')), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name_plural': '供应商', 'db_table': 'partner_supplier', 'ordering': ['code'], }, ), migrations.CreateModel( name='Contact', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('is_deleted', models.BooleanField(default=False)), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('ext_data', models.JSONField(blank=True, default=dict)), ('source_channel', models.CharField(blank=True, default='manual', max_length=32)), ('name', models.CharField(max_length=64)), ('phone', models.CharField(blank=True, default='', max_length=32)), ('email', models.EmailField(blank=True, default='', max_length=254)), ('title', models.CharField(blank=True, default='', help_text='职位/称呼', max_length=64)), ('is_primary', models.BooleanField(default=False, help_text='是否主联系人')), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('org', models.ForeignKey(blank=True, help_text='所属组织(多机构预留)', null=True, on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.org')), ('tenant', models.ForeignKey(help_text='所属租户', on_delete=django.db.models.deletion.PROTECT, related_name='+', to='core.tenant')), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('customer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='contacts', to='partner.customer')), ('supplier', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='contacts', to='partner.supplier')), ], options={ 'verbose_name_plural': '联系人', 'db_table': 'partner_contact', }, ), migrations.AddIndex( model_name='customer', index=models.Index(fields=['tenant', 'code'], name='partner_cus_tenant__2867db_idx'), ), migrations.AddIndex( model_name='customer', index=models.Index(fields=['tenant', 'name'], name='partner_cus_tenant__2624be_idx'), ), migrations.AddIndex( model_name='customer', index=models.Index(fields=['tenant', 'phone'], name='partner_cus_tenant__5c39f9_idx'), ), migrations.AlterUniqueTogether( name='customer', unique_together={('tenant', 'code')}, ), migrations.AddIndex( model_name='supplier', index=models.Index(fields=['tenant', 'code'], name='partner_sup_tenant__16257e_idx'), ), migrations.AddIndex( model_name='supplier', index=models.Index(fields=['tenant', 'name'], name='partner_sup_tenant__1381f4_idx'), ), migrations.AlterUniqueTogether( name='supplier', unique_together={('tenant', 'code')}, ), ]