32 lines
1.7 KiB
Python
32 lines
1.7 KiB
Python
from models import db, BaseModel
|
||
from peewee import *
|
||
from datetime import datetime
|
||
|
||
|
||
class CjjScor(BaseModel):
|
||
id = AutoField() # 自增主键[1,6](@ref)
|
||
email = CharField(max_length=255, default='', verbose_name='邮箱')
|
||
telegram = CharField(max_length=255, default='', verbose_name='电报号')
|
||
address = CharField(max_length=255, default='', verbose_name='地址')
|
||
private_key = CharField(max_length=255, default='', verbose_name='私钥')
|
||
mnemonic = CharField(max_length=255, default='', verbose_name='助记词')
|
||
invite_code = CharField(max_length=255, default='', )
|
||
points = IntegerField(default=0, verbose_name='任务积分')
|
||
badge_num = IntegerField(default=0, verbose_name='徽章数量')
|
||
tx_num = IntegerField(default=0, verbose_name='交互tx')
|
||
swap_num = IntegerField(default=0, verbose_name='跨链次数')
|
||
invite_num = IntegerField(default=0, )
|
||
contract_amount = CharField(max_length=255, default='', verbose_name='合约金额')
|
||
node_run_time = CharField(max_length=255, default='', verbose_name='节点运行时间')
|
||
remark = TextField(default='', verbose_name='备注') # 使用TextField替代varchar(2048)[3](@ref)
|
||
user_data = TextField(default='', verbose_name='用户信息')
|
||
created_at = DateTimeField(default=datetime.now, verbose_name='创建时间') # 自动设置时间[6](@ref)
|
||
updated_at = DateTimeField(constraints=[SQL('DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP')],
|
||
verbose_name='更新时间')
|
||
|
||
class Meta:
|
||
database = db
|
||
table_name = 'cjj_scor' # 显式指定表名[3](@ref)
|
||
# 可添加表注释（需配合MySQL使用）
|
||
table_settings = ['COMMENT "用户积分及链上行为记录表"']
|