from django.db import models


class District(models.Model):

    id = models.AutoField("ID", primary_key=True)
    city_id = models.CharField("城市ID", max_length=64, blank=True, null=True)
    city = models.CharField("城市", max_length=64, blank=True, null=True)
    pid = models.CharField("PID",max_length=64,  blank=True, null=True)

    class Meta:
        db_table = "district"


class DayData(models.Model):

    id = models.AutoField("ID", primary_key=True)
    cityid = models.CharField("城市ID", max_length=64, blank=True, null=True)
    province = models.CharField("省", max_length=64, blank=True, null=True)
    city = models.CharField("市", max_length=64, blank=True, null=True)
    district = models.CharField("区", max_length=64, blank=True, null=True)
    content = models.TextField("天气")
    class Meta:
        db_table = "day_data"

class ServerDayData(models.Model):

    id = models.AutoField("ID", primary_key=True)
    cityid = models.CharField("城市ID", max_length=64, blank=True, null=True)
    province = models.CharField("省", max_length=64, blank=True, null=True)
    city = models.CharField("市", max_length=64, blank=True, null=True)
    district = models.CharField("区", max_length=64, blank=True, null=True)
    content = models.TextField("天气")

    class Meta:
        db_table = "server_day_data"


class AddressInfo(models.Model):

    id = models.AutoField("ID", primary_key=True)
    cityid = models.CharField("城市ID", max_length=64, blank=True, null=True)
    province = models.CharField("省", max_length=64, blank=True, null=True)
    city = models.CharField("市", max_length=64, blank=True, null=True)
    district = models.CharField("区", max_length=64, blank=True, null=True)

    class Meta:
        db_table = "address_info"


class HistoryData(models.Model):
    id = models.AutoField("ID", primary_key=True)
    timestamp = models.PositiveIntegerField("时间戳", default=0)
    cityid = models.PositiveIntegerField("地址ID", default=0)
    content = models.TextField("天气")

    class Meta:
        db_table = "history_data"


class HistoryDayData(models.Model):

    id = models.AutoField("ID", primary_key=True)
    cityid = models.CharField("城市ID", max_length=64, blank=True, null=True)
    content = models.TextField("天气")
    addtime = models.PositiveIntegerField("时间", default=0)
    class Meta:
        db_table = "history_today"