from django.db import models

class HeNanAddr(models.Model):
    province = models.CharField(max_length=100, blank=True, null=True)
    city = models.CharField(max_length=100, blank=True, null=True)
    district = models.CharField(max_length=100, blank=True, null=True)
    code = models.CharField(max_length=100, blank=True, null=True)

    class Meta:
        db_table = 'he_nan_addr'

class CbdAddrPest(models.Model):
    pest = models.CharField(max_length=100, blank=True, null=True)
    pest_id = models.CharField(max_length=10, blank=True, null=True, default="0")
    count = models.PositiveIntegerField(default=0)
    date = models.PositiveIntegerField(default=0)
    format_date = models.CharField(max_length=100, blank=True, null=True)
    province = models.CharField(max_length=100, blank=True, null=True)
    city = models.CharField(max_length=100, blank=True, null=True)
    district = models.CharField(max_length=100, blank=True, null=True)
    addr_code = models.CharField(max_length=100, blank=True, null=True)

    class Meta:
        db_table = 'cbd_addr_pest'