openKriemy/models.py

from tortoise.models import Model
from tortoise.fields import IntField, BigIntField, CharField, TextField, BooleanField, ForeignKeyField

class Action(Model):
  id = IntField(pk=True)
  name = CharField(max_length=64, unique=True)
  template = TextField()
  can_apply_to_self = BooleanField(default=True)

class Gif(Model):
  id = IntField(pk=True)
  action = ForeignKeyField('models.Action', related_name='gifs')
  file_id = CharField(max_length=64, unique=True)

class UserColor(Model):
  id = IntField(pk=True)
  username = CharField(max_length=256, unique=True)
  color = IntField()

class StickerPack(Model):
  id = IntField(pk=True)
  short_name = CharField(max_length=256, unique=True)
  sid = BigIntField()
  hash = BigIntField()

  stickers_count = IntField(default=0)

class Admin(Model):
  id = IntField(pk=True)
  user_id = IntField(unique=True)