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
rowid int
tms timestamp
ref varchar(30) latin1_swedish_ci
entity int
fk_soc int Browse foreign values Browse foreign values
fk_projet int
ref_ext varchar(255) latin1_swedish_ci
ref_int varchar(255) latin1_swedish_ci
ref_customer varchar(255) latin1_swedish_ci
date_creation datetime
fk_user_author int
fk_user_modif int
date_valid datetime
fk_user_valid int
date_delivery datetime
date_expedition datetime
fk_address int
fk_shipping_method int
tracking_number varchar(50) latin1_swedish_ci
fk_statut smallint
billed smallint
height float
width float
size_units int
size float
weight_units int
weight float
note_private text latin1_swedish_ci
note_public text latin1_swedish_ci
model_pdf varchar(255) latin1_swedish_ci
last_main_doc varchar(255) latin1_swedish_ci
fk_incoterms int
location_incoterms varchar(255) latin1_swedish_ci
import_key varchar(14) latin1_swedish_ci
extraparams varchar(255) latin1_swedish_ci