cnr-ibba / IMAGE-InjectTool

        db_table = 'vessels'

class VesselsStorage(BaseMixin, models.Model):

    vessels_storage_id = models.IntegerField(blank=True, null=True)

    db_vessel = models.IntegerField(blank=True, null=True)

    storage_id = models.IntegerField(blank=True, null=True)

    no_units = models.SmallIntegerField(blank=True, null=True)

    db_status = models.IntegerField(blank=True, null=True)

    comment = models.TextField(blank=True, null=True)

    chk_lvl = models.SmallIntegerField(blank=True, null=True)

    dirty = models.NullBooleanField()

    guid = models.BigIntegerField(primary_key=True)

    last_change_dt = models.DateTimeField(blank=True, null=True)

    last_change_user = models.TextField(blank=True, null=True)

    owner = models.TextField(blank=True, null=True)

    synch = models.NullBooleanField()

    version = models.SmallIntegerField(blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'vessels_storage'

        unique_together = (('db_vessel', 'storage_id', 'db_status'),)

# --- Useful Views

        db_table = 'sources'

class StatusChanges(BaseMixin, models.Model):

    status_change_id = models.IntegerField(blank=True, null=True)

    vessels_storage_id = models.IntegerField(blank=True, null=True)

    old_status = models.IntegerField(blank=True, null=True)

    new_status = models.IntegerField(blank=True, null=True)

    action_dt = models.DateTimeField(blank=True, null=True)

    comment = models.TextField(blank=True, null=True)

    chk_lvl = models.SmallIntegerField(blank=True, null=True)

    dirty = models.NullBooleanField()

    guid = models.BigIntegerField(primary_key=True)

    last_change_dt = models.DateTimeField(blank=True, null=True)

    last_change_user = models.TextField(blank=True, null=True)

    owner = models.TextField(blank=True, null=True)

    synch = models.NullBooleanField()

    version = models.SmallIntegerField(blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'status_changes'

class Storage(BaseMixin, models.Model):