from itertools import chain from django.contrib.auth.models import BaseUserManager, AbstractBaseUser from django.db import models from six import python_2_unicode_compatible from imagekit.models import ProcessedImageField from imagekit.processors import ResizeToFill from AnsjerPush.config import SERVER_DOMAIN from django.utils import timezone class PermissionsManager(models.Manager): use_in_migrations = True def get_by_natural_key(self, permName): return self.get( permName=permName ) class RoleManager(models.Manager): """ The manager for the auth's Role model.. """ use_in_migrations = True def get_by_natural_key(self, roleName): return self.get(roleName=roleName) class UserManager(BaseUserManager): def create_user(self, username, password, userID, is_active, user_isValid, **extra_fields): user = self.model( username=username, userID=userID, is_active=is_active, user_isValid=user_isValid, **extra_fields ) user.set_password(password) user.save(using=self._db) role = Role.objects.get(rid=1) user.role.add(role) return user def create_superuser(self, username, password, userID, is_active, user_isValid, **extra_fields): # extra_fields.setdefault('is_superuser', is_superuser) is_superuser = extra_fields.get('is_superuser', None) if is_superuser != 100 and is_superuser != 1: raise ValueError('Superuser must have is_superuser=1 or 100.') return self.create_user(username, password, userID, is_active, user_isValid, **extra_fields) @python_2_unicode_compatible class Permissions(models.Model): permName = models.CharField(blank=True, null=True, max_length=32, unique=True, verbose_name=u'权限名称') description = models.CharField(blank=True, null=True, max_length=128, verbose_name=u'描述信息', default='') objects = PermissionsManager() class Meta: ordering = ['permName'] db_table = 'permissions' verbose_name = u'role permission' verbose_name_plural = verbose_name unique_together = (('permName'),) def natural_key(self): return (self.permName) class MenuModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') parentId = models.IntegerField(default=0, verbose_name='父节点ID') name = models.CharField(max_length=50, null=True, default='', verbose_name='名称') # 首字母大写，一定要与vue文件的name对应起来，用于noKeepAlive缓存控制（该项特别重要） path = models.CharField(max_length=100, null=True, default='', verbose_name='路径') component = models.CharField(max_length=100, null=True, default='', verbose_name='vue文件路径') # 所谓的vue 组件 hidden = models.BooleanField(blank=True, default=False, verbose_name=u'是否隐藏') alwaysShow = models.BooleanField(blank=True, default=False, verbose_name=u'始终显示当前节点') levelHidden = models.BooleanField(blank=True, default=False, verbose_name=u'是否隐藏一级路由') title = models.CharField(max_length=50, default='', verbose_name='标题') icon = models.CharField(max_length=50, default='', verbose_name='图标名') isCustomSvg = models.BooleanField(blank=True, default=False, verbose_name=u'是否是自定义svg图标') noKeepAlive = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否不缓存') noClosable = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否可关闭多标签页') badge = models.CharField(max_length=10, default='', verbose_name='badge小标签（只支持子级）') tabHidden = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否不显示多标签页') activeMenu = models.CharField(max_length=50, default='', verbose_name='高亮指定菜单') dot = models.BooleanField(blank=True, default=False, verbose_name=u'小圆点') dynamicNewTab = models.BooleanField(blank=True, default=False, verbose_name=u'动态传参路由是否新开标签页') redirect = models.CharField(max_length=50, default='', verbose_name='重定向') menu_code = models.CharField(max_length=100, default='', verbose_name='菜单编码') menutype = models.SmallIntegerField(default=1, verbose_name=u'类型') # 类型: 1-菜单 2-按钮 sort = models.IntegerField(default=0, verbose_name='排序') class Meta: db_table = 'menu' verbose_name = u'菜单表' verbose_name_plural = verbose_name class Role(models.Model): rid = models.SmallIntegerField(primary_key=True, unique=True, verbose_name=u'用户角色组ID') roleName = models.CharField(max_length=32, unique=True, default='User', verbose_name=u'角色名称') permission = models.ManyToManyField(to='Permissions', blank=True, verbose_name=u'权限', db_table='role_permissions') menu = models.ManyToManyField(to='MenuModel', blank=True, verbose_name=u'后台菜单权限', db_table='role_menu') Description = models.TextField(blank=True, default='', verbose_name=u'描述信息') objects = RoleManager() class Meta: ordering = ['roleName'] db_table = 'role' verbose_name = u'用户角色' verbose_name_plural = verbose_name def __str__(self): return self.roleName def natural_key(self): return (self.roleName,) def get_all_permission(self): perms = self.permission.all() permslist = [] if self.rid == 100: perms = Permissions.objects.all() for perm in perms: permslist.append(perm.permName) return permslist else: permlist_tmp = [] for perm in perms: permlist_tmp.append(perm.permName) permSet = set(permlist_tmp) permslist = list(permSet) permslist.sort() return permslist class Device_User(AbstractBaseUser): userID = models.CharField(blank=True, max_length=32, primary_key=True, verbose_name=u'用户ID', unique=True) role = models.ManyToManyField(to='Role', blank=True, verbose_name=u'用户角色', db_table='user_role') username = models.CharField(max_length=64, db_index=True, verbose_name=u'用户名', default='', blank=True) password = models.CharField(max_length=128, verbose_name=u'密码') userEmail = models.EmailField(max_length=64, db_index=True, verbose_name=u'邮箱', default='', blank=True) # 实际的路径就是 MEDIA_ROOT/Image/filename,所以可用upload_to来指定文件存放的前缀路径 userIconPath = ProcessedImageField(blank=True, upload_to='User/Images/', default='static/User/default.png', verbose_name=u'头像', # 图片将处理成85x85的尺寸 processors=[ResizeToFill(85, 85)], ) userIconUrl = models.URLField(blank=True, max_length=128, default=SERVER_DOMAIN + 'account/getAvatar/User/defaultUser.png') NickName = models.CharField(blank=True, max_length=64, default='', verbose_name=u'用户昵称') is_superuser = models.IntegerField(blank=True, default=0, verbose_name=u'用户类型') is_active = models.BooleanField(blank=True, default=False, verbose_name=u'用户活动状态') data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True) last_login = models.DateTimeField(blank=True, verbose_name='u最后登录时间', auto_now=True) user_isValid = models.BooleanField(blank=True, default=False, verbose_name=u'用户有效性', help_text=u'是否是认证通过的用户') online = models.BooleanField(blank=True, default=False, verbose_name=u'用户登录状态') machine_code = models.CharField(blank=True, max_length=128, default='', verbose_name=u'机械码') language = models.CharField(blank=True, max_length=16, default='en', verbose_name=u'语言地区') # 手机注册增加字段 phone = models.CharField(max_length=16, db_index=True, verbose_name=u'手机号', default='', blank=True) fingerprint_enable = models.SmallIntegerField(default=0, verbose_name=u'是否开启了指纹登录') # 0：未开启，1：已开启 fingerprint_key = models.CharField(max_length=128, default='', verbose_name=u'客户端用于解码的密钥等信息') is_local = models.BooleanField(blank=True, default=False, verbose_name=u'是否是本地登录用户') # False：账号登录，1：本地登录 subscribe_email = models.SmallIntegerField(default=0, verbose_name=u'是否订阅营销邮件') # 0：未订阅，1：订阅，2：不订阅 region_country = models.IntegerField(blank=True, default=0, verbose_name='地区表唯一标识') objects = UserManager() USERNAME_FIELD = 'userID' # 必须有一个唯一标识 REQUIRED_FIELDS = ['is_superuser'] # 创建superuser时的必须字段 class Meta: ordering = ('-data_joined',) verbose_name = u'用户信息' db_table = 'device_user' get_latest_by = 'last_login' def __str__(self): return self.username def get_role_id(self): rids = [] roles = self.role.all() for role in roles: rids.append(role.rid) return rids def get_all_permission(self): roles = self.role.all() permslist = [] for role in roles: if role.rid == 100: perms = Permissions.objects.all() for perm in perms: permslist.append(perm.permName) return permslist permSet = set(permslist) for role in roles: permlist_tmp = [] for perm in role.permission.all(): permlist_tmp.append(perm.permName) permSet_tmp = set(permlist_tmp) permSet = permSet.union(permSet_tmp) permslist = list(permSet) permslist.sort() return permslist @property def is_staff(self): return self.is_superuser # 设备表是建项目开发者设计的,自己看着办 # 谢谢提醒！我选择凉拌。 # 我选择狗带 class Device_Info(models.Model): id = models.CharField(blank=True, max_length=32, primary_key=True) userID = models.ForeignKey(Device_User, blank=True, to_field='userID', on_delete=models.CASCADE) NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称') UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID', default='') SID = models.CharField(blank=True, max_length=32, verbose_name=u'服务器ID', default='') View_Account = models.CharField(blank=True, max_length=32, verbose_name=u'设备用户名称', default='') View_Password = models.CharField(blank=True, max_length=32, verbose_name=u'设备密码', default='') AudioFormat = models.IntegerField(blank=True, default=1, verbose_name=u'初始化影像') EventNotification = models.IntegerField(blank=True, verbose_name=u'报警类型', default=0) ChannelIndex = models.IntegerField(blank=True, verbose_name=u'通道号', default=0) Online = models.BooleanField(blank=True, default=False, verbose_name=u'设备是否在线') mMonitorIndex = models.IntegerField(blank=True, default=-1) Type = models.IntegerField(blank=True, verbose_name='设备类型') DebugMode = models.IntegerField(blank=True, verbose_name=u'调试模式', default=0) NotificationMode = models.IntegerField(blank=True, verbose_name=u'是否报警', default=0) qvgaLevel = models.BooleanField(blank=True, verbose_name=u'SD与HD画面', default=0, help_text=u'0代表：SD、1代表：HD') isShare = models.BooleanField(blank=True, verbose_name=u'共享设备', help_text=u'是否为共享获取的设备', default=False) primaryUserID = models.CharField(blank=True, verbose_name='主用户id', max_length=32, default='') primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='') vodPrimaryUserID = models.CharField(blank=True, verbose_name='云存主用户id', max_length=32, default='') vodPrimaryMaster = models.CharField(max_length=64, verbose_name=u'云存主用户名', default='') data_joined = models.DateTimeField(blank=True, verbose_name=u'设备添加时间', auto_now_add=True) update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True, null=True) ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'设备区域ip') area = models.CharField(blank=True, max_length=100, default='', verbose_name=u'设备区域area') # ios要求新增字段 version = models.CharField(blank=True, max_length=20, default='', verbose_name=u'版本号') iSNotification = models.BooleanField(blank=True, verbose_name=u'报警通知 0:关闭,1:开启)', default=False) isVod = models.SmallIntegerField(blank=True, default=0, verbose_name='是否支持云存') # 是否支持云存设备 isExist = models.SmallIntegerField(blank=True, default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在，0不存在，2设备被重置 isCameraOpenCloud = models.SmallIntegerField(blank=True, default=1, verbose_name='是否开启云存') # 0：不开启 1：开启 serial_number = models.CharField(blank=True, max_length=9, default='', verbose_name='关联序列号') ### REQUIRED_FIELDS = [] def __str__(self): return self.NickName def model_to_dict(self, fields=None, exclude=None): opts = self._meta data = {} for f in chain(opts.concrete_fields, opts.private_fields, opts.many_to_many): if not getattr(f, 'editable', False): continue if fields and f.name not in fields: continue if exclude and f.name in exclude: continue data[f.name] = f.value_from_object(self) return data class Meta: db_table = 'device_info' ordering = ('-data_joined',) verbose_name = u'用户设备信息表' verbose_name_plural = verbose_name class Access_Log(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') user = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户') operation = models.CharField(max_length=100, db_index=True, default='', blank=True, verbose_name=u'操作') ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址') url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径') status = models.IntegerField(default=0, blank=True, verbose_name=u'状态') time = models.DateTimeField(null=True, blank=True, db_index=True, verbose_name=u'访问时间') content = models.TextField(blank=True, default='', verbose_name=u'参数内容') class Meta: db_table = 'access_log' verbose_name = u'访问日志表' verbose_name_plural = verbose_name class EquipmentInfo1(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_1' verbose_name = '推送数据表1' app_label = 'db2' class EquipmentInfo2(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_2' verbose_name = '推送数据表2' app_label = 'db2' class EquipmentInfo3(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_3' verbose_name = '推送数据表3' app_label = 'db2' class EquipmentInfo4(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_4' verbose_name = '推送数据表4' app_label = 'db2' class EquipmentInfo5(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_5' verbose_name = '推送数据表5' app_label = 'db2' class EquipmentInfo6(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_6' verbose_name = '推送数据表6' app_label = 'db2' class EquipmentInfo7(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_7' verbose_name = '推送数据表7' app_label = 'db2' class EquipmentInfo8(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_8' verbose_name = '推送数据表8' app_label = 'db2' class EquipmentInfo9(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_9' verbose_name = '推送数据表9' app_label = 'db2' class EquipmentInfo10(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_10' verbose_name = '推送数据表10' app_label = 'db2' class EquipmentInfo11(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_11' verbose_name = '推送数据表11' app_label = 'db2' class EquipmentInfo12(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_12' verbose_name = '推送数据表12' app_label = 'db2' class EquipmentInfo13(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_13' verbose_name = '推送数据表13' app_label = 'db2' class EquipmentInfo14(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_14' verbose_name = '推送数据表14' app_label = 'db2' class EquipmentInfo15(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_15' verbose_name = '推送数据表15' app_label = 'db2' class EquipmentInfo16(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_16' verbose_name = '推送数据表16' app_label = 'db2' class EquipmentInfo17(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_17' verbose_name = '推送数据表17' app_label = 'db2' class EquipmentInfo18(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_18' verbose_name = '推送数据表18' app_label = 'db2' class EquipmentInfo19(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_19' verbose_name = '推送数据表19' app_label = 'db2' class EquipmentInfo20(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_20' verbose_name = '推送数据表20' app_label = 'db2' class EquipmentInfo21(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_21' verbose_name = '推送数据表21' app_label = 'db2' class EquipmentInfo22(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_22' verbose_name = '推送数据表22' app_label = 'db2' class EquipmentInfo23(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_23' verbose_name = '推送数据表23' app_label = 'db2' class EquipmentInfo24(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_24' verbose_name = '推送数据表24' app_label = 'db2' class EquipmentInfo25(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_25' verbose_name = '推送数据表25' app_label = 'db2' class EquipmentInfo26(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_26' verbose_name = '推送数据表26' app_label = 'db2' class EquipmentInfo27(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_27' verbose_name = '推送数据表27' app_label = 'db2' class EquipmentInfo28(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_28' verbose_name = '推送数据表28' app_label = 'db2' class EquipmentInfo29(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_29' verbose_name = '推送数据表29' app_label = 'db2' class EquipmentInfo30(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_30' verbose_name = '推送数据表30' app_label = 'db2' class EquipmentInfo31(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_31' verbose_name = '推送数据表31' app_label = 'db2' class EquipmentInfo32(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_32' verbose_name = '推送数据表32' app_label = 'db2' class EquipmentInfo33(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_33' verbose_name = '推送数据表33' app_label = 'db2' class EquipmentInfo34(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_34' verbose_name = '推送数据表34' app_label = 'db2' class EquipmentInfo35(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_35' verbose_name = '推送数据表35' app_label = 'db2' class EquipmentInfo36(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_36' verbose_name = '推送数据表36' app_label = 'db2' class EquipmentInfo37(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_37' verbose_name = '推送数据表37' app_label = 'db2' class EquipmentInfo38(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_38' verbose_name = '推送数据表38' app_label = 'db2' class EquipmentInfo39(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_39' verbose_name = '推送数据表39' app_label = 'db2' class EquipmentInfo40(models.Model): id = models.BigAutoField(primary_key=True, verbose_name='主键') device_user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name='用户id') device_uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='设备uid') device_nick_name = models.CharField(default='', max_length=32, verbose_name='设备昵称') channel = models.PositiveSmallIntegerField(default=1, verbose_name='设备通道') # 0:空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物), # 51:移动侦测,52:传感器报警,53:影像遗失,54:PIR,55:门磁报警,56:外部发报,57:人型报警, # 702:摄像头休眠,703:摄像头唤醒,704：电量过低 event_type = models.IntegerField(default=0, verbose_name='事件类型') # （51,）表示一个事件标签。（51,57,）两个事件标签 event_tag = models.CharField(default='', max_length=128, db_index=True, verbose_name='事件标签') alarm = models.CharField(default='', max_length=256, verbose_name='报警信息') # 0:无图, 1:单图, 3:多图 is_st = models.PositiveSmallIntegerField(default=0, verbose_name='图片信息') # 1: 阿里云, 2: AWS storage_location = models.PositiveSmallIntegerField(default=1, verbose_name='存储桶位置') border_coords = models.TextField(default='', verbose_name='ai类型图片边框位置信息') status = models.BooleanField(default=False, verbose_name='已读状态') # 0: 未读, 1: 已读 answer_status = models.BooleanField(default=False, verbose_name='接听状态') # 0: 未接听,1: 已接听 event_time = models.CharField(default='', max_length=10, db_index=True, verbose_name='上报时间') add_time = models.IntegerField(default=0, db_index=True, verbose_name='添加时间') class Meta: db_table = 'equipment_info_40' verbose_name = '推送数据表40' app_label = 'db2' class Ai_Push_Info(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') devUid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备ID') devNickName = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称') Channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道') eventType = models.CharField(blank=True, max_length=100, default='', verbose_name=u'事件类型') status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态') alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息') eventTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'设备报警时间') receiveTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间') userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID') is_st = models.SmallIntegerField(default=0, verbose_name='是否截图') # 0 否,1 是图，2,视频 storage_location = models.SmallIntegerField(default=1, db_index=True, verbose_name='数据信息存储位置。1：阿里云oss，2：aws') # message_id = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方推送服务器返回的id') # push_type = models.SmallIntegerField(blank=True, default=0, verbose_name='第三方推送服务器标志。0：APNS推送，1：谷歌推送，2：极光推送') # push_server_status = models.IntegerField(blank=True, default=200, verbose_name='是否成功推送到第三方服务器。200：成功，other：失败') # push_device_status = models.SmallIntegerField(blank=True, default=-1, verbose_name='是否成功推送到目标设备。0：失败，1：成功') addTime = models.IntegerField(verbose_name='添加时间', default=0) def __str__(self): return self.id class Meta: db_table = 'ai_push_info' verbose_name = u'ai信息推送表' verbose_name_plural = verbose_name ordering = ('-id',) class StatResModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='自动ID') name = models.CharField(default='', max_length=120, verbose_name='图片名称', unique=True) addTime = models.IntegerField(verbose_name='添加时间', default=0) def __str__(self): return self.name class Meta: db_table = 'statres' verbose_name = '静态资源表' verbose_name_plural = verbose_name ordering = ('id',) class FeedBackModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') userID = models.ForeignKey(Device_User, null=True, blank=True, to_field='userID', on_delete=models.CASCADE) type = models.SmallIntegerField(default=0, verbose_name='反馈类型') # 【0:产品建议,1:功能异常,2:安全问题】 status = models.SmallIntegerField(default=0, verbose_name='状态:0未解决/解决') content = models.TextField(blank=True, null=True, verbose_name=u'反馈描述') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) FS = models.ManyToManyField(to='StatResModel', blank=True, verbose_name=u'用户反馈关联资源', db_table='fb_res') app = models.CharField(max_length=8, default='', verbose_name='类型') # [ios,android] phone_model = models.CharField(max_length=64, default='', verbose_name='手机型号') # [小米,android] os_version = models.CharField(max_length=16, default='', verbose_name='系统版本') uid = models.CharField(max_length=20, default='', verbose_name='设备uid') product_type = models.CharField(max_length=32, default='', verbose_name='设备uid') app_version = models.CharField(max_length=32, default='', verbose_name='app版本信息') appBundleId = models.CharField(max_length=32, default='', verbose_name='app版本appBundleId') email = models.CharField(max_length=32, default='', verbose_name='app版本email') score = models.CharField(max_length=32, default='0', verbose_name='评分--星星数') def __str__(self): return self.id class Meta: db_table = 'feedback' verbose_name = u'用户反馈信息表' verbose_name_plural = verbose_name ordering = ('-id',) class User_Brand(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') # 关联用户 userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) deviceSupplier = models.CharField(max_length=32, default='', verbose_name='（必填）设备供应商 string （例：华为、小米...）') deviceModel = models.CharField(max_length=64, default='', verbose_name='（必填）设备型号 string @mock=HM NOTE 1TD') osType = models.CharField(max_length=32, default='', verbose_name='（必填）操作系统名称 string @mock=Android') osVersion = models.CharField(max_length=32, default='', verbose_name='（必填）操作系统版本号 string @mock=4.0') country = models.CharField(max_length=200, default='', verbose_name='国家') province = models.CharField(max_length=150, default='', verbose_name='省') city = models.CharField(max_length=132, default='', verbose_name='市') area = models.CharField(max_length=132, default='', verbose_name='区') street = models.CharField(max_length=132, default='', verbose_name='街道') longitude = models.CharField(max_length=30, default='', verbose_name='经度') latitude = models.CharField(max_length=30, default='', verbose_name='纬度') appId = models.CharField(max_length=50, default='', verbose_name='appid_值') status = models.IntegerField(default=0, verbose_name='传国家省市信息过来就为状态：1 ，不传就为状态：0') ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'区域ip') addTime = models.IntegerField(verbose_name='添加时间', default=0) def __str__(self): return self.id class Meta: db_table = 'user_brand' verbose_name = u'用户登录手机端手机品牌统计表' verbose_name_plural = verbose_name ordering = ('id',) # 存储通表 class VodBucketModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') bucket = models.CharField(max_length=60, verbose_name='存储桶名称') storeDay = models.IntegerField(default=0, verbose_name='存储生命周期(天)') content = models.TextField(verbose_name='描述', default='') endpoint = models.CharField(max_length=125, default='', verbose_name='存储节点') area = models.CharField(max_length=16, default='', verbose_name='区域') region = models.CharField(max_length=16, default='', verbose_name='regionID') is_free = models.SmallIntegerField(default=0, verbose_name='是否为免费存储桶[0:否,1:是]') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) mold = models.SmallIntegerField(default=0, verbose_name='存储区域类型') # 0：国内阿里 1：国外aws region_id = models.IntegerField(default=1, verbose_name='大洲编号') def __str__(self): return self.id class Meta: db_table = 'vod_bucket' verbose_name = u'存储通信息' verbose_name_plural = verbose_name ordering = ('-id',) class Store_Meal(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增ID') # title = models.CharField(blank=True, max_length=32, verbose_name=u'标题') currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币符号') symbol = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'符号') price = models.CharField(blank=True, max_length=32, verbose_name=u'价格') virtual_price = models.CharField(blank=True, max_length=32, verbose_name=u'虚拟价格') is_discounts = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否有优惠 [0=否，1是]') # 0没有；1有 discount_price = models.CharField(blank=True, max_length=32, verbose_name=u'第二年优惠价格') day = models.IntegerField(default=0, blank=True, verbose_name=u'云存录像保存天数（循环）') # 7,30,180,360 expire = models.IntegerField(default=0, blank=True, verbose_name=u'有效期') # 单位月 # content = models.TextField(blank=True, null=True, verbose_name=u'描述') add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True) # type = models.SmallIntegerField(default=0, verbose_name='付款类型') # 0是paypal,1为支付宝 pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='store_meal_pay') update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True) bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1, verbose_name='存储空间') commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型') # 0：事件型 1：连续型 commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码') is_show = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否隐藏 [0=否，1是]') # lang = models.CharField(default='', max_length=20, verbose_name='语言/国家') lang = models.ManyToManyField(to='Lang', verbose_name='套餐语言', db_table='store_meal_lang') cycle_config_id = models.IntegerField(null=True, verbose_name='周期付款配置表id') sort = models.IntegerField(default=99, blank=True, verbose_name=u'排序，越小越靠前') # 单位月 # 备用字段 spare_3 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段3') spare_4 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段4') def __str__(self): return self.id class Meta: db_table = 'store_meal' verbose_name = u'存储套餐' verbose_name_plural = verbose_name ordering = ('id',) class AiStoreMeal(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增ID') title = models.CharField(blank=True, max_length=32, verbose_name=u'标题') currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币符号') symbol = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'符号') price = models.CharField(blank=True, max_length=32, verbose_name=u'价格') virtual_price = models.CharField(blank=True, max_length=32, verbose_name=u'虚拟价格') is_discounts = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否有优惠 [0=否，1是]') # 0没有；1有 discount_price = models.CharField(blank=True, max_length=32, verbose_name=u'第二年优惠价格') effective_day = models.IntegerField(default=0, blank=True, verbose_name=u'有效天数') # 7,30,180,360 content = models.TextField(blank=True, null=True, verbose_name=u'描述') add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True) # type = models.SmallIntegerField(default=0, verbose_name='付款类型') # 0是paypal,1为支付宝 pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='ai_store_meal_pay') update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True) # bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, # default=1, verbose_name='存储空间') # commodity_type = models.SmallIntegerField(default=0, verbose_name='套餐类型') # 1：人形 2：动物 3：汽车 is_show = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否隐藏 [0=否，1是]') lang = models.CharField(default='', max_length=20, verbose_name='语言/国家') # cycle_config_id = models.IntegerField(null=True, verbose_name='周期付款配置表id') def __str__(self): return self.id class Meta: db_table = 'ai_store_meal' verbose_name = u'AI套餐' verbose_name_plural = verbose_name ordering = ('id',) class Pay_Type(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增ID') payment = models.CharField(max_length=32, verbose_name=u'支付方式') def __str__(self): return self.id class Meta: db_table = 'pay_type' verbose_name = u'付款类型' verbose_name_plural = verbose_name ordering = ('id',) # 套餐语言表 class Lang(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增ID') lang = models.CharField(default='', max_length=20, db_index=True, verbose_name='语言/国家') title = models.CharField(blank=True, max_length=320, verbose_name='标题') content = models.TextField(blank=True, null=True, verbose_name='描述') discount_content = models.CharField(blank=True, max_length=320, verbose_name=u'优惠信息描述') def __str__(self): return self.id class Meta: db_table = 'lang' verbose_name = '套餐语言' verbose_name_plural = verbose_name ordering = ('id',) class Equipment_Version(models.Model): eid = models.CharField(blank=True, max_length=32, primary_key=True) ESN = models.CharField(blank=True, max_length=32, verbose_name=u'设备规格名称') code = models.CharField(blank=True, max_length=64, verbose_name=u'设备规格代码') version = models.CharField(blank=True, max_length=64, verbose_name=u'设备版本') softwareVersion = models.CharField(blank=True, max_length=32, verbose_name=u'软件版本') chipModelList2Code = models.CharField(max_length=32, blank=True, verbose_name=u'主芯片码') channel = models.IntegerField(blank=True, verbose_name=u'通道数') resolutionRatio = models.IntegerField(blank=True, verbose_name=u'分辨率') type = models.CharField(blank=True, max_length=16, verbose_name=u'设备机型') companyCode = models.CharField(blank=True, max_length=128, verbose_name=u'用户公司名称') data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True) fileSize = models.CharField(blank=True, max_length=16, verbose_name=u'文件总大小') filePath = models.CharField(blank=True, max_length=256, verbose_name=u'升级文件路径') Description = models.TextField(blank=True, default='', verbose_name=u'描述信息') fileMd5 = models.CharField(blank=True, max_length=32, default='', verbose_name=u'上传文件MD5加密') status = models.BooleanField(blank=True, default=True, verbose_name=u'是否开启更新状态') update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True) lang = models.CharField(blank=True, default='en', max_length=32, verbose_name=u'ota包内置语言') mci = models.CharField(default='', blank=True, max_length=10, verbose_name='设备类型') img = models.CharField(max_length=300, blank=True, default='', verbose_name=u'图片路径') max_ver = models.CharField(default='', max_length=16, verbose_name='最大版本号') def __str__(self): return self.eid class Meta: verbose_name = '设备版本信息' ordering = ('-data_joined',) db_table = 'equipment_version' class App_Info(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID') appName = models.CharField(blank=True, max_length=32, verbose_name=u'app名称') systemLanguage = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言') newAppversion = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本') minAppversion = models.CharField(default='', blank=True, max_length=12, verbose_name=u'最小系统版本') bundleVersion = models.CharField(blank=True, max_length=12, verbose_name=u'项目版本') content = models.TextField(blank=True, default='', verbose_name=u'更新内容') app_type = models.IntegerField(default=0, blank=True, verbose_name=u'app类型') # ios 1,android 2 add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True) update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True) downloadLink = models.CharField(max_length=300, blank=True, default='', verbose_name='升级') img = models.CharField(default='', max_length=128, verbose_name='图片路径') def __str__(self): return self.id class Meta: db_table = 'app_info' verbose_name = u'app信息表' verbose_name_plural = verbose_name ordering = ('id',) class App_Colophon(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') app_id = models.ForeignKey(App_Info, to_field='id', on_delete=models.CASCADE, verbose_name='appid编号', blank=True, default=1) lang = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言') newApp_version = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本') content = models.TextField(blank=True, default='', verbose_name=u'更新内容') version_time = models.IntegerField(default=0, blank=True, verbose_name=u'版本更新的时间') def __str__(self): return self.id class Meta: db_table = 'app_colophon' verbose_name = u'app信息表的记录关联到App_Info' verbose_name_plural = verbose_name ordering = ('id',) class Order_Model(models.Model): orderID = models.CharField(blank=True, max_length=20, primary_key=True, verbose_name=u'订单id') paymentID = models.CharField(blank=True, max_length=64, default='', verbose_name='付款id') trade_no = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方订单号') userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) # 订单关联用户 UID = models.CharField(max_length=20, verbose_name='设备UID') channel = models.SmallIntegerField(default=0, verbose_name=u'通道数') desc = models.CharField(max_length=50, default='', verbose_name='商品描述') price = models.CharField(default='', max_length=16, verbose_name='价格') refunded_amount = models.FloatField(default=0, verbose_name=u'已退款金额') currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) isSelectDiscounts = models.SmallIntegerField(default=0, verbose_name=u'用户是否选择了第二年优惠 [0=否，1是]') # 0: 待支付, 1：支付成功, 2: 取消支付, 4: 退款失败, 5: 全额退款, 6: 部分退款, 9：处理中, 10：支付失败 status = models.SmallIntegerField(default=0, verbose_name='付款状态') # 1: PayPal, 2: 支付宝, 3: 微信, 10: 免费体验, 11: 激活码 payType = models.SmallIntegerField(default=0, verbose_name='支付方式') payTime = models.IntegerField(verbose_name='支付成功时间', default=0) rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='关联云存套餐表') ai_rank = models.ForeignKey(AiStoreMeal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='关联ai套餐表') order_type = models.SmallIntegerField(default=0, verbose_name='订单类型：0：云存：1:ai') nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称') uid_bucket_id = models.IntegerField(default=0, verbose_name='关联uid_bucket的字段') commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型') commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码') pay_url = models.CharField(max_length=2000, default='', verbose_name='支付url') paypal = models.CharField(max_length=500, null=True, blank=True, verbose_name='支付批准url') promotion_rule_id = models.CharField(blank=True, max_length=64, default='', verbose_name='促销id') plan_id = models.CharField(default='', blank=True, max_length=64, verbose_name=u'paypal计划id') agreement_id = models.CharField(default='', blank=True, max_length=64, verbose_name=u'paypal协议id') coupon_id = models.CharField(default='', blank=True, max_length=10, verbose_name=u'优惠券id') store_meal_name = models.CharField(default='', blank=True, max_length=64, verbose_name=u'关联套餐名') def __str__(self): return self.orderID class Meta: db_table = 'orders' verbose_name = u'订单信息表' verbose_name_plural = verbose_name ordering = ('-orderID',) class CouponModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID') use_status = models.SmallIntegerField(default=0, verbose_name='使用状态') # 0未使用；1冻结；2已使用 type = models.SmallIntegerField(default=0, verbose_name='优惠类型') # 1打折； 2抵扣 coupon_discount = models.CharField(blank=True, max_length=32, verbose_name=u'折扣力度') distributeTime = models.IntegerField(verbose_name='发放到用户账户时间', default=0) valid_time = models.PositiveIntegerField(default=9999999999, verbose_name='有效期间') # 超过有效期不可在使用；0永久 # use_limit = models.CharField(default=0, max_length=100, verbose_name='使用限制') #0:所有服务都可使用; 1:云存；2:ai; addTime = models.IntegerField(verbose_name='添加时间', default=0) def __str__(self): return self.id class Meta: db_table = 'coupon' verbose_name = u'优惠券' verbose_name_plural = verbose_name class PayCycleConfigModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') # name = models.CharField(default='',max_length=200, verbose_name='计划名字') # tax = models.CharField(max_length=2000, default='', verbose_name='税金') cycles = models.IntegerField(verbose_name='周期：0代表无限期', default=0) frequency = models.CharField(max_length=50, verbose_name='频率,MONTH,WEEK,YEAR', default=0) frequencyInterval = models.IntegerField(default=0, verbose_name='频率周期') remark = models.CharField(max_length=1000, default='', verbose_name='备注') def __str__(self): return self.id class Meta: db_table = 'pay_cycle_config' verbose_name = u'周期付款计划' verbose_name_plural = verbose_name class PromotionRuleModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') ruleName = models.TextField(default='', verbose_name='规则名字') # json格式, 例： {"cn":"黑色星期五","en":"Black Friday"} ruleDesc = models.TextField(default='', verbose_name='规则描述') # json格式, 例： {"cn":"买一送一","en":"buy one get one free"} ruleConfig = models.CharField(max_length=2000, default='', verbose_name='规则配置') # json格式, 例： {"buy": 1, "get": 1} startTime = models.IntegerField(verbose_name='促销活动开始时间', default=0) endTime = models.IntegerField(verbose_name='促销活动结束时间', default=0) status = models.SmallIntegerField(default=0, verbose_name='活动状态：0未进行；1进行中') remark = models.CharField(max_length=50, default='', verbose_name='备注') popups = models.CharField(max_length=2000, default='', verbose_name='app弹窗消息') # json格式 ,例： {"cn":"买一送一","en":"buy one get one free"} def __str__(self): return self.id class Meta: db_table = 'promotion_rule' verbose_name = u'促销规则表' verbose_name_plural = verbose_name ordering = ('-id',) class VodHlsModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='回放列表主键') uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True) channel = models.SmallIntegerField(default=0, verbose_name='通道') time = models.IntegerField(verbose_name='播放列表名字时间戳', default=0, db_index=True) endTime = models.IntegerField(verbose_name='云存储删除时间（周期）', default=0, db_index=True) sec = models.IntegerField(verbose_name='秒数', default=0) bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1, verbose_name='存储空间') fg = models.CharField(max_length=20, verbose_name='ts个数,时间描述片段数') # 阿里为时间片段数,亚马逊为一个32bit整型，前28bit代表ts文件的时长 def __str__(self): return self.id class Meta: db_table = 'vod_hls' verbose_name = u'云存回放信息表' verbose_name_plural = verbose_name ordering = ('-id',) class OssCrdModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') uid = models.CharField(max_length=20, verbose_name='设备UID') channel = models.SmallIntegerField(default=0, verbose_name='通道') data = models.TextField(verbose_name='设备sts') addTime = models.IntegerField(verbose_name='添加时间', default=0) bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1, verbose_name='存储空间') def __str__(self): return self.id class Meta: db_table = 'osscrd' verbose_name = u'设备证书' verbose_name_plural = verbose_name ordering = ('-id',) class StsCrdModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True) channel = models.SmallIntegerField(default=0, verbose_name='通道') data = models.TextField(verbose_name='设备sts') addTime = models.IntegerField(verbose_name='添加时间', default=0) bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1, verbose_name='存储空间') type = models.SmallIntegerField(default=0, verbose_name='sts类型') # 0:阿里云,1:s3 def __str__(self): return self.id class Meta: db_table = 'stscrd' verbose_name = u'设备证书' verbose_name_plural = verbose_name ordering = ('-id',) class UID_Bucket(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True) channel = models.SmallIntegerField(default=0, verbose_name='通道') bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间') status = models.SmallIntegerField(default=0, verbose_name='状态[0:开启,1:关闭]') endTime = models.BigIntegerField(verbose_name='套餐结束时间', db_index=True, default=0) addTime = models.IntegerField(verbose_name='添加时间', default=0) updateTime = models.BigIntegerField(verbose_name='更新时间', default=0) use_status = models.IntegerField(verbose_name='使用状态[1:使用中,2已过期]', default=0) has_unused = models.SmallIntegerField(default=0, verbose_name='是否拥有其它未使用的套餐[0:否,1:是]') class Meta: db_table = 'vod_uid_bucket' verbose_name = '设备关联套餐表' verbose_name_plural = verbose_name ordering = ('id',) class Unused_Uid_Meal(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True) channel = models.SmallIntegerField(default=0, verbose_name='通道') bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间') addTime = models.IntegerField(verbose_name='添加时间', default=0) expire = models.IntegerField(verbose_name='存储桶存储时长[月份]', default=0) num = models.IntegerField(verbose_name='个数', default=0) # effect_time = models.BigIntegerField(verbose_name='生效时间', db_index=True, default=0) # uid_bucket = models.ForeignKey(UID_Bucket, blank=True, to_field='id', on_delete=models.CASCADE, default=0, # verbose_name='uid_bucket关联') class Meta: db_table = 'unused_uid_Meal' verbose_name = '未使用的设备关联套餐表' verbose_name_plural = verbose_name ordering = ('id',) class UID_Preview(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID') channel = models.SmallIntegerField(verbose_name=u'通道号', default=0) addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) class Meta: db_table = 'uid_preview' verbose_name = '设备预览图' verbose_name_plural = verbose_name ordering = ('id',) # 系统发送信息新到用户 class SysMsgModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID') title = models.CharField(default='', max_length=64, verbose_name='标题') msg = models.TextField(blank=True, default='', verbose_name='发送内容') status = models.SmallIntegerField(verbose_name='是否已读', default=0) # 0:否,1:是 addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) # 消息类型, 0:系统通知, 702:休眠, 704:低电量 eventType = models.IntegerField(verbose_name='消息类型', default=0) jumpLink = models.TextField(default='', verbose_name='跳转链接') uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID') channel = models.IntegerField(default=0, verbose_name='通道号') class Meta: db_table = 'sys_msg' verbose_name = '系统消息' verbose_name_plural = verbose_name ordering = ('-id',) app_label = "db2" # 设备推送重构 # 设备配置表，新 class UidSetModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, db_index=True, unique=True, verbose_name='设备UID') channel = models.SmallIntegerField(default=0, verbose_name='通道数量') # detect_status = models.SmallIntegerField(default=0, verbose_name='推送开关') # 状态[0:关闭,1:开启,2:用户解绑] detect_interval = models.IntegerField(verbose_name='推送间隔', default=60) # 秒 addTime = models.IntegerField(verbose_name='添加时间', default=0, db_index=True) updTime = models.IntegerField(verbose_name='更新时间', default=0, db_index=True) ucode = models.CharField(max_length=32, verbose_name='设备产品码', default='') version = models.CharField(max_length=32, verbose_name='设备版本', default='') p2p_region = models.CharField(max_length=16, verbose_name='设备p2p区域', default='ALL') # ALL CN EU US tz = models.CharField(default='', max_length=16, verbose_name='设备时区') # +8 video_code = models.SmallIntegerField(default=0, verbose_name='编码类型') # 0:264,1:265 nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称') ip = models.CharField(max_length=20, default='', verbose_name=u'设备ip') # 设备重置后第一次启动时间 detect_group = models.CharField(default='', max_length=32, verbose_name=u'检测类型') pwd = models.CharField(max_length=32, default='', verbose_name=u'设备密码') # 暂时是预留字段 resetTime = models.IntegerField(default=0, verbose_name='设备重置时间') region_alexa = models.CharField(max_length=8, verbose_name='设备alexa区域', default='ALL') # ALL CN EU US deviceModel = models.CharField(blank=True, max_length=64, default='', verbose_name=u'设备型号') TimeZone = models.CharField(blank=True, max_length=50, default='', verbose_name=u'时区') TimeStatus = models.SmallIntegerField(default=0, verbose_name='同步手机时间开关。0：关闭，1：开启') SpaceUsable = models.CharField(blank=True, max_length=20, default='', verbose_name=u'可用空间') SpaceSum = models.CharField(blank=True, max_length=20, default='', verbose_name=u'总空间') MirrorType = models.IntegerField(blank=True, default=0, verbose_name=u'镜像类型 0:关闭镜像,1：上下镜像，2:左右镜像，3：上下左右镜像') RecordType = models.IntegerField(blank=True, default=0, verbose_name=u'录像模式(0:关闭,1:全是录像,3:报警录像)') OutdoorModel = models.IntegerField(blank=True, default=0, verbose_name=u'室外模式 0：关闭，1：开启') WIFIName = models.CharField(blank=True, max_length=50, default='', verbose_name=u'无线名称') isDetector = models.SmallIntegerField(default=0, verbose_name=u'侦测开关0:关闭,1:开启') DetectorRank = models.IntegerField(default=0, verbose_name=u'侦测灵敏度 0:低,1:中,2:高,3:最高') is_human = models.IntegerField(default=0, verbose_name='是否支持人形追踪。0：不支持，1：支持') is_custom_voice = models.IntegerField(default=0, verbose_name='是否支持自定义语音。0：不支持，1：支持') double_wifi = models.IntegerField(default=0, verbose_name='是否支持双频wifi。0：不支持，1：支持') isSupportFourPoint = models.SmallIntegerField(default=0, verbose_name='是否支持预置点') # 0:不支持, 1:支持 mobile_4g = models.IntegerField(default=0, verbose_name='是否支持4g。0：不支持，1：支持') is_ptz = models.IntegerField(default=0, verbose_name='是否支持云台。0：不支持，1：支持') is_ai = models.IntegerField(default=2, verbose_name='是否支持ai') # 0,关闭，1开启，2,不支持 cloud_vod = models.SmallIntegerField(default=2, verbose_name='云存开关') # 0,关闭，1开启，2,不支持 is_alexa = models.IntegerField(default=0, verbose_name='是否支持alexa') # 0为不支持，1为支持，2为开启alexa发现 is_notification = models.IntegerField(blank=True, default=1, verbose_name='新加-消息提醒开关') # 0：关闭，1：开启 new_detect_interval = models.IntegerField(blank=True, verbose_name='新加-消息提醒间隔', default=60) # 秒 tb_country = models.IntegerField(blank=True, default=0, verbose_name='国家') tb_city_information_id = models.IntegerField(blank=True, default=0, verbose_name='城市信息') device_type = models.SmallIntegerField(default=0, verbose_name='设备类型') ai_type = models.IntegerField(default=0, verbose_name='检测类型') msg_notify = models.JSONField(null=True, verbose_name='消息通知Json') class Meta: db_table = 'uid_set' verbose_name = u'设备配置表' verbose_name_plural = verbose_name ordering = ('id',) # 设备关联用户推送 class UidPushModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) uid_set = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE) appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID') app_type = models.IntegerField(default=0, verbose_name=u'app类型 1:ios,2:安卓') # 0: apns, 1: 安卓gcm, 2: 极光, 3:华为, 4:小米, 5:vivo, 6:oppo, 7:魅族, 8:荣耀 push_type = models.IntegerField(default=0, verbose_name=u'推送类型') token_val = models.CharField(default='', max_length=500, db_index=True, verbose_name=u'设备验证令牌') jg_token_val = models.CharField(default='', max_length=500, verbose_name=u'极光推送令牌') m_code = models.CharField(default='', max_length=64, verbose_name='手机唯一标识') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) lang = models.CharField(max_length=8, verbose_name='推送语言类型', default='en') # en英文 cn中文 tz = models.CharField(max_length=8, verbose_name='utc时区', default='0') class Meta: db_table = 'uid_push' verbose_name = '设备绑定' verbose_name_plural = verbose_name ordering = ('-id',) class GatewayPush(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') user_id = models.CharField(default='', max_length=32, db_index=True, verbose_name=u'用户id') app_bundle_id = models.CharField(default='', max_length=32, verbose_name=u'app包id') app_type = models.IntegerField(default=0, verbose_name=u'app类型') # 1: ios, 2: 安卓 push_type = models.IntegerField(default=0, verbose_name=u'推送类型') # 0: apns, 1: 安卓gcm, 2: 极光, 3:华为, 4:小米, 5:vivo, 6:oppo, 7:魅族 token_val = models.CharField(default='', max_length=500, verbose_name=u'设备验证令牌') m_code = models.CharField(default='', max_length=64, db_index=True, verbose_name='手机唯一标识') lang = models.CharField(default='en', max_length=8, verbose_name='推送语言') tz = models.CharField(default='0', max_length=8, verbose_name='时区') logout = models.BooleanField(default=False, verbose_name=u'退出登录') class Meta: db_table = 'gateway_push' verbose_name = '网关推送' verbose_name_plural = verbose_name app_label = 'db2' # 设备通道配置 class UidChannelSetModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') uid = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE) channel = models.IntegerField(default=1, verbose_name='通道号') channel_name = models.CharField(blank=True, default='', max_length=20, verbose_name=u'通道名') pir_audio = models.SmallIntegerField(default=0, verbose_name='pir声音。0：关闭，1：开启') mic_audio = models.SmallIntegerField(default=0, verbose_name='mic声音。0：关闭，1：开启') battery_status = models.SmallIntegerField(default=0, verbose_name='低电量提醒状态。0：关闭，1：开启') battery_level = models.SmallIntegerField(default=0, verbose_name='低电量提醒级别。0: 低于10%；1：低于25%；2：低于50%；3：低于75%') sleep_status = models.SmallIntegerField(default=0, verbose_name='是否开启【休眠通知】。0：关闭；1：开启') sleep_time = models.SmallIntegerField(default=0, verbose_name='摄像机进入休眠时间。0：不休眠；1：10秒；2：20秒；3：30秒') light_night_model = models.IntegerField(default=0, verbose_name='夜视模式') # 0：全彩模式，1：黑白模式，2：智能夜视模式 light_alarm_type = models.IntegerField(default=0, verbose_name='警报人形类型') # 0为人形，1为移动，3是人形和移动侦测0x0f # 声光报警级别: 0: 关闭，1：强烈声光告警，2：轻微声光告警，3: 强烈声告警，4:轻微声告警，5:强烈光告警 light_alarm_level = models.IntegerField(default=0, verbose_name='声光报警级别') light_alarm_man_en = models.IntegerField(default=0, verbose_name='人为告警状态') # 0：关，1：开 light_alarm_vol = models.IntegerField(default=0, verbose_name='报警音量') # 音量值0-100 light_long_light = models.IntegerField(default=0, verbose_name='长亮') voice_prompt_status = models.SmallIntegerField(default=0, verbose_name='个性语音提示快关。0：关闭，1：开启') voice_prompt_enter = models.IntegerField(default=0, verbose_name='进入铃声id') voice_prompt_leave = models.IntegerField(default=0, verbose_name='离开铃声id') voice_prompt_intelligent_mute = models.SmallIntegerField(default=0, verbose_name='智能静音。0：关闭，1：开启') voice_start_x = models.FloatField(default=0, verbose_name='起始坐标的x') voice_start_y = models.FloatField(default=18, verbose_name='起始坐标的y') voice_end_x = models.FloatField(default=44, verbose_name='结束坐标的x') voice_end_y = models.FloatField(default=18, verbose_name='结束坐标的y') voice_start_time = models.IntegerField(default=0, verbose_name='语音执行的起始时间') voice_end_time = models.IntegerField(default=0, verbose_name='语音执行的结束时间') voice_repeat_day = models.IntegerField(default=127, verbose_name='语音执行的日期，周几') voice_direction = models.IntegerField(default=0, verbose_name='语音方向。') class Meta: db_table = 'uid_channel' verbose_name = '设备通道设置' verbose_name_plural = verbose_name # oauth2 第三方登录补全信息 class UserExModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) appBundleId = models.CharField(default='', max_length=32, verbose_name=u'appID') region = models.CharField(default='', max_length=16, verbose_name='区域语言') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'} class Meta: db_table = 'user_ex' verbose_name = '用户扩展信息表' verbose_name_plural = verbose_name ordering = ('-id',) # oauth2 第三方登录补全信息 class UserOauth2Model(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) authType = models.SmallIntegerField(default=0, verbose_name=0) # 授权类型 0 非授权，1 微信授权，2 苹果授权 unionID = models.CharField(default='', max_length=64, verbose_name='唯一标记') # 绑定唯一标记 unionID addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='更新时间', default=0) # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'} class Meta: db_table = 'user_oauth2' verbose_name = '用户oauth2关联' verbose_name_plural = verbose_name ordering = ('-id',) class SysMassModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键自增id') sender = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) # 发送人 platform = models.CharField(default='', verbose_name='平台', max_length=16) lang = models.TextField(blank=True, default='', verbose_name=u'语种') recever = models.TextField(blank=True, default='', verbose_name=u'接受者') msg = models.TextField(blank=True, default='', verbose_name=u'发送内容') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='修改时间', default=0) class Meta: db_table = 'sys_mass' verbose_name = '群发消息记录表' verbose_name_plural = verbose_name ordering = ('-id',) class UidUserModel(models.Model): id = models.CharField(max_length=32, primary_key=True) userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) NickName = models.CharField(max_length=32, verbose_name=u'设备名称') UID = models.CharField(max_length=32, verbose_name=u'设备UID', default='') View_Account = models.CharField(max_length=32, verbose_name=u'设备用户名称', default='') View_Password = models.CharField(max_length=32, verbose_name=u'设备密码', default='') ChannelIndex = models.IntegerField(verbose_name=u'通道号', default=0) Type = models.IntegerField(verbose_name='设备类型') NotificationMode = models.IntegerField(verbose_name=u'是否报警', default=0) isShare = models.BooleanField(verbose_name=u'共享设备', default=False) primaryUserID = models.CharField(verbose_name='主用户id', max_length=32, default='') primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='') data_joined = models.DateTimeField(verbose_name=u'设备添加时间', auto_now_add=True) version = models.CharField(max_length=20, default='', verbose_name=u'版本号') isVod = models.SmallIntegerField(default=0, verbose_name='是否支持云存') # 是否支持云存设备 isExist = models.SmallIntegerField(default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在，0不存在 is_ap = models.SmallIntegerField(default=1, verbose_name='是否为ap模式添加') # 1为ap模式添加，0为非ap模式添加 class Meta: db_table = 'uid_user' ordering = ('-data_joined',) verbose_name = u'用户设备ap表' verbose_name_plural = verbose_name class pushDeployModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键自增id') name = models.CharField(max_length=32, default='', verbose_name=u'推送配置名称') key = models.CharField(max_length=32, default='', verbose_name=u'推送配置key') secret = models.CharField(max_length=32, default='', verbose_name=u'推送配置密钥') pem = models.CharField(max_length=32, default='', verbose_name=u'推送配置路径') type = models.CharField(max_length=32, default='', verbose_name=u'推送配置类型') # ios 1,android 2 addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='修改时间', default=0) class Meta: db_table = 'push_deploy' verbose_name = '推送配置表' verbose_name_plural = verbose_name ordering = ('-id',) class AppSetModel(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键自增id') appBundleId = models.CharField(max_length=64, default='', verbose_name=u'APPid') content = models.TextField(default='', verbose_name=u'里面包含评分，用户帮助，ap添加方式，ap工具，广告模块等json字段值') addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.IntegerField(verbose_name='修改时间', default=0) class Meta: db_table = 'app_set' verbose_name = 'app的各个版本控制表' verbose_name_plural = verbose_name ordering = ('-id',) # 认证客户端类型表 class ApplicationModel(models.Model): CLIENT_TYPES = ( ('confidential', 'confidential'), ('public', 'public'), ) # authorization_code # 授权码模式(即先登录获取code, 再获取token) # password # 密码模式(将用户名, 密码传过去, 直接获取token) # client_credentials # 客户端模式(无用户, 用户向客户端注册, 然后客户端以自己的名义向’服务端’获取资源) # implicit # 简化模式(在redirect_uri # 的Hash传递token; # Auth客户端运行在浏览器中, 如JS, Flash) # refresh_token # 刷新access_token GRANT_TYPES = ( ('authorization_code', "authorization_code"), ('password', "password"), ('client_credentials', "client_credentials"), ('implicit', "implicit"), ('refresh_token', "refresh_token"), ) id = models.BigAutoField(primary_key=True) name = models.CharField(max_length=128, blank=True, verbose_name='client名字描述') client_id = models.CharField(max_length=50, unique=True, verbose_name='客户端id') client_secret = models.CharField(max_length=50, unique=True, verbose_name='客户端secret') client_type = models.CharField(max_length=32, choices=CLIENT_TYPES, verbose_name='客户端类型') grant_type = models.CharField(max_length=32, choices=GRANT_TYPES, blank=True, null=True) redirect_uri = models.TextField(blank=True, null=True, verbose_name='重定向url') skip_auth = models.BooleanField(default=False, verbose_name='是否跳过点击授权') add_time = models.IntegerField(verbose_name='添加时间', default=0) update_time = models.IntegerField(verbose_name='更新时间', default=0) class Meta: ordering = ('-add_time',) verbose_name = u'可授权客户端表' db_table = 'oauth_application' # 授权码信息表 class GrantCodeModel(models.Model): id = models.BigAutoField(primary_key=True) userID = models.ForeignKey(Device_User, verbose_name="用户表userID", to_field='userID', on_delete=models.CASCADE) code = models.CharField(max_length=32, unique=True) app_id = models.CharField(max_length=100, default='', verbose_name="appBundleId") application = models.ForeignKey(ApplicationModel, verbose_name="用户表id", to_field='id', on_delete=models.CASCADE) expire_time = models.IntegerField(verbose_name='过期时间', default=0) add_time = models.IntegerField(verbose_name='添加时间', default=0) update_time = models.IntegerField(verbose_name='更新时间', default=0) # 输出的永远是本地时间输出的永远是本地时间 def is_expired(self): return timezone.now() >= self.expire_time class Meta: ordering = ('-add_time',) verbose_name = u'授权码表' db_table = 'oauth_grant_code' class UserAppFrequencyModel(models.Model): id = models.AutoField(primary_key=True) user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表') type = models.SmallIntegerField(default=0, verbose_name='使用频率类型') # 1：每天，2：三天，3：一周，4：两周，5：一个月，6：一个月以上 data_time = models.IntegerField(default=0, verbose_name='数据时间') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: verbose_name = '用户使用APP频率表' verbose_name_plural = verbose_name db_table = 'user_app_frequency' ordering = ('-add_time',) class AppFrequencyStatisticsModel(models.Model): id = models.AutoField(primary_key=True) data = models.TextField(default='', verbose_name='统计好的数据') month = models.IntegerField(default=0, verbose_name='月份') year = models.IntegerField(default=0, verbose_name='年份') class Meta: verbose_name = 'app月使用频率统计表' verbose_name_plural = verbose_name db_table = 'app_frequency_statistics' class AppFrequencyYearStatisticsModel(models.Model): id = models.AutoField(primary_key=True) data = models.TextField(default='', verbose_name='统计好的数据') year = models.IntegerField(default=0, verbose_name='年份') num = models.IntegerField(default=0, verbose_name='总人数') class Meta: verbose_name = 'app使用频率统计表，年度统计' verbose_name_plural = verbose_name db_table = 'app_frequency_year_statistics' # alexa连接数统计表 class AlexaConnectStatisticsModel(models.Model): id = models.AutoField(primary_key=True) num = models.IntegerField(default=0, verbose_name='总人数') data_time = models.IntegerField(default=0, verbose_name='数据时间') class Meta: verbose_name = 'alexa连接数统计表' verbose_name_plural = verbose_name db_table = 'alexa_statistics' class FAQModel(models.Model): id = models.AutoField(primary_key=True) title = models.CharField(max_length=64, default='', unique=True, verbose_name='标题') content = models.TextField(default='', verbose_name='内容') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_faq' verbose_name = '问题帮助表' verbose_name_plural = verbose_name class AppLogModel(models.Model): id = models.AutoField(primary_key=True) user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表') uid = models.CharField(max_length=20, default='', verbose_name='设备uid') average_delay = models.CharField(max_length=32, default='', verbose_name='最高平均延时') status = models.SmallIntegerField(default=0, verbose_name='失败状态') # 0: 成功,1: 失败 filename = models.CharField(max_length=120, default='', verbose_name='文件名') add_time = models.IntegerField(default=0, verbose_name='日期') class Meta: db_table = 'app_log' verbose_name = 'APP日志表' verbose_name_plural = verbose_name class DeviceLogModel(models.Model): id = models.AutoField(primary_key=True) ip = models.CharField(default='', max_length=32, verbose_name='ip') uid = models.CharField(max_length=32, default='', verbose_name='设备uid') serial_number = models.CharField(max_length=9, default='', verbose_name='序列号') status = models.SmallIntegerField(default=0, verbose_name='上传状态') # 0: 成功,1: 失败 filename = models.CharField(max_length=120, default='', verbose_name='文件名') add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间') class Meta: db_table = 'device_log' verbose_name = '设备日志表' verbose_name_plural = verbose_name class EquipmentInfoExStatisticsModel(models.Model): id = models.AutoField(primary_key=True) push_type = models.SmallIntegerField(default=0, verbose_name='第三方推送服务器标志。0：APNS推送，1：谷歌推送，2：极光推送') number_of_successes = models.IntegerField(default=0, verbose_name='推送成功数量') number_of_failures = models.IntegerField(default=0, verbose_name='推送失败数量') number_of_arrival = models.IntegerField(default=0, verbose_name='推送到达数量') statistics_date = models.IntegerField(default=0, verbose_name='属于哪天、哪月的统计') date_type = models.SmallIntegerField(default=0, verbose_name='统计日期的类型。0：天，1：月') add_time = models.IntegerField(default=0, verbose_name='添加时间') class Meta: db_table = 'equipment_info_ex_statistics' verbose_name = '推送消息统计表' verbose_name_plural = verbose_name class CountryIPModel(models.Model): id = models.AutoField(primary_key=True) ip = models.CharField(default='', max_length=32, verbose_name='ip') user_ex = models.ForeignKey(UserExModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户扩展信息表id') country = models.CharField(default='', max_length=100, verbose_name='国家') status = models.SmallIntegerField(default=0, verbose_name='是否已经查找，0：否，1：是') add_time = models.IntegerField(default=0, verbose_name='添加时间') class Meta: db_table = 'country_ip' verbose_name = 'ip-国家统计表' verbose_name_plural = verbose_name class ZositechHelpModel(models.Model): id = models.AutoField(primary_key=True) locale = models.CharField(default='', db_index=True, max_length=50, verbose_name='语言') label_names = models.CharField(default='', db_index=True, max_length=50, verbose_name='标签') origin = models.CharField(default='', db_index=True, max_length=50, verbose_name='来源') # author_id = models.CharField(default='', max_length=50, verbose_name='管理员id') # body = models.TextField(default='', blank=True, verbose_name='内容') # comments_disabled = models.CharField(default='', max_length=10, verbose_name='comments') # created_at = models.CharField(default='', max_length=50, verbose_name='创建时间') # draft = models.CharField(default='', max_length=10, verbose_name='草稿') # edited_at = models.CharField(default='',max_length=50, verbose_name='修改时间') # html_url = models.CharField(default='', blank=True, verbose_name='跳转路径') # body = models.CharField(default='', blank=True, verbose_name='标签') # body = models.CharField(default='', blank=True, verbose_name='标签') # body = models.TextField(default='', blank=True, verbose_name='标签') # body = models.TextField(default='', blank=True, verbose_name='标签') # body = models.CharField(default='', blank=True, verbose_name='标签') # body = models.CharField(default='', blank=True, verbose_name='标签') content = models.TextField(blank=True, default='', verbose_name=u'内容') class Meta: db_table = 'zositech_help' verbose_name = '周视使用帮助表' verbose_name_plural = verbose_name class EquipmentVersionLimitModel(models.Model): id = models.AutoField(primary_key=True) type = models.SmallIntegerField(default=0, verbose_name='限制类型') content = models.TextField(default='', verbose_name='限制内容') equipment_version = models.ForeignKey(Equipment_Version, to_field='eid', on_delete=models.CASCADE, verbose_name='关联设备版本信息id') status = models.SmallIntegerField(default=0, verbose_name='是否启用。0：不启用，1：启用') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'equipment_version_limit' verbose_name = '设备版本信息限制表' verbose_name_plural = verbose_name class ExperienceContextModel(models.Model): id = models.AutoField(primary_key=True) experience_type = models.SmallIntegerField(default=0, verbose_name='体验类型') # 0: 免费体验套餐， 1： 激活码 uid = models.CharField(max_length=20, default='', verbose_name='设备uid') do_time = models.IntegerField(default=0, verbose_name='激活时间') # is_experience = models.SmallIntegerField(default=0, verbose_name=u'是否云存体验用户') # 0：不是体验用户，1：是体验用户 class Meta: db_table = 'experience_context' verbose_name = '设备体验表' verbose_name_plural = verbose_name class CDKcontextModel(models.Model): id = models.AutoField(primary_key=True) cdk = models.CharField(max_length=50, unique=True, verbose_name='激活码') create_time = models.IntegerField(default=0, verbose_name='创建时间') valid_time = models.IntegerField(default=0, verbose_name='有效期间') # 超过有效期激活码不可在激活 ,0：永久 is_activate = models.SmallIntegerField(default=0, verbose_name='是否已激活') # 0 未激活 1 已激活 is_down = models.SmallIntegerField(default=0, verbose_name='是否已下载') # 0 未下载 1 已下载 rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='套餐类型') # order = models.ForeignKey(Order_Model, blank=True, max_length=20, to_field='orderID', on_delete=models.CASCADE, verbose_name='订单id', unique=True) order = models.CharField(max_length=20, blank=True, unique=True, verbose_name='订单id') # 备用字段 spare_1 = models.CharField(default='', blank=True, max_length=64, verbose_name=u'备用字段1') spare_2 = models.CharField(default='', blank=True, max_length=64, verbose_name=u'备用字段2') spare_3 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段3') spare_4 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段4') class Meta: db_table = 'cdk_context' verbose_name = '激活码表' verbose_name_plural = verbose_name class VoicePromptModel(models.Model): id = models.AutoField(primary_key=True) title = models.CharField(max_length=128, default='', verbose_name='语音标题') type = models.SmallIntegerField(default=0, verbose_name='语音类型。0：进入语音，1：离开语音') filename = models.CharField(max_length=120, default='', verbose_name='文件名') language = models.CharField(max_length=16, default='', verbose_name='语言类型') classification = models.SmallIntegerField(default=1, verbose_name='语音分类。0：系统，1：自定义') add_time = models.IntegerField(default=0, verbose_name='添加时间') uid = models.CharField(max_length=20, default='0', verbose_name='关联设备UID') channel = models.IntegerField(default=0, verbose_name='通道号') status = models.SmallIntegerField(default=1, verbose_name='是否启用。0：不启用，1：启用') class Meta: db_table = 'voice_prompt' verbose_name = '语音提示表' verbose_name_plural = verbose_name class DeviceTypeModel(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=64, default='', verbose_name='设备名称') model = models.SmallIntegerField(default=0, verbose_name='设备大类。1：dvr，2：ipc') type = models.IntegerField(default=0, verbose_name='设备类型') ptz_type = models.IntegerField(default=0, verbose_name='ptz类型。1：dvr球机，2：IPCPTZ，3：同轴菜单') icon = models.CharField(max_length=120, default='', verbose_name='文件名') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'device_type' verbose_name = '设备类型表' verbose_name_plural = verbose_name class OperatingLogsModel(models.Model): id = models.AutoField(primary_key=True) userId = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作人') operatingtime = models.DateTimeField(blank=True, verbose_name=u'操作时间', auto_now=True) operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容') operatingtype = models.CharField(blank=True, verbose_name=u'操作类型', max_length=32) is_saveprocessinfo = models.SmallIntegerField(default=1, verbose_name=u'是否保存过程信息。1：保存，2：不保存') devUid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备ID') userIp = models.CharField(blank=True, max_length=20, default='', verbose_name=u'用户ip') class Meta: db_table = 'operating_logs' verbose_name = '操作数据表' verbose_name_plural = verbose_name class ProcessInfoLogsModel(models.Model): id = models.AutoField(primary_key=True) userId = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作人') devUid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备ID') operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容') operatingtime = models.DateTimeField(blank=True, verbose_name=u'操作时间', auto_now=True) class Meta: db_table = 'processinfo_logs' verbose_name = '过程信息表' verbose_name_plural = verbose_name class EquipmentLogModel(models.Model): id = models.AutoField(primary_key=True) user = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作用户') uid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备uid') equipmentid = models.CharField(blank=False, max_length=100, db_index=True, verbose_name=u'设备主键id') NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称') ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址') time = models.DateTimeField(null=True, blank=True, db_index=True, verbose_name=u'访问时间') operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容') url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径') class Meta: db_table = 'equipment_log' verbose_name = '设备日志表' verbose_name_plural = verbose_name class UserModel(models.Model): id = models.AutoField(primary_key=True) username = models.CharField(unique=True, max_length=128, null=False, verbose_name='用户名') password = models.CharField(max_length=128, null=False, verbose_name='密码') permission = models.CharField(max_length=24, null=False, verbose_name='权限') login_time = models.IntegerField(blank=True, default=0, verbose_name='登录时间') online = models.SmallIntegerField(default=0, verbose_name='是否在线') phone = models.CharField(max_length=11, default='', verbose_name='手机号') add_time = models.IntegerField(default=0, verbose_name='添加时间') class Meta: verbose_name = '用户表' verbose_name_plural = verbose_name db_table = 'user' class CompanyModel(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=64, unique=True, default='', verbose_name='企业名称') mark = models.CharField(max_length=3, unique=True, default='', verbose_name='企业标志，用于序列号的后三位') secret = models.CharField(max_length=10, db_index=True, default='', verbose_name='企业秘钥') quantity = models.IntegerField(default=0, verbose_name='已购买的序列号的数量') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_company' verbose_name = '企业表' verbose_name_plural = verbose_name class RegionModel(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32, default='', verbose_name='区域名称') continent_code = models.CharField(max_length=3, default='', verbose_name='洲代码') api = models.CharField(max_length=50, default='', verbose_name='请求地址') class Meta: db_table = 'tb_region' verbose_name = '区域表' verbose_name_plural = verbose_name class VPGModel(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=32, default='', verbose_name='群组名称') uid_count = models.IntegerField(default=0, verbose_name='uid数量') region = models.ForeignKey(RegionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='群组用于的地区') company = models.ForeignKey(CompanyModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联企业表') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_vpg' verbose_name = 'vpg表' verbose_name_plural = verbose_name class UIDModel(models.Model): id = models.AutoField(primary_key=True) uid = models.CharField(max_length=20, null=False, db_index=True, unique=True, verbose_name='设备id') mac = models.CharField(max_length=17, null=True, default='', verbose_name='设备id对应的mac地址') uid_extra = models.TextField(default='', verbose_name='uid的额外描述') status = models.SmallIntegerField(default=0, verbose_name='使用状态') # 0:未分配,1:已分配,2:已使用 add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') area = models.SmallIntegerField(default=0, verbose_name='区域') # 0：国内；1：国外 vpg = models.ForeignKey(VPGModel, to_field='id', default=1, on_delete=models.DO_NOTHING, verbose_name='关联VPG表的id') p2p_type = models.IntegerField(default=1, verbose_name='p2p类型。1：宸云，2：tutk') full_uid_code = models.CharField(max_length=256, default='', verbose_name='宸云完整uid') platform = models.CharField(max_length=10, default='', verbose_name='平台') init_string = models.CharField(max_length=256, default='', verbose_name='尚云设备初始化字符') init_string_app = models.CharField(max_length=256, default='', verbose_name='尚云设备app初始化字符') class Meta: ordering = ('-add_time',) verbose_name = 'uid表' verbose_name_plural = verbose_name db_table = 'uid' class UserUIDModel(models.Model): id = models.AutoField(primary_key=True) user = models.ForeignKey(UserModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户表id') uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联uid表id') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: verbose_name = '用户与UID的关联表' verbose_name_plural = verbose_name db_table = 'user_uid' class PermissionModel(models.Model): id = models.AutoField(primary_key=True) type = models.SmallIntegerField(null=False, verbose_name='权限枚举') description = models.TextField(default='', verbose_name='权限描述') class Meta: verbose_name = '权限表' verbose_name_plural = verbose_name db_table = 'permission' class LogModel(models.Model): id = models.AutoField(primary_key=True) operation = models.CharField(max_length=100, default='', verbose_name='操作描述') time = models.IntegerField(default=0, verbose_name='操作时间') ip = models.CharField(default='', max_length=24, verbose_name='用户ip') user = models.ForeignKey(UserModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户id') content = models.TextField(default='', verbose_name='请求参数') status = models.IntegerField(default=0, verbose_name='请求状态') url = models.CharField(max_length=150, default='', verbose_name='请求路径') class Meta: ordering = ('-time',) verbose_name = '日志表' verbose_name_plural = verbose_name db_table = 'log' class HistoryUIDModel(models.Model): id = models.AutoField(primary_key=True) uid = models.CharField(max_length=20, null=False, db_index=True, verbose_name='设备id') uid_extra = models.TextField(default='', verbose_name='uid的额外描述') status = models.SmallIntegerField(default=0, verbose_name='使用状态') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') area = models.SmallIntegerField(default=0, verbose_name='区域') # 0：国内；1：国外 class Meta: verbose_name = '历史UID表' verbose_name_plural = verbose_name db_table = 'history_uid' class MacModel(models.Model): id = models.AutoField(primary_key=True) value = models.CharField(max_length=17, null=False, verbose_name='最新的mac地址') is_active = models.BooleanField(default=True, verbose_name='当前mac地址是否可用') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: verbose_name = '最新的mac地址表' verbose_name_plural = verbose_name db_table = 'tb_mac' class OrderTaskModel(models.Model): id = models.AutoField(primary_key=True) order_number = models.CharField(max_length=32, verbose_name='订单号') board = models.CharField(max_length=32, verbose_name='主板') plan = models.CharField(max_length=32, verbose_name='配置方案') checksum = models.CharField(max_length=32, verbose_name='校验和') ic_model = models.CharField(max_length=32, verbose_name='ic型号') quantity = models.IntegerField(default=0, verbose_name='通知单上的生成数量') add_time = models.IntegerField(default=0, verbose_name='添加时间') class Meta: db_table = 'order_task' verbose_name = '订单任务表' verbose_name_plural = verbose_name class OrderUIDModel(models.Model): id = models.AutoField(primary_key=True) uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联uid表') order = models.ForeignKey(OrderTaskModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联订单任务表') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'order_uid' verbose_name = '订单与uid关联表' verbose_name_plural = verbose_name class CountryModel(models.Model): id = models.AutoField(primary_key=True) number = models.IntegerField(unique=True, verbose_name='区号') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') region = models.ForeignKey(RegionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联区域表') country_code = models.CharField(max_length=2, default='', verbose_name='国家iso2代码') country_name = models.CharField(max_length=20, default='', verbose_name='国家名') class Meta: db_table = 'tb_country' verbose_name = '地区表' verbose_name_plural = verbose_name class LanguageModel(models.Model): id = models.AutoField(primary_key=True) lang = models.CharField(max_length=16, default='', verbose_name='语种') lang_youdao = models.CharField(max_length=16, default='', verbose_name='有道的语种') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_language' verbose_name = '语言表' verbose_name_plural = verbose_name class CountryLanguageModel(models.Model): id = models.AutoField(primary_key=True) country_name = models.CharField(max_length=64, default='', verbose_name='国家名称') language = models.ForeignKey(LanguageModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联语言表的id') country = models.ForeignKey(CountryModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联地区表的id') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_country_language' verbose_name = '不同语言的地区名称表' verbose_name_plural = verbose_name class SerialNumberModel(models.Model): id = models.AutoField(primary_key=True) serial_number = models.CharField(max_length=9, db_index=True, unique=True, verbose_name='序列号') status = models.SmallIntegerField(default=1, verbose_name='可用状态。0：不可用，1：可用') use_status = models.SmallIntegerField(default=0, db_index=True, verbose_name='使用状态, 0: 未使用, 1: 已分配') add_time = models.IntegerField(default=0, verbose_name='添加时间') class Meta: db_table = 'tb_serial_number' verbose_name = '序列号表' verbose_name_plural = verbose_name class CompanySerialModel(models.Model): id = models.AutoField(primary_key=True) company = models.ForeignKey(CompanyModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联企业表的id') serial_number = models.CharField(max_length=11, db_index=True, blank=True, default='', verbose_name=u'6位数序列号') status = models.SmallIntegerField(default=0, verbose_name='序列号的状态。0：未使用，1：已使用，2：已和UID关联,3:已占用') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_company_serial' verbose_name = '企业关联序列号表' verbose_name_plural = verbose_name class UIDCompanySerialModel(models.Model): id = models.AutoField(primary_key=True) uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联UID表') company_serial = models.ForeignKey(CompanySerialModel, to_field='id', on_delete=models.CASCADE, verbose_name='6位数序列号') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'tb_uid_company_serial' verbose_name = 'UID关联【企业关联序列号】表' verbose_name_plural = verbose_name class iotdeviceInfoModel(models.Model): id = models.AutoField(primary_key=True) serial_number = models.CharField(max_length=11, blank=True, default='', db_index=True, verbose_name=u'关联Device_Info表的序列号') uid = models.CharField(blank=True, max_length=32, default='', db_index=True, verbose_name=u'设备UID') certificate_id = models.CharField(blank=True, max_length=256, default='', verbose_name=u'证书id') certificate_pem = models.TextField(blank=True, default='', verbose_name=u'证书项目') public_key = models.TextField(blank=True, default='', verbose_name=u'公有密钥') private_key = models.TextField(blank=True, default='', verbose_name=u'私有密钥') thing_name = models.CharField(blank=True, max_length=256, default='', verbose_name=u'IoT Thing Name') thing_groups = models.CharField(blank=True, max_length=256, default='', verbose_name=u'IoT Thing Groups') endpoint = models.CharField(blank=True, max_length=256, db_index=True, default='', verbose_name=u'iot端点') token_iot_number = models.CharField(blank=True, db_index=True, default='', max_length=50, verbose_name='连接iot令牌') add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间') update_time = models.DateTimeField(blank=True, auto_now=True, verbose_name=u'更新时间') class Meta: db_table = 'iot_deviceInfo' verbose_name = 'iot设备信息表' verbose_name_plural = verbose_name ordering = ('-add_time',) class UIDMainUser(models.Model): id = models.AutoField(primary_key=True) UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID', default='') user_id = models.CharField(blank=True, max_length=32, verbose_name=u'用户ID', default='') class Meta: db_table = 'uid_mainuser' verbose_name = '设备主用户表' verbose_name_plural = verbose_name class Pc_Info(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') pc_name = models.CharField(blank=True, max_length=32, verbose_name=u'软件名称') bundle_version = models.IntegerField(default=0, verbose_name=u'项目类型。0：Zosi;149：COCOON HD; 150:Loocam; 151:中性') pc_version = models.CharField(blank=True, max_length=12, verbose_name=u'版本号') pc_test = models.SmallIntegerField(default=0, verbose_name='测试版。0：否，1：是') lang = models.CharField(blank=True, max_length=32, verbose_name=u'语言类型') download_link = models.CharField(max_length=300, blank=True, default='', verbose_name='下载链接') add_time = models.IntegerField(verbose_name='添加时间', default=0) update_time = models.IntegerField(verbose_name='更新时间', default=0) file_type = models.CharField(blank=True, max_length=32, verbose_name=u'文件类型') package = models.CharField(blank=True, max_length=32, verbose_name=u'整合包id') explain = models.TextField(blank=True, default='', verbose_name=u'更新内容') is_update = models.SmallIntegerField(blank=True, default=0, verbose_name='强制更新。0：否，1：是') is_open = models.SmallIntegerField(blank=True, default=0, verbose_name='是否开启版本。0：否，1：是') content = models.TextField(blank=True, default='', verbose_name=u'内容信息') authority = models.SmallIntegerField(blank=True, default=0, verbose_name='权限') class Meta: db_table = 'pc_info' verbose_name = u'pc信息表' verbose_name_plural = verbose_name ordering = ('id',) class CloudLogModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') user = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户') uid = models.CharField(blank=True, max_length=32, db_index=True, verbose_name=u'uid', default='') operation = models.CharField(max_length=100, db_index=True, default='', blank=True, verbose_name=u'操作') ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址') url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径') time = models.IntegerField(null=True, blank=True, db_index=True, verbose_name=u'访问时间') content = models.TextField(blank=True, default='', verbose_name=u'参数内容') class Meta: db_table = 'cloud_log' verbose_name = '云存api记录表' verbose_name_plural = verbose_name class VideoPlaybackTimeModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') userID = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户ID') uid = models.CharField(max_length=32, default='', db_index=True, verbose_name=u'uid') playMode = models.CharField(max_length=10, default='', verbose_name=u'播放模式') startTime = models.IntegerField(default=0, verbose_name=u'开始播放时间') duration = models.SmallIntegerField(default=0, verbose_name='播放时长') class Meta: db_table = 'video_playback_time' verbose_name = '视频播放时长表' verbose_name_plural = verbose_name class PctestjobModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') jobname = models.CharField(blank=True, max_length=32, verbose_name=u'岗位名字') jobcode = models.SmallIntegerField(default=3, verbose_name='岗位code 。1：管理员，3：普通人员') class Meta: db_table = 'pctest_job' verbose_name = u'pc岗位表' verbose_name_plural = verbose_name ordering = ('id',) class PctestdeviceModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') devicename = models.CharField(blank=True, max_length=32, verbose_name=u'设备名字') class Meta: db_table = 'pctest_device' verbose_name = u'pc测试设备表' verbose_name_plural = verbose_name ordering = ('id',) class PctestfunctionModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') functionname = models.CharField(blank=True, max_length=32, verbose_name=u'职能名字') functioncode = models.SmallIntegerField(default=1, verbose_name='职能code 。PC端自己逻辑判断') class Meta: db_table = 'pctest_function' verbose_name = u'pc设备职能表' verbose_name_plural = verbose_name ordering = ('id',) class PctestuserModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') username = models.CharField(blank=True, max_length=32, verbose_name=u'用户名字') password = models.CharField(blank=True, max_length=32, verbose_name=u'用户名字') job = models.ForeignKey(PctestjobModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表') class Meta: db_table = 'pctest_user' verbose_name = u'pc角色岗位表' verbose_name_plural = verbose_name ordering = ('id',) class PctestlogModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') user = models.ForeignKey(PctestuserModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表') content = models.TextField(blank=True, default='', verbose_name=u'测试日志') addtime = models.IntegerField(verbose_name='添加时间', default=0) class Meta: db_table = 'pctest_log' verbose_name = u'pc测试日志表' verbose_name_plural = verbose_name ordering = ('id',) class PctestjobdeviceModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') job = models.ForeignKey(PctestjobModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表') device = models.ForeignKey(PctestdeviceModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc测试设备表') class Meta: db_table = 'pctest_job_device' verbose_name = u'pc岗位设备关联表' verbose_name_plural = verbose_name ordering = ('id',) class PctestModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') device = models.ForeignKey(PctestdeviceModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc测试设备表') function = models.ForeignKey(PctestfunctionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc设备职能表') class Meta: db_table = 'pctest_device_function' verbose_name = u'pc岗位设备关联表' verbose_name_plural = verbose_name ordering = ('id',) class P2PIpModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, default='', unique=True, db_index=True, verbose_name='设备uid') ip = models.CharField(default='', max_length=32, verbose_name='ip') p2p_request_times = models.IntegerField(default=0, verbose_name='p2p请求次数') relay_request_times = models.IntegerField(default=0, verbose_name='relay请求次数') continent_name = models.CharField(default='', max_length=10, verbose_name='大洲') country_name = models.CharField(default='', max_length=100, verbose_name='国家') region_name = models.CharField(default='', max_length=100, verbose_name='地区') city_name = models.CharField(default='', max_length=100, verbose_name='城市') add_time = models.IntegerField(default=0, verbose_name='添加时间') update_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'p2p_ip' verbose_name = u'设备p2p_ip地区表' verbose_name_plural = verbose_name class DeviceDomainModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, default='', unique=True, db_index=True, verbose_name='uid') serial_number = models.CharField(max_length=9, default='', unique=True, db_index=True, verbose_name='序列号') ip = models.CharField(default='', max_length=32, verbose_name='ip') country_name = models.CharField(max_length=20, default='', verbose_name='国家名') api = models.CharField(max_length=50, default='', verbose_name='使用的域名') add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间') update_time = models.DateTimeField(blank=True, auto_now=True, verbose_name=u'更新时间') class Meta: db_table = 'device_domain' verbose_name = u'设备域名表' verbose_name_plural = verbose_name class RequestRecordModel(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增ID') method = models.CharField(max_length=10, default='', verbose_name='请求类型') url = models.CharField(max_length=200, default='', verbose_name='请求路径') parameter = models.CharField(max_length=200, default='', verbose_name='请求参数') execute_time = models.FloatField(default=0, verbose_name='执行时间') status_code = models.CharField(max_length=10, default='', verbose_name='响应状态码') reason_phrase = models.CharField(max_length=200, default='', verbose_name='错误信息') add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间') class Meta: db_table = 'request_record' verbose_name = u'请求记录表' verbose_name_plural = verbose_name ordering = ('-add_time',) class AiService(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True) channel = models.SmallIntegerField(default=0, verbose_name='通道') orders = models.ForeignKey(Order_Model, to_field='orderID', default='', on_delete=models.CASCADE, verbose_name='关联订单表') detect_status = models.SmallIntegerField(default=0, verbose_name='状态[0:开启,1:关闭]') endTime = models.BigIntegerField(verbose_name='套餐结束时间', db_index=True, default=0) addTime = models.IntegerField(verbose_name='添加时间', default=0) updTime = models.BigIntegerField(verbose_name='更新时间', default=0) use_status = models.IntegerField(verbose_name='使用状态[0:未使用,1:使用中,2已过期]', default=0) detect_group = models.CharField(blank=True, default='1', max_length=100, verbose_name='侦测类型[1=人;2=动物;3=车]') detect_interval = models.IntegerField(verbose_name='推送间隔', default=60) # 秒 class Meta: db_table = 'ai_service' verbose_name = 'ai设备服务表' verbose_name_plural = verbose_name ordering = ('id',) class AiProcessTime(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') msg_id = models.CharField(max_length=50, verbose_name='消息id', default=0) detectTime = models.BigIntegerField(verbose_name='设备侦测时间', default=0) receiveTime = models.BigIntegerField(verbose_name='接口调用时间', default=0) aiTime = models.BigIntegerField(verbose_name='ai识别上传开始时间', default=0) aiEndTime = models.BigIntegerField(verbose_name='ai识别结束时间', default=0) pushTime = models.BigIntegerField(verbose_name='推送开始时间', default=0) pushEndTime = models.BigIntegerField(verbose_name='推送结束时间', default=0) picUploadTime = models.BigIntegerField(verbose_name='图片上传开始时间', default=0) picUploadEndTime = models.BigIntegerField(verbose_name='图片上传结束结束时间', default=0) serverCountTime = models.BigIntegerField(verbose_name='服务器总花时间', default=0) appPushTime = models.IntegerField(verbose_name='添加时间', default=0) endTime = models.IntegerField(verbose_name='接口结束时间', default=0) class Meta: db_table = 'ai_process_time' verbose_name = 'ai设备服务表' verbose_name_plural = verbose_name ordering = ('id',) class GatewaySubDevice(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') device = models.ForeignKey(Device_Info, to_field='id', default='', on_delete=models.CASCADE, verbose_name='关联设备信息id') device_type = models.SmallIntegerField(default=0, verbose_name=u'设备类型') nickname = models.CharField(default='', max_length=32, verbose_name=u'设备名称') ieee_addr = models.CharField(default='', max_length=64, verbose_name=u'长地址') src_addr = models.CharField(default='', max_length=16, verbose_name=u'短地址') status = models.SmallIntegerField(default=0, verbose_name='状态') # 0:关闭, 1:开启 is_tampered = models.SmallIntegerField(default=0, verbose_name='拆动状态') # 0:正常, 1:被拆动 mac = models.CharField(default='', max_length=32, verbose_name=u'mac地址') device_model = models.CharField(default='', max_length=16, verbose_name=u'设备型号') manufacturer = models.CharField(default='', max_length=16, verbose_name=u'制造商') sensor_serial = models.CharField(default='', max_length=32, verbose_name=u'传感器序列号') firmware_version = models.CharField(default='', max_length=32, verbose_name=u'固件版本') hardware_version = models.CharField(default='', max_length=32, verbose_name=u'硬件版本') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'gateway_sub_device' verbose_name = '网关子设备' verbose_name_plural = verbose_name class SensorRecord(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID') gateway_sub_device_id = models.IntegerField(default=0, blank=True, verbose_name=u'网关子设备id') alarm = models.CharField(default='', max_length=32, verbose_name=u'消息内容') event_type = models.SmallIntegerField(default=0, verbose_name=u'消息类型') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'sensor_record' verbose_name = '传感器记录' verbose_name_plural = verbose_name app_label = 'db2' class UnicomCombo(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记Id') package_id = models.CharField(default='', max_length=32, verbose_name=u'联通套餐id') combo_name = models.CharField(default='', max_length=32, verbose_name=u'套餐名称') status = models.SmallIntegerField(default=0, verbose_name='状态{0:开启,1:停用}') # 套餐类型 0：商用，1：初始化赠送 combo_type = models.SmallIntegerField(default=0, verbose_name='套餐类型') flow_total = models.IntegerField(default=0, blank=True, verbose_name=u'流量总量值 单位(MB)') expiration_days = models.IntegerField(default=0, blank=True, verbose_name=u'有效期天数') expiration_type = models.SmallIntegerField(default=0, verbose_name=u'有效期类型,0=天，1=月，2=年') pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='unicom_combo_pay_type') is_unlimited = models.SmallIntegerField(default=0, verbose_name=u'是否无限流量,，0：有限流量，1：无限流量') price = models.CharField(blank=True, max_length=32, verbose_name=u'价格') sort = models.IntegerField(default=0, blank=True, verbose_name=u'排序，越小越靠前') remark = models.TextField(blank=True, default='', verbose_name=u'描述信息') updated_time = models.IntegerField(default=0, verbose_name='更新时间') created_time = models.IntegerField(default=0, verbose_name='创建时间') is_show = models.SmallIntegerField(default=1, verbose_name=u'是否显示,0：不显示，1：显示') is_del = models.BooleanField(blank=True, default=False, verbose_name=u'是否删除默认false') class Meta: db_table = 'unicom_combo' verbose_name = '联通套餐表' verbose_name_plural = verbose_name class UnicomComboOrderInfo(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记Id') iccid = models.CharField(default='', max_length=32, verbose_name=u'完整的20位纯数字ICCID') renew_list_id = models.CharField(blank=True, default='', max_length=32, verbose_name=u'联通订购成功套餐队列id') status = models.SmallIntegerField(default=0, verbose_name='状态{0:未使用,1:已使用,2:已过期}') order_id = models.CharField(blank=True, default='', max_length=32, verbose_name=u'关联订单表') combo = models.ForeignKey(UnicomCombo, to_field='id', default='', on_delete=models.CASCADE, verbose_name=u'联通套餐表') year = models.IntegerField(default=0, verbose_name='使用年') month = models.IntegerField(default=0, verbose_name='使用月') flow_total_usage = models.CharField(blank=True, default='', max_length=32, verbose_name=u'激活时当月已用流量') flow_exceed = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'当前套餐已超流量值MB') last_combo_flow_exceed = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'上一个流量套餐流量已超值(MB)') is_flow_exceed = models.IntegerField(default=0, verbose_name=u'当前套餐是否已超流量，0：正常结算，1：已超需计入下一个流量套餐') sort = models.IntegerField(default=99, blank=True, verbose_name=u'排序') next_month_activate = models.BooleanField(blank=True, default=False, verbose_name=u'下月激活') activation_time = models.IntegerField(default=0, verbose_name='激活时间') expire_time = models.IntegerField(default=0, verbose_name='过期时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') created_time = models.IntegerField(default=0, verbose_name='创建时间') is_del = models.BooleanField(blank=True, default=False, verbose_name=u'是否删除') class Meta: db_table = 'unicom_combo_order_info' verbose_name = '联通套餐订单信息表' verbose_name_plural = verbose_name class UnicomDeviceInfo(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记Id') iccid = models.CharField(db_index=True, unique=True, max_length=32, verbose_name=u'完整的20位纯数字ICCID') status = models.SmallIntegerField(default=0, verbose_name=u'状态{0:可测试,1:测试完成,2:已使用}') serial_no = models.CharField(default='', max_length=32, verbose_name=u'设备序列号') user_id = models.CharField(blank=True, max_length=32, verbose_name=u'用户id') card_type = models.SmallIntegerField(default=0, verbose_name=u'状态{0:联通,1:电信,2:移动}') main_card = models.SmallIntegerField(default=0, verbose_name=u'状态{0:主卡,1:拔插卡}') updated_time = models.IntegerField(default=0, verbose_name='更新时间') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'unicom_device_info' verbose_name = '联通设备信息' verbose_name_plural = verbose_name class UnicomFlowPush(models.Model): id = models.AutoField(primary_key=True) user_id = models.CharField(default='', max_length=32, verbose_name=u'用户id') # 0: 剩余10%流量预警, 1: 流量到期 type = models.SmallIntegerField(default=0, verbose_name='流量推送类型') combo_order_id = models.CharField(max_length=32, default='', verbose_name='当前订单套餐id') serial_no = models.CharField(max_length=32, default='', verbose_name='序列号') flow_total_usage = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'当月实际流量用量 单位(MB)') flow_total = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'流量总量 单位(MB)') status = models.SmallIntegerField(default=0, verbose_name=u'状态{0:待推送,1:已推送}') updated_time = models.IntegerField(default=0, verbose_name='更新时间') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'unicom_flow_push' verbose_name = '联通流量用量推送' verbose_name_plural = verbose_name app_label = 'db2' class SceneLog(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增标记ID') scene_name = models.CharField(default='', max_length=100, verbose_name='场景名称') scene_id = models.IntegerField(default=0, verbose_name='关联场景id') device_id = models.CharField(default='', max_length=32, verbose_name='关联网关id') sub_device_id = models.IntegerField(default=0, verbose_name='关联子设备id') tasks = models.TextField(default='', verbose_name=u'任务') status = models.SmallIntegerField(default=0, verbose_name='场景状态') created_time = models.IntegerField(default=0, verbose_name='场景触发时间') class Meta: db_table = 'scene_log' verbose_name = '场景日志' verbose_name_plural = verbose_name app_label = 'db2' class SmartScene(models.Model): id = models.AutoField(primary_key=True, verbose_name=u'自增标记id') user = models.ForeignKey(Device_User, to_field='userID', default='', on_delete=models.CASCADE, verbose_name='关联用户表id') device_id = models.CharField(default='', max_length=32, verbose_name=u'关联设备信息id') sub_device_id = models.IntegerField(default=0, verbose_name=u'关联子设备表id') scene_name = models.CharField(default='', max_length=100, verbose_name=u'场景名称') conditions = models.TextField(default='', verbose_name=u'条件') tasks = models.TextField(default='', verbose_name=u'任务') is_all_day = models.SmallIntegerField(default=0, verbose_name=u'是否全天') # 0: 不设置时间, 1: 全天, 2: 非全天 effective_time_id = models.IntegerField(default=0, verbose_name=u'关联场景执行时间id') is_enable = models.BooleanField(default=True, verbose_name=u'是否开启') device_data = models.TextField(default='', verbose_name=u'设备场景数据') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'smart_scene' verbose_name = '智能场景' verbose_name_plural = verbose_name class DeviceChannelUserSet(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') uid = models.CharField(blank=True, db_index=True, max_length=32, verbose_name=u'设备UID') channels = models.CharField(default='', blank=True, max_length=128, verbose_name=u'用户通道多个逗号隔开') user_id = models.CharField(default='', db_index=True, max_length=32, verbose_name=u'用户id') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'device_channel_user_set' verbose_name = '设备通道用户设置' verbose_name_plural = verbose_name class DeviceSharePermission(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') code = models.CharField(blank=True, db_index=True, max_length=32, verbose_name=u'权限编码') sort = models.IntegerField(default=99, blank=True, verbose_name=u'排序，越小越靠前') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'device_share_permission' verbose_name = '设备分享权限' verbose_name_plural = verbose_name class DevicePermissionLang(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') permission_id = models.IntegerField(default=0, verbose_name=u'关联设备权限ID') name = models.CharField(default='', max_length=50, verbose_name=u'权限名称') desc = models.CharField(blank=True, max_length=64, default='', verbose_name=u'描述') lang = models.CharField(default='', max_length=20, db_index=True, verbose_name='例如：cn') sort = models.IntegerField(default=99, blank=True, verbose_name=u'排序，越小越靠前') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'device_permission_lang' verbose_name = '设备分享权限语言描述' verbose_name_plural = verbose_name class DeviceChannelUserPermission(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') permission_id = models.IntegerField(default=0, verbose_name=u'关联设备权限ID') channel_user_id = models.IntegerField(default=0, verbose_name=u'通道用户id') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'device_channel_user_permission' verbose_name = '设备分享权限关联通道用户' verbose_name_plural = verbose_name class DeviceTypeSharePermission(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') permission_id = models.IntegerField(default=0, verbose_name=u'关联设备权限ID') type = models.SmallIntegerField(default=0, verbose_name='设备类型') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'device_type_share_permission' verbose_name = '设备类型关联分享权限' verbose_name_plural = verbose_name class VodHlsTag(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') uid = models.CharField(blank=True, db_index=True, max_length=32, verbose_name=u'设备UID') vod_hls_id = models.IntegerField(default=0, db_index=True, verbose_name='云存hlsId') tab_num = models.SmallIntegerField(default=0, verbose_name='所在表编号') ai_event_time = models.IntegerField(default=0, db_index=True, verbose_name='ai事件事件') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'vod_hls_tag' verbose_name = '云存hls标签' verbose_name_plural = verbose_name class VodHlsTagType(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') tag_id = models.IntegerField(default=0, db_index=True, verbose_name='云存关联AI标签ID') type = models.SmallIntegerField(default=0, db_index=True, verbose_name='标签类型') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'vod_hls_tag_type' verbose_name = '云存hls关联标签类型' verbose_name_plural = verbose_name class SocketInfo(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增id') device_id = models.CharField(max_length=32, default='', verbose_name='设备id') serial_number = models.CharField(db_index=True, max_length=20, verbose_name='序列号') online = models.BooleanField(default=False, verbose_name='在线状态False：不在线，True：在线') type_switch = models.SmallIntegerField(default=0, verbose_name='开关类型 0：总开关，1：倒计时开关') status = models.BooleanField(default=False, verbose_name='开关状态 0：关闭，1：开启') count_down_time = models.IntegerField(default=0, verbose_name='倒计时时间戳') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 's_socket_info' verbose_name = '插座信息' verbose_name_plural = verbose_name class CustomizedPush(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') title = models.CharField(default='', max_length=64, verbose_name='标题') msg = models.TextField(default='', verbose_name='内容') link = models.TextField(default='', verbose_name='链接') icon_link = models.TextField(default='', verbose_name='预览图链接') country = models.CharField(default='', max_length=32, verbose_name='国家') # 多选型号用,分开 device_type = models.TextField(default='', verbose_name='设备类型') register_period = models.CharField(default='', max_length=32, verbose_name='注册年限') time_zone = models.CharField(default='', max_length=8, verbose_name='时区') push_time = models.CharField(default='', max_length=32, verbose_name='推送时间') push_timestamp = models.IntegerField(default=0, verbose_name='推送时间戳') push_app = models.CharField(default='', max_length=64, verbose_name='推送APP') # False:待推送, True:已推送 push_satus = models.BooleanField(default=False, verbose_name='推送状态') class Meta: db_table = 'customized_push' verbose_name = '定制化推送' class UserAudioVideoPush(models.Model): id = models.AutoField(primary_key=True, verbose_name='主键') uid = models.CharField(default='', max_length=32, verbose_name='设备UID') buttonUser1 = models.CharField(default='', max_length=32, verbose_name='用户按钮1') buttonUser2 = models.CharField(default='', max_length=32, verbose_name='用户按钮2') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'user_audio_video_push' verbose_name = '用户音视频推送表' class PushLog(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增标记ID') uid = models.CharField(max_length=32, default='', db_index=True, verbose_name='设备UID') event_type = models.CharField(default='', max_length=100, verbose_name='事件类型') push_type = models.SmallIntegerField(default=0, verbose_name='推送类型') push_result = models.BooleanField(default=False, verbose_name='推送结果') content = models.TextField(default='', verbose_name='推送字段值') created_time = models.IntegerField(default=0, verbose_name='触发时间') class Meta: db_table = 'push_log' verbose_name = '推送日志' app_label = 'db2' class DeviceDailyReport(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增标记ID') device_id = models.CharField(default='', max_length=32, verbose_name='设备ID') type = models.SmallIntegerField(default=0, verbose_name=u'统计类型0:默认1:电耗统计') battery_level = models.IntegerField(default=0, verbose_name='23:59电量百分比') report_date = models.DateTimeField(blank=True, null=True, verbose_name=u'统计日期时间') report_time = models.IntegerField(default=0, verbose_name='设备上报时间戳') human_detection = models.IntegerField(default=0, verbose_name='人形检测次数') working_hours = models.IntegerField(default=0, verbose_name='工作时长/秒') wake_sleep = models.IntegerField(default=0, verbose_name='唤醒休眠次数') pir_wakeup_count = models.IntegerField(default=0, verbose_name='PIR唤醒次数') mqtt_wakeup_count = models.IntegerField(default=0, verbose_name='mqtt唤醒次数') channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道') created_time = models.IntegerField(default=0, verbose_name='创建时间') updated_time = models.IntegerField(default=0, verbose_name='更新时间') class Meta: db_table = 'device_daily_report' verbose_name = '设备日报记录表' verbose_name_plural = verbose_name app_label = 'db2' class AbnormalEvent(models.Model): id = models.AutoField(primary_key=True, verbose_name='自增标记ID') uid = models.CharField(default='', max_length=20, verbose_name='uid') device_type = models.IntegerField(default=0, verbose_name='设备类型') version = models.CharField(default='', max_length=64, verbose_name='设备版本') event_code = models.CharField(default='', max_length=16, verbose_name='异常事件编码') content = models.TextField(default='', verbose_name='异常内容') # 上报类型, 0: 自动上报, 1: 手动上报 report_type = models.IntegerField(default=0, verbose_name='上报类型') event_time = models.IntegerField(default=0, verbose_name='异常事件触发时间') created_time = models.IntegerField(default=0, verbose_name='创建时间') class Meta: db_table = 'abnormal_event' verbose_name = '异常事件' app_label = 'db2'