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)