from django.db import models


class TableRowOrder(models.Model):
    """
    Row order a user chose by dragging rows in a table.
    One record per (user, page + table); `keys` is the list of row keys in order.
    """

    owner_type = models.CharField(max_length=10)          # 'admin' or 'staff'
    owner_id = models.PositiveIntegerField()
    table_key = models.CharField(max_length=255)          # e.g. "/admin/staff_list/#staffTable"
    keys = models.JSONField(default=list)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'table_row_orders'
        constraints = [
            models.UniqueConstraint(fields=['owner_type', 'owner_id', 'table_key'],
                                    name='unique_table_row_order'),
        ]

    def __str__(self):
        return f'{self.owner_type}#{self.owner_id} {self.table_key}'
