mirror of
https://github.com/zhenxun-org/zhenxun_bot.git
synced 2026-09-29 00:32:06 +08:00
32 lines
1.1 KiB
Python
32 lines
1.1 KiB
Python
from typing import ClassVar
|
|
|
|
from tortoise import fields
|
|
|
|
from zhenxun.services.db_context import Model
|
|
from zhenxun.utils.enum import GoldHandle
|
|
|
|
|
|
class UserGoldLog(Model):
|
|
id = fields.IntField(pk=True, generated=True, auto_increment=True)
|
|
"""自增id"""
|
|
user_id = fields.CharField(255, description="用户id")
|
|
"""用户id"""
|
|
gold = fields.IntField(description="金币")
|
|
"""金币"""
|
|
handle = fields.CharEnumField(GoldHandle, default=None, description="道具处理类型")
|
|
"""金币处理类型"""
|
|
source = fields.CharField(255, null=True, description="来源插件")
|
|
"""来源插件"""
|
|
create_time = fields.DatetimeField(auto_now_add=True, description="创建时间")
|
|
"""创建时间"""
|
|
|
|
class Meta: # pyright: ignore [reportIncompatibleVariableOverride]
|
|
table = "user_gold_log"
|
|
table_description = "用户金币记录表"
|
|
# 高频写表补索引(H4):按 user_id / (user_id, create_time) 查询流水,
|
|
# SchemaGuard 启动时自动建,不改变查询语义。
|
|
indexes: ClassVar = [
|
|
("user_id",),
|
|
("user_id", "create_time"),
|
|
]
|