# Generated by Django 5.1.3 on 2026-05-27 12:43 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("dms", "0005_phase6_version_operations"), ("organizations", "0001_initial"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="DocumentSearchIndex", 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", ), ), ("title", models.TextField(blank=True, default="", verbose_name="title")), ( "code", models.CharField(blank=True, default="", max_length=100, verbose_name="code"), ), ( "document_type_code", models.CharField( blank=True, default="", max_length=80, verbose_name="document type code" ), ), ( "document_type_name", models.CharField( blank=True, default="", max_length=200, verbose_name="document type name" ), ), ( "repository_public_id", models.UUIDField( blank=True, db_index=True, null=True, verbose_name="repository public id" ), ), ( "folder_public_id", models.UUIDField( blank=True, db_index=True, null=True, verbose_name="folder public id" ), ), ( "status", models.CharField( blank=True, db_index=True, default="", max_length=20, verbose_name="status" ), ), ( "workflow_status", models.CharField( blank=True, default="", max_length=100, verbose_name="workflow status" ), ), ( "file_name", models.CharField( blank=True, default="", max_length=500, verbose_name="file name" ), ), ( "content_type", models.CharField( blank=True, db_index=True, default="", max_length=200, verbose_name="content type", ), ), ( "file_size", models.BigIntegerField(blank=True, null=True, verbose_name="file size bytes"), ), ( "version_label", models.CharField( blank=True, default="", max_length=50, verbose_name="version label" ), ), ( "search_text", models.TextField( blank=True, default="", help_text="Concatenated searchable plain text: title + code + document-type name + version label + file name. Populated by index_document().", verbose_name="search text", ), ), ( "tags", models.JSONField( default=list, help_text='Lowercase string labels, e.g. ["contract", "urgent"]. Populated from document.extra["tags"] or AI classification.', verbose_name="tags", ), ), ( "extra_json", models.JSONField( blank=True, default=dict, help_text="Reserved for Phase-4 structured metadata indexing. Arbitrary key/value pairs added by the metadata engine.", verbose_name="extra JSON", ), ), ("indexed_at", models.DateTimeField(auto_now=True, verbose_name="indexed at")), ( "index_version", models.PositiveIntegerField(default=1, verbose_name="index version"), ), ( "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.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="search_index", 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", ), ), ], options={ "verbose_name": "document search index", "verbose_name_plural": "document search indices", "indexes": [ models.Index(fields=["tenant", "status"], name="dms_srch_tenant_status_idx"), models.Index( fields=["tenant", "content_type"], name="dms_srch_tenant_ctype_idx" ), models.Index( fields=["tenant", "document_type_code"], name="dms_srch_tenant_dtype_idx" ), models.Index(fields=["tenant", "indexed_at"], name="dms_srch_tenant_idxat_idx"), ], }, ), migrations.CreateModel( name="SavedSearch", 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"), ), ( "query_params", models.JSONField( default=dict, help_text="Serialized SearchParams dict. Validated by SearchParamsSerializer at create/update time.", verbose_name="query params", ), ), ( "is_shared", models.BooleanField( default=False, help_text="When True this saved search is visible (read-only) to all active users in the same tenant.", verbose_name="shared", ), ), ( "last_used_at", models.DateTimeField(blank=True, null=True, verbose_name="last used at"), ), ("use_count", models.PositiveIntegerField(default=0, verbose_name="use count")), ( "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", ), ), ( "owner", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="dms_saved_searches", to=settings.AUTH_USER_MODEL, verbose_name="owner", ), ), ( "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": "saved search", "verbose_name_plural": "saved searches", "ordering": ("-created_at",), "indexes": [ models.Index( fields=["tenant", "owner", "is_deleted"], name="dms_savedsearch_owner_idx" ), models.Index( fields=["tenant", "is_shared", "is_deleted"], name="dms_savedsearch_shared_idx", ), ], }, ), ]