# Generated by Django 5.2.13 on 2026-04-24 22:45 import apps.core.storage.paths import django.db.models.deletion import django.utils.timezone import django_fsm from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("core", "0017_alter_customuser_role_alter_notification_verb"), ("rims_grants", "0027_application_institutions_and_more"), ("rims_scholarships", "0003_currency_iso4217_choices"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Business", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "business_id", models.CharField( editable=False, help_text="Auto-generated public identifier (FRSME-OBR024).", max_length=20, unique=True, ), ), ("name", models.CharField(max_length=255)), ("sector", models.CharField(db_index=True, max_length=128)), ("sub_sector", models.CharField(blank=True, max_length=128)), ( "business_stage", models.CharField( choices=[ ("idea", "Idea / pre-seed"), ("mvp", "MVP / prototype"), ("early_revenue", "Early revenue"), ("growth", "Growth"), ("scale", "Scale"), ], db_index=True, max_length=32, ), ), ("founding_date", models.DateField(blank=True, null=True)), ("country", models.CharField(blank=True, db_index=True, max_length=2)), ("location", models.CharField(blank=True, max_length=255)), ("description", models.TextField(blank=True)), ("target_market", models.TextField(blank=True)), ( "logo", models.FileField( blank=True, null=True, upload_to=apps.core.storage.paths.upload_to_smehub_onboarding, ), ), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_admin_review", "Pending admin review"), ("verified", "Verified"), ("rejected", "Rejected"), ("revoked", "Revoked"), ], db_index=True, default="pending_admin_review", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("revoke_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_businesses_verified", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="BusinessBaseline", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("entered_at", models.DateTimeField(default=django.utils.timezone.now)), ( "business_stage_at_entry", models.CharField( choices=[ ("idea", "Idea / pre-seed"), ("mvp", "MVP / prototype"), ("early_revenue", "Early revenue"), ("growth", "Growth"), ("scale", "Scale"), ], max_length=32, ), ), ("fte_count", models.PositiveIntegerField(default=0)), ("pte_count", models.PositiveIntegerField(default=0)), ( "revenue_range", models.CharField( choices=[ ("none", "No revenue yet"), ("under_1k", "Under $1k / month"), ("1k_10k", "$1k–10k / month"), ("10k_50k", "$10k–50k / month"), ("50k_250k", "$50k–250k / month"), ("over_250k", "Over $250k / month"), ], default="none", max_length=32, ), ), ("primary_target_market", models.CharField(blank=True, max_length=255)), ( "geographic_reach", models.CharField( blank=True, help_text="Comma-separated countries or regional descriptor.", max_length=255, ), ), ( "locked_at", models.DateTimeField( blank=True, help_text="When the baseline was committed to M&E (FRSME-OBR035).", null=True, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "business", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="baseline", to="smehub_onboarding.business", ), ), ], ), migrations.CreateModel( name="BuyerProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True)), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("sectors_sourced", models.JSONField(blank=True, default=list)), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], "abstract": False, }, ), migrations.CreateModel( name="EntrepreneurProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True, help_text="Short professional summary.")), ( "photo", models.FileField( blank=True, null=True, upload_to=apps.core.storage.paths.upload_to_smehub_onboarding, ), ), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("pending_more_info", "Pending more info"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("info_request_message", models.TextField(blank=True)), ("rims_match_confirmed", models.BooleanField(default=False)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("submitted_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "rims_match_application", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_entrepreneur_matches", to="rims_grants.application", ), ), ( "rims_match_scholar", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_entrepreneur_matches", to="rims_scholarships.scholar", ), ), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="smehub_entrepreneur", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_entrepreneurs_verified", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.AddField( model_name="business", name="entrepreneur", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="businesses", to="smehub_onboarding.entrepreneurprofile", ), ), migrations.CreateModel( name="InvestorProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True)), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "organisation_type", models.CharField( blank=True, help_text="Angel / VC / DFI / donor / foundation / government programme.", max_length=32, ), ), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], "abstract": False, }, ), migrations.CreateModel( name="MentorProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True)), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "expertise_sectors", models.JSONField( blank=True, default=list, help_text="List of sector tags this mentor specialises in.", ), ), ("years_experience", models.PositiveSmallIntegerField(blank=True, null=True)), ("languages", models.JSONField(blank=True, default=list)), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], "abstract": False, }, ), migrations.CreateModel( name="PartnerProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True)), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "organisation_type", models.CharField( blank=True, help_text="government / corporate / NGO / university.", max_length=32, ), ), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], "abstract": False, }, ), migrations.CreateModel( name="RegistrationRecord", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("full_name", models.CharField(max_length=255)), ("email", models.EmailField(db_index=True, max_length=254)), ( "country", models.CharField(blank=True, help_text="ISO-3166-1 alpha-2", max_length=2), ), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ( "role", models.CharField( choices=[ ("entrepreneur", "Entrepreneur"), ("mentor", "Mentor"), ("investor", "Investor"), ("service_provider", "Service provider"), ("partner", "Partner organisation"), ("buyer", "Buyer / off-taker"), ], max_length=32, ), ), ( "password_hash", models.CharField(help_text="Pre-hashed via make_password.", max_length=128), ), ("token", models.CharField(db_index=True, max_length=64, unique=True)), ("token_expires_at", models.DateTimeField()), ("consumed_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "created_user", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_registration", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="ServiceProviderProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("country", models.CharField(blank=True, max_length=2)), ("organisation", models.CharField(blank=True, max_length=255)), ("phone", models.CharField(blank=True, max_length=32)), ("bio", models.TextField(blank=True)), ( "verification_status", django_fsm.FSMField( choices=[ ("pending_verification", "Pending verification"), ("verified", "Verified"), ("rejected", "Rejected"), ], db_index=True, default="pending_verification", max_length=32, protected=True, ), ), ("rejection_reason", models.TextField(blank=True)), ("verified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("services_offered", models.JSONField(blank=True, default=list)), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "verified_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], "abstract": False, }, ), migrations.CreateModel( name="AIHAffiliation", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "nature", models.CharField( choices=[ ("student", "Student"), ("alumni", "Alumni"), ("faculty", "Faculty"), ("external", "External community entrepreneur"), ], max_length=16, ), ), ("programme_of_origin", models.CharField(blank=True, max_length=255)), ("is_primary", models.BooleanField(db_index=True, default=False)), ( "set_by_admin", models.BooleanField( default=False, help_text="FRSME-OBR034 backend override flag." ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "institution", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="smehub_affiliations", to="core.institution", ), ), ( "rims_award", models.ForeignKey( blank=True, help_text="RIMS award resolved when programme_of_origin is grant-funded.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_affiliations", to="rims_grants.award", ), ), ( "rims_scholarship_record", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="smehub_affiliations", to="rims_scholarships.scholar", ), ), ( "business", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="affiliations", to="smehub_onboarding.business", ), ), ], options={ "ordering": ["-is_primary", "-created_at"], "constraints": [ models.UniqueConstraint( fields=("business", "institution"), name="uniq_smehub_business_institution" ), models.UniqueConstraint( condition=models.Q(("is_primary", True)), fields=("business",), name="uniq_smehub_primary_affiliation", ), ], }, ), migrations.AddIndex( model_name="entrepreneurprofile", index=models.Index( fields=["verification_status", "country"], name="smehub_onbo_verific_0249ff_idx" ), ), migrations.AddIndex( model_name="business", index=models.Index( fields=["sector", "business_stage", "verification_status"], name="smehub_onbo_sector_acb539_idx", ), ), migrations.AddIndex( model_name="business", index=models.Index( fields=["country", "verification_status"], name="smehub_onbo_country_de3ac9_idx" ), ), migrations.AddIndex( model_name="registrationrecord", index=models.Index( fields=["email", "consumed_at"], name="smehub_onbo_email_bd5caa_idx" ), ), ]