[kenneth@localhost info]$ cat models.py
from django.db import models
from snow.info.models import User
# Create your models here.

#Resort related

class Country(models.Model):
        name = models.CharField(maxlength=100)

class Resort(models.Model):
        country = models.ForeignKey(Country)
        name = models.CharField(maxlength=200)
        utm = models.IntegerField()

class Lift(models.Model):
        resort = models.ForeignKey(Resort)
        name = models.CharField(maxlength=200)

class Run(models.Model):
        resort = models.ForeignKey(Resort)
        name = models.CharField(maxlength=200)

class Depth(models.Model):
        resort = models.ForeignKey(Resort)
        depth = models.IntegerField()
        time = models.IntegerField()
        LOCATION_CHOICES = (
                ('T', 'Top'),
                ('B', 'Bottom'),
        )
        location = models.CharField(maxlength=1, choices=LOCATION_CHOICES)

#metadata

class Review(models.Model):
        date = models.DateField()
        #user = models.ForeignKey(User)
        resort = models.ForeignKey(Resort)
        #various textfields or user inputs, define later

class Rating(models.Model):
        review = models.ForeignKey(Review)
        TYPE = (
                ('B', 'Snowboarding'),
                ('P', 'Park'),
                ('W', 'Powder'),
                ('S', 'Skiing'),
                ('T', 'Telemark'),
                ('C', 'Children'),
                ('I', 'Pipe'),
        )
        type = models.CharField(maxlength=1, choices=TYPE)
        num_stars = models.IntegerField()