class World(TableModel):
__tablename__ = "world"
_type_info = [
("id", Integer32(primary_key=True)),
("randomNumber",
Integer32(sqla_column_args=dict(name="randomnumber"))),
]
class CardGroup(TableModel):
__tablename__ = 'cc_card_group'
id = Integer32(primary_key=True)
name = Unicode(1)
description = Unicode
users_perms = Integer32(default=0)
id_agent = Integer32(default=0)
class Logrefill(TableModel):
__tablename__ = 'cc_logrefill'
id = Integer64(primary_key=True)
# card = ForeignKeyField(Card, db_column='card_id')
card = Integer64(db_column='card_id')
date = Date
agent = Integer64(db_column='agent_id')
credit = Decimal(default=0.0)
description = Unicode
# refill_type (amount:0, correction:1, extra fee:2,agent refund:3)
refill_type = Integer32(default=0)
added_invoice = Integer32(default=0)
class Logpayment(TableModel):
__tablename__ = 'cc_logpayment'
id = Integer64(primary_key=True)
card = Integer64(db_column='card_id')
date = Date(default_factory=date.today)
description = Unicode
payment = Decimal(default=0.0)
# payment_type (amount:0, correction:1, extra fee:2,agent refund:3)
payment_type = Integer32(default=0)
id_logrefill = Integer64
added_commission = Integer32(default=0)
added_refill = Integer32(default=0)
agent = Integer64(db_column='agent_id')
class Call(TableModel):
__tablename__ = 'cc_call'
id = Integer64(primary_key=True)
sessionid = Unicode(1, default=0)
uniqueid = Unicode(1, null=False)
card_id = Integer64(null=False, db_column='card_id')
nasipaddress = Unicode(1, null=False)
starttime = Date(index=True, default_factory=date.today)
stoptime = Unicode(1, default="0000-00-00 00:00:00")
buycost = Decimal
calledstation = Unicode(1, index=True)
destination = Integer32
dnid = Unicode(1, null=False)
id_card_package_offer = Integer32
id_did = Integer32
id_ratecard = Integer32
id_tariffgroup = Integer32
id_tariffplan = Integer32
id_trunk = Integer32
real_sessiontime = Integer32
sessionbill = Float
sessiontime = Integer32
sipiax = Integer32
src = Unicode(1)
terminatecauseid = Integer32(index=True)
class CallplanLcr(TableModel):
__tablename__ = 'cc_callplan_lcr'
id = Integer32(primary_key=True)
buyrate = Decimal
connectcharge = Decimal
destination = Unicode(1)
dialprefix = Unicode(1)
id_trunk = Integer32
idtariffplan = Integer32
initblock = Integer32
ratecard = Integer32(db_column='ratecard_id')
rateinitial = Decimal
startdate = Date
stopdate = Date
tariffgroup = Integer32(db_column='tariffgroup_id')
class Timezone(TableModel):
__tablename__ = 'cc_timezone'
id = Integer32(primary_key=True)
gmtoffset = Integer64
gmttime = Unicode(1)
gmtzone = Unicode(1)
class CardSeria(TableModel):
__tablename__ = 'cc_card_seria'
id = Integer32(primary_key=True)
description = Unicode
name = Unicode(1)
value = Integer64
class Support(TableModel):
__tablename__ = 'cc_support'
id = Integer32(primary_key=True)
email = Unicode(1)
language = Unicode(1)
name = Unicode(1)
class CallArchive(TableModel):
__tablename__ = 'cc_call_archive'
buycost = Decimal
calledstation = Unicode(1, index=True)
card = Integer64(db_column='card_id')
destination = Integer32
dnid = Unicode(1)
id = Integer64(primary_key=True)
id_card_package_offer = Integer32
id_did = Integer32
id_ratecard = Integer32
id_tariffgroup = Integer32
id_tariffplan = Integer32
id_trunk = Integer32
nasipaddress = Unicode(1)
real_sessiontime = Integer32
sessionbill = Float
sessionid = Unicode(1)
sessiontime = Integer32
sipiax = Integer32
src = Unicode(1)
starttime = Date(index=True)
stoptime = Date
terminatecauseid = Integer32(index=True)
uniqueid = Unicode(1)
class Phonebook(TableModel):
__tablename__ = 'cc_phonebook'
id = Integer32(primary_key=True)
description = Unicode
id_card = Integer64
name = Unicode(1)
class CampaignConfig(TableModel):
__tablename__ = 'cc_campaign_config'
id = Integer32(primary_key=True)
context = Unicode(1)
description = Unicode
flatrate = Decimal
name = Unicode(1)
class CampaignPhonestatus(TableModel):
__tablename__ = 'cc_campaign_phonestatus'
id_callback = Unicode(1)
id_campaign = Integer32(primary_key=True)
id_phonenumber = Integer64(primary_key=True)
lastuse = Date
status = Integer32
class SupportComponent(TableModel):
__tablename__ = 'cc_support_component'
id = Integer32(primary_key=True)
activated = Integer32
id_support = Integer32
name = Unicode(1)
type_user = Integer32
class MissedCalls(TableModel):
__tablename__ = 'missed_calls'
id = Integer32(primary_key=True)
callid = Unicode(1, index=True)
cdr = Integer32(db_column='cdr_id')
dst_domain = Unicode(1)
dst_ouser = Unicode(1)
dst_user = Unicode(1)
from_tag = Unicode(1)
method = Unicode(1)
sip_code = Unicode(1)
sip_reason = Unicode(1)
src_domain = Unicode(1)
src_ip = Unicode(1)
src_user = Unicode(1)
time = Date
to_tag = Unicode(1)
class Charge(TableModel):
__tablename__ = 'cc_charge'
id = Integer64(primary_key=True)
amount = Float(default=0)
charged_status = Integer32(default=0)
# Values: 1:charge DID setup, 2:Montly charge for DID use, 3:Subscription fee, 4:Extra Charge
chargetype = Integer32(default=4)
cover_from = Date
cover_to = Date
creationdate = Date(index=True, default_factory=date.today)
description = Unicode
id_cc_card = Card(db_column='id_cc_card')
id_cc_card_subscription = Integer64
# id_cc_did = Integer64
cc_did = Did.store_as(table(left='id_cc_did'))
iduser = Integer32(default=0)
invoiced_status = Integer32(default=0)
class Extensions(TableModel):
__tablename__ = 'cc_extension'
id = Integer32(primary_key=True)
context = Unicode(64, default='home')
exten = Unicode(20, default='')
priority = Unicode(4, default='0')
app = Unicode(20, default='Dial')
appdata = Unicode(128, default='')
class Currencies(TableModel):
__tablename__ = 'cc_currencies'
id = Integer32(primary_key=True)
basecurrency = Unicode(1)
currency = Unicode(1, unique=True)
lastupdate = Date
name = Unicode(1)
value = Decimal
class Ratecard(TableModel):
__tablename__ = 'cc_ratecard'
id = Integer32(primary_key=True)
additional_block_charge = Decimal
additional_block_charge_time = Integer32
additional_grace = Integer32
announce_time_correction = Decimal
billingblock = Integer32
billingblocka = Integer32
billingblockb = Integer32
billingblockc = Integer32
buyrate = Decimal
buyrateincrement = Integer32
buyrateinitblock = Integer32
chargea = Decimal
chargeb = Decimal
chargec = Float
connectcharge = Decimal
destination = Integer64
dialprefix = Unicode(1, index=True)
disconnectcharge = Decimal
disconnectcharge_after = Integer32
endtime = Integer32
id_outbound_cidgroup = Integer32
id_trunk = Integer32
idtariffplan = Integer32(index=True)
initblock = Integer32
is_merged = Integer32
minimal_cost = Decimal
musiconhold = Unicode(1)
rateinitial = Decimal
rounding_calltime = Integer32
rounding_threshold = Integer32
startdate = Date
starttime = Integer32
stepchargea = Decimal
stepchargeb = Decimal
stepchargec = Float
stopdate = Date
tag = Unicode(1)
timechargea = Integer32
timechargeb = Integer32
timechargec = Integer32
class Configuration(TableModel):
__tablename__ = 'cc_configuration'
configuration_description = Unicode(1)
configuration = Integer32(primary_key=True, db_column='configuration_id')
configuration_key = Unicode(1)
configuration_title = Unicode(1)
configuration_type = Integer32
configuration_value = Unicode(1)
set_function = Unicode(1)
use_function = Unicode(1)
class Config(TableModel):
__tablename__ = 'cc_config'
id = Integer32(primary_key=True)
config_description = Unicode(1)
config_group_title = Unicode(1)
config_key = Unicode(1)
config_listvalues = Unicode(1)
config_title = Unicode(1)
config_value = Unicode(1)
config_valuetype = Integer32
class Tariffgroup(TableModel):
__tablename__ = 'cc_tariffgroup'
id = Integer32(primary_key=True)
creationdate = Date
id_cc_package_offer = Integer64
idtariffplan = Integer32
iduser = Integer32
lcrtype = Integer32
removeinterprefix = Integer32
tariffgroupname = Unicode(1)
class Templatemail(TableModel):
__tablename__ = 'cc_templatemail'
id = Integer32(primary_key=True)
fromemail = Unicode(1)
fromname = Unicode(1)
id_language = Unicode(1)
mailtype = Unicode(1)
messagehtml = Unicode(1)
messagetext = Unicode(1)
subject = Unicode(1)
class IaxBuddies(TableModel):
__tablename__ = 'cc_iax_buddies'
id = Integer32(primary_key=True)
defaultip = Unicode(1, db_column='DEFAULTip')
accountcode = Unicode(1)
adsi = Unicode(1)
allow = Unicode(1)
amaflags = Unicode(1)
auth = Unicode(1)
callerid = Unicode(1)
cid_number = Unicode(1)
codecpriority = Unicode(1)
context = Unicode(1)
dbsecret = Unicode(1)
deny = Unicode(1)
disallow = Unicode(1)
encryption = Unicode(1)
forcejitterbuffer = Unicode(1)
fullname = Unicode(1)
host = Unicode(1, index=True)
id_cc_card = Integer32
inkeys = Unicode(1)
ipaddr = Unicode(1, index=True)
jitterbuffer = Unicode(1)
language = Unicode(1)
mask = Unicode(1)
maxauthreq = Unicode(1)
maxcallnumbers = Unicode(1)
maxcallnumbers_nonvalidated = Unicode(1)
mohinterpret = Unicode(1)
mohsuggest = Unicode(1)
name = Unicode(1, unique=True)
outkey = Unicode(1)
permit = Unicode(1)
port = Unicode(1, index=True)
qualify = Unicode(1)
qualifyfreqnotok = Unicode(1)
qualifyfreqok = Unicode(1)
qualifysmoothing = Unicode(1)
regcontext = Unicode(1)
regexten = Unicode(1)
regseconds = Integer32
requirecalltoken = Unicode(1)
secret = Unicode(1)
sendani = Unicode(1)
setvar = Unicode(1)
sourceaddress = Unicode(1)
timezone = Unicode(1)
transfer = Unicode(1)
trunk = Unicode(1)
type = Unicode(1)
username = Unicode(1)
class Did(TableModel):
__tablename__ = 'cc_did'
id = Integer64(primary_key=True)
# id_cc_country = Integer32
# id_cc_didgroup = Integer64
id_cc_didgroup = Integer32(null=False)
cc_country = Country.store_as(table(left='id_cc_country'))
activated = Integer32(null=False)
did = Unicode(1, unique=True)
reserved = Integer32
iduser = Integer64(null=False)
creationdate = Date(default_factory=date.today)
startingdate = Date
expirationdate = Date
aleg_carrier_connect_charge = Decimal
aleg_carrier_connect_charge_offp = Decimal
aleg_carrier_cost_min = Decimal
aleg_carrier_cost_min_offp = Decimal
aleg_carrier_increment = Integer32
aleg_carrier_increment_offp = Integer32
aleg_carrier_initblock = Integer32
aleg_carrier_initblock_offp = Integer32
aleg_retail_connect_charge = Decimal
aleg_retail_connect_charge_offp = Decimal
aleg_retail_cost_min = Decimal
aleg_retail_cost_min_offp = Decimal
aleg_retail_increment = Integer32
aleg_retail_increment_offp = Integer32
aleg_retail_initblock = Integer32
aleg_retail_initblock_offp = Integer32
aleg_timeinterval = Unicode
billingtype = Integer32
connection_charge = Decimal
description = Unicode
fixrate = Float
max_concurrent = Integer32
secondusedreal = Integer32
selling_rate = Decimal
class Tariffplan(TableModel):
__tablename__ = 'cc_tariffplan'
id = Integer32(primary_key=True)
calleridprefix = Unicode(1)
creationdate = Date
description = Unicode
dnidprefix = Unicode(1)
expirationdate = Date
id_trunk = Integer32
idowner = Integer32
iduser = Integer32
reftariffplan = Integer32
secondusedcarrier = Integer32
secondusedratecard = Integer32
secondusedreal = Integer32
startingdate = Date
tariffname = Unicode(1)
class SipBuddiesEmpty(TableModel):
__tablename__ = 'cc_sip_buddies_empty'
defaultip = Unicode(1, db_column='DEFAULTip')
accountcode = Unicode(1)
allow = Unicode(1)
amaflags = Unicode(1)
callerid = Unicode(1)
callgroup = Unicode(1)
cancallforward = Unicode(1)
canreinvite = Unicode(1)
context = Unicode(1)
deny = Unicode(1)
disallow = Unicode(1)
dtmfmode = Unicode(1)
fromdomain = Unicode(1)
fromuser = Unicode(1)
fullcontact = Unicode(1)
host = Unicode(1)
id = Integer32(primary_key=True)
id_cc_card = Integer32
insecure = Unicode(1)
ipaddr = Unicode(1)
language = Unicode(1)
mailbox = Unicode(1)
mask = Unicode(1)
md5secret = Unicode(1)
musiconhold = Unicode(1)
name = Unicode(1)
nat = Unicode(1)
permit = Unicode(1)
pickupgroup = Unicode(1)
port = Unicode(1)
qualify = Unicode(1)
regexten = Unicode(1)
regseconds = Integer32
restrictcid = Unicode(1)
rtpholdtimeout = Unicode(1)
rtptimeout = Unicode(1)
secret = Unicode(1)
setvar = Unicode(1)
type = Unicode(1)
username = Unicode(1)
class Trunk(TableModel):
__tablename__ = 'cc_trunk'
addparameter = Unicode(1)
creationdate = Date
failover_trunk = Integer32
id_provider = Integer32
id_trunk = Integer32(primary_key=True)
if_max_use = Integer32
inuse = Integer32
maxuse = Integer32
providerip = Unicode(1)
providertech = Unicode(1)
removeprefix = Unicode(1)
secondusedcarrier = Integer32
secondusedratecard = Integer32
secondusedreal = Integer32
status = Integer32
trunkcode = Unicode(1)
trunkprefix = Unicode(1)
class Fortune(TableModel):
__tablename__ = "fortune"
id = Integer32(primary_key=True)
message = Unicode
class PackageRate(TableModel):
__tablename__ = 'cc_package_rate'
package = Integer32(db_column='package_id', primary_key=True)
rate = Integer32(db_column='rate_id', primary_key=True)
