from django.db import models

# Create your models here

class huc10(models.Model): 
    huc10 = models.IntegerField()
    huc10_name = models.CharField(maxlength=20)  
    county = models.CharField(maxlength=20) 

class lakes(models.Model): 
    midas = models.IntegerField()
    name = models.CharField(maxlength=20) 
    type = models.CharField(maxlength=20)
    huc_6 = models.IntegerField()
    huc_8 = models.IntegerField()
    huc_8_name = models.CharField(maxlength=20)
    huc_10 =  models.IntegerField()
    huc_12 = models.IntegerField()
    huc_12_name =  models.CharField(maxlength=100)
    geocode = models.CharField(maxlength=100)
    town  = models.CharField(maxlength=100)

class posts(models.Model): 
    title = models.CharField(maxlength=50)  
    content =  models.CharField(maxlength=10000)  
    lake = models.ForeignKey(lakes) 
    huc10 = models.ForeignKey(huc10) 
    CATEGORY_CHOICES = ( 
        ('g', 'general'),   
        ('l', 'land'), 
        ('w', 'water'), 
        ('a', 'animal'), 
        ('p', 'plant'),
        ) 
    category = models.CharField(maxlength=20, choices=CATEGORY_CHOICES) 
    TYPE_CHOICES = ( 
        ('g', 'general informaion') 
        ('q', 'question') 
        ('a', 'answer') 
      ) 
    type = models.CharField(maxlength=20, chocies=TYPE_CHOCIES) 
    date =  models.DateField()
    user =  models.Manager()