# Generated by Django 5.1.3 on 2026-05-27 13:07 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("dms", "0006_phase7_search_indexing"), ("organizations", "0001_initial"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Comment", 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", ), ), ("body", models.TextField(verbose_name="body")), ("is_resolved", models.BooleanField(default=False, verbose_name="resolved")), ( "resolved_at", models.DateTimeField(blank=True, null=True, verbose_name="resolved at"), ), ( "author", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="dms_comments", to=settings.AUTH_USER_MODEL, verbose_name="author", ), ), ( "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="comments", 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", ), ), ( "parent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="replies", to="dms.comment", verbose_name="parent comment", ), ), ( "resolved_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="dms_resolved_comments", to=settings.AUTH_USER_MODEL, verbose_name="resolved 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", ), ), ( "version", models.ForeignKey( blank=True, help_text="Leave blank for a document-level comment.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="comments", to="dms.documentversion", verbose_name="document version", ), ), ], options={ "verbose_name": "comment", "verbose_name_plural": "comments", }, ), migrations.CreateModel( name="Annotation", 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", ), ), ( "annotation_type", models.CharField( choices=[ ("highlight", "Highlight"), ("note", "Note"), ("freehand", "Freehand Drawing"), ("stamp", "Stamp"), ("redaction", "Redaction"), ], default="note", max_length=20, verbose_name="annotation type", ), ), ( "page_number", models.PositiveIntegerField( blank=True, help_text="1-based page number for multi-page documents.", null=True, verbose_name="page number", ), ), ( "position_data", models.JSONField( default=dict, help_text="Viewer-specific coordinate / bounding-box JSON.", verbose_name="position data", ), ), ("body", models.TextField(blank=True, default="", verbose_name="body")), ( "color", models.CharField( default="#FFFF00", help_text="CSS hex color for the annotation mark.", max_length=7, verbose_name="color", ), ), ( "author", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="dms_annotations", to=settings.AUTH_USER_MODEL, verbose_name="author", ), ), ( "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="annotations", 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( on_delete=django.db.models.deletion.CASCADE, related_name="annotations", to="dms.documentversion", verbose_name="document version", ), ), ( "linked_comment", models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="annotation", to="dms.comment", verbose_name="linked comment", ), ), ], options={ "verbose_name": "annotation", "verbose_name_plural": "annotations", }, ), migrations.CreateModel( name="Mention", 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", ), ), ( "is_notified", models.BooleanField( default=False, help_text="True once the notification engine has dispatched the alert.", verbose_name="notified", ), ), ( "comment", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="mentions", to="dms.comment", verbose_name="comment", ), ), ( "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", ), ), ( "mentioned_user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="dms_mentions", to=settings.AUTH_USER_MODEL, verbose_name="mentioned user", ), ), ( "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": "mention", "verbose_name_plural": "mentions", }, ), migrations.AddIndex( model_name="comment", index=models.Index(fields=["document", "is_deleted"], name="dms_comment_doc_idx"), ), migrations.AddIndex( model_name="comment", index=models.Index( fields=["document", "is_resolved", "is_deleted"], name="dms_comment_doc_resolved_idx", ), ), migrations.AddIndex( model_name="comment", index=models.Index(fields=["version", "is_deleted"], name="dms_comment_ver_idx"), ), migrations.AddIndex( model_name="comment", index=models.Index(fields=["parent", "is_deleted"], name="dms_comment_parent_idx"), ), migrations.AddIndex( model_name="annotation", index=models.Index(fields=["version", "is_deleted"], name="dms_annot_version_idx"), ), migrations.AddIndex( model_name="annotation", index=models.Index(fields=["document", "is_deleted"], name="dms_annot_doc_idx"), ), migrations.AddIndex( model_name="annotation", index=models.Index( fields=["version", "page_number", "is_deleted"], name="dms_annot_page_idx" ), ), migrations.AddIndex( model_name="mention", index=models.Index(fields=["comment"], name="dms_mention_comment_idx"), ), migrations.AddIndex( model_name="mention", index=models.Index( fields=["mentioned_user", "is_notified"], name="dms_mention_user_notified_idx" ), ), migrations.AlterUniqueTogether( name="mention", unique_together={("comment", "mentioned_user")}, ), ]