class ReportBranchParts(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblReportBranchParts"
report_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
report_date = db.Column(db.DateTime, nullable=True)
branch_id = db.Column(db.Integer, nullable=True)
payment_delivered = db.Column(db.DECIMAL(12, 2), nullable=True)
payment_sale = db.Column(db.DECIMAL(12, 2), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ReportWorkshopPurchase(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblReportWorkshopPurchase"
report_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
report_date = db.Column(db.DateTime, nullable=True)
supplier_id = db.Column(db.Integer, nullable=True)
payment = db.Column(db.DECIMAL(12, 2), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Schedule_Document(db.Model):
__tablename__ = "tbl_schedule_document"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
document_path = db.Column(db.String(500), nullable=True)
original_file_name = db.Column(db.String(100), nullable=True)
uuid_file_name = db.Column(db.String(500), nullable=True)
document_status = db.Column(db.DECIMAL(2, 2), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class DropdownList(db.Model):
""" Dropdown Model for storing dropdown related details """
__tablename__ = "tbldropdown"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
key_id = db.Column(db.String(100), nullable=True)
key_value_en = db.Column(db.String(250), nullable=True)
key_value_ma = db.Column(db.String(250), nullable=True)
type = db.Column(db.String(50), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isactive = db.Column(db.Integer, nullable=True, default=1)
class ForgotPass(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblforgotpassword"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
fid = db.Column(db.String(100), unique=True)
public_id = db.Column(db.String(100))
status = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
created_by = db.Column(db.Integer, nullable=True)
isactive = db.Column(db.Integer, nullable=True, default=1)
class Product(db.Model):
""" Product Model for storing product related details """
__tablename__ = "tblproduct"
product_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
product_name = db.Column(db.String(250), nullable=True)
product_value = db.Column(db.String(250), nullable=True)
type = db.Column(db.String(50), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class AuditLog(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblAuditLog"
audit_log_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
type = db.Column(db.String(250), nullable=True)
sub_type = db.Column(db.String(250), nullable=True)
details = db.Column(db.JSON, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Location(db.Model):
__tablename__ = "tbl_location"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
city = db.Column(db.String(255), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Role(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblrole"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
role_Id = db.Column(db.Integer, nullable=True)
role_Name = db.Column(db.String(100), nullable=True)
permission = db.Column(db.ARRAY(db.Integer), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Device(db.Model):
""" User Model for storing user related details """
__tablename__ = "tbldevice"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
device_id = db.Column(db.String(250), nullable=True)
notification_token = db.Column(db.String(250), unique=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ScheduleType(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblScheduleType"
schedule_type_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
schedule_type = db.Column(db.String(250), nullable=True)
display_name = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class MenuComponent(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblMenuComponent"
menu_component_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
component_name = db.Column(db.String(250), nullable=True)
menu_id = db.Column(db.Integer, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class PDCRegistrationInspection(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblPDCRegistrationInspection"
pdc_registration_inspection_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
pdc_registration_id = db.Column(db.Integer, nullable=True)
checklist_id = db.Column(db.Integer, nullable=True)
findings = db.Column(db.String(250), nullable=True)
inspection_status = db.Column(db.DECIMAL(4, 2), nullable=True)
approval_category = db.Column(db.Integer, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ClaimDetails(db.Model):
""" Payroll model related details """
__tablename__ = "tblclaim_details"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
claim_id = db.Column(db.Integer, nullable=True)
item = db.Column(db.String(250), nullable=True)
description = db.Column(db.String(250), nullable=True)
company_name = db.Column(db.String(250), nullable=True)
qty = db.Column(db.Integer, nullable=True)
unit_price = db.Column(db.DECIMAL(12, 2), nullable=True)
amount = db.Column(db.DECIMAL(12, 2), nullable=True)
file_path = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isactive = db.Column(db.Integer, nullable=True, default=1)
class Report_Download(db.Model):
__tablename__ = "tbl_report_downloads"
download_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
public_id = db.Column(db.String(100), nullable=True)
type = db.Column(db.String(100), nullable=True)
month = db.Column(db.String(100), nullable=True)
year = db.Column(db.String(100), nullable=True)
file_path = db.Column(db.String(500), nullable=True)
status = db.Column(db.DECIMAL(10, 1), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ReportCorrectiveHead(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblReportCorrectiveHead"
report_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
supplier_id = db.Column(db.Integer, nullable=True)
report_date = db.Column(db.DateTime, nullable=True)
department_id = db.Column(db.Integer, nullable=True)
car_no = db.Column(db.String(250), nullable=True)
quality = db.Column(db.Integer, nullable=True)
environment = db.Column(db.Integer, nullable=True)
safety = db.Column(db.Integer, nullable=True)
health = db.Column(db.Integer, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime, nullable=True, default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Menuitem(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblmenuitem"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
menu_name = db.Column(db.String(100), nullable=True)
display_name = db.Column(db.String(100), nullable=True)
order_no = db.Column(db.Integer, nullable=True)
parent_id = db.Column(db.Integer, nullable=False)
menu_code = db.Column(db.Integer, nullable=True)
# 1 = Default menu, 2 = Sheet Menu, 3 = Country Menu
submenu_type = db.Column(db.Integer, nullable=True, default=1)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Checklist(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblChecklist"
checklist_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
module = db.Column(db.Integer, nullable=True)
sub_module = db.Column(db.Integer, nullable=True)
zone = db.Column(db.Integer, nullable=True)
item_description = db.Column(db.String(250), nullable=True)
icon_name = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class InspectionItem(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblInspectionItem"
inspection_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
reference_id = db.Column(db.Integer, nullable=True)
# 1 - PDC
# 2 - PJC
# 3 - SCHEDULED MAINTENANCE
# 4 - AD HOC
# 5 - BREAKDOWN
inspection_type = db.Column(db.Integer, nullable=True)
checklist_id = db.Column(db.Integer, nullable=True)
findings = db.Column(db.String(250), nullable=True)
inspection_status = db.Column(db.DECIMAL(4, 2), nullable=True)
approval_category = db.Column(db.Integer, nullable=True)
# workshop related changes
supervisor = db.Column(db.String(250), nullable=True)
mechanic = db.Column(db.String(250), nullable=True)
inspections_defects = db.Column(db.String(250), nullable=True)
technician_remarks = db.Column(db.String(250),
nullable=True) # or Workshop Actions
workshop_status = db.Column(db.DECIMAL(4, 2), nullable=True)
date_in = db.Column(db.DateTime, nullable=True)
date_out = db.Column(db.DateTime, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class RKPLogin(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblRKP_login"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, nullable=True)
user_pubic_id = db.Column(db.String(250), nullable=True)
rt_status = db.Column(db.Integer, nullable=True)
start_date = db.Column(db.DateTime, nullable=True)
stoped_date = db.Column(db.DateTime, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ReportTracker(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblReportTracker"
report_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
report_date = db.Column(db.DateTime, nullable=True)
report_type = db.Column(db.Integer, nullable=True)
status = db.Column(db.Integer, nullable=True)
org_filename = db.Column(db.String(250), nullable=True)
uuid_filename = db.Column(db.String(250), nullable=True)
full_path = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Supplier(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblSupplier"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
public_id = db.Column(db.String(100), unique=True)
supplier_name = db.Column(db.String(250), nullable=True)
supplier_location = db.Column(db.String(250), nullable=True)
contact_number = db.Column(db.String(20), nullable=True)
email_id = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isactive = db.Column(db.Integer, nullable=True, default=1)
class Leave_Summary(db.Model):
__tablename__ = "tbl_leave_summary"
summary_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, nullable=True)
year = db.Column(db.String(100), nullable=True)
previous_year_balance = db.Column(db.Integer, nullable=True)
leave_allocated = db.Column(db.Integer, nullable=True)
annual_leave = db.Column(db.Integer, nullable=True)
medical_leave_allocated = db.Column(db.Integer, nullable=True)
medical_leave = db.Column(db.Integer, nullable=True)
leave_others = db.Column(db.Integer, nullable=True)
leave_taken = db.Column(db.DECIMAL(2, 2), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Claim(db.Model):
""" Payroll model related details """
__tablename__ = "tblclaim"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, nullable=True)
claim_no = db.Column(db.String(250), nullable=True)
emp_id = db.Column(db.String(250), nullable=True)
loc = db.Column(db.String(250), nullable=True)
department = db.Column(db.String(250), nullable=True)
claim_type = db.Column(db.String(250), nullable=True)
claim_date = db.Column(db.DateTime, nullable=True)
status = db.Column(db.DECIMAL(12, 2), nullable=True)
grand_total = db.Column(db.DECIMAL(12, 2), nullable=True)
paid_date = db.Column(db.DateTime, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isactive = db.Column(db.Integer, nullable=True, default=1)
class ScheduledMaintenance(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblScheduledMaintenance"
scheduled_maintenance_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
date_in = db.Column(db.DateTime, nullable=True)
mechanic = db.Column(db.String(250), nullable=True)
supervisor = db.Column(db.String(250), nullable=True)
mileage = db.Column(db.String(250), nullable=True)
next_due = db.Column(db.String(250), nullable=True)
rt_regn = db.Column(db.String(250), nullable=True)
trailer_regn = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class ReportCorrectiveDetail(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblReportCorrectiveDetail"
detail_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
head_id = db.Column(db.Integer, nullable=True)
description = db.Column(db.String(250), nullable=True)
part_no = db.Column(db.String(250), nullable=True)
qty = db.Column(db.DECIMAL(12, 2), nullable=True)
price = db.Column(db.DECIMAL(12, 2), nullable=True)
total = db.Column(db.DECIMAL(12, 2), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Leave_Application(db.Model):
__tablename__ = "tbl_leave_application"
leave_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, nullable=True)
from_date = db.Column(db.DateTime, nullable=True)
to_date = db.Column(db.DateTime, nullable=True)
days_of_leave = db.Column(db.String(500), nullable=True)
leave_type = db.Column(db.String(500), nullable=True)
status = db.Column(db.DECIMAL(10, 1), nullable=True)
is_after_leave_taken = db.Column(db.Integer, nullable=True)
file_path = db.Column(db.String(500), nullable=True)
reason = db.Column(db.String(500), nullable=True)
rejection_reason = db.Column(db.String(500), nullable=True)
rejected_by = db.Column(db.String(500), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class PDCRegistration(db.Model):
""" User Model for storing user related details """
__tablename__ = "tblPDCRegistration"
pdc_registration_id = db.Column(db.Integer,
primary_key=True,
autoincrement=True)
user_id = db.Column(db.Integer, nullable=True)
vehicle_id = db.Column(db.Integer, nullable=True)
schedule_id = db.Column(db.Integer, nullable=True)
rt_licence_number = db.Column(db.String(250), nullable=True)
owner_name = db.Column(db.String(250), nullable=True)
date_of_registartion = db.Column(db.DateTime, nullable=True)
date_of_expiry = db.Column(db.DateTime, nullable=True)
rt_location = db.Column(db.String(250), nullable=True)
rt_category = db.Column(db.String(250), nullable=True)
rt_load = db.Column(db.String(250), nullable=True)
rt_type = db.Column(db.String(250), nullable=True)
inspection_category = db.Column(db.Integer, nullable=True)
inspection_notes = db.Column(db.String(250), nullable=True)
# Here approval related changes
# 0 - saved
# 1 - submitted / pending
# 2 - Approved
# 3 - Rejected
approval_status = db.Column(db.DECIMAL(4, 2), nullable=True)
approved_date = db.Column(db.DateTime, nullable=True)
approved_by = db.Column(db.Integer, nullable=True)
approval_notes = db.Column(db.String(250), nullable=True)
# approval ends
brake_lining_pad_thickness_pm = db.Column(JSONB, nullable=True)
brake_lining_pad_thickness_trailer = db.Column(JSONB, nullable=True)
clutch_Details_info = db.Column(JSONB, nullable=True)
date_in = db.Column(db.DateTime, nullable=True)
date_out = db.Column(db.DateTime, nullable=True)
mechanic = db.Column(db.String(250), nullable=True)
supervisor = db.Column(db.String(250), nullable=True)
mileage = db.Column(db.String(250), nullable=True)
next_due = db.Column(db.String(250), nullable=True)
rt_regn = db.Column(db.String(250), nullable=True)
trailer_regn = db.Column(db.String(250), nullable=True)
remarks = db.Column(db.String(500), nullable=True)
inspection_type = db.Column(db.Integer, nullable=True)
repair_overhaul = db.Column(db.String(250), nullable=True)
welding_shop = db.Column(db.String(250), nullable=True)
tyre_shop = db.Column(db.String(250), nullable=True)
completed_status = db.Column(db.DECIMAL(10, 1), nullable=True)
is_acknowledged = db.Column(db.Boolean, nullable=True)
acknowledged_date = db.Column(db.DateTime, nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class WorkshopParts(db.Model):
""" Workshop Parts Model for storing user related details """
__tablename__ = "tblWorkshopParts"
parts_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
pdcregistration_reference_id = db.Column(db.Integer)
inspection_reference_id = db.Column(db.Integer)
regn_no = db.Column(db.String(250), nullable=True)
parts = db.Column(db.String(250), nullable=True)
parts_no = db.Column(db.String(250), nullable=True)
quantity = db.Column(db.String(250), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
class Insurance(db.Model):
__tablename__ = "tbl_insurance"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
public_id = db.Column(db.String(255), nullable=False)
vehicle_id = db.Column(db.Integer, nullable=True)
policy = db.Column(db.String(300), nullable=True)
loc = db.Column(db.String(300), nullable=True)
ref_no = db.Column(db.String(300), nullable=True)
due_date = db.Column(db.DateTime, nullable=True)
bank_or_insurer = db.Column(db.String(300), nullable=True)
amount = db.Column(db.DECIMAL(12, 4), nullable=True)
remarks = db.Column(db.String(300), nullable=True)
types = db.Column(db.String(300), nullable=True)
created_by = db.Column(db.Integer, nullable=True)
updated_by = db.Column(db.Integer, nullable=True)
created_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
updated_date = db.Column(db.DateTime,
nullable=True,
default=datetime.datetime.utcnow())
isActive = db.Column(db.Integer, nullable=True, default=1)
