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 ums_garage advance_salary
* id : varchar(36)
* user_id : varchar(36)
* period_year : int(11)
* period_month : int(11)
* amount : decimal(12,2)
* expense_id : varchar(36)
* branch_id : varchar(36)
* created_at : timestamp
v ums_garage branches
* id : varchar(36)
* name : varchar(255)
* code : varchar(20)
* address : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v ums_garage bulk_payment_invoices
* id : varchar(36)
* customer_payment_id : varchar(36)
* invoice_id : varchar(36)
* invoice_number : varchar(50)
* amount_paid : decimal(12,2)
* remaining_before : decimal(12,2)
* created_at : timestamp
v ums_garage company_documents
* id : varchar(36)
* branch_id : varchar(36)
* document_type : varchar(80)
* file_url : varchar(500)
* label : varchar(255)
* created_at : timestamp
v ums_garage company_settings
* id : int(11)
* company_name : varchar(255)
* tagline : varchar(255)
* address : varchar(500)
* phone : varchar(50)
* email : varchar(100)
* logo_url : varchar(500)
* created_at : timestamp
* updated_at : timestamp
* trn : varchar(50)
* no_trn : tinyint(1)
* vehicle_inspection_enabled : tinyint(1)
* branch_id : varchar(36)
* signature_terms_and_conditions : text
v ums_garage customers
* id : varchar(36)
* user_id : varchar(36)
* first_name : varchar(100)
* last_name : varchar(100)
* display_name : varchar(255)
* gender : enum('male','female','other')
* mobile_number : varchar(20)
* email : varchar(255)
* password_hash : varchar(255)
* date_of_birth : date
* image_url : varchar(500)
* address : text
* total_spent : decimal(10,2)
* last_visit : timestamp
* created_at : timestamp
* updated_at : timestamp
* is_b2b : tinyint(1)
* company_name : varchar(255)
* trn_number : varchar(50)
* credit_terms : varchar(100)
* special_discount : decimal(5,2)
* contact_person : varchar(255)
v ums_garage customer_payments
* id : varchar(36)
* invoice_id : varchar(36)
* job_card_id : varchar(36)
* customer_id : varchar(36)
* invoice_number : varchar(50)
* customer_name : varchar(255)
* customer_phone : varchar(50)
* vehicle_license_plate : varchar(50)
* amount : decimal(10,2)
* payment_method : varchar(50)
* payment_date : timestamp
* advance_applied : decimal(10,2)
* invoice_subtotal : decimal(10,2)
* invoice_tax : decimal(10,2)
* invoice_total : decimal(10,2)
* invoice_remaining_before : decimal(10,2)
* invoice_remaining_after : decimal(10,2)
* notes : text
* created_at : timestamp
* payment_type : varchar(50)
* branch_id : varchar(36)
* is_bulk_payment : tinyint(1)
v ums_garage expenses
* id : varchar(36)
* description : text
* amount : decimal(10,2)
* tax : decimal(10,2)
* total_amount : decimal(10,2)
* quantity : int(11)
* unit_price : decimal(10,2)
* category : varchar(64)
* payment_method : enum('cash','card','bank_transfer','check')
* payment_date : timestamp
* status : enum('paid','pending','overdue')
* vendor : varchar(255)
* invoice_number : varchar(100)
* notes : text
* trn : varchar(50)
* approved_by : varchar(36)
* created_at : timestamp
* source_type : varchar(50)
* source_id : varchar(36)
* branch_id : varchar(36)
v ums_garage expense_categories
* id : varchar(36)
* branch_id : varchar(36)
* code : varchar(64)
* display_name : varchar(150)
* sort_order : int(11)
* created_at : timestamp
v ums_garage garage_tools
* id : varchar(36)
* branch_id : varchar(36)
* name : varchar(255)
* category : varchar(64)
* description : text
* manufacturer : varchar(150)
* model : varchar(150)
* serial_number : varchar(100)
* asset_tag : varchar(64)
* status : varchar(32)
* location : varchar(255)
* acquired_date : date
* acquired_cost : decimal(12,2)
* last_inspection_date : date
* next_inspection_due : date
* notes : text
* created_at : timestamp
* updated_at : timestamp
v ums_garage income
* id : varchar(36)
* customer_name : varchar(255)
* invoice_number : varchar(50)
* amount : decimal(10,2)
* payment_method : enum('cash','card','bank_transfer','check')
* payment_date : timestamp
* status : enum('completed','pending','failed')
* category : varchar(64)
* description : text
* received_by : varchar(36)
* created_at : timestamp
* source : varchar(20)
* customer_payment_id : varchar(36)
* branch_id : varchar(36)
v ums_garage income_categories
* id : varchar(36)
* branch_id : varchar(36)
* code : varchar(64)
* display_name : varchar(150)
* sort_order : int(11)
* created_at : timestamp
v ums_garage inventory_packages
* id : char(36)
* branch_id : char(36)
* name : varchar(255)
* supplier_id : char(36)
* product_id : char(36)
* package_quantity : decimal(10,2)
* buying_price : decimal(10,2)
* created_at : timestamp
* updated_at : timestamp
v ums_garage invoices
* id : varchar(36)
* proforma_invoice_id : varchar(36)
* job_card_id : varchar(36)
* customer_id : varchar(36)
* quotation_id : varchar(36)
* invoice_number : varchar(50)
* subtotal : decimal(10,2)
* tax : decimal(10,2)
* total_amount : decimal(10,2)
* advance_amount : decimal(10,2)
* remaining_amount : decimal(10,2)
* status : enum('draft','sent','partially-paid','fully-paid','overdue')
* due_date : timestamp
* paid_date : timestamp
* payment_method : varchar(50)
* notes : text
* customer_name : varchar(255)
* customer_email : varchar(255)
* customer_phone : varchar(50)
* vehicle_brand : varchar(100)
* vehicle_name : varchar(100)
* vehicle_year : int(11)
* vehicle_license_plate : varchar(50)
* vin_number : varchar(100)
* created_at : timestamp
* updated_at : timestamp
* branch_id : varchar(36)
* sales_vat_exempt : tinyint(1)
* discount : decimal(10,2)
v ums_garage invoice_items
* id : varchar(36)
* invoice_id : varchar(36)
* description : varchar(255)
* quantity : int(11)
* unit_price : decimal(10,2)
* total : decimal(10,2)
* cost_price : decimal(10,2)
* vendor_name : varchar(255)
* vat_for_expense : tinyint(1)
* proforma_invoice_item_id : varchar(36)
* type : enum('service','part','outsourced')
* supplier_id : varchar(36)
* product_id : varchar(36)
* stock_deducted : tinyint(1)
* created_at : timestamp
* discount : decimal(10,2)
v ums_garage job_cards
* id : varchar(36)
* job_card_number : varchar(50)
* quotation_id : varchar(36)
* customer_id : varchar(36)
* vehicle_id : varchar(36)
* assigned_to : varchar(36)
* status : enum('pending','in-progress','completed','cancelled')
* priority : enum('low','medium','high','urgent')
* start_date : timestamp
* completion_date : timestamp
* actual_labor_hours : decimal(5,2)
* notes : text
* subtotal : decimal(10,2)
* tax : decimal(10,2)
* total_amount : decimal(10,2)
* created_at : timestamp
* updated_at : timestamp
* advance_amount : decimal(10,2)
* vehicle_inspection_report_id : varchar(36)
* branch_id : varchar(36)
* sales_vat_exempt : tinyint(1)
* discount : decimal(10,2)
* lpo_number : varchar(100)
* vehicle_km : int(11)
v ums_garage job_card_assignments
* id : varchar(36)
* job_card_id : varchar(36)
* user_id : varchar(36)
* expected_labour_hours : decimal(5,2)
* labour_hours : decimal(5,2)
* created_at : timestamp
v ums_garage job_card_before_after
* id : varchar(36)
* job_card_id : varchar(36)
* before_file_path : varchar(500)
* after_file_path : varchar(500)
* description : text
* sort_order : int(11)
* created_at : timestamp
v ums_garage job_card_hidden_expenses
* id : varchar(36)
* job_card_id : varchar(36)
* description : varchar(500)
* amount_aed : decimal(10,2)
* payment_method : varchar(50)
* vat_applied : tinyint(1)
* created_at : timestamp
* expense_type : enum('part','outsourced','service')
* supplier_id : char(36)
* product_id : char(36)
* quantity : decimal(10,2)
* unit_price : decimal(10,2)
* cost_price : decimal(10,2)
* vendor_name : varchar(255)
v ums_garage job_card_items
* id : varchar(36)
* job_card_id : varchar(36)
* description : varchar(255)
* quantity : int(11)
* unit_price : decimal(10,2)
* total : decimal(10,2)
* cost_price : decimal(10,2)
* vendor_name : varchar(255)
* vat_for_expense : tinyint(1)
* type : enum('service','part','outsourced')
* supplier_id : varchar(36)
* product_id : varchar(36)
* created_at : timestamp
* is_done : tinyint(1)
* discount : decimal(10,2)
v ums_garage job_card_photos
* id : varchar(36)
* job_card_id : varchar(36)
* file_path : varchar(500)
* caption : varchar(500)
* type : enum('before','after','damage','other')
* created_at : timestamp
v ums_garage job_card_signatures
* id : varchar(36)
* job_card_id : varchar(36)
* signature_data_url : longtext
* signed_at : datetime
* created_at : datetime
v ums_garage job_card_tasks
* id : varchar(36)
* job_card_id : varchar(36)
* description : varchar(500)
* completed : tinyint(1)
* sort_order : int(11)
* created_at : timestamp
v ums_garage products
* id : varchar(36)
* supplier_id : varchar(36)
* name : varchar(255)
* description : text
* sku : varchar(100)
* category : varchar(100)
* unit_price : decimal(10,2)
* cost_price : decimal(10,2)
* stock_quantity : int(11)
* min_stock_level : int(11)
* max_stock_level : int(11)
* unit : varchar(50)
* status : enum('active','inactive')
* created_at : timestamp
* updated_at : timestamp
v ums_garage product_branch_stock
* id : varchar(36)
* product_id : varchar(36)
* branch_id : varchar(36)
* quantity : int(11)
* updated_at : timestamp
v ums_garage product_stock_layers
* id : varchar(36)
* product_id : varchar(36)
* branch_id : varchar(36)
* quantity : int(11)
* unit_price : decimal(12,2)
* vat_applied : tinyint(1)
* created_at : timestamp
v ums_garage proforma_invoices
* id : varchar(36)
* job_card_id : varchar(36)
* customer_id : varchar(36)
* quotation_id : varchar(36)
* proforma_number : varchar(50)
* subtotal : decimal(10,2)
* tax : decimal(10,2)
* total_amount : decimal(10,2)
* advance_amount : decimal(10,2)
* remaining_amount : decimal(10,2)
* status : enum('converted','pending','approved','rejected')
* notes : text
* created_at : timestamp
* updated_at : timestamp
* branch_id : varchar(36)
* sales_vat_exempt : tinyint(1)
* discount : decimal(10,2)
v ums_garage proforma_invoice_items
* id : varchar(36)
* proforma_invoice_id : varchar(36)
* description : varchar(255)
* quantity : int(11)
* unit_price : decimal(10,2)
* total : decimal(10,2)
* cost_price : decimal(10,2)
* vendor_name : varchar(255)
* vat_for_expense : tinyint(1)
* type : enum('service','part','outsourced')
* supplier_id : varchar(36)
* product_id : varchar(36)
* created_at : timestamp
* discount : decimal(10,2)
v ums_garage quotations
* id : varchar(36)
* quotation_number : varchar(50)
* customer_id : varchar(36)
* vehicle_id : varchar(36)
* customer_name : varchar(255)
* vehicle_info : text
* subtotal : decimal(10,2)
* tax : decimal(10,2)
* total_amount : decimal(10,2)
* remaining_amount : decimal(10,2)
* status : enum('available','approved','converted')
* valid_until : timestamp
* notes : text
* created_at : timestamp
* updated_at : timestamp
* branch_id : varchar(36)
* sales_vat_exempt : tinyint(1)
* discount : decimal(10,2)
* vehicle_inspection_report_id : varchar(36)
v ums_garage quotation_items
* id : varchar(36)
* quotation_id : varchar(36)
* description : varchar(255)
* quantity : int(11)
* unit_price : decimal(10,2)
* total : decimal(10,2)
* cost_price : decimal(10,2)
* vendor_name : varchar(255)
* vat_for_expense : tinyint(1)
* type : enum('service','part','outsourced')
* supplier_id : varchar(36)
* product_id : varchar(36)
* created_at : timestamp
* discount : decimal(10,2)
v ums_garage salary_records
* id : varchar(36)
* user_id : varchar(36)
* period_year : int(11)
* period_month : int(11)
* base_amount : decimal(12,2)
* overtime_amount : decimal(12,2)
* adjustment_amount : decimal(12,2)
* bonus_amount : decimal(12,2)
* advance_amount : decimal(12,2)
* total_amount : decimal(12,2)
* expense_id : varchar(36)
* created_at : timestamp
* branch_id : varchar(36)
v ums_garage salary_settings
* user_id : varchar(36)
* base_salary : decimal(12,2)
* overtime_threshold_hours : decimal(6,2)
* overtime_rate_per_hour : decimal(10,2)
* created_at : timestamp
* updated_at : timestamp
* branch_id : varchar(36)
v ums_garage stock_changes
* id : varchar(36)
* product_id : varchar(36)
* type : enum('in','out')
* quantity : int(11)
* reference_type : varchar(50)
* reference_id : varchar(36)
* reference_display : varchar(255)
* created_at : timestamp
* branch_id : varchar(36)
v ums_garage stock_topup_batches
* id : varchar(36)
* vendor_name : varchar(255)
* supplier_id : varchar(36)
* payment_date : timestamp
* trn : varchar(50)
* payment_method : varchar(50)
* payment_status : varchar(20)
* invoice_number : varchar(100)
* notes : text
* total_amount : decimal(12,2)
* paid_amount : decimal(12,2)
* item_count : int(11)
* status : varchar(20)
* created_at : timestamp
* description : varchar(500)
* expense_id : varchar(36)
* branch_id : varchar(36)
* job_card_id : varchar(36)
v ums_garage stock_topup_batch_items
* id : varchar(36)
* batch_id : varchar(36)
* product_id : varchar(36)
* product_name : varchar(255)
* quantity : int(11)
* buying_price : decimal(10,2)
* amount : decimal(12,2)
* vat_applied : tinyint(1)
* created_at : timestamp
v ums_garage suppliers
* id : varchar(36)
* name : varchar(255)
* email : varchar(255)
* phone : varchar(20)
* address : text
* rating : decimal(3,2)
* products_count : int(11)
* total_orders : int(11)
* status : enum('active','inactive')
* category : varchar(100)
* created_at : timestamp
* updated_at : timestamp
* display_name : varchar(255)
* trn : varchar(15)
* work_phone : varchar(50)
* mobile : varchar(50)
* address_line_1 : varchar(500)
* bank_name : varchar(255)
* account_number : varchar(100)
* iban : varchar(50)
* swift_code : varchar(20)
* branch : varchar(255)
v ums_garage supplier_payments
* id : varchar(36)
* purchase_id : varchar(36)
* supplier_id : varchar(36)
* vendor_name : varchar(255)
* amount : decimal(10,2)
* payment_method : varchar(50)
* payment_date : timestamp
* is_advance : tinyint(1)
* purchase_total : decimal(10,2)
* purchase_remaining_before : decimal(10,2)
* purchase_remaining_after : decimal(10,2)
* notes : text
* created_at : timestamp
v ums_garage users
* id : varchar(36)
* email : varchar(255)
* password_hash : varchar(255)
* name : varchar(255)
* role : enum('admin','employee','customer','manager','accountant','superadmin')
* branch_id : varchar(36)
* phone : varchar(20)
* address : text
* emirates_id_file_path : varchar(255)
* passport_file_path : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v ums_garage user_branches
* id : varchar(36)
* user_id : varchar(36)
* branch_id : varchar(36)
* created_at : timestamp
v ums_garage vehicles
* id : varchar(36)
* vehicle_id : varchar(50)
* customer_id : varchar(36)
* brand : varchar(100)
* name : varchar(100)
* license_plate : varchar(20)
* vin_number : varchar(17)
* year : int(11)
* color : varchar(50)
* odometer_reading : int(11)
* last_service_date : timestamp
* next_service_date : timestamp
* status : enum('active','inactive','maintenance')
* fuel_type : enum('gasoline','diesel','electric','hybrid')
* engine_size : varchar(20)
* transmission : enum('automatic','manual')
* images : longtext
* created_at : timestamp
* updated_at : timestamp
* insurance_start_date : date
* insurance_expiry_date : date
* mulkiya_start_date : date
* mulkiya_expiry_date : date
* traffic_plate_number : varchar(64)
v ums_garage vehicle_brands
* id : varchar(36)
* name : varchar(100)
* description : text
* logo_url : varchar(500)
* created_at : timestamp
* updated_at : timestamp
v ums_garage vehicle_documents
* id : varchar(36)
* vehicle_id : varchar(36)
* type : enum('registration','insurance','photo','other')
* file_path : varchar(500)
* name : varchar(255)
* created_at : timestamp
v ums_garage vehicle_inspection_checklist
* id : varchar(36)
* report_id : varchar(36)
* item_code : varchar(10)
* item_name : varchar(255)
* ok : tinyint(1)
* scratch : tinyint(1)
* rust : tinyint(1)
* dent : tinyint(1)
* sat_pickup : tinyint(1)
* unsat_pickup : tinyint(1)
* sat_turnin : tinyint(1)
* unsat_turnin : tinyint(1)
* remarks : varchar(500)
v ums_garage vehicle_inspection_damage_marks
* id : varchar(36)
* report_id : varchar(36)
* mark_type : varchar(20)
* x_pct : decimal(5,2)
* y_pct : decimal(5,2)
* car_view : varchar(20)
* created_at : timestamp
v ums_garage vehicle_inspection_photos
* id : varchar(36)
* report_id : varchar(36)
* file_path : varchar(255)
* sort_order : int(11)
* caption : varchar(500)
* created_at : timestamp
v ums_garage vehicle_inspection_reports
* id : varchar(36)
* job_card_id : varchar(36)
* quotation_id : varchar(36)
* vehicle_id : varchar(36)
* customer_id : varchar(36)
* branch_id : varchar(36)
* status : varchar(20)
* mileage_out : decimal(10,2)
* mileage_in : decimal(10,2)
* mileage : decimal(10,2)
* inspector_name : varchar(255)
* inspection_date : date
* remarks : text
* created_at : timestamp
* updated_at : timestamp
v ums_garage vehicle_names
* id : varchar(36)
* brand_id : varchar(36)
* name : varchar(100)
* description : text
* category : enum('sedan','suv','truck','hatchback','coupe','convertible','wagon','van','other')
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship