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 AlarmReport(TableModel):
__tablename__ = 'cc_alarm_report'
calculatedvalue = Float
cc_alarm = Integer64(db_column='cc_alarm_id')
daterun = Date
id = Integer64(primary_key=True)
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 ServiceReport(TableModel):
__tablename__ = 'cc_service_report'
cc_service = Integer64(db_column='cc_service_id')
daterun = Date
id = Integer64(primary_key=True)
totalcardperform = Integer32
totalcredit = Float
class CardPackageOffer(TableModel):
__tablename__ = 'cc_card_package_offer'
date_consumption = Date(index=True)
id = Integer64(primary_key=True)
id_cc_card = Integer64(index=True)
id_cc_package_offer = Integer64(index=True)
used_secondes = Integer64
class LogrefillAgent(TableModel):
__tablename__ = 'cc_logrefill_agent'
agent = Integer64(db_column='agent_id')
credit = Decimal
date = Date
description = Unicode
id = Integer64(primary_key=True)
refill_type = Integer32
class LogpaymentAgent(TableModel):
__tablename__ = 'cc_logpayment_agent'
added_refill = Integer32
agent = Integer64(db_column='agent_id')
date = Date
description = Unicode
id = Integer64(primary_key=True)
id_logrefill = Integer64
payment = Decimal
payment_type = Integer32
class Notification(TableModel):
__tablename__ = 'cc_notification'
date = Date
from_ = Integer64(db_column='from_id')
from_type = Integer32
id = Integer64(primary_key=True)
key_value = Unicode(1)
link = Integer64(db_column='link_id')
link_type = Unicode(1)
priority = Integer32
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 Provider(TableModel):
__tablename__ = 'cc_provider'
id = Integer64(primary_key=True)
creationdate = Date
description = Unicode
provider_name = Unicode(1, unique=True)
class Agent(TableModel):
__tablename__ = 'cc_agent'
active = Unicode(1)
address = Unicode(1)
bank_info = Unicode
banner = Unicode
city = Unicode(1)
com_balance = Decimal
commission = Decimal
company = Unicode(1)
country = Unicode(1)
credit = Decimal
currency = Unicode(1)
datecreation = Date
email = Unicode(1)
fax = Unicode(1)
firstname = Unicode(1)
id = Integer64(primary_key=True)
id_tariffgroup = Integer32
language = Unicode(1)
lastname = Unicode(1)
locale = Unicode(1)
location = Unicode
login = Unicode(1, unique=True)
options = Integer32
passwd = Unicode(1)
perms = Integer32
phone = Unicode(1)
state = Unicode(1)
threshold_remittance = Decimal
vat = Decimal
zipcode = Unicode(1)
class Country(TableModel):
__tablename__ = 'cc_country'
id = Integer64(primary_key=True)
countrycode = Unicode(1)
countryname = Unicode(1)
countryprefix = Unicode(1)
class StatusLog(TableModel):
__tablename__ = 'cc_status_log'
id = Integer64(primary_key=True)
id_cc_card = Integer64
status = Integer32
updated_date = Date
class Backup(TableModel):
__tablename__ = 'cc_backup'
creationdate = Date
id = Integer64(primary_key=True)
name = Unicode(1, unique=True)
path = Unicode(1)
class AutorefillReport(TableModel):
__tablename__ = 'cc_autorefill_report'
daterun = Date
id = Integer64(primary_key=True)
totalcardperform = Integer32
totalcredit = Decimal
class Paypal(TableModel):
__tablename__ = 'cc_paypal'
id = Integer64(primary_key=True)
address_city = Unicode(1)
address_country = Unicode(1)
address_name = Unicode(1)
address_state = Unicode(1)
address_status = Unicode(1)
address_street = Unicode(1)
address_zip = Unicode(1)
first_name = Unicode(1)
item_name = Unicode(1)
item_number = Unicode(1)
last_name = Unicode(1)
mc_currency = Unicode(1)
mc_fee = Decimal
mc_gross = Decimal
memo = Unicode
payer_business_name = Unicode(1)
payer_email = Unicode(1)
payer = Unicode(1, db_column='payer_id')
payer_status = Unicode(1)
payment_date = Unicode(1)
payment_status = Unicode(1)
payment_type = Unicode(1)
pending_reason = Unicode(1)
quantity = Integer32
reason_code = Unicode(1)
tax = Decimal
txn = Unicode(1, db_column='txn_id', unique=True)
txn_type = Unicode(1)
class CardHistory(TableModel):
__tablename__ = 'cc_card_history'
datecreated = Date
description = Unicode
id = Integer64(primary_key=True)
id_cc_card = Integer64
class Campaign(TableModel):
__tablename__ = 'cc_campaign'
id = Integer64(primary_key=True)
creationdate = Date
daily_start_time = Time
daily_stop_time = Time
description = Unicode
expirationdate = Date
forward_number = Unicode(1)
frequency = Integer32
friday = Integer32
id_campaign_config = Integer32
id_card = Integer64
id_cid_group = Integer32
monday = Integer32
name = Unicode(1, unique=True)
nb_callmade = Integer32
saturday = Integer32
secondusedreal = Integer32
startingdate = Date
status = Integer32
sunday = Integer32
thursday = Integer32
tuesday = Integer32
wednesday = Integer32
class CallbackSpool(TableModel):
__tablename__ = 'cc_callback_spool'
account = Unicode(1)
actionid = Unicode(1)
agi_result = Unicode(1)
application = Unicode(1)
async = Unicode(1)
callback_time = Date
callerid = Unicode(1)
channel = Unicode(1)
context = Unicode(1)
data = Unicode(1)
entry_time = Date
exten = Unicode(1)
id = Integer64(primary_key=True)
id_server = Integer32
id_server_group = Integer32
last_attempt_time = Date
manager_result = Unicode(1)
num_attempt = Integer32
priority = Unicode(1)
server_ip = Unicode(1)
status = Unicode(1)
timeout = Unicode(1)
uniqueid = Unicode(1, unique=True)
variable = Unicode(1)
class OutboundCidList(TableModel):
__tablename__ = 'cc_outbound_cid_list'
id = Integer64(primary_key=True)
activated = Integer32
cid = Unicode(1)
creationdate = Date
outbound_cid_group = Integer32
class Callerid(TableModel):
__tablename__ = 'cc_callerid'
id = Integer64(primary_key=True)
# id_cc_card = Integer64
cc_card = Card.store_as(table(left='id_cc_card'))
activated = Unicode(1, default='t')
cid = Unicode(1, unique=True)
class EpaymentLogAgent(TableModel):
__tablename__ = 'cc_epayment_log_agent'
agent = Integer64(db_column='agent_id')
amount = Unicode(1)
cc_expires = Unicode(1)
cc_number = Unicode(1)
cc_owner = Unicode(1)
creationdate = Date
credit_card_type = Unicode(1)
currency = Unicode(1)
cvv = Unicode(1)
id = Integer64(primary_key=True)
paymentmethod = Unicode(1)
status = Integer32
transaction_detail = Unicode
vat = Float
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 AgentSignup(TableModel):
__tablename__ = 'cc_agent_signup'
code = Unicode(1, unique=True)
id = Integer64(primary_key=True)
id_agent = Integer32
id_group = Integer32
id_tariffgroup = Integer32
class BillingCustomer(TableModel):
__tablename__ = 'cc_billing_customer'
date = Date
id = Integer64(primary_key=True)
id_card = Integer64
id_invoice = Integer64
start_date = Date
class MessageAgent(TableModel):
__tablename__ = 'cc_message_agent'
id = Integer64(primary_key=True)
id_agent = Integer32
logo = Integer32
message = Unicode
order_display = Integer32
type = Integer32
class Speeddial(TableModel):
__tablename__ = 'cc_speeddial'
creationdate = Date
id = Integer64(primary_key=True)
id_cc_card = Integer64
name = Unicode(1)
phone = Unicode(1)
speeddial = Integer32
class SubscriptionSignup(TableModel):
__tablename__ = 'cc_subscription_signup'
description = Unicode(1)
enable = Integer32
id = Integer64(primary_key=True)
id_callplan = Integer64
id_subscription = Integer64
label = Unicode(1)
class User(TableModel):
__tablename__ = 'user'
id = Integer64(primary_key=True)
active = Integer32
admin = Integer32
email = Unicode(1, unique=True)
password = Unicode(1)
username = Unicode(1, unique=True)