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()) shortcode = db.Column(db.String(30)) created_at = db.Column(db.String(50))
class Inquiry(db.Model): __tablename__ = 'inquiries' id = db.Column(db.Integer, primary_key=True) msisdn = db.Column(db.String(32)) message = db.Column(db.Text()) date = db.Column(db.String(20)) time = db.Column(db.String(10)) status = db.Column(db.String(60), default='Pending') remarks = db.Column(db.Text()) created_at = db.Column(db.String(50))
class Appointment(db.Model): __tablename__ = 'appointments' id = db.Column(db.Integer, primary_key=True) school_name = db.Column(db.Text()) address = db.Column(db.Text()) contact_person = db.Column(db.String(100)) msisdn = db.Column(db.String(32)) date = db.Column(db.String(20), default=None) time = db.Column(db.String(10), default=None) created_at = db.Column(db.String(50))
class Rider(db.Model): id = db.Column(db.Integer, primary_key=True) facebook_id = db.Column(db.Text()) first_name = db.Column(db.String(100)) last_name = db.Column(db.String(100)) address = db.Column(db.Text()) msisdn = db.Column(db.String(20)) id_path = db.Column(db.Text()) selfie_path = db.Column(db.Text()) reg_status = db.Column(db.String(20)) created_at = db.Column(db.String(50))
class Raffle(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) name = db.Column(db.String(50)) title = db.Column(db.String(50)) description = db.Column(db.Text()) auto_draw = db.Column(db.Boolean(), default=False) limited_slots = db.Column(db.Boolean()) vacant_slots = db.Column(db.String(30)) participants = db.Column(db.Integer, default=0) created_by_id = db.Column(db.Integer) created_by_name = db.Column(db.String(100)) created_date = db.Column(db.String(20)) created_time = db.Column(db.String(10)) drawn_by_id = db.Column(db.Integer) drawn_by_name = db.Column(db.String(100)) draw_date = db.Column(db.String(20)) draw_time = db.Column(db.String(10)) start_date = db.Column(db.String(20)) end_date = db.Column(db.String(20)) dti_permit = db.Column(db.String(60)) winner_count = db.Column(db.Integer) grand_prize = db.Column(db.String(60)) min_purchase_req = db.Column(db.String(10)) ref_key = db.Column(db.String(12)) status = db.Column(db.String(10), default='Pending') created_at = db.Column(db.String(50))
class RafflePrize(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) raffle_id = db.Column(db.Integer) prize_label = db.Column(db.String(60)) prize = db.Column(db.Text()) created_at = db.Column(db.String(50))
class Shopper(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) name = db.Column(db.String(100)) msisdn = db.Column(db.String(20)) address = db.Column(db.Text()) birthday = db.Column(db.String(20)) join_date = db.Column(db.String(20)) 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 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 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)) status = db.Column(db.String(30), default='pending') created_at = db.Column(db.String(50))
class Conversation(db.Model): id = db.Column(db.Integer, primary_key=True) client_no = db.Column(db.String(32)) contact_name = db.Column(db.String(100), default=None) msisdn = db.Column(db.String(30)) display_name = db.Column(db.String(100)) status = db.Column(db.String(30),default='unread') latest_content = db.Column(db.Text()) latest_date = db.Column(db.String(20)) latest_time = db.Column(db.String(10)) created_at = db.Column(db.String(50))
class Driver(db.Model): id = db.Column(db.Integer, primary_key=True) plate_no = db.Column(db.String(10)) name = db.Column(db.String(100)) address = db.Column(db.Text()) msisdn = db.Column(db.String(20)) dl_no = db.Column(db.String(60)) car_make = db.Column(db.String(60)) car_model = db.Column(db.String(60)) car_color = db.Column(db.String(60)) status = db.Column(db.String(20)) created_at = db.Column(db.String(50))
class OutboundMessage(db.Model): id = db.Column(db.Integer, primary_key=True) batch_id = db.Column(db.Integer()) bill_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)) content = db.Column(db.Text()) 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 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 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 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 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 HouseholdImage(db.Model): id = db.Column(db.Integer, primary_key=True) household_id = db.Column(db.Integer()) path = db.Column(db.Text())