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 :
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
Number of tables: 0
v digital_store admin_login_attempts
* id : int(11)
* email : varchar(255)
* attempts : int(11)
* ip_address : varchar(45)
* locked_until : datetime
* created_at : datetime
* updated_at : datetime
v digital_store ai_blog_generation_logs
* id : int(11)
* blog_post_id : int(11)
* system_prompt : longtext
* user_prompt : longtext
* image_prompt : text
* keywords_data : longtext
* primary_keyword : varchar(255)
* gpt_input_tokens : int(11)
* gpt_output_tokens : int(11)
* gpt_cost_usd : decimal(10,6)
* dalle_cost_usd : decimal(10,6)
* dataforseo_cost_usd : decimal(10,6)
* total_cost_usd : decimal(10,6)
* gpt_model : varchar(50)
* image_model : varchar(50)
* raw_response : longtext
* created_at : timestamp
v digital_store ai_blog_logs
* id : int(11)
* action : varchar(100)
* input_tokens : int(11)
* output_tokens : int(11)
* image_generated : tinyint(1)
* cost_usd : decimal(10,6)
* model : varchar(50)
* success : tinyint(1)
* error_message : text
* created_at : datetime
v digital_store ai_blog_queue
* id : int(11)
* topic : varchar(500)
* keywords : varchar(500)
* language : varchar(10)
* status : enum('pending','processing','completed','failed')
* scheduled_at : datetime
* processed_at : datetime
* blog_post_id : int(11)
* error_message : text
* created_at : datetime
v digital_store ai_blog_settings
* id : int(11)
* setting_key : varchar(100)
* setting_value : text
* created_at : datetime
* updated_at : datetime
v digital_store ai_generation_history
* id : int(10) unsigned
* entity_type : enum('product','category')
* entity_id : int(10) unsigned
* cost_chatgpt : decimal(10,6)
* cost_dalle : decimal(10,6)
* cost_dataforseo : decimal(10,6)
* cost_total : decimal(10,6)
* keywords : longtext
* keyword_details : longtext
* prompts : longtext
* model : varchar(50)
* languages : longtext
* created_at : timestamp
v digital_store blog_posts
* id : int(10) unsigned
* user_id : int(10) unsigned
* title : varchar(255)
* slug : varchar(255)
* excerpt : text
* content : longtext
* featured_image : varchar(255)
* featured_image_alt : varchar(500)
* featured_image_title : varchar(255)
* status : enum('published','draft','scheduled')
* ai_generated : tinyint(1)
* published_at : timestamp
* views : int(11)
* seo_title : varchar(255)
* seo_description : text
* seo_keywords : text
* faqs : longtext
* created_at : timestamp
* updated_at : timestamp
* no_index : tinyint(1)
* lighthouse_score : int(3)
* lighthouse_updated_at : datetime
* in_sitemap : tinyint(1)
v digital_store categories
* id : int(10) unsigned
* parent_id : int(10) unsigned
* name : varchar(100)
* slug : varchar(100)
* description : text
* icon : varchar(100)
* image : varchar(255)
* color : varchar(20)
* sort_order : int(11)
* status : enum('active','inactive')
* seo_title : varchar(255)
* seo_description : text
* seo_keywords : text
* created_at : timestamp
* updated_at : timestamp
* no_index : tinyint(1)
* in_sitemap : tinyint(1)
v digital_store category_translations
* id : int(10) unsigned
* category_id : int(10) unsigned
* language_code : varchar(5)
* name : varchar(100)
* description : text
* short_description : text
* slug : varchar(255)
* seo_title : varchar(255)
* seo_description : text
* seo_keywords : text
* created_at : timestamp
* updated_at : timestamp
* no_index : tinyint(1)
v digital_store contacts
* id : int(10) unsigned
* name : varchar(100)
* email : varchar(100)
* subject : varchar(255)
* message : text
* status : enum('new','read','replied','closed')
* ip_address : varchar(45)
* created_at : timestamp
v digital_store contact_messages
* id : int(11)
* name : varchar(100)
* email : varchar(255)
* subject : varchar(255)
* message : text
* ip_address : varchar(45)
* is_read : tinyint(1)
* created_at : timestamp
v digital_store coupons
* id : int(11)
* code : varchar(50)
* type : enum('percentage','fixed')
* value : decimal(10,2)
* min_order : decimal(10,2)
* min_amount : decimal(10,2)
* max_uses : int(11)
* used_count : int(11)
* expires_at : datetime
* status : enum('active','inactive')
* created_at : datetime
v digital_store coupon_rate_limits
* ip_hash : varchar(64)
* attempts : int(11)
* first_attempt : datetime
v digital_store coupon_usage
* id : int(11)
* coupon_id : int(11)
* user_id : int(11)
* order_id : int(11)
* used_at : datetime
v digital_store email_templates
* id : int(10) unsigned
* name : varchar(100)
* subject : varchar(255)
* body : longtext
* variables : longtext
* status : enum('active','inactive')
* created_at : timestamp
* updated_at : timestamp
v digital_store email_verification_tokens
* id : int(10) unsigned
* user_id : int(10) unsigned
* token : varchar(64)
* expires_at : timestamp
* created_at : timestamp
v digital_store index_queue
* id : int(11)
* url : varchar(500)
* url_type : enum('blog','product','page')
* post_id : int(11)
* status : enum('pending','submitted','indexed','failed')
* priority : int(11)
* submit_attempts : int(11)
* last_attempt_at : datetime
* indexed_at : datetime
* created_at : datetime
v digital_store invoices
* id : int(11)
* order_id : int(11)
* invoice_number : varchar(50)
* invoice_data : text
* uyumsoft_uuid : varchar(100)
* status : enum('pending','created','sent','cancelled')
* created_at : datetime
v digital_store keyword_research
* id : int(11)
* keyword : varchar(255)
* language_code : varchar(10)
* location_code : int(11)
* search_volume : int(11)
* competition : decimal(5,4)
* cpc : decimal(10,2)
* keyword_difficulty : int(11)
* trend_data : longtext
* source : varchar(50)
* used_in_blog : tinyint(1)
* last_updated : datetime
* created_at : datetime
* competition_level : varchar(20)
v digital_store languages
* id : int(11)
* code : varchar(5)
* name : varchar(50)
* native_name : varchar(50)
* flag_image : varchar(255)
* flag_emoji : varchar(10)
* is_active : tinyint(1)
* sort_order : int(11)
* created_at : datetime
* updated_at : datetime
v digital_store lighthouse_cache
* id : int(11)
* url_hash : varchar(32)
* url : varchar(500)
* data : longtext
* score : int(3)
* created_at : datetime
v digital_store login_attempts
* id : int(11)
* email : varchar(255)
* attempts : int(11)
* ip_address : varchar(45)
* locked_until : datetime
* created_at : datetime
* updated_at : datetime
v digital_store oauth_connections
* id : int(10) unsigned
* user_id : int(10) unsigned
* provider : enum('google','facebook')
* provider_id : varchar(255)
* provider_email : varchar(255)
* access_token : text
* refresh_token : text
* token_expires_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v digital_store orders
* id : int(10) unsigned
* order_number : varchar(50)
* user_id : int(10) unsigned
* email : varchar(100)
* phone : varchar(20)
* subtotal : decimal(10,2)
* discount : decimal(10,2)
* coupon_code : varchar(50)
* total : decimal(10,2)
* currency : varchar(3)
* payment_method : varchar(50)
* payment_id : varchar(255)
* payment_url : varchar(500)
* payment_status : enum('pending','completed','failed','refunded')
* order_status : enum('pending','processing','completed','cancelled')
* notes : text
* admin_notes : text
* ip_address : varchar(45)
* user_agent : text
* completed_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v digital_store order_deliveries
* id : int(10) unsigned
* order_id : int(10) unsigned
* order_item_id : int(10) unsigned
* delivery_type : enum('topup','account','instant','manual')
* customer_input : longtext
* delivery_data : text
* smm_panel_id : int(11)
* delivery_format : text
* status : enum('pending','processing','delivered','failed')
* delivered_at : timestamp
* notes : text
* created_at : timestamp
* updated_at : timestamp
v digital_store order_items
* id : int(10) unsigned
* order_id : int(10) unsigned
* product_id : int(10) unsigned
* product_name : varchar(255)
* quantity : int(11)
* price : decimal(10,2)
* total : decimal(10,2)
* delivered_data : text
* delivered_at : timestamp
* created_at : timestamp
* customer_input : longtext
* delivery_status : enum('pending','processing','delivered','failed')
* delivery_data : text
* delivery_type : varchar(50)
v digital_store pages
* id : int(10) unsigned
* slug : varchar(100)
* title : varchar(255)
* content : longtext
* status : enum('published','draft')
* seo_title : varchar(255)
* seo_description : text
* created_at : timestamp
* updated_at : timestamp
* seo_keywords : varchar(255)
* sort_order : int(11)
* show_in_header : tinyint(1)
* no_index : tinyint(1)
v digital_store password_reset_tokens
* id : int(10) unsigned
* user_id : int(10) unsigned
* token : varchar(64)
* expires_at : timestamp
* used_at : timestamp
* created_at : timestamp
v digital_store products
* id : int(10) unsigned
* category_id : int(10) unsigned
* user_id : int(10) unsigned
* name : varchar(255)
* slug : varchar(255)
* short_description : varchar(500)
* description : text
* price : decimal(10,2)
* sale_price : decimal(10,2)
* min_quantity : int(11)
* max_quantity : int(11)
* stock : int(11)
* sold : int(11)
* image : varchar(255)
* images : longtext
* delivery_type : enum('instant','manual','account','api','topup','dc_boost')
* delivery_data : text
* required_fields : longtext
* delivery_format : text
* delivery_time : varchar(100)
* smm_service_id : int(11)
* smm_panel_id : int(11)
* smm_platform : varchar(50)
* status : enum('active','inactive','draft')
* sort_order : int(11)
* featured : tinyint(1)
* rating : decimal(2,1)
* reviews_count : int(11)
* views : int(11)
* seo_title : varchar(255)
* seo_description : text
* seo_keywords : text
* created_at : timestamp
* updated_at : timestamp
* features : text
* meta_title : varchar(255)
* meta_description : text
* meta_keywords : varchar(500)
* no_index : tinyint(1)
* in_sitemap : tinyint(1)
v digital_store product_images
* id : int(11)
* product_id : int(11)
* image_path : varchar(255)
* sort_order : int(11)
* created_at : datetime
v digital_store product_stock
* id : int(11)
* product_id : int(11)
* stock_data : text
* is_sold : tinyint(1)
* order_id : int(11)
* order_item_id : int(11)
* sold_at : datetime
* created_at : datetime
* notes : text
v digital_store product_translations
* id : int(10) unsigned
* product_id : int(10) unsigned
* language_code : varchar(5)
* name : varchar(255)
* short_description : varchar(500)
* description : text
* seo_title : varchar(255)
* seo_description : text
* seo_keywords : text
* created_at : timestamp
* updated_at : timestamp
* no_index : tinyint(1)
v digital_store product_variants
* id : int(11)
* product_id : int(11)
* name : varchar(100)
* price : decimal(10,2)
* stock : int(11)
* status : enum('active','inactive')
* sort_order : int(11)
* created_at : datetime
v digital_store reviews
* id : int(10) unsigned
* product_id : int(10) unsigned
* user_id : int(10) unsigned
* order_id : int(10) unsigned
* rating : tinyint(1)
* comment : text
* status : enum('pending','approved','rejected')
* created_at : timestamp
* updated_at : timestamp
v digital_store settings
* id : int(10) unsigned
* key : varchar(100)
* value : text
* type : varchar(50)
* group : varchar(50)
* updated_at : timestamp
v digital_store sitemap_pings
* id : int(11)
* ping_type : enum('google','bing')
* success : tinyint(1)
* response_code : int(11)
* created_at : datetime
v digital_store site_settings
* id : int(10) unsigned
* setting_key : varchar(100)
* setting_value : longtext
* setting_type : enum('text','textarea','number','boolean','json','image','color')
* setting_group : varchar(50)
* setting_label : varchar(255)
* setting_description : text
* sort_order : int(11)
* created_at : timestamp
* updated_at : timestamp
v digital_store smm_order_logs
* id : int(11)
* order_item_id : int(11)
* smm_order_id : int(11)
* smm_panel_id : int(11)
* status : varchar(50)
* error_message : text
* response_data : longtext
* created_at : datetime
v digital_store smm_panels
* id : int(11)
* name : varchar(100)
* slug : varchar(100)
* api_url : varchar(500)
* api_key : varchar(500)
* status : enum('active','inactive')
* is_default : tinyint(1)
* balance : decimal(10,2)
* currency : varchar(10)
* last_sync_at : datetime
* notes : text
* created_at : datetime
* updated_at : datetime
v digital_store tickets
* id : int(11)
* ticket_number : varchar(20)
* user_id : int(11)
* guest_email : varchar(255)
* guest_name : varchar(100)
* subject : varchar(255)
* category : enum('general','order','payment','technical','refund','other')
* priority : enum('low','medium','high','urgent')
* status : enum('open','in_progress','answered','closed')
* order_id : int(11)
* created_at : timestamp
* updated_at : timestamp
* closed_at : timestamp
v digital_store ticket_attachments
* id : int(11)
* ticket_id : int(11)
* reply_id : int(11)
* filename : varchar(255)
* original_name : varchar(255)
* file_type : varchar(100)
* file_size : int(11)
* created_at : timestamp
v digital_store ticket_replies
* id : int(11)
* ticket_id : int(11)
* user_id : int(11)
* admin_id : int(11)
* is_admin : tinyint(1)
* message : text
* created_at : timestamp
v digital_store transactions
* id : int(10) unsigned
* user_id : int(10) unsigned
* type : enum('deposit','withdrawal','purchase','refund','bonus','transfer')
* amount : decimal(10,2)
* balance_after : decimal(10,2)
* description : varchar(255)
* reference_id : int(10) unsigned
* reference_type : varchar(50)
* status : enum('pending','completed','failed')
* created_at : timestamp
v digital_store users
* id : int(10) unsigned
* username : varchar(50)
* email : varchar(100)
* password : varchar(255)
* name : varchar(100)
* phone : varchar(20)
* avatar : varchar(255)
* role : enum('admin','user','seller')
* balance : decimal(10,2)
* status : enum('active','inactive','banned')
* email_verified_at : timestamp
* remember_token : varchar(100)
* last_login_at : timestamp
* last_login_ip : varchar(45)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship