from django.db import models

# Create your models here.
# 角色表
class Roles(models.Model):
    name = models.CharField(max_length=50)
    status = models.BooleanField(default=True)


    class Meta:
        db_table='roles'


# 管理員表
class Admin_user(models.Model):
    username = models.CharField(max_length=50,verbose_name='用戶名')
    password = models.CharField(max_length=200,verbose_name='密碼')
    pic = models.CharField(max_length=200,default='',verbose_name='頭像')
    status = models.BooleanField(default=True,verbose_name='狀態(tài)')  # 狀態(tài)
    supper = models.BooleanField(default=False,verbose_name='是否為超級管理員') # 是否為超級管理員
    role = models.ForeignKey(Roles,on_delete=models.CASCADE)


    class Meta:
        db_table='admin_user'


# 資源表
class Resource(models.Model):
    name = models.CharField(max_length=50)
    status = models.BooleanField(default=True)
    url = models.CharField(max_length=50,default='')
    level = models.IntegerField()
    pid = models.ForeignKey('self',on_delete=models.SET_NULL,null=True,blank=True,related_name='subs')
    roles = models.ManyToManyField(Roles,related_name='resources',null=True,blank=True)


    class Meta:
        db_table='resource'