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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 social_app admin_activity_log
* id : int(11)
* admin_id : int(11)
* action : varchar(60)
* target_type : varchar(30)
* target_id : int(11)
* details : varchar(500)
* ip_address : varchar(45)
* created_at : timestamp
v social_app ads
* id : int(11)
* ad_type : enum('image','html_code')
* image_path : varchar(500)
* html_code : text
* caption : varchar(150)
* position : varchar(20)
* video_position : enum('pre_roll','mid_roll')
* target_creator_id : int(11)
* target_post_id : int(11)
* created_by_user_id : int(11)
* is_active : tinyint(1)
* clicks_count : int(11)
* created_at : timestamp
v social_app ad_campaigns
* id : int(11)
* user_id : int(11)
* target_type : varchar(10)
* target_id : int(11)
* title : varchar(120)
* budget : decimal(10,2)
* price_per_1000 : decimal(10,2)
* impressions_target : int(11)
* impressions_delivered : int(11)
* clicks_count : int(11)
* duration_days : smallint(6)
* target_countries : varchar(100)
* target_devices : varchar(30)
* payment_method : varchar(20)
* payment_sender : varchar(40)
* payment_ref : varchar(80)
* payment_screenshot : varchar(500)
* status : varchar(16)
* admin_reason : varchar(500)
* reviewed_by : int(11)
* reviewed_at : datetime
* submit_count : smallint(6)
* starts_at : datetime
* ends_at : datetime
* created_at : timestamp
* updated_at : timestamp
* ad_kind : varchar(10)
* description : varchar(300)
* creative_path : varchar(500)
* whatsapp : varchar(20)
* chat_enabled : tinyint(1)
* cta_text : varchar(30)
* scan_note : varchar(255)
v social_app ad_events
* id : int(11)
* ad_id : int(11)
* event_type : enum('view','click','skip')
* user_id : int(11)
* ip_address : varchar(45)
* device_type : varchar(30)
* creator_id : int(11)
* post_id : int(11)
* is_suspicious : tinyint(1)
* created_at : timestamp
v social_app ad_impressions
* ad_id : int(11)
* visitor_key : varchar(64)
* impressions : int(11)
* window_start : datetime
v social_app bookmarks
* id : int(11)
* user_id : int(11)
* post_id : int(11)
* created_at : timestamp
v social_app call_participants
* id : int(11)
* room_id : int(11)
* user_id : int(11)
* status : varchar(12)
* invited_at : timestamp
* joined_at : datetime
* left_at : datetime
* last_ping : datetime
v social_app call_ratings
* id : int(11)
* room_id : int(11)
* rater_id : int(11)
* rated_user_id : int(11)
* rating : tinyint(4)
* created_at : timestamp
v social_app call_rooms
* id : int(11)
* host_id : int(11)
* call_type : varchar(10)
* status : varchar(10)
* created_at : timestamp
* ended_at : datetime
v social_app call_room_signals
* id : bigint(20)
* room_id : int(11)
* from_user : int(11)
* to_user : int(11)
* signal_type : varchar(12)
* payload : mediumtext
* created_at : timestamp
v social_app call_sessions
* id : int(11)
* caller_id : int(11)
* callee_id : int(11)
* call_type : enum('audio','video')
* status : enum('ringing','accepted','declined','ended','missed')
* started_at : timestamp
* ended_at : timestamp
v social_app call_signals
* id : int(11)
* call_id : int(11)
* sender_id : int(11)
* signal_type : enum('offer','answer','ice_candidate')
* payload : mediumtext
* created_at : timestamp
v social_app campaign_reviews
* id : int(11)
* campaign_id : int(11)
* admin_id : int(11)
* action : varchar(14)
* reason : varchar(500)
* created_at : timestamp
v social_app campaign_stats_daily
* campaign_id : int(11)
* stat_date : date
* country : char(2)
* device : varchar(10)
* impressions : int(11)
* clicks : int(11)
v social_app categories
* id : int(11)
* name : varchar(50)
* emoji : varchar(10)
* created_at : timestamp
v social_app comments
* id : int(11)
* post_id : int(11)
* user_id : int(11)
* content : text
* created_at : timestamp
* parent_id : int(11)
* edited_at : datetime
v social_app contact_hashes
* user_id : int(11)
* h : char(64)
* created_at : timestamp
v social_app conversation_archives
* id : int(11)
* user_id : int(11)
* other_id : int(11)
* archived_at : timestamp
v social_app conversation_versions
* user_low : int(11)
* user_high : int(11)
* version : int(10) unsigned
v social_app earnings_ledger
* id : int(11)
* user_id : int(11)
* post_id : int(11)
* ad_event_id : int(11)
* amount : decimal(10,4)
* reason : enum('ad_click','ad_view')
* created_at : timestamp
v social_app error_logs
* id : int(11)
* severity : varchar(30)
* message : text
* file_path : varchar(500)
* line_number : int(11)
* trace : text
* request_url : varchar(500)
* user_id : int(11)
* is_resolved : tinyint(1)
* created_at : timestamp
v social_app friends
* id : int(11)
* user_id : int(11)
* friend_id : int(11)
* status : enum('pending','accepted')
* created_at : timestamp
v social_app friend_categories
* id : int(11)
* owner_id : int(11)
* friend_id : int(11)
* category : varchar(20)
v social_app friend_dismissed
* user_id : int(11)
* other_id : int(11)
* created_at : timestamp
v social_app hashtags
* id : int(11)
* tag : varchar(100)
* uses_count : int(11)
* last_used_at : datetime
v social_app likes
* id : int(11)
* post_id : int(11)
* user_id : int(11)
* reaction_type : enum('like','love','haha','wow','sad','angry')
* created_at : timestamp
v social_app live_messages
* id : int(11)
* stream_id : int(11)
* user_id : int(11)
* body : varchar(300)
* created_at : timestamp
v social_app live_streams
* id : int(11)
* user_id : int(11)
* title : varchar(150)
* description : varchar(500)
* category : varchar(40)
* audience : varchar(8)
* stream_key : char(32)
* path_name : char(20)
* status : varchar(10)
* status_note : varchar(300)
* sexual : tinyint(3) unsigned
* checks_done : int(11)
* viewers : int(11)
* peak_viewers : int(11)
* scheduled_at : datetime
* started_at : datetime
* ended_at : datetime
* last_check_at : datetime
* created_at : timestamp
v social_app login_attempts
* id : int(11)
* identifier : varchar(100)
* success : tinyint(1)
* created_at : timestamp
v social_app messages
* id : int(11)
* sender_id : int(11)
* receiver_id : int(11)
* content : text
* attachment_path : varchar(500)
* attachment_type : varchar(20)
* is_read : tinyint(1)
* created_at : timestamp
* deleted_at : datetime
* shared_post_id : int(11)
* call_room_id : int(11)
* call_type : varchar(10)
* call_outcome : varchar(20)
* call_duration : int(11)
v social_app message_reactions
* id : int(11)
* message_id : int(11)
* user_id : int(11)
* emoji : varchar(16)
v social_app moderation_results
* id : int(11)
* post_id : int(11)
* upload_url : varchar(190)
* user_id : int(11)
* engine : varchar(30)
* sexual : tinyint(3) unsigned
* violence : tinyint(3) unsigned
* text_score : tinyint(3) unsigned
* verdict : varchar(10)
* reason : varchar(600)
* frames_json : mediumtext
* created_at : timestamp
v social_app monetization_requests
* id : int(11)
* user_id : int(11)
* post_id : int(11)
* status : enum('pending','approved','rejected')
* created_at : timestamp
v social_app notifications
* id : int(11)
* user_id : int(11)
* actor_id : int(11)
* type : varchar(40)
* post_id : int(11)
* extra_text : varchar(255)
* is_read : tinyint(1)
* created_at : timestamp
v social_app notification_prefs
* user_id : int(11)
* notif_type : varchar(40)
* enabled : tinyint(1)
v social_app pages
* id : int(11)
* owner_id : int(11)
* name : varchar(100)
* category : varchar(50)
* description : varchar(500)
* avatar_path : varchar(500)
* cover_path : varchar(500)
* avatar_color : varchar(20)
* is_verified : tinyint(1)
* created_at : timestamp
v social_app page_followers
* id : int(11)
* page_id : int(11)
* user_id : int(11)
* created_at : timestamp
v social_app page_views
* id : int(11)
* visitor_key : varchar(64)
* user_id : int(11)
* ip_address : varchar(45)
* user_agent : varchar(300)
* device_type : varchar(30)
* page_url : varchar(300)
* page_label : varchar(150)
* duration_seconds : int(11)
* created_at : timestamp
v social_app password_resets
* id : int(11)
* user_id : int(11)
* token_hash : char(64)
* expires_at : datetime
* used_at : datetime
* delivery : varchar(20)
* status : varchar(20)
* requested_ip : varchar(45)
* created_at : timestamp
v social_app payment_methods
* id : int(11)
* code : varchar(20)
* label : varchar(60)
* details : varchar(500)
* holder_name : varchar(80)
* icon : varchar(80)
* is_active : tinyint(1)
* sort_order : smallint(6)
v social_app poll_options
* id : int(11)
* post_id : int(11)
* option_text : varchar(150)
* position : tinyint(4)
v social_app poll_votes
* id : int(11)
* post_id : int(11)
* option_id : int(11)
* user_id : int(11)
* created_at : timestamp
v social_app posts
* id : int(11)
* user_id : int(11)
* content : text
* media_type : varchar(20)
* media_url : varchar(500)
* visibility : varchar(20)
* views_count : int(11)
* shares_count : int(11)
* ad_placement : enum('auto','pre_roll','mid_roll','none')
* video_title : varchar(200)
* category : varchar(50)
* tags : varchar(500)
* thumbnail_path : varchar(500)
* ad_enabled : tinyint(1)
* ad_positions : varchar(255)
* is_short : tinyint(1)
* deletion_status : enum('none','pending','denied')
* created_at : timestamp
* is_pinned : tinyint(1)
* edited_at : datetime
* page_id : int(11)
* moderation_status : varchar(12)
* moderation_score : tinyint(3) unsigned
* moderation_note : varchar(255)
* max_quality : varchar(8)
* allow_download : tinyint(1)
* audience : varchar(8)
v social_app post_boosts
* id : int(11)
* post_id : int(11)
* user_id : int(11)
* cost : decimal(10,2)
* impressions_target : int(11)
* impressions_delivered : int(11)
* status : varchar(20)
* created_at : timestamp
v social_app post_drafts
* id : int(11)
* user_id : int(11)
* content : text
* media_type : varchar(20)
* media_url : varchar(500)
* visibility : varchar(20)
* extra_json : text
* status : varchar(20)
* scheduled_at : datetime
* created_at : timestamp
* updated_at : timestamp
v social_app post_edits
* id : int(11)
* post_id : int(11)
* old_content : text
* old_video_title : varchar(200)
* old_category : varchar(50)
* old_tags : varchar(500)
* old_thumbnail : varchar(500)
* edited_at : timestamp
v social_app post_hashtags
* post_id : int(11)
* hashtag_id : int(11)
* created_at : datetime
v social_app profile_visits
* id : int(11)
* profile_id : int(11)
* visitor_id : int(11)
* visit_date : date
v social_app rate_limits
* bucket_key : varchar(150)
* hits : int(11)
* window_start : int(11)
v social_app reports
* id : int(11)
* reporter_id : int(11)
* post_id : int(11)
* reason : varchar(50)
* details : text
* screenshot_path : varchar(500)
* status : enum('pending','reviewed','dismissed')
* created_at : timestamp
v social_app settings
* setting_key : varchar(100)
* setting_value : varchar(255)
v social_app support_messages
* id : int(11)
* ticket_id : int(11)
* sender_id : int(11)
* is_admin_reply : tinyint(1)
* content : text
* attachment_path : varchar(500)
* attachment_type : varchar(20)
* created_at : timestamp
v social_app support_tickets
* id : int(11)
* user_id : int(11)
* subject : varchar(200)
* status : enum('open','closed')
* created_at : timestamp
v social_app typing_status
* user_id : int(11)
* to_user_id : int(11)
* updated_at : datetime
v social_app upload_scans
* media_url : varchar(190)
* user_id : int(11)
* frames_count : tinyint(4)
* skin_score : tinyint(3) unsigned
* ai_score : tinyint(3) unsigned
* note : varchar(255)
* created_at : timestamp
* gore_score : tinyint(3) unsigned
* source : varchar(10)
* engine : varchar(30)
* details : mediumtext
v social_app users
* id : int(11)
* name : varchar(100)
* contact : varchar(150)
* password : varchar(255)
* age : int(11)
* avatar_color : varchar(20)
* cover_gradient : varchar(60)
* cover_image_path : varchar(500)
* avatar_path : varchar(500)
* bio : varchar(255)
* privacy_default : varchar(20)
* message_privacy : enum('everyone','friends_only')
* monetization_enabled : tinyint(1)
* default_ad_enabled : tinyint(1)
* preview_sound_enabled : tinyint(1)
* is_admin : tinyint(1)
* created_at : timestamp
* is_verified : tinyint(1)
* is_disabled : tinyint(1)
* suspended_until : datetime
* show_profile_visits : tinyint(1)
* google_id : varchar(64)
* call_privacy : varchar(20)
* vp_duration_limit : int(11)
* vp_quota_mb : int(11)
* is_hidden : tinyint(1)
* hidden_at : datetime
* phone_hash : char(64)
* email_hash : char(64)
* country : char(2)
* city : varchar(60)
v social_app user_blocks
* id : int(11)
* blocker_id : int(11)
* blocked_id : int(11)
* created_at : timestamp
v social_app user_strikes
* id : int(11)
* user_id : int(11)
* report_id : int(11)
* post_id : int(11)
* reason : varchar(50)
* consumed : tinyint(1)
* created_at : timestamp
* source : varchar(10)
* note : varchar(255)
* created_by : int(11)
v social_app user_uploads
* id : int(11)
* url : varchar(255)
* user_id : int(11)
* folder : varchar(30)
* size : bigint(20)
* created_at : timestamp
v social_app video_captions
* id : int(11)
* post_id : int(11)
* language : varchar(10)
* language_label : varchar(50)
* vtt_path : varchar(500)
* created_at : timestamp
v social_app video_daily_views
* post_id : int(11)
* view_date : date
* views : int(11)
v social_app video_events
* id : int(11)
* upload_id : char(24)
* user_id : int(11)
* level : varchar(8)
* message : varchar(500)
* created_at : timestamp
v social_app video_renditions
* id : int(11)
* post_id : int(11)
* quality : varchar(8)
* file_path : varchar(500)
* file_size : bigint(20)
* source : varchar(10)
* created_at : timestamp
v social_app video_uploads
* id : char(24)
* user_id : int(11)
* post_id : int(11)
* fingerprint : varchar(64)
* original_name : varchar(200)
* ext : varchar(8)
* size : bigint(20)
* chunk_size : int(11)
* chunks_total : int(11)
* status : varchar(12)
* progress : tinyint(3) unsigned
* stage : varchar(80)
* attempts : tinyint(3) unsigned
* priority : tinyint(4)
* error : varchar(500)
* original_url : varchar(255)
* media_url : varchar(255)
* thumb_url : varchar(255)
* duration : decimal(10,2)
* width : smallint(5) unsigned
* height : smallint(5) unsigned
* vcodec : varchar(20)
* bitrate_kbps : int(11)
* result_json : text
* audience : varchar(8)
* locked_at : datetime
* finished_at : datetime
* created_at : timestamp
* updated_at : timestamp
* kind : varchar(6)
* scan_done : tinyint(1)
v social_app video_watch_history
* id : int(11)
* user_id : int(11)
* post_id : int(11)
* category : varchar(50)
* watch_seconds : int(11)
* updated_at : timestamp
v social_app withdrawal_requests
* id : int(11)
* user_id : int(11)
* amount : decimal(10,2)
* method : varchar(40)
* account_details : varchar(255)
* status : varchar(20)
* admin_note : varchar(255)
* created_at : timestamp
* processed_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship