gistfile1.py

class BaseModel(Model):
    class Meta:
        database = psql_db

# There can be a lot of Alerts that come in. 
# Each Alert can "have" many users
class Alert(BaseModel):
    alertId = CharField(unique = True, primary_key = True)
    alertLink = Charfield(unique = True)
    startTime = TimeField()
    endTime = TimeField(null = True)
    alertType = CharField(null = True)
    jcaLink = CharField()
    links = CharField(null = True)
    event = ForeignKeyField(Event, related_name = 'alerts')

    class Meta:
        order_by = ('eventId',)

# Basic Person/User
class Person(BaseModel):
    name = CharField(unique = True,)
    link = CharField(unique = True)

# Associates Person with Alert, I guess?
class PersonAlertAssoc(BaseModel):
    person = ForeignKey(Person, related_name = 'person')
    alert = ForeignKey(Alert, related_name = 'alert')

# Each Event can "have" many Alerts and a description/assessment
class Event(BaseModel):
    assessment = CharField()