VSeesResourceWeb/background/models.py

# Create your models here.
from django.db import models


class WechatUserInfo(models.Model):
    user_id = models.IntegerField(primary_key=True, verbose_name=u'企业用户ID', unique=True)
    name = models.CharField(blank=True, max_length=32, verbose_name=u'名字')
    position = models.CharField(blank=True, max_length=64, verbose_name=u'岗位')
    status = models.SmallIntegerField(default=0, verbose_name='用户状态')  # 1：已激活，2：已禁用，4：未激活，5：退出企业
    add_time = models.IntegerField(default=0, verbose_name='创建时间')
    upd_time = models.IntegerField(default=0, verbose_name='修改时间')

    class Meta:
        db_table = 'wechat_user_info'
        verbose_name = '企业用户信息'
        verbose_name_plural = verbose_name


class ProductInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_name = models.CharField(default='', max_length=32, verbose_name='产品名称')
    product_name_en = models.CharField(default='', max_length=32, verbose_name='产品英文名称')
    icon_url = models.CharField(default='', max_length=200, verbose_name='图标地址')

    class Meta:
        db_table = 'product_info'
        verbose_name = '产品信息'
        verbose_name_plural = verbose_name


class VideoInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')  # 1: 上架, 0: 下架

    class Meta:
        db_table = 'video_info'
        verbose_name = '视频信息'
        verbose_name_plural = verbose_name


class QuickStartInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')  # 1: 上架, 0: 下架

    class Meta:
        db_table = 'quick_start_info'
        verbose_name = '说明书信息'
        verbose_name_plural = verbose_name


class UpgradeFirmwareInfo(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    product_info_id = models.SmallIntegerField(default=0, verbose_name='关联产品信息表')
    title = models.CharField(default='', max_length=100, verbose_name='标题')
    link = models.TextField(default='', verbose_name='链接')
    status = models.SmallIntegerField(default=0, verbose_name='状态')  # 1: 上架, 0: 下架

    class Meta:
        db_table = 'upgrade_firmware_info'
        verbose_name = '升级文件信息'
        verbose_name_plural = verbose_name


class OperationLog(models.Model):
    id = models.AutoField(primary_key=True, verbose_name='主键')
    user_id = models.IntegerField(default=0, verbose_name='用户id')
    date = models.IntegerField(default=0, verbose_name='日期')
    operation = models.CharField(default='', max_length=200, verbose_name='操作记录')

    class Meta:
        db_table = 'operation_log'
        verbose_name = '操作日志'
        verbose_name_plural = verbose_name