Thả tập tin vào đây

SQL upload ( 0 ) x -

Cài đặt liên quan đến trang Bấm vào thanh để cuộn lên đỉnh trang
Nhấn Ctrl+Enter để thực thi truy vấn Nhấn Enter để thực thi truy vấn
tăng dần
giảm dần
Thứ tự:
Gỡ rối SQL
Số lượng
Thứ tự thực thi
Thời gian cần
Xếp theo:
Nhóm truy vấn
Bỏ nhóm các truy vấn
Co lại Mở rộng Hiện theo dõi Ẩn theo dõi Số lượng : Thời gian cần :
Đánh dấu
Làm tươi lại
Thêm
Không có đánh dấu nào
Thêm đánh dấu
Tùy chọn
Đặt lại thành mặc định





Co lại Mở rộng Truy vấn lại Sửa Giải thích Hồ sơ Đánh dấu Truy vấn bị lỗi Cơ sở dữ liệu : Thời gian truy vấn :
Chưa đặt tên *
v Hiện/Ẩn danh sách bảng Hiển thị toàn màn hình Thêm bảng từ cơ sở dữ liệu khác Trang mới Mở trang Ghi lại trang Ghi trang bằng tên mới Xóa trang Tạo bảng Create relationship Chọn cột bạn muốn hiển thị Tải lại Trợ giúp Các liên kết góc / Liên kết trực tiếp Dính lưới v Nhỏ/To tất cả Bật/tắt lớn/nhỏ Toggle relationship lines Xuất lược đồ > Di chuyển trình đơn > Đóng đinh chữ
v v
Số lượng bảng: 0
v delivery_app additional_services
* id : int(11)
* code : varchar(50)
* name : varchar(150)
* description : text
* default_price : decimal(15,2)
* is_active : tinyint(1)
* created_at : timestamp
v delivery_app cashback_settings
* setting_key : varchar(64)
* setting_value : text
* description : varchar(255)
v delivery_app cashback_transactions
* id : int(11)
* order_id : varchar(64)
* customer_id : int(11)
* batch_group_id : varchar(64)
* total_batch_orders : tinyint(4)
* batch_sequence_index : tinyint(4)
* cashback_rate : decimal(5,2)
* order_fee_amount : decimal(10,2)
* cashback_amount : decimal(10,2)
* status : enum('completed','refunded','failed')
* created_at : datetime
v delivery_app challenges
* id : int(11)
* title : varchar(150)
* reward_amount : decimal(15,2)
* target_count : int(11)
* type : enum('order_count','revenue')
* start_time : datetime
* end_time : datetime
v delivery_app drivers
* id : bigint(20)
* user_id : bigint(20)
* vehicle_info : varchar(100)
* vehicle_plate : varchar(20)
* status : enum('online','offline','busy')
* is_auto_accept : tinyint(1)
* allow_phone_assignment : tinyint(1)
* max_distance_km : decimal(4,1)
* rating_average : decimal(3,2)
* current_lat : decimal(10,8)
* current_lng : decimal(11,8)
* created_at : timestamp
* total_ratings : int(11)
* session_token : varchar(255)
* fcm_token : varchar(255)
* device_id : varchar(100)
* accept_express : tinyint(1)
* accept_fast : tinyint(1)
* accept_saving : tinyint(1)
* max_cod_amount : decimal(15,2)
* is_auto_batch_enabled : tinyint(1)
* auto_batch_mode : enum('flexible','strict_forward')
* allow_extra_capacity : tinyint(1)
* max_batch_orders : int(11)
* deposit_amount : decimal(15,2)
v delivery_app driver_bank_accounts
* id : bigint(20)
* user_id : bigint(20)
* bank_code : varchar(20)
* bank_name : varchar(100)
* account_number : varchar(50)
* account_holder : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v delivery_app driver_challenges
* id : bigint(20)
* driver_id : bigint(20)
* challenge_id : int(11)
* current_progress : int(11)
* status : enum('active','completed','expired')
* created_at : timestamp
v delivery_app driver_daily_earnings
* id : bigint(20)
* driver_id : int(11)
* stat_date : date
* completed_orders_count : int(11)
* gross_fare : decimal(15,2)
* service_fee : decimal(15,2)
* bonus_amount : decimal(15,2)
* net_income : decimal(15,2)
* online_seconds : int(11)
* points : int(11)
* created_at : timestamp
* updated_at : timestamp
v delivery_app driver_daily_stats
* id : bigint(20)
* driver_id : bigint(20)
* stat_date : date
* auto_completed_count : int(11)
* manual_completed_count : int(11)
* total_completed_count : int(11)
* is_auto_accept_locked : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v delivery_app driver_documents
* id : bigint(20)
* driver_id : bigint(20)
* doc_type : enum('license','id_card','vehicle_reg')
* image_url : varchar(255)
* status : enum('pending','verified','rejected')
* reject_reason : varchar(255)
* created_at : timestamp
v delivery_app driver_online_sessions
* id : bigint(20)
* driver_id : int(11)
* session_date : date
* first_online_time : datetime
* last_active_at : datetime
* accumulated_seconds : int(11)
* current_session_start : datetime
* created_at : timestamp
* updated_at : timestamp
v delivery_app notifications
* id : bigint(20)
* user_id : bigint(20)
* title : varchar(255)
* description : text
* type : varchar(50)
* is_read : tinyint(4)
* created_at : timestamp
v delivery_app orders
* id : bigint(20)
* order_code : varchar(32)
* user_id : bigint(20)
* driver_id : bigint(20)
* service_type_id : int(11)
* status : enum('finding_driver','pending','picking_up','picked_up','delivering','completed','returned','cancelled')
* total_fee : decimal(15,2)
* cargo_value : decimal(15,2)
* total_cod_amount : decimal(15,2)
* cash_to_collect : decimal(15,2)
* payer : enum('sender','receiver')
* payment_method : enum('cash','wallet','credit_card')
* voucher_code : varchar(50)
* note_for_driver : text
* package_size : varchar(20)
* weight : int(11)
* category : varchar(100)
* assigned_driver_phone : varchar(20)
* assignment_type : varchar(20)
* is_round_trip : tinyint(1)
* round_trip_fee : decimal(15,2)
* distance_km : decimal(10,2)
* created_at : timestamp
* cancellation_reason : varchar(255)
* updated_at : timestamp
* max_delivery_minutes : int(11)
* picked_up_at : datetime
* delivered_at : datetime
* is_late : tinyint(1)
* is_auto_batch_enabled : tinyint(1)
* platform_fee : decimal(10,2)
* batch_group_id : varchar(64)
* batch_sequence_index : tinyint(4)
v delivery_app order_audits
* id : bigint(20)
* order_id : bigint(20)
* official_google_km : double
* osrm_shadow_km : double
* actual_driver_gps_km : double
* osrm_diff_km : double
* osrm_error_percent : double
* actual_gps_breadcrumbs : longtext
* created_at : timestamp
v delivery_app order_chats
* id : bigint(20)
* order_id : bigint(20)
* sender_type : varchar(20)
* sender_id : bigint(20)
* sender_name : varchar(100)
* message : text
* is_read : tinyint(4)
* created_at : timestamp
v delivery_app order_dispatch_logs
* id : bigint(20)
* order_id : bigint(20)
* driver_id : bigint(20)
* status : enum('sent','accepted','rejected','timeout')
* dispatched_at : timestamp
* responded_at : timestamp
v delivery_app order_fee_details
* id : bigint(20)
* order_id : bigint(20)
* subtotal_fee : decimal(15,2)
* service_fee : decimal(15,2)
* discount_amount : decimal(15,2)
* vat_fee : decimal(15,2)
* platform_fee : decimal(15,2)
* driver_tax_withholding : decimal(15,2)
* remaining_fee : decimal(15,2)
* driver_net_income : decimal(15,2)
* base_fee : decimal(15,2)
* total_add_fees : decimal(15,2)
* size_surcharge : decimal(15,2)
* stop_fee : decimal(15,2)
* cod_fee : decimal(15,2)
* round_trip_fee : decimal(15,2)
* tip_amount : decimal(15,2)
* service_id : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v delivery_app order_holds
* id : bigint(20)
* order_id : bigint(20)
* driver_id : bigint(20)
* hold_amount : decimal(15,2)
* reason : varchar(100)
* claim_deadline : datetime
* status : enum('holding','released','penalized','refunded_to_customer')
* resolved_at : datetime
* note : varchar(255)
* created_at : timestamp
v delivery_app order_photos
* id : bigint(20)
* order_id : bigint(20)
* stop_id : bigint(20)
* driver_id : bigint(20)
* photo_type : varchar(50)
* photo_url : varchar(255)
* latitude : decimal(10,8)
* longitude : decimal(11,8)
* address : text
* created_at : timestamp
v delivery_app order_ratings
* id : bigint(20)
* order_id : bigint(20)
* rater_id : bigint(20)
* ratee_id : bigint(20)
* rater_role : enum('customer','driver')
* rating : tinyint(4)
* tags : longtext
* comment : text
* image_urls : longtext
* is_anonymous : tinyint(1)
* created_at : timestamp
v delivery_app order_referral_commissions
* id : bigint(20)
* order_id : bigint(20)
* order_code : varchar(32)
* beneficiary_user_id : bigint(20)
* tier_level : tinyint(4)
* commission_rate : decimal(5,4)
* commission_amount : decimal(15,2)
* order_subtotal_fee : decimal(15,2)
* status : varchar(20)
* created_at : timestamp
v delivery_app order_route_legs
* id : bigint(20)
* order_id : bigint(20)
* leg_index : int(11)
* leg_type : varchar(30)
* start_address : varchar(255)
* start_lat : double
* start_lng : double
* end_address : varchar(255)
* end_lat : double
* end_lng : double
* distance_km : double
* duration_minutes : double
* polyline : longtext
* created_at : timestamp
v delivery_app order_status_history
* id : bigint(20)
* order_id : bigint(20)
* order_stop_id : bigint(20)
* status : varchar(50)
* note : varchar(255)
* image_url_1 : varchar(255)
* image_url_2 : varchar(255)
* created_at : timestamp
v delivery_app order_stops
* id : bigint(20)
* order_id : bigint(20)
* stop_index : int(11)
* stop_type : enum('pickup','dropoff')
* address_name : varchar(150)
* address : varchar(255)
* address_note : varchar(255)
* lat : decimal(10,8)
* lng : decimal(11,8)
* contact_name : varchar(100)
* contact_phone : varchar(20)
* cod_amount : decimal(15,2)
* status : enum('pending','picked_up','success','failed')
* fail_reason : varchar(255)
* created_at : timestamp
* stop_order : int(11)
v delivery_app promotions
* id : int(11)
* code : varchar(50)
* title : varchar(150)
* description : text
* type : enum('percentage','fixed')
* value : decimal(10,2)
* max_discount : decimal(10,2)
* min_order_value : decimal(10,2)
* cashback_amount : decimal(10,2)
* category : enum('khuyen_mai','freeship','all')
* is_first_order_only : tinyint(1)
* is_active : tinyint(1)
* expires_at : date
* created_at : timestamp
v delivery_app saved_addresses
* id : bigint(20)
* user_id : bigint(20)
* type : enum('home','work','other')
* address_name : varchar(150)
* full_address : varchar(255)
* address_note : varchar(255)
* contact_name : varchar(100)
* contact_phone : varchar(20)
* lat : decimal(10,8)
* lng : decimal(11,8)
* is_default : tinyint(1)
* created_at : timestamp
v delivery_app service_types
* id : int(11)
* code : varchar(30)
* name : varchar(100)
* base_price : decimal(15,2)
* price_per_km : decimal(15,2)
* duration_label : varchar(50)
* icon_url : varchar(255)
* is_active : tinyint(1)
v delivery_app support_tickets
* id : bigint(20)
* user_id : bigint(20)
* subject : varchar(200)
* content : text
* status : enum('open','processing','resolved','closed')
* created_at : timestamp
* updated_at : timestamp
v delivery_app trip_telemetry
* id : int(11)
* order_id : varchar(64)
* driver_id : varchar(64)
* vehicle_type : varchar(20)
* original_distance_meters : int(11)
* actual_distance_meters : int(11)
* saved_distance_meters : int(11)
* actual_polyline : text
* is_shortcut : tinyint(1)
* status : varchar(20)
* created_at : timestamp
v delivery_app users
* id : bigint(20)
* phone : varchar(20)
* full_name : varchar(150)
* email : varchar(150)
* password_hash : varchar(255)
* role : enum('customer','driver','admin')
* avatar_url : varchar(255)
* gender : enum('male','female','other')
* dob : date
* wallet_balance : decimal(15,2)
* reward_points : int(11)
* is_verified : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
* rating_average : decimal(3,2)
* total_ratings : int(11)
* session_token : varchar(255)
* referral_code : varchar(20)
v delivery_app user_referrals
* id : bigint(20)
* user_id : bigint(20)
* tier3_leader_id : bigint(20)
* tier2_leader_id : bigint(20)
* tier1_leader_id : bigint(20)
* created_at : timestamp
v delivery_app wallet_transactions
* id : bigint(20)
* user_id : bigint(20)
* amount : decimal(15,2)
* type : enum('deposit','withdraw','order_pay','order_income','platform_fee','bonus','refund','buy_navigation_quota')
* status : enum('pending','success','failed')
* reference_id : varchar(50)
* description : varchar(255)
* created_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship