Skip to content

Instantly share code, notes, and snippets.

@gcavalcante8808
Created November 5, 2014 00:32
Show Gist options
  • Save gcavalcante8808/cde70e20d8896a80de0c to your computer and use it in GitHub Desktop.
Save gcavalcante8808/cde70e20d8896a80de0c to your computer and use it in GitHub Desktop.
Autogenerated models.py for Zabbix - Django ORM
# 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
# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# 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 [app_label]'
# into your database.
from __future__ import unicode_literals
from django.db import models
class Acknowledges(models.Model):
acknowledgeid = models.BigIntegerField(primary_key=True)
userid = models.ForeignKey('Users', db_column='userid')
eventid = models.ForeignKey('Events', db_column='eventid')
clock = models.IntegerField()
message = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'acknowledges'
class Actions(models.Model):
actionid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=255)
eventsource = models.IntegerField()
evaltype = models.IntegerField()
status = models.IntegerField()
esc_period = models.IntegerField()
def_shortdata = models.CharField(max_length=255)
def_longdata = models.TextField()
recovery_msg = models.IntegerField()
r_shortdata = models.CharField(max_length=255)
r_longdata = models.TextField()
formula = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'actions'
class Alerts(models.Model):
alertid = models.BigIntegerField(primary_key=True)
actionid = models.ForeignKey(Actions, db_column='actionid')
eventid = models.ForeignKey('Events', db_column='eventid')
userid = models.ForeignKey('Users', db_column='userid', blank=True, null=True)
clock = models.IntegerField()
mediatypeid = models.ForeignKey('MediaType', db_column='mediatypeid', blank=True, null=True)
sendto = models.CharField(max_length=100)
subject = models.CharField(max_length=255)
message = models.TextField()
status = models.IntegerField()
retries = models.IntegerField()
error = models.CharField(max_length=128)
esc_step = models.IntegerField()
alerttype = models.IntegerField()
class Meta:
managed = False
db_table = 'alerts'
class ApplicationTemplate(models.Model):
application_templateid = models.BigIntegerField(primary_key=True)
applicationid = models.ForeignKey('Applications', db_column='applicationid')
templateid = models.ForeignKey('Applications', db_column='templateid')
class Meta:
managed = False
db_table = 'application_template'
class Applications(models.Model):
applicationid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey('Hosts', db_column='hostid')
name = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'applications'
class Auditlog(models.Model):
auditid = models.BigIntegerField(primary_key=True)
userid = models.ForeignKey('Users', db_column='userid')
clock = models.IntegerField()
action = models.IntegerField()
resourcetype = models.IntegerField()
details = models.CharField(max_length=128)
ip = models.CharField(max_length=39)
resourceid = models.BigIntegerField()
resourcename = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'auditlog'
class AuditlogDetails(models.Model):
auditdetailid = models.BigIntegerField(primary_key=True)
auditid = models.ForeignKey(Auditlog, db_column='auditid')
table_name = models.CharField(max_length=64)
field_name = models.CharField(max_length=64)
oldvalue = models.TextField()
newvalue = models.TextField()
class Meta:
managed = False
db_table = 'auditlog_details'
class AutoregHost(models.Model):
autoreg_hostid = models.BigIntegerField(primary_key=True)
proxy_hostid = models.ForeignKey('Hosts', db_column='proxy_hostid', blank=True, null=True)
host = models.CharField(max_length=64)
listen_ip = models.CharField(max_length=39)
listen_port = models.IntegerField()
listen_dns = models.CharField(max_length=64)
host_metadata = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'autoreg_host'
class Conditions(models.Model):
conditionid = models.BigIntegerField(primary_key=True)
actionid = models.ForeignKey(Actions, db_column='actionid')
conditiontype = models.IntegerField()
operator = models.IntegerField()
value = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'conditions'
class Config(models.Model):
configid = models.BigIntegerField(primary_key=True)
refresh_unsupported = models.IntegerField()
work_period = models.CharField(max_length=100)
alert_usrgrpid = models.ForeignKey('Usrgrp', db_column='alert_usrgrpid', blank=True, null=True)
event_ack_enable = models.IntegerField()
event_expire = models.IntegerField()
event_show_max = models.IntegerField()
default_theme = models.CharField(max_length=128)
authentication_type = models.IntegerField()
ldap_host = models.CharField(max_length=255)
ldap_port = models.IntegerField()
ldap_base_dn = models.CharField(max_length=255)
ldap_bind_dn = models.CharField(max_length=255)
ldap_bind_password = models.CharField(max_length=128)
ldap_search_attribute = models.CharField(max_length=128)
dropdown_first_entry = models.IntegerField()
dropdown_first_remember = models.IntegerField()
discovery_groupid = models.ForeignKey('Groups', db_column='discovery_groupid')
max_in_table = models.IntegerField()
search_limit = models.IntegerField()
severity_color_0 = models.CharField(max_length=6)
severity_color_1 = models.CharField(max_length=6)
severity_color_2 = models.CharField(max_length=6)
severity_color_3 = models.CharField(max_length=6)
severity_color_4 = models.CharField(max_length=6)
severity_color_5 = models.CharField(max_length=6)
severity_name_0 = models.CharField(max_length=32)
severity_name_1 = models.CharField(max_length=32)
severity_name_2 = models.CharField(max_length=32)
severity_name_3 = models.CharField(max_length=32)
severity_name_4 = models.CharField(max_length=32)
severity_name_5 = models.CharField(max_length=32)
ok_period = models.IntegerField()
blink_period = models.IntegerField()
problem_unack_color = models.CharField(max_length=6)
problem_ack_color = models.CharField(max_length=6)
ok_unack_color = models.CharField(max_length=6)
ok_ack_color = models.CharField(max_length=6)
problem_unack_style = models.IntegerField()
problem_ack_style = models.IntegerField()
ok_unack_style = models.IntegerField()
ok_ack_style = models.IntegerField()
snmptrap_logging = models.IntegerField()
server_check_interval = models.IntegerField()
hk_events_mode = models.IntegerField()
hk_events_trigger = models.IntegerField()
hk_events_internal = models.IntegerField()
hk_events_discovery = models.IntegerField()
hk_events_autoreg = models.IntegerField()
hk_services_mode = models.IntegerField()
hk_services = models.IntegerField()
hk_audit_mode = models.IntegerField()
hk_audit = models.IntegerField()
hk_sessions_mode = models.IntegerField()
hk_sessions = models.IntegerField()
hk_history_mode = models.IntegerField()
hk_history_global = models.IntegerField()
hk_history = models.IntegerField()
hk_trends_mode = models.IntegerField()
hk_trends_global = models.IntegerField()
hk_trends = models.IntegerField()
class Meta:
managed = False
db_table = 'config'
class Dbversion(models.Model):
mandatory = models.IntegerField()
optional = models.IntegerField()
class Meta:
managed = False
db_table = 'dbversion'
class Dchecks(models.Model):
dcheckid = models.BigIntegerField(primary_key=True)
druleid = models.ForeignKey('Drules', db_column='druleid')
type = models.IntegerField()
key_field = models.CharField(db_column='key_', max_length=255) # Field renamed because it ended with '_'.
snmp_community = models.CharField(max_length=255)
ports = models.CharField(max_length=255)
snmpv3_securityname = models.CharField(max_length=64)
snmpv3_securitylevel = models.IntegerField()
snmpv3_authpassphrase = models.CharField(max_length=64)
snmpv3_privpassphrase = models.CharField(max_length=64)
uniq = models.IntegerField()
snmpv3_authprotocol = models.IntegerField()
snmpv3_privprotocol = models.IntegerField()
snmpv3_contextname = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'dchecks'
class Dhosts(models.Model):
dhostid = models.BigIntegerField(primary_key=True)
druleid = models.ForeignKey('Drules', db_column='druleid')
status = models.IntegerField()
lastup = models.IntegerField()
lastdown = models.IntegerField()
class Meta:
managed = False
db_table = 'dhosts'
class Drules(models.Model):
druleid = models.BigIntegerField(primary_key=True)
proxy_hostid = models.ForeignKey('Hosts', db_column='proxy_hostid', blank=True, null=True)
name = models.CharField(unique=True, max_length=255)
iprange = models.CharField(max_length=255)
delay = models.IntegerField()
nextcheck = models.IntegerField()
status = models.IntegerField()
class Meta:
managed = False
db_table = 'drules'
class Dservices(models.Model):
dserviceid = models.BigIntegerField(primary_key=True)
dhostid = models.ForeignKey(Dhosts, db_column='dhostid')
type = models.IntegerField()
key_field = models.CharField(db_column='key_', max_length=255) # Field renamed because it ended with '_'.
value = models.CharField(max_length=255)
port = models.IntegerField()
status = models.IntegerField()
lastup = models.IntegerField()
lastdown = models.IntegerField()
dcheckid = models.ForeignKey(Dchecks, db_column='dcheckid')
ip = models.CharField(max_length=39)
dns = models.CharField(max_length=64)
class Meta:
managed = False
db_table = 'dservices'
class Escalations(models.Model):
escalationid = models.BigIntegerField(primary_key=True)
actionid = models.BigIntegerField()
triggerid = models.BigIntegerField(blank=True, null=True)
eventid = models.BigIntegerField(blank=True, null=True)
r_eventid = models.BigIntegerField(blank=True, null=True)
nextcheck = models.IntegerField()
esc_step = models.IntegerField()
status = models.IntegerField()
itemid = models.BigIntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'escalations'
class Events(models.Model):
eventid = models.BigIntegerField(primary_key=True)
source = models.IntegerField()
object = models.IntegerField()
objectid = models.BigIntegerField()
clock = models.IntegerField()
value = models.IntegerField()
acknowledged = models.IntegerField()
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'events'
class Expressions(models.Model):
expressionid = models.BigIntegerField(primary_key=True)
regexpid = models.ForeignKey('Regexps', db_column='regexpid')
expression = models.CharField(max_length=255)
expression_type = models.IntegerField()
exp_delimiter = models.CharField(max_length=1)
case_sensitive = models.IntegerField()
class Meta:
managed = False
db_table = 'expressions'
class Functions(models.Model):
functionid = models.BigIntegerField(primary_key=True)
itemid = models.ForeignKey('Items', db_column='itemid')
triggerid = models.ForeignKey('Triggers', db_column='triggerid')
function = models.CharField(max_length=12)
parameter = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'functions'
class Globalmacro(models.Model):
globalmacroid = models.BigIntegerField(primary_key=True)
macro = models.CharField(unique=True, max_length=64)
value = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'globalmacro'
class Globalvars(models.Model):
globalvarid = models.BigIntegerField(primary_key=True)
snmp_lastsize = models.IntegerField()
class Meta:
managed = False
db_table = 'globalvars'
class GraphDiscovery(models.Model):
graphid = models.ForeignKey('Graphs', db_column='graphid', primary_key=True)
parent_graphid = models.ForeignKey('Graphs', db_column='parent_graphid')
class Meta:
managed = False
db_table = 'graph_discovery'
class GraphTheme(models.Model):
graphthemeid = models.BigIntegerField(primary_key=True)
description = models.CharField(unique=True, max_length=64)
theme = models.CharField(max_length=64)
backgroundcolor = models.CharField(max_length=6)
graphcolor = models.CharField(max_length=6)
graphbordercolor = models.CharField(max_length=6)
gridcolor = models.CharField(max_length=6)
maingridcolor = models.CharField(max_length=6)
gridbordercolor = models.CharField(max_length=6)
textcolor = models.CharField(max_length=6)
highlightcolor = models.CharField(max_length=6)
leftpercentilecolor = models.CharField(max_length=6)
rightpercentilecolor = models.CharField(max_length=6)
nonworktimecolor = models.CharField(max_length=6)
gridview = models.IntegerField()
legendview = models.IntegerField()
class Meta:
managed = False
db_table = 'graph_theme'
class Graphs(models.Model):
graphid = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=128)
width = models.IntegerField()
height = models.IntegerField()
yaxismin = models.FloatField()
yaxismax = models.FloatField()
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
show_work_period = models.IntegerField()
show_triggers = models.IntegerField()
graphtype = models.IntegerField()
show_legend = models.IntegerField()
show_3d = models.IntegerField()
percent_left = models.FloatField()
percent_right = models.FloatField()
ymin_type = models.IntegerField()
ymax_type = models.IntegerField()
ymin_itemid = models.ForeignKey('Items', db_column='ymin_itemid', blank=True, null=True)
ymax_itemid = models.ForeignKey('Items', db_column='ymax_itemid', blank=True, null=True)
flags = models.IntegerField()
class Meta:
managed = False
db_table = 'graphs'
class GraphsItems(models.Model):
gitemid = models.BigIntegerField(primary_key=True)
graphid = models.ForeignKey(Graphs, db_column='graphid')
itemid = models.ForeignKey('Items', db_column='itemid')
drawtype = models.IntegerField()
sortorder = models.IntegerField()
color = models.CharField(max_length=6)
yaxisside = models.IntegerField()
calc_fnc = models.IntegerField()
type = models.IntegerField()
class Meta:
managed = False
db_table = 'graphs_items'
class GroupDiscovery(models.Model):
groupid = models.ForeignKey('Groups', db_column='groupid', primary_key=True)
parent_group_prototypeid = models.ForeignKey('GroupPrototype', db_column='parent_group_prototypeid')
name = models.CharField(max_length=64)
lastcheck = models.IntegerField()
ts_delete = models.IntegerField()
class Meta:
managed = False
db_table = 'group_discovery'
class GroupPrototype(models.Model):
group_prototypeid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey('Hosts', db_column='hostid')
name = models.CharField(max_length=64)
groupid = models.ForeignKey('Groups', db_column='groupid', blank=True, null=True)
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
class Meta:
managed = False
db_table = 'group_prototype'
class Groups(models.Model):
groupid = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=64)
internal = models.IntegerField()
flags = models.IntegerField()
class Meta:
managed = False
db_table = 'groups'
class History(models.Model):
itemid = models.BigIntegerField()
clock = models.IntegerField()
value = models.FloatField()
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'history'
class HistoryLog(models.Model):
id = models.BigIntegerField(primary_key=True)
itemid = models.BigIntegerField()
clock = models.IntegerField()
timestamp = models.IntegerField()
source = models.CharField(max_length=64)
severity = models.IntegerField()
value = models.TextField()
logeventid = models.IntegerField()
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'history_log'
class HistoryStr(models.Model):
itemid = models.BigIntegerField()
clock = models.IntegerField()
value = models.CharField(max_length=255)
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'history_str'
class HistoryText(models.Model):
id = models.BigIntegerField(primary_key=True)
itemid = models.BigIntegerField()
clock = models.IntegerField()
value = models.TextField()
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'history_text'
class HistoryUint(models.Model):
itemid = models.BigIntegerField()
clock = models.IntegerField()
value = models.BigIntegerField()
ns = models.IntegerField()
class Meta:
managed = False
db_table = 'history_uint'
class HostDiscovery(models.Model):
hostid = models.ForeignKey('Hosts', db_column='hostid', primary_key=True)
parent_hostid = models.ForeignKey('Hosts', db_column='parent_hostid', blank=True, null=True)
parent_itemid = models.ForeignKey('Items', db_column='parent_itemid', blank=True, null=True)
host = models.CharField(max_length=64)
lastcheck = models.IntegerField()
ts_delete = models.IntegerField()
class Meta:
managed = False
db_table = 'host_discovery'
class HostInventory(models.Model):
hostid = models.ForeignKey('Hosts', db_column='hostid', primary_key=True)
inventory_mode = models.IntegerField()
type = models.CharField(max_length=64)
type_full = models.CharField(max_length=64)
name = models.CharField(max_length=64)
alias = models.CharField(max_length=64)
os = models.CharField(max_length=64)
os_full = models.CharField(max_length=255)
os_short = models.CharField(max_length=64)
serialno_a = models.CharField(max_length=64)
serialno_b = models.CharField(max_length=64)
tag = models.CharField(max_length=64)
asset_tag = models.CharField(max_length=64)
macaddress_a = models.CharField(max_length=64)
macaddress_b = models.CharField(max_length=64)
hardware = models.CharField(max_length=255)
hardware_full = models.TextField()
software = models.CharField(max_length=255)
software_full = models.TextField()
software_app_a = models.CharField(max_length=64)
software_app_b = models.CharField(max_length=64)
software_app_c = models.CharField(max_length=64)
software_app_d = models.CharField(max_length=64)
software_app_e = models.CharField(max_length=64)
contact = models.TextField()
location = models.TextField()
location_lat = models.CharField(max_length=16)
location_lon = models.CharField(max_length=16)
notes = models.TextField()
chassis = models.CharField(max_length=64)
model = models.CharField(max_length=64)
hw_arch = models.CharField(max_length=32)
vendor = models.CharField(max_length=64)
contract_number = models.CharField(max_length=64)
installer_name = models.CharField(max_length=64)
deployment_status = models.CharField(max_length=64)
url_a = models.CharField(max_length=255)
url_b = models.CharField(max_length=255)
url_c = models.CharField(max_length=255)
host_networks = models.TextField()
host_netmask = models.CharField(max_length=39)
host_router = models.CharField(max_length=39)
oob_ip = models.CharField(max_length=39)
oob_netmask = models.CharField(max_length=39)
oob_router = models.CharField(max_length=39)
date_hw_purchase = models.CharField(max_length=64)
date_hw_install = models.CharField(max_length=64)
date_hw_expiry = models.CharField(max_length=64)
date_hw_decomm = models.CharField(max_length=64)
site_address_a = models.CharField(max_length=128)
site_address_b = models.CharField(max_length=128)
site_address_c = models.CharField(max_length=128)
site_city = models.CharField(max_length=128)
site_state = models.CharField(max_length=64)
site_country = models.CharField(max_length=64)
site_zip = models.CharField(max_length=64)
site_rack = models.CharField(max_length=128)
site_notes = models.TextField()
poc_1_name = models.CharField(max_length=128)
poc_1_email = models.CharField(max_length=128)
poc_1_phone_a = models.CharField(max_length=64)
poc_1_phone_b = models.CharField(max_length=64)
poc_1_cell = models.CharField(max_length=64)
poc_1_screen = models.CharField(max_length=64)
poc_1_notes = models.TextField()
poc_2_name = models.CharField(max_length=128)
poc_2_email = models.CharField(max_length=128)
poc_2_phone_a = models.CharField(max_length=64)
poc_2_phone_b = models.CharField(max_length=64)
poc_2_cell = models.CharField(max_length=64)
poc_2_screen = models.CharField(max_length=64)
poc_2_notes = models.TextField()
class Meta:
managed = False
db_table = 'host_inventory'
class Hostmacro(models.Model):
hostmacroid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey('Hosts', db_column='hostid')
macro = models.CharField(max_length=64)
value = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'hostmacro'
class Hosts(models.Model):
hostid = models.BigIntegerField(primary_key=True)
proxy_hostid = models.ForeignKey('self', db_column='proxy_hostid', blank=True, null=True)
host = models.CharField(max_length=128)
status = models.IntegerField()
disable_until = models.IntegerField()
error = models.CharField(max_length=128)
available = models.IntegerField()
errors_from = models.IntegerField()
lastaccess = models.IntegerField()
ipmi_authtype = models.IntegerField()
ipmi_privilege = models.IntegerField()
ipmi_username = models.CharField(max_length=16)
ipmi_password = models.CharField(max_length=20)
ipmi_disable_until = models.IntegerField()
ipmi_available = models.IntegerField()
snmp_disable_until = models.IntegerField()
snmp_available = models.IntegerField()
maintenanceid = models.ForeignKey('Maintenances', db_column='maintenanceid', blank=True, null=True)
maintenance_status = models.IntegerField()
maintenance_type = models.IntegerField()
maintenance_from = models.IntegerField()
ipmi_errors_from = models.IntegerField()
snmp_errors_from = models.IntegerField()
ipmi_error = models.CharField(max_length=128)
snmp_error = models.CharField(max_length=128)
jmx_disable_until = models.IntegerField()
jmx_available = models.IntegerField()
jmx_errors_from = models.IntegerField()
jmx_error = models.CharField(max_length=128)
name = models.CharField(max_length=128)
flags = models.IntegerField()
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
description = models.TextField()
class Meta:
managed = False
db_table = 'hosts'
class HostsGroups(models.Model):
hostgroupid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey(Hosts, db_column='hostid')
groupid = models.ForeignKey(Groups, db_column='groupid')
class Meta:
managed = False
db_table = 'hosts_groups'
class HostsTemplates(models.Model):
hosttemplateid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey(Hosts, db_column='hostid')
templateid = models.ForeignKey(Hosts, db_column='templateid')
class Meta:
managed = False
db_table = 'hosts_templates'
class Housekeeper(models.Model):
housekeeperid = models.BigIntegerField(primary_key=True)
tablename = models.CharField(max_length=64)
field = models.CharField(max_length=64)
value = models.BigIntegerField()
class Meta:
managed = False
db_table = 'housekeeper'
class Httpstep(models.Model):
httpstepid = models.BigIntegerField(primary_key=True)
httptestid = models.ForeignKey('Httptest', db_column='httptestid')
name = models.CharField(max_length=64)
no = models.IntegerField()
url = models.CharField(max_length=2048)
timeout = models.IntegerField()
posts = models.TextField()
required = models.CharField(max_length=255)
status_codes = models.CharField(max_length=255)
variables = models.TextField()
follow_redirects = models.IntegerField()
retrieve_mode = models.IntegerField()
headers = models.TextField()
class Meta:
managed = False
db_table = 'httpstep'
class Httpstepitem(models.Model):
httpstepitemid = models.BigIntegerField(primary_key=True)
httpstepid = models.ForeignKey(Httpstep, db_column='httpstepid')
itemid = models.ForeignKey('Items', db_column='itemid')
type = models.IntegerField()
class Meta:
managed = False
db_table = 'httpstepitem'
class Httptest(models.Model):
httptestid = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=64)
applicationid = models.ForeignKey(Applications, db_column='applicationid', blank=True, null=True)
nextcheck = models.IntegerField()
delay = models.IntegerField()
status = models.IntegerField()
variables = models.TextField()
agent = models.CharField(max_length=255)
authentication = models.IntegerField()
http_user = models.CharField(max_length=64)
http_password = models.CharField(max_length=64)
hostid = models.ForeignKey(Hosts, db_column='hostid')
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
http_proxy = models.CharField(max_length=255)
retries = models.IntegerField()
ssl_cert_file = models.CharField(max_length=255)
ssl_key_file = models.CharField(max_length=255)
ssl_key_password = models.CharField(max_length=64)
verify_peer = models.IntegerField()
verify_host = models.IntegerField()
headers = models.TextField()
class Meta:
managed = False
db_table = 'httptest'
class Httptestitem(models.Model):
httptestitemid = models.BigIntegerField(primary_key=True)
httptestid = models.ForeignKey(Httptest, db_column='httptestid')
itemid = models.ForeignKey('Items', db_column='itemid')
type = models.IntegerField()
class Meta:
managed = False
db_table = 'httptestitem'
class IconMap(models.Model):
iconmapid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=64)
default_iconid = models.ForeignKey('Images', db_column='default_iconid')
class Meta:
managed = False
db_table = 'icon_map'
class IconMapping(models.Model):
iconmappingid = models.BigIntegerField(primary_key=True)
iconmapid = models.ForeignKey(IconMap, db_column='iconmapid')
iconid = models.ForeignKey('Images', db_column='iconid')
inventory_link = models.IntegerField()
expression = models.CharField(max_length=64)
sortorder = models.IntegerField()
class Meta:
managed = False
db_table = 'icon_mapping'
class Ids(models.Model):
table_name = models.CharField(max_length=64)
field_name = models.CharField(max_length=64)
nextid = models.BigIntegerField()
class Meta:
managed = False
db_table = 'ids'
class Images(models.Model):
imageid = models.BigIntegerField(primary_key=True)
imagetype = models.IntegerField()
name = models.CharField(unique=True, max_length=64)
image = models.TextField()
class Meta:
managed = False
db_table = 'images'
class Interface(models.Model):
interfaceid = models.BigIntegerField(primary_key=True)
hostid = models.ForeignKey(Hosts, db_column='hostid')
main = models.IntegerField()
type = models.IntegerField()
useip = models.IntegerField()
ip = models.CharField(max_length=64)
dns = models.CharField(max_length=64)
port = models.CharField(max_length=64)
bulk = models.IntegerField()
class Meta:
managed = False
db_table = 'interface'
class InterfaceDiscovery(models.Model):
interfaceid = models.ForeignKey(Interface, db_column='interfaceid', primary_key=True)
parent_interfaceid = models.ForeignKey(Interface, db_column='parent_interfaceid')
class Meta:
managed = False
db_table = 'interface_discovery'
class ItemCondition(models.Model):
item_conditionid = models.BigIntegerField(primary_key=True)
itemid = models.ForeignKey('Items', db_column='itemid')
operator = models.IntegerField()
macro = models.CharField(max_length=64)
value = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'item_condition'
class ItemDiscovery(models.Model):
itemdiscoveryid = models.BigIntegerField(primary_key=True)
itemid = models.ForeignKey('Items', db_column='itemid')
parent_itemid = models.ForeignKey('Items', db_column='parent_itemid')
key_field = models.CharField(db_column='key_', max_length=255) # Field renamed because it ended with '_'.
lastcheck = models.IntegerField()
ts_delete = models.IntegerField()
class Meta:
managed = False
db_table = 'item_discovery'
class Items(models.Model):
itemid = models.BigIntegerField(primary_key=True)
type = models.IntegerField()
snmp_community = models.CharField(max_length=64)
snmp_oid = models.CharField(max_length=255)
hostid = models.ForeignKey(Hosts, db_column='hostid')
name = models.CharField(max_length=255)
key_field = models.CharField(db_column='key_', max_length=255) # Field renamed because it ended with '_'.
delay = models.IntegerField()
history = models.IntegerField()
trends = models.IntegerField()
status = models.IntegerField()
value_type = models.IntegerField()
trapper_hosts = models.CharField(max_length=255)
units = models.CharField(max_length=255)
multiplier = models.IntegerField()
delta = models.IntegerField()
snmpv3_securityname = models.CharField(max_length=64)
snmpv3_securitylevel = models.IntegerField()
snmpv3_authpassphrase = models.CharField(max_length=64)
snmpv3_privpassphrase = models.CharField(max_length=64)
formula = models.CharField(max_length=255)
error = models.CharField(max_length=2048)
lastlogsize = models.BigIntegerField()
logtimefmt = models.CharField(max_length=64)
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
valuemapid = models.ForeignKey('Valuemaps', db_column='valuemapid', blank=True, null=True)
delay_flex = models.CharField(max_length=255)
params = models.TextField()
ipmi_sensor = models.CharField(max_length=128)
data_type = models.IntegerField()
authtype = models.IntegerField()
username = models.CharField(max_length=64)
password = models.CharField(max_length=64)
publickey = models.CharField(max_length=64)
privatekey = models.CharField(max_length=64)
mtime = models.IntegerField()
flags = models.IntegerField()
interfaceid = models.ForeignKey(Interface, db_column='interfaceid', blank=True, null=True)
port = models.CharField(max_length=64)
description = models.TextField()
inventory_link = models.IntegerField()
lifetime = models.CharField(max_length=64)
snmpv3_authprotocol = models.IntegerField()
snmpv3_privprotocol = models.IntegerField()
state = models.IntegerField()
snmpv3_contextname = models.CharField(max_length=255)
evaltype = models.IntegerField()
class Meta:
managed = False
db_table = 'items'
class ItemsApplications(models.Model):
itemappid = models.BigIntegerField(primary_key=True)
applicationid = models.ForeignKey(Applications, db_column='applicationid')
itemid = models.ForeignKey(Items, db_column='itemid')
class Meta:
managed = False
db_table = 'items_applications'
class Maintenances(models.Model):
maintenanceid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=128)
maintenance_type = models.IntegerField()
description = models.TextField()
active_since = models.IntegerField()
active_till = models.IntegerField()
class Meta:
managed = False
db_table = 'maintenances'
class MaintenancesGroups(models.Model):
maintenance_groupid = models.BigIntegerField(primary_key=True)
maintenanceid = models.ForeignKey(Maintenances, db_column='maintenanceid')
groupid = models.ForeignKey(Groups, db_column='groupid')
class Meta:
managed = False
db_table = 'maintenances_groups'
class MaintenancesHosts(models.Model):
maintenance_hostid = models.BigIntegerField(primary_key=True)
maintenanceid = models.ForeignKey(Maintenances, db_column='maintenanceid')
hostid = models.ForeignKey(Hosts, db_column='hostid')
class Meta:
managed = False
db_table = 'maintenances_hosts'
class MaintenancesWindows(models.Model):
maintenance_timeperiodid = models.BigIntegerField(primary_key=True)
maintenanceid = models.ForeignKey(Maintenances, db_column='maintenanceid')
timeperiodid = models.ForeignKey('Timeperiods', db_column='timeperiodid')
class Meta:
managed = False
db_table = 'maintenances_windows'
class Mappings(models.Model):
mappingid = models.BigIntegerField(primary_key=True)
valuemapid = models.ForeignKey('Valuemaps', db_column='valuemapid')
value = models.CharField(max_length=64)
newvalue = models.CharField(max_length=64)
class Meta:
managed = False
db_table = 'mappings'
class Media(models.Model):
mediaid = models.BigIntegerField(primary_key=True)
userid = models.ForeignKey('Users', db_column='userid')
mediatypeid = models.ForeignKey('MediaType', db_column='mediatypeid')
sendto = models.CharField(max_length=100)
active = models.IntegerField()
severity = models.IntegerField()
period = models.CharField(max_length=100)
class Meta:
managed = False
db_table = 'media'
class MediaType(models.Model):
mediatypeid = models.BigIntegerField(primary_key=True)
type = models.IntegerField()
description = models.CharField(unique=True, max_length=100)
smtp_server = models.CharField(max_length=255)
smtp_helo = models.CharField(max_length=255)
smtp_email = models.CharField(max_length=255)
exec_path = models.CharField(max_length=255)
gsm_modem = models.CharField(max_length=255)
username = models.CharField(max_length=255)
passwd = models.CharField(max_length=255)
status = models.IntegerField()
class Meta:
managed = False
db_table = 'media_type'
class Opcommand(models.Model):
operationid = models.ForeignKey('Operations', db_column='operationid', primary_key=True)
type = models.IntegerField()
scriptid = models.ForeignKey('Scripts', db_column='scriptid', blank=True, null=True)
execute_on = models.IntegerField()
port = models.CharField(max_length=64)
authtype = models.IntegerField()
username = models.CharField(max_length=64)
password = models.CharField(max_length=64)
publickey = models.CharField(max_length=64)
privatekey = models.CharField(max_length=64)
command = models.TextField()
class Meta:
managed = False
db_table = 'opcommand'
class OpcommandGrp(models.Model):
opcommand_grpid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey('Operations', db_column='operationid')
groupid = models.ForeignKey(Groups, db_column='groupid')
class Meta:
managed = False
db_table = 'opcommand_grp'
class OpcommandHst(models.Model):
opcommand_hstid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey('Operations', db_column='operationid')
hostid = models.ForeignKey(Hosts, db_column='hostid', blank=True, null=True)
class Meta:
managed = False
db_table = 'opcommand_hst'
class Opconditions(models.Model):
opconditionid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey('Operations', db_column='operationid')
conditiontype = models.IntegerField()
operator = models.IntegerField()
value = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'opconditions'
class Operations(models.Model):
operationid = models.BigIntegerField(primary_key=True)
actionid = models.ForeignKey(Actions, db_column='actionid')
operationtype = models.IntegerField()
esc_period = models.IntegerField()
esc_step_from = models.IntegerField()
esc_step_to = models.IntegerField()
evaltype = models.IntegerField()
class Meta:
managed = False
db_table = 'operations'
class Opgroup(models.Model):
opgroupid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey(Operations, db_column='operationid')
groupid = models.ForeignKey(Groups, db_column='groupid')
class Meta:
managed = False
db_table = 'opgroup'
class Opmessage(models.Model):
operationid = models.ForeignKey(Operations, db_column='operationid', primary_key=True)
default_msg = models.IntegerField()
subject = models.CharField(max_length=255)
message = models.TextField()
mediatypeid = models.ForeignKey(MediaType, db_column='mediatypeid', blank=True, null=True)
class Meta:
managed = False
db_table = 'opmessage'
class OpmessageGrp(models.Model):
opmessage_grpid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey(Operations, db_column='operationid')
usrgrpid = models.ForeignKey('Usrgrp', db_column='usrgrpid')
class Meta:
managed = False
db_table = 'opmessage_grp'
class OpmessageUsr(models.Model):
opmessage_usrid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey(Operations, db_column='operationid')
userid = models.ForeignKey('Users', db_column='userid')
class Meta:
managed = False
db_table = 'opmessage_usr'
class Optemplate(models.Model):
optemplateid = models.BigIntegerField(primary_key=True)
operationid = models.ForeignKey(Operations, db_column='operationid')
templateid = models.ForeignKey(Hosts, db_column='templateid')
class Meta:
managed = False
db_table = 'optemplate'
class Profiles(models.Model):
profileid = models.BigIntegerField(primary_key=True)
userid = models.ForeignKey('Users', db_column='userid')
idx = models.CharField(max_length=96)
idx2 = models.BigIntegerField()
value_id = models.BigIntegerField()
value_int = models.IntegerField()
value_str = models.CharField(max_length=255)
source = models.CharField(max_length=96)
type = models.IntegerField()
class Meta:
managed = False
db_table = 'profiles'
class ProxyAutoregHost(models.Model):
id = models.BigIntegerField(primary_key=True)
clock = models.IntegerField()
host = models.CharField(max_length=64)
listen_ip = models.CharField(max_length=39)
listen_port = models.IntegerField()
listen_dns = models.CharField(max_length=64)
host_metadata = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'proxy_autoreg_host'
class ProxyDhistory(models.Model):
id = models.BigIntegerField(primary_key=True)
clock = models.IntegerField()
druleid = models.BigIntegerField()
type = models.IntegerField()
ip = models.CharField(max_length=39)
port = models.IntegerField()
key_field = models.CharField(db_column='key_', max_length=255) # Field renamed because it ended with '_'.
value = models.CharField(max_length=255)
status = models.IntegerField()
dcheckid = models.BigIntegerField(blank=True, null=True)
dns = models.CharField(max_length=64)
class Meta:
managed = False
db_table = 'proxy_dhistory'
class ProxyHistory(models.Model):
id = models.BigIntegerField(primary_key=True)
itemid = models.BigIntegerField()
clock = models.IntegerField()
timestamp = models.IntegerField()
source = models.CharField(max_length=64)
severity = models.IntegerField()
value = models.TextField()
logeventid = models.IntegerField()
ns = models.IntegerField()
state = models.IntegerField()
class Meta:
managed = False
db_table = 'proxy_history'
class Regexps(models.Model):
regexpid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=128)
test_string = models.TextField()
class Meta:
managed = False
db_table = 'regexps'
class Rights(models.Model):
rightid = models.BigIntegerField(primary_key=True)
groupid = models.ForeignKey('Usrgrp', db_column='groupid')
permission = models.IntegerField()
id = models.ForeignKey(Groups, db_column='id')
class Meta:
managed = False
db_table = 'rights'
class Screens(models.Model):
screenid = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=255)
hsize = models.IntegerField()
vsize = models.IntegerField()
templateid = models.ForeignKey(Hosts, db_column='templateid', blank=True, null=True)
class Meta:
managed = False
db_table = 'screens'
class ScreensItems(models.Model):
screenitemid = models.BigIntegerField(primary_key=True)
screenid = models.ForeignKey(Screens, db_column='screenid')
resourcetype = models.IntegerField()
resourceid = models.BigIntegerField()
width = models.IntegerField()
height = models.IntegerField()
x = models.IntegerField()
y = models.IntegerField()
colspan = models.IntegerField()
rowspan = models.IntegerField()
elements = models.IntegerField()
valign = models.IntegerField()
halign = models.IntegerField()
style = models.IntegerField()
url = models.CharField(max_length=255)
dynamic = models.IntegerField()
sort_triggers = models.IntegerField()
application = models.CharField(max_length=255)
max_columns = models.IntegerField()
class Meta:
managed = False
db_table = 'screens_items'
class Scripts(models.Model):
scriptid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=255)
command = models.CharField(max_length=255)
host_access = models.IntegerField()
usrgrpid = models.ForeignKey('Usrgrp', db_column='usrgrpid', blank=True, null=True)
groupid = models.ForeignKey(Groups, db_column='groupid', blank=True, null=True)
description = models.TextField()
confirmation = models.CharField(max_length=255)
type = models.IntegerField()
execute_on = models.IntegerField()
class Meta:
managed = False
db_table = 'scripts'
class ServiceAlarms(models.Model):
servicealarmid = models.BigIntegerField(primary_key=True)
serviceid = models.ForeignKey('Services', db_column='serviceid')
clock = models.IntegerField()
value = models.IntegerField()
class Meta:
managed = False
db_table = 'service_alarms'
class Services(models.Model):
serviceid = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=128)
status = models.IntegerField()
algorithm = models.IntegerField()
triggerid = models.ForeignKey('Triggers', db_column='triggerid', blank=True, null=True)
showsla = models.IntegerField()
goodsla = models.FloatField()
sortorder = models.IntegerField()
class Meta:
managed = False
db_table = 'services'
class ServicesLinks(models.Model):
linkid = models.BigIntegerField(primary_key=True)
serviceupid = models.ForeignKey(Services, db_column='serviceupid')
servicedownid = models.ForeignKey(Services, db_column='servicedownid')
soft = models.IntegerField()
class Meta:
managed = False
db_table = 'services_links'
class ServicesTimes(models.Model):
timeid = models.BigIntegerField(primary_key=True)
serviceid = models.ForeignKey(Services, db_column='serviceid')
type = models.IntegerField()
ts_from = models.IntegerField()
ts_to = models.IntegerField()
note = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'services_times'
class Sessions(models.Model):
sessionid = models.CharField(primary_key=True, max_length=32)
userid = models.ForeignKey('Users', db_column='userid')
lastaccess = models.IntegerField()
status = models.IntegerField()
class Meta:
managed = False
db_table = 'sessions'
class Slides(models.Model):
slideid = models.BigIntegerField(primary_key=True)
slideshowid = models.ForeignKey('Slideshows', db_column='slideshowid')
screenid = models.ForeignKey(Screens, db_column='screenid')
step = models.IntegerField()
delay = models.IntegerField()
class Meta:
managed = False
db_table = 'slides'
class Slideshows(models.Model):
slideshowid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=255)
delay = models.IntegerField()
class Meta:
managed = False
db_table = 'slideshows'
class SysmapElementUrl(models.Model):
sysmapelementurlid = models.BigIntegerField(primary_key=True)
selementid = models.ForeignKey('SysmapsElements', db_column='selementid')
name = models.CharField(max_length=255)
url = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'sysmap_element_url'
class SysmapUrl(models.Model):
sysmapurlid = models.BigIntegerField(primary_key=True)
sysmapid = models.ForeignKey('Sysmaps', db_column='sysmapid')
name = models.CharField(max_length=255)
url = models.CharField(max_length=255)
elementtype = models.IntegerField()
class Meta:
managed = False
db_table = 'sysmap_url'
class Sysmaps(models.Model):
sysmapid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=128)
width = models.IntegerField()
height = models.IntegerField()
backgroundid = models.ForeignKey(Images, db_column='backgroundid', blank=True, null=True)
label_type = models.IntegerField()
label_location = models.IntegerField()
highlight = models.IntegerField()
expandproblem = models.IntegerField()
markelements = models.IntegerField()
show_unack = models.IntegerField()
grid_size = models.IntegerField()
grid_show = models.IntegerField()
grid_align = models.IntegerField()
label_format = models.IntegerField()
label_type_host = models.IntegerField()
label_type_hostgroup = models.IntegerField()
label_type_trigger = models.IntegerField()
label_type_map = models.IntegerField()
label_type_image = models.IntegerField()
label_string_host = models.CharField(max_length=255)
label_string_hostgroup = models.CharField(max_length=255)
label_string_trigger = models.CharField(max_length=255)
label_string_map = models.CharField(max_length=255)
label_string_image = models.CharField(max_length=255)
iconmapid = models.ForeignKey(IconMap, db_column='iconmapid', blank=True, null=True)
expand_macros = models.IntegerField()
severity_min = models.IntegerField()
class Meta:
managed = False
db_table = 'sysmaps'
class SysmapsElements(models.Model):
selementid = models.BigIntegerField(primary_key=True)
sysmapid = models.ForeignKey(Sysmaps, db_column='sysmapid')
elementid = models.BigIntegerField()
elementtype = models.IntegerField()
iconid_off = models.ForeignKey(Images, db_column='iconid_off', blank=True, null=True)
iconid_on = models.ForeignKey(Images, db_column='iconid_on', blank=True, null=True)
label = models.CharField(max_length=2048)
label_location = models.IntegerField()
x = models.IntegerField()
y = models.IntegerField()
iconid_disabled = models.ForeignKey(Images, db_column='iconid_disabled', blank=True, null=True)
iconid_maintenance = models.ForeignKey(Images, db_column='iconid_maintenance', blank=True, null=True)
elementsubtype = models.IntegerField()
areatype = models.IntegerField()
width = models.IntegerField()
height = models.IntegerField()
viewtype = models.IntegerField()
use_iconmap = models.IntegerField()
application = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'sysmaps_elements'
class SysmapsLinkTriggers(models.Model):
linktriggerid = models.BigIntegerField(primary_key=True)
linkid = models.ForeignKey('SysmapsLinks', db_column='linkid')
triggerid = models.ForeignKey('Triggers', db_column='triggerid')
drawtype = models.IntegerField()
color = models.CharField(max_length=6)
class Meta:
managed = False
db_table = 'sysmaps_link_triggers'
class SysmapsLinks(models.Model):
linkid = models.BigIntegerField(primary_key=True)
sysmapid = models.ForeignKey(Sysmaps, db_column='sysmapid')
selementid1 = models.ForeignKey(SysmapsElements, db_column='selementid1')
selementid2 = models.ForeignKey(SysmapsElements, db_column='selementid2')
drawtype = models.IntegerField()
color = models.CharField(max_length=6)
label = models.CharField(max_length=2048)
class Meta:
managed = False
db_table = 'sysmaps_links'
class Timeperiods(models.Model):
timeperiodid = models.BigIntegerField(primary_key=True)
timeperiod_type = models.IntegerField()
every = models.IntegerField()
month = models.IntegerField()
dayofweek = models.IntegerField()
day = models.IntegerField()
start_time = models.IntegerField()
period = models.IntegerField()
start_date = models.IntegerField()
class Meta:
managed = False
db_table = 'timeperiods'
class Trends(models.Model):
itemid = models.BigIntegerField()
clock = models.IntegerField()
num = models.IntegerField()
value_min = models.FloatField()
value_avg = models.FloatField()
value_max = models.FloatField()
class Meta:
managed = False
db_table = 'trends'
class TrendsUint(models.Model):
itemid = models.BigIntegerField()
clock = models.IntegerField()
num = models.IntegerField()
value_min = models.BigIntegerField()
value_avg = models.BigIntegerField()
value_max = models.BigIntegerField()
class Meta:
managed = False
db_table = 'trends_uint'
class TriggerDepends(models.Model):
triggerdepid = models.BigIntegerField(primary_key=True)
triggerid_down = models.ForeignKey('Triggers', db_column='triggerid_down')
triggerid_up = models.ForeignKey('Triggers', db_column='triggerid_up')
class Meta:
managed = False
db_table = 'trigger_depends'
class TriggerDiscovery(models.Model):
triggerid = models.ForeignKey('Triggers', db_column='triggerid', primary_key=True)
parent_triggerid = models.ForeignKey('Triggers', db_column='parent_triggerid')
class Meta:
managed = False
db_table = 'trigger_discovery'
class Triggers(models.Model):
triggerid = models.BigIntegerField(primary_key=True)
expression = models.CharField(max_length=2048)
description = models.CharField(max_length=255)
url = models.CharField(max_length=255)
status = models.IntegerField()
value = models.IntegerField()
priority = models.IntegerField()
lastchange = models.IntegerField()
comments = models.TextField()
error = models.CharField(max_length=128)
templateid = models.ForeignKey('self', db_column='templateid', blank=True, null=True)
type = models.IntegerField()
state = models.IntegerField()
flags = models.IntegerField()
class Meta:
managed = False
db_table = 'triggers'
class UserHistory(models.Model):
userhistoryid = models.BigIntegerField(primary_key=True)
userid = models.ForeignKey('Users', db_column='userid', unique=True)
title1 = models.CharField(max_length=255)
url1 = models.CharField(max_length=255)
title2 = models.CharField(max_length=255)
url2 = models.CharField(max_length=255)
title3 = models.CharField(max_length=255)
url3 = models.CharField(max_length=255)
title4 = models.CharField(max_length=255)
url4 = models.CharField(max_length=255)
title5 = models.CharField(max_length=255)
url5 = models.CharField(max_length=255)
class Meta:
managed = False
db_table = 'user_history'
class Users(models.Model):
userid = models.BigIntegerField(primary_key=True)
alias = models.CharField(unique=True, max_length=100)
name = models.CharField(max_length=100)
surname = models.CharField(max_length=100)
passwd = models.CharField(max_length=32)
url = models.CharField(max_length=255)
autologin = models.IntegerField()
autologout = models.IntegerField()
lang = models.CharField(max_length=5)
refresh = models.IntegerField()
type = models.IntegerField()
theme = models.CharField(max_length=128)
attempt_failed = models.IntegerField()
attempt_ip = models.CharField(max_length=39)
attempt_clock = models.IntegerField()
rows_per_page = models.IntegerField()
class Meta:
managed = False
db_table = 'users'
class UsersGroups(models.Model):
id = models.BigIntegerField(primary_key=True)
usrgrpid = models.ForeignKey('Usrgrp', db_column='usrgrpid')
userid = models.ForeignKey(Users, db_column='userid')
class Meta:
managed = False
db_table = 'users_groups'
class Usrgrp(models.Model):
usrgrpid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=64)
gui_access = models.IntegerField()
users_status = models.IntegerField()
debug_mode = models.IntegerField()
class Meta:
managed = False
db_table = 'usrgrp'
class Valuemaps(models.Model):
valuemapid = models.BigIntegerField(primary_key=True)
name = models.CharField(unique=True, max_length=64)
class Meta:
managed = False
db_table = 'valuemaps'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment