# Generated by Django 5.1.4 on 2026-02-10 20:24 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 = [ ("core", "0001_initial"), ("members", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="EquipmentCategory", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=150)), ("description", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], options={ "verbose_name": "Equipment Category", "verbose_name_plural": "Equipment Categories", "ordering": ["name"], }, ), migrations.CreateModel( name="PurchaseOrder", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("order_number", models.CharField(max_length=100, unique=True)), ("order_date", models.DateField()), ("expected_delivery", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("ordered", "Ordered"), ("received", "Received"), ("cancelled", "Cancelled"), ], default="draft", max_length=20, ), ), ("total_amount", models.DecimalField(decimal_places=2, max_digits=12)), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], options={ "verbose_name": "Purchase Order", "verbose_name_plural": "Purchase Orders", "ordering": ["-order_date"], }, ), migrations.CreateModel( name="Supplier", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=255)), ("contact_person", models.CharField(blank=True, max_length=150)), ("email", models.EmailField(blank=True, max_length=254)), ("phone", models.CharField(blank=True, max_length=20)), ("address", models.TextField(blank=True)), ("notes", models.TextField(blank=True)), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], options={ "verbose_name": "Supplier", "verbose_name_plural": "Suppliers", "ordering": ["name"], }, ), migrations.CreateModel( name="AccessCard", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("card_number", models.CharField(max_length=255, unique=True)), ( "card_type", models.CharField( choices=[ ("rfid", "RFID"), ("qr", "QR"), ("barcode", "Barcode"), ], max_length=10, ), ), ("is_active", models.BooleanField(default=True)), ("issued_at", models.DateTimeField()), ("deactivated_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "member", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="access_cards", to="members.memberprofile", ), ), ], options={ "verbose_name": "Access Card", "verbose_name_plural": "Access Cards", "ordering": ["-issued_at"], }, ), migrations.CreateModel( name="AccessPoint", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=150)), ( "access_type", models.CharField( choices=[ ("main_entrance", "Main Entrance"), ("gym_floor", "Gym Floor"), ("pool", "Pool"), ("locker_room", "Locker Room"), ("studio", "Studio"), ("vip", "VIP"), ], max_length=20, ), ), ("hardware_id", models.CharField(blank=True, max_length=255)), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "location", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="access_points", to="core.location", ), ), ], options={ "verbose_name": "Access Point", "verbose_name_plural": "Access Points", "ordering": ["name"], }, ), migrations.CreateModel( name="AccessLog", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "direction", models.CharField( choices=[("entry", "Entry"), ("exit", "Exit")], max_length=10 ), ), ( "method", models.CharField( choices=[ ("qr_code", "QR Code"), ("rfid", "RFID"), ("biometric", "Biometric"), ("manual", "Manual"), ("pin", "PIN"), ], max_length=20, ), ), ("timestamp", models.DateTimeField()), ("granted", models.BooleanField(default=True)), ( "denial_reason", models.CharField(blank=True, max_length=255, null=True), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "member", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="access_logs", to="members.memberprofile", ), ), ( "access_point", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="access_logs", to="operations.accesspoint", ), ), ], options={ "verbose_name": "Access Log", "verbose_name_plural": "Access Logs", "ordering": ["-timestamp"], }, ), migrations.CreateModel( name="Equipment", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=255)), ("serial_number", models.CharField(blank=True, max_length=255)), ("purchase_date", models.DateField()), ( "purchase_price", models.DecimalField(decimal_places=2, max_digits=10), ), ("warranty_expiry", models.DateField(blank=True, null=True)), ( "status", models.CharField( choices=[ ("operational", "Operational"), ("maintenance", "Under Maintenance"), ("out_of_order", "Out of Order"), ("retired", "Retired"), ], default="operational", max_length=20, ), ), ("last_maintenance", models.DateField(blank=True, null=True)), ("next_maintenance", models.DateField(blank=True, null=True)), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "location", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="equipment", to="core.location", ), ), ( "category", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="equipment", to="operations.equipmentcategory", ), ), ], options={ "verbose_name": "Equipment", "verbose_name_plural": "Equipment", "ordering": ["name"], }, ), migrations.CreateModel( name="FacilityBooking", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "facility_type", models.CharField( choices=[ ("court", "Court"), ("studio", "Studio"), ("pool_lane", "Pool Lane"), ("sauna", "Sauna"), ("locker", "Locker"), ("childcare", "Childcare"), ("parking", "Parking"), ], max_length=20, ), ), ("facility_name", models.CharField(max_length=255)), ("start_time", models.DateTimeField()), ("end_time", models.DateTimeField()), ( "status", models.CharField( choices=[ ("confirmed", "Confirmed"), ("cancelled", "Cancelled"), ("completed", "Completed"), ("no_show", "No Show"), ], default="confirmed", max_length=20, ), ), ( "price", models.DecimalField(decimal_places=2, default=0, max_digits=10), ), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "location", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="facility_bookings", to="core.location", ), ), ( "member", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="facility_bookings", to="members.memberprofile", ), ), ], options={ "verbose_name": "Facility Booking", "verbose_name_plural": "Facility Bookings", "ordering": ["-start_time"], }, ), migrations.CreateModel( name="GiftCard", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("code", models.CharField(max_length=100, unique=True)), ("balance", models.DecimalField(decimal_places=2, max_digits=10)), ( "initial_balance", models.DecimalField(decimal_places=2, max_digits=10), ), ("is_active", models.BooleanField(default=True)), ("expires_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "assigned_to", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="gift_cards", to="members.memberprofile", ), ), ( "purchased_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="purchased_gift_cards", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "Gift Card", "verbose_name_plural": "Gift Cards", "ordering": ["-created_at"], }, ), migrations.CreateModel( name="MaintenanceLog", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "maintenance_type", models.CharField( choices=[ ("preventive", "Preventive"), ("corrective", "Corrective"), ("inspection", "Inspection"), ], max_length=20, ), ), ("description", models.TextField()), ( "cost", models.DecimalField( blank=True, decimal_places=2, max_digits=10, null=True ), ), ("date", models.DateField()), ("next_scheduled", models.DateField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "equipment", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="maintenance_logs", to="operations.equipment", ), ), ( "performed_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="maintenance_logs", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "Maintenance Log", "verbose_name_plural": "Maintenance Logs", "ordering": ["-date"], }, ), migrations.CreateModel( name="POSTransaction", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("subtotal", models.DecimalField(decimal_places=2, max_digits=10)), ( "tax", models.DecimalField(decimal_places=2, default=0, max_digits=10), ), ( "discount", models.DecimalField(decimal_places=2, default=0, max_digits=10), ), ("total", models.DecimalField(decimal_places=2, max_digits=10)), ( "payment_method", models.CharField( choices=[ ("cash", "Cash"), ("card", "Card"), ("mpesa", "M-Pesa"), ("mixed", "Mixed"), ], max_length=10, ), ), ( "status", models.CharField( choices=[ ("completed", "Completed"), ("refunded", "Refunded"), ("voided", "Voided"), ], default="completed", max_length=20, ), ), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "cashier", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="pos_transactions", to=settings.AUTH_USER_MODEL, ), ), ( "location", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="pos_transactions", to="core.location", ), ), ( "member", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="pos_transactions", to="members.memberprofile", ), ), ], options={ "verbose_name": "POS Transaction", "verbose_name_plural": "POS Transactions", "ordering": ["-created_at"], }, ), migrations.CreateModel( name="Product", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=255)), ("sku", models.CharField(max_length=100, unique=True)), ("description", models.TextField(blank=True)), ( "category", models.CharField( choices=[ ("supplement", "Supplement"), ("merchandise", "Merchandise"), ("beverage", "Beverage"), ("snack", "Snack"), ("equipment", "Equipment"), ("other", "Other"), ], max_length=20, ), ), ("price", models.DecimalField(decimal_places=2, max_digits=10)), ("cost_price", models.DecimalField(decimal_places=2, max_digits=10)), ("stock_quantity", models.PositiveIntegerField(default=0)), ("reorder_level", models.PositiveIntegerField(default=0)), ( "image", models.ImageField( blank=True, null=True, upload_to="operations/products/" ), ), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "location", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="products", to="core.location", ), ), ], options={ "verbose_name": "Product", "verbose_name_plural": "Products", "ordering": ["name"], }, ), migrations.CreateModel( name="POSTransactionItem", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("description", models.CharField(max_length=255)), ("quantity", models.PositiveIntegerField(default=1)), ("unit_price", models.DecimalField(decimal_places=2, max_digits=10)), ("total_price", models.DecimalField(decimal_places=2, max_digits=10)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "transaction", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="items", to="operations.postransaction", ), ), ( "product", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="pos_transaction_items", to="operations.product", ), ), ], options={ "verbose_name": "POS Transaction Item", "verbose_name_plural": "POS Transaction Items", "ordering": ["transaction"], }, ), migrations.CreateModel( name="PurchaseOrderItem", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("quantity", models.PositiveIntegerField()), ("unit_price", models.DecimalField(decimal_places=2, max_digits=10)), ("received_quantity", models.PositiveIntegerField(default=0)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "order", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="items", to="operations.purchaseorder", ), ), ( "product", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="purchase_order_items", to="operations.product", ), ), ], options={ "verbose_name": "Purchase Order Item", "verbose_name_plural": "Purchase Order Items", "ordering": ["order"], }, ), migrations.AddField( model_name="purchaseorder", name="supplier", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="purchase_orders", to="operations.supplier", ), ), migrations.CreateModel( name="TimeBasedAccessRule", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=150)), ( "day_of_week", models.IntegerField(help_text="Day of week: 0=Monday, 6=Sunday"), ), ("start_time", models.TimeField()), ("end_time", models.TimeField()), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "access_point", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="access_rules", to="operations.accesspoint", ), ), ( "location", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="access_rules", to="core.location", ), ), ( "membership_plans", models.ManyToManyField( blank=True, related_name="access_rules", to="members.membershipplan", ), ), ], options={ "verbose_name": "Time-Based Access Rule", "verbose_name_plural": "Time-Based Access Rules", "ordering": ["day_of_week", "start_time"], }, ), ]