class RaffleBrand(db.Model):
id = db.Column(db.Integer, primary_key=True)
client_no = db.Column(db.String(32))
raffle_id = db.Column(db.Integer)
brand_name = db.Column(db.String(60))
brand_code = db.Column(db.String(60))
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 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 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 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 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 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 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 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 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 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 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 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 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 AdminUser(db.Model):
id = db.Column(db.Integer,primary_key=True)
client_no = db.Column(db.String(32))
email = db.Column(db.String(60))
password = db.Column(db.String(20))
temp_pw = db.Column(db.String(20))
name = db.Column(db.String(100))
role = db.Column(db.String(30))
active_sort = db.Column(db.String(30))
added_by_id = 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 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 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 AdminUser(db.Model):
id = db.Column(db.Integer, primary_key=True)
client_no = db.Column(db.String(32))
email = db.Column(db.String(60))
password = db.Column(db.String(20))
name = db.Column(db.String(100))
role = db.Column(db.String(30))
status = db.Column(db.String(8), default='Active')
added_by_id = 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 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 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 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 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 AdminUser(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(60))
password = db.Column(db.String(20))
name = db.Column(db.String(100))
status = db.Column(db.String(8), default='Active')
added_by_id = db.Column(db.Integer)
added_by_name = db.Column(db.String(100))
join_date = db.Column(db.String(50))
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 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 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 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 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 Service(db.Model):
id = db.Column(db.Integer, primary_key=True)
client_no = db.Column(db.String(32))
name = db.Column(db.String(30))
price = db.Column(db.String(10))
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))
