Distribuzione FUSS » octomon

# 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'