class Verification(models.Model):
email = models.CharField(max_length=32, verbose_name='邮箱')
verification_code = models.CharField(max_length=32, verbose_name='验证码')
create_time = models.IntegerField(verbose_name='创办时间')
class Meta:
db_table = 'Verification'
verbose_name = '验证码表'
verbose_name_plural = verbose_name
class Dor(models.Model):
num = models.CharField(verbose_name='宿舍号', max_length=32, unique=True)
sex = models.CharField(verbose_name='居住性别', max_length=32)
max_people = models.IntegerField(verbose_name='最大人数')
now_people = models.IntegerField(verbose_name='现在人数')
class Meta:
db_table = 'Dor'
verbose_name = '宿舍表'
verbose_name_plural = verbose_name
class Notice(models.Model):
user_id = models.CharField(max_length=32, verbose_name='发布账号')
user_name = models.CharField(max_length=32, verbose_name='姓名')
title = models.CharField(max_length=20, verbose_name='标题')
content = RichTextField()
send_time = models.CharField(max_length=32, verbose_name='发布时间')
finally_time = models.CharField(max_length=32, verbose_name='最后更新时间')
class Meta:
db_table = 'Notice'
verbose_name = '公告表'
verbose_name_plural = verbose_name
class Player(models.Model):
id_player = models.AutoField(primary_key=True)
user = models.OneToOneField(User)
position = models.CharField(
max_length=10,
validators=[validate_comma_separated_integer_list],
default="50,100,50")
map = models.IntegerField(default=1)
role = models.ForeignKey(Role)
def __str__(self):
return "Username = "******", role = " + self.role.name
class Change_dor(models.Model):
stu_id = models.CharField(max_length=32, verbose_name='申请账号')
name = models.CharField(max_length=32, verbose_name='姓名')
sex = models.CharField(verbose_name='性别', max_length=32)
major_class = models.CharField(max_length=32,
default='未知',
verbose_name='专业班级')
now_dor = models.CharField(max_length=32, verbose_name='更换前宿舍')
go_dor = models.CharField(max_length=32, verbose_name='更换至宿舍')
remarks = models.CharField(max_length=256, verbose_name='备注', default='无')
send_time = models.CharField(max_length=32, verbose_name='发布时间')
admin = models.CharField(max_length=32, verbose_name='批改管理员', null=True)
process_time = models.CharField(max_length=32,
verbose_name='批改时间',
null=True)
status = models.IntegerField(verbose_name='是否同意',
default=0) # 同意为1，不同意为2,未处理为0
class Meta:
db_table = 'Change_dor'
verbose_name = '更换宿舍申请表'
verbose_name_plural = verbose_name
class Loss_goods(models.Model):
stu_id = models.CharField(max_length=32, verbose_name='丢失账号')
loss_name = models.CharField(max_length=32, verbose_name='姓名')
loss_phone = models.CharField(max_length=32, verbose_name='电话')
loss_goods_name = models.CharField(max_length=32, verbose_name='丢失物品名字')
loss_type = models.CharField(max_length=32, verbose_name='丢失类别')
loss_location = models.CharField(max_length=32, verbose_name='丢失地点')
loss_picture = models.ImageField(upload_to='images', verbose_name='丢失照片')
loss_remarks = models.CharField(max_length=256,
verbose_name='丢失备注',
default='无')
loss_time = models.CharField(max_length=32, verbose_name='丢失时间')
send_time = models.CharField(max_length=32, verbose_name='订单发布时间')
complete_time = models.CharField(max_length=32,
verbose_name='订单完成时间',
null=True)
status = models.IntegerField(verbose_name='订单状态', default=0) # 未处理为0，已找到为1
class Meta:
db_table = 'Loss_goods'
verbose_name = '丢失物品信息表'
verbose_name_plural = verbose_name
class Pickup_goods(models.Model):
stu_id = models.CharField(max_length=32, verbose_name='拾取账号')
pickup_name = models.CharField(max_length=32, verbose_name='姓名')
pickup_phone = models.CharField(max_length=32, verbose_name='电话')
pickup_goods_name = models.CharField(max_length=32, verbose_name='拾取物品名字')
pickup_type = models.CharField(max_length=32, verbose_name='拾取类别')
pickup_location = models.CharField(max_length=32, verbose_name='拾取地点')
pickup_picture = models.ImageField(upload_to='images', verbose_name='拾取照片')
pickup_remarks = models.CharField(max_length=256,
verbose_name='拾取备注',
default='无')
pickup_time = models.CharField(max_length=32, verbose_name='拾取时间')
send_time = models.CharField(max_length=32, verbose_name='订单发布时间')
status = models.IntegerField(verbose_name='订单状态', default=0) # 未处理为0，已找到为1
class Meta:
db_table = 'Pickup_goods'
verbose_name = '拾取物品信息表'
verbose_name_plural = verbose_name
class Fix_dor(models.Model):
stu_id = models.CharField(max_length=32, verbose_name='申请账号')
name = models.CharField(max_length=32, verbose_name='姓名')
phone = models.CharField(verbose_name='电话', max_length=32)
dor = models.CharField(max_length=32, verbose_name='宿舍')
simple_remarks = models.CharField(max_length=256,
verbose_name='简要原因',
default='无')
detail_remarks = models.CharField(max_length=256,
verbose_name='详细原因',
default='无')
send_time = models.CharField(max_length=32, verbose_name='发布时间')
admin = models.CharField(max_length=32, verbose_name='批改管理员', null=True)
process_time = models.CharField(max_length=32,
verbose_name='批改时间',
null=True)
status = models.IntegerField(verbose_name='是否同意', default=0) # 未处理为0，处理为1
class Meta:
db_table = 'Fix_dor'
verbose_name = '宿舍维修申请表'
verbose_name_plural = verbose_name
class User(models.Model):
user_id = models.CharField(max_length=32, verbose_name='账号', unique=True)
password = models.CharField(max_length=32, verbose_name='密码')
email = models.CharField(max_length=32, verbose_name='邮箱') # 用于忘记密码功能
name = models.CharField(max_length=32, verbose_name='姓名')
phone = models.CharField(max_length=32,
verbose_name='电话',
default='0000000000')
location = models.CharField(max_length=32, verbose_name='住址', default='地球')
sex = models.CharField(verbose_name='性别', max_length=32, default='男生')
class Meta:
db_table = 'User'
verbose_name = '管理员用户表'
verbose_name_plural = verbose_name
class AvatarPlayer(models.Model):
## Define avatar_id and player_id as composite primary key
class Meta:
unique_together = (('avatar_id', 'player_id'), )
avatar_id = models.ForeignKey(
'Avatar',
on_delete=models.CASCADE,
)
player_id = models.ForeignKey(
'Player',
on_delete=models.CASCADE,
)
avatar_name = models.CharField(max_length=80, default=None)
def __str__(self):
return "Avatar name = " + self.avatar_name
class Stu(models.Model):
stu_id = models.CharField(max_length=32, verbose_name='账号', unique=True)
password = models.CharField(max_length=32, verbose_name='密码')
email = models.CharField(max_length=32, verbose_name='邮箱') # 用于忘记密码功能
name = models.CharField(max_length=32, verbose_name='姓名')
phone = models.CharField(max_length=32, verbose_name='电话', default='0')
major_class = models.CharField(max_length=32,
default='未知',
verbose_name='专业班级')
birthday = models.CharField(verbose_name='出生日期',
max_length=32,
default='2000-01-01')
remarks = models.CharField(max_length=256, verbose_name='备注', default='无')
sex = models.CharField(verbose_name='性别', max_length=32)
dor = models.ForeignKey(to=Dor,
to_field='num',
on_delete=models.CASCADE,
verbose_name='宿舍号',
null=True)
class Meta:
db_table = 'Stu'
verbose_name = '学生用户表'
verbose_name_plural = verbose_name
class Avatar(models.Model):
avatar_id = models.AutoField(primary_key=True)
name = models.CharField(max_length=80, default="pig")
def __str__(self):
return "Avatar name = " + self.name
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('username',
models.CharField(error_messages={
'unique':
'A user with that login already exists.'
},
max_length=255,
unique=True,
verbose_name='login')),
('email',
models.EmailField(error_messages={
'unique':
'A user with that email already exists.'
},
max_length=254,
unique=True,
verbose_name='email')),
('first_name',
models.CharField(max_length=255,
null=True,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='last name')),
('middle_name',
models.CharField(blank=True,
max_length=255,
null=True,
verbose_name='middle name')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', user.models.UserManager()),
],
),
]
