# Generated by Django 5.1.3 on 2026-05-27 11:31 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("dms", "0001_phase2_repository_folder"), ("organizations", "0001_initial"), ("storage", "0003_phase0c_fileasset_enhancement"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="DocumentType", 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")), ( "code", models.SlugField( help_text="URL-safe identifier, unique per tenant. E.g. 'contract'.", max_length=80, verbose_name="code", ), ), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "icon", models.CharField(blank=True, default="", max_length=64, verbose_name="icon"), ), ( "color", models.CharField(blank=True, default="", max_length=32, verbose_name="color"), ), ("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": "document type", "verbose_name_plural": "document types", "ordering": ("name",), }, ), migrations.CreateModel( name="Document", 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", ), ), ("title", models.CharField(max_length=500, verbose_name="title")), ( "code", models.CharField( blank=True, default="", help_text="Optional human-readable document number, unique per tenant among active documents. E.g. 'CONTRACT-2024-001'.", max_length=100, verbose_name="code", ), ), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("published", "Published"), ("archived", "Archived"), ], db_index=True, default="draft", max_length=20, verbose_name="status", ), ), ( "workflow_status", models.CharField( blank=True, default="", max_length=100, verbose_name="workflow status" ), ), ( "extra", models.JSONField( blank=True, default=dict, help_text="Pass-through JSON store for future metadata phases. Do not put business logic on these keys.", verbose_name="extra", ), ), ( "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", ), ), ( "folder", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="documents", to="dms.folder", verbose_name="folder", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "repository", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="documents", to="dms.repository", verbose_name="repository", ), ), ( "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", ), ), ( "document_type", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="documents", to="dms.documenttype", verbose_name="document type", ), ), ], options={ "verbose_name": "document", "verbose_name_plural": "documents", "ordering": ("-created_at",), }, ), migrations.CreateModel( name="DocumentVersion", 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", ), ), ( "file_size_bytes", models.BigIntegerField(blank=True, null=True, verbose_name="file size bytes"), ), ( "content_type", models.CharField( blank=True, default="", max_length=200, verbose_name="content type" ), ), ( "checksum_sha256", models.CharField( blank=True, default="", max_length=64, verbose_name="checksum SHA-256" ), ), ( "version_major", models.PositiveIntegerField(default=1, verbose_name="major version"), ), ( "version_minor", models.PositiveIntegerField(default=0, verbose_name="minor version"), ), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("published", "Published"), ("superseded", "Superseded"), ("archived", "Archived"), ], db_index=True, default="draft", max_length=20, verbose_name="status", ), ), ( "is_current", models.BooleanField( default=False, help_text="Denormalized: mirrors document.current_version == self.", verbose_name="is current", ), ), ( "label", models.CharField( blank=True, default="", help_text="Optional display label, e.g. 'Initial release'.", max_length=200, verbose_name="label", ), ), ( "change_summary", models.TextField( blank=True, default="", help_text="What changed in this version.", verbose_name="change summary", ), ), ( "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", ), ), ( "document", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="versions", to="dms.document", verbose_name="document", ), ), ( "file_asset", models.ForeignKey( blank=True, help_text="The underlying file. May be NULL for a shell version created before the file upload completes.", null=True, on_delete=django.db.models.deletion.PROTECT, related_name="document_versions", to="storage.filemetadata", verbose_name="file asset", ), ), ( "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": "document version", "verbose_name_plural": "document versions", "ordering": ("-version_major", "-version_minor"), }, ), migrations.AddField( model_name="document", name="current_version", field=models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="current_for_document", to="dms.documentversion", verbose_name="current version", ), ), migrations.AddIndex( model_name="documenttype", index=models.Index( fields=["tenant", "is_active", "is_deleted"], name="dms_documen_tenant__5954f1_idx" ), ), migrations.AddConstraint( model_name="documenttype", constraint=models.UniqueConstraint( condition=models.Q(("is_deleted", False)), fields=("tenant", "code"), name="dms_documenttype_unique_code_per_tenant", ), ), migrations.AddIndex( model_name="documentversion", index=models.Index( fields=["document", "status", "is_deleted"], name="dms_documen_documen_0ee2a7_idx" ), ), migrations.AddIndex( model_name="documentversion", index=models.Index( fields=["tenant", "is_deleted"], name="dms_documen_tenant__ce9db8_idx" ), ), migrations.AddConstraint( model_name="documentversion", constraint=models.UniqueConstraint( condition=models.Q(("is_deleted", False)), fields=("document", "version_major", "version_minor"), name="dms_documentversion_unique_version_per_document", ), ), migrations.AddIndex( model_name="document", index=models.Index( fields=["tenant", "status", "is_deleted"], name="dms_documen_tenant__a2c797_idx" ), ), migrations.AddIndex( model_name="document", index=models.Index( fields=["repository", "folder", "is_deleted"], name="dms_documen_reposit_a5269d_idx" ), ), migrations.AddIndex( model_name="document", index=models.Index( fields=["tenant", "document_type", "is_deleted"], name="dms_documen_tenant__fb9450_idx", ), ), migrations.AddConstraint( model_name="document", constraint=models.UniqueConstraint( condition=models.Q(("is_deleted", False), models.Q(("code", ""), _negated=True)), fields=("tenant", "code"), name="dms_document_unique_code_per_tenant", ), ), ]