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
  • 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: