class Permission(models.Model):
"""
资源权限
"""
resource = models.CharField(default='', max_length=128) # 资源名
method = models.CharField(default='GET', max_length=32) # 方法名
created_at = models.DateTimeField(auto_now_add=True) # 更新时间
class Meta(object):
table_name = 'rust_permission'
class UserLimitedPermission(models.Model):
"""
用户禁止访问的资源及方法
"""
user_id = models.IntegerField(default=0)
permission_id = models.IntegerField(default=0)
updated_at = models.DateTimeField() # 更新时间
class Meta(object):
table_name = 'rust_user_limited_permission'
class PermissionGroupHasUser(models.Model):
"""
权限组中的用户
"""
group_id = models.IntegerField(default=0)
user_id = models.IntegerField(default=0)
updated_at = models.DateTimeField(null=False)
class Meta(object):
table_name = 'rust_permission_group_has_user'
class DynamicComment(models.Model):
"""
动态评论
"""
dynamic_id = models.IntegerField(default=0, index=True) # 动态id
user_id = models.IntegerField(default=0, index=True) # 评论者的user_id
content = models.TextField(default='') # 评论内容
created_at = models.DateTimeField(auto_now_add=True) # 创建时间
class Meta(object):
table_name = 'dynamic_comment'
class Topic(models.Model):
"""
话题
"""
name = models.CharField(default='', max_length=128) # 名称
avatar = models.TextField(default='') # 头像
description = models.TextField(default='') # 描述
created_at = models.DateTimeField(auto_now_add=True) # 创建时间
is_banned = models.BooleanField(default=False) # 禁用情况
class Meta(object):
table_name = 'topic_topic'
class User(models.Model):
"""
用户
"""
username = models.CharField(default='', max_length=128) #用户名
password = models.CharField(default='', max_length=1024) #密码
nickname = models.CharField(default='', max_length=512) #用户昵称
avatar = models.TextField(default='') #头像
is_manager = models.BooleanField(default=False) # 是否管理员
created_at = models.DateTimeField(auto_now_add=True) #创建时间
class Meta(object):
table_name = 'rust_user'
class Dynamic(models.Model):
"""
动态
"""
user_id = models.IntegerField(default=0) # 发布人的user_id
content = models.TextField(default='') # 消息内容
topic_id = models.IntegerField(default=0) # 话题的id
longitude = models.FloatField(default=0) # 发布地点的经度
latitude = models.FloatField(default=0) # 发布地点的纬度
created_at = models.DateTimeField(auto_now_add=True) # 创建时间
is_deleted = models.BooleanField(default=False) # 是否删除
class Meta(object):
table_name = 'dynamic_dynamic'