from django.db import models

# Create your models here.

class RT_edu(models.Model):
    city = models.CharField(max_length=7)
    cntr = models.CharField(max_length=7)
    edu_name = models.CharField(max_length=50)
    edu_center = models.CharField(max_length=30)
    edu_start = models.DateField()
    edu_end = models.DateField()
    edu_time = models.IntegerField()
    edu_infocall = models.CharField(max_length=30)

class Maps(models.Model):
    mapdata = models.TextField()

class RT_agri_policy(models.Model):
    city = models.CharField(max_length=7)
    cntr = models.CharField(max_length=7)
    plcy_name = models.CharField(max_length=50)
    plcy_condition = models.TextField()
    plcy_content = models.TextField(null=True)
    plcy_condition_detail = models.TextField(null=True)
    plcy_document = models.TextField(null=True)
    plcy_amount = models.TextField(null=True)
    plcy_contact = models.TextField(null=True)

class AuctionData(models.Model):
    raw_num = models.IntegerField()
    aucng_de = models.IntegerField()
    pblmng_whsal_mrkt_nm = models.CharField(max_length=16)
    pblmng_whsal_mrkt_cd = models.CharField(max_length=16)
    cpr_nm = models.CharField(max_length=16)
    cpr_cd = models.CharField(max_length=16)
    prdlst_nm = models.CharField(max_length=16)
    prdlst_cd = models.CharField(max_length=16)
    spcies_nm = models.CharField(max_length=16)
    spcies_cd = models.CharField(max_length=16)
    delngbundle_qy = models.FloatField()
    stndrd = models.CharField(max_length=20)
    stndrd_cd = models.CharField(max_length=16)
    grad = models.CharField(max_length=16)
    grad_cd = models.CharField(max_length=16)
    sanji_cd = models.CharField(max_length=16, null=True)
    sanji_nm = models.CharField(max_length=20, null=True)
    mumm_amt = models.IntegerField()
    avrg_amt = models.IntegerField()
    mxmm_amt = models.IntegerField()
    delng_qy = models.IntegerField()
    cnts = models.IntegerField()

class ProductData(models.Model):
    large_cd = models.CharField(max_length=10)
    large_nm = models.CharField(max_length=10)
    medium_cd = models.CharField(max_length=10)
    medium_nm = models.CharField(max_length=16)
    small_cd = models.CharField(max_length=10)
    small_nm = models.CharField(max_length=22)

class JointMarketData(models.Model):
    raw_num = models.IntegerField()
    aucng_de = models.IntegerField()