bigdataAPI/apps/Equipment/models.py

from django.db import models
from apps.UserApp.models import MyUser
# Create your models here.

class Device(models.Model):
    TYPE_CHOICES = {
        1: '气象站',
    }
    device_id = models.CharField(u'设备id', max_length=30, primary_key=True)
    owner = models.ForeignKey(
        MyUser, blank=True, null=True, on_delete = models.DO_NOTHING, verbose_name=u'设备所属用户')
    device_type = models.SmallIntegerField(u'设备类型', default=1, choices=TYPE_CHOICES.items())
    lng = models.CharField(u'经度', max_length=10, default="")
    lat = models.CharField(u'纬度', max_length=10, default="")
    iccid = models.CharField(u'设备卡号', max_length=20, default="")
    volt = models.CharField(u'电压', max_length=10, default="")
    rssi = models.CharField(u'信号强度', max_length=10, default="")
    version = models.CharField(u'设备版本号', max_length=50, default="")
    is_online = models.SmallIntegerField(u'是否在线', default=1)
    upl_time = models.IntegerField(default=0)
    class Meta:
        db_table = "device"
        verbose_name = u'设备列表'
        verbose_name_plural = verbose_name


class QXZData(models.Model):
    device_id = models.ForeignKey(Device, on_delete = models.CASCADE)
    device_data = models.TextField()
    add_time = models.IntegerField(default=0)

    class Meta:
        db_table = "qxz_data"
        verbose_name = u'气象站数据'
        verbose_name_plural = verbose_name