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 enchanted accounts
* id : bigint(20)
* Whitelist : tinyint(1)
* Characters : int(10)
* Gemstone : int(20)
* Banned : int(20)
* Reason : varchar(254)
* License : varchar(50)
* Discord : varchar(50)
* Login : int(20)
* Token : varchar(10)
v enchanted avatars
* id : int(10) unsigned
* Passport : int(11)
* Image : longtext
* Permission : varchar(64)
* created_at : timestamp
* updated_at : timestamp
v enchanted bancoes_accounts
* id : int(10) unsigned
* user_id : varchar(64)
* name : varchar(120)
* passport : varchar(64)
* bank : varchar(64)
* agency : varchar(10)
* account_number : varchar(24)
* pix_key : varchar(100)
* created_at : datetime
v enchanted bancoes_cards
* id : int(10) unsigned
* user_id : varchar(64)
* type : enum('debito','credito')
* number_last4 : char(4)
* expiry : char(5)
* credit_limit : decimal(10,2)
* available : decimal(10,2)
* active : tinyint(1)
* blocked : tinyint(1)
* created_at : datetime
v enchanted bancoes_transactions
* id : bigint(20) unsigned
* user_id : varchar(64)
* type : enum('entrada','saida')
* method : enum('pix','transferencia','pagamento','debito','credito','saque','deposito','multa','taxa','fatura')
* title : varchar(120)
* description : varchar(255)
* amount : decimal(12,2) unsigned
* balance_after : decimal(12,2)
* target_user_id : varchar(64)
* created_at : datetime
v enchanted bank_accounts
* id : int(11)
* passport : int(11)
* account_number : varchar(16)
* pin_hash : bigint(20)
* status : enum('ACTIVE','CLOSED')
* created_at : bigint(20)
* updated_at : bigint(20)
v enchanted bank_business_accounts
* id : int(11)
* business : varchar(64)
* account_number : varchar(16)
* balance : bigint(20)
* created_at : bigint(20)
* updated_at : bigint(20)
v enchanted bank_business_roles
* id : int(11)
* business : varchar(64)
* passport : int(11)
* role : enum('OWNER','ADMIN','CASHIER')
* created_at : bigint(20)
* updated_at : bigint(20)
v enchanted bank_cards
* id : int(11)
* passport : int(11)
* card_last4 : varchar(4)
* limit_total : int(11)
* limit_used : int(11)
* close_day : tinyint(4)
* due_day : tinyint(4)
* score : int(11)
* blocked_until : bigint(20)
* created_at : bigint(20)
v enchanted bank_card_installments
* id : int(11)
* passport : int(11)
* principal : int(11)
* months : int(11)
* monthly_interest_bp : int(11)
* remaining_months : int(11)
* principal_remaining : int(11)
* monthly_principal : int(11)
* next_due_at : bigint(20)
* status : enum('ACTIVE','FINISHED','CANCELED')
* created_at : bigint(20)
v enchanted bank_card_invoices
* id : int(11)
* passport : int(11)
* cycle_year : int(11)
* cycle_month : int(11)
* status : enum('OPEN','CLOSED','PAID','OVERDUE','INSTALLMENT')
* close_at : bigint(20)
* due_at : bigint(20)
* total : int(11)
* paid : int(11)
* min_payment : int(11)
* interest_added : int(11)
* last_interest_at : bigint(20)
* late_fee_applied : tinyint(4)
* created_at : bigint(20)
v enchanted bank_card_tx
* id : int(11)
* passport : int(11)
* invoice_id : int(11)
* kind : enum('PURCHASE','FEE','PAYMENT','REVERSAL')
* description : varchar(64)
* amount : int(11)
* created_at : bigint(20)
v enchanted bank_ledger
* id : int(11)
* passport : int(11)
* direction : enum('IN','OUT')
* amount : bigint(20)
* label : varchar(64)
* category : varchar(32)
* meta : longtext
* created_at : bigint(20)
v enchanted bank_loans
* id : int(11)
* passport : int(11)
* principal : bigint(20)
* months : int(11)
* interest_bp : int(11)
* monthly_amount : bigint(20)
* remaining_months : int(11)
* next_due_at : bigint(20)
* status : enum('ACTIVE','FINISHED','DEFAULTED','CANCELED')
* created_at : bigint(20)
* updated_at : bigint(20)
* last_payment_at : bigint(20)
v enchanted bank_physical_cards
* id : int(11)
* passport : int(11)
* card_uid : varchar(32)
* issued : tinyint(4)
* issued_at : bigint(20)
* created_at : bigint(20)
v enchanted bank_savings
* passport : int(11)
* balance : bigint(20)
* last_yield_at : bigint(20)
* last_deposit_at : bigint(20)
* created_at : bigint(20)
* updated_at : bigint(20)
v enchanted characters
* id : bigint(20)
* Name : varchar(50)
* Lastname : varchar(50)
* Sex : varchar(1)
* Phone : varchar(10)
* Bank : int(20)
* Blood : int(1)
* Prison : int(10)
* Medic : int(20)
* Groups : int(20)
* Skin : varchar(50)
* Killed : int(9)
* Death : int(9)
* Playing : int(9)
* Daily : varchar(10)
* DailyReward : int(3)
* License : varchar(50)
* Avatar : varchar(255)
* Created : int(20)
* Login : int(20)
* Deleted : int(1)
* paypal : int(11)
v enchanted chests
* id : bigint(20)
* Name : varchar(50)
* Weight : int(10)
* Slots : int(20)
* Permission : varchar(50)
* Logs : tinyint(1)
v enchanted dependents
* id : bigint(20)
* Passport : int(10)
* Dependent : int(10)
* Name : varchar(50)
v enchanted entitydata
* Name : varchar(100)
* Information : longtext
v enchanted esrp_phone_emergency_calls
* id : int(11)
* passport : int(11)
* name : varchar(120)
* phone : varchar(40)
* service : varchar(40)
* type : varchar(80)
* message : text
* street : varchar(160)
* x : double
* y : double
* z : double
* anonymous : tinyint(1)
* status : varchar(30)
* created_at : timestamp
* urgency : varchar(40)
* attachment : text
* assigned_passport : int(11)
* assigned_name : varchar(120)
* closed_at : timestamp
v enchanted fines
* id : bigint(20)
* Passport : int(10)
* Name : varchar(50)
* Date : varchar(50)
* Hour : varchar(50)
* Price : int(20)
* Message : longtext
v enchanted hwid
* id : bigint(20)
* Account : int(10)
* Token : varchar(250)
* Banned : tinyint(1)
v enchanted investments
* id : int(20)
* Passport : int(10)
* Liquid : int(20)
* Monthly : int(20)
* Deposit : int(20)
* Last : int(20)
v enchanted invoices
* id : int(20)
* Passport : int(10)
* Received : int(10)
* Type : varchar(50)
* Reason : longtext
* Holder : varchar(50)
* Price : int(20)
v enchanted jeffresources
* conheceu : varchar(50)
v enchanted jeff_presets
* user_id : int(11)
* vehicle_name : varchar(100)
* preset_name : varchar(100)
* props : longtext
v enchanted ks_bankapp
* id : bigint(20)
* user_id : bigint(20)
* text : varchar(255)
* type : varchar(255)
* valor : varchar(255)
* data : varchar(255)
v enchanted ks_bankappfaturas
* id : bigint(20)
* user_id : bigint(20)
* nuser_id : bigint(20)
* type : varchar(255)
* valor : varchar(255)
* data : varchar(255)
v enchanted mdt_creative_arrest
* id : bigint(19)
* Passport : bigint(19)
* Officer : bigint(19)
* Officers : longtext
* Timestamp : bigint(19)
* Infractions : longtext
* Arrest : bigint(19)
* Fine : bigint(19)
* Description : longtext
* permission : varchar(100)
v enchanted mdt_creative_arrest_records
* id : int(11)
* TargetPassport : int(11)
* OfficerPassport : int(11)
* Reason : text
* Date : int(11)
* permission : varchar(100)
v enchanted mdt_creative_board
* id : bigint(19)
* Title : varchar(100)
* Description : longtext
* Permission : varchar(100)
v enchanted mdt_creative_crimes
* id : int(11)
* Passport : int(11)
* Crime : text
* Date : int(11)
* Officer : int(11)
* permission : varchar(100)
v enchanted mdt_creative_criminal_records
* id : int(11)
* TargetPassport : int(11)
* Crimes : text
* Fine : int(11)
* Sentence : int(11)
* Notes : text
* OfficerPassport : int(11)
* OfficerName : varchar(100)
* Date : int(11)
* Permission : varchar(100)
v enchanted mdt_creative_fines
* id : bigint(19)
* Passport : bigint(19)
* Officer : bigint(19)
* Timestamp : bigint(19)
* Infractions : longtext
* Fine : bigint(19)
* Description : longtext
* Paid : tinyint(1)
* Arrest : bigint(19)
* Date : varchar(10)
* Hour : varchar(10)
v enchanted mdt_creative_firearms
* id : int(11)
* Passport : int(11)
* Weapon : varchar(100)
* Serial : varchar(100)
* Date : int(11)
* Officer : int(11)
* permission : varchar(100)
v enchanted mdt_creative_medals
* id : bigint(19)
* Image : text
* Name : varchar(150)
* Officers : longtext
v enchanted mdt_creative_medals_users
* id : int(11)
* Passport : int(11)
* MedalId : int(11)
* Date : int(11)
v enchanted mdt_creative_patrols
* id : int(11)
* permission : varchar(100)
* car : varchar(100)
* unit : varchar(100)
* officers : text
* start_time : int(11)
* status : varchar(20)
v enchanted mdt_creative_penalcode_articles
* id : bigint(19)
* Section : bigint(19)
* Article : varchar(250)
* Contravention : varchar(250)
* Fine : bigint(19)
* Arrest : bigint(19)
* Bail : bigint(19)
* Order : int(10)
v enchanted mdt_creative_penalcode_sections
* id : bigint(19)
* Type : varchar(10)
* Title : varchar(100)
* Description : longtext
* Order : int(10)
v enchanted mdt_creative_penal_codes
* Id : int(11)
* Title : varchar(255)
* Description : text
* Penalty : varchar(255)
* Mode : varchar(50)
v enchanted mdt_creative_reports
* id : bigint(19)
* Passport : bigint(19)
* Title : text
* Suspects : longtext
* Officer : bigint(19)
* Timestamp : bigint(19)
* Description : longtext
* Archive : tinyint(1)
* permission : varchar(100)
v enchanted mdt_creative_units
* id : bigint(19)
* Image : text
* Name : varchar(150)
* Permission : varchar(100)
* Officers : longtext
v enchanted mdt_creative_vehicles
* id : bigint(19)
* Passport : bigint(19)
* Officer : bigint(19)
* Image : text
* Vehicle : varchar(100)
* Plate : varchar(10)
* Location : varchar(100)
* Timestamp : bigint(19)
* Description : longtext
v enchanted mdt_creative_wanted
* id : bigint(19)
* Passport : bigint(19)
* Image : text
* Accusations : longtext
* Officer : bigint(19)
* Timestamp : bigint(19)
* HowLong : int(5)
* Description : longtext
* permission : varchar(100)
v enchanted mdt_creative_warning
* id : bigint(19)
* Passport : bigint(19)
* Officer : bigint(19)
* Timestamp : bigint(19)
* Description : longtext
v enchanted mdt_creative_warnings
* id : int(11)
* officer_passport : int(11)
* target_passport : int(11)
* reason : text
* date : int(11)
* permission : varchar(100)
v enchanted mdt_creative_warrants
* id : int(11)
* Officer : int(11)
* Passport : int(11)
* reason : text
* date : int(11)
* permission : varchar(100)
v enchanted mdt_reports
* id : int(11)
* officer_passport : int(11)
* title : varchar(255)
* content : text
* date : int(11)
* permission : varchar(100)
v enchanted mensagens_es_blocks
* id : int(11)
* blocker_number : varchar(32)
* blocked_number : varchar(32)
* created_at : timestamp
v enchanted mensagens_es_calls
* id : int(11)
* caller_number : varchar(32)
* receiver_number : varchar(32)
* call_type : enum('voice','video')
* status : enum('missed','answered','declined','outgoing','incoming')
* started_at : timestamp
* ended_at : timestamp
* duration_seconds : int(11)
v enchanted mensagens_es_conversations
* id : int(11)
* type : enum('private','group')
* title : varchar(80)
* avatar : text
* created_by : varchar(64)
* created_at : timestamp
* updated_at : timestamp
v enchanted mensagens_es_messages
* id : int(11)
* conversation_id : int(11)
* sender_number : varchar(32)
* message_type : enum('text','image','audio','location','document','contact','poll','system')
* body : text
* metadata : longtext
* reply_to : int(11)
* forwarded : tinyint(1)
* created_at : timestamp
* edited_at : timestamp
* deleted_at : timestamp
* deleted_for_everyone : tinyint(1)
v enchanted mensagens_es_participants
* id : int(11)
* conversation_id : int(11)
* phone_number : varchar(32)
* display_name : varchar(80)
* is_admin : tinyint(1)
* muted : tinyint(1)
* archived : tinyint(1)
* pinned : tinyint(1)
* deleted_at : timestamp
* joined_at : timestamp
* last_read_message_id : int(11)
v enchanted mensagens_es_reads
* id : int(11)
* message_id : int(11)
* phone_number : varchar(32)
* delivered_at : timestamp
* read_at : timestamp
v enchanted mensagens_es_settings
* id : int(11)
* phone_number : varchar(32)
* display_name : varchar(80)
* avatar : text
* status_message : varchar(140)
* read_receipts : tinyint(1)
* last_seen_enabled : tinyint(1)
* notifications_enabled : tinyint(1)
* theme : varchar(20)
* updated_at : timestamp
v enchanted mensagens_es_starred
* id : int(11)
* message_id : int(11)
* phone_number : varchar(32)
* created_at : timestamp
v enchanted mensagens_es_status
* id : int(11)
* phone_number : varchar(32)
* status_type : enum('text','image')
* content : text
* background_color : varchar(20)
* text_color : varchar(20)
* font_size : int(11)
* metadata : longtext
* expires_at : timestamp
* created_at : timestamp
v enchanted mensagens_es_status_views
* id : int(11)
* status_id : int(11)
* viewer_number : varchar(32)
* viewed_at : timestamp
v enchanted painel_creative_announcements
* Id : bigint(19)
* Title : text
* Description : longtext
* Date : bigint(19)
* Updated : bigint(19)
* Permission : varchar(100)
v enchanted painel_creative_tags
* Id : bigint(19)
* Image : text
* Name : varchar(150)
* Members : longtext
* Permission : varchar(100)
v enchanted painel_creative_transactions
* Id : bigint(19)
* Type : varchar(50)
* Passport : bigint(19)
* Value : bigint(19)
* Date : bigint(19)
* Transfer : bigint(19)
* Permission : varchar(100)
v enchanted permissions
* id : bigint(19)
* Permission : varchar(100)
* Members : int(10)
* Bank : bigint(19)
v enchanted phone_backups
* id : varchar(100)
* phone_number : varchar(15)
v enchanted phone_clock_alarms
* id : int(10) unsigned
* phone_number : varchar(15)
* hours : int(2)
* minutes : int(2)
* label : varchar(50)
* enabled : tinyint(1)
v enchanted phone_crypto
* id : varchar(100)
* coin : varchar(15)
* amount : double
* invested : int(11)
v enchanted phone_crypto_coins
* coin : varchar(15)
* coin_value : double
v enchanted phone_darkchat_accounts
* phone_number : varchar(15)
* username : varchar(20)
* password : varchar(100)
v enchanted phone_darkchat_channels
* name : varchar(50)
* password : varchar(100)
v enchanted phone_darkchat_members
* channel_name : varchar(50)
* username : varchar(20)
v enchanted phone_darkchat_messages
* id : int(11)
* channel : varchar(50)
* sender : varchar(20)
* content : varchar(1000)
* timestamp : timestamp
v enchanted phone_instagram_accounts
* display_name : varchar(30)
* username : varchar(20)
* password : varchar(100)
* profile_image : varchar(500)
* bio : varchar(100)
* post_count : int(11)
* story_count : int(11)
* follower_count : int(11)
* following_count : int(11)
* phone_number : varchar(15)
* private : tinyint(1)
* verified : tinyint(1)
* date_joined : timestamp
v enchanted phone_instagram_comments
* id : varchar(10)
* post_id : varchar(50)
* username : varchar(20)
* comment : varchar(500)
* like_count : int(11)
* timestamp : timestamp
v enchanted phone_instagram_follows
* followed : varchar(20)
* follower : varchar(20)
v enchanted phone_instagram_follow_requests
* requester : varchar(20)
* requestee : varchar(20)
* timestamp : timestamp
v enchanted phone_instagram_likes
* id : varchar(10)
* username : varchar(20)
* is_comment : tinyint(1)
v enchanted phone_instagram_messages
* id : varchar(10)
* sender : varchar(20)
* recipient : varchar(20)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v enchanted phone_instagram_notifications
* id : varchar(10)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* post_id : varchar(50)
* timestamp : timestamp
v enchanted phone_instagram_posts
* id : varchar(10)
* media : text
* caption : varchar(500)
* location : varchar(50)
* like_count : int(11)
* comment_count : int(11)
* username : varchar(20)
* timestamp : timestamp
v enchanted phone_instagram_stories
* id : varchar(10)
* username : varchar(20)
* image : varchar(500)
* metadata : longtext
* timestamp : timestamp
v enchanted phone_instagram_stories_views
* story_id : varchar(50)
* viewer : varchar(20)
* timestamp : timestamp
v enchanted phone_last_phone
* id : varchar(100)
* phone_number : varchar(15)
v enchanted phone_logged_in_accounts
* phone_number : varchar(15)
* app : varchar(50)
* username : varchar(100)
* active : tinyint(1)
v enchanted phone_mail_accounts
* address : varchar(100)
* password : varchar(100)
v enchanted phone_mail_deleted
* message_id : int(10) unsigned
* address : varchar(100)
v enchanted phone_mail_messages
* id : int(10) unsigned
* recipient : varchar(100)
* sender : varchar(100)
* subject : varchar(100)
* content : text
* attachments : longtext
* actions : longtext
* read : tinyint(1)
* timestamp : timestamp
v enchanted phone_maps_locations
* id : int(10) unsigned
* phone_number : varchar(15)
* name : varchar(50)
* x_pos : float
* y_pos : float
v enchanted phone_marketplace_posts
* id : int(11)
* phone_number : varchar(15)
* title : varchar(50)
* description : varchar(1000)
* attachments : text
* price : int(11)
* timestamp : timestamp
v enchanted phone_message_channels
* id : int(11)
* is_group : tinyint(1)
* name : varchar(50)
* last_message : varchar(50)
* last_message_timestamp : timestamp
v enchanted phone_message_members
* channel_id : int(11)
* phone_number : varchar(15)
* is_owner : tinyint(1)
* deleted : tinyint(1)
* unread : int(11)
v enchanted phone_message_messages
* id : int(11)
* channel_id : int(11)
* sender : varchar(15)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v enchanted phone_music_playlists
* id : int(10) unsigned
* phone_number : varchar(15)
* name : varchar(50)
* cover : varchar(500)
v enchanted phone_music_saved_playlists
* playlist_id : int(10) unsigned
* phone_number : varchar(15)
v enchanted phone_music_songs
* song_id : varchar(100)
* playlist_id : int(10) unsigned
v enchanted phone_notes
* id : int(10) unsigned
* phone_number : varchar(15)
* title : varchar(50)
* content : longtext
* timestamp : timestamp
v enchanted phone_notifications
* id : int(11)
* phone_number : varchar(15)
* app : varchar(50)
* title : varchar(50)
* content : varchar(500)
* thumbnail : varchar(500)
* avatar : varchar(500)
* show_avatar : tinyint(1)
* custom_data : text
* timestamp : timestamp
v enchanted phone_phones
* id : varchar(100)
* owner_id : varchar(100)
* phone_number : varchar(15)
* name : varchar(50)
* pin : varchar(4)
* face_id : varchar(100)
* settings : longtext
* is_setup : tinyint(1)
* assigned : tinyint(1)
* battery : int(11)
* last_seen : timestamp
v enchanted phone_phone_blocked_numbers
* phone_number : varchar(15)
* blocked_number : varchar(15)
v enchanted phone_phone_calls
* id : int(10) unsigned
* caller : varchar(15)
* callee : varchar(15)
* duration : int(11)
* answered : tinyint(1)
* hide_caller_id : tinyint(1)
* timestamp : timestamp
v enchanted phone_phone_contacts
* contact_phone_number : varchar(15)
* firstname : varchar(50)
* lastname : varchar(50)
* profile_image : varchar(500)
* email : varchar(50)
* address : varchar(50)
* favourite : tinyint(1)
* phone_number : varchar(15)
v enchanted phone_phone_voicemail
* id : int(10) unsigned
* caller : varchar(15)
* callee : varchar(15)
* url : varchar(500)
* duration : int(11)
* hide_caller_id : tinyint(1)
* timestamp : timestamp
v enchanted phone_photos
* id : int(11)
* phone_number : varchar(15)
* is_video : tinyint(1)
* size : float
* metadata : varchar(20)
* is_favourite : tinyint(1)
* timestamp : timestamp
v enchanted phone_photo_albums
* id : int(11)
* phone_number : varchar(15)
* title : varchar(100)
* shared : tinyint(1)
v enchanted phone_photo_album_members
* album_id : int(11)
* phone_number : varchar(15)
v enchanted phone_photo_album_photos
* album_id : int(11)
* photo_id : int(11)
v enchanted phone_services_channels
* id : int(10) unsigned
* phone_number : varchar(15)
* company : varchar(50)
* last_message : varchar(100)
* timestamp : timestamp
v enchanted phone_services_messages
* id : int(10) unsigned
* channel_id : int(10) unsigned
* sender : varchar(15)
* message : varchar(1000)
* x_pos : int(11)
* y_pos : int(11)
* timestamp : timestamp
v enchanted phone_tiktok_accounts
* name : varchar(30)
* bio : varchar(100)
* avatar : varchar(500)
* username : varchar(20)
* password : varchar(100)
* verified : tinyint(1)
* follower_count : int(11)
* following_count : int(11)
* like_count : int(11)
* video_count : int(11)
* twitter : varchar(20)
* instagram : varchar(20)
* show_likes : tinyint(1)
* phone_number : varchar(15)
* date_joined : timestamp
v enchanted phone_tiktok_channels
* id : varchar(10)
* last_message : varchar(50)
* member_1 : varchar(20)
* member_2 : varchar(20)
* timestamp : timestamp
v enchanted phone_tiktok_comments
* id : varchar(10)
* reply_to : varchar(10)
* video_id : varchar(10)
* username : varchar(20)
* comment : varchar(550)
* likes : int(11)
* replies : int(11)
* timestamp : timestamp
v enchanted phone_tiktok_comments_likes
* username : varchar(20)
* comment_id : varchar(10)
v enchanted phone_tiktok_follows
* followed : varchar(20)
* follower : varchar(20)
v enchanted phone_tiktok_likes
* username : varchar(20)
* video_id : varchar(10)
v enchanted phone_tiktok_messages
* id : varchar(10)
* channel_id : varchar(10)
* sender : varchar(20)
* content : varchar(500)
* timestamp : timestamp
v enchanted phone_tiktok_notifications
* id : int(11)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* video_id : varchar(10)
* comment_id : varchar(10)
* timestamp : timestamp
v enchanted phone_tiktok_pinned_videos
* username : varchar(20)
* video_id : varchar(10)
v enchanted phone_tiktok_saves
* username : varchar(20)
* video_id : varchar(10)
v enchanted phone_tiktok_unread_messages
* username : varchar(20)
* channel_id : varchar(10)
* amount : int(11)
v enchanted phone_tiktok_videos
* id : varchar(10)
* username : varchar(20)
* src : varchar(500)
* caption : varchar(100)
* metadata : longtext
* music : text
* likes : int(11)
* comments : int(11)
* views : int(11)
* saves : int(11)
* pinned_comment : varchar(10)
* timestamp : timestamp
v enchanted phone_tiktok_views
* username : varchar(20)
* video_id : varchar(10)
v enchanted phone_tinder_accounts
* name : varchar(50)
* phone_number : varchar(15)
* photos : text
* bio : varchar(500)
* dob : date
* is_male : tinyint(1)
* interested_men : tinyint(1)
* interested_women : tinyint(1)
* active : tinyint(1)
* last_seen : datetime
v enchanted phone_tinder_matches
* phone_number_1 : varchar(15)
* phone_number_2 : varchar(15)
* latest_sender : varchar(15)
* latest_message : varchar(1000)
* latest_message_timestamp : timestamp
* phone_number_1_has_unread : tinyint(1)
* phone_number_2_has_unread : tinyint(1)
v enchanted phone_tinder_messages
* id : int(11)
* sender : varchar(15)
* recipient : varchar(15)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v enchanted phone_tinder_swipes
* swiper : varchar(15)
* swipee : varchar(15)
* liked : tinyint(1)
v enchanted phone_twitter_accounts
* display_name : varchar(30)
* username : varchar(20)
* password : varchar(100)
* phone_number : varchar(15)
* bio : varchar(100)
* profile_image : varchar(500)
* profile_header : varchar(500)
* pinned_tweet : varchar(50)
* verified : tinyint(1)
* follower_count : int(11)
* following_count : int(11)
* private : tinyint(1)
* date_joined : timestamp
v enchanted phone_twitter_follows
* followed : varchar(20)
* follower : varchar(20)
* notifications : tinyint(1)
v enchanted phone_twitter_follow_requests
* requester : varchar(20)
* requestee : varchar(20)
* timestamp : timestamp
v enchanted phone_twitter_hashtags
* hashtag : varchar(50)
* amount : int(11)
* last_used : timestamp
v enchanted phone_twitter_likes
* tweet_id : varchar(50)
* username : varchar(20)
* timestamp : timestamp
v enchanted phone_twitter_messages
* id : varchar(10)
* sender : varchar(20)
* recipient : varchar(20)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v enchanted phone_twitter_notifications
* id : varchar(10)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* tweet_id : varchar(50)
* timestamp : timestamp
v enchanted phone_twitter_promoted
* tweet_id : varchar(50)
* promotions : int(11)
* views : int(11)
v enchanted phone_twitter_retweets
* tweet_id : varchar(50)
* username : varchar(20)
* timestamp : timestamp
v enchanted phone_twitter_tweets
* id : varchar(10)
* username : varchar(20)
* content : varchar(280)
* attachments : text
* reply_to : varchar(50)
* like_count : int(11)
* reply_count : int(11)
* retweet_count : int(11)
* timestamp : timestamp
v enchanted phone_voice_memos_recordings
* id : int(11)
* phone_number : varchar(15)
* file_name : varchar(50)
* file_url : varchar(500)
* file_length : int(11)
* created_at : timestamp
v enchanted phone_wallet_transactions
* id : int(11)
* phone_number : varchar(15)
* amount : int(11)
* company : varchar(50)
* timestamp : timestamp
v enchanted phone_yellow_pages_posts
* id : int(10) unsigned
* phone_number : varchar(15)
* title : varchar(50)
* description : varchar(1000)
* attachment : varchar(500)
* price : int(11)
* timestamp : timestamp
v enchanted playerdata
* Passport : int(10)
* Name : varchar(100)
* Information : longtext
v enchanted propertys
* id : int(20)
* Name : varchar(20)
* Interior : varchar(20)
* Item : int(3)
* Tax : int(20)
* Passport : int(11)
* Serial : varchar(10)
* Vault : int(6)
* Fridge : int(6)
* Garage : longtext
v enchanted races
* id : int(20)
* Mode : int(5)
* Race : int(5)
* Passport : int(10)
* Vehicle : varchar(50)
* Points : int(20)
v enchanted taxs
* id : int(20)
* Passport : int(10)
* Name : varchar(50)
* Date : varchar(50)
* Hour : varchar(50)
* Price : int(20)
* Message : longtext
v enchanted transactions
* id : int(20)
* Passport : int(10)
* Type : varchar(50)
* Date : varchar(50)
* Price : int(20)
* Balance : int(20)
* Timeset : int(20)
v enchanted vehicles
* id : int(20)
* Passport : int(10)
* Vehicle : varchar(100)
* Tax : int(20)
* Plate : varchar(10)
* Weight : int(9)
* Save : varchar(50)
* Rental : int(20)
* Arrest : tinyint(1)
* Block : tinyint(1)
* Engine : int(4)
* Body : int(4)
* Health : int(4)
* Fuel : int(3)
* Nitro : int(5)
* Work : tinyint(1)
* Doors : longtext
* Windows : longtext
* Tyres : longtext
* Seatbelt : tinyint(1)
* Drift : tinyint(1)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship