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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
request_id int(11)
requested_by_employee_id int(11)
product_id int(11)
supplier_id int(11)
item_name varchar(150) utf8mb4_unicode_ci
quantity int(11)
estimated_cost decimal(10,2)
validated_by int(11)
validated_at timestamp
notes text utf8mb4_unicode_ci
letter_purpose text utf8mb4_unicode_ci
requester_signature_name varchar(150) utf8mb4_unicode_ci
requester_signature_file varchar(255) utf8mb4_unicode_ci
requester_sign_ip varchar(64) utf8mb4_unicode_ci
requester_sign_ua varchar(255) utf8mb4_unicode_ci
supplier_signatory_name varchar(150) utf8mb4_unicode_ci
supplier_signature_file varchar(255) utf8mb4_unicode_ci
formality_letter_file varchar(255) utf8mb4_unicode_ci
letter_integrity_hash varchar(64) utf8mb4_unicode_ci
supplier_sign_token varchar(64) utf8mb4_unicode_ci
supplier_sign_token_expires timestamp
supplier_sign_requested_at timestamp
supplier_signed_at timestamp
supplier_sign_ip varchar(64) utf8mb4_unicode_ci
supplier_sign_ua varchar(255) utf8mb4_unicode_ci
status enum('pending_validation', 'pending_finance', 'pending_supplier', 'ready_to_receive', 'approved', 'rejected', 'fulfilled') utf8mb4_unicode_ci
decided_by int(11)
decided_at timestamp
finance_signature longtext utf8mb4_unicode_ci
finance_signature_at datetime
finance_approved_by int(11)
finance_approved_at timestamp
finance_signature_name varchar(150) utf8mb4_unicode_ci
finance_signature_file varchar(255) utf8mb4_unicode_ci
finance_sign_ip varchar(64) utf8mb4_unicode_ci
finance_sign_ua varchar(255) utf8mb4_unicode_ci
received_by int(11)
received_at timestamp
requested_at timestamp
requester_full_name varchar(150) utf8mb4_unicode_ci
requester_signature longtext utf8mb4_unicode_ci
requester_signature_at datetime
requester_signature_checked_by int(11)
requester_signature_checked_at datetime
procurement_letter longtext utf8mb4_unicode_ci
supplier_approval_token_hash char(64) utf8mb4_unicode_ci
supplier_approval_expires_at datetime
supplier_signature longtext utf8mb4_unicode_ci
supplier_signature_at datetime