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 full-screen 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
v v
Number of tables: 0
v qbcoreframework_71b942 0resmon_apartment_rooms
* id : int(11)
* apartment_id : int(11)
* room_id : int(11)
* owner : varchar(64)
* owner_name : varchar(64)
* life_time : tinyint(1)
* options : text
* permissions : mediumtext
* furnitures : longtext
* indicators : mediumtext
* due_date : datetime
* created_at : timestamp
* updated_at : timestamp
v qbcoreframework_71b942 0resmon_ph_houses
* id : int(11)
* type : varchar(32)
* label : varchar(64)
* price : int(11)
* door_coords : text
* garage_coords : text
* coords_label : varchar(255)
* meta : longtext
* created_at : timestamp
* updated_at : timestamp
v qbcoreframework_71b942 0resmon_ph_owned_houses
* id : int(11)
* houseId : int(11)
* type : varchar(32)
* owner : varchar(64)
* owner_name : varchar(64)
* options : text
* permissions : mediumtext
* furnitures : longtext
* indicators : mediumtext
* created_at : timestamp
* updated_at : timestamp
v qbcoreframework_71b942 0resmon_weed_dryers
* id : int(11)
* zoneId : varchar(64)
* dryerId : varchar(64)
* extraDryEffect : int(11)
* items : longtext
* created_at : timestamp
* updated_at : timestamp
v qbcoreframework_71b942 0resmon_weed_plants
* id : int(11)
* zoneId : varchar(64)
* genetics : varchar(6)
* stage : int(11)
* health : int(11)
* light : int(11)
* water : int(11)
* fertilizer : int(11)
* coords : text
* created_at : timestamp
* updated_at : timestamp
v qbcoreframework_71b942 apartments
* id : int(10) unsigned
* name : varchar(255)
* type : varchar(255)
* label : varchar(255)
* citizenid : varchar(11)
v qbcoreframework_71b942 bank_accounts
* id : int(11)
* citizenid : varchar(11)
* account_name : varchar(50)
* account_balance : int(11)
* account_type : enum('shared','job','gang')
* users : longtext
v qbcoreframework_71b942 bank_accounts_new
* id : varchar(50)
* amount : int(11)
* transactions : longtext
* auth : longtext
* isFrozen : int(11)
* creator : varchar(50)
v qbcoreframework_71b942 bank_statements
* id : int(11)
* citizenid : varchar(11)
* account_name : varchar(50)
* amount : int(11)
* reason : varchar(50)
* statement_type : enum('deposit','withdraw')
* date : timestamp
v qbcoreframework_71b942 bans
* id : int(11)
* name : varchar(50)
* license : varchar(50)
* discord : varchar(50)
* ip : varchar(50)
* reason : text
* expire : int(11)
* bannedby : varchar(255)
v qbcoreframework_71b942 codem_venicehud_data
* identifier : varchar(65)
* data : longtext
* stress : int(11)
v qbcoreframework_71b942 crypto
* crypto : varchar(50)
* worth : int(11)
* history : text
v qbcoreframework_71b942 crypto_transactions
* id : int(11)
* citizenid : varchar(11)
* title : varchar(50)
* message : varchar(50)
* date : timestamp
v qbcoreframework_71b942 darkchat_messages
* id : int(11)
* password : text
* owner : varchar(50)
* name : varchar(50)
* messages : text
v qbcoreframework_71b942 dealers
* id : int(11)
* name : varchar(50)
* coords : longtext
* time : longtext
* createdby : varchar(50)
v qbcoreframework_71b942 frkn_hack
* id : int(11)
* identifier : varchar(46)
* notes : longtext
* announcement : longtext
* apps : longtext
* build : longtext
* props : longtext
* miner : longtext
* username : varchar(50)
* cryptoaddress : varchar(50)
* macaddress : varchar(50)
* reputation : longtext
* hire : longtext
* butcoin : decimal(20,6)
* temporaryCoin : decimal(20,6)
* connectWifiTime : time
* openControl : tinyint(4)
v qbcoreframework_71b942 frkn_hack_public_binunce
* id : int(11)
* senderUserName : varchar(100)
* senderAddress : varchar(100)
* receiverAddress : varchar(100)
* macAddress : varchar(100)
* amount : varchar(50)
v qbcoreframework_71b942 frkn_heist_contracts
* id : int(11)
* contractId : int(11)
* timeOut : datetime
* members : longtext
* start : tinyint(1)
v qbcoreframework_71b942 frkn_heist_strains
* id : int(11)
* identifier : varchar(50)
* name : varchar(50)
* members : longtext
v qbcoreframework_71b942 gloveboxitems
* id : int(11)
* plate : varchar(255)
* items : longtext
* label : varchar(100)
* slots : int(11)
* personal : varchar(255)
* weight : int(11)
* job : varchar(100)
v qbcoreframework_71b942 houselocations
* id : int(11)
* name : varchar(255)
* label : varchar(255)
* coords : text
* owned : tinyint(1)
* price : int(11)
* tier : tinyint(4)
* garage : text
v qbcoreframework_71b942 house_plants
* id : int(11)
* building : varchar(50)
* stage : int(11)
* sort : varchar(50)
* gender : varchar(50)
* food : int(11)
* health : int(11)
* progress : int(11)
* coords : text
* plantid : varchar(50)
v qbcoreframework_71b942 instagram_account
* id : varchar(90)
* name : varchar(50)
* phone : varchar(50)
* username : varchar(50)
* password : varchar(50)
* avatar : text
* description : text
* verify : int(11)
v qbcoreframework_71b942 instagram_followers
* username : varchar(50)
* followed : varchar(50)
v qbcoreframework_71b942 instagram_posts
* id : int(11)
* username : varchar(50)
* image : text
* description : varchar(255)
* location : varchar(50)
* filter : varchar(50)
* created : timestamp
* likes : text
v qbcoreframework_71b942 instagram_stories
* owner : varchar(50)
* data : text
v qbcoreframework_71b942 insta_stories
* username : varchar(50)
* location : varchar(50)
* filter : varchar(50)
* description : varchar(50)
* image : text
* created : time
v qbcoreframework_71b942 inventories
* id : int(11)
* identifier : varchar(50)
* items : longtext
v qbcoreframework_71b942 lapraces
* id : int(11)
* name : varchar(50)
* checkpoints : text
* records : text
* creator : varchar(50)
* distance : int(11)
* raceid : varchar(50)
v qbcoreframework_71b942 occasion_vehicles
* id : int(11)
* seller : varchar(50)
* price : int(11)
* description : longtext
* plate : varchar(50)
* model : varchar(50)
* mods : text
* occasionid : varchar(50)
v qbcoreframework_71b942 ox_doorlock
* id : int(11) unsigned
* name : varchar(50)
* data : longtext
v qbcoreframework_71b942 pefcl_accounts
* id : int(11)
* number : varchar(255)
* accountName : varchar(255)
* isDefault : tinyint(1)
* ownerIdentifier : varchar(255)
* role : varchar(255)
* balance : int(11)
* type : varchar(255)
* createdAt : datetime
* updatedAt : datetime
* deletedAt : datetime
v qbcoreframework_71b942 pefcl_cash
* id : int(11)
* amount : int(11)
* ownerIdentifier : varchar(255)
* createdAt : datetime
* updatedAt : datetime
v qbcoreframework_71b942 pefcl_external_accounts
* id : int(11)
* number : varchar(255)
* name : varchar(255)
* userId : varchar(255)
* createdAt : datetime
* updatedAt : datetime
v qbcoreframework_71b942 pefcl_invoices
* id : int(11)
* message : varchar(255)
* from : varchar(255)
* to : varchar(255)
* fromIdentifier : varchar(255)
* toIdentifier : varchar(255)
* receiverAccountIdentifier : varchar(255)
* amount : int(11)
* status : varchar(255)
* expiresAt : datetime
* createdAt : datetime
* updatedAt : datetime
v qbcoreframework_71b942 pefcl_shared_accounts
* id : int(11)
* userIdentifier : varchar(255)
* name : varchar(255)
* role : varchar(255)
* createdAt : datetime
* updatedAt : datetime
* deletedAt : datetime
* accountId : int(11)
v qbcoreframework_71b942 pefcl_transactions
* id : int(11)
* message : varchar(255)
* amount : int(11)
* type : varchar(255)
* createdAt : datetime
* updatedAt : datetime
* toAccountId : int(11)
* fromAccountId : int(11)
v qbcoreframework_71b942 phone_accounts
* app : varchar(50)
* id : varchar(80)
* name : varchar(50)
* password : varchar(50)
* birthdate : varchar(50)
* gender : varchar(50)
* interested : text
* avatar : text
v qbcoreframework_71b942 phone_alertjobs
* id : int(11)
* job : varchar(255)
* alerts : longtext
* date : timestamp
v qbcoreframework_71b942 phone_chats
* app : varchar(50)
* author : varchar(50)
* number : varchar(50)
* created : varchar(50)
v qbcoreframework_71b942 phone_invoices
* id : int(10)
* citizenid : varchar(50)
* amount : int(11)
* society : tinytext
* sender : varchar(50)
* sendercitizenid : varchar(50)
v qbcoreframework_71b942 phone_messages
* id : int(11)
* citizenid : varchar(46)
* phone : varchar(50)
* number : varchar(50)
* owner : varchar(50)
* messages : text
* type : varchar(50)
* read : int(11)
* created : varchar(50)
v qbcoreframework_71b942 phone_news
* id : int(11)
* owner : varchar(50)
* title : varchar(50)
* content : text
* image : text
* created : varchar(50)
v qbcoreframework_71b942 phone_notifies
* id : int(11)
* phone : varchar(50)
* msg_content : text
* msg_head : varchar(50)
* app_name : text
* msg_time : varchar(50)
v qbcoreframework_71b942 phone_tweets
* id : int(11)
* citizenid : varchar(11)
* firstName : varchar(25)
* lastName : varchar(25)
* message : text
* date : datetime
* url : text
* picture : varchar(512)
* tweetId : varchar(25)
v qbcoreframework_71b942 players
* id : int(11)
* citizenid : varchar(11)
* cid : int(11)
* license : varchar(255)
* name : varchar(255)
* money : text
* charinfo : text
* job : text
* gang : text
* position : text
* metadata : text
* inventory : longtext
* last_updated : timestamp
* apps : text
* widget : text
* bt : text
* cryptocurrency : longtext
* cryptocurrencytransfers : text
* phonePos : text
* spotify : text
* ringtone : text
* first_screen_showed : int(11)
v qbcoreframework_71b942 playerskins
* id : int(11)
* citizenid : varchar(11)
* model : varchar(255)
* skin : text
* active : tinyint(4)
v qbcoreframework_71b942 player_contacts
* id : int(11)
* identifier : varchar(50)
* citizenid : varchar(50)
* name : varchar(50)
* number : varchar(50)
* iban : varchar(50)
* display : varchar(50)
* note : text
* pp : text
* isBlocked : int(11)
v qbcoreframework_71b942 player_houses
* id : int(255)
* house : varchar(50)
* identifier : varchar(50)
* citizenid : varchar(11)
* keyholders : text
* decorations : text
* stash : text
* outfit : text
* logout : text
v qbcoreframework_71b942 player_mails
* id : int(11)
* identifier : varchar(50)
* citizenid : varchar(50)
* sender : varchar(50)
* subject : varchar(50)
* message : text
* read : tinyint(4)
* mailid : int(11)
* date : timestamp
* button : text
v qbcoreframework_71b942 player_notes
* id : int(11)
* identifier : text
* baslik : text
* aciklama : text
v qbcoreframework_71b942 player_outfits
* id : int(11)
* citizenid : varchar(11)
* outfitname : varchar(50)
* model : varchar(50)
* skin : text
* outfitId : varchar(50)
v qbcoreframework_71b942 player_transactions
* id : varchar(50)
* isFrozen : int(11)
* transactions : longtext
v qbcoreframework_71b942 player_vehicles
* id : int(11)
* license : varchar(50)
* citizenid : varchar(11)
* vehicle : varchar(50)
* hash : varchar(50)
* mods : longtext
* plate : varchar(8)
* fakeplate : varchar(8)
* garage : varchar(50)
* fuel : int(11)
* engine : float
* body : float
* state : int(11)
* depotprice : int(11)
* drivingdistance : int(50)
* status : text
* balance : int(11)
* paymentamount : int(11)
* paymentsleft : int(11)
* financetime : int(11)
* glovebox : longtext
* trunk : longtext
v qbcoreframework_71b942 player_warns
* id : int(11)
* senderIdentifier : varchar(50)
* targetIdentifier : varchar(50)
* reason : text
* warnId : varchar(50)
v qbcoreframework_71b942 stashitems
* id : int(11)
* stash : varchar(255)
* items : longtext
* label : varchar(100)
* slots : int(11)
* job : varchar(100)
* personal : varchar(255)
* weight : int(11)
v qbcoreframework_71b942 tiktok_users
* id : int(11)
* username : varchar(50)
* phone : varchar(50)
* pp : text
* name : varchar(50)
* bio : text
* birthday : varchar(50)
* videos : text
* followers : text
* following : text
* liked : text
v qbcoreframework_71b942 tiktok_videos
* id : int(11)
* userID : int(11)
* created : varchar(50)
* data : text
* phone : varchar(50)
v qbcoreframework_71b942 tinder_accounts
* id : int(11)
* phone : varchar(50)
* pp : text
* name : varchar(50)
* gender : varchar(50)
* targetGender : varchar(50)
* hobbies : varchar(50)
* age : varchar(50)
* description : varchar(50)
* password : varchar(50)
v qbcoreframework_71b942 tinder_likes
* id : int(11)
* phone : varchar(1024)
* likeds : mediumtext
v qbcoreframework_71b942 tinder_messages
* id : int(11)
* phone : varchar(50)
* number : longtext
* messages : longtext
v qbcoreframework_71b942 trunkitems
* id : int(11)
* plate : varchar(255)
* items : longtext
* label : varchar(100)
* personal : varchar(255)
* weight : int(11)
* slots : int(11)
* job : varchar(100)
v qbcoreframework_71b942 twitter_account
* id : varchar(90)
* name : varchar(50)
* phone : varchar(50)
* username : varchar(50)
* password : varchar(50)
* avatar : text
v qbcoreframework_71b942 twitter_hashtags
* id : int(11)
* name : varchar(80)
* created : varchar(50)
* count : int(11)
v qbcoreframework_71b942 twitter_mentions
* id : int(11)
* id_tweet : int(11)
* username : varchar(50)
* mentioned : text
* created : varchar(50)
v qbcoreframework_71b942 twitter_tweets
* id : int(5)
* username : varchar(80)
* message : longtext
* hashtags : varchar(50)
* mentions : varchar(50)
* created : varchar(50)
* image : text
* likes : text
v qbcoreframework_71b942 whatsapp_accounts
* id : varchar(100)
* name : varchar(50)
* phone : varchar(50)
* password : varchar(50)
* avatar : text
v qbcoreframework_71b942 whatsapp_chats
* id : int(11)
* phone : varchar(50)
* number : varchar(50)
* created : varchar(50)
* messages : text
v qbcoreframework_71b942 whatsapp_chats_messages
* id : int(11)
* id_chat : int(11)
* owner : varchar(50)
* type : varchar(50)
* created : varchar(50)
* message : mediumtext
* readed : int(1)
v qbcoreframework_71b942 whatsapp_groups
* id : int(11)
* phone : varchar(50)
* number : varchar(50)
* type : varchar(50)
* name : varchar(50)
* image : text
* created : varchar(50)
v qbcoreframework_71b942 whatsapp_groups_messages
* id : int(11)
* id_group : varchar(50)
* owner : varchar(50)
* type : varchar(50)
* message : text
* created : varchar(50)
* read : int(11)
* name : varchar(50)
v qbcoreframework_71b942 whatsapp_groups_users
* number_group : varchar(50)
* admin : int(11)
* phone : varchar(50)
v qbcoreframework_71b942 whatsapp_stories
* phone : varchar(50)
* image : text
* created : varchar(50)
* description : varchar(50)
* location : varchar(50)
* filter : varchar(50)
v qbcoreframework_71b942 yellowpages_posts
* id : int(11)
* message : text
* name : varchar(255)
* number : varchar(20)
* url : varchar(255)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship