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)