# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#     * Rearrange models' order
#     * Make sure each model has one field with primary_key=True
# Feel free to rename the models, but don't rename db_table values or field names.
#
# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'
# into your database.

from django.db import models

class Activity(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    user_id = models.IntegerField(null=True, blank=True)
    description = models.CharField(max_length=6000)
    timestamp = models.DateTimeField(null=True, blank=True)
    end_timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'activity'

class AlarmDefinition(models.Model):
    id = models.IntegerField(primary_key=True)
    user_id = models.IntegerField()
    description = models.CharField(max_length=600)
    code = models.CharField(max_length=6000)
    active = models.IntegerField()
    local = models.IntegerField()
    class Meta:
        db_table = u'alarm_definition'

class AlarmDefinitionRun(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField(unique=True)
    definition_id = models.IntegerField()
    school_timestamp = models.FloatField(null=True, blank=True)
    class Meta:
        db_table = u'alarm_definition_run'

class Alarms(models.Model):
    id = models.IntegerField(primary_key=True)
    host_id = models.IntegerField()
    definition_id = models.IntegerField(null=True, blank=True)
    description = models.CharField(max_length=600)
    timestamp = models.DateTimeField(null=True, blank=True)
    ack = models.IntegerField(null=True, blank=True)
    ack_by_id = models.IntegerField(null=True, blank=True)
    ack_when = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'alarms'

class Area(models.Model):
    id = models.IntegerField(primary_key=True)
    code = models.CharField(max_length=150, blank=True)
    name = models.CharField(max_length=450, blank=True)
    class Meta:
        db_table = u'area'

class Components(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=600, blank=True)
    value = models.CharField(max_length=600, blank=True)
    host_id = models.IntegerField(null=True, blank=True)
    timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'components'

class Computer(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    hostname = models.CharField(max_length=600, blank=True)
    serial_number = models.CharField(max_length=600, blank=True)
    video_serial_number = models.CharField(max_length=600, blank=True)
    location = models.CharField(max_length=600, blank=True)
    warranty_expire = models.DateField(null=True, blank=True)
    dismissed = models.IntegerField(null=True, blank=True)
    class Meta:
        db_table = u'computer'

class GroupPermission(models.Model):
    group_id = models.IntegerField()
    permission_id = models.IntegerField()
    class Meta:
        db_table = u'group_permission'

class HostScrapBook(models.Model):
    id = models.IntegerField(primary_key=True)
    host_id = models.IntegerField()
    user_id = models.IntegerField(null=True, blank=True)
    content = models.CharField(max_length=6000)
    timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'host_scrap_book'

class OtherHardware(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    kind_id = models.IntegerField(null=True, blank=True)
    vendor = models.CharField(max_length=600, blank=True)
    model = models.CharField(max_length=600, blank=True)
    serial_number = models.CharField(max_length=600, blank=True)
    warranty_expire = models.DateField(null=True, blank=True)
    location = models.CharField(max_length=600, blank=True)
    dismissed = models.IntegerField(null=True, blank=True)
    class Meta:
        db_table = u'other_hardware'

class OtherHardwareKind(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=600, blank=True)
    description = models.CharField(max_length=600, blank=True)
    class Meta:
        db_table = u'other_hardware_kind'

class Permission(models.Model):
    id = models.IntegerField(primary_key=True)
    permission_name = models.CharField(max_length=48, unique=True)
    description = models.CharField(max_length=765, blank=True)
    class Meta:
        db_table = u'permission'

class School(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=600, blank=True)
    area_id = models.IntegerField(null=True, blank=True)
    address = models.CharField(max_length=900, blank=True)
    phone_number = models.CharField(max_length=600, blank=True)
    email_address = models.CharField(max_length=600, blank=True)
    lat = models.FloatField(null=True, blank=True)
    lon = models.FloatField(null=True, blank=True)
    last_timestamp = models.FloatField(null=True, blank=True)
    class Meta:
        db_table = u'school'

class SchoolKey(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    fingerprint = models.CharField(max_length=600, unique=True)
    crypto_key = models.TextField(blank=True)
    class Meta:
        db_table = u'school_key'

class SchoolKeyUsage(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    key_id = models.IntegerField(null=True, blank=True)
    timestamp = models.DateTimeField(null=True, blank=True)
    first_data_timestamp = models.FloatField(null=True, blank=True)
    last_data_timestamp = models.FloatField(null=True, blank=True)
    class Meta:
        db_table = u'school_key_usage'

class SchoolProps(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    propname = models.CharField(max_length=600)
    propvalue = models.CharField(max_length=600)
    class Meta:
        db_table = u'school_props'

class SchoolTgUser(models.Model):
    school_id = models.IntegerField()
    tg_user_id = models.IntegerField()
    class Meta:
        db_table = u'school_tg_user'

class ScrapBook(models.Model):
    id = models.IntegerField(primary_key=True)
    school_id = models.IntegerField()
    user_id = models.IntegerField(null=True, blank=True)
    content = models.CharField(max_length=6000)
    timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'scrap_book'

class TgGroup(models.Model):
    id = models.IntegerField(primary_key=True)
    group_name = models.CharField(max_length=48, unique=True)
    display_name = models.CharField(max_length=765, blank=True)
    created = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'tg_group'

class TgUser(models.Model):
    id = models.IntegerField(primary_key=True)
    user_name = models.CharField(max_length=48, unique=True)
    email_address = models.CharField(max_length=765, unique=True)
    display_name = models.CharField(max_length=765, blank=True)
    password = models.CharField(max_length=120, blank=True)
    created = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'tg_user'

class Ticket(models.Model):
    id = models.IntegerField(primary_key=True)
    opened = models.DateTimeField(null=True, blank=True)
    opened_by_id = models.IntegerField(null=True, blank=True)
    ticket_for = models.CharField(max_length=600, blank=True)
    object_id = models.IntegerField(null=True, blank=True)
    description = models.CharField(max_length=6000, blank=True)
    closed = models.DateTimeField(null=True, blank=True)
    closed_by = models.IntegerField(null=True, blank=True)
    class Meta:
        db_table = u'ticket'

class TicketNote(models.Model):
    id = models.IntegerField(primary_key=True)
    ticket_id = models.IntegerField(null=True, blank=True)
    user_id = models.IntegerField(null=True, blank=True)
    timestamp = models.DateTimeField(null=True, blank=True)
    content = models.CharField(max_length=6000, blank=True)
    class Meta:
        db_table = u'ticket_note'

class Used(models.Model):
    id = models.IntegerField(primary_key=True)
    host_id = models.IntegerField()
    timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'used'

class UsedNotGood(models.Model):
    id = models.IntegerField(primary_key=True)
    host_id = models.IntegerField()
    timestamp = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'used_not_good'

class UserGroup(models.Model):
    group_id = models.IntegerField()
    user_id = models.IntegerField()
    class Meta:
        db_table = u'user_group'

class Visit(models.Model):
    id = models.IntegerField(primary_key=True)
    visit_key = models.CharField(max_length=120, unique=True)
    created = models.DateTimeField(null=True, blank=True)
    expiry = models.DateTimeField(null=True, blank=True)
    class Meta:
        db_table = u'visit'

class VisitIdentity(models.Model):
    id = models.IntegerField(primary_key=True)
    visit_key = models.CharField(max_length=120, unique=True)
    user_id = models.IntegerField(null=True, blank=True)
    class Meta:
        db_table = u'visit_identity'