# Generated by Django 5.2.16 on 2026-09-15 15:45 import django.contrib.auth.models import django.contrib.auth.validators import django.core.validators import django.db.models.deletion import django.utils.timezone from decimal import Decimal from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(max_length=254, unique=True)), ('role', models.CharField(choices=[('ADMIN', 'Admin'), ('ACCOUNTANT', 'Accountant'), ('BUSINESS', 'Business'), ('INVESTOR', 'Investor')], max_length=20)), ('phone', models.CharField(blank=True, max_length=30)), ('is_active', models.BooleanField(default=True)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='AccountantPermission', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('permissions', models.JSONField(blank=True, default=dict)), ('updated_at', models.DateTimeField(auto_now=True)), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='accountant_permissions', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='AuditLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('operation', models.CharField(max_length=30)), ('module', models.CharField(max_length=100)), ('object_type', models.CharField(max_length=100)), ('object_id', models.CharField(blank=True, max_length=100)), ('description', models.TextField(blank=True)), ('metadata', models.JSONField(blank=True, default=dict)), ('created_at', models.DateTimeField(auto_now_add=True, db_index=True)), ('actor', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='audit_logs', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Business', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('name', models.CharField(max_length=255)), ('location', models.CharField(blank=True, max_length=500)), ('owner_name', models.CharField(max_length=255)), ('owner_aadhar', models.CharField(blank=True, max_length=32)), ('owner_pan', models.CharField(blank=True, max_length=20)), ('owner_mobile', models.CharField(blank=True, max_length=30)), ('owner_sex', models.CharField(blank=True, max_length=30)), ('bank_details', models.JSONField(blank=True, default=dict)), ('business_details', models.JSONField(blank=True, default=dict)), ('owner_photo', models.ImageField(blank=True, null=True, upload_to='businesses/owners/')), ('business_photo', models.ImageField(blank=True, null=True, upload_to='businesses/business/')), ('documents', models.JSONField(blank=True, default=list)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='businesses_created', to=settings.AUTH_USER_MODEL)), ('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='business_profile', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='BusinessDocument', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=255)), ('file', models.FileField(upload_to='businesses/documents/')), ('created_at', models.DateTimeField(auto_now_add=True)), ('business', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='uploaded_documents', to='admin_panel.business')), ('uploaded_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Investment', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('amount', models.DecimalField(decimal_places=2, max_digits=14, validators=[django.core.validators.MinValueValidator(Decimal('0.01'))])), ('investor_annual_rate', models.DecimalField(decimal_places=4, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0')), django.core.validators.MaxValueValidator(Decimal('100'))])), ('investment_date', models.DateField(default=django.utils.timezone.localdate)), ('maturity_date', models.DateField(blank=True, null=True)), ('status', models.CharField(choices=[('ACTIVE', 'Active'), ('MATURED', 'Matured'), ('CLOSED', 'Closed'), ('CANCELLED', 'Cancelled')], default='ACTIVE', max_length=20)), ('terms_snapshot', models.JSONField(blank=True, default=dict)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('business', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='investments', to='admin_panel.business')), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='investments_created', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-investment_date'], }, ), migrations.CreateModel( name='Certificate', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('html_content', models.TextField()), ('attachment_files', models.JSONField(blank=True, default=list)), ('version', models.PositiveIntegerField(default=1)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='certificates_created', to=settings.AUTH_USER_MODEL)), ('investment', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='certificate', to='admin_panel.investment')), ], ), migrations.CreateModel( name='Investor', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('name', models.CharField(max_length=255)), ('email', models.EmailField(blank=True, max_length=254)), ('mobile', models.CharField(blank=True, max_length=30)), ('identity_details', models.JSONField(blank=True, default=dict)), ('bank_details', models.JSONField(blank=True, default=dict)), ('nominee_details', models.JSONField(blank=True, default=dict)), ('other_details', models.JSONField(blank=True, default=dict)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='investors_created', to=settings.AUTH_USER_MODEL)), ('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='investor_profile', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created_at'], }, ), migrations.AddField( model_name='investment', name='investor', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='investments', to='admin_panel.investor'), ), migrations.CreateModel( name='KuberBusinessInvestment', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('amount', models.DecimalField(decimal_places=2, max_digits=14, validators=[django.core.validators.MinValueValidator(Decimal('0.01'))])), ('annual_rate', models.DecimalField(decimal_places=4, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0')), django.core.validators.MaxValueValidator(Decimal('100'))])), ('investment_date', models.DateField(default=django.utils.timezone.localdate)), ('maturity_date', models.DateField(blank=True, null=True)), ('notes', models.TextField(blank=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('business', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='kuber_investments', to='admin_panel.business')), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='kuber_business_investments_created', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-investment_date'], }, ), migrations.CreateModel( name='LedgerEntry', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('entry_date', models.DateField(db_index=True, default=django.utils.timezone.localdate)), ('entry_type', models.CharField(choices=[('CREDIT_PROFIT', 'Credit Profit'), ('SOFT_DEBIT', 'Soft Debit'), ('DEBIT', 'Debit')], max_length=30)), ('amount', models.DecimalField(decimal_places=2, max_digits=14, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('annual_rate', models.DecimalField(blank=True, decimal_places=4, max_digits=7, null=True)), ('description', models.TextField(blank=True)), ('reference', models.CharField(blank=True, max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True)), ('business', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='ledger_entries', to='admin_panel.business')), ('investment', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ledger_entries', to='admin_panel.investment')), ('investor', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ledger_entries', to='admin_panel.investor')), ('kuber_investment', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ledger_entries', to='admin_panel.kuberbusinessinvestment')), ], options={ 'ordering': ['-entry_date', '-created_at'], }, ), migrations.CreateModel( name='PasswordResetOTP', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('otp_hash', models.CharField(max_length=128)), ('expires_at', models.DateTimeField()), ('attempts', models.PositiveIntegerField(default=0)), ('used', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='password_reset_otps', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Payout', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('amount', models.DecimalField(decimal_places=2, max_digits=14, validators=[django.core.validators.MinValueValidator(Decimal('0.01'))])), ('payout_date', models.DateField(default=django.utils.timezone.localdate)), ('notes', models.TextField(blank=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='payouts_created', to=settings.AUTH_USER_MODEL)), ('investment', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='payouts', to='admin_panel.investment')), ('investor', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='payouts', to='admin_panel.investor')), ], ), migrations.CreateModel( name='Scheme', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('category', models.CharField(choices=[('SILVER', 'Silver'), ('GOLD', 'Gold'), ('PLATINUM', 'Platinum'), ('DIAMOND', 'Diamond')], max_length=20)), ('name', models.CharField(max_length=255)), ('description', models.TextField(blank=True)), ('tenure_months', models.PositiveIntegerField()), ('annual_interest_rate', models.DecimalField(decimal_places=4, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0')), django.core.validators.MaxValueValidator(Decimal('100'))])), ('penalty_rate', models.DecimalField(decimal_places=4, default=Decimal('0'), max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0')), django.core.validators.MaxValueValidator(Decimal('100'))])), ('withdrawal_type', models.CharField(blank=True, max_length=40)), ('compounding_frequency', models.CharField(blank=True, max_length=30)), ('monthly_installment', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('rules', models.JSONField(blank=True, default=list)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='schemes_created', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['category', 'tenure_months', 'name'], }, ), migrations.AddField( model_name='investment', name='scheme', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='investments', to='admin_panel.scheme'), ), migrations.CreateModel( name='BalanceSheet', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, db_index=True, null=True)), ('statement_date', models.DateField()), ('file', models.FileField(upload_to='balance_sheets/')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('uploaded_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='balance_sheets_uploaded', to=settings.AUTH_USER_MODEL)), ('business', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='balance_sheets', to='admin_panel.business')), ], options={ 'ordering': ['-statement_date', '-created_at'], 'constraints': [models.UniqueConstraint(condition=models.Q(('deleted_at__isnull', True)), fields=('business', 'statement_date'), name='unique_live_balance_sheet_per_business_date')], }, ), migrations.CreateModel( name='RecurringContribution', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('contribution_date', models.DateField(default=django.utils.timezone.localdate)), ('amount', models.DecimalField(decimal_places=2, max_digits=14, validators=[django.core.validators.MinValueValidator(Decimal('0.01'))])), ('created_at', models.DateTimeField(auto_now_add=True)), ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='recurring_contributions_created', to=settings.AUTH_USER_MODEL)), ('investment', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='recurring_contributions', to='admin_panel.investment')), ], options={ 'ordering': ['contribution_date'], 'constraints': [models.UniqueConstraint(fields=('investment', 'contribution_date'), name='one_platinum_contribution_per_investment_date')], }, ), ]