قم إفلات الملفات هنا

SQL upload ( 0 ) x -

الإعدادات المتعلقة بالصفحة انقر على الشريط للتمرير إلى أعلى الصفحة
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
تصحيح SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
تحديث
إضافة
لا توجد إشارات مرجعية
إضافة للمفضلة
خيارات
Set default





Collapse Expand Requery تعديل Explain جانبي Bookmark Query failed قاعدة البيانات : Queried time :
بدون عنوان *
v Show/Hide tables list View in fullscreen اضافة جداول من قواعد بيانات اخري New page فتح الصفحة احفظ الصفحة حفظ الصفحة في صيغة Delete pages أنشئ الجدول Create relationship اختر الحقل لإظهاره Reload مساعدة Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > نقل القائمة > Pin text
v v
عدد الجداول: 0
v roveix_desk audit_logs
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* action : varchar(100)
* entity : varchar(100)
* entity_id : int(10) unsigned
* meta : longtext
* ip_address : varchar(64)
* created_at : datetime
v roveix_desk branches
* id : int(10) unsigned
* salla_id : bigint(20) unsigned
* name : varchar(190)
* branch_code : varchar(100)
* city : varchar(120)
* country : varchar(120)
* address : text
* shippable : tinyint(1)
* pickable : tinyint(1)
* pos : tinyint(1)
* raw_data : longtext
* active : tinyint(1)
* salla_synced_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix_desk brands
* id : int(10) unsigned
* salla_id : bigint(20) unsigned
* name : varchar(190)
* description : text
* banner : varchar(500)
* raw_data : longtext
* active : tinyint(1)
* salla_synced_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix_desk categories
* id : int(10) unsigned
* salla_id : bigint(20) unsigned
* name : varchar(160)
* slug : varchar(190)
* active : tinyint(1)
* created_at : datetime
* updated_at : datetime
* raw_data : longtext
* salla_synced_at : datetime
v roveix_desk customers
* id : bigint(20) unsigned
* salla_id : bigint(20) unsigned
* first_name : varchar(120)
* last_name : varchar(120)
* full_name : varchar(255)
* mobile : varchar(50)
* email : varchar(190)
* gender : varchar(30)
* city : varchar(120)
* country : varchar(120)
* country_code : varchar(10)
* location : varchar(500)
* avatar : varchar(500)
* raw_data : longtext
* source : enum('local','salla','import')
* salla_synced_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix_desk expenses
* id : int(10) unsigned
* category : varchar(100)
* description : varchar(500)
* amount : decimal(12,2)
* expense_date : date
* attachment : varchar(500)
* user_id : int(10) unsigned
* created_at : datetime
v roveix_desk import_logs
* id : bigint(20) unsigned
* filename : varchar(255)
* added : int(11)
* updated : int(11)
* skipped : int(11)
* errors : longtext
* user_id : int(10) unsigned
* created_at : datetime
v roveix_desk inventory_movements
* id : bigint(20) unsigned
* product_id : int(10) unsigned
* movement : enum('purchase','sale','adjustment','return','import')
* qty_change : int(11)
* qty_after : int(11)
* reference_type : varchar(40)
* reference_id : int(10) unsigned
* note : varchar(500)
* user_id : int(10) unsigned
* created_at : datetime
v roveix_desk login_attempts
* id : bigint(20) unsigned
* email_hash : char(64)
* ip_address : varchar(64)
* attempts : smallint(5) unsigned
* window_started : datetime
* blocked_until : datetime
* updated_at : datetime
v roveix_desk messages
* id : bigint(20) unsigned
* sender_id : int(10) unsigned
* recipient_id : int(10) unsigned
* subject : varchar(180)
* body : text
* is_read : tinyint(1)
* created_at : datetime
v roveix_desk notifications
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* title : varchar(180)
* body : varchar(1000)
* type : varchar(40)
* is_read : tinyint(1)
* created_at : datetime
v roveix_desk notification_deliveries
* id : bigint(20) unsigned
* notification_id : bigint(20) unsigned
* user_id : int(10) unsigned
* is_read : tinyint(1)
* read_at : datetime
* created_at : datetime
v roveix_desk products
* id : int(10) unsigned
* salla_id : bigint(20) unsigned
* category_id : int(10) unsigned
* name : varchar(255)
* sku : varchar(100)
* mpn : varchar(100)
* aliases : text
* description : mediumtext
* price : decimal(12,2)
* regular_price : decimal(12,2)
* cost : decimal(12,2)
* quantity : int(11)
* default_qty : int(11)
* low_stock_threshold : int(11)
* image_url : text
* local_image : varchar(500)
* product_url : text
* status : enum('sale','out','hidden','archived')
* source : enum('local','salla','import')
* raw_data : longtext
* created_at : datetime
* updated_at : datetime
* brand_id : int(10) unsigned
* unlimited_quantity : tinyint(1)
* salla_hash : char(64)
* sync_state : enum('local','synced','local_newer','remote_newer','conflict','error')
* sync_error : text
* salla_synced_at : datetime
v roveix_desk quotes
* id : int(10) unsigned
* quote_no : varchar(40)
* customer_name : varchar(150)
* customer_phone : varchar(50)
* vin : varchar(40)
* status : enum('draft','sent','accepted','rejected','converted')
* subtotal : decimal(12,2)
* discount : decimal(12,2)
* total : decimal(12,2)
* note : text
* user_id : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v roveix_desk quote_items
* id : int(10) unsigned
* quote_id : int(10) unsigned
* product_id : int(10) unsigned
* name : varchar(255)
* sku : varchar(100)
* qty : int(11)
* unit_price : decimal(12,2)
* cost : decimal(12,2)
* line_total : decimal(12,2)
v roveix_desk sales
* id : int(10) unsigned
* invoice_no : varchar(40)
* quote_id : int(10) unsigned
* customer_name : varchar(150)
* vin : varchar(40)
* payment_method : varchar(80)
* subtotal : decimal(12,2)
* discount : decimal(12,2)
* payment_fees : decimal(12,2)
* shipping_cost : decimal(12,2)
* other_costs : decimal(12,2)
* cogs : decimal(12,2)
* total : decimal(12,2)
* net_profit : decimal(12,2)
* status : enum('completed','pending','cancelled','refunded')
* user_id : int(10) unsigned
* sold_at : datetime
* created_at : datetime
* customer_phone : varchar(50)
* notes : text
* external_order_no : varchar(60)
* payment_method_key : varchar(60)
* shipping_revenue : decimal(12,2)
* payment_fee_base : decimal(12,2)
* payment_fee_vat : decimal(12,2)
* wallet_deductions : decimal(12,2)
* payout_net : decimal(12,2)
* updated_at : datetime
* salla_order_id : bigint(20) unsigned
* salla_reference_id : bigint(20) unsigned
* source : enum('local','salla')
* raw_data : longtext
* salla_synced_at : datetime
v roveix_desk sale_items
* id : int(10) unsigned
* sale_id : int(10) unsigned
* product_id : int(10) unsigned
* name : varchar(255)
* sku : varchar(100)
* qty : int(11)
* unit_price : decimal(12,2)
* unit_cost : decimal(12,2)
* line_total : decimal(12,2)
* line_profit : decimal(12,2)
v roveix_desk salla_connections
* id : int(10) unsigned
* merchant_id : bigint(20) unsigned
* store_name : varchar(190)
* store_domain : varchar(255)
* authorized_user : longtext
* access_token_enc : longtext
* refresh_token_enc : longtext
* token_expires_at : datetime
* refresh_expires_at : datetime
* scopes : longtext
* authorization_mode : enum('custom','easy')
* status : enum('pending','connected','expired','revoked','error')
* last_error : text
* last_connected_at : datetime
* last_api_at : datetime
* last_sync_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix_desk salla_jobs
* id : bigint(20) unsigned
* connection_id : int(10) unsigned
* job_type : varchar(80)
* payload : longtext
* status : enum('queued','running','done','failed')
* attempts : smallint(5) unsigned
* available_at : datetime
* locked_at : datetime
* finished_at : datetime
* last_error : text
* created_at : datetime
v roveix_desk salla_remote_entities
* id : bigint(20) unsigned
* connection_id : int(10) unsigned
* entity_type : varchar(80)
* external_id : varchar(100)
* local_table : varchar(80)
* local_id : bigint(20) unsigned
* external_updated_at : datetime
* payload_hash : char(64)
* payload : longtext
* sync_state : enum('remote','synced','local_newer','remote_newer','conflict','deleted','error')
* last_error : text
* last_seen_at : datetime
* created_at : datetime
* updated_at : datetime
v roveix_desk salla_sync_logs
* id : bigint(20) unsigned
* connection_id : int(10) unsigned
* resource : varchar(80)
* direction : enum('pull','push','webhook','test')
* status : enum('running','success','partial','failed')
* added : int(11)
* updated : int(11)
* skipped : int(11)
* failed : int(11)
* details : longtext
* started_at : datetime
* finished_at : datetime
* user_id : int(10) unsigned
v roveix_desk salla_webhook_events
* id : bigint(20) unsigned
* connection_id : int(10) unsigned
* event_name : varchar(120)
* merchant_id : bigint(20) unsigned
* event_hash : char(64)
* payload : longtext
* status : enum('received','processing','processed','ignored','failed')
* attempts : smallint(5) unsigned
* last_error : text
* received_at : datetime
* processed_at : datetime
v roveix_desk settings
* key : varchar(120)
* value : longtext
v roveix_desk system_announcements
* id : int(10) unsigned
* title : varchar(180)
* body : varchar(1000)
* display_mode : enum('fixed','marquee')
* type : enum('info','success','warning','danger')
* is_active : tinyint(1)
* starts_at : datetime
* ends_at : datetime
* created_by : int(10) unsigned
* created_at : datetime
* updated_at : datetime
v roveix_desk users
* id : int(10) unsigned
* name : varchar(120)
* email : varchar(190)
* password : varchar(255)
* role : enum('admin','manager','sales','accountant','inventory','custom')
* permissions : longtext
* avatar : varchar(500)
* phone : varchar(40)
* status : enum('active','disabled')
* last_login_at : datetime
* created_at : datetime
* updated_at : datetime
* avatar_seed : varchar(120)
* avatar_style : varchar(60)
* employee_code : varchar(50)
* job_title : varchar(120)
* department : varchar(120)
* notes : text
* session_version : int(10) unsigned
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship