# Generated by Django 5.2.6 on 2026-06-13 13:46 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"), ("platform_workflow", "0002_process_definition"), ("storage", "0003_phase0c_fileasset_enhancement"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="CatalogCategory", 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", ), ), ( "sort_order", models.PositiveIntegerField( db_index=True, default=0, verbose_name="sort order" ), ), ( "catalog_type", models.CharField( choices=[ ("product", "Product"), ("service", "Service"), ("it_service", "IT Service"), ("hr_service", "HR Service"), ("procurement", "Procurement"), ], db_index=True, max_length=30, verbose_name="catalog type", ), ), ("name", models.CharField(max_length=200, verbose_name="name")), ("slug", models.SlugField(max_length=200, verbose_name="slug")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "icon", models.CharField(blank=True, default="", max_length=50, verbose_name="icon"), ), ( "is_active", models.BooleanField(db_index=True, default=True, verbose_name="active"), ), ( "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="children", to="catalog.catalogcategory", 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": "catalog category", "verbose_name_plural": "catalog categories", }, ), migrations.CreateModel( name="CatalogItem", 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", ), ), ("name", models.CharField(max_length=500, verbose_name="name")), ("slug", models.SlugField(max_length=500, verbose_name="slug")), ( "catalog_type", models.CharField( choices=[ ("product", "Product"), ("service", "Service"), ("it_service", "IT Service"), ("hr_service", "HR Service"), ("procurement", "Procurement"), ], db_index=True, max_length=30, verbose_name="catalog type", ), ), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "short_description", models.CharField( blank=True, default="", max_length=500, verbose_name="short description" ), ), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("review", "In Review"), ("published", "Published"), ("retired", "Retired"), ], db_index=True, default="draft", max_length=20, verbose_name="status", ), ), ( "published_at", models.DateTimeField( blank=True, db_index=True, null=True, verbose_name="published at" ), ), ( "retired_at", models.DateTimeField(blank=True, null=True, verbose_name="retired at"), ), ( "related_items", models.JSONField(blank=True, default=list, verbose_name="related items"), ), ( "documentation_content_id", models.UUIDField( blank=True, help_text="Reference to a ContentItem for detailed documentation", null=True, verbose_name="documentation content ID", ), ), ( "ai_description", models.TextField(blank=True, default="", verbose_name="AI description"), ), ( "ai_semantic_type", models.CharField( blank=True, default="", max_length=100, verbose_name="AI semantic type" ), ), ( "category", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="items", to="catalog.catalogcategory", 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", ), ), ( "image", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to="storage.filemetadata", verbose_name="image", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="owned_catalog_items", 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", ), ), ( "workflow_instance", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to="platform_workflow.workflowinstance", verbose_name="workflow instance", ), ), ], options={ "verbose_name": "catalog item", "verbose_name_plural": "catalog items", "ordering": ["-published_at", "-created_at"], }, ), migrations.CreateModel( name="CatalogItemVersion", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("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", ), ), ("version", models.PositiveIntegerField(verbose_name="version number")), ("name", models.CharField(max_length=500, verbose_name="name")), ("description", models.TextField(verbose_name="description")), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("review", "In Review"), ("published", "Published"), ("retired", "Retired"), ], max_length=20, verbose_name="status at snapshot", ), ), ( "change_summary", models.CharField( blank=True, default="", max_length=500, verbose_name="change summary" ), ), ("created_at", models.DateTimeField(auto_now_add=True, verbose_name="created at")), ( "catalog_item", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="versions", to="catalog.catalogitem", verbose_name="catalog item", ), ), ( "changed_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="changed 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", ), ), ], options={ "verbose_name": "catalog item version", "verbose_name_plural": "catalog item versions", "ordering": ["-version"], }, ), migrations.AddIndex( model_name="catalogcategory", index=models.Index( fields=["tenant", "catalog_type"], name="catalog_cat_tenant__4982fe_idx" ), ), migrations.AddIndex( model_name="catalogcategory", index=models.Index(fields=["tenant", "parent"], name="catalog_cat_tenant__7d9628_idx"), ), migrations.AddIndex( model_name="catalogcategory", index=models.Index( fields=["tenant", "is_active"], name="catalog_cat_tenant__3f928c_idx" ), ), migrations.AlterUniqueTogether( name="catalogcategory", unique_together={("tenant", "slug")}, ), migrations.AddIndex( model_name="catalogitem", index=models.Index( fields=["tenant", "catalog_type"], name="catalog_cat_tenant__870067_idx" ), ), migrations.AddIndex( model_name="catalogitem", index=models.Index(fields=["tenant", "status"], name="catalog_cat_tenant__6001a1_idx"), ), migrations.AddIndex( model_name="catalogitem", index=models.Index( fields=["tenant", "category"], name="catalog_cat_tenant__07a07e_idx" ), ), migrations.AddIndex( model_name="catalogitem", index=models.Index(fields=["tenant", "owner"], name="catalog_cat_tenant__84811f_idx"), ), migrations.AddIndex( model_name="catalogitem", index=models.Index( fields=["tenant", "catalog_type", "status"], name="catalog_cat_tenant__c24997_idx" ), ), migrations.AlterUniqueTogether( name="catalogitem", unique_together={("tenant", "slug")}, ), migrations.AlterUniqueTogether( name="catalogitemversion", unique_together={("catalog_item", "version")}, ), ]