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 lossantos apartments
* id : int(11)
* name : varchar(255)
* type : varchar(255)
* label : varchar(255)
* citizenid : varchar(255)
v lossantos bank_accounts
* record_id : bigint(255)
* citizenid : varchar(250)
* business : varchar(50)
* businessid : int(11)
* gangid : varchar(50)
* amount : bigint(255)
* account_type : enum('Current','Savings','business','Gang')
v lossantos bank_cards
* record_id : bigint(255)
* citizenid : varchar(50)
* cardNumber : varchar(50)
* cardPin : varchar(50)
* cardActive : tinyint(4)
* cardLocked : tinyint(4)
* cardType : varchar(50)
v lossantos bank_statements
* record_id : bigint(255)
* citizenid : varchar(50)
* account : varchar(50)
* business : varchar(50)
* businessid : int(11)
* gangid : varchar(50)
* deposited : int(11)
* withdraw : int(11)
* balance : int(11)
* date : varchar(50)
* type : varchar(255)
v lossantos 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 lossantos boombox
* id : int(11)
* owner : varchar(46)
* songname : varchar(500)
* author : varchar(500)
* imageurl : text
* songurl : text
v lossantos cameras
* cid : varchar(50)
* cameradata : longtext
* camID : int(11)
v lossantos carmileages
* plate : text
* mileage : text
v lossantos codem-hud-data
* identifier : varchar(65)
* data : longtext
* stress : int(11)
v lossantos core_skills
* id : int(11)
* citizenid : varchar(50)
* skill_name : varchar(100)
* value1 : varchar(50)
* value2 : varchar(50)
* value3 : varchar(50)
v lossantos crypto
* crypto : varchar(50)
* worth : int(11)
* history : text
v lossantos crypto_transactions
* id : int(11)
* citizenid : varchar(50)
* title : varchar(50)
* message : varchar(50)
* date : timestamp
v lossantos dealers
* id : int(11)
* name : varchar(50)
* coords : longtext
* time : longtext
* createdby : varchar(50)
v lossantos debux_recentpost
* id : int(11)
* time : varchar(50)
* text : varchar(500)
v lossantos ds_blipcreator
* id : int(11) unsigned
* name : varchar(50)
* data : longtext
v lossantos fuel_stations
* location : int(11)
* owned : int(11)
* owner : varchar(50)
* fuel : int(11)
* fuelprice : int(11)
* balance : int(255)
* label : varchar(255)
v lossantos gammy_scrapyard
* id : varchar(50)
* cooldown : bigint(20)
* timestamp : bigint(20)
v lossantos gloveboxitems
* id : int(11)
* plate : varchar(255)
* items : longtext
v lossantos houselocations
* id : int(11)
* name : varchar(255)
* label : varchar(255)
* coords : text
* owned : tinyint(1)
* price : int(11)
* tier : tinyint(4)
* garage : text
v lossantos house_plants
* id : int(11)
* building : varchar(50)
* stage : varchar(50)
* sort : varchar(50)
* gender : varchar(50)
* food : int(11)
* health : int(11)
* progress : int(11)
* coords : text
* plantid : varchar(50)
v lossantos lapraces
* id : int(11)
* name : varchar(50)
* checkpoints : text
* records : text
* creator : varchar(50)
* distance : int(11)
* raceid : varchar(50)
v lossantos licenses
* id : int(11)
* type : varchar(255)
* label : varchar(255)
v lossantos management_funds
* id : int(11)
* job_name : varchar(50)
* amount : int(100)
* type : enum('boss','gang')
v lossantos marketplace
* id : int(11)
* name : longtext
* normal : longtext
* auction : longtext
v lossantos marketplace_sellers
* id : int(11)
* identifier : longtext
* totalsold : int(11)
* earnings : longtext
v lossantos mdt_bolos
* id : int(11)
* author : varchar(50)
* title : varchar(50)
* plate : varchar(50)
* owner : varchar(50)
* individual : varchar(50)
* detail : text
* tags : text
* gallery : text
* officersinvolved : text
* time : varchar(20)
* jobtype : varchar(25)
v lossantos mdt_bulletin
* id : int(11)
* title : text
* desc : text
* author : varchar(50)
* time : varchar(20)
* jobtype : varchar(25)
v lossantos mdt_clocking
* id : int(10)
* user_id : varchar(50)
* firstname : varchar(255)
* lastname : varchar(255)
* clock_in_time : varchar(255)
* clock_out_time : varchar(50)
* total_time : int(10)
v lossantos mdt_convictions
* id : int(11)
* cid : varchar(50)
* linkedincident : int(11)
* warrant : varchar(50)
* guilty : varchar(50)
* processed : varchar(50)
* associated : varchar(50)
* charges : text
* fine : int(11)
* sentence : int(11)
* recfine : int(11)
* recsentence : int(11)
* time : varchar(20)
v lossantos mdt_data
* id : int(11)
* cid : varchar(20)
* information : mediumtext
* tags : text
* gallery : text
* jobtype : varchar(25)
* pfp : text
* fingerprint : varchar(50)
v lossantos mdt_impound
* id : int(11)
* vehicleid : int(11)
* linkedreport : int(11)
* fee : int(11)
* time : varchar(255)
v lossantos mdt_incidents
* id : int(11)
* author : varchar(50)
* title : varchar(50)
* details : text
* tags : text
* officersinvolved : text
* civsinvolved : text
* evidence : text
* time : varchar(20)
* jobtype : varchar(25)
v lossantos mdt_logs
* id : int(11)
* text : text
* time : varchar(20)
* jobtype : varchar(25)
v lossantos mdt_reports
* id : int(11)
* author : varchar(50)
* title : varchar(255)
* type : varchar(50)
* details : text
* tags : text
* officersinvolved : text
* civsinvolved : text
* gallery : text
* time : varchar(20)
* jobtype : varchar(25)
v lossantos mdt_vehicleinfo
* id : int(11)
* plate : varchar(50)
* information : text
* stolen : tinyint(1)
* code5 : tinyint(1)
* image : text
* points : int(11)
v lossantos mdt_weaponinfo
* id : int(11)
* serial : varchar(50)
* owner : varchar(50)
* information : text
* weapClass : varchar(50)
* weapModel : varchar(50)
* image : varchar(255)
v lossantos 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 lossantos okokbanking_societies
* society : varchar(255)
* society_name : varchar(255)
* value : int(50)
* iban : varchar(255)
* is_withdrawing : int(1)
v lossantos okokbanking_transactions
* id : int(11)
* receiver_identifier : varchar(255)
* receiver_name : varchar(255)
* sender_identifier : varchar(255)
* sender_name : varchar(255)
* date : varchar(255)
* value : int(50)
* type : varchar(255)
v lossantos okokbilling
* id : int(50)
* receiver_identifier : varchar(255)
* receiver_name : varchar(255)
* author_identifier : varchar(255)
* author_name : varchar(255)
* society : varchar(255)
* society_name : varchar(255)
* item : varchar(255)
* invoice_value : int(50)
* status : varchar(50)
* notes : varchar(255)
* sent_date : varchar(255)
* limit_pay_date : varchar(255)
* fees_amount : int(50)
* paid_date : varchar(255)
v lossantos okokreports
* admin_identifier : varchar(255)
* responded_reports : varchar(255)
v lossantos pa_vehicleshop_showroom_vehicles
* id : int(11)
* dealershipId : int(11)
* data : longtext
v lossantos pa_vehicleshop_stocks
* id : int(11)
* dealershipId : int(11)
* data : longtext
v lossantos phone_chatrooms
* id : int(10) unsigned
* room_code : varchar(10)
* room_name : varchar(15)
* room_owner_id : varchar(20)
* room_owner_name : varchar(60)
* room_members : text
* room_pin : varchar(50)
* unpaid_balance : decimal(10,2)
* is_pinned : tinyint(1)
* created : datetime
v lossantos phone_chatroom_messages
* id : int(10) unsigned
* room_id : int(10) unsigned
* member_id : varchar(20)
* member_name : varchar(50)
* message : text
* is_pinned : tinyint(1)
* created : datetime
v lossantos phone_invoices
* id : int(10)
* citizenid : varchar(50)
* amount : int(11)
* society : tinytext
* sender : varchar(50)
* sendercitizenid : varchar(50)
* time : int(11)
v lossantos phone_messages
* id : int(11)
* citizenid : varchar(50)
* number : varchar(50)
* messages : text
* time : int(11)
v lossantos phone_note
* id : int(10)
* citizenid : varchar(50)
* title : text
* text : text
* lastupdate : varchar(50)
v lossantos phone_tweets
* id : int(11)
* citizenid : varchar(50)
* firstName : varchar(25)
* lastName : varchar(25)
* type : varchar(25)
* message : text
* url : text
* tweetId : varchar(25)
* date : datetime
v lossantos players
* id : int(11)
* citizenid : varchar(50)
* 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
* dnzv3 : int(11)
* dnzv3_active : int(11)
* dnzv3_timeblock : int(11)
* iban : varchar(255)
* pincode : int(50)
* tattoos : longtext
* crafting_level : tinyint(4)
* crafting_xp : smallint(6)
* credits : int(11)
* tasks : longtext
* tasks_completed : longtext
* winnings : longtext
* ownedskills : longtext
* skillsinfo : longtext
* frkn_craftxp : int(11)
* frkn_craftlevel : int(11)
v lossantos playerskins
* id : int(11)
* citizenid : varchar(255)
* model : varchar(255)
* skin : text
* active : tinyint(2)
v lossantos player_contacts
* id : int(11)
* citizenid : varchar(50)
* name : varchar(50)
* number : varchar(50)
v lossantos player_emotes
* id : int(11)
* player_id : varchar(50)
* emote_category : varchar(255)
* emote_index : int(11)
* emote_type : varchar(255)
* emote_value : varchar(255)
v lossantos player_houses
* id : int(255)
* house : varchar(50)
* identifier : varchar(50)
* citizenid : varchar(50)
* keyholders : text
* decorations : text
* stash : text
* outfit : text
* logout : text
v lossantos player_jobs
* id : int(11)
* jobname : varchar(50)
* employees : text
* maxEmployee : tinyint(11)
v lossantos player_mails
* id : int(11)
* citizenid : varchar(50)
* sender : varchar(50)
* subject : varchar(50)
* message : text
* read : tinyint(4)
* mailid : int(11)
* date : timestamp
* button : text
v lossantos player_outfits
* id : int(11)
* citizenid : varchar(50)
* outfitname : varchar(50)
* model : varchar(50)
* skin : text
* outfitId : varchar(50)
v lossantos player_vehicles
* id : int(11)
* license : varchar(50)
* citizenid : varchar(50)
* vehicle : varchar(50)
* hash : varchar(50)
* mods : longtext
* plate : varchar(50)
* fakeplate : varchar(50)
* 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)
* nosColour : text
* traveldistance : int(50)
* noslevel : int(10)
* hasnitro : tinyint(4)
* stored : tinyint(4)
* parking : varchar(60)
* favorite : varchar(60)
* logs : longtext
v lossantos player_warns
* id : int(11)
* senderIdentifier : varchar(50)
* targetIdentifier : varchar(50)
* reason : text
* warnId : varchar(50)
v lossantos properties
* property_id : int(11)
* owner_citizenid : varchar(50)
* street : varchar(100)
* region : varchar(100)
* description : longtext
* has_access : longtext
* extra_imgs : longtext
* furnitures : longtext
* for_sale : tinyint(1)
* price : int(11)
* shell : varchar(50)
* apartment : varchar(50)
* door_data : longtext
* garage_data : longtext
v lossantos punchmachine
* id : int(11)
* name : varchar(50)
* score : varchar(50)
v lossantos sprays
* id : int(11)
* x : float(8,4)
* y : float(8,4)
* z : float(8,4)
* rx : float(8,4)
* ry : float(8,4)
* rz : float(8,4)
* scale : float(8,4)
* text : varchar(32)
* font : varchar(32)
* color : int(3)
* interior : int(3)
* created_at : timestamp
v lossantos stashitems
* id : int(11)
* stash : varchar(255)
* items : longtext
v lossantos trunkitems
* id : int(11)
* plate : varchar(255)
* items : longtext
v lossantos user_licenses
* id : int(11)
* type : varchar(255)
* owner : varchar(255)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship