Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v truckingbusiness account_transfers
* id : int(11)
* transfer_date : date
* amount : decimal(15,2)
* currency : varchar(8)
* currency_amount : decimal(15,2)
* reason : varchar(512)
* from_payment_method : varchar(64)
* to_payment_method : varchar(64)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness advance_documents
* id : int(11)
* advance_id : int(11)
* url : varchar(255)
* file_name : varchar(255)
* uploaded_at : timestamp
v truckingbusiness advance_expense_documents
* id : int(11)
* advance_expense_id : int(11)
* url : varchar(1000)
* file_name : varchar(255)
* mime_type : varchar(120)
* uploaded_at : timestamp
v truckingbusiness advance_expense_usage
* id : int(11)
* trip_id : int(11)
* date : date
* amount : decimal(10,2)
* service : varchar(255)
* category : enum('maintenance','other','diesel','border charges','personal','miscellaneous')
* created_at : timestamp
* updated_at : timestamp
* qashio : tinyint(1)
v truckingbusiness advance_tracker
* id : int(11)
* employee_name : varchar(255)
* amount : decimal(10,2)
* trip_date : date
* trip_id : int(11)
* status : enum('received','deducted')
* deduction_date : date
* deduction_source : text
* created_at : timestamp
* updated_at : timestamp
* currency : enum('AED','SAR','QAR','KWD','BHD','OMR','INR')
* currency_amount : decimal(10,2)
* petty_cash : tinyint(1)
* qashio : tinyint(1)
* advance_payment_method : varchar(32)
* payment_reference : varchar(255)
* bulk_advance_id : int(11)
v truckingbusiness app_roles
* id : int(11)
* slug : varchar(64)
* display_name : varchar(128)
* is_system : tinyint(1)
* created_at : timestamp
v truckingbusiness app_role_permissions
* id : int(11)
* role_id : int(11)
* path_prefix : varchar(512)
v truckingbusiness cash_trip_payment_entries
* id : int(11)
* trip_id : int(11)
* client_name : varchar(255)
* batch_total_amount : decimal(14,2)
* company : varchar(50)
* trip_ids : longtext
* allocations : longtext
* batch_receipt_upload : varchar(512)
* amount : decimal(12,2)
* channel : varchar(32)
* payment_date : date
* payment_id : int(11)
* created_at : timestamp
* currency : varchar(8)
* currency_amount : decimal(15,2)
* remarks : varchar(1024)
v truckingbusiness city_exchange_pension
* id : int(11)
* company_name : varchar(255)
* pension_month : date
* mol_id : varchar(64)
* phone_number : varchar(64)
* amount : decimal(15,2)
* com_amount : decimal(15,2)
* include_vat : tinyint(1)
* vat_amount : decimal(15,2)
* net_amount : decimal(15,2)
* payment_method : varchar(32)
* payment_date : date
* attachment_1 : varchar(512)
* attachment_2 : varchar(512)
* attachment_3 : varchar(512)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness city_exchange_reimbursement
* id : bigint(20) unsigned
* company_name : varchar(32)
* year : smallint(6)
* month_no : tinyint(4)
* amount : decimal(12,2)
* payment_method : varchar(40)
* pay_date : date
* docs : text
* remarks : text
* created_at : timestamp
* updated_at : timestamp
* reimbursement_month : date
* attachment_1 : varchar(512)
* attachment_2 : varchar(512)
* attachment_3 : varchar(512)
v truckingbusiness city_exchange_salary
* id : int(11)
* company_name : varchar(255)
* total_employees : int(11)
* salary_month : date
* salary_amount : decimal(15,2)
* sif_charges : decimal(15,2)
* service_charges : decimal(15,2)
* atm_charges : decimal(15,2)
* discount : decimal(15,2)
* include_vat : tinyint(1)
* vat_rate : decimal(10,4)
* vat_amount : decimal(15,2)
* total_amount : decimal(15,2)
* payment_method : varchar(32)
* payment_date : date
* attachment_1 : varchar(512)
* attachment_2 : varchar(512)
* attachment_3 : varchar(512)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness clients
* name : varchar(50)
* address : text
* tel_no : varchar(20)
* po_box : int(10)
* trn_no : varchar(17)
* contact_person : varchar(50)
* person_number : varchar(20)
v truckingbusiness client_share_accounts
* id : int(11)
* client_id : varchar(50)
* trip_id : int(11)
* amount_due : decimal(10,2)
* paid : tinyint(1)
v truckingbusiness company
* name : varchar(10)
v truckingbusiness company_documents
* id : int(11)
* name : varchar(255)
* icon : varchar(64)
* file_name : varchar(255)
* file_path : varchar(512)
* expiry_date : date
* created_at : timestamp
v truckingbusiness company_expense_documents
* id : int(11)
* expense_id : int(11)
* url : varchar(1000)
* file_name : varchar(255)
* mime_type : varchar(120)
* uploaded_at : timestamp
v truckingbusiness dashboard_notes
* id : int(11)
* title : varchar(500)
* note : text
* status : varchar(32)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness diesel
* id : int(11)
* date : date
* driver_name : varchar(255)
* vehicle_number : varchar(255)
* types : enum('purchased','sold')
* liter : decimal(10,2)
* amount : decimal(10,2)
* currency : varchar(10)
* paid_from_advance : tinyint(1)
* trip_id : int(11)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness diesel_documents
* id : int(11)
* diesel_id : int(11)
* url : varchar(500)
* file_name : varchar(255)
* uploaded_at : timestamp
v truckingbusiness driver_salaries
* id : int(11)
* employee_name : varchar(100)
* month : int(2)
* year : int(4)
* base_salary : decimal(10,2)
* working_days : int(2)
* trip_allowance : decimal(10,2)
* visa_deduction : decimal(10,2)
* advance_deduction : decimal(10,2)
* fine_deduction : decimal(10,2)
* diesel_sold : decimal(10,2)
* net_salary : decimal(10,2)
* payment_status : enum('pending','paid')
* payment_date : date
* payment_method : varchar(32)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness employees
* employee : varchar(100)
* refered_as : varchar(25)
* designation : varchar(100)
* contact_no : varchar(25)
* whatsapp_no : varchar(25)
* salary : int(11)
* visa_outstanding : int(11)
* advance_avl : int(11)
* visa_under : varchar(10)
* visa_exp : date
* nationality : varchar(30)
* eid : varchar(100)
* health_ins_exp : date
* emp_ins_exp : date
* license_exp : date
* status : varchar(10)
v truckingbusiness employee_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* employee_name : varchar(100)
v truckingbusiness expense_payment_logs
* id : int(11)
* miscellaneous_id : int(11)
* payment_date : date
* amount : decimal(10,2)
* method : varchar(225)
* reference_no : varchar(100)
* notes : text
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness fines
* id : int(11)
* trip_id : int(11)
* reason : text
* truck_number : varchar(50)
* driver_name : varchar(100)
* driver_fault : tinyint(1)
* fine_date : date
* amount : decimal(10,2)
* payment_status : varchar(50)
* paid_by : varchar(255)
* salary_id : int(11)
v truckingbusiness fine_documents
* fine_id : int(11)
* url : varchar(255)
* uploaded_at : date
v truckingbusiness inventory_parts
* id : int(11)
* date : date
* name : varchar(100)
* cost : decimal(10,2)
* remarks : text
* photo_url : varchar(255)
v truckingbusiness inventory_tir
* id : int(11)
* number : varchar(50)
* quantity : int(11)
* cost : decimal(10,2)
* remarks : text
v truckingbusiness investor1_accounts
* id : int(11)
* date : date
* trip_id : int(11)
* fixed_tir_price : decimal(10,2)
* sold_tir_price : decimal(10,2)
* amount_due : decimal(10,2)
* paid : tinyint(1)
* tir_number : varchar(50)
* remarks : text
v truckingbusiness invoice
* id : int(11)
* invoice_number : varchar(50)
* client : varchar(255)
* url : varchar(255)
* date : date
* price : decimal(10,2)
* status : varchar(50)
* approval_status : enum('pending','approved','rejected')
* approved_by : varchar(255)
* approved_at : timestamp
* trip_ids : text
* include_vat : tinyint(1)
* include_vat_company_rate : tinyint(1)
* vat_amount : decimal(10,2)
* total_with_vat : decimal(10,2)
* due_date : date
* company : varchar(50)
* invoice_destination : enum('OMAN','GCC','LOCAL')
v truckingbusiness invoice_bulk_payments
* id : int(11)
* payment_group_id : int(11)
* client_name : varchar(255)
* company : varchar(50)
* invoice_id : int(11)
* invoice_ids : longtext
* allocations : longtext
* amount : decimal(14,2)
* payment_date : date
* channel : varchar(32)
* created_at : timestamp
* remarks : text
v truckingbusiness invoice_credit_notes
* id : int(11)
* invoice_id : int(11)
* company : varchar(32)
* credit_date : date
* amount : decimal(12,2)
* vat_applied : tinyint(1)
* created_at : timestamp
v truckingbusiness invoice_items
* id : int(11)
* invoice_id : int(11)
* trip_id : int(11)
* date : date
* description : text
* d_o : varchar(255)
* qty : decimal(10,2)
* unit : varchar(50)
* price : decimal(10,2)
* amount : decimal(10,2)
* lpo_no : varchar(255)
* driver_name : varchar(255)
* truck_no : varchar(255)
* extra_delivery_details : text
* created_at : timestamp
* updated_at : timestamp
* is_bold : tinyint(1)
* item_order : int(11)
v truckingbusiness invoice_payments
* id : int(11)
* invoice_id : int(11)
* amount : decimal(14,2)
* channel : enum('petty_cash','qashio','cheque','bank_transfer')
* payment_date : date
* bulk_payment_id : int(11)
* created_at : timestamp
v truckingbusiness kec_invoice_item_remarks
* id : int(11)
* invoice_id : int(11)
* invoice_item_id : int(11)
* remark : text
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness kec_invoice_item_share_amounts
* id : int(11)
* invoice_id : int(11)
* invoice_item_id : int(11)
* share_amount : decimal(12,2)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness kec_invoice_remarks
* id : int(11)
* invoice_id : int(11)
* remark : text
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness kec_projects
* id : int(11)
* name : varchar(255)
* created_at : timestamp
v truckingbusiness kec_project_invoices
* id : int(11)
* project_id : int(11)
* invoice_id : int(11)
* added_at : timestamp
v truckingbusiness kec_project_payments
* id : int(11)
* project_id : int(11)
* payment_date : date
* amount : decimal(12,2)
* remarks : text
* payment_method : varchar(32)
* receipt_upload : varchar(500)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness logs
* id : int(11)
* user : varchar(255)
* action : text
* description : text
* timestamp : timestamp
v truckingbusiness master_accounts
* id : int(11)
* month : int(11)
* year : int(11)
* income : decimal(10,2)
* expense : decimal(10,2)
* net_profit : decimal(10,2)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness master_account_details
* id : int(11)
* master_account_id : int(11)
* category : enum('TRIP_PROFIT','OUTSIDE_ACCOUNT','MAINTENANCE','FINE','SALARY','MISCELLANEOUS','DIESEL','CLIENT_SHARE','INVESTOR_SHARE','VAT')
* reference_id : int(11)
* amount : decimal(10,2)
* type : enum('INCOME','EXPENSE')
* description : text
* created_at : timestamp
v truckingbusiness miscellaneous
* id : int(11)
* date : date
* category : varchar(225)
* description : text
* amount : decimal(10,2)
* vat : decimal(10,2)
* total : decimal(10,2)
* reference_no : varchar(50)
* status : enum('pending','partial','completed')
* flow_type : enum('inflow','outflow')
* petty_cash : tinyint(1)
* prepaid_expense : tinyint(1)
* prepaid_start_date : date
* prepaid_end_date : date
* prepaid_write_off_date : date
* paid_from_advance : tinyint(1)
* trip_id : int(11)
* company : varchar(10)
* remarks : text
* document_url : varchar(255)
* created_at : timestamp
* updated_at : timestamp
* trn : varchar(50)
* supplier : varchar(255)
* truck_number : varchar(64)
* employee_name : varchar(255)
v truckingbusiness miscellaneous_categories
* id : int(11)
* name : varchar(100)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness other_employees
* employee : varchar(100)
* owner : varchar(50)
* refered_as : varchar(25)
* designation : varchar(100)
* contact_no : varchar(25)
* whatsapp_no : varchar(25)
* visa_under : varchar(10)
* visa_exp : date
* nationality : varchar(30)
* eid : varchar(25)
* health_ins_exp : date
* emp_ins_exp : date
* license_exp : date
v truckingbusiness other_employee_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* employee_name : varchar(100)
v truckingbusiness other_owner
* name : varchar(50)
* remarks : text
* eid : varchar(100)
* phone_number : varchar(20)
* whatsapp_number : varchar(20)
* address : text
v truckingbusiness other_trailer
* trailer_no : varchar(25)
* owner : varchar(50)
* company_under : varchar(50)
* mulkiya_exp : date
* oman_ins_exp : date
v truckingbusiness other_trailer_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* other_trailer_number : varchar(20)
v truckingbusiness other_trucks
* truck_number : varchar(20)
* owner : varchar(50)
* driver : varchar(50)
* year : int(11)
* vehicle_under : varchar(10)
* trailer_no : varchar(25)
* country : varchar(15)
* mulkiya_exp : date
* ins_exp : date
v truckingbusiness other_trucks_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* other_truck_number : varchar(20)
v truckingbusiness outside_accounts
* id : int(11)
* date : date
* owner : varchar(50)
* driver : varchar(100)
* truck : varchar(50)
* remark : varchar(225)
* amount : decimal(10,2)
* status : enum('PAID','UNPAID','PARTIALLY_PAID')
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness outside_account_documents
* id : int(11)
* account_id : int(11)
* url : varchar(255)
* file_name : varchar(255)
* uploaded_at : datetime
* document_type : varchar(50)
v truckingbusiness outside_account_payments
* id : int(11)
* payment_id : int(11)
* owner_name : varchar(255)
* batch_total_amount : decimal(14,2)
* account_ids : longtext
* allocations : longtext
* channel : varchar(32)
* batch_receipt_upload : varchar(512)
* account_id : int(11)
* amount : decimal(10,2)
* payment_date : date
* remark : varchar(255)
* created_at : timestamp
v truckingbusiness outsource_advance_details
* id : int(11)
* trip_id : int(11)
* party_name : varchar(255)
* trip_date : date
* amount : decimal(10,2)
* status : enum('received','deducted')
* deduction_date : date
* deduction_source : text
* currency : enum('AED','SAR','QAR','KWD','BHD','OMR','INR')
* currency_amount : decimal(10,2)
* petty_cash : tinyint(1)
* qashio : tinyint(1)
* advance_payment_method : varchar(32)
* payment_reference : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness payment_types
* id : int(11)
* code : varchar(64)
* name : varchar(64)
* company : varchar(32)
* display_name : varchar(255)
* account_kind : varchar(32)
* account : varchar(255)
* description : text
* is_credit : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness pdc
* id : int(11)
* chq_no : varchar(50)
* issued_from : varchar(255)
* issued_to : varchar(255)
* issued_for : text
* amount : decimal(10,2)
* chq_dated : date
* pdc_days_left : varchar(50)
* status : enum('PENDING','CLEARED','BOUNCED')
* picture_path : varchar(500)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness personal_advance
* id : int(11)
* employee_name : varchar(255)
* amount : decimal(10,2)
* advance_date : date
* status : enum('unpaid','partially_paid','paid')
* remarks : text
* currency : enum('AED','SAR','QAR','KWD','BHD','OMR','INR')
* currency_amount : decimal(10,2)
* petty_cash : tinyint(1)
* qashio : tinyint(1)
* advance_payment_method : varchar(32)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness personal_advance_payments
* id : int(11)
* personal_advance_id : int(11)
* payment_date : date
* amount : decimal(10,2)
* source : enum('salary','returned')
* payment_method : varchar(32)
* remarks : text
* salary_id : int(11)
* receipt_upload : varchar(500)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness qashio_erp_transactions
* id : int(11)
* qashio_id : varchar(64)
* transaction_category : varchar(64)
* transaction_time : datetime(3)
* billing_amount : decimal(14,4)
* billing_currency : varchar(8)
* transaction_amount : decimal(14,4)
* transaction_currency : varchar(8)
* memo : text
* merchant_name : varchar(512)
* expense_category_name : varchar(255)
* card_name : varchar(255)
* card_last_four : varchar(8)
* card_holder_name : varchar(255)
* raw_json : longtext
* synced_at : timestamp
* assigned_trip_id : int(11)
* assigned_kind : enum('purchase','cash_withdrawal')
* assigned_at : timestamp
* voided : tinyint(1)
* voided_at : timestamp
* linked_trip_expense_id : int(11)
* linked_advance_tracker_id : int(11)
* marked_synced : tinyint(1)
* remark : varchar(2048)
* clearing_delta : decimal(18,4)
* qashio_txn_id : varchar(64)
* parent_txn_id : varchar(64)
* message_type : varchar(32)
v truckingbusiness salary_documents
* id : int(11)
* salary_id : int(11)
* url : varchar(255)
* file_name : varchar(255)
* document_type : enum('receipt','slip')
* uploaded_at : timestamp
v truckingbusiness salary_na
* employee_name : varchar(100)
* year : int(4)
* month : int(2)
* created_at : timestamp
v truckingbusiness suppliers
* name : varchar(50)
* tel_no : varchar(15)
* contact_person : varchar(25)
* phone_no : varchar(15)
* about : text
* trn : varchar(50)
v truckingbusiness tax_submitted
* id : int(11)
* payment_date : date
* company_name : varchar(32)
* assigned_months : longtext
* payment_method : varchar(32)
* payment_amount : decimal(15,2)
* remarks : text
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness tir_sold_payment_log
* id : int(11)
* payment_date : date
* amount : decimal(15,2)
* remarks : varchar(500)
* payment_method : varchar(32)
* created_at : timestamp
v truckingbusiness tir_stock_additions
* id : int(11)
* quantity : int(11)
* added_at : datetime
* remarks : varchar(512)
v truckingbusiness tir_stock_settings
* id : tinyint(4)
* quantity : int(11)
* unit_cost : decimal(12,2)
* updated_at : timestamp
v truckingbusiness trailers
* trailer_no : varchar(25)
* company_under : varchar(50)
* mulkiya_exp : date
* oman_ins_exp : date
* asset_value : int(11)
* status : varchar(10)
v truckingbusiness trailer_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* trailer_number : varchar(25)
v truckingbusiness trips
* id : int(11)
* date : date
* destination_country : varchar(50)
* service_provider : varchar(50)
* client : varchar(100)
* trip_description : text
* remarks : text
* trip_type : enum('OWN','OUTSOURCED')
* return_load : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* tons : decimal(10,2)
* unit : varchar(50)
* cash_trip_receipt_upload : varchar(512)
v truckingbusiness trip_charges
* id : int(11)
* trip_id : int(11)
* uae_border : decimal(10,2)
* uae_border_details : text
* international_border : decimal(10,2)
* international_border_details : text
* custom : decimal(10,2)
* extra_delivery : decimal(10,2)
* extra_delivery_details : text
* driver_extra_rate : decimal(10,2)
* extra_charges : decimal(10,2)
* extra_charges_details : text
* paid_by_client : decimal(10,2)
* paid_by_client_details : text
* expense : decimal(10,2)
* tons : decimal(10,2)
* unit : varchar(50)
v truckingbusiness trip_documents
* id : int(11)
* trip_id : int(11)
* lpo_no : varchar(50)
* dio_no : varchar(50)
* tir_no : varchar(50)
* tir_price : decimal(10,2)
v truckingbusiness trip_documents_files
* id : int(11)
* trip_id : int(11)
* type : varchar(50)
* url : varchar(255)
* upload_date : date
v truckingbusiness trip_expenses
* id : int(11)
* trip_id : int(11)
* date : date
* amount : decimal(10,2)
* service : varchar(255)
* outsource_expense : tinyint(1)
* category : varchar(50)
* created_at : timestamp
* updated_at : timestamp
* qashio : tinyint(1)
* expense_payment_method : varchar(32)
v truckingbusiness trip_financials
* id : int(11)
* trip_id : int(11)
* company_rate : decimal(10,2)
* driver_rate : decimal(10,2)
* trip_rate : decimal(10,2)
* advance : decimal(10,2)
* advance_expense : decimal(10,2)
* receivable_client : decimal(10,2)
* receivable_status : enum('UNPAID','PAID','CASH')
* outsource_payment : decimal(10,2)
* payable_status : enum('UNPAID','PAID')
* outsource_payment_method : varchar(32)
* outsource_payment_reference : varchar(255)
* truck_profit : decimal(10,2)
* company_profit : decimal(10,2)
* remaining_advance : decimal(10,2)
v truckingbusiness trip_investors
* id : int(11)
* trip_id : int(11)
* investor_type : enum('INVESTOR1','INVESTOR2','INVESTOR3','INVESTOR4','INVESTOR5','CLIENT')
* share_amount : decimal(10,2)
v truckingbusiness trip_paid_by_client
* id : int(11)
* trip_id : int(11)
* date : date
* amount : decimal(10,2)
* service : varchar(255)
* DO_num : varchar(225)
* tons : decimal(10,2)
* unit : varchar(50)
* invoice_include_vat : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v truckingbusiness trip_resources
* id : int(11)
* trip_id : int(11)
* truck_no : varchar(50)
* driver : varchar(100)
* other_truck_no : varchar(50)
* other_driver : varchar(100)
* other_driver_contact : varchar(50)
* other_owner : varchar(100)
* other_owner_number : varchar(50)
* diesel : decimal(10,2)
* diesel_sold : decimal(10,2)
v truckingbusiness truckmaintenance
* id : int(11)
* date : date
* driver_name : varchar(100)
* truck_number : varchar(20)
* vehicle_under : varchar(10)
* maintenance_detail : text
* credit_card : decimal(10,2)
* bank : decimal(10,2)
* cash : decimal(10,2)
* vat : decimal(10,2)
* round_off : decimal(10,4)
* total : decimal(10,2)
* status : varchar(20)
* supplier : varchar(50)
* trip_id : int(11)
* paid_from_advance : tinyint(1)
* petty_cash : tinyint(1)
* qashio_amount : decimal(10,2)
* include_vat : tinyint(1)
v truckingbusiness truckmaintenance_payments
* id : int(11)
* payment_id : int(11)
* supplier_name : varchar(255)
* batch_total_amount : decimal(14,2)
* maintenance_ids : longtext
* allocations : longtext
* batch_receipt_upload : varchar(512)
* truck_maintenance_id : int(11)
* amount : decimal(10,2)
* channel : varchar(32)
* payment_date : date
* created_at : timestamp
v truckingbusiness truckmaintenance_receipts
* id : int(11)
* truck_number : varchar(20)
* url : varchar(255)
* uploaded_at : date
* truck_maintenance_id : int(11)
v truckingbusiness trucks
* truck_number : varchar(20)
* driver : varchar(30)
* year : int(11)
* vehicle_under : varchar(10)
* trailer_no : varchar(25)
* country : varchar(15)
* mulkiya_exp : date
* ins_exp : date
* truck_value : int(11)
* status : varchar(10)
v truckingbusiness truck_documents
* id : int(11)
* type : varchar(50)
* url : varchar(100)
* uploadDate : date
* truck_number : varchar(20)
v truckingbusiness users
* id : int(11)
* username : varchar(50)
* password_hash : varchar(255)
* email : varchar(100)
* created_at : datetime
* role : varchar(64)
* last_modified : timestamp
* active : tinyint(1)
* last_login : timestamp
v truckingbusiness vehicle_status
* id : int(11)
* truck_number : varchar(50)
* driver : varchar(100)
* vehicle_under : varchar(50)
* status : varchar(20)
* comment : text
* date : date
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship