Skip to content

Instantly share code, notes, and snippets.

@voice1

voice1/freepbx_peewee_schema.py

Last active September 1, 2018 00:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save voice1/1de30d93c0ef9c59f8d496df3dd667a4 to your computer and use it in GitHub Desktop.
Save voice1/1de30d93c0ef9c59f8d496df3dd667a4 to your computer and use it in GitHub Desktop.
Download ZIP
FreePBX database schema for Peewee ORM
Raw
freepbx_peewee_schema.py
from peewee import *
database = MySQLDatabase('asterisk', **{'charset': 'utf8', 'use_unicode': True})
class UnknownField(object):
def __init__(self, *_, **__): pass
class BaseModel(Model):
class Meta:
database = database
class Admin(BaseModel):
value = CharField(constraints=[SQL("DEFAULT ''")])
variable = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
class Meta:
table_name = 'admin'
class Ampusers(BaseModel):
deptname = CharField(constraints=[SQL("DEFAULT ''")])
extension_high = CharField(constraints=[SQL("DEFAULT ''")])
extension_low = CharField(constraints=[SQL("DEFAULT ''")])
password_sha1 = CharField()
sections = TextField()
username = CharField(primary_key=True)
class Meta:
table_name = 'ampusers'
class Announcement(BaseModel):
allow_skip = IntegerField(null=True)
announcement = AutoField(column_name='announcement_id')
description = CharField(null=True)
noanswer = IntegerField(constraints=[SQL("DEFAULT 0")])
post_dest = CharField(null=True)
recording = IntegerField(column_name='recording_id', null=True)
repeat_msg = CharField(constraints=[SQL("DEFAULT ''")])
return_ivr = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'announcement'
class Areminder(BaseModel):
attachas = CharField(constraints=[SQL("DEFAULT CSV")])
cidtype = CharField(constraints=[SQL("DEFAULT default")])
csext = CharField(constraints=[SQL("DEFAULT ''")])
emailcomplete = TextField()
emailfrom = TextField()
enabled = IntegerField(constraints=[SQL("DEFAULT 1")])
greeting2id = IntegerField(constraints=[SQL("DEFAULT 0")])
greetingid = IntegerField(constraints=[SQL("DEFAULT 0")])
instructionsid = IntegerField(constraints=[SQL("DEFAULT 0")])
lastemail = IntegerField(constraints=[SQL("DEFAULT 0")])
maxnotice = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField(constraints=[SQL("DEFAULT ''")])
outcid = CharField(constraints=[SQL("DEFAULT ''")])
outcidname = CharField(constraints=[SQL("DEFAULT ''")])
resched = CharField(constraints=[SQL("DEFAULT LOG")])
retrycount = IntegerField(constraints=[SQL("DEFAULT 3")])
retrydelay = IntegerField(constraints=[SQL("DEFAULT 300")])
saydate = IntegerField(constraints=[SQL("DEFAULT 1")])
sayname = IntegerField(constraints=[SQL("DEFAULT 1")])
schedext = CharField(constraints=[SQL("DEFAULT ''")])
start1 = IntegerField(constraints=[SQL("DEFAULT 0")])
start2 = IntegerField(constraints=[SQL("DEFAULT 0")])
start3 = IntegerField(constraints=[SQL("DEFAULT 0")])
start4 = IntegerField(constraints=[SQL("DEFAULT 0")])
start5 = IntegerField(constraints=[SQL("DEFAULT 0")])
start6 = IntegerField(constraints=[SQL("DEFAULT 0")])
start7 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop1 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop2 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop3 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop4 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop5 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop6 = IntegerField(constraints=[SQL("DEFAULT 0")])
stop7 = IntegerField(constraints=[SQL("DEFAULT 0")])
ttsengine = IntegerField(constraints=[SQL("DEFAULT 1")])
class Meta:
table_name = 'areminder'
class AreminderCalls(BaseModel):
appointment = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
arid = IntegerField(constraints=[SQL("DEFAULT 0")])
calltime = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
length = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField(constraints=[SQL("DEFAULT ''")])
notes = CharField(null=True)
number = CharField(constraints=[SQL("DEFAULT ''")])
retry = IntegerField(constraints=[SQL("DEFAULT 0")])
status = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'areminder_calls'
class AreminderSettings(BaseModel):
key = CharField(constraints=[SQL("DEFAULT ''")])
value = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'areminder_settings'
class AreminderUpdates(BaseModel):
delete = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
id = IntegerField()
lastupdate = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
update = IntegerField(constraints=[SQL("DEFAULT 300")])
uri = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'areminder_updates'
primary_key = False
class Arimanager(BaseModel):
name = CharField(unique=True)
password = CharField(null=True)
password_format = CharField(null=True)
read_only = IntegerField(constraints=[SQL("DEFAULT 1")], null=True)
class Meta:
table_name = 'arimanager'
class Backup(BaseModel):
data = TextField(null=True)
description = CharField(null=True)
email = TextField(null=True)
immortal = CharField(null=True)
name = CharField(null=True)
class Meta:
table_name = 'backup'
class BackupCache(BaseModel):
id = CharField(unique=True)
manifest = TextField(null=True)
class Meta:
table_name = 'backup_cache'
primary_key = False
class BackupDetails(BaseModel):
backup = IntegerField(column_name='backup_id')
index = CharField(null=True)
key = CharField(null=True)
value = CharField(null=True)
class Meta:
table_name = 'backup_details'
primary_key = False
class BackupItems(BaseModel):
backup = IntegerField(column_name='backup_id')
exclude = TextField(null=True)
path = TextField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'backup_items'
primary_key = False
class BackupServerDetails(BaseModel):
key = CharField(null=True)
server = IntegerField(column_name='server_id')
value = CharField(null=True)
class Meta:
table_name = 'backup_server_details'
primary_key = False
class BackupServers(BaseModel):
data = TextField(null=True)
desc = CharField(null=True)
immortal = CharField(null=True)
name = CharField(null=True)
readonly = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'backup_servers'
class BackupTemplateDetails(BaseModel):
exclude = TextField(null=True)
path = TextField(null=True)
template = IntegerField(column_name='template_id')
type = CharField(null=True)
class Meta:
table_name = 'backup_template_details'
primary_key = False
class BackupTemplates(BaseModel):
data = TextField(null=True)
desc = CharField(null=True)
immortal = CharField(null=True)
name = CharField(null=True)
class Meta:
table_name = 'backup_templates'
class BriaSettings(BaseModel):
key = CharField(unique=True)
value = TextField()
class Meta:
table_name = 'bria_settings'
primary_key = False
class BroadcastCallees(BaseModel):
group = IntegerField(column_name='group_id', constraints=[SQL("DEFAULT 0")], index=True)
name = CharField(constraints=[SQL("DEFAULT ''")], index=True)
phonenum = CharField(constraints=[SQL("DEFAULT ''")], index=True)
class Meta:
table_name = 'broadcast_callees'
class BroadcastCampaignGroups(BaseModel):
campaign = IntegerField(column_name='campaign_id')
group = IntegerField(column_name='group_id')
class Meta:
table_name = 'broadcast_campaign_groups'
class BroadcastCampaigns(BaseModel):
active = IntegerField()
callerid = CharField()
completed = IntegerField()
concurrentcalls = IntegerField(constraints=[SQL("DEFAULT 2")], null=True)
date_finish = DateField()
date_start = DateField()
destination_machine = CharField()
destination_person = CharField()
dupes = IntegerField(constraints=[SQL("DEFAULT 2")], null=True)
email = CharField()
email_settings = CharField()
name = CharField(constraints=[SQL("DEFAULT ''")])
prefix = CharField(null=True)
retries = IntegerField(constraints=[SQL("DEFAULT 2")], null=True)
time_finish = TimeField()
time_start = TimeField()
uniqueid = CharField(constraints=[SQL("DEFAULT ''")], null=True)
weekday_finish = IntegerField()
weekday_start = IntegerField()
class Meta:
table_name = 'broadcast_campaigns'
class BroadcastGroups(BaseModel):
csvformat = CharField(constraints=[SQL("DEFAULT ABC")], null=True)
ftpdelete = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
lastupdate = IntegerField(constraints=[SQL("DEFAULT 140000000")], null=True)
name = CharField()
update = IntegerField(constraints=[SQL("DEFAULT 300")], null=True)
uri = CharField(null=True)
class Meta:
table_name = 'broadcast_groups'
class BroadcastLog(BaseModel):
answer = IntegerField()
attempt = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
callee = CharField(index=True, null=True)
callid = CharField()
campaign = IntegerField(column_name='campaign_id', index=True)
campaign_name = CharField()
delivered_to = CharField()
dialedname = CharField(null=True)
dialednum = CharField(null=True)
initiated_dial = IntegerField()
last_updated = DateTimeField()
uniqueid = CharField(index=True, null=True)
class Meta:
table_name = 'broadcast_log'
class BroadcastSettings(BaseModel):
concurrent_calls = IntegerField(constraints=[SQL("DEFAULT 0")])
from_email = CharField(constraints=[SQL("DEFAULT ''")])
maximum_retry = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'broadcast_settings'
primary_key = False
class Callback(BaseModel):
callback = AutoField(column_name='callback_id')
callbacknum = CharField(null=True)
deptname = CharField(null=True)
description = CharField(null=True)
destination = CharField(null=True)
sleep = IntegerField(null=True)
class Meta:
table_name = 'callback'
class CalleridEntries(BaseModel):
cidname = CharField(null=True)
cidnum = CharField(null=True)
name = CharField(null=True)
perm = CharField(null=True)
prefix = CharField(null=True)
class Meta:
table_name = 'callerid_entries'
class Calllimit(BaseModel):
key = CharField(primary_key=True)
value = CharField(null=True)
class Meta:
table_name = 'calllimit'
class CalllimitUsage(BaseModel):
calllimit = IntegerField(column_name='calllimit_id')
dispname = CharField(constraints=[SQL("DEFAULT ''")])
foreign = CharField(column_name='foreign_id', constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'calllimit_usage'
indexes = (
(('dispname', 'foreign'), True),
)
primary_key = CompositeKey('dispname', 'foreign')
class Callrecording(BaseModel):
callrecording = AutoField(column_name='callrecording_id')
callrecording_mode = CharField(null=True)
description = CharField(null=True)
dest = CharField(null=True)
class Meta:
table_name = 'callrecording'
class CallrecordingModule(BaseModel):
callrecording = CharField(null=True)
cidnum = CharField(constraints=[SQL("DEFAULT ''")], null=True)
display = CharField(null=True)
extension = CharField(null=True)
class Meta:
table_name = 'callrecording_module'
primary_key = False
class CertmanCas(BaseModel):
basename = CharField(unique=True)
cn = CharField()
on = CharField()
passphrase = CharField(null=True)
salt = CharField(null=True)
uid = AutoField()
class Meta:
table_name = 'certman_cas'
class CertmanCerts(BaseModel):
additional = TextField(null=True)
basename = CharField(unique=True)
caid = IntegerField(null=True)
cid = AutoField()
default = IntegerField(constraints=[SQL("DEFAULT 0")])
description = CharField(null=True)
type = CharField(constraints=[SQL("DEFAULT ss")])
class Meta:
table_name = 'certman_certs'
class CertmanCsrs(BaseModel):
basename = CharField(unique=True)
cid = AutoField()
class Meta:
table_name = 'certman_csrs'
class CertmanMapping(BaseModel):
cid = IntegerField(null=True)
id = CharField(primary_key=True)
rekey = IntegerField(null=True)
setup = CharField(null=True)
verify = CharField(null=True)
class Meta:
table_name = 'certman_mapping'
class Cidlookup(BaseModel):
cache = IntegerField(constraints=[SQL("DEFAULT 0")])
cidlookup = AutoField(column_name='cidlookup_id')
deptname = CharField(null=True)
description = CharField()
http_host = CharField(null=True)
http_password = CharField(null=True)
http_path = CharField(null=True)
http_port = CharField(null=True)
http_query = CharField(null=True)
http_username = CharField(null=True)
mysql_charset = CharField(null=True)
mysql_dbname = CharField(null=True)
mysql_host = CharField(null=True)
mysql_password = CharField(null=True)
mysql_query = CharField(null=True)
mysql_username = CharField(null=True)
opencnam_account_sid = CharField(null=True)
opencnam_auth_token = CharField(null=True)
sourcetype = CharField()
class Meta:
table_name = 'cidlookup'
class CidlookupIncoming(BaseModel):
cidlookup = IntegerField(column_name='cidlookup_id')
cidnum = CharField(null=True)
extension = CharField(null=True)
class Meta:
table_name = 'cidlookup_incoming'
primary_key = False
class Conferencespro(BaseModel):
setting = CharField(unique=True)
value = CharField()
class Meta:
table_name = 'conferencespro'
primary_key = False
class ConferencesproRooms(BaseModel):
ivr = CharField()
room = CharField(unique=True)
user = CharField()
class Meta:
table_name = 'conferencespro_rooms'
primary_key = False
class ContactmanagerEntryEmails(BaseModel):
email = CharField(null=True)
entryid = IntegerField()
class Meta:
table_name = 'contactmanager_entry_emails'
class ContactmanagerEntryImages(BaseModel):
entryid = AutoField()
format = CharField()
gravatar = IntegerField(constraints=[SQL("DEFAULT 0")])
image = TextField(null=True)
class Meta:
table_name = 'contactmanager_entry_images'
class ContactmanagerEntryNumbers(BaseModel):
e164 = CharField(column_name='E164', null=True)
countrycode = CharField(null=True)
entryid = IntegerField()
extension = CharField(null=True)
flags = CharField(null=True)
locale = CharField(null=True)
nationalnumber = CharField(null=True)
number = CharField(null=True)
possibleshort = IntegerField(null=True)
regioncode = CharField(null=True)
stripped = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'contactmanager_entry_numbers'
class ContactmanagerEntrySpeeddials(BaseModel):
entryid = IntegerField()
numberid = IntegerField()
class Meta:
table_name = 'contactmanager_entry_speeddials'
class ContactmanagerEntryUsermanImages(BaseModel):
format = CharField()
gravatar = IntegerField(constraints=[SQL("DEFAULT 0")])
image = TextField(null=True)
uid = AutoField()
class Meta:
table_name = 'contactmanager_entry_userman_images'
class ContactmanagerEntryWebsites(BaseModel):
entryid = IntegerField()
website = CharField(null=True)
class Meta:
table_name = 'contactmanager_entry_websites'
class ContactmanagerEntryXmpps(BaseModel):
entryid = IntegerField()
xmpp = CharField(null=True)
class Meta:
table_name = 'contactmanager_entry_xmpps'
class ContactmanagerGroupEntries(BaseModel):
address = CharField(constraints=[SQL("DEFAULT ''")])
company = CharField(constraints=[SQL("DEFAULT ''")])
displayname = CharField(constraints=[SQL("DEFAULT ''")])
fname = CharField(constraints=[SQL("DEFAULT ''")])
groupid = IntegerField()
lname = CharField(constraints=[SQL("DEFAULT ''")])
title = CharField(constraints=[SQL("DEFAULT ''")])
user = IntegerField()
uuid = CharField(null=True, unique=True)
class Meta:
table_name = 'contactmanager_group_entries'
class ContactmanagerGroups(BaseModel):
name = CharField()
owner = IntegerField()
type = CharField()
class Meta:
table_name = 'contactmanager_groups'
class Cronmanager(BaseModel):
command = CharField(constraints=[SQL("DEFAULT ''")])
freq = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT ''")])
lasttime = IntegerField(constraints=[SQL("DEFAULT 0")])
module = CharField(constraints=[SQL("DEFAULT ''")])
time = CharField(null=True)
class Meta:
table_name = 'cronmanager'
indexes = (
(('module', 'id'), True),
)
primary_key = CompositeKey('id', 'module')
class CustomExtensions(BaseModel):
custom_exten = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
description = CharField(constraints=[SQL("DEFAULT ''")])
notes = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'custom_extensions'
class CustomcontextsContexts(BaseModel):
context = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
description = CharField(constraints=[SQL("DEFAULT ''")], unique=True)
dialrules = CharField(null=True)
faildestination = CharField(null=True)
failpin = CharField(null=True)
failpincdr = IntegerField(constraints=[SQL("DEFAULT 0")])
featurefaildestination = CharField(null=True)
featurefailpin = CharField(null=True)
featurefailpincdr = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'customcontexts_contexts'
class CustomcontextsContextsList(BaseModel):
context = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
description = CharField(constraints=[SQL("DEFAULT ''")], unique=True)
locked = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'customcontexts_contexts_list'
class CustomcontextsIncludes(BaseModel):
context = CharField(constraints=[SQL("DEFAULT ''")])
include = CharField(constraints=[SQL("DEFAULT ''")])
sort = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
timegroupid = IntegerField(null=True)
userules = CharField(null=True)
class Meta:
table_name = 'customcontexts_includes'
indexes = (
(('context', 'include'), True),
)
primary_key = CompositeKey('context', 'include')
class CustomcontextsIncludesList(BaseModel):
context = CharField(constraints=[SQL("DEFAULT ''")])
description = CharField(constraints=[SQL("DEFAULT ''")])
include = CharField(constraints=[SQL("DEFAULT ''")])
missing = IntegerField(constraints=[SQL("DEFAULT 0")])
sort = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'customcontexts_includes_list'
indexes = (
(('context', 'include'), True),
)
primary_key = CompositeKey('context', 'include')
class CustomcontextsModule(BaseModel):
id = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
value = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'customcontexts_module'
class CxpanelConferenceRooms(BaseModel):
add_conference_room = IntegerField()
conference_room = CharField(column_name='conference_room_id', unique=True)
cxpanel_conference_room = AutoField(column_name='cxpanel_conference_room_id')
display_name = CharField()
class Meta:
table_name = 'cxpanel_conference_rooms'
class CxpanelEmail(BaseModel):
body = CharField()
subject = CharField()
class Meta:
table_name = 'cxpanel_email'
primary_key = False
class CxpanelManagedItems(BaseModel):
cxpanel = CharField(column_name='cxpanel_id')
fpbx = CharField(column_name='fpbx_id')
type = CharField()
class Meta:
table_name = 'cxpanel_managed_items'
primary_key = False
class CxpanelPhoneNumber(BaseModel):
cxpanel_phone_number = AutoField(column_name='cxpanel_phone_number_id')
phone_number = CharField()
type = CharField()
user = CharField(column_name='user_id')
class Meta:
table_name = 'cxpanel_phone_number'
class CxpanelQueues(BaseModel):
add_queue = IntegerField()
cxpanel_queue = AutoField(column_name='cxpanel_queue_id')
display_name = CharField()
queue = CharField(column_name='queue_id', unique=True)
class Meta:
table_name = 'cxpanel_queues'
class CxpanelRecordingAgent(BaseModel):
directory = CharField()
file_name_mask = CharField()
identifier = CharField()
resource_extension = CharField()
resource_host = CharField()
class Meta:
table_name = 'cxpanel_recording_agent'
primary_key = False
class CxpanelServer(BaseModel):
api_host = CharField()
api_password = CharField()
api_port = IntegerField()
api_use_ssl = IntegerField()
api_username = CharField()
asterisk_host = CharField()
clean_unknown_items = IntegerField()
client_host = CharField()
client_port = IntegerField()
client_use_ssl = IntegerField()
name = CharField()
sync_with_userman = IntegerField()
class Meta:
table_name = 'cxpanel_server'
primary_key = False
class CxpanelUsers(BaseModel):
add_extension = IntegerField()
add_user = IntegerField()
auto_answer = IntegerField()
cxpanel_user = AutoField(column_name='cxpanel_user_id')
display_name = CharField()
full = IntegerField()
hashed_password = CharField()
initial_password = CharField()
parent_user = CharField(column_name='parent_user_id')
password_dirty = IntegerField()
peer = CharField()
user = CharField(column_name='user_id', unique=True)
class Meta:
table_name = 'cxpanel_users'
class CxpanelVoicemailAgent(BaseModel):
directory = CharField()
identifier = CharField()
resource_extension = CharField()
resource_host = CharField()
class Meta:
table_name = 'cxpanel_voicemail_agent'
primary_key = False
class Dahdi(BaseModel):
data = CharField(constraints=[SQL("DEFAULT ''")])
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT -1")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'dahdi'
indexes = (
(('id', 'keyword'), True),
)
primary_key = CompositeKey('id', 'keyword')
class DahdiAdvanced(BaseModel):
additional = IntegerField(constraints=[SQL("DEFAULT 1")], null=True)
default_val = CharField(null=True)
keyword = CharField(primary_key=True)
type = CharField(constraints=[SQL("DEFAULT chandahdi")], null=True)
val = CharField(null=True)
class Meta:
table_name = 'dahdi_advanced'
class DahdiAdvancedModules(BaseModel):
module_name = CharField(null=True, unique=True)
settings = TextField(null=True)
class Meta:
table_name = 'dahdi_advanced_modules'
class DahdiAnalog(BaseModel):
context = CharField(null=True)
group = CharField(null=True)
port = IntegerField(null=True, unique=True)
rxgain = CharField(constraints=[SQL("DEFAULT 0.0")])
signalling = CharField(null=True)
txgain = CharField(constraints=[SQL("DEFAULT 0.0")])
type = CharField(null=True)
class Meta:
table_name = 'dahdi_analog'
primary_key = False
class DahdiConfiguredLocations(BaseModel):
basechan = IntegerField(null=True)
device = CharField(null=True)
location = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'dahdi_configured_locations'
primary_key = False
class DahdiModules(BaseModel):
module_name = CharField(null=True, unique=True)
settings = TextField(null=True)
class Meta:
table_name = 'dahdi_modules'
primary_key = False
class DahdiSpans(BaseModel):
active = IntegerField(constraints=[SQL("DEFAULT 1")], null=True)
additional_groups = TextField(null=True)
alarms = CharField(null=True)
basechan = IntegerField(null=True)
coding = CharField(null=True)
coding_opts = CharField(null=True)
context = CharField(null=True)
definedchans = IntegerField(null=True)
description = CharField(null=True)
devicetype = CharField(null=True)
framing = CharField(null=True)
framing_opts = CharField(null=True)
group = IntegerField(null=True)
irq = CharField(null=True)
lbo = IntegerField(null=True)
location = CharField(null=True)
manufacturer = CharField(constraints=[SQL("DEFAULT Digium")])
max_ch = IntegerField(null=True)
mfcr2_accept_on_offer = CharField(constraints=[SQL("DEFAULT yes")])
mfcr2_advanced_protocol_file = CharField(null=True)
mfcr2_allow_collect_calls = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_call_files = CharField(constraints=[SQL("DEFAULT yes")])
mfcr2_category = CharField(constraints=[SQL("DEFAULT national_subscriber")])
mfcr2_charge_calls = CharField(constraints=[SQL("DEFAULT yes")])
mfcr2_double_answer = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_forced_release = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_get_ani_first = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_immediate_accept = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_logdir = CharField(null=True)
mfcr2_logging = CharField(null=True)
mfcr2_max_ani = IntegerField(constraints=[SQL("DEFAULT 10")])
mfcr2_max_dnis = IntegerField(constraints=[SQL("DEFAULT 4")])
mfcr2_metering_pulse_timeout = DecimalField()
mfcr2_mfback_pulse_timeout = DecimalField()
mfcr2_mfback_timeout = DecimalField()
mfcr2_skip_catefory = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_skip_category = CharField(constraints=[SQL("DEFAULT no")])
mfcr2_variant = CharField(constraints=[SQL("DEFAULT ITU")])
min_ch = IntegerField(null=True)
name = CharField(null=True)
pridialplan = CharField(null=True)
priexclusive = CharField()
prilocaldialplan = CharField(null=True)
reserved_ch = IntegerField(null=True)
rxgain = CharField(constraints=[SQL("DEFAULT 0.0")])
signalling = CharField(null=True)
span = IntegerField()
spantype = CharField(null=True)
switchtype = CharField(null=True)
syncsrc = IntegerField(null=True)
timing = IntegerField(null=True)
totchans = IntegerField(null=True)
txgain = CharField(constraints=[SQL("DEFAULT 0.0")])
type = CharField(null=True)
class Meta:
table_name = 'dahdi_spans'
class Dahdichandids(BaseModel):
channel = AutoField()
description = CharField(constraints=[SQL("DEFAULT ''")])
did = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'dahdichandids'
class Daynight(BaseModel):
dest = CharField(constraints=[SQL("DEFAULT ''")])
dmode = CharField(constraints=[SQL("DEFAULT ''")])
ext = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'daynight'
indexes = (
(('ext', 'dmode', 'dest'), True),
)
primary_key = CompositeKey('dest', 'dmode', 'ext')
class Devices(BaseModel):
description = CharField(null=True)
devicetype = CharField(constraints=[SQL("DEFAULT ''")])
dial = CharField(constraints=[SQL("DEFAULT ''")])
emergency_cid = CharField(null=True)
id = CharField(constraints=[SQL("DEFAULT ''")], index=True)
tech = CharField(constraints=[SQL("DEFAULT ''")], index=True)
user = CharField(null=True)
class Meta:
table_name = 'devices'
primary_key = False
class DigiumPhonesAlerts(BaseModel):
alertinfo = CharField(null=True)
name = CharField(null=True)
ringtone = IntegerField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'digium_phones_alerts'
class DigiumPhonesCustomappSettings(BaseModel):
customappid = IntegerField()
keyword = CharField(constraints=[SQL("DEFAULT ''")])
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_customapp_settings'
indexes = (
(('customappid', 'keyword'), True),
)
primary_key = CompositeKey('customappid', 'keyword')
class DigiumPhonesCustomapps(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_customapps'
class DigiumPhonesDeviceAlerts(BaseModel):
alertid = IntegerField()
deviceid = IntegerField()
id = IntegerField()
class Meta:
table_name = 'digium_phones_device_alerts'
indexes = (
(('deviceid', 'alertid'), True),
)
primary_key = CompositeKey('alertid', 'deviceid')
class DigiumPhonesDeviceCustomapps(BaseModel):
customappid = IntegerField()
deviceid = IntegerField()
id = IntegerField()
class Meta:
table_name = 'digium_phones_device_customapps'
indexes = (
(('deviceid', 'customappid'), True),
)
primary_key = CompositeKey('customappid', 'deviceid')
class DigiumPhonesDeviceExternallines(BaseModel):
deviceid = IntegerField()
externallineid = IntegerField()
id = IntegerField()
class Meta:
table_name = 'digium_phones_device_externallines'
indexes = (
(('deviceid', 'externallineid'), True),
)
primary_key = CompositeKey('deviceid', 'externallineid')
class DigiumPhonesDeviceLogos(BaseModel):
deviceid = IntegerField()
id = IntegerField()
logoid = IntegerField()
class Meta:
table_name = 'digium_phones_device_logos'
indexes = (
(('deviceid', 'logoid'), True),
)
primary_key = CompositeKey('deviceid', 'logoid')
class DigiumPhonesDeviceMcpages(BaseModel):
deviceid = IntegerField()
id = IntegerField()
mcpageid = IntegerField()
class Meta:
table_name = 'digium_phones_device_mcpages'
indexes = (
(('deviceid', 'mcpageid'), True),
)
primary_key = CompositeKey('deviceid', 'mcpageid')
class DigiumPhonesDeviceNetworks(BaseModel):
deviceid = IntegerField()
id = IntegerField()
networkid = IntegerField()
class Meta:
table_name = 'digium_phones_device_networks'
indexes = (
(('deviceid', 'networkid'), True),
)
primary_key = CompositeKey('deviceid', 'networkid')
class DigiumPhonesDeviceParkapps(BaseModel):
category = CharField(constraints=[SQL("DEFAULT ''")])
deviceid = IntegerField()
id = IntegerField()
class Meta:
table_name = 'digium_phones_device_parkapps'
indexes = (
(('deviceid', 'category'), True),
)
primary_key = CompositeKey('category', 'deviceid')
class DigiumPhonesDevicePhonebooks(BaseModel):
deviceid = IntegerField()
id = IntegerField()
phonebookid = IntegerField()
class Meta:
table_name = 'digium_phones_device_phonebooks'
indexes = (
(('deviceid', 'phonebookid'), True),
)
primary_key = CompositeKey('deviceid', 'phonebookid')
class DigiumPhonesDeviceRingtones(BaseModel):
deviceid = IntegerField()
id = IntegerField()
ringtoneid = IntegerField()
class Meta:
table_name = 'digium_phones_device_ringtones'
indexes = (
(('deviceid', 'ringtoneid'), True),
)
primary_key = CompositeKey('deviceid', 'ringtoneid')
class DigiumPhonesDeviceSettings(BaseModel):
deviceid = IntegerField()
keyword = CharField(constraints=[SQL("DEFAULT ''")])
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_device_settings'
indexes = (
(('deviceid', 'keyword'), True),
)
primary_key = CompositeKey('deviceid', 'keyword')
class DigiumPhonesDeviceStatuses(BaseModel):
deviceid = IntegerField()
id = IntegerField()
statusid = IntegerField()
class Meta:
table_name = 'digium_phones_device_statuses'
indexes = (
(('deviceid', 'statusid'), True),
)
primary_key = CompositeKey('deviceid', 'statusid')
class DigiumPhonesDevices(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_devices'
class DigiumPhonesExtensionSettings(BaseModel):
extension = IntegerField()
keyword = CharField(constraints=[SQL("DEFAULT ''")])
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_extension_settings'
indexes = (
(('extension', 'keyword'), True),
)
primary_key = CompositeKey('extension', 'keyword')
class DigiumPhonesExternallineSettings(BaseModel):
externallineid = IntegerField()
keyword = CharField(constraints=[SQL("DEFAULT ''")])
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_externalline_settings'
indexes = (
(('externallineid', 'keyword'), True),
)
primary_key = CompositeKey('externallineid', 'keyword')
class DigiumPhonesExternallines(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_externallines'
class DigiumPhonesFirmware(BaseModel):
file_name = CharField()
package = CharField(column_name='package_id')
phone_model = CharField()
unique = CharField(column_name='unique_id', primary_key=True)
class Meta:
table_name = 'digium_phones_firmware'
class DigiumPhonesFirmwarePackages(BaseModel):
file_path = CharField()
name = CharField()
unique = CharField(column_name='unique_id', primary_key=True)
version = CharField()
class Meta:
table_name = 'digium_phones_firmware_packages'
class DigiumPhonesGeneral(BaseModel):
default_val = CharField(null=True)
keyword = CharField(primary_key=True)
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_general'
class DigiumPhonesLines(BaseModel):
deviceid = IntegerField()
extension = CharField(constraints=[SQL("DEFAULT ''")])
id = IntegerField()
class Meta:
table_name = 'digium_phones_lines'
indexes = (
(('deviceid', 'extension'), True),
)
primary_key = CompositeKey('deviceid', 'extension')
class DigiumPhonesLogos(BaseModel):
model = CharField(null=True)
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_logos'
class DigiumPhonesMcpageSettings(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")])
mcpageid = IntegerField()
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_mcpage_settings'
indexes = (
(('mcpageid', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'mcpageid')
class DigiumPhonesMcpages(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_mcpages'
class DigiumPhonesNetworkSettings(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")])
networkid = IntegerField()
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_network_settings'
indexes = (
(('networkid', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'networkid')
class DigiumPhonesNetworks(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_networks'
class DigiumPhonesPhonebookEntries(BaseModel):
extension = CharField(null=True)
id = IntegerField()
phonebookid = IntegerField()
class Meta:
table_name = 'digium_phones_phonebook_entries'
indexes = (
(('id', 'phonebookid'), True),
)
primary_key = CompositeKey('id', 'phonebookid')
class DigiumPhonesPhonebookEntrySettings(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")])
phonebookentryid = IntegerField()
phonebookid = IntegerField()
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_phonebook_entry_settings'
indexes = (
(('phonebookid', 'phonebookentryid', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'phonebookentryid', 'phonebookid')
class DigiumPhonesPhonebooks(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_phonebooks'
class DigiumPhonesPnacSettings(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")])
pnacid = IntegerField()
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_pnac_settings'
indexes = (
(('pnacid', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'pnacid')
class DigiumPhonesPnacs(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_pnacs'
class DigiumPhonesQueues(BaseModel):
deviceid = IntegerField()
permission = CharField(constraints=[SQL("DEFAULT ''")])
queueid = IntegerField()
class Meta:
table_name = 'digium_phones_queues'
indexes = (
(('queueid', 'deviceid', 'permission'), True),
)
primary_key = CompositeKey('deviceid', 'permission', 'queueid')
class DigiumPhonesRingtones(BaseModel):
builtin = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
filename = CharField(null=True)
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_ringtones'
class DigiumPhonesStatusEntries(BaseModel):
id = IntegerField()
statusid = IntegerField()
text = CharField(null=True)
class Meta:
table_name = 'digium_phones_status_entries'
indexes = (
(('id', 'statusid'), True),
)
primary_key = CompositeKey('id', 'statusid')
class DigiumPhonesStatusSettings(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")])
statusid = IntegerField()
val = CharField(null=True)
class Meta:
table_name = 'digium_phones_status_settings'
indexes = (
(('statusid', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'statusid')
class DigiumPhonesStatuses(BaseModel):
name = CharField(null=True)
class Meta:
table_name = 'digium_phones_statuses'
class DigiumPhonesVoicemailTranslations(BaseModel):
keyword = CharField()
locale = CharField()
val = CharField()
class Meta:
table_name = 'digium_phones_voicemail_translations'
indexes = (
(('locale', 'keyword'), True),
)
primary_key = CompositeKey('keyword', 'locale')
class DigiumaddoninstallerAddons(BaseModel):
category_index = IntegerField()
description = TextField(null=True)
documentation = CharField(constraints=[SQL("DEFAULT ''")])
id = CharField(primary_key=True)
is_installed = IntegerField(constraints=[SQL("DEFAULT 0")])
is_registered = IntegerField(constraints=[SQL("DEFAULT 0")])
is_uptodate = IntegerField(constraints=[SQL("DEFAULT 0")])
link = CharField(constraints=[SQL("DEFAULT ''")])
name = CharField(constraints=[SQL("DEFAULT ''")])
product_index = IntegerField()
register_limit = IntegerField(constraints=[SQL("DEFAULT 0")])
status = CharField(constraints=[SQL("DEFAULT not_installed")])
supported_version = CharField(constraints=[SQL("DEFAULT 0.1")], null=True)
class Meta:
table_name = 'digiumaddoninstaller_addons'
class DigiumaddoninstallerAddonsDownloads(BaseModel):
addon = CharField(column_name='addon_id', null=True)
download = CharField(column_name='download_id', null=True)
class Meta:
table_name = 'digiumaddoninstaller_addons_downloads'
class DigiumaddoninstallerDownloads(BaseModel):
available_version = CharField(constraints=[SQL("DEFAULT ''")])
id = CharField(primary_key=True)
installed_version = CharField(constraints=[SQL("DEFAULT ''")])
name = CharField(constraints=[SQL("DEFAULT ''")])
package = CharField(constraints=[SQL("DEFAULT {ast}-{name}")])
path = CharField(constraints=[SQL("DEFAULT ''")])
tarball = CharField(constraints=[SQL("DEFAULT {name}-{astver}_{version}-{arch}.tar.gz")])
class Meta:
table_name = 'digiumaddoninstaller_downloads'
class DigiumaddoninstallerDownloadsAstVersions(BaseModel):
ast_version = CharField()
download = CharField(column_name='download_id')
class Meta:
table_name = 'digiumaddoninstaller_downloads_ast_versions'
class DigiumaddoninstallerDownloadsBits(BaseModel):
bit = CharField(null=True)
download = CharField(column_name='download_id')
class Meta:
table_name = 'digiumaddoninstaller_downloads_bits'
class DigiumaddoninstallerRegisters(BaseModel):
addon = CharField(column_name='addon_id')
data = TextField()
filename = CharField()
path = CharField()
time_registered = DateTimeField(constraints=[SQL("DEFAULT CURRENT_TIMESTAMP")])
class Meta:
table_name = 'digiumaddoninstaller_registers'
class DigiumaddoninstallerSystem(BaseModel):
value = CharField(constraints=[SQL("DEFAULT ''")])
variable = CharField(constraints=[SQL("DEFAULT ''")], unique=True)
class Meta:
table_name = 'digiumaddoninstaller_system'
class DirectoryDetails(BaseModel):
alert_info = CharField(null=True)
announcement = IntegerField(null=True)
callid_prefix = CharField(null=True)
description = CharField(null=True)
dirname = CharField(null=True)
invalid_destination = CharField(null=True)
invalid_recording = IntegerField(null=True)
repeat_loops = CharField(null=True)
repeat_recording = IntegerField(null=True)
retivr = CharField(null=True)
rvolume = CharField(constraints=[SQL("DEFAULT ''")])
say_extension = CharField(null=True)
class Meta:
table_name = 'directory_details'
class DirectoryEntries(BaseModel):
audio = CharField(null=True)
dial = CharField(constraints=[SQL("DEFAULT ''")], null=True)
e = IntegerField(column_name='e_id', null=True)
foreign = CharField(column_name='foreign_id', null=True)
id = IntegerField()
name = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'directory_entries'
primary_key = False
class Disa(BaseModel):
cid = CharField(null=True)
context = CharField(null=True)
digittimeout = IntegerField(null=True)
disa = AutoField(column_name='disa_id')
displayname = CharField(null=True)
hangup = CharField(null=True)
keepcid = IntegerField(constraints=[SQL("DEFAULT 1")])
needconf = CharField(null=True)
pin = CharField(null=True)
resptimeout = IntegerField(null=True)
class Meta:
table_name = 'disa'
class EndpointAastraExtra(BaseModel):
exclude = CharField(null=True)
label = CharField(null=True, unique=True)
type = CharField(null=True)
value = CharField(null=True)
class Meta:
table_name = 'endpoint_aastra_extra'
primary_key = False
class EndpointBasefiles(BaseModel):
oid = CharField(column_name='OID', null=True)
attrib = CharField(null=True)
brand = CharField(null=True)
define = CharField(null=True)
description = CharField(null=True)
edited = CharField(null=True)
file = CharField(null=True)
model = CharField(null=True)
param = CharField(null=True)
template = CharField(null=True)
type = CharField(null=True)
value = CharField(null=True)
class Meta:
table_name = 'endpoint_basefiles'
class EndpointBrand(BaseModel):
brand = CharField(null=True)
id = IntegerField(unique=True)
oui = CharField(null=True)
class Meta:
table_name = 'endpoint_brand'
primary_key = False
class EndpointButtons(BaseModel):
brand = CharField()
daylight = CharField(null=True)
id = BigAutoField()
key = CharField()
template_name = CharField()
value = CharField(null=True)
class Meta:
table_name = 'endpoint_buttons'
class EndpointCustomext(BaseModel):
destination = CharField(null=True)
ext = CharField()
id = BigIntegerField(unique=True)
label = CharField(null=True)
secret = CharField()
sipport = CharField(column_name='sipPort', null=True)
class Meta:
table_name = 'endpoint_customExt'
primary_key = False
class EndpointExtButtons(BaseModel):
brand = CharField()
ext = CharField()
id = BigAutoField()
key = CharField()
template_name = CharField()
value = CharField(null=True)
class Meta:
table_name = 'endpoint_ext_buttons'
class EndpointExtensions(BaseModel):
accessory = CharField(null=True)
account = CharField(null=True)
blf = CharField(null=True)
blf_label = CharField(null=True)
brand = CharField(null=True)
country = CharField(null=True)
exp0 = CharField(null=True)
exp1 = CharField(null=True)
exp2 = CharField(null=True)
exp3 = CharField(null=True)
exp4 = CharField(null=True)
exp5 = CharField(null=True)
ext = CharField(primary_key=True)
mac = CharField(null=True)
model = CharField(null=True)
multicell = CharField(null=True)
rebuild = CharField(null=True)
repeater1 = CharField(null=True)
repeater2 = CharField(null=True)
repeater3 = CharField(null=True)
template = CharField(null=True)
vpn = BigIntegerField(null=True)
class Meta:
table_name = 'endpoint_extensions'
class EndpointFirmware(BaseModel):
brand = CharField(unique=True)
installed1 = CharField(null=True)
installed2 = CharField(null=True)
slot1 = CharField(null=True)
slot2 = CharField(null=True)
class Meta:
table_name = 'endpoint_firmware'
primary_key = False
class EndpointGlobal(BaseModel):
key = CharField(unique=True)
values = CharField(null=True)
class Meta:
table_name = 'endpoint_global'
primary_key = False
class EndpointIgnoremac(BaseModel):
id = BigIntegerField(unique=True)
mac = CharField()
class Meta:
table_name = 'endpoint_ignoreMac'
primary_key = False
class EndpointImages(BaseModel):
key = CharField(unique=True)
class Meta:
table_name = 'endpoint_images'
primary_key = False
class EndpointModels(BaseModel):
accounts = CharField(null=True)
brand = CharField(null=True)
exp = CharField(null=True)
extrakey = CharField(null=True)
firmware = CharField(null=True)
global_ = CharField(column_name='global', null=True)
linekeys = CharField(null=True)
model = CharField(null=True, unique=True)
prgkey = CharField(null=True)
softkeys = CharField(null=True)
speeddial = CharField(null=True)
topsoftkey = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'endpoint_models'
primary_key = False
class EndpointRingtones(BaseModel):
description = CharField(null=True)
key = CharField(unique=True)
class Meta:
table_name = 'endpoint_ringtones'
primary_key = False
class EndpointTemplates(BaseModel):
acr = CharField(null=True)
activecallstatus = CharField(column_name='activecallStatus', null=True)
answer = CharField(null=True)
background = CharField(null=True)
backlightactive = CharField(column_name='backlightActive', null=True)
backlightinactive = CharField(column_name='backlightInActive', null=True)
backlighttimeout = CharField(column_name='backlightTimeout', null=True)
backupdest = CharField(column_name='backupDest', null=True)
backupoutboundproxy = CharField(column_name='backupOutboundProxy', null=True)
backupoutboundproxyport = CharField(column_name='backupOutboundProxyPort', null=True)
backupport = CharField(column_name='backupPort', null=True)
barge = CharField(null=True)
brand = CharField(null=True)
browsernote = CharField(column_name='browserNote', null=True)
callwaiting = CharField(null=True)
confcallrelease = CharField(column_name='confCallRelease', null=True)
contactphoto = CharField(column_name='contactPhoto', null=True)
country = CharField(null=True)
dvlan = CharField(column_name='dVlan', null=True)
dateformat = CharField(column_name='dateFormat', null=True)
daylight = CharField(null=True)
default = CharField(null=True)
destination = CharField(null=True)
dhcpvlan = CharField(column_name='dhcpVlan', null=True)
dialfirstdigit = CharField(column_name='dialFirstDigit', null=True)
dialnow = CharField(column_name='dialNow', null=True)
dialpattern = CharField(null=True)
dsted = CharField(column_name='dstED', null=True)
dstem = CharField(column_name='dstEM', null=True)
dstet = CharField(column_name='dstET', null=True)
dstew = CharField(column_name='dstEW', null=True)
dstsd = CharField(column_name='dstSD', null=True)
dstsm = CharField(column_name='dstSM', null=True)
dstst = CharField(column_name='dstST', null=True)
dstsw = CharField(column_name='dstSW', null=True)
echo = CharField(null=True)
entrytimeout = CharField(column_name='entryTimeout', null=True)
ext = CharField(null=True)
externaldefault = CharField(column_name='externalDefault', null=True)
extra = CharField(null=True)
features = CharField(null=True)
firmware = CharField(constraints=[SQL("DEFAULT 0")], null=True)
focus = CharField(null=True)
fontsize = CharField(column_name='fontSize', null=True)
ftppass = CharField(null=True)
ftpserver = CharField(null=True)
ftpuser = CharField(null=True)
guioverride = CharField(column_name='guiOverride', null=True)
headset = CharField(null=True)
holdtone = CharField(column_name='holdTone', null=True)
holdtonedelay = CharField(column_name='holdToneDelay', null=True)
hotline = CharField(null=True)
hotlinedest = CharField(column_name='hotlineDest', null=True)
id = BigAutoField()
internaldefault = CharField(column_name='internalDefault', null=True)
keypresstone = CharField(column_name='keypressTone', null=True)
labelscroll = CharField(column_name='labelScroll', null=True)
language = CharField(null=True)
lcdlanguage = CharField(column_name='lcdLanguage', null=True)
ldapbase = CharField(column_name='ldapBase', null=True)
ldapdisplayname = CharField(column_name='ldapDisplayName', null=True)
ldaplookupcall = CharField(column_name='ldapLookupCall', null=True)
ldapmaxhits = CharField(column_name='ldapMaxHits', null=True)
ldapnameattributes = CharField(column_name='ldapNameAttributes', null=True)
ldapnamefilter = CharField(column_name='ldapNameFilter', null=True)
ldapnumberattributes = CharField(column_name='ldapNumberAttributes', null=True)
ldapnumberfilter = CharField(column_name='ldapNumberFilter', null=True)
ldappassword = CharField(column_name='ldapPassword', null=True)
ldapport = CharField(column_name='ldapPort', null=True)
ldapsearchdelay = CharField(column_name='ldapSearchDelay', null=True)
ldapserveraddress = CharField(column_name='ldapServerAddress', null=True)
ldapsort = CharField(column_name='ldapSort', null=True)
ldapusername = CharField(column_name='ldapUsername', null=True)
linelabel = CharField(column_name='lineLabel', null=True)
lldp = CharField(null=True)
lldppacket = CharField(column_name='lldpPacket', null=True)
lldpprotocol = CharField(column_name='lldpProtocol', null=True)
logoled = CharField(null=True)
longpressidlestate = CharField(column_name='longPressIdleState', null=True)
longpressinusestate = CharField(column_name='longPressInUseState', null=True)
longpressringstate = CharField(column_name='longPressRingState', null=True)
menukey = CharField(null=True)
menupin = CharField(null=True)
misscallsstatus = CharField(column_name='misscallsStatus', null=True)
missed = CharField(null=True)
models = CharField(constraints=[SQL("DEFAULT 0")], null=True)
multicastaddress = CharField(column_name='multicastAddress', null=True)
multicastenable = CharField(column_name='multicastEnable', null=True)
mute = CharField(null=True)
offhook = CharField(null=True)
outboundproxy = CharField(column_name='outboundProxy', null=True)
outboundproxyport = CharField(column_name='outboundProxyPort', null=True)
outgoing = CharField(null=True)
phoneapps = CharField(column_name='phoneApps', null=True)
phonelabel = CharField(column_name='phoneLabel', null=True)
powerstatus = CharField(column_name='powerStatus', null=True)
protocol = CharField(null=True)
remotedisconnect = CharField(column_name='remoteDisconnect', null=True)
ringingstatus = CharField(column_name='ringingStatus', null=True)
shortpressidlestate = CharField(column_name='shortPressIdleState', null=True)
shortpressinusestate = CharField(column_name='shortPressInUseState', null=True)
ssschedule = CharField(column_name='ssSchedule', null=True)
sstext = CharField(column_name='ssText', null=True)
stutter = CharField(null=True)
template_name = CharField(null=True)
timeformat = CharField(column_name='timeFormat', null=True)
time_server = CharField(null=True)
time_server_1 = CharField(null=True)
time_server_2 = CharField(null=True)
time_server_3 = CharField(null=True)
timeout = CharField(null=True)
timezone = CharField(null=True)
toneset = CharField(null=True)
vvlan = CharField(column_name='vVlan', null=True)
vvlanp = CharField(column_name='vVlanP', null=True)
vlanidentity = CharField(column_name='vlanIdentity', null=True)
vlanmode = CharField(column_name='vlanMode', null=True)
vlanpass = CharField(column_name='vlanPass', null=True)
voicemailtone = CharField(column_name='voicemailTone', null=True)
voicemailkey = CharField(null=True)
voicemessagestatus = CharField(column_name='voicemessageStatus', null=True)
volume = CharField(null=True)
wenable1 = CharField(column_name='wEnable1', null=True)
wwepbits1 = CharField(column_name='wWEPBits1', null=True)
wwpapskkey1 = CharField(column_name='wWPAPSKKey1', null=True)
wwpapskpass1 = CharField(column_name='wWPAPSKPass1', null=True)
wsecurity1 = CharField(null=True)
wssid1 = CharField(null=True)
class Meta:
table_name = 'endpoint_templates'
class EndpointTimezones(BaseModel):
aastra = CharField(null=True)
and_ = CharField(column_name='and', null=True)
cisco = CharField(null=True)
ciscoent = CharField(column_name='ciscoEnt', null=True)
code = CharField(null=True)
cortelco = CharField(null=True)
digium = CharField(null=True)
dp715 = CharField(null=True)
grandstream = CharField(null=True)
location = CharField(null=True)
mocet = CharField(null=True)
obihai = CharField(null=True)
offset = CharField(null=True)
panasonic = CharField(null=True)
panasonic2 = CharField(null=True)
phoenix = CharField(null=True)
snom = CharField(null=True)
snomv8 = CharField(null=True)
vtech = CharField(null=True)
yealink = CharField(null=True)
class Meta:
table_name = 'endpoint_timezones'
class EndpointXml(BaseModel):
_480i = CharField(column_name='480i', null=True)
_51i = CharField(column_name='51i', null=True)
_53i = CharField(column_name='53i', null=True)
_55i = CharField(column_name='55i', null=True)
_57i = CharField(column_name='57i', null=True)
_57ict = CharField(column_name='57iCT', null=True)
_6731i = CharField(column_name='6731i', null=True)
_6735i = CharField(column_name='6735i', null=True)
_6737i = CharField(column_name='6737i', null=True)
_6739i = CharField(column_name='6739i', null=True)
_675_1 = CharField(column_name='675-1', null=True)
_675_2 = CharField(column_name='675-2', null=True)
_675_3 = CharField(column_name='675-3', null=True)
_9112i = CharField(column_name='9112i', null=True)
_9133i = CharField(column_name='9133i', null=True)
_9143i = CharField(column_name='9143i', null=True)
_9480i = CharField(column_name='9480i', null=True)
_9480ict = CharField(column_name='9480iCT', null=True)
api = CharField(null=True)
app_name = CharField(null=True, unique=True)
url = CharField(null=True)
class Meta:
table_name = 'endpoint_xml'
primary_key = False
class EndpointmanBrandList(BaseModel):
cfg_ver = CharField()
directory = CharField()
hidden = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(primary_key=True)
installed = IntegerField(constraints=[SQL("DEFAULT 0")])
local = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField()
class Meta:
table_name = 'endpointman_brand_list'
class EndpointmanCustomConfigs(BaseModel):
data = TextField()
name = CharField()
original_name = CharField()
product = CharField(column_name='product_id')
class Meta:
table_name = 'endpointman_custom_configs'
class EndpointmanGlobalVars(BaseModel):
idnum = AutoField()
value = TextField()
var_name = CharField(unique=True)
class Meta:
table_name = 'endpointman_global_vars'
class EndpointmanLineList(BaseModel):
custom_cfg_data = TextField()
description = CharField()
ext = CharField()
line = IntegerField()
luid = AutoField()
mac = IntegerField(column_name='mac_id')
user_cfg_data = TextField()
class Meta:
table_name = 'endpointman_line_list'
class EndpointmanMacList(BaseModel):
config_files_override = TextField()
global_custom_cfg_data = TextField()
global_settings_override = TextField(null=True)
global_user_cfg_data = TextField()
mac = CharField(null=True, unique=True)
model = CharField()
specific_settings = TextField(null=True)
template = IntegerField(column_name='template_id')
class Meta:
table_name = 'endpointman_mac_list'
class EndpointmanModelList(BaseModel):
brand = IntegerField()
enabled = IntegerField(constraints=[SQL("DEFAULT 0")])
hidden = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(primary_key=True)
max_lines = IntegerField()
model = CharField()
product = CharField(column_name='product_id')
template_data = TextField()
template_list = TextField()
class Meta:
table_name = 'endpointman_model_list'
class EndpointmanOuiList(BaseModel):
brand = IntegerField()
custom = IntegerField(constraints=[SQL("DEFAULT 0")])
oui = CharField(null=True, unique=True)
class Meta:
table_name = 'endpointman_oui_list'
class EndpointmanProductList(BaseModel):
brand = IntegerField()
cfg_dir = CharField()
cfg_ver = CharField()
config_files = TextField(null=True)
firmware_files = TextField()
firmware_vers = CharField()
hidden = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(primary_key=True)
long_name = CharField()
short_name = CharField()
special_cfgs = TextField()
class Meta:
table_name = 'endpointman_product_list'
class EndpointmanTemplateList(BaseModel):
config_files_override = TextField(null=True)
global_custom_cfg_data = TextField(null=True)
global_settings_override = TextField(null=True)
model = CharField(column_name='model_id')
name = CharField()
product = CharField(column_name='product_id')
class Meta:
table_name = 'endpointman_template_list'
class Extensionroutes(BaseModel):
exten = CharField(constraints=[SQL("DEFAULT ''")])
route = IntegerField(column_name='route_id', constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'extensionroutes'
indexes = (
(('exten', 'route'), True),
)
primary_key = CompositeKey('exten', 'route')
class Extensions(BaseModel):
application = CharField(constraints=[SQL("DEFAULT ''")])
args = CharField(null=True)
context = CharField(constraints=[SQL("DEFAULT default")])
descr = TextField(null=True)
extension = CharField(constraints=[SQL("DEFAULT ''")])
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
priority = CharField(constraints=[SQL("DEFAULT 1")])
class Meta:
table_name = 'extensions'
indexes = (
(('context', 'extension', 'priority'), True),
)
primary_key = CompositeKey('context', 'extension', 'priority')
class FaxDetails(BaseModel):
key = CharField(null=True, unique=True)
value = CharField(null=True)
class Meta:
table_name = 'fax_details'
primary_key = False
class FaxIncoming(BaseModel):
cidnum = CharField(null=True)
destination = CharField(null=True)
detection = CharField(null=True)
detectionwait = CharField(null=True)
extension = CharField(null=True)
legacy_email = CharField(null=True)
ring = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
class Meta:
table_name = 'fax_incoming'
primary_key = False
class FaxUsers(BaseModel):
faxattachformat = CharField(null=True)
faxemail = TextField(null=True)
faxenabled = CharField(null=True)
user = CharField(null=True, unique=True)
class Meta:
table_name = 'fax_users'
primary_key = False
class Featurecodes(BaseModel):
customcode = CharField(null=True)
defaultcode = CharField(null=True)
description = CharField(constraints=[SQL("DEFAULT ''")])
enabled = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
featurename = CharField(constraints=[SQL("DEFAULT ''")])
helptext = CharField()
modulename = CharField(constraints=[SQL("DEFAULT ''")])
providedest = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'featurecodes'
indexes = (
(('modulename', 'featurename'), True),
)
primary_key = CompositeKey('featurename', 'modulename')
class Findmefollow(BaseModel):
annmsg = IntegerField(column_name='annmsg_id', null=True)
dring = CharField(null=True)
grplist = CharField()
grpnum = CharField(primary_key=True)
grppre = CharField(null=True)
grptime = IntegerField()
needsconf = CharField(null=True)
postdest = CharField(null=True)
pre_ring = IntegerField(constraints=[SQL("DEFAULT 0")])
remotealert = IntegerField(column_name='remotealert_id', null=True)
ringing = CharField(null=True)
rvolume = CharField(constraints=[SQL("DEFAULT ''")])
strategy = CharField()
toolate = IntegerField(column_name='toolate_id', null=True)
class Meta:
table_name = 'findmefollow'
class Fop2Buttoncontext(BaseModel):
id_button = AutoField()
id_context = IntegerField(null=True)
class Meta:
table_name = 'fop2ButtonContext'
class Fop2Groupbutton(BaseModel):
context = IntegerField(column_name='context_id')
group_name = CharField(null=True)
id_button = IntegerField()
class Meta:
table_name = 'fop2GroupButton'
class Fop2Permgroup(BaseModel):
context = IntegerField(column_name='context_id')
id_group = IntegerField(null=True)
name = CharField(null=True)
name_group = CharField(null=True)
class Meta:
table_name = 'fop2PermGroup'
class Fop2Usercontext(BaseModel):
id_context = IntegerField(null=True)
id_user = AutoField()
class Meta:
table_name = 'fop2UserContext'
class Fop2Usergroup(BaseModel):
context = IntegerField(column_name='context_id')
exten = CharField()
id_group = IntegerField()
class Meta:
table_name = 'fop2UserGroup'
indexes = (
(('exten', 'id_group', 'context'), True),
)
class Fop2Userplugin(BaseModel):
context = IntegerField(column_name='context_id')
exten = CharField(null=True)
id_plugin = CharField(null=True)
class Meta:
table_name = 'fop2UserPlugin'
indexes = (
(('exten', 'id_plugin'), True),
)
class Fop2Usertemplate(BaseModel):
context = IntegerField(column_name='context_id')
exten = CharField()
id_template = IntegerField()
class Meta:
table_name = 'fop2UserTemplate'
indexes = (
(('exten', 'id_template'), True),
)
class Fop2Buttons(BaseModel):
accountcode = CharField(constraints=[SQL("DEFAULT ''")], null=True)
autoanswerheader = CharField(constraints=[SQL("DEFAULT __SIPADDHEADER51=Call-Info: answer-after=0.001")])
channel = CharField(constraints=[SQL("DEFAULT ''")], null=True)
context = CharField(null=True)
context_id = IntegerField()
cssclass = CharField(constraints=[SQL("DEFAULT ''")])
customastdb = CharField(constraints=[SQL("DEFAULT ''")], null=True)
device = CharField()
email = CharField(constraints=[SQL("DEFAULT ''")])
exclude = IntegerField(constraints=[SQL("DEFAULT 0")])
exten = CharField(null=True)
extenvoicemail = CharField(constraints=[SQL("DEFAULT ''")])
external = CharField(constraints=[SQL("DEFAULT ''")], null=True)
group = CharField(constraints=[SQL("DEFAULT ''")])
label = CharField(null=True)
mailbox = CharField(null=True)
originatechannel = CharField(constraints=[SQL("DEFAULT ''")], null=True)
originatevariables = TextField()
privacy = CharField(null=True)
queuechannel = TextField(null=True)
queuecontext = CharField(constraints=[SQL("DEFAULT ''")])
server = CharField(constraints=[SQL("DEFAULT ''")])
sortorder = IntegerField(constraints=[SQL("DEFAULT 0")])
spyoptions = CharField(constraints=[SQL("DEFAULT ''")], null=True)
tags = CharField(constraints=[SQL("DEFAULT ''")], null=True)
type = CharField()
class Meta:
table_name = 'fop2buttons'
indexes = (
(('context_id', 'device'), True),
)
class Fop2Contexts(BaseModel):
context = CharField(null=True, unique=True)
exclude = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField()
class Meta:
table_name = 'fop2contexts'
class Fop2Groups(BaseModel):
context = IntegerField(column_name='context_id')
id = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField()
class Meta:
table_name = 'fop2groups'
indexes = (
(('context', 'name'), True),
(('id', 'context'), True),
)
primary_key = False
class Fop2Managerusercontext(BaseModel):
id_context = IntegerField(index=True, null=True)
id_user = IntegerField(index=True)
class Meta:
table_name = 'fop2managerUserContext'
indexes = (
(('id_user', 'id_context'), False),
)
primary_key = False
class Fop2Manageracl(BaseModel):
level = CharField(null=True)
resource = CharField(null=True, unique=True)
class Meta:
table_name = 'fop2manageracl'
class Fop2Managersecurelevel(BaseModel):
detail = CharField(null=True, unique=True)
icon = CharField(null=True)
level = AutoField()
class Meta:
table_name = 'fop2managersecurelevel'
class Fop2Managerusers(BaseModel):
level = CharField(null=True)
password = CharField(null=True)
user = CharField(null=True, unique=True)
class Meta:
table_name = 'fop2managerusers'
class Fop2Permissions(BaseModel):
context = IntegerField(column_name='context_id')
name = CharField(null=True)
permissions = CharField(null=True)
class Meta:
table_name = 'fop2permissions'
class Fop2Plugins(BaseModel):
description = TextField(null=True)
global_ = IntegerField(column_name='global', constraints=[SQL("DEFAULT 0")], null=True)
name = CharField(null=True)
rawname = CharField(null=True, unique=True)
version = CharField(null=True)
class Meta:
table_name = 'fop2plugins'
class Fop2Recordings(BaseModel):
context = CharField(null=True)
datetime = DateTimeField(null=True)
duration = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
filename = TextField(null=True)
ownerextension = CharField(null=True)
targetextension = CharField(null=True)
uniqueid = CharField(null=True, unique=True)
class Meta:
table_name = 'fop2recordings'
class Fop2Settings(BaseModel):
keyword = CharField(unique=True)
value = TextField()
class Meta:
table_name = 'fop2settings'
class Fop2Setup(BaseModel):
keyword = CharField()
parameter = CharField(constraints=[SQL("DEFAULT ''")], null=True)
value = CharField(constraints=[SQL("DEFAULT ''")], null=True)
class Meta:
table_name = 'fop2setup'
indexes = (
(('keyword', 'parameter'), True),
)
class Fop2Templates(BaseModel):
context = IntegerField(column_name='context_id')
groups = CharField(null=True)
isdefault = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
name = CharField(null=True)
permissions = CharField(null=True)
plugins = CharField(null=True)
class Meta:
table_name = 'fop2templates'
class Fop2Users(BaseModel):
context = IntegerField(column_name='context_id')
exten = CharField()
permissions = CharField(null=True)
secret = CharField()
class Meta:
table_name = 'fop2users'
indexes = (
(('exten', 'context'), True),
)
class FreepbxLog(BaseModel):
level = CharField(constraints=[SQL("DEFAULT error")])
message = TextField()
section = CharField(null=True)
status = IntegerField(constraints=[SQL("DEFAULT 0")])
time = DateTimeField(constraints=[SQL("DEFAULT 0000-00-00 00:00:00")])
class Meta:
table_name = 'freepbx_log'
indexes = (
(('time', 'level'), False),
)
class FreepbxSettings(BaseModel):
category = CharField(null=True)
defaultval = CharField(null=True)
description = TextField(null=True)
emptyok = IntegerField(constraints=[SQL("DEFAULT 1")], null=True)
hidden = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
keyword = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
level = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
module = CharField(null=True)
name = CharField(null=True)
options = TextField(null=True)
readonly = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
sortorder = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
type = CharField(null=True)
value = CharField(null=True)
class Meta:
table_name = 'freepbx_settings'
class Globals(BaseModel):
value = CharField()
variable = CharField(primary_key=True)
class Meta:
table_name = 'globals'
class Hotelwakeup(BaseModel):
application = CharField(null=True)
cid = CharField(null=True)
cnam = CharField(null=True)
data = CharField(null=True)
extensionlength = IntegerField()
maxretries = AutoField()
operator_extensions = CharField(null=True)
operator_mode = IntegerField()
retrytime = IntegerField()
waittime = IntegerField()
class Meta:
table_name = 'hotelwakeup'
class HotelwakeupCalls(BaseModel):
application = CharField(null=True)
cid = CharField(null=True)
cnam = CharField(null=True)
data = CharField(null=True)
ext = IntegerField()
filename = CharField(null=True)
frequency = IntegerField()
maxretries = IntegerField()
outdir = CharField(null=True)
retrytime = IntegerField()
tempdir = CharField(null=True)
time = AutoField()
waittime = IntegerField()
class Meta:
table_name = 'hotelwakeup_calls'
class Iax(BaseModel):
data = CharField()
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT -1")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'iax'
indexes = (
(('id', 'keyword'), True),
)
primary_key = CompositeKey('id', 'keyword')
class Iaxsettings(BaseModel):
data = CharField(constraints=[SQL("DEFAULT ''")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
seq = IntegerField(constraints=[SQL("DEFAULT 0")])
type = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'iaxsettings'
indexes = (
(('keyword', 'seq', 'type'), True),
)
primary_key = CompositeKey('keyword', 'seq', 'type')
class Incoming(BaseModel):
alertinfo = CharField(constraints=[SQL("DEFAULT ''")], null=True)
cidnum = CharField(constraints=[SQL("DEFAULT ''")], null=True)
delay_answer = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
description = CharField(constraints=[SQL("DEFAULT ''")], null=True)
destination = CharField(constraints=[SQL("DEFAULT ''")], null=True)
extension = CharField()
grppre = CharField(constraints=[SQL("DEFAULT ''")], null=True)
mohclass = CharField(constraints=[SQL("DEFAULT default")])
pmmaxretries = CharField(constraints=[SQL("DEFAULT ''")], null=True)
pmminlength = CharField(constraints=[SQL("DEFAULT ''")], null=True)
pricid = CharField(constraints=[SQL("DEFAULT ''")], null=True)
privacyman = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
reversal = CharField(constraints=[SQL("DEFAULT ''")], null=True)
ringing = CharField(constraints=[SQL("DEFAULT ''")], null=True)
rvolume = CharField(constraints=[SQL("DEFAULT 0")], null=True)
class Meta:
table_name = 'incoming'
class IndicationsZonelist(BaseModel):
conf = TextField(null=True)
iso = CharField(primary_key=True)
name = CharField()
class Meta:
table_name = 'indications_zonelist'
class IvrDetails(BaseModel):
alertinfo = CharField(null=True)
announcement = IntegerField(null=True)
description = CharField(null=True)
directdial = CharField(null=True)
invalid_append_announce = IntegerField(constraints=[SQL("DEFAULT 1")])
invalid_destination = CharField(null=True)
invalid_ivr_ret = IntegerField(constraints=[SQL("DEFAULT 0")])
invalid_loops = CharField(null=True)
invalid_recording = CharField(null=True)
invalid_retry_recording = CharField(null=True)
name = CharField(null=True)
retvm = CharField(null=True)
rvolume = CharField(constraints=[SQL("DEFAULT ''")])
timeout_append_announce = IntegerField(constraints=[SQL("DEFAULT 1")])
timeout_destination = CharField(null=True)
timeout_enabled = CharField(null=True)
timeout_ivr_ret = IntegerField(constraints=[SQL("DEFAULT 0")])
timeout_loops = CharField(null=True)
timeout_recording = CharField(null=True)
timeout_retry_recording = CharField(null=True)
timeout_time = IntegerField(null=True)
class Meta:
table_name = 'ivr_details'
class IvrEntries(BaseModel):
dest = CharField(null=True)
ivr = IntegerField(column_name='ivr_id')
ivr_ret = IntegerField(constraints=[SQL("DEFAULT 0")])
selection = CharField(null=True)
class Meta:
table_name = 'ivr_entries'
primary_key = False
class Kvstore(BaseModel):
id = CharField(null=True)
key = CharField(index=True)
module = CharField()
type = CharField(null=True)
val = TextField(null=True)
class Meta:
table_name = 'kvstore'
indexes = (
(('module', 'id'), False),
(('module', 'key', 'id'), True),
)
primary_key = False
class LanguageIncoming(BaseModel):
cidnum = CharField(null=True)
extension = CharField(null=True)
language = CharField(null=True)
class Meta:
table_name = 'language_incoming'
primary_key = False
class Languages(BaseModel):
description = CharField(null=True)
dest = CharField(null=True)
lang_code = CharField(null=True)
language = AutoField(column_name='language_id')
class Meta:
table_name = 'languages'
class LogfileLogfiles(BaseModel):
debug = CharField(null=True)
dtmf = CharField(null=True)
error = CharField(null=True)
fax = CharField(null=True)
name = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
notice = CharField(null=True)
security = CharField(null=True)
verbose = CharField(null=True)
warning = CharField(null=True)
class Meta:
table_name = 'logfile_logfiles'
class LogfileSettings(BaseModel):
key = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
value = CharField(null=True)
class Meta:
table_name = 'logfile_settings'
class Manager(BaseModel):
deny = CharField(null=True)
manager = AutoField(column_name='manager_id')
name = CharField()
permit = CharField(null=True)
read = CharField(null=True)
secret = CharField(null=True)
write = CharField(null=True)
writetimeout = IntegerField(null=True)
class Meta:
table_name = 'manager'
class Meetme(BaseModel):
adminpin = CharField(null=True)
description = CharField(null=True)
exten = CharField(primary_key=True)
joinmsg = IntegerField(column_name='joinmsg_id', null=True)
language = CharField(constraints=[SQL("DEFAULT ''")])
music = CharField(null=True)
options = CharField(null=True)
timeout = IntegerField(constraints=[SQL("DEFAULT 21600")], null=True)
userpin = CharField(null=True)
users = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
class Meta:
table_name = 'meetme'
class Miscapps(BaseModel):
description = CharField(null=True)
dest = CharField(null=True)
ext = CharField(null=True)
miscapps = AutoField(column_name='miscapps_id')
class Meta:
table_name = 'miscapps'
class Miscdests(BaseModel):
description = CharField()
destdial = CharField()
class Meta:
table_name = 'miscdests'
class ModuleXml(BaseModel):
data = TextField(null=True)
id = CharField(constraints=[SQL("DEFAULT xml")], primary_key=True)
time = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'module_xml'
class Modules(BaseModel):
enabled = IntegerField(constraints=[SQL("DEFAULT 0")])
modulename = CharField(constraints=[SQL("DEFAULT ''")])
signature = TextField(null=True)
version = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'modules'
class Motif(BaseModel):
authmode = CharField(constraints=[SQL("DEFAULT plaintext")])
oauth_clientid = CharField()
oauth_secret = CharField()
password = CharField()
phonenum = CharField()
priority = IntegerField(constraints=[SQL("DEFAULT 127")])
refresh_token = CharField()
settings = TextField()
statusmessage = CharField()
type = CharField(constraints=[SQL("DEFAULT googlevoice")])
username = CharField()
class Meta:
table_name = 'motif'
class Music(BaseModel):
application = CharField(null=True)
category = CharField(null=True, unique=True)
format = CharField(null=True)
random = IntegerField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'music'
class Notifications(BaseModel):
candelete = IntegerField(constraints=[SQL("DEFAULT 0")])
display_text = CharField(constraints=[SQL("DEFAULT ''")])
extended_text = TextField()
id = CharField(constraints=[SQL("DEFAULT ''")])
level = IntegerField(constraints=[SQL("DEFAULT 0")])
link = CharField(constraints=[SQL("DEFAULT ''")])
module = CharField(constraints=[SQL("DEFAULT ''")])
reset = IntegerField(constraints=[SQL("DEFAULT 0")])
timestamp = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'notifications'
indexes = (
(('module', 'id'), True),
)
primary_key = CompositeKey('id', 'module')
class OutboundRoutePatterns(BaseModel):
match_cid = CharField(constraints=[SQL("DEFAULT ''")])
match_pattern_pass = CharField(constraints=[SQL("DEFAULT ''")])
match_pattern_prefix = CharField(constraints=[SQL("DEFAULT ''")])
prepend_digits = CharField(constraints=[SQL("DEFAULT ''")])
route = IntegerField(column_name='route_id')
class Meta:
table_name = 'outbound_route_patterns'
indexes = (
(('route', 'match_pattern_prefix', 'match_pattern_pass', 'match_cid', 'prepend_digits'), True),
)
primary_key = CompositeKey('match_cid', 'match_pattern_pass', 'match_pattern_prefix', 'prepend_digits', 'route')
class OutboundRouteSequence(BaseModel):
route = IntegerField(column_name='route_id')
seq = IntegerField()
class Meta:
table_name = 'outbound_route_sequence'
indexes = (
(('route', 'seq'), True),
)
primary_key = CompositeKey('route', 'seq')
class OutboundRouteTrunks(BaseModel):
route = IntegerField(column_name='route_id')
seq = IntegerField()
trunk = IntegerField(column_name='trunk_id')
class Meta:
table_name = 'outbound_route_trunks'
indexes = (
(('route', 'trunk', 'seq'), True),
)
primary_key = CompositeKey('route', 'seq', 'trunk')
class OutboundRoutes(BaseModel):
dest = CharField(null=True)
emergency_route = CharField(null=True)
intracompany_route = CharField(null=True)
mohclass = CharField(null=True)
name = CharField(null=True)
outcid = CharField(null=True)
outcid_mode = CharField(null=True)
password = CharField(null=True)
route = AutoField(column_name='route_id')
time_group = IntegerField(column_name='time_group_id', null=True)
class Meta:
table_name = 'outbound_routes'
class Outroutemsg(BaseModel):
data = CharField()
keyword = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
class Meta:
table_name = 'outroutemsg'
class PagingAutoanswer(BaseModel):
setting = CharField()
useragent = CharField()
var = CharField()
class Meta:
table_name = 'paging_autoanswer'
indexes = (
(('useragent', 'var'), True),
)
primary_key = CompositeKey('useragent', 'var')
class PagingConfig(BaseModel):
announcement = CharField(null=True)
description = CharField(constraints=[SQL("DEFAULT ''")])
duplex = IntegerField(constraints=[SQL("DEFAULT 0")])
force_page = IntegerField()
page_group = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
volume = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'paging_config'
class PagingGroups(BaseModel):
ext = CharField(constraints=[SQL("DEFAULT ''")])
page_number = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'paging_groups'
indexes = (
(('page_number', 'ext'), True),
)
primary_key = CompositeKey('ext', 'page_number')
class Parkplus(BaseModel):
alertinfo = CharField(constraints=[SQL("DEFAULT ''")])
announcement = IntegerField(column_name='announcement_id', null=True)
autocidpp = CharField(constraints=[SQL("DEFAULT none")])
cidpp = CharField(constraints=[SQL("DEFAULT ''")])
comebacktoorigin = CharField(constraints=[SQL("DEFAULT yes")])
defaultlot = CharField(constraints=[SQL("DEFAULT no")])
dest = CharField(constraints=[SQL("DEFAULT app-blackhole,hangup,1")])
findslot = CharField(constraints=[SQL("DEFAULT first")])
generatefc = CharField(constraints=[SQL("DEFAULT yes")])
id = BigAutoField()
name = CharField(constraints=[SQL("DEFAULT ''")])
numslots = IntegerField(constraints=[SQL("DEFAULT 4")])
parkedcallreparking = CharField(constraints=[SQL("DEFAULT caller")])
parkedcalltransfers = CharField(constraints=[SQL("DEFAULT caller")])
parkedmusicclass = CharField(constraints=[SQL("DEFAULT default")], null=True)
parkedplay = CharField(constraints=[SQL("DEFAULT both")])
parkext = CharField(constraints=[SQL("DEFAULT ''")])
parkingtime = IntegerField(constraints=[SQL("DEFAULT 45")])
parkpos = CharField(constraints=[SQL("DEFAULT ''")])
rvolume = CharField(constraints=[SQL("DEFAULT ''")])
type = CharField(constraints=[SQL("DEFAULT public")])
class Meta:
table_name = 'parkplus'
class ParkplusAnnounce(BaseModel):
announce_order = TextField(null=True)
announce_repeat = IntegerField(null=True)
announceext = CharField(constraints=[SQL("DEFAULT ''")])
autocidpp = CharField(constraints=[SQL("DEFAULT none")])
cidpp = CharField(constraints=[SQL("DEFAULT ''")])
comebacktoorigin = CharField(constraints=[SQL("DEFAULT yes")])
dest = CharField(constraints=[SQL("DEFAULT ''")])
failure_recording = CharField(column_name='failure_recording_id', null=True)
name = CharField(constraints=[SQL("DEFAULT ''")])
page_announcement = CharField(column_name='page_announcement_id', null=True)
page_announcement_id_1 = CharField(null=True)
page_announcement_id_2 = CharField(null=True)
page_announcement_id_3 = CharField(null=True)
page = CharField(column_name='page_id')
page_timer_extend = IntegerField(constraints=[SQL("DEFAULT 0")])
park = IntegerField(column_name='park_id')
parkingretry = IntegerField(constraints=[SQL("DEFAULT 1")])
parkingtime = IntegerField(constraints=[SQL("DEFAULT 45")])
parkingtime_enable = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
primary_announcement = CharField(column_name='primary_announcement_id', null=True)
record_announcement = CharField(column_name='record_announcement_id', null=True)
record_message = CharField(constraints=[SQL("DEFAULT no")])
record_message_length = IntegerField(constraints=[SQL("DEFAULT 5")], null=True)
record_message_silence = IntegerField(constraints=[SQL("DEFAULT 3")], null=True)
replace_announcement = CharField(column_name='replace_announcement_id', null=True)
slot_announce_enable = CharField(constraints=[SQL("DEFAULT yes")])
successful_recording = CharField(column_name='successful_recording_id', null=True)
class Meta:
table_name = 'parkplus_announce'
class ParkplusDevice(BaseModel):
device = CharField(column_name='device_id', primary_key=True)
parkplus = IntegerField(column_name='parkplus_id', constraints=[SQL("DEFAULT 1")])
class Meta:
table_name = 'parkplus_device'
class Phpagiconf(BaseModel):
asman_port = IntegerField()
asman_secret = CharField(null=True)
asman_server = CharField(null=True)
asman_user = CharField(null=True)
basedir = CharField(null=True)
cepstral_swift = CharField(null=True)
cepstral_voice = CharField(null=True)
debug = IntegerField(null=True)
err_email = CharField(null=True)
error_handler = IntegerField(null=True)
festival_text2wave = CharField(null=True)
hostname = CharField(null=True)
phpagiid = AutoField()
setuid = IntegerField(null=True)
tempdir = CharField(null=True)
class Meta:
table_name = 'phpagiconf'
class PinsetUsage(BaseModel):
dispname = CharField(constraints=[SQL("DEFAULT ''")])
foreign = CharField(column_name='foreign_id', constraints=[SQL("DEFAULT ''")])
pinsets = IntegerField(column_name='pinsets_id')
class Meta:
table_name = 'pinset_usage'
indexes = (
(('dispname', 'foreign'), True),
)
primary_key = CompositeKey('dispname', 'foreign')
class Pinsets(BaseModel):
addtocdr = IntegerField(null=True)
deptname = CharField(null=True)
description = CharField(null=True)
passwords = TextField(null=True)
pinsets = AutoField(column_name='pinsets_id')
class Meta:
table_name = 'pinsets'
class Pjsip(BaseModel):
data = CharField()
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT -1")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'pjsip'
indexes = (
(('id', 'keyword'), True),
)
primary_key = CompositeKey('id', 'keyword')
class PmsBanner(BaseModel):
image = CharField()
label = CharField()
title = CharField()
class Meta:
table_name = 'pms_banner'
class PmsBooking(BaseModel):
booking_number = CharField()
canceled = IntegerField()
checked_in = IntegerField()
comments = CharField()
confirmed = IntegerField()
date_ci = IntegerField()
date_co = IntegerField()
guest = CharField(column_name='guest_id')
money_advance = CharField()
num_guest = IntegerField(constraints=[SQL("DEFAULT 1")])
payment_mode = CharField()
payment_mode_b = CharField()
room = CharField(column_name='room_id')
class Meta:
table_name = 'pms_booking'
class PmsCalendar(BaseModel):
datefield = DateField(null=True)
class Meta:
table_name = 'pms_calendar'
primary_key = False
class PmsCharges(BaseModel):
formula = CharField()
label = CharField()
value = DecimalField()
class Meta:
table_name = 'pms_charges'
class PmsConfig(BaseModel):
body = CharField()
cbr = IntegerField(constraints=[SQL("DEFAULT 1")])
company = CharField()
cos = IntegerField()
cosci = CharField()
cosco = CharField()
currency = CharField(constraints=[SQL("DEFAULT en_US")])
discount = DecimalField(constraints=[SQL("DEFAULT 0.00")])
emergency = CharField()
from_name = CharField()
hpms_dir = CharField()
ip_address = CharField()
locked = IntegerField(constraints=[SQL("DEFAULT 1")])
logo = CharField()
logo64 = TextField()
mail = CharField()
o_m = CharField(constraints=[SQL("DEFAULT Hotel")], primary_key=True)
port = IntegerField()
reception = CharField()
rmbc = IntegerField(constraints=[SQL("DEFAULT 1")])
rounded = IntegerField(constraints=[SQL("DEFAULT 0")])
subject = CharField()
ticket_body = CharField()
ticket_footer = CharField()
ticket_header = CharField()
tourist_tax = DecimalField(constraints=[SQL("DEFAULT 0.00")])
version = CharField()
class Meta:
table_name = 'pms_config'
class PmsCosOracle(BaseModel):
cs0 = CharField()
cs1 = CharField()
cs2 = CharField()
cs3 = CharField()
class Meta:
table_name = 'pms_cos_oracle'
primary_key = False
class PmsGuest(BaseModel):
nif = CharField(column_name='NIF')
off_doc = CharField(column_name='Off_Doc')
address = CharField()
city = CharField()
comments = CharField()
cp = CharField()
fax = CharField()
first_name = CharField()
lang = CharField()
last_name = CharField()
mail = CharField()
mobile = CharField()
phone = CharField()
class Meta:
table_name = 'pms_guest'
class PmsMaidServices(BaseModel):
file = CharField()
label = CharField()
priority_level = CharField()
service_number = CharField()
class Meta:
table_name = 'pms_maid_services'
class PmsMinibar(BaseModel):
charge = IntegerField()
digit = IntegerField()
label = CharField()
price = DecimalField()
vat = DecimalField(constraints=[SQL("DEFAULT 0.00")])
class Meta:
table_name = 'pms_minibar'
primary_key = False
class PmsModels(BaseModel):
room_description = CharField()
room_guest = DecimalField(constraints=[SQL("DEFAULT 0.00")])
room_model = CharField()
room_price = DecimalField(constraints=[SQL("DEFAULT 0.00")])
room_vat = DecimalField()
class Meta:
table_name = 'pms_models'
primary_key = False
class PmsPrivileges(BaseModel):
pms_grp = CharField()
users_grp = CharField()
class Meta:
table_name = 'pms_privileges'
class PmsRatesObrt(BaseModel):
fixed_charge = DecimalField()
increment = IntegerField()
mask = IntegerField()
obrt = CharField()
price = DecimalField()
taxe = DecimalField()
class Meta:
table_name = 'pms_rates_obrt'
class PmsRegister(BaseModel):
billing_file = CharField()
booking_number = CharField()
date_ci = IntegerField()
date_co = IntegerField()
guest = CharField(column_name='guest_id')
invoice_number = CharField()
money_advance = CharField()
num_guest = IntegerField(constraints=[SQL("DEFAULT 1")])
paid = IntegerField()
payment_mode = CharField()
payment_mode_b = CharField()
restaurant = DecimalField()
room = CharField(column_name='room_id')
status = IntegerField()
total_bar = DecimalField()
total_billing = DecimalField()
total_call = DecimalField()
total_room = DecimalField()
vm_pwd = IntegerField()
class Meta:
table_name = 'pms_register'
class PmsRestSales(BaseModel):
charge = DecimalField()
date = CharField()
guest = CharField()
price = DecimalField()
product = CharField()
room = CharField()
class Meta:
table_name = 'pms_rest_sales'
class PmsRestaurant(BaseModel):
charge = IntegerField()
image = CharField()
label = CharField()
price = DecimalField()
ref = CharField()
type = CharField()
class Meta:
table_name = 'pms_restaurant'
class PmsRooms(BaseModel):
raci = CharField(column_name='RACI')
raco = CharField(column_name='RACO')
clean = IntegerField(constraints=[SQL("DEFAULT 1")])
cos = CharField(constraints=[SQL("DEFAULT 128")])
extension = CharField()
free = IntegerField(constraints=[SQL("DEFAULT 1")])
groupe = CharField()
guest_name = CharField()
guest_number = CharField()
job = CharField()
last_call = CharField()
mini_bar = CharField()
model = CharField()
room_name = CharField()
class Meta:
table_name = 'pms_rooms'
class PmsSchedDiscounting(BaseModel):
date = CharField()
label = CharField()
rate = DecimalField()
class Meta:
table_name = 'pms_sched_discounting'
primary_key = False
class PmsSchedRoom(BaseModel):
date = CharField()
label = CharField()
price = DecimalField()
type = CharField()
class Meta:
table_name = 'pms_sched_room'
primary_key = False
class PmsStatus(BaseModel):
booking = IntegerField()
busy = IntegerField()
canceled = IntegerField()
confirmed = IntegerField()
date = CharField(unique=True)
free = IntegerField()
class Meta:
table_name = 'pms_status'
primary_key = False
class PresencestateList(BaseModel):
message = CharField(null=True)
type = CharField(null=True)
class Meta:
table_name = 'presencestate_list'
class PresencestatePrefs(BaseModel):
extension = CharField()
item = IntegerField(column_name='item_id')
pref = CharField(null=True)
class Meta:
table_name = 'presencestate_prefs'
indexes = (
(('extension', 'item'), True),
)
primary_key = CompositeKey('extension', 'item')
class Prosody(BaseModel):
host = TextField(null=True)
key = TextField(null=True)
store = TextField(null=True)
type = TextField(null=True)
user = TextField(null=True)
value = TextField(null=True)
class Meta:
table_name = 'prosody'
indexes = (
(('host', 'user', 'store', 'key'), False),
)
primary_key = False
class QueuemetricsOptions(BaseModel):
keyword = CharField(null=True, unique=True)
value = TextField(null=True)
class Meta:
table_name = 'queuemetrics_options'
primary_key = False
class Queueprio(BaseModel):
description = CharField(null=True)
dest = CharField(null=True)
queue_priority = CharField(null=True)
queueprio = AutoField(column_name='queueprio_id')
class Meta:
table_name = 'queueprio'
class QueuesConfig(BaseModel):
agentannounce = IntegerField(column_name='agentannounce_id', null=True)
alertinfo = CharField(constraints=[SQL("DEFAULT ''")])
callback = CharField(column_name='callback_id', constraints=[SQL("DEFAULT ''")])
callconfirm = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
callconfirm_id = IntegerField(null=True)
cwignore = IntegerField(constraints=[SQL("DEFAULT 0")])
descr = CharField(constraints=[SQL("DEFAULT ''")])
dest = CharField(constraints=[SQL("DEFAULT ''")])
extension = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
grppre = CharField(constraints=[SQL("DEFAULT ''")])
ivr = CharField(column_name='ivr_id', constraints=[SQL("DEFAULT 0")])
joinannounce = IntegerField(column_name='joinannounce_id', null=True)
maxwait = CharField(constraints=[SQL("DEFAULT ''")])
monitor_heard = IntegerField(null=True)
monitor_spoken = IntegerField(null=True)
monitor_type = CharField(null=True)
password = CharField(constraints=[SQL("DEFAULT ''")])
qnoanswer = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
qregex = CharField(null=True)
queuewait = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
ringing = IntegerField(constraints=[SQL("DEFAULT 0")])
togglehint = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
use_queue_context = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
class Meta:
table_name = 'queues_config'
class QueuesDetails(BaseModel):
data = CharField(constraints=[SQL("DEFAULT ''")])
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT -1")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'queues_details'
indexes = (
(('id', 'keyword', 'data'), True),
)
primary_key = CompositeKey('data', 'id', 'keyword')
class QxactAgentActions(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")], index=True)
channel = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")])
extension = CharField(constraints=[SQL("DEFAULT ''")])
logintime = IntegerField(constraints=[SQL("DEFAULT 0")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
reason = CharField(constraints=[SQL("DEFAULT ''")])
time = IntegerField(index=True, null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'qxact_agent_actions'
class QxactAgentActionsOld(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")])
channel = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")])
extension = CharField(constraints=[SQL("DEFAULT ''")])
logintime = IntegerField(constraints=[SQL("DEFAULT 0")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
reason = CharField(constraints=[SQL("DEFAULT ''")])
time = IntegerField(null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'qxact_agent_actions_old'
class QxactAgentCalls(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
ringtime = IntegerField(constraints=[SQL("DEFAULT 0")])
time = IntegerField(null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'qxact_agent_calls'
class QxactAgentCallsOld(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
ringtime = IntegerField(constraints=[SQL("DEFAULT 0")])
time = IntegerField(null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'qxact_agent_calls_old'
class QxactCalls(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")], index=True)
callerid = CharField(constraints=[SQL("DEFAULT ''")])
calltime = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
did = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")], index=True)
key = IntegerField(constraints=[SQL("DEFAULT -1")])
origpos = IntegerField(constraints=[SQL("DEFAULT 0")])
position = IntegerField(constraints=[SQL("DEFAULT 0")])
queuename = CharField(constraints=[SQL("DEFAULT ''")], index=True)
time = IntegerField(index=True, null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")], index=True)
waittime = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
class Meta:
table_name = 'qxact_calls'
class QxactCallsOld(BaseModel):
agent = CharField(constraints=[SQL("DEFAULT ''")], index=True)
callerid = CharField(constraints=[SQL("DEFAULT ''")])
calltime = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
did = CharField(constraints=[SQL("DEFAULT ''")])
event = CharField(constraints=[SQL("DEFAULT ''")], index=True)
key = IntegerField(constraints=[SQL("DEFAULT -1")])
origpos = IntegerField(constraints=[SQL("DEFAULT 0")])
position = IntegerField(constraints=[SQL("DEFAULT 0")])
queuename = CharField(constraints=[SQL("DEFAULT ''")], index=True)
time = IntegerField(index=True, null=True)
uniqueid = CharField(constraints=[SQL("DEFAULT ''")], index=True)
waittime = IntegerField(constraints=[SQL("DEFAULT 0")], index=True)
class Meta:
table_name = 'qxact_calls_old'
class QxactReports(BaseModel):
data = TextField(null=True)
name = CharField(constraints=[SQL("DEFAULT UNNAMED REPORT")])
class Meta:
table_name = 'qxact_reports'
class QxactReportsOld(BaseModel):
data = TextField(null=True)
name = CharField(constraints=[SQL("DEFAULT UNNAMED REPORT")])
class Meta:
table_name = 'qxact_reports_old'
class QxactSystemEvents(BaseModel):
event = CharField(constraints=[SQL("DEFAULT ''")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
time = IntegerField(null=True)
class Meta:
table_name = 'qxact_system_events'
class QxactSystemEventsOld(BaseModel):
event = CharField(constraints=[SQL("DEFAULT ''")])
queuename = CharField(constraints=[SQL("DEFAULT ''")])
time = IntegerField(null=True)
class Meta:
table_name = 'qxact_system_events_old'
class RecordingReport(BaseModel):
key = CharField(null=True, unique=True)
value = TextField(null=True)
class Meta:
table_name = 'recording_report'
primary_key = False
class Recordings(BaseModel):
description = CharField(null=True)
displayname = CharField(null=True)
fcode = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
fcode_pass = CharField(null=True)
filename = TextField(null=True)
class Meta:
table_name = 'recordings'
class RestapiGeneral(BaseModel):
keyword = CharField(null=True, unique=True)
value = CharField(null=True)
class Meta:
table_name = 'restapi_general'
primary_key = False
class RestapiLogEventDetails(BaseModel):
data = TextField(null=True)
e = IntegerField(column_name='e_id', index=True, null=True)
event = CharField(null=True)
id = IntegerField(unique=True)
time = IntegerField(null=True)
trigger = TextField(null=True)
class Meta:
table_name = 'restapi_log_event_details'
primary_key = False
class RestapiLogEvents(BaseModel):
id = IntegerField(unique=True)
ip = CharField(null=True)
server = CharField(null=True)
signature = CharField(null=True)
time = IntegerField(index=True, null=True)
token = CharField(index=True, null=True)
class Meta:
table_name = 'restapi_log_events'
primary_key = False
class RestapiTokenDetails(BaseModel):
key = CharField(null=True)
token = IntegerField(column_name='token_id', null=True)
value = TextField(null=True)
class Meta:
table_name = 'restapi_token_details'
primary_key = False
class RestapiTokenUserMapping(BaseModel):
token = IntegerField(column_name='token_id', null=True)
user = CharField(null=True)
class Meta:
table_name = 'restapi_token_user_mapping'
primary_key = False
class RestapiTokens(BaseModel):
desc = CharField(null=True)
id = IntegerField(unique=True)
name = CharField(null=True)
class Meta:
table_name = 'restapi_tokens'
primary_key = False
class RestappsSettings(BaseModel):
key = CharField(constraints=[SQL("DEFAULT ''")])
module = CharField(constraints=[SQL("DEFAULT ''")])
value = CharField(null=True)
class Meta:
table_name = 'restapps_settings'
indexes = (
(('module', 'key'), True),
)
primary_key = CompositeKey('key', 'module')
class RestappsStats(BaseModel):
application = CharField()
brand = CharField()
model = CharField()
page = CharField()
timestamp = IntegerField(null=True)
class Meta:
table_name = 'restapps_stats'
primary_key = False
class Ringgroups(BaseModel):
alertinfo = CharField(null=True)
annmsg = IntegerField(column_name='annmsg_id', null=True)
cfignore = CharField(null=True)
cpickup = CharField(null=True)
cwignore = CharField(null=True)
description = CharField()
elsewhere = CharField(null=True)
grplist = CharField()
grpnum = CharField(primary_key=True)
grppre = CharField(null=True)
grptime = IntegerField()
needsconf = CharField(null=True)
postdest = CharField(null=True)
progress = CharField(null=True)
recording = CharField(constraints=[SQL("DEFAULT dontcare")], null=True)
remotealert = IntegerField(column_name='remotealert_id', null=True)
ringing = CharField(null=True)
rvolume = CharField(constraints=[SQL("DEFAULT ''")])
strategy = CharField()
toolate = IntegerField(column_name='toolate_id', null=True)
class Meta:
table_name = 'ringgroups'
class RvmCallback(BaseModel):
caller_id_number = CharField()
description = CharField()
ts_added = DateTimeField(null=True)
class Meta:
table_name = 'rvm_callback'
class SangomacrmRestRows(BaseModel):
calldate = IntegerField(null=True)
cnam = CharField(null=True)
cnum = CharField(null=True)
destination = CharField(null=True)
direction = CharField(null=True)
exttocall = CharField(null=True)
owner = CharField(null=True)
recordingfile = CharField(null=True)
source = CharField(null=True)
type = CharField(null=True)
uuid = CharField(null=True)
voicemailfile = CharField(null=True)
zulu_type = CharField(null=True)
class Meta:
table_name = 'sangomacrm_rest_rows'
primary_key = False
class SangomacrmRestWebhooks(BaseModel):
direction = CharField()
url = CharField()
class Meta:
table_name = 'sangomacrm_rest_webhooks'
class SangomarcrmSalesforceUsers(BaseModel):
email = CharField()
first_name = CharField()
last_name = CharField()
uid = IntegerField(null=True)
username = CharField()
uuid = CharField(primary_key=True)
class Meta:
table_name = 'sangomarcrm_salesforce_users'
class SangomarcrmSuitecrmUsers(BaseModel):
first_name = CharField()
last_name = CharField()
uid = IntegerField(null=True)
username = CharField()
uuid = CharField(primary_key=True)
class Meta:
table_name = 'sangomarcrm_suitecrm_users'
class SangomarcrmZohoUsers(BaseModel):
email = CharField()
first_name = CharField()
last_name = CharField()
uid = IntegerField(null=True)
username = CharField()
uuid = CharField(primary_key=True)
class Meta:
table_name = 'sangomarcrm_zoho_users'
class Setcid(BaseModel):
cid = AutoField(column_name='cid_id')
cid_name = CharField(null=True)
cid_num = CharField(null=True)
description = CharField(null=True)
dest = CharField(null=True)
class Meta:
table_name = 'setcid'
class Sip(BaseModel):
data = CharField()
flags = IntegerField(constraints=[SQL("DEFAULT 0")])
id = CharField(constraints=[SQL("DEFAULT -1")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'sip'
indexes = (
(('id', 'keyword'), True),
)
primary_key = CompositeKey('id', 'keyword')
class Sipsettings(BaseModel):
data = CharField(constraints=[SQL("DEFAULT ''")])
keyword = CharField(constraints=[SQL("DEFAULT ''")])
seq = IntegerField(constraints=[SQL("DEFAULT 0")])
type = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'sipsettings'
indexes = (
(('keyword', 'seq', 'type'), True),
)
primary_key = CompositeKey('keyword', 'seq', 'type')
class SmsDids(BaseModel):
did = CharField(unique=True)
class Meta:
table_name = 'sms_dids'
class SmsMedia(BaseModel):
mid = IntegerField()
name = CharField()
raw = TextField()
class Meta:
table_name = 'sms_media'
class SoundlangCustomlangs(BaseModel):
description = CharField()
language = CharField()
class Meta:
table_name = 'soundlang_customlangs'
class SoundlangPackages(BaseModel):
author = CharField(null=True)
authorlink = CharField(null=True)
format = CharField()
id = BigAutoField()
installed = CharField(null=True)
language = CharField()
license = TextField(null=True)
module = CharField()
type = CharField()
version = CharField(null=True)
class Meta:
table_name = 'soundlang_packages'
indexes = (
(('type', 'module', 'language', 'format'), True),
)
class SoundlangPrompts(BaseModel):
filename = CharField(null=True)
format = CharField()
language = CharField()
module = CharField()
type = CharField()
class Meta:
table_name = 'soundlang_prompts'
primary_key = False
class SoundlangSettings(BaseModel):
keyword = CharField(primary_key=True)
value = CharField()
class Meta:
table_name = 'soundlang_settings'
class SuperfectaMf(BaseModel):
cidnum = CharField(null=True)
debug = IntegerField(null=True)
extension = CharField(null=True)
prefix = CharField(null=True)
scheme = CharField(null=True)
spam_child = BigIntegerField(column_name='spam_child_id', null=True)
superfecta_mf = BigAutoField(column_name='superfecta_mf_id')
timestamp_end = FloatField(null=True)
timestamp_start = FloatField(index=True, null=True)
winning_child = BigIntegerField(column_name='winning_child_id', null=True)
class Meta:
table_name = 'superfecta_mf'
class SuperfectaMfChild(BaseModel):
cached = IntegerField(null=True)
cnam = CharField(null=True)
debug_result = TextField(null=True)
error_result = TextField(null=True)
priority = IntegerField(null=True)
source = CharField(null=True)
spam = IntegerField(null=True)
spam_text = CharField(null=True)
superfecta_mf_child = BigAutoField(column_name='superfecta_mf_child_id')
superfecta_mf = BigIntegerField(column_name='superfecta_mf_id', index=True, null=True)
timestamp_cnam = FloatField(null=True)
timestamp_end = FloatField(null=True)
timestamp_start = FloatField(index=True, null=True)
class Meta:
table_name = 'superfecta_mf_child'
class SuperfectaToIncoming(BaseModel):
cidnum = CharField(null=True)
extension = CharField(null=True)
scheme = CharField()
superfecta_to_incoming = BigAutoField(column_name='superfecta_to_incoming_id')
class Meta:
table_name = 'superfecta_to_incoming'
indexes = (
(('extension', 'cidnum'), True),
)
class Superfectacache(BaseModel):
callerid = CharField()
dateentered = DateTimeField()
number = BigAutoField()
class Meta:
table_name = 'superfectacache'
class Superfectaconfig(BaseModel):
field = CharField()
source = CharField()
value = TextField(null=True)
class Meta:
table_name = 'superfectaconfig'
indexes = (
(('source', 'field'), True),
)
primary_key = CompositeKey('field', 'source')
class SysadminOptions(BaseModel):
key = CharField(null=True, unique=True)
value = TextField(null=True)
class Meta:
table_name = 'sysadmin_options'
primary_key = False
class SysadminUpdateLog(BaseModel):
status = CharField(null=True)
status_id = IntegerField(null=True)
time = BigIntegerField(null=True)
version = CharField(null=True)
class Meta:
table_name = 'sysadmin_update_log'
class Timeconditions(BaseModel):
deptname = CharField(null=True)
displayname = CharField(null=True)
falsegoto = CharField(null=True)
fcc_password = CharField(constraints=[SQL("DEFAULT ''")], null=True)
generate_hint = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
invert_hint = IntegerField(constraints=[SQL("DEFAULT 0")], null=True)
priority = CharField(constraints=[SQL("DEFAULT 0")])
time = IntegerField(null=True)
timeconditions = AutoField(column_name='timeconditions_id')
timezone = CharField(constraints=[SQL("DEFAULT ''")], null=True)
truegoto = CharField(null=True)
class Meta:
table_name = 'timeconditions'
class TimegroupsDetails(BaseModel):
time = CharField(constraints=[SQL("DEFAULT ''")])
timegroupid = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'timegroups_details'
class TimegroupsGroups(BaseModel):
description = CharField(constraints=[SQL("DEFAULT ''")], unique=True)
class Meta:
table_name = 'timegroups_groups'
class TrunkDialpatterns(BaseModel):
match_pattern_pass = CharField(constraints=[SQL("DEFAULT ''")])
match_pattern_prefix = CharField(constraints=[SQL("DEFAULT ''")])
prepend_digits = CharField(constraints=[SQL("DEFAULT ''")])
seq = IntegerField(constraints=[SQL("DEFAULT 0")])
trunkid = IntegerField(constraints=[SQL("DEFAULT 0")])
class Meta:
table_name = 'trunk_dialpatterns'
indexes = (
(('trunkid', 'match_pattern_prefix', 'match_pattern_pass', 'prepend_digits', 'seq'), True),
)
primary_key = CompositeKey('match_pattern_pass', 'match_pattern_prefix', 'prepend_digits', 'seq', 'trunkid')
class Trunks(BaseModel):
channelid = CharField(constraints=[SQL("DEFAULT ''")])
continue_ = CharField(column_name='continue', constraints=[SQL("DEFAULT off")], null=True)
dialoutprefix = CharField(constraints=[SQL("DEFAULT ''")])
disabled = CharField(constraints=[SQL("DEFAULT off")], null=True)
failscript = CharField(constraints=[SQL("DEFAULT ''")])
keepcid = CharField(constraints=[SQL("DEFAULT off")], null=True)
maxchans = CharField(constraints=[SQL("DEFAULT ''")], null=True)
name = CharField(constraints=[SQL("DEFAULT ''")])
outcid = CharField(constraints=[SQL("DEFAULT ''")])
provider = CharField(null=True)
tech = CharField()
trunkid = IntegerField(constraints=[SQL("DEFAULT 0")])
usercontext = CharField(null=True)
class Meta:
table_name = 'trunks'
indexes = (
(('trunkid', 'tech', 'channelid'), True),
)
primary_key = CompositeKey('channelid', 'tech', 'trunkid')
class Tts(BaseModel):
engine = CharField(null=True)
goto = CharField(null=True)
name = CharField()
text = TextField()
class Meta:
table_name = 'tts'
class Ttsengines(BaseModel):
name = CharField(null=True)
path = CharField(null=True)
class Meta:
table_name = 'ttsengines'
class UcpSessions(BaseModel):
address = CharField(null=True)
session = CharField(primary_key=True)
time = IntegerField(null=True)
uid = IntegerField(null=True)
class Meta:
table_name = 'ucp_sessions'
class UsermanDirectories(BaseModel):
active = IntegerField(constraints=[SQL("DEFAULT 0")])
default = IntegerField(constraints=[SQL("DEFAULT 0")])
driver = CharField(constraints=[SQL("DEFAULT ''")])
locked = IntegerField(constraints=[SQL("DEFAULT 0")])
name = CharField(null=True)
order = IntegerField(constraints=[SQL("DEFAULT 5")])
class Meta:
table_name = 'userman_directories'
class UsermanGroups(BaseModel):
auth = CharField(constraints=[SQL("DEFAULT freepbx")], null=True)
authid = CharField(null=True)
dateformat = CharField(null=True)
datetimeformat = CharField(null=True)
description = CharField(null=True)
groupname = CharField(null=True)
language = CharField(null=True)
local = IntegerField(constraints=[SQL("DEFAULT 0")])
permissions = TextField(null=True)
priority = IntegerField(constraints=[SQL("DEFAULT 5")])
timeformat = CharField(null=True)
timezone = CharField(null=True)
users = TextField(null=True)
class Meta:
table_name = 'userman_groups'
indexes = (
(('groupname', 'auth'), True),
)
class UsermanGroupsSettings(BaseModel):
gid = IntegerField()
key = CharField()
module = CharField()
type = CharField(null=True)
val = TextField()
class Meta:
table_name = 'userman_groups_settings'
indexes = (
(('gid', 'key'), False),
(('gid', 'module', 'key'), True),
(('module', 'gid'), False),
)
primary_key = False
class UsermanUsers(BaseModel):
auth = CharField(constraints=[SQL("DEFAULT freepbx")], null=True)
authid = CharField(null=True)
cell = CharField(null=True)
company = CharField(null=True)
dateformat = CharField(null=True)
datetimeformat = CharField(null=True)
default_extension = CharField(constraints=[SQL("DEFAULT none")])
department = CharField(null=True)
description = CharField(null=True)
displayname = CharField(null=True)
email = TextField(null=True)
fax = CharField(null=True)
fname = CharField(null=True)
home = CharField(null=True)
language = CharField(null=True)
lname = CharField(null=True)
password = CharField(null=True)
permissions = TextField(null=True)
primary_group = IntegerField(null=True)
timeformat = CharField(null=True)
timezone = CharField(null=True)
title = CharField(null=True)
username = CharField(null=True)
work = CharField(null=True)
class Meta:
table_name = 'userman_users'
indexes = (
(('username', 'auth'), True),
)
class UsermanUsersSettings(BaseModel):
key = CharField()
module = CharField()
type = CharField(null=True)
uid = IntegerField()
val = TextField()
class Meta:
table_name = 'userman_users_settings'
indexes = (
(('module', 'uid'), False),
(('uid', 'key'), False),
(('uid', 'module', 'key'), True),
)
primary_key = False
class Users(BaseModel):
busy_cid = CharField(constraints=[SQL("DEFAULT ''")])
busy_dest = CharField(constraints=[SQL("DEFAULT ''")])
chanunavail_cid = CharField(constraints=[SQL("DEFAULT ''")])
chanunavail_dest = CharField(constraints=[SQL("DEFAULT ''")])
extension = CharField(constraints=[SQL("DEFAULT ''")], index=True)
mohclass = CharField(constraints=[SQL("DEFAULT default")], null=True)
name = CharField(null=True)
noanswer = CharField(null=True)
noanswer_cid = CharField(constraints=[SQL("DEFAULT ''")])
noanswer_dest = CharField(constraints=[SQL("DEFAULT ''")])
outboundcid = CharField(null=True)
password = CharField(null=True)
recording = CharField(null=True)
ringtimer = IntegerField(null=True)
sipname = CharField(null=True)
voicemail = CharField(null=True)
class Meta:
table_name = 'users'
primary_key = False
class VirtualQueueConfig(BaseModel):
adest = CharField(constraints=[SQL("DEFAULT ''")])
agentannounce = IntegerField(column_name='agentannounce_id', null=True)
alertinfo = CharField(constraints=[SQL("DEFAULT ''")])
callconfirm = IntegerField(column_name='callconfirm_id', null=True)
cdest = CharField(constraints=[SQL("DEFAULT ''")])
cidpp = CharField(constraints=[SQL("DEFAULT ''")])
dest = CharField(constraints=[SQL("DEFAULT ''")])
full_dest = CharField(constraints=[SQL("DEFAULT ''")])
gotodest = CharField(constraints=[SQL("DEFAULT ''")])
joinannounce = IntegerField(column_name='joinannounce_id', null=True)
joinempty_dest = CharField(constraints=[SQL("DEFAULT ''")])
joinunavail_dest = CharField(constraints=[SQL("DEFAULT ''")])
language = CharField(constraints=[SQL("DEFAULT ''")])
leaveempty_dest = CharField(constraints=[SQL("DEFAULT ''")])
leaveunavail_dest = CharField(constraints=[SQL("DEFAULT ''")])
max_penalty = IntegerField(null=True)
maxwait = CharField(null=True)
min_penalty = IntegerField(null=True)
music = CharField(null=True)
name = CharField(constraints=[SQL("DEFAULT ''")])
position = IntegerField(null=True)
priority = IntegerField(null=True)
rule = IntegerField(column_name='rule_id', null=True)
class Meta:
table_name = 'virtual_queue_config'
class VisualPhonebook(BaseModel):
address = CharField(constraints=[SQL("DEFAULT ''")], null=True)
company = CharField(null=True)
context = CharField(constraints=[SQL("DEFAULT ''")], null=True)
email = CharField(constraints=[SQL("DEFAULT ''")], null=True)
firstname = CharField(null=True)
lastname = CharField(null=True)
owner = CharField(constraints=[SQL("DEFAULT ''")], null=True)
phone1 = CharField(null=True)
phone2 = CharField(null=True)
picture = CharField(null=True)
private = CharField(constraints=[SQL("DEFAULT no")], null=True)
class Meta:
table_name = 'visual_phonebook'
indexes = (
(('firstname', 'lastname', 'company'), False),
)
class Vmblast(BaseModel):
audio_label = IntegerField(constraints=[SQL("DEFAULT -1")])
description = CharField()
grpnum = BigAutoField()
password = CharField()
class Meta:
table_name = 'vmblast'
class VmblastGroups(BaseModel):
ext = CharField(constraints=[SQL("DEFAULT ''")])
grpnum = BigIntegerField()
class Meta:
table_name = 'vmblast_groups'
indexes = (
(('grpnum', 'ext'), True),
)
primary_key = CompositeKey('ext', 'grpnum')
class Vmnotify(BaseModel):
cidtype = CharField(constraints=[SQL("DEFAULT default")])
deletemsg = CharField(constraints=[SQL("DEFAULT yes")])
emailattach = IntegerField(constraints=[SQL("DEFAULT 1")])
emailbody = TextField()
emailfail = TextField()
emailfrom = CharField(constraints=[SQL("DEFAULT ''")])
emailsubject = CharField(constraints=[SQL("DEFAULT ''")])
emailsuccess = TextField()
enabled = IntegerField(constraints=[SQL("DEFAULT 1")])
getname = IntegerField(constraints=[SQL("DEFAULT 0")])
greetingid = IntegerField(constraints=[SQL("DEFAULT 0")])
instructionsid = IntegerField(constraints=[SQL("DEFAULT 0")])
mailbox = CharField(primary_key=True)
outcid = CharField(constraints=[SQL("DEFAULT ''")])
outcidname = CharField(constraints=[SQL("DEFAULT ''")])
prioritydelay = IntegerField(constraints=[SQL("DEFAULT 120")])
recipients = TextField()
retrycount = IntegerField(constraints=[SQL("DEFAULT 3")])
retrydelay = IntegerField(constraints=[SQL("DEFAULT 300")])
class Meta:
table_name = 'vmnotify'
class VmnotifyEvents(BaseModel):
notification = IntegerField(column_name='notification_id', constraints=[SQL("DEFAULT 0")])
number = CharField(constraints=[SQL("DEFAULT ''")])
priority = IntegerField(constraints=[SQL("DEFAULT 0")])
status = IntegerField(constraints=[SQL("DEFAULT 0")])
time = IntegerField(null=True)
class Meta:
table_name = 'vmnotify_events'
class VmnotifyNotifications(BaseModel):
callerid = CharField(constraints=[SQL("DEFAULT ''")])
length = IntegerField(constraints=[SQL("DEFAULT 0")])
mailbox = CharField(constraints=[SQL("DEFAULT ''")])
priority = IntegerField(constraints=[SQL("DEFAULT 0")])
retry = IntegerField(constraints=[SQL("DEFAULT 0")])
status = IntegerField(constraints=[SQL("DEFAULT 0")])
time = IntegerField(null=True)
class Meta:
table_name = 'vmnotify_notifications'
class VoicemailAdmin(BaseModel):
value = CharField(constraints=[SQL("DEFAULT ''")])
variable = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
class Meta:
table_name = 'voicemail_admin'
class VqplusCallbackCalls(BaseModel):
callback = CharField()
cbid = IntegerField()
position = IntegerField()
queue_num = CharField()
uniqueid = CharField(primary_key=True)
class Meta:
table_name = 'vqplus_callback_calls'
class VqplusCallbackConfig(BaseModel):
announcement = CharField(null=True)
cbqueue = CharField(null=True)
cid = CharField(null=True)
maxcallbacks = IntegerField(null=True)
name = CharField(constraints=[SQL("DEFAULT ''")])
numprepend = CharField(null=True)
patterns = TextField(null=True)
promptcb = CharField(null=True)
promptcbaccept = CharField(null=True)
promptreqconfirm = CharField(null=True)
promptreqname = CharField(null=True)
promptreqnum = CharField(null=True)
recordname = IntegerField(null=True)
retries = IntegerField(null=True)
retrydelay = IntegerField(null=True)
timeout = IntegerField(null=True)
class Meta:
table_name = 'vqplus_callback_config'
class VqplusCallbackLog(BaseModel):
callback = CharField()
cbid = IntegerField()
queue_num = CharField()
reason = CharField()
success = IntegerField(null=True)
timestamp = IntegerField()
uniqueid = CharField(primary_key=True)
class Meta:
table_name = 'vqplus_callback_log'
class VqplusQruleConfig(BaseModel):
name = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'vqplus_qrule_config'
class VqplusQruleDetail(BaseModel):
elapsed = IntegerField()
max_penalty = CharField(constraints=[SQL("DEFAULT ''")])
min_penalty = CharField(constraints=[SQL("DEFAULT ''")])
rule = IntegerField(column_name='rule_id')
class Meta:
table_name = 'vqplus_qrule_detail'
indexes = (
(('rule', 'elapsed'), True),
)
primary_key = CompositeKey('elapsed', 'rule')
class VqplusQueueConfig(BaseModel):
adest = CharField(constraints=[SQL("DEFAULT ''")])
cdest = CharField(constraints=[SQL("DEFAULT ''")])
full_dest = CharField(constraints=[SQL("DEFAULT ''")])
joinempty_dest = CharField(constraints=[SQL("DEFAULT ''")])
joinunavail_dest = CharField(constraints=[SQL("DEFAULT ''")])
lazymembers = CharField(constraints=[SQL("DEFAULT no")])
leaveempty_dest = CharField(constraints=[SQL("DEFAULT ''")])
leaveunavail_dest = CharField(constraints=[SQL("DEFAULT ''")])
max_penalty = IntegerField(null=True)
min_penalty = IntegerField(null=True)
queue_num = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
rule = IntegerField(column_name='rule_id', null=True)
upil = CharField(constraints=[SQL("DEFAULT no")])
class Meta:
table_name = 'vqplus_queue_config'
class WebrtcClients(BaseModel):
breaker = CharField()
certid = IntegerField(null=True)
cid = CharField()
device = CharField(unique=True)
password = CharField()
realm = CharField()
sipuri = CharField()
user = CharField(unique=True)
username = CharField()
websocket = CharField()
class Meta:
table_name = 'webrtc_clients'
primary_key = False
class XmppOptions(BaseModel):
keyword = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
value = TextField(null=True)
class Meta:
table_name = 'xmpp_options'
class XmppUsers(BaseModel):
password = CharField(null=True)
user = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
username = CharField(null=True)
class Meta:
table_name = 'xmpp_users'
class ZuluInteractionsContacts(BaseModel):
calleridname = CharField(null=True)
calleridnumber = CharField(null=True)
contactman = IntegerField(column_name='contactman_id', index=True, null=True)
id = CharField(primary_key=True)
linkedid = CharField(index=True, null=True)
type = CharField()
userman = IntegerField(column_name='userman_id', index=True, null=True)
zulu = IntegerField(column_name='zulu_id', index=True, null=True)
class Meta:
table_name = 'zulu_interactions_contacts'
class ZuluInteractionsInteractionStates(BaseModel):
archived = IntegerField(constraints=[SQL("DEFAULT 0")])
interaction = CharField(column_name='interaction_id', constraints=[SQL("DEFAULT ''")])
topic = CharField(null=True)
userman = IntegerField(column_name='userman_id')
class Meta:
table_name = 'zulu_interactions_interaction_states'
indexes = (
(('userman', 'interaction'), True),
)
primary_key = False
class ZuluInteractionsInteractions(BaseModel):
id = CharField(primary_key=True)
start_time = IntegerField()
topic = CharField(null=True)
type = CharField(constraints=[SQL("DEFAULT direct")], null=True)
class Meta:
table_name = 'zulu_interactions_interactions'
class ZuluInteractionsMembers(BaseModel):
interaction = CharField(column_name='interaction_id')
linkedid = CharField()
type = CharField()
class Meta:
table_name = 'zulu_interactions_members'
indexes = (
(('linkedid', 'interaction'), True),
)
primary_key = CompositeKey('interaction', 'linkedid')
class ZuluInteractionsStreamBodies(BaseModel):
body = TextField(null=True)
searchable = TextField(null=True)
stream = CharField(column_name='stream_id', primary_key=True)
class Meta:
table_name = 'zulu_interactions_stream_bodies'
class ZuluInteractionsStreamLinks(BaseModel):
link = TextField()
stream = CharField(column_name='stream_id', primary_key=True)
class Meta:
table_name = 'zulu_interactions_stream_links'
class ZuluInteractionsStreams(BaseModel):
id = CharField(primary_key=True)
interaction = CharField(column_name='interaction_id', index=True)
member = CharField(column_name='member_id', constraints=[SQL("DEFAULT ''")], index=True)
seen = IntegerField(constraints=[SQL("DEFAULT 0")])
type = CharField()
when = IntegerField(index=True)
zulu = IntegerField(column_name='zulu_id', index=True)
class Meta:
table_name = 'zulu_interactions_streams'
class ZuluLoginTokens(BaseModel):
expires = IntegerField(null=True)
temp = IntegerField(constraints=[SQL("DEFAULT 1")])
token = CharField(constraints=[SQL("DEFAULT ''")], primary_key=True)
uid = IntegerField(null=True)
websocket_session = CharField(constraints=[SQL("DEFAULT ''")])
class Meta:
table_name = 'zulu_login_tokens'
class ZuluSoftphones(BaseModel):
certid = IntegerField()
device = IntegerField()
user = AutoField()
class Meta:
table_name = 'zulu_softphones'
class ZuluTokens(BaseModel):
client_ip = CharField()
client_type = CharField()
client_version = CharField()
connect_time = IntegerField()
token = CharField()
uid = IntegerField()
websocket_session = CharField(primary_key=True)
class Meta:
table_name = 'zulu_tokens'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment