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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(10)
OwnerID int(10)
FromDate date
TillDate date
Type int(10)
PayByMonth decimal(10,2)
NotIBANCorrectAmount decimal(10,2)
PayPeriodType int(11)
PayBedType int(11)
FirstMonth int(10)
FirstMonthNotIBANCorrect int(10)
FirstMonthSEPAError int(10)
ClientBankName text utf8mb4_general_ci
NotIBANCorrectDate date
CanTakeClientMoney enum('Yes', 'No') utf8mb4_general_ci
ClientBLZ varchar(255) utf8mb4_general_ci
IsNotIBANCorrect enum('Yes', 'No') utf8mb4_general_ci
ClientBIC varchar(255) utf8mb4_general_ci
IsSEPAError enum('Yes', 'No') utf8mb4_general_ci
StartFile longblob
ClientAccountNumber varchar(255) utf8mb4_general_ci
StartExt varchar(255) utf8mb4_general_ci
FinishExt varchar(255) utf8mb4_general_ci
FinishFile longblob
OurAccountID int(10)
OurBankID int(10)
IssuedOn date
SequenceType enum('', 'FRST', 'RCUR', 'OOFF', 'FNAL') utf8mb4_general_ci
Mandatsreferenz varchar(30) utf8mb4_general_ci
status int(11)
deleted int(11)
addedOn datetime
addedBy int(11)
modifiedBy int(11)
modifiedOn timestamp