from django.db import models
# Create your models here.
class User(models.Model):
username = models.CharField(max_length=32)
pasword = models.CharField(max_length=32)
class Meta:
verbose_name_plural = "用户表"
def __str__(self):
return self.username
class Role(models.Model):
caption = models.CharField(max_length=32)
class Meta:
verbose_name_plural = "角色表"
def __str__(self):
return self.caption
class User2Role(models.Model):
u = models.ForeignKey("User")
r = models.ForeignKey("Role")
class Meta:
verbose_name_plural = "用户角色分配表"
def __str__(self):
return "%s:%s"%(self.u.username,self.r.caption)
class Action(models.Model):
#/user.html?t=get 获取用户信息
#/user.html?t=post 创建用户
#/user.html?t=put 修改用户
#/user.html?t=delete 删除用户
#1 ---> get 查询
#2 ---> post 增加
#3 ---> put 修改
#4 ---> delete 删除
caption = models.CharField(max_length=32)
code = models.CharField(max_length=32)
class Meta:
verbose_name_plural = "操作表"
def __str__(self):
return self.caption
class Menu(models.Model):
caption = models.CharField(max_length=32)
parent = models.ForeignKey("self",related_name="p",null=True,blank=True)
class Meta:
verbose_name_plural="菜单表"
def __str__(self):
return self.caption
class Permission(models.Model):
#/user.html 用户管理
caption = models.CharField(max_length=32)
url = models.CharField(max_length=32)
menu = models.ForeignKey("Menu",null=True)
class Meta:
verbose_name_plural = "权限"
def __str__(self):
return self.caption
class Permission2Action(models.Model):
p = models.ForeignKey("Permission")
a = models.ForeignKey("Action")
class Meta:
verbose_name_plural = "权限表"
def __str__(self):
return "%s-%s:%s?t=%s"%(self.p.caption,self.a.caption,self.p.url,self.a.code)
class Permission2Action2Role(models.Model):
p2a = models.ForeignKey("Permission2Action")
r = models.ForeignKey("Role")
class Meta:
verbose_name_plural = "角色权限分配表"
def __str__(self):
return "%s:%s"%(self.r.caption,self.p2a)