models

type Permission struct {
	ID        int
	Resource  string
	Action    string
	CreatedAt time.Time
}

type Role struct {
	ID          int
	Name        string
	Description string
	IsSystem    bool
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   gorm.DeletedAt

	Permissions []Permission `gorm:"-"`
}

type Session struct {
	ID                uuid.UUID `gorm:"primaryKey"`
	UserID            int
	CredentialVersion int64
	RefreshTokenID    uuid.UUID
	ExpiresAt         time.Time
	RevokedAt         sql.Null[time.Time]
	CreatedAt         time.Time
	UpdatedAt         time.Time
}

type Token struct {
	ID         int
	UUID       uuid.UUID
	UserID     int
	Token      string
	Name       string
	LastUsedAt sql.Null[time.Time]
	ExpiresAt  sql.Null[time.Time]
	CreatedAt  time.Time
	UpdatedAt  time.Time
	DeletedAt  gorm.DeletedAt

	Permissions []Permission `gorm:"-"`
}

type User struct {
	ID                int
	UUID              uuid.UUID
	Email             string
	Password          sql.Null[string]
	CredentialVersion int64 `gorm:"default:1"`
	Status            string
	IsSystem          bool
	Metadata          json.RawMessage
	CreatedAt         time.Time
	UpdatedAt         time.Time
	DeletedAt         gorm.DeletedAt

	Roles []Role `gorm:"-"`
}

type UserHistoryRecord struct {
	ID         uuid.UUID
	OccurredAt time.Time
	CreatedAt  time.Time
	UserID     int
	EventType  string
	Data       []byte
	Metadata   string
}

type UserRole struct {
	UserID    int
	RoleID    int
	CreatedAt time.Time
	ExpiresAt sql.Null[time.Time]
}