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 nldsignc_2025 activity_logs
* log_id : int(11)
* user_id : int(11)
* action : varchar(50)
* affected_user_id : int(11)
* created_at : timestamp
* log_type : varchar(50)
v nldsignc_2025 admin_logs
* log_id : int(11)
* admin_id : int(11)
* action : varchar(50)
* user_id : int(11)
* details : text
* created_at : timestamp
v nldsignc_2025 admin_users
* id : int(11)
* username : varchar(50)
* password : varchar(255)
* created_at : timestamp
v nldsignc_2025 ad_user
* id : int(11)
* username : varchar(50)
* user_id : varchar(50)
* password : varchar(255)
* full_name : varchar(100)
* phone : varchar(15)
* email : varchar(100)
* created_date : datetime
* updated_date : datetime
* last_login : datetime
* status : enum('active','inactive','suspended')
* role : enum('admin','moderator','user')
* profile_image : varchar(255)
* login_attempts : int(11)
* locked_until : datetime
v nldsignc_2025 borrower_blacklist
* id : int(11)
* borrower_name : varchar(100)
* borrower_department : varchar(100)
* reason : text
* blacklist_date : timestamp
* expiry_date : date
* status : enum('active','expired','removed')
* created_by : int(11)
* notes : text
v nldsignc_2025 borrow_transactions
* id : int(11)
* equipment_id : int(11)
* transaction_type : varchar(20)
* quantity : int(11)
* user_name : varchar(100)
* notes : text
* attachment : varchar(255)
* approver_name : varchar(100)
* return_signature : varchar(255)
* borrow_signature : varchar(255)
* borrower_name : varchar(100)
* borrower_department : varchar(100)
* borrower_phone : varchar(20)
* borrowed_date : datetime
* purpose : text
* borrow_date : datetime
* due_date : datetime
* expected_return_date : datetime
* actual_return_date : datetime
* borrow_request_id : varchar(50)
* status : varchar(20)
* user_id : int(11)
* condition_on_return : text
* return_notes : text
* created_at : timestamp
v nldsignc_2025 car_reservations
* id : int(11)
* doc_no : varchar(20)
* book_date : date
* work_time : time
* use_date : date
* return_date : date
* depart_time : time
* return_time : time
* car_type : varchar(255)
* destination : varchar(255)
* map_url : varchar(1000)
* route_points_json : longtext
* contact_name : varchar(100)
* job_no : varchar(50)
* has_map : varchar(10)
* contact_tel : varchar(20)
* pickup_location : varchar(255)
* pickup_datetime : datetime
* has_staff : varchar(10)
* staff_data : longtext
* job_type : varchar(255)
* detail : varchar(500)
* detail2 : varchar(500)
* return_type : varchar(50)
* return_location : varchar(255)
* car_plate : varchar(20)
* vehicle_id : int(11)
* driver_name : varchar(100)
* vehicles_json : longtext
* requester_sign : varchar(100)
* requester_tel : varchar(20)
* status : enum('pending','approved','cancelled','updated','delivered')
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 car_reservation_photos
* id : int(11)
* reservation_id : int(11)
* filename : varchar(255)
* uploaded_by : varchar(100)
* created_at : timestamp
v nldsignc_2025 car_reservation_vehicle_type_logs
* id : int(11)
* reservation_id : int(11)
* doc_no : varchar(50)
* vehicle_type : varchar(50)
* vehicle_type_label : varchar(100)
* created_at : timestamp
v nldsignc_2025 categories
* id : int(11)
* name : varchar(50)
v nldsignc_2025 contact_summary
* status : enum('new','in_progress','replied','closed')
* priority : enum('low','medium','high','urgent')
* total_contacts : bigint(21)
* this_week : bigint(21)
* this_month : bigint(21)
v nldsignc_2025 data_user
* id : int(11)
* username : varchar(50)
* fullname : varchar(100)
* department : varchar(100)
* password : varchar(50)
* email : varchar(100)
* role : varchar(50)
* status : enum('pending','approved','rejected')
* created_at : timestamp
v nldsignc_2025 drivers
* id : int(11)
* user_id : varchar(50)
* password : varchar(255)
* driver_name : varchar(100)
* nickname : varchar(50)
* contact_number : varchar(20)
* license_type : tinyint(4)
* skills : varchar(50)
* photo : varchar(255)
* status : enum('pending','active','inactive')
* open_for_job : tinyint(1)
* assigned_vehicle : varchar(120)
* created_at : timestamp
v nldsignc_2025 driver_location_logs
* id : int(11)
* driver_id : int(11)
* driver_user_id : varchar(60)
* driver_name : varchar(120)
* lat : decimal(10,7)
* lng : decimal(10,7)
* accuracy : float
* logged_at : datetime
v nldsignc_2025 employees
* id : int(11)
* team_name : varchar(50)
* employee_id : varchar(20)
* full_name : varchar(150)
* department : varchar(100)
* photo : varchar(255)
* created_at : timestamp
* team_color : varchar(20)
* status : varchar(20)
* daily_wage : decimal(10,2)
* ot_wage : decimal(10,2)
v nldsignc_2025 equipments
* id : int(11)
* img : varchar(255)
* name : varchar(255)
* model : varchar(100)
* brand : varchar(100)
* serial_number : varchar(255)
* serial : varchar(100)
* quantity : int(11)
* category_id : int(11)
* description : text
* status : enum('available','in_use','maintenance','damaged')
* condition_status : enum('good','fair','needs_repair','broken')
* location : varchar(255)
* purchase_date : date
* purchase_price : decimal(10,2)
* warranty_expiry : date
* last_maintenance : date
* image_path : varchar(500)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 equipment_categories
* id : int(11)
* name : varchar(100)
* description : text
* color : varchar(7)
* status : enum('active','inactive')
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 equipment_condition_history
* id : int(11)
* equipment_id : int(11)
* transaction_id : int(11)
* condition_before : enum('excellent','good','fair','poor','damaged','lost')
* condition_after : enum('excellent','good','fair','poor','damaged','lost')
* damage_description : text
* repair_needed : tinyint(1)
* repair_cost : decimal(10,2)
* inspector_name : varchar(255)
* inspection_date : datetime
* notes : text
v nldsignc_2025 equipment_maintenance
* id : int(11)
* equipment_id : int(11)
* maintenance_type : enum('preventive','corrective','emergency')
* maintenance_date : datetime
* next_maintenance_date : date
* cost : decimal(10,2)
* description : text
* status : enum('scheduled','in_progress','completed','cancelled')
* technician : varchar(100)
* notes : text
* created_at : timestamp
v nldsignc_2025 equipment_transactions
* id : int(11)
* equipment_id : int(11)
* transaction_type : enum('add','borrow','return','maintenance','repair')
* quantity : int(11)
* user_name : varchar(255)
* notes : text
* created_at : timestamp
* attachment : varchar(255)
* approver_name : varchar(255)
* return_signature : varchar(255)
* borrow_signature : varchar(255)
* borrower_name : varchar(255)
* borrower_department : varchar(255)
* borrower_phone : varchar(20)
* returner_name : varchar(255)
* returner_department : varchar(255)
* returner_position : varchar(255)
* returner_code : varchar(50)
* purpose : text
* borrow_date : datetime
* expected_return_date : datetime
* actual_return_date : datetime
* borrow_request_id : varchar(50)
* status : enum('borrowed','returned','completed','cancelled')
* user_id : int(11)
* condition_on_return : enum('good','fair','damaged','lost')
* return_notes : text
* receiver_name : varchar(255)
* receiver_role : varchar(100)
* signature_borrower : longtext
* signature_receiver : longtext
* related_borrow_id : int(11)
v nldsignc_2025 equipment_usage_stats
* id : int(11)
* equipment_id : int(11)
* total_borrows : int(11)
* total_returns : int(11)
* overdue_count : int(11)
* damage_count : int(11)
* total_usage_hours : decimal(10,2)
* average_rating : decimal(3,2)
* last_borrowed_date : datetime
* last_returned_date : datetime
* updated_at : timestamp
v nldsignc_2025 foreman_approvers
* id : int(11)
* user_id : int(11)
* user_name : varchar(255)
* role : varchar(50)
* department : varchar(100)
* max_approval_amount : decimal(15,2)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 foreman_material_attachments
* id : int(11)
* breakdown_id : int(11)
* file_name : varchar(255)
* file_path : varchar(500)
* file_type : varchar(50)
* file_size : int(11)
* description : text
* uploaded_by : int(11)
* uploaded_by_name : varchar(255)
* created_at : timestamp
v nldsignc_2025 foreman_material_breakdown
* id : int(11)
* foreman_id : varchar(50)
* foreman_name : varchar(255)
* project_name : varchar(255)
* job_number : varchar(100)
* customer : varchar(255)
* receiver_name : varchar(255)
* project_owner : varchar(255)
* location : varchar(255)
* required_date : date
* installation_date : date
* status : enum('draft','pending','approved','rejected','completed','cancelled')
* remarks : text
* created_at : timestamp
* updated_at : timestamp
* submitted_at : timestamp
* approved_at : timestamp
* approved_by : varchar(50)
* approved_by_name : varchar(255)
* rejected_at : timestamp
* rejected_by : varchar(50)
* rejected_by_name : varchar(255)
* rejection_reason : text
* store_confirmed_by : varchar(50)
* store_confirmed_by_name : varchar(255)
* store_confirmed_at : datetime
* pr_print_count : int(11)
v nldsignc_2025 foreman_material_items
* id : int(11)
* breakdown_id : int(11)
* material_id : int(11)
* material_code : varchar(100)
* material_name : varchar(255)
* brand : varchar(100)
* order_date : date
* required_qty : decimal(10,2)
* required_unit : varchar(50)
* stock_qty : decimal(10,2)
* stock_unit : varchar(50)
* order_qty : decimal(10,2)
* approved_qty : decimal(10,2)
* actual_qty : decimal(10,2)
* received_qty : decimal(10,2)
* received_date : datetime
* received_by : varchar(100)
* item_remarks : text
* is_paid : tinyint(1)
* is_checked : tinyint(1)
* checked_by : varchar(100)
* checked_at : datetime
* paid_by : varchar(100)
* paid_at : datetime
* created_at : timestamp
* updated_at : timestamp
* sort_order : int(11)
v nldsignc_2025 foreman_material_logs
* id : int(11)
* breakdown_id : int(11)
* action : varchar(50)
* user_id : int(11)
* user_name : varchar(255)
* user_role : varchar(50)
* old_status : varchar(50)
* new_status : varchar(50)
* remarks : text
* ip_address : varchar(45)
* created_at : timestamp
v nldsignc_2025 foreman_material_received
* id : int(11)
* item_id : int(11)
* received_no : int(11)
* received_qty : decimal(10,2)
* received_date : datetime
* received_by : varchar(100)
* issued_by : varchar(100)
* warehouse_history_id : int(11)
* remarks : text
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 foreman_pr_print_history
* id : int(11)
* breakdown_id : int(11)
* pr_number : varchar(50)
* print_count : int(11)
* project_name : varchar(255)
* job_number : varchar(100)
* customer : varchar(255)
* project_owner : varchar(255)
* location : varchar(255)
* required_date : date
* installation_date : date
* receiver_name : varchar(255)
* foreman_name : varchar(255)
* printed_by : varchar(50)
* printed_by_name : varchar(255)
* items_snapshot : longtext
* created_at : timestamp
v nldsignc_2025 foreman_users
* id : varchar(50)
* password : varchar(255)
* full_name : varchar(255)
* nickname : varchar(100)
* department : varchar(100)
* photo : longblob
* photo_filename : varchar(255)
* signature : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 fuel_prices
* id : int(11)
* station_name : varchar(255)
* fuel_type : varchar(50)
* price : decimal(10,2)
* source : varchar(255)
* icon_url : varchar(500)
* updated_at : timestamp
v nldsignc_2025 fuel_price_history
* id : int(11)
* station_name : varchar(255)
* fuel_type : varchar(50)
* price : decimal(10,2)
* source : varchar(255)
* icon_url : varchar(500)
* recorded_date : date
* recorded_at : timestamp
v nldsignc_2025 holidays
* id : int(11)
* holiday_name : varchar(255)
* holiday_date : date
* description : text
v nldsignc_2025 incoming_items
* id : int(11)
* date : date
* category : varchar(100)
* item_name : varchar(500)
* required_date : date
* product_code : varchar(100)
* brand : varchar(200)
* size : varchar(200)
* note : text
* quantity : decimal(10,2)
* unit : varchar(50)
* price_before_vat : decimal(12,2)
* price_with_vat : decimal(12,2)
* total_price : decimal(12,2)
* pr_number : varchar(100)
* foreman : varchar(200)
* job_number : varchar(100)
* job_name : varchar(500)
* vendor : varchar(300)
* vendor_phone : varchar(50)
* po_number : varchar(100)
* order_by : varchar(200)
* order_date : date
* appointment_date : date
* received_date : date
* received_by : varchar(200)
* invoice_number : varchar(200)
* status : varchar(50)
* created_by : varchar(100)
* created_date : datetime
* updated_at : timestamp
v nldsignc_2025 job_plan_workflow
* id : int(11)
* job_code : varchar(100)
* job_title : varchar(255)
* open_job_date : date
* foreman_name : varchar(150)
* sale_name : varchar(150)
* deliver_job_date : date
* workflow_status : varchar(50)
* status_note : varchar(255)
* plan_work_date : date
* work_day_label : varchar(100)
* estimated_duration : varchar(120)
* bill_receive_date : date
* wood_team : varchar(150)
* timeline_start_date : date
* timeline_end_date : date
* created_at : datetime
* updated_at : datetime
v nldsignc_2025 led_item
* id : int(6) unsigned zerofill
* name_item : text
* detail : text
* Rem_Amt : double(10,2)
* type : int(11)
* img : text
v nldsignc_2025 led_transactions
* id : int(11)
* item_id : int(6) unsigned
* job_number : varchar(50)
* operator : varchar(100)
* type : enum('add','subtract')
* quantity : double(10,2)
* remark : text
* transaction_date : datetime
v nldsignc_2025 led_types
* type_id : int(11)
* type_name : varchar(100)
v nldsignc_2025 loan_members
* id : int(11)
* name : varchar(255)
* department : varchar(255)
* position : varchar(255)
* name_leader : varchar(255)
* phone : varchar(20)
* email : varchar(255)
* image : varchar(500)
* status : enum('active','inactive','suspended')
* approval_status : enum('pending','approved','rejected')
* approved_by : varchar(255)
* approved_date : datetime
* member_code : varchar(50)
* notes : text
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 media_equipment
* id : int(11)
* equipment_code : varchar(50)
* equipment_name : varchar(255)
* equipment_type : varchar(100)
* brand : varchar(100)
* model : varchar(100)
* serial_number : varchar(100)
* size : varchar(100)
* location : varchar(200)
* status : enum('AVAILABLE','IN_USE','MAINTENANCE','BROKEN')
* stock_quantity : int(11)
* min_quantity : int(11)
* image_path : varchar(255)
* notes : text
* created_at : timestamp
* updated_at : timestamp
* last_stock_update : timestamp
v nldsignc_2025 pending_contacts
* id : int(11)
* name : varchar(255)
* email : varchar(255)
* subject : varchar(500)
* company : varchar(255)
* project_type : varchar(100)
* priority : enum('low','medium','high','urgent')
* days_waiting : int(7)
* created_at : timestamp
v nldsignc_2025 purchase_items
* id : int(11)
* purchase_order_id : int(11)
* category : varchar(50)
* item_name : varchar(255)
* product_code : varchar(100)
* brand : varchar(100)
* quantity : decimal(10,2)
* unit : varchar(50)
* unit_price : decimal(10,2)
* unit_price_vat : decimal(10,2)
* total_price : decimal(10,2)
* remarks : text
v nldsignc_2025 purchase_orders
* id : int(11)
* order_date : date
* product_type : varchar(100)
* item_name : varchar(200)
* required_date : date
* product_code : varchar(50)
* brand : varchar(100)
* size : varchar(100)
* remark : text
* quantity : decimal(10,2)
* unit : varchar(50)
* price_before_vat : decimal(10,2)
* price_with_vat : decimal(10,2)
* total_amount : decimal(10,2)
* pr_number : varchar(50)
* foreman : varchar(100)
* job_number : varchar(50)
* job_name : varchar(200)
* vendor : varchar(200)
* phone : varchar(50)
* po_number : varchar(50)
* ordered_by : varchar(100)
* order_date_time : date
* expected_date : date
* received_date : date
* received_by : varchar(100)
* invoice_no : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 qa_in_store
* id : int(11)
* update_date : date
* category : varchar(100)
* product_name : varchar(255)
* required_date : date
* product_code : varchar(100)
* brand : varchar(100)
* size : varchar(50)
* note : text
* quantity : decimal(10,2)
* unit : varchar(50)
* price_before_vat : decimal(15,5)
* price_with_vat : decimal(15,5)
* total_amount : decimal(15,5)
* pr_number : varchar(100)
* foreman : varchar(100)
* job : varchar(255)
* remarks : text
* vendor : varchar(255)
* phone_number : varchar(20)
* po : varchar(100)
* order_person : varchar(100)
* order_date : date
* delivery_date : date
* received_date : date
* receiver : varchar(100)
* invoice_bill : varchar(255)
* image : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 qa_in_store_images
* id : int(11)
* qa_store_id : int(11)
* image_name : varchar(255)
* original_name : varchar(255)
* file_path : varchar(500)
* file_size : int(11)
* mime_type : varchar(100)
* image_type : varchar(50)
* upload_order : int(11)
* uploaded_at : timestamp
* updated_at : timestamp
v nldsignc_2025 recent_contacts
* id : int(11)
* name : varchar(255)
* email : varchar(255)
* phone : varchar(20)
* subject : varchar(500)
* message_preview : varchar(100)
* company : varchar(255)
* project_type : varchar(100)
* status : enum('new','in_progress','replied','closed')
* priority : enum('low','medium','high','urgent')
* created_at : timestamp
v nldsignc_2025 return_evidence
* id : int(11)
* transaction_id : int(11)
* evidence_type : enum('before_return','after_return','damage','condition')
* file_path : varchar(500)
* file_name : varchar(255)
* file_size : int(11)
* description : text
* uploaded_by : int(11)
* created_at : timestamp
v nldsignc_2025 return_feedback
* id : int(11)
* transaction_id : int(11)
* borrower_rating : int(1)
* service_rating : int(1)
* equipment_quality_rating : int(1)
* feedback_message : text
* suggestions : text
* submitted_at : timestamp
v nldsignc_2025 return_logs
* id : int(11)
* borrow_id : int(11)
* equipment_id : int(11)
* quantity_returned : int(11)
* return_date : datetime
* condition_on_return : text
* return_notes : text
* return_signature : varchar(255)
* attachment_file : varchar(255)
* processed_by : varchar(100)
* created_at : timestamp
v nldsignc_2025 return_notifications
* id : int(11)
* transaction_id : int(11)
* notification_type : enum('reminder','overdue','returned')
* message : text
* sent_at : timestamp
* read_at : timestamp
* created_at : timestamp
v nldsignc_2025 return_signatures
* id : int(11)
* transaction_id : int(11)
* returner_signature : longtext
* receiver_signature : longtext
* return_condition : enum('same','damaged','improved')
* return_notes : text
* created_at : timestamp
v nldsignc_2025 roles
* id : int(11)
* name : varchar(100)
* permissions : longtext
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 stock_logs
* id : int(11)
* equipment_id : int(11)
* action : enum('add','remove')
* quantity : int(11)
* notes : text
* created_at : timestamp
v nldsignc_2025 suppliers
* id : int(11)
* name : varchar(255)
* contact_info : text
v nldsignc_2025 system_permissions
* id : int(11)
* role_id : int(11)
* system_key : varchar(50)
* can_access : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 system_settings
* id : int(11)
* setting_key : varchar(100)
* setting_value : text
* setting_type : enum('string','integer','boolean','json')
* description : text
* is_public : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 teams
* id : int(11)
* department : varchar(100)
* team_name : varchar(150)
* team_leader : varchar(150)
* leader_photo : varchar(255)
* created_at : datetime
* updated_at : datetime
v nldsignc_2025 team_members
* id : int(11)
* team_id : int(11)
* member_name : varchar(150)
* member_photo : varchar(255)
* created_at : datetime
v nldsignc_2025 tools_new
* id : int(11)
* img : varchar(255)
* name : varchar(255)
* model : varchar(100)
* brand : varchar(100)
* serial : varchar(100)
* quantity : int(11)
* description : text
* status : enum('available','in_use','maintenance','damaged')
* location : varchar(255)
* created_at : timestamp
v nldsignc_2025 tool_categories
* id : int(11)
* category_name : varchar(100)
* description : text
* created_at : timestamp
v nldsignc_2025 traffic_reports
* id : int(11)
* reservation_id : int(11)
* driver_name : varchar(120)
* status : enum('departed','arrived')
* lat : decimal(10,7)
* lng : decimal(10,7)
* location_text : varchar(500)
* note : text
* reported_at : datetime
* mileage : int(11)
v nldsignc_2025 traffic_report_photos
* id : int(11)
* traffic_report_id : int(11)
* filename : varchar(255)
* uploaded_by : varchar(120)
* uploaded_at : datetime
v nldsignc_2025 users
* user_id : int(11)
* username : varchar(50)
* password : varchar(255)
* email : varchar(100)
* role_id : int(11)
* created_at : timestamp
* status : enum('pending','approved','rejected')
* approved_by : int(11)
* approved_at : timestamp
v nldsignc_2025 user_activity_logs
* id : int(11)
* user_id : int(11)
* username : varchar(100)
* action_type : varchar(50)
* module : varchar(50)
* action_description : text
* ip_address : varchar(45)
* user_agent : text
* additional_data : longtext
* created_at : timestamp
v nldsignc_2025 user_sessions
* id : int(11)
* user_id : int(11)
* session_id : varchar(255)
* ip_address : varchar(45)
* user_agent : text
* created_at : timestamp
* last_activity : timestamp
* is_active : tinyint(1)
v nldsignc_2025 vehicles
* id : int(11)
* car_plate : varchar(20)
* car_type : enum('sedan','pickup','van','truck_small','truck_large','other')
* res_car_type : varchar(60)
* vehicle_kind : varchar(100)
* brand : varchar(50)
* model : varchar(120)
* car_year : year(4)
* color : varchar(30)
* fuel_type : enum('gasoline','diesel','lpg','ngv','hybrid','ev')
* cargo_size : varchar(60)
* cargo_capacity_kg : int(11)
* engine_cc : int(11)
* engine_cylinders : int(11)
* horsepower_hp : int(11)
* cargo_width_m : decimal(5,2)
* cargo_length_m : decimal(5,2)
* cargo_height_m : decimal(5,2)
* timing_system : enum('belt','chain','gear','unknown')
* timing_note : varchar(255)
* chassis_no : varchar(50)
* engine_no : varchar(50)
* reg_date : date
* reg_date_text : varchar(100)
* vehicle_age_years : int(11)
* reg_expire : date
* insurance_co : varchar(100)
* insurance_no : varchar(50)
* insurance_expire : date
* inspect_expire : date
* last_service_km : int(11)
* last_service_date : date
* next_service_km : int(11)
* next_service_date : date
* current_km : int(11)
* gross_weight_kg : int(11)
* curb_weight_kg : int(11)
* payload_weight_kg : int(11)
* department : varchar(100)
* assigned_driver : int(11)
* remark : text
* status : enum('active','maintenance','inactive')
* created_at : timestamp
v nldsignc_2025 vehicle_photos
* id : int(11)
* vehicle_id : int(11)
* filename : varchar(255)
* sort_order : tinyint(4)
* created_at : timestamp
v nldsignc_2025 vehicle_repairs
* id : int(11)
* vehicle_id : int(11)
* car_plate : varchar(20)
* repair_date : date
* repair_type : varchar(80)
* description : text
* cost : decimal(10,2)
* garage : varchar(200)
* mileage_at_repair : int(11)
* next_repair_km : int(11)
* next_repair_date : date
* note : text
* created_by : varchar(100)
* created_at : datetime
v nldsignc_2025 v_all_borrowing
* source_table : varchar(15)
* id : int(11)
* equipment_id : int(11)
* equipment_name : varchar(255)
* category : varchar(100)
* borrower_name : varchar(100)
* borrower_department : varchar(100)
* borrower_phone : varchar(20)
* quantity : int(11)
* borrow_date : datetime
* expected_return_date : datetime
* actual_return_date : datetime
* status : varchar(20)
* purpose : text
* days_overdue : int(7)
v nldsignc_2025 v_borrowing_stats
* borrower_name : varchar(100)
* borrower_department : varchar(100)
* borrower_phone : varchar(20)
* total_items : bigint(21)
* overdue_items : decimal(22,0)
* first_borrow_date : datetime
* last_expected_return : datetime
v nldsignc_2025 v_borrow_summary
* equipment_id : int(11)
* equipment_name : varchar(255)
* model : varchar(100)
* brand : varchar(100)
* quantity : int(11)
* equipment_status : enum('available','in_use','maintenance','damaged')
* total_borrows : bigint(21)
* currently_borrowed : bigint(21)
* last_borrow_date : datetime
* last_return_date : datetime
* availability_status : varchar(11)
v nldsignc_2025 warehouse_categories
* id : int(11)
* category_name : varchar(100)
* created_at : timestamp
* is_active : tinyint(1)
v nldsignc_2025 warehouse_column_settings
* id : int(11)
* user_id : varchar(50)
* setting_name : varchar(100)
* column_order : text
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 warehouse_products
* id : int(11)
* product_code : varchar(50)
* brand : varchar(100)
* category : varchar(100)
* product_name : varchar(255)
* quantity : double
* unit : varchar(50)
* barcode : varchar(100)
* shelf : varchar(50)
* location : varchar(50)
* created_by : varchar(100)
* image : varchar(255)
* created_at : timestamp
* updated_at : timestamp
* price : decimal(10,5)
* cost : decimal(10,5)
* supplier : varchar(255)
* minimum_stock : int(11)
* status : enum('active','inactive','pending')
* description : text
v nldsignc_2025 warehouse_receive_history
* id : int(11)
* product_id : int(11)
* receive_date : date
* status : enum('pending','received','rejected','???','???????','???????')
* transaction_type : varchar(20)
* quantity : decimal(10,2)
* job_number : varchar(255)
* job_name : varchar(255)
* supplier : varchar(100)
* foreman : varchar(100)
* recorder : varchar(100)
* created_at : timestamp
* po_id : int(11)
v nldsignc_2025 warehouse_scan_log
* id : int(10) unsigned
* logged_at : datetime
* action : varchar(20)
* username : varchar(100)
* product_id : int(10) unsigned
* product_name : varchar(255)
* product_code : varchar(100)
* barcode : varchar(100)
* field : varchar(50)
* new_value : varchar(255)
* query_text : varchar(255)
v nldsignc_2025 warehouse_units
* id : int(11)
* unit_name : varchar(50)
* created_at : timestamp
* is_active : tinyint(1)
v nldsignc_2025 wep_contact
* id : int(11)
* name : varchar(255)
* email : varchar(255)
* phone : varchar(20)
* subject : varchar(500)
* message : text
* company : varchar(255)
* project_type : varchar(100)
* budget_range : varchar(100)
* status : enum('new','in_progress','replied','closed')
* priority : enum('low','medium','high','urgent')
* ip_address : varchar(45)
* user_agent : text
* source_page : varchar(255)
* admin_notes : text
* replied_by : int(11)
* replied_at : datetime
* created_at : timestamp
* updated_at : timestamp
v nldsignc_2025 wep_news
* id : int(11)
* title : varchar(255)
* content : text
* image : varchar(255)
* author_id : int(11)
* author_name : varchar(100)
* status : enum('draft','published','archived')
* priority : int(11)
* views : int(11)
* created_date : datetime
* updated_date : datetime
* published_date : datetime
v nldsignc_2025 wep_performances
* id : int(11)
* job_number : varchar(50)
* name_job : varchar(255)
* detail : text
* images : text
* status : enum('active','inactive')
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* view_count : int(11)
v nldsignc_2025 wep_products
* id : int(11)
* product_name : varchar(255)
* main_image : varchar(255)
* secondary_images : text
* product_video : varchar(255)
* price : decimal(10,2)
* description : text
* status : enum('active','inactive')
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* view_count : int(11)
v nldsignc_2025 withdrawals
* id : int(11)
* withdrawal_number : varchar(20)
* withdrawal_date : date
* job_number : varchar(50)
* project_name : varchar(255)
* requester : varchar(100)
* remarks : text
* created_at : datetime
v nldsignc_2025 withdrawal_items
* id : int(11)
* withdrawal_id : int(11)
* item_name : varchar(255)
* quantity : decimal(10,2)
* unit : varchar(50)
* remarks : text
v nldsignc_2025 work_plans
* id : int(11)
* parent_id : int(11)
* team_id : int(11)
* team_name : varchar(100)
* department : varchar(100)
* job_number : varchar(100)
* job_title : varchar(255)
* supervisor : varchar(150)
* team_leader : varchar(150)
* work_type : varchar(100)
* work_type_label : varchar(120)
* start_date : date
* start_time : time
* end_date : date
* end_time : time
* location : varchar(255)
* province : varchar(100)
* description : text
* members : text
* status : varchar(50)
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v nldsignc_2025 work_plan_files
* id : int(11)
* work_plan_id : int(11)
* file_name : varchar(255)
* original_name : varchar(255)
* file_type : varchar(100)
* file_size : bigint(20)
* uploaded_by : int(11)
* uploaded_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship