# Generated by Django 5.1.3 on 2026-05-27 13:25 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("dms", "0007_phase9_collaboration"), ("organizations", "0001_initial"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="RetentionPolicy", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "is_deleted", models.BooleanField(db_index=True, default=False, verbose_name="deleted"), ), ( "deleted_at", models.DateTimeField(blank=True, null=True, verbose_name="deleted at"), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ("name", models.CharField(max_length=200, verbose_name="name")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "retention_period_days", models.PositiveIntegerField( default=0, help_text="0 = keep indefinitely until explicit action.", verbose_name="retention period (days)", ), ), ( "action_on_expiry", models.CharField( choices=[ ("review", "Review"), ("archive", "Archive"), ("destroy", "Destroy"), ], default="review", max_length=20, verbose_name="action on expiry", ), ), ("is_active", models.BooleanField(default=True, verbose_name="active")), ( "created_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="created by", ), ), ( "deleted_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="deleted by", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ( "updated_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="updated by", ), ), ], options={ "verbose_name": "retention policy", "verbose_name_plural": "retention policies", "ordering": ("name",), }, ), migrations.CreateModel( name="ArchiveRecord", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ("archived_at", models.DateTimeField(verbose_name="archived at")), ("reason", models.TextField(blank=True, default="", verbose_name="reason")), ( "expires_at", models.DateTimeField( blank=True, help_text="Computed from archived_at + retention_period_days. Null if is_permanent=True or policy has no expiry.", null=True, verbose_name="expires at", ), ), ( "is_permanent", models.BooleanField( default=False, help_text="If True, expires_at is always null regardless of policy.", verbose_name="permanent", ), ), ( "archived_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="archive_records", to=settings.AUTH_USER_MODEL, verbose_name="archived by", ), ), ( "created_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="created by", ), ), ( "document", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="archive_records", to="dms.document", verbose_name="document", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ( "updated_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="updated by", ), ), ( "version", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="archive_records", to="dms.documentversion", verbose_name="document version", ), ), ( "retention_policy", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="archive_records", to="dms.retentionpolicy", verbose_name="retention policy", ), ), ], options={ "verbose_name": "archive record", "verbose_name_plural": "archive records", "ordering": ("-archived_at",), }, ), migrations.CreateModel( name="LegalHold", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ( "name", models.CharField( help_text="Case name or brief description of the hold reason.", max_length=200, verbose_name="hold name", ), ), ("notes", models.TextField(blank=True, default="", verbose_name="notes")), ("started_at", models.DateTimeField(auto_now_add=True, verbose_name="started at")), ( "ended_at", models.DateTimeField( blank=True, help_text="Null means the hold is still active.", null=True, verbose_name="ended at", ), ), ( "created_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="created by", ), ), ( "document", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="legal_holds", to="dms.document", verbose_name="document", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "placed_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="placed_legal_holds", to=settings.AUTH_USER_MODEL, verbose_name="placed by", ), ), ( "released_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="released_legal_holds", to=settings.AUTH_USER_MODEL, verbose_name="released by", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ( "updated_by", models.ForeignKey( blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="updated by", ), ), ], options={ "verbose_name": "legal hold", "verbose_name_plural": "legal holds", "ordering": ("-started_at",), "indexes": [ models.Index(fields=["document"], name="dms_legalhold_doc_idx"), models.Index( fields=["document", "ended_at"], name="dms_legalhold_doc_active_idx" ), models.Index(fields=["tenant", "ended_at"], name="dms_lhld_tenant_act_idx"), ], }, ), migrations.AddIndex( model_name="retentionpolicy", index=models.Index( fields=["tenant", "is_active", "is_deleted"], name="dms_reten_tenant_act_idx" ), ), migrations.AddConstraint( model_name="retentionpolicy", constraint=models.UniqueConstraint( condition=models.Q(("is_deleted", False)), fields=("tenant", "name"), name="dms_retentionpolicy_unique_name_per_tenant", ), ), migrations.AddIndex( model_name="archiverecord", index=models.Index(fields=["document"], name="dms_archive_doc_idx"), ), migrations.AddIndex( model_name="archiverecord", index=models.Index(fields=["document", "archived_at"], name="dms_archive_doc_date_idx"), ), migrations.AddIndex( model_name="archiverecord", index=models.Index( fields=["tenant", "expires_at"], name="dms_archive_tenant_expires_idx" ), ), ]