class TinyUrl(Model): id = BigAutoField() user_id = IntegerField(null=False) short_uuid = CharField(max_length=255, null=False, help_text='长度为 6 位') long_url_hash = CharField(max_length=64, null=False) long_url = CharField(max_length=2048, null=False) created_at = DateTimeField( null=False, constraints=[SQL('DEFAULT CURRENT_TIMESTAMP')], help_text='应用数据库工夫' ) updated_at = DateTimeField( null=False, constraints=[ SQL('DEFAULT CURRENT_TIMESTAMP'), SQL('ON UPDATE CURRENT_TIMESTAMP'), ] ) class Meta: database = db table_name = 'tiny_url' indexes = ( (('short_uuid',), True), (('user_id', 'long_url_hash'), True), )
应用 indexes 就能够了