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
v v
Number of tables: 0
v coregg-sp accounts
* id : bigint(20)
* whitelist : tinyint(1)
* chars : int(10)
* gems : int(20)
* priority : int(20)
* rolepass : int(20)
* premium : int(20)
* discord : varchar(50)
* indications : int(11)
* license : varchar(50)
v coregg-sp amarrar
* Passport : int(11)
* Minutos : int(11)
v coregg-sp bank_accounts
* id : bigint(20)
* user_id : varchar(50)
* image_url : varchar(255)
* is_business : tinyint(4)
* name : varchar(50)
* balance : int(10) unsigned
v coregg-sp bank_account_cryptos
* account_id : bigint(20)
* iso : char(3)
* balance : decimal(20,8)
v coregg-sp bank_account_invites
* account_id : bigint(20)
* user_id : varchar(50)
* role : varchar(50)
* created_at : int(11)
v coregg-sp bank_account_members
* user_id : varchar(50)
* account_id : bigint(20)
* role : varchar(50)
* created_at : int(11)
v coregg-sp bank_charts
* day : int(11)
* account_id : bigint(20)
* balance : int(10) unsigned
v coregg-sp bank_fines
* id : bigint(20)
* user_id : varchar(50)
* description : varchar(255)
* amount : int(10) unsigned
* metadata : text
* paid_at : int(11)
* expires_at : int(11)
* interest : int(10) unsigned
* created_at : int(11)
v coregg-sp bank_investments
* id : bigint(20)
* account_id : bigint(20)
* code : varchar(255)
* amount : bigint(20) unsigned
* revenue : bigint(20) unsigned
* yield_at : int(10) unsigned
* created_at : int(10) unsigned
v coregg-sp bank_pix_keys
* account_id : bigint(20)
* key : varchar(50)
* created_at : int(11)
v coregg-sp bank_transactions
* id : bigint(20)
* payer_id : bigint(20)
* payee_id : bigint(20)
* type : varchar(50)
* amount : int(10) unsigned
* description : varchar(255)
* author : varchar(255)
* created_at : int(11)
v coregg-sp banneds
* id : int(11)
* license : varchar(50)
* time : int(20)
v coregg-sp big_bennys
* plate : varchar(255)
* level : float
* purged : int(11)
* purge_dist : float
* escape : int(11)
* pipoco : varchar(50)
* color : varchar(50)
* motor : varchar(50)
* stance : text
* remap : text
v coregg-sp big_jobs
* # : int(11)
* user_id : varchar(255)
* xp : int(11)
v coregg-sp big_jobsv2
* user_id : int(11)
* job_name : varchar(255)
* level : int(11)
* xp : int(11)
* resgato : text
v coregg-sp big_jobs_codes
* code : varchar(50)
* xp : int(11)
v coregg-sp centralcart_scheduler
* id : bigint(20)
* user_id : varchar(255)
* command : varchar(255)
* params : text
* execute_at : datetime
v coregg-sp characters
* id : int(11)
* license : varchar(50)
* phone : varchar(10)
* name : varchar(50)
* name2 : varchar(50)
* sex : varchar(1)
* bank : int(20)
* garages : int(11)
* blood : int(1)
* fines : int(20)
* prison : int(11)
* deleted : int(1)
* paypal : int(11)
* age : int(11)
* lastlogin : int(11)
v coregg-sp core_buff
* org : varchar(50)
* horas : int(11)
* porcentagem : int(11)
* domination : tinyint(4)
v coregg-sp core_laundry
* id : int(11)
* efficiency : int(11)
* potency : int(11)
* cleaners : int(11)
* progress : longtext
v coregg-sp core_panel_admissions
* org : varchar(50)
* passport : int(11)
* date : int(22)
* lastdate : int(22)
* ontoday : tinyint(1)
* onyesterday : tinyint(1)
v coregg-sp core_panel_blocklist
* id : int(11)
* Passport : int(11)
* Time : varchar(50)
v coregg-sp core_panel_extracts
* org : varchar(50)
* name : varchar(50)
* passport : int(11)
* action : varchar(50)
* amount : int(11)
* date : int(22)
v coregg-sp core_panel_goals
* org : varchar(50)
* passport : int(11)
* value : int(11)
v coregg-sp core_panel_orgs
* org : varchar(50)
* value : int(3)
* bank : int(11)
* meta : int(11)
v coregg-sp core_royale
* passport : int(11)
* username : text
* avatar : longtext
* kills : int(11)
* deaths : int(11)
* wins : int(11)
* games : int(11)
v coregg-sp entitydata
* dkey : varchar(100)
* dvalue : longtext
v coregg-sp etstore_cnh_fotos
* user_id : int(11)
* foto_local : varchar(255)
* foto_discord : varchar(255)
* ultima_atualizacao : timestamp
v coregg-sp etstore_detencoes
* id : int(11)
* police_id : int(11)
* owner_id : int(11)
* vehicle_name : varchar(50)
* vehicle_identifier : varchar(50)
* motivo : mediumtext
* price : int(11)
* date : int(11)
v coregg-sp etstore_habilitacao
* passport : int(11)
* tipo : varchar(255)
* aprovado : int(11)
v coregg-sp fines
* id : int(11)
* Passport : int(10)
* Name : varchar(50)
* Date : varchar(50)
* Hour : varchar(50)
* Value : int(11)
* Message : longtext
v coregg-sp heyy_hospital_appointments
* id : int(11)
* user_id : varchar(50)
* medic_id : varchar(50)
* department : varchar(50)
* prescription : varchar(50)
* reason : varchar(250)
* description : text
* created_at : timestamp
* updated_at : timestamp
v coregg-sp heyy_hospital_avatars
* user_id : int(11)
* url : text
v coregg-sp heyy_hospital_departments
* department : varchar(50)
* balance : int(11)
v coregg-sp heyy_hospital_duty
* id : int(11)
* user_id : varchar(50)
* started_at : timestamp
* closed_at : timestamp
v coregg-sp heyy_hospital_exams
* id : int(11)
* user_id : varchar(50)
* medic_id : varchar(50)
* department : varchar(50)
* name : varchar(250)
* description : text
* created_at : timestamp
* updated_at : timestamp
v coregg-sp heyy_hospital_pharmacy_stock
* id : int(11)
* department : varchar(50)
* item : varchar(50)
* amount : int(11)
* price : int(11)
* visible : tinyint(4)
v coregg-sp heyy_hospital_plasters
* id : int(11)
* user_id : varchar(50)
* medic_id : varchar(50)
* department : varchar(50)
* duration : int(11)
* body_parts : longtext
* description : text
* created_at : timestamp
* updated_at : timestamp
v coregg-sp heyy_hospital_plasters_time
* user_id : varchar(50)
* remaing_time : int(11)
v coregg-sp heyy_hospital_playerdata
* user_id : int(11)
* key : varchar(50)
* value : text
v coregg-sp heyy_hospital_schedules
* id : int(11)
* user_id : varchar(50)
* medic_id : varchar(50)
* author_id : varchar(50)
* department : varchar(50)
* reason : varchar(250)
* description : text
* status : enum('PENDING','DONE','CANCELLED','NOT_ATTENDED')
* created_at : timestamp
* scheduled_to : timestamp
* updated_at : timestamp
v coregg-sp heyy_hospital_settings
* user_id : varchar(50)
* settings : text
v coregg-sp heyy_hospital_transactions
* id : int(11)
* department : varchar(50)
* user_id : varchar(15)
* type : varchar(20)
* amount : int(11)
* description : varchar(50)
* created_at : timestamp
v coregg-sp heyy_hospital_warnings
* id : int(11)
* content : text
* author_id : varchar(50)
* department : varchar(50)
* created_at : timestamp
v coregg-sp heyy_houses_bookmarks
* userID : int(11)
* label : varchar(50)
v coregg-sp heyy_houses_presets
* userID : int(11)
* name : varchar(50)
* clothes : longtext
v coregg-sp heyy_houses_propertys
* id : int(11)
* label : varchar(50)
* internalID : int(11)
* interior : varchar(50)
* interiorColor : varchar(50)
* userID : int(11)
* expiresAt : timestamp
* chestLevel : int(11)
* permissions : longtext
* unlocked : tinyint(4)
* garageCoords : longtext
* garageIdentifier : varchar(50)
v coregg-sp heyy_houses_settings
* userID : int(11)
* settings : text
v coregg-sp heyy_mdt_avatars
* userID : varchar(11)
* url : text
v coregg-sp heyy_mdt_duty
* id : int(11)
* userID : varchar(11)
* startedAt : timestamp
* closedAt : timestamp
* open : tinyint(1)
v coregg-sp heyy_mdt_history
* id : int(11)
* officerID : longtext
* suspectID : varchar(11)
* arrestTime : int(11)
* finesValue : int(11)
* infractions : text
* description : text
* appliedAt : timestamp
v coregg-sp heyy_mdt_incidents
* id : int(11)
* officerID : varchar(11)
* requesterID : longtext
* suspectIDs : text
* title : text
* description : text
* createdAt : timestamp
* updatedAt : timestamp
* open : tinyint(1)
v coregg-sp heyy_mdt_settings
* userID : varchar(11)
* settings : text
v coregg-sp heyy_mdt_wanted
* userID : varchar(11)
* officerID : varchar(11)
* reason : text
* startedAt : timestamp
v coregg-sp heyy_mdt_wanted_vehicles
* ownerID : varchar(11)
* model : varchar(50)
* plate : varchar(15)
* officerID : varchar(11)
* reason : text
* startedAt : timestamp
v coregg-sp heyy_mdt_warnings
* id : int(11)
* authorID : varchar(11)
* message : text
* deleted : tinyint(4)
* createdAt : timestamp
v coregg-sp houses
* id : int(11)
* casa : varchar(50)
* dono : tinyint(4)
* permissao : char(50)
* time : varchar(50)
* dias : int(11)
v coregg-sp investments
* id : int(11)
* Passport : int(10)
* Liquid : int(20)
* Monthly : int(20)
* Deposit : int(20)
* Last : int(20)
v coregg-sp ox_doorlock
* id : int(11) unsigned
* name : varchar(50)
* data : longtext
v coregg-sp playerdata
* Passport : int(11)
* dkey : varchar(100)
* dvalue : longtext
v coregg-sp races
* id : int(11)
* Race : int(3)
* Passport : int(5)
* Name : varchar(100)
* Vehicle : varchar(50)
* Points : int(20)
v coregg-sp relationship
* Passport : int(11)
* status : int(11)
* OtherPassport : int(11)
v coregg-sp smartphone_bank_invoices
* id : bigint(20)
* payee_id : int(11)
* payer_id : int(11)
* reason : varchar(255)
* value : int(11)
* paid : tinyint(4)
* created_at : int(11)
* updated_at : int(11)
v coregg-sp smartphone_blocks
* user_id : int(11)
* phone : varchar(32)
v coregg-sp smartphone_calls
* id : bigint(20)
* initiator : varchar(50)
* target : varchar(50)
* duration : int(11)
* status : varchar(255)
* video : tinyint(4)
* anonymous : tinyint(4)
* created_at : bigint(20)
v coregg-sp smartphone_casino
* user_id : int(11)
* balance : bigint(20)
* double : bigint(20)
* crash : bigint(20)
* mine : bigint(20)
v coregg-sp smartphone_contacts
* id : bigint(20)
* owner : varchar(50)
* phone : varchar(255)
* name : varchar(255)
v coregg-sp smartphone_ifood_orders
* id : varchar(10)
* user_id : int(11)
* worker_id : int(11)
* store_id : int(11)
* total : int(11)
* fee : int(11)
* rate : tinyint(4)
* created_at : int(11)
v coregg-sp smartphone_instagram
* id : bigint(20)
* user_id : int(11)
* username : varchar(255)
* name : varchar(255)
* bio : varchar(255)
* avatarURL : varchar(255)
* verified : tinyint(4)
v coregg-sp smartphone_instagram_followers
* follower_id : bigint(20)
* profile_id : bigint(20)
v coregg-sp smartphone_instagram_likes
* post_id : bigint(20)
* profile_id : bigint(20)
v coregg-sp smartphone_instagram_notifications
* id : bigint(20)
* profile_id : int(11)
* author_id : int(11)
* content : varchar(512)
* saw : tinyint(4)
* created_at : int(11)
v coregg-sp smartphone_instagram_posts
* id : bigint(20)
* profile_id : bigint(20)
* post_id : bigint(20)
* image : varchar(255)
* content : varchar(255)
* created_at : bigint(20)
v coregg-sp smartphone_olx
* id : bigint(20)
* user_id : int(11)
* title : varchar(255)
* category : varchar(255)
* price : int(11)
* description : varchar(1024)
* images : varchar(1024)
* created_at : bigint(20)
v coregg-sp smartphone_paypal_transactions
* id : bigint(20)
* user_id : bigint(20)
* target : bigint(20)
* type : varchar(255)
* description : varchar(255)
* value : bigint(20)
* created_at : bigint(20)
v coregg-sp smartphone_tinder
* id : bigint(20)
* user_id : int(11)
* name : varchar(255)
* image : varchar(255)
* bio : varchar(1024)
* age : tinyint(4)
* gender : varchar(50)
* show_gender : tinyint(4)
* tags : varchar(255)
* show_tags : tinyint(4)
* target : varchar(100)
v coregg-sp smartphone_tinder_messages
* id : bigint(20)
* sender : int(11)
* target : int(11)
* content : varchar(255)
* liked : tinyint(4)
* created_at : bigint(20)
v coregg-sp smartphone_tinder_rating
* profile_id : int(11)
* rated_id : int(11)
* rating : tinyint(4)
v coregg-sp smartphone_tor_messages
* id : bigint(20)
* channel : varchar(24)
* sender : varchar(50)
* image : varchar(512)
* location : varchar(255)
* content : varchar(500)
* created_at : bigint(20)
v coregg-sp smartphone_tor_payments
* id : bigint(20)
* sender : bigint(20)
* target : bigint(20)
* amount : int(11)
* created_at : bigint(20)
v coregg-sp smartphone_twitter_followers
* follower_id : bigint(20)
* profile_id : bigint(20)
v coregg-sp smartphone_twitter_likes
* tweet_id : bigint(20)
* profile_id : bigint(20)
v coregg-sp smartphone_twitter_profiles
* id : bigint(20)
* user_id : int(11)
* name : varchar(255)
* username : varchar(255)
* avatarURL : varchar(255)
* bannerURL : varchar(255)
* bio : varchar(255)
* verified : tinyint(4)
v coregg-sp smartphone_twitter_tweets
* id : bigint(20)
* profile_id : int(11)
* tweet_id : bigint(20)
* content : varchar(280)
* image : varchar(255)
* created_at : int(11)
v coregg-sp smartphone_uber_trips
* id : varchar(10)
* user_id : int(11)
* driver_id : int(11)
* total : int(11)
* from : varchar(255)
* to : varchar(255)
* user_rate : tinyint(4)
* driver_rate : tinyint(4)
* created_at : int(11)
* finished_at : int(11)
v coregg-sp smartphone_weazel
* id : bigint(20)
* user_id : int(11)
* author : varchar(255)
* tag : varchar(255)
* title : varchar(255)
* description : varchar(4096)
* imageURL : varchar(255)
* videoURL : varchar(255)
* views : int(11)
* created_at : int(11)
v coregg-sp smartphone_whatsapp
* owner : varchar(32)
* avatarURL : varchar(255)
* read_receipts : tinyint(4)
v coregg-sp smartphone_whatsapp_channels
* id : bigint(20)
* sender : varchar(50)
* target : varchar(50)
v coregg-sp smartphone_whatsapp_groups
* id : bigint(20)
* name : varchar(255)
* avatarURL : varchar(255)
* owner : varchar(255)
* members : varchar(1200)
* created_at : bigint(20)
v coregg-sp smartphone_whatsapp_messages
* id : bigint(20)
* channel_id : bigint(20) unsigned
* sender : varchar(50)
* image : varchar(512)
* location : varchar(255)
* content : varchar(500)
* deleted_by : varchar(255)
* readed : tinyint(4)
* saw_at : bigint(20)
* created_at : bigint(20)
v coregg-sp taxs
* id : int(11)
* Passport : int(10)
* Name : varchar(50)
* Date : varchar(50)
* Hour : varchar(50)
* Value : int(11)
* Message : longtext
v coregg-sp tokens
* token : varchar(250)
* steam : varchar(50)
* banned : tinyint(1)
v coregg-sp transactions
* id : int(11)
* Passport : int(10)
* Type : varchar(50)
* Date : varchar(50)
* Value : int(11)
* Balance : int(11)
* Timeset : int(20)
v coregg-sp vehicles
* id : int(11)
* Passport : int(11)
* vehicle : varchar(100)
* tax : int(20)
* plate : varchar(10)
* rental : int(20)
* arrest : int(20)
* dismantle : int(20)
* engine : int(4)
* body : int(4)
* health : int(4)
* fuel : int(3)
* nitro : int(5)
* work : varchar(5)
* mode : varchar(9)
* doors : longtext
* windows : longtext
* tyres : longtext
* brakes : longtext
* mods : longtext
* drift : tinyint(1)
* removed : int(11)
* conce : int(20)
* alugado : tinyint(1)
v coregg-sp warehouse
* id : int(20)
* Name : varchar(50)
* Weight : int(20)
* Password : varchar(50)
* Passport : int(10)
* Tax : int(20)
v coregg-sp zo_attachs
* user_id : int(11)
* attachs : text
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship