# Generated by Django 5.1.3 on 2026-06-13 17:55 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("organizations", "0002_workspace_template_user_context_pref"), ("storage", "0003_phase0c_fileasset_enhancement"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Category", 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", ), ), ( "sort_order", models.PositiveIntegerField( db_index=True, default=0, verbose_name="sort order" ), ), ("name", models.CharField(max_length=255, verbose_name="name")), ( "category_type", models.CharField( choices=[ ("subject", "correspondence.category_type.subject"), ("unit", "correspondence.category_type.unit"), ], default="subject", max_length=20, verbose_name="category type", ), ), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "is_active", models.BooleanField(db_index=True, default=True, verbose_name="active"), ), ( "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", ), ), ( "parent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="children", to="correspondence.category", verbose_name="parent category", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "correspondence category", "verbose_name_plural": "correspondence categories", }, ), migrations.CreateModel( name="Letter", 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"), ), ("version", models.PositiveIntegerField(default=0, verbose_name="version")), ( "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", ), ), ( "letter_type", models.CharField( choices=[ ("incoming", "correspondence.letter_type.incoming"), ("outgoing", "correspondence.letter_type.outgoing"), ("internal_memo", "correspondence.letter_type.internal_memo"), ("announcement", "correspondence.letter_type.announcement"), ("notice", "correspondence.letter_type.notice"), ], db_index=True, max_length=20, verbose_name="letter type", ), ), ( "status", models.CharField( choices=[ ("draft", "correspondence.letter_status.draft"), ("sent", "correspondence.letter_status.sent"), ("received", "correspondence.letter_status.received"), ("in_progress", "correspondence.letter_status.in_progress"), ("completed", "correspondence.letter_status.completed"), ("archived", "correspondence.letter_status.archived"), ("cancelled", "correspondence.letter_status.cancelled"), ], db_index=True, default="draft", max_length=20, verbose_name="status", ), ), ( "priority", models.CharField( choices=[ ("low", "correspondence.letter_priority.low"), ("normal", "correspondence.letter_priority.normal"), ("high", "correspondence.letter_priority.high"), ("urgent", "correspondence.letter_priority.urgent"), ], default="normal", max_length=20, verbose_name="priority", ), ), ( "security", models.CharField( choices=[ ("normal", "correspondence.letter_security.normal"), ("confidential", "correspondence.letter_security.confidential"), ("secret", "correspondence.letter_security.secret"), ("top_secret", "correspondence.letter_security.top_secret"), ], default="normal", max_length=20, verbose_name="security level", ), ), ( "registration_number", models.CharField( blank=True, db_index=True, default="", max_length=100, verbose_name="registration number", ), ), ( "registration_date", models.DateField( blank=True, db_index=True, null=True, verbose_name="registration date" ), ), ("subject", models.CharField(max_length=500, verbose_name="subject")), ("body", models.TextField(blank=True, default="", verbose_name="body")), ("summary", models.TextField(blank=True, default="", verbose_name="summary")), ( "sender_external", models.CharField( blank=True, default="", max_length=500, verbose_name="external sender" ), ), ( "sender_organization", models.CharField( blank=True, default="", max_length=500, verbose_name="sender organization" ), ), ( "letter_date", models.DateField( blank=True, db_index=True, null=True, verbose_name="letter date" ), ), ( "received_date", models.DateField( blank=True, db_index=True, null=True, verbose_name="received date" ), ), ( "sent_date", models.DateField( blank=True, db_index=True, null=True, verbose_name="sent date" ), ), ( "due_date", models.DateField(blank=True, db_index=True, null=True, verbose_name="due date"), ), ( "external_reference", models.CharField( blank=True, default="", max_length=255, verbose_name="external reference" ), ), ("metadata", models.JSONField(blank=True, default=dict, verbose_name="metadata")), ( "category", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="letters", to="correspondence.category", verbose_name="category", ), ), ( "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", ), ), ( "parent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="replies", to="correspondence.letter", verbose_name="parent letter", ), ), ( "sender", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="sent_letters", to=settings.AUTH_USER_MODEL, verbose_name="sender", ), ), ( "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": "letter", "verbose_name_plural": "letters", }, ), migrations.CreateModel( name="LetterAttachment", 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", ), ), ( "attachment_type", models.CharField( choices=[ ("scan", "correspondence.attachment_type.scan"), ("attachment", "correspondence.attachment_type.attachment"), ], default="attachment", max_length=20, verbose_name="attachment type", ), ), ( "description", models.CharField( blank=True, default="", max_length=500, verbose_name="description" ), ), ( "sort_order", models.PositiveIntegerField( db_index=True, default=0, verbose_name="sort order" ), ), ( "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", ), ), ( "file", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="letter_attachments", to="storage.filemetadata", verbose_name="file", ), ), ( "letter", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="attachments", to="correspondence.letter", verbose_name="letter", ), ), ( "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": "letter attachment", "verbose_name_plural": "letter attachments", "ordering": ["sort_order"], }, ), migrations.CreateModel( name="LetterheadTemplate", 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=255, verbose_name="name")), ( "header_html", models.TextField(blank=True, default="", verbose_name="header HTML"), ), ( "footer_html", models.TextField(blank=True, default="", verbose_name="footer HTML"), ), ("css_styles", models.TextField(blank=True, default="", verbose_name="CSS styles")), ( "is_default", models.BooleanField(db_index=True, default=False, verbose_name="default"), ), ( "is_active", models.BooleanField(db_index=True, 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": "letterhead template", "verbose_name_plural": "letterhead templates", }, ), migrations.AddField( model_name="letter", name="letterhead", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="letters", to="correspondence.letterheadtemplate", verbose_name="letterhead", ), ), migrations.CreateModel( name="LetterRecipient", 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", ), ), ( "recipient_name", models.CharField( blank=True, default="", max_length=500, verbose_name="recipient name" ), ), ( "recipient_organization", models.CharField( blank=True, default="", max_length=500, verbose_name="recipient organization", ), ), ( "recipient_type", models.CharField( choices=[ ("to", "correspondence.recipient_type.to"), ("cc", "correspondence.recipient_type.cc"), ("bcc", "correspondence.recipient_type.bcc"), ], default="to", max_length=10, verbose_name="recipient type", ), ), ( "status", models.CharField( choices=[ ("pending", "correspondence.recipient_status.pending"), ("sent", "correspondence.recipient_status.sent"), ("delivered", "correspondence.recipient_status.delivered"), ("read", "correspondence.recipient_status.read"), ("failed", "correspondence.recipient_status.failed"), ], default="pending", max_length=20, verbose_name="status", ), ), ("sent_at", models.DateTimeField(blank=True, null=True, verbose_name="sent at")), ( "delivered_at", models.DateTimeField(blank=True, null=True, verbose_name="delivered at"), ), ("read_at", models.DateTimeField(blank=True, null=True, verbose_name="read at")), ( "letter", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="recipients", to="correspondence.letter", verbose_name="letter", ), ), ( "recipient", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="received_letters", to=settings.AUTH_USER_MODEL, verbose_name="recipient", ), ), ], options={ "verbose_name": "letter recipient", "verbose_name_plural": "letter recipients", }, ), migrations.CreateModel( name="LetterTemplate", 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=255, verbose_name="name")), ( "letter_type", models.CharField( choices=[ ("incoming", "correspondence.letter_type.incoming"), ("outgoing", "correspondence.letter_type.outgoing"), ("internal_memo", "correspondence.letter_type.internal_memo"), ("announcement", "correspondence.letter_type.announcement"), ("notice", "correspondence.letter_type.notice"), ], default="outgoing", max_length=20, verbose_name="letter type", ), ), ( "subject_template", models.CharField( blank=True, default="", max_length=500, verbose_name="subject template" ), ), ( "body_template", models.TextField(blank=True, default="", verbose_name="body template"), ), ( "is_default", models.BooleanField(db_index=True, default=False, verbose_name="default"), ), ( "is_active", models.BooleanField(db_index=True, 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", ), ), ( "letterhead", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="templates", to="correspondence.letterheadtemplate", verbose_name="letterhead", ), ), ( "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": "letter template", "verbose_name_plural": "letter templates", }, ), migrations.AddField( model_name="letter", name="template", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="letters", to="correspondence.lettertemplate", verbose_name="template", ), ), migrations.CreateModel( name="NumberingTemplate", 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=255, verbose_name="name")), ( "pattern", models.CharField( default="{year}/{counter:04d}", help_text="correspondence.numbering.pattern_help", max_length=255, verbose_name="pattern", ), ), ( "prefix", models.CharField(blank=True, default="", max_length=50, verbose_name="prefix"), ), ("counter", models.PositiveIntegerField(default=0, verbose_name="counter")), ( "letter_type", models.CharField( choices=[ ("incoming", "correspondence.letter_type.incoming"), ("outgoing", "correspondence.letter_type.outgoing"), ("internal_memo", "correspondence.letter_type.internal_memo"), ("announcement", "correspondence.letter_type.announcement"), ("notice", "correspondence.letter_type.notice"), ], default="outgoing", max_length=20, verbose_name="letter type", ), ), ( "is_default", models.BooleanField(db_index=True, default=False, verbose_name="default"), ), ( "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": "numbering template", "verbose_name_plural": "numbering templates", }, ), migrations.AddField( model_name="lettertemplate", name="numbering_template", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="templates", to="correspondence.numberingtemplate", verbose_name="numbering template", ), ), migrations.AddField( model_name="letter", name="numbering_template", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="letters", to="correspondence.numberingtemplate", verbose_name="numbering template", ), ), migrations.CreateModel( name="LetterReference", 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", ), ), ( "reference_type", models.CharField( choices=[ ("reply", "correspondence.reference_type.reply"), ("forward", "correspondence.reference_type.forward"), ("related", "correspondence.reference_type.related"), ], default="related", max_length=20, verbose_name="reference type", ), ), ( "note", models.CharField(blank=True, default="", max_length=500, verbose_name="note"), ), ( "from_letter", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="references_from", to="correspondence.letter", verbose_name="from letter", ), ), ( "to_letter", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="references_to", to="correspondence.letter", verbose_name="to letter", ), ), ], options={ "verbose_name": "letter reference", "verbose_name_plural": "letter references", "constraints": [ models.UniqueConstraint( fields=("from_letter", "to_letter", "reference_type"), name="uq_letter_ref_from_to_type", ) ], }, ), migrations.AddConstraint( model_name="numberingtemplate", constraint=models.UniqueConstraint( condition=models.Q(("is_deleted", False)), fields=("tenant", "name"), name="uq_numbering_template_tenant_name", ), ), migrations.AddIndex( model_name="letter", index=models.Index( fields=["letter_type", "status"], name="corresponde_letter__a2be03_idx" ), ), migrations.AddIndex( model_name="letter", index=models.Index(fields=["registration_date"], name="corresponde_registr_36dc0a_idx"), ), ]