class Bill(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) date = db.Column(db.String(60)) used = db.Column(db.Integer()) available = db.Column(db.Integer()) price = db.Column(db.String(30)) created_at = db.Column(db.String(50))
class Group(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) name = db.Column(db.String(32)) size = db.Column(db.Integer(),default=0) created_by_id = db.Column(db.Integer()) created_by_name = db.Column(db.String(100)) created_at = db.Column(db.String(50))
class TransactionItem(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) transaction_id = db.Column(db.Integer()) service_id = db.Column(db.Integer()) service_name = db.Column(db.String(30)) quantity = db.Column(db.String(10)) price = db.Column(db.String(10)) total = db.Column(db.String(10))
class ConversationItem(db.Model): id = db.Column(db.Integer, primary_key=True) conversation_id = db.Column(db.Integer()) message_type = db.Column(db.String(30)) outbound_sender_id = db.Column(db.Integer()) outbound_sender_name = db.Column(db.String(100)) date = db.Column(db.String(20)) time = db.Column(db.String(10)) content = db.Column(db.Text) created_at = db.Column(db.String(50))
class Blast(db.Model): id = db.Column(db.Integer, primary_key=True) sender_id = db.Column(db.Integer()) batch_size = db.Column(db.Integer()) done = db.Column(db.Integer(), default=0) pending = db.Column(db.Integer(), default=0) failed = db.Column(db.Integer(), default=0) sender_name = db.Column(db.String(60)) date = db.Column(db.String(20)) time = db.Column(db.String(10)) timestamp = db.Column(db.String(50))
class ReminderMessage(db.Model): id = db.Column(db.Integer, primary_key=True) batch_id = db.Column(db.Integer()) date = db.Column(db.String(20)) time = db.Column(db.String(10)) contact_name = db.Column(db.String(100), default='Unknown') content = db.Column(db.Text()) msisdn = db.Column(db.String(30)) characters = db.Column(db.Integer()) cost = db.Column(db.String(10)) status = db.Column(db.String(30),default='pending') created_at = db.Column(db.String(50))
class ContactBatch(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) uploader_id = db.Column(db.Integer()) uploader_name = db.Column(db.String(100)) batch_size = db.Column(db.Integer()) date = db.Column(db.String(20)) time = db.Column(db.String(10)) file_name = db.Column(db.Text) done = db.Column(db.Integer(),default=0) pending = db.Column(db.Integer(),default=0) failed = db.Column(db.Integer(),default=0) created_at = db.Column(db.String(50))
class Batch(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) message_type = db.Column(db.String(60)) sender_id = db.Column(db.Integer()) batch_size = db.Column(db.Integer()) done = db.Column(db.Integer(),default=0) pending = db.Column(db.Integer(),default=0) failed = db.Column(db.Integer(),default=0) sender_name = db.Column(db.String(60)) recipient = db.Column(db.Text()) date = db.Column(db.String(20)) time = db.Column(db.String(10)) content = db.Column(db.Text) created_at = db.Column(db.String(50))
class Message(db.Model): id = db.Column(db.Integer, primary_key=True) blast_id = db.Column(db.Integer()) msisdn = db.Column(db.String(30)) status = db.Column(db.String(30), default='pending') content = db.Column(db.Text) timestamp = db.Column(db.String(50))
class RaffleShopper(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) raffle_id = db.Column(db.Integer) shopper_id = db.Column(db.Integer) register_date = db.Column(db.String(20)) register_time = db.Column(db.String(10)) entries = db.Column(db.Integer()) created_at = db.Column(db.String(50))
class Bill(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) date = db.Column(db.String(60)) year = db.Column(db.String(10)) transactions = db.Column(db.Integer()) price = db.Column(db.String(30)) created_at = db.Column(db.String(50)) receipt_path = db.Column(db.Text(), default='')
class OutboundMessage(db.Model): id = db.Column(db.Integer, primary_key=True) batch_id = db.Column(db.Integer()) date = db.Column(db.String(20)) time = db.Column(db.String(10)) contact_name = db.Column(db.String(100)) msisdn = db.Column(db.String(30)) status = db.Column(db.String(30), default='pending') created_at = db.Column(db.String(50))
class Booking(db.Model): id = db.Column(db.Integer, primary_key=True) rider_id = db.Column(db.Integer()) rider_facebook_id = db.Column(db.Text()) driver_id = db.Column(db.Integer()) pickup_lat = db.Column(db.Text()) pickup_long = db.Column(db.Text()) destination_lat = db.Column(db.Text()) destination_long = db.Column(db.Text()) km = db.Column(db.String(10)) minutes = db.Column(db.String(10)) fare = db.Column(db.Integer()) date = db.Column(db.String(50)) book_time = db.Column(db.String(50)) match_time = db.Column(db.String(50)) pickup_time = db.Column(db.String(50)) arrival_time = db.Column(db.String(50)) booking_status = db.Column(db.String(30)) created_at = db.Column(db.String(50))
class Client(db.Model): id = db.Column(db.Integer,primary_key=True) client_no = db.Column(db.String(32), unique=True) name = db.Column(db.String(50)) app_id = db.Column(db.Text()) app_secret = db.Column(db.Text()) passphrase = db.Column(db.Text()) plan = db.Column(db.String(30)) shortcode = db.Column(db.String(30)) max_outgoing = db.Column(db.Integer()) created_at = db.Column(db.String(50))
class Contact(db.Model): id = db.Column(db.Integer,primary_key=True) batch_id = db.Column(db.String(30),default='N/A') client_no = db.Column(db.String(32)) contact_type = db.Column(db.String(32)) name = db.Column(db.String(100)) msisdn = db.Column(db.String(20)) added_by = db.Column(db.Integer()) added_by_name = db.Column(db.String(100)) join_date = db.Column(db.String(50)) created_at = db.Column(db.String(50))
class Citizen(db.Model): id = db.Column(db.Integer, primary_key=True) last_name = db.Column(db.String(60)) first_name = db.Column(db.String(60)) middle_name = db.Column(db.String(60)) gender = db.Column(db.String(60)) age = db.Column(db.Integer()) birthday = db.Column(db.String(80)) employment_status = db.Column(db.String(60)) occupation = db.Column(db.String(60)) company = db.Column(db.String(60)) email = db.Column(db.String(60)) citizenship = db.Column(db.String(60)) religion = db.Column(db.String(60)) civil_status = db.Column(db.String(60)) msisdn = db.Column(db.String(15)) household_id = db.Column(db.Integer()) household_name = db.Column(db.String(60)) position = db.Column(db.String(60)) status = db.Column(db.String(60)) remarks = db.Column(db.String(60))
class Household(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60)) number_of_members = db.Column(db.Integer()) region = db.Column(db.String(60)) province = db.Column(db.String(60)) city = db.Column(db.String(60)) barangay = db.Column(db.String(100)) address = db.Column(db.Text()) cluster = db.Column(db.String(100)) contact = db.Column(db.String(15)) status = db.Column(db.String(60)) remarks = db.Column(db.String(60))
class Report(db.Model, Serializer): id = db.Column(db.Integer,primary_key=True) client_no = db.Column(db.String(32)) name = db.Column(db.String(60)) report_type = db.Column(db.String(60)) from_date = db.Column(db.String(30)) to_date = db.Column(db.String(30)) generated_by = db.Column(db.String(60)) generated_by_id = db.Column(db.Integer()) date = db.Column(db.String(50)) time = db.Column(db.String(30)) status = db.Column(db.String(30),default='Pending') created_at = db.Column(db.String(50))
class Transaction(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) date = db.Column(db.String(30)) time = db.Column(db.String(10)) status = db.Column(db.String(30)) cashier_id = db.Column(db.Integer()) cashier_name = db.Column(db.String(60)) customer_name = db.Column(db.String(60), nullable=True) customer_msisdn = db.Column(db.String(30), nullable=True) process_date = db.Column(db.String(30), default='') process_time = db.Column(db.String(10), default='') done_date = db.Column(db.String(30), default='') done_time = db.Column(db.String(10), default='') pickup_date = db.Column(db.String(30), default='') pickup_time = db.Column(db.String(10), default='') total = db.Column(db.String(30)) notes = db.Column(db.Text()) created_at = db.Column(db.String(50))
class ContactGroup(db.Model): id = db.Column(db.Integer, primary_key=True) group_id = db.Column(db.Integer()) contact_id = db.Column(db.Integer())
class SVC(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer()) facebook_id = db.Column(db.Text()) token = db.Column(db.String(10)) created_at = db.Column(db.String(50))
class ParentChild(db.Model): id = db.Column(db.Integer, primary_key=True) parent_id = db.Column(db.Integer()) child_id = db.Column(db.Integer()) relation = db.Column(db.String(60))
class HouseholdImage(db.Model): id = db.Column(db.Integer, primary_key=True) household_id = db.Column(db.Integer()) path = db.Column(db.Text())