ftautosystems.work / 127.0.0.1 / foll7069_fta

Sık kullanılan tablolar yok.

Gezinti panelinin görünümünü özelleştirir.

Gezinti paneli

Veritabanlarını gezinti ağacı olarak göster Gezinti panelindeki, veritabanı ağacını bir seçici ile değiştirir
Ana panel ile bağla Şu anki veritabanı veya tabloyu vurgulayarak ana panel ile bağlantılar.
Logoyu görüntüle Gezinti panelinde logoyu gösterir.
Logo bağlantısı URL'si Gezinti panelindeki logoyu işaret eden URL.
Logo bağlantısı hedefi Bağlantılı sayfayı ana pencerede (`main`) veya yeni bir tanede (`new`) açar.
Vurgulamaları etkinleştir Fare imleci altında sunucuyu vurgular.
İlk seviyedeki en fazla öğe Gezinti ağacının ilk seviyesindeki her sayfada görüntülenebilen öğe sayısıdır.
Süzgeç kutusunu görüntülemek için en az öğe sayısı Süzgeç kutusunu görüntülemek için en az öğe (tablolar, görünümler, yordamlar ve olaylar) sayısını tanımlar.
Son kullanılan tablolar En fazla son kullanılan tablo sayısıdır; etkisizleştirmek için 0'a ayarlayın.
Sık kullanılan tablolar En fazla sık kullanılan tablo sayısıdır; etkisizleştirmek için 0'a ayarlayın.
Gezinti paneli genişliği Gezinti panelini daraltmak için 0'a ayarlayın.

Gezinti ağacını özelleştirir.

Gezinti ağacı

Daldaki en fazla öğe Gezinti ağacının her sayfasında görüntülenebilen öğe sayısıdır.
Ağaçtaki öğeleri grupla Gezinti ağacındaki öğeleri gruplar (Veritabanları ve Tablolar sekmeleri üzerini tanımlanan ayıraç tarafından belirlenir).
Gezinti ağacı genişlemesini etkinleştir Gezinti panelinde ağaç genişleme olanağının sunulup sunulmayacağı.
Tabloları ağaçta göster Gezinti ağacındaki veritabanı altında tabloların gösterilip gösterilmeyeceği
Görünümleri ağaç içinde göster Gezinti ağacındaki veritabanı altında görünümlerin gösterilip gösterilmeyeceği
İşlevleri ağaç içinde göster Gezinti ağacındaki veritabanı altında işlevlerin gösterilip gösterilmeyeceği
Yordamları ağaç içinde göster Gezinti ağacındaki veritabanı altında yordamların gösterilip gösterilmeyeceği
Olayları ağaç içinde göster Gezinti ağacındaki veritabanı altında olayların gösterilip gösterilmeyeceği
Tek bir veritabanı genişlet Gezinti ağacındaki tek bir veritabanının otomatik olarak genişletilip genişletilmeyeceği.

Sunucuları görüntüleme seçenekleri.

Sunucular

Sunucu seçimlerini görüntüle Sunucu seçimini gezinti panelinin en üstünde görüntüler.
Sunucuları liste olarak görüntüle Sunucu listelemeyi aşağı açılır menü yerine liste olarak gösterir.

Veritabanlarını görüntüleme seçenekleri.

Veritabanları

Veritabanı süzgeci kutusunu görüntülemek için en az veritabanı sayısı
Veritabanı ağaç ayıracı Veritabanlarını farklı ağaç seviyelerine ayıran dizgidir.

Tabloları görüntüleme seçenekleri.

Tablolar

Hızlı erişim simgesi için hedef
İkinci hızlı erişim simgesi için hedef
Tablo ağacı ayıracı Tabloları farklı ağaç seviyelerine ayıran dizgidir.
En fazla tablo ağacı derinliği

Dosyaları buraya bırakın

SQL gönderme ( 0 ) x -

Bu kısmı geçmek için Javascript etkinleştirilmek zorundadır!

Sayfanın en üstüne kaydırmak için çubuğa tklayın

Sorguyu çalıştırmak için Ctrl+Enter tuşlarına basın

Daralt Genişlet İzi göster İzi gizle Aldığı süre :

Yer işaretleri yok

Etiket: Hedef veritabanı: Bu yer işaretini paylaş

Her zaman sorgu mesajlarını genişlet
Başlangıçta sorgu geçmişini göster
Şu an gözatılan sorguyu göster
Enter tuşuna basıldığında sorguları çalıştır ve Shift+Enter tuşları ile yeni satır ekle. Bunu kalıcı yapmak için ayarlara bakın.
Koyu temaya değiştir

Daralt Genişlet Yeniden sorgula Düzenle Açıkla Profil çıkart Yer işareti Sorgu başarısız oldu Database : Sorgu süresi :

Başlıksız *

v		foll7069_fta account_seal_log
id : bigint(20) unsigned
email_hash : char(64)
lang : varchar(8)
sent_at : datetime

v		foll7069_fta admin_login_attempts
id : int(11)
email : varchar(255)
attempts : int(11)
ip_address : varchar(45)
locked_until : datetime
created_at : datetime
updated_at : datetime

v		foll7069_fta ad_click_log
id : int(11)
ip_address : varchar(45)
url : varchar(500)
user_agent : varchar(500)
gclid : varchar(100)
gad_source : varchar(20)
referer : varchar(500)
country : varchar(10)
device_type : varchar(20)
session_id : varchar(100)
user_id : int(11)
created_at : datetime

v		foll7069_fta ad_fraud_ips
id : int(11)
ip_address : varchar(45)
rule : varchar(100)
type : varchar(30)
reason : varchar(255)
original_ip : varchar(45)
format : varchar(20)
detected_at : datetime
added_by : int(11)

v		foll7069_fta affiliates
id : int(10) unsigned
user_id : int(10) unsigned
referral_code : varchar(20)
referral_code_changed_at : datetime
status : enum('pending','approved','banned')
commission_rate : decimal(5,2)
total_clicks : int(10) unsigned
total_signups : int(10) unsigned
total_orders : int(10) unsigned
total_earnings : decimal(15,2)
available_balance : decimal(15,2)
pending_balance : decimal(12,2)
created_at : timestamp
updated_at : timestamp
payout_details : text

v		foll7069_fta affiliate_campaigns
id : int(10) unsigned
affiliate_id : int(10) unsigned
name : varchar(100)
sub_id : varchar(40)
clicks : int(10) unsigned
signups : int(10) unsigned
orders : int(10) unsigned
earnings : decimal(15,2)
status : enum('active','archived')
created_at : timestamp

v		foll7069_fta affiliate_clicks
id : int(10) unsigned
affiliate_id : int(10) unsigned
campaign_id : int(10) unsigned
ip_address : varchar(45)
user_agent : text
referrer_url : text
landing_page : varchar(500)
created_at : timestamp

v		foll7069_fta affiliate_commissions
id : int(10) unsigned
affiliate_id : int(10) unsigned
campaign_id : int(10) unsigned
referral_id : int(10) unsigned
order_id : int(10) unsigned
order_total : decimal(15,2)
commission_rate : decimal(5,2)
commission_amount : decimal(15,2)
status : enum('pending','approved','rejected','paid')
created_at : timestamp
approved_at : timestamp
available_at : datetime
admin_note : text

v		foll7069_fta affiliate_referrals
id : int(10) unsigned
affiliate_id : int(10) unsigned
campaign_id : int(10) unsigned
user_id : int(10) unsigned
created_at : timestamp

v		foll7069_fta affiliate_withdrawals
id : int(10) unsigned
affiliate_id : int(10) unsigned
amount : decimal(15,2)
payment_method : enum('balance','paypal','bank','crypto')
payment_details : longtext
status : enum('pending','approved','rejected','completed')
created_at : timestamp
processed_at : timestamp
admin_note : text

v		foll7069_fta ai_blog_generation_logs
id : int(11)
blog_post_id : int(11)
system_prompt : longtext
user_prompt : longtext
image_prompt : text
keywords_data : longtext
primary_keyword : varchar(255)
gpt_input_tokens : int(11)
gpt_output_tokens : int(11)
gpt_cost_usd : decimal(10,6)
dalle_cost_usd : decimal(10,6)
dataforseo_cost_usd : decimal(10,6)
total_cost_usd : decimal(10,6)
gpt_model : varchar(50)
image_model : varchar(50)
raw_response : longtext
created_at : timestamp

v		foll7069_fta ai_blog_logs
id : int(11)
action : varchar(100)
input_tokens : int(11)
output_tokens : int(11)
image_generated : tinyint(1)
cost_usd : decimal(10,6)
model : varchar(50)
success : tinyint(1)
error_message : text
created_at : datetime

v		foll7069_fta ai_blog_queue
id : int(11)
topic : varchar(500)
keywords : varchar(500)
language : varchar(10)
status : enum('pending','processing','completed','failed')
scheduled_at : datetime
processed_at : datetime
blog_post_id : int(11)
error_message : text
created_at : datetime

v		foll7069_fta ai_blog_settings
id : int(11)
setting_key : varchar(100)
setting_value : text
created_at : datetime
updated_at : datetime

v		foll7069_fta ai_content_queue
id : int(11)
entity_type : enum('product','category','blog')
entity_id : int(11)
entity_name : varchar(255)
main_keyword : varchar(500)
category : varchar(255)
languages : longtext
generate_image : tinyint(1)
use_dataforseo : tinyint(1)
status : enum('pending','processing','completed','failed')
priority : int(11)
error : text
result : longtext
created_at : datetime
started_at : datetime
completed_at : datetime
created_by : int(11)

v		foll7069_fta ai_generation_history
id : int(10) unsigned
entity_type : enum('product','category')
entity_id : int(10) unsigned
cost_chatgpt : decimal(10,6)
cost_dalle : decimal(10,6)
cost_dataforseo : decimal(10,6)
cost_total : decimal(10,6)
keywords : longtext
keyword_details : longtext
prompts : longtext
model : varchar(50)
languages : longtext
created_at : timestamp

v		foll7069_fta ai_generation_queue
id : int(10) unsigned
batch_id : varchar(32)
type : enum('product','category')
item_id : int(10) unsigned
mode : enum('enhance','generate')
keyword : varchar(512)
seeds_by_lang : longtext
languages : longtext
options : longtext
status : enum('pending','processing','completed','failed','cancelled')
priority : tinyint(3) unsigned
attempts : tinyint(3) unsigned
max_attempts : tinyint(3) unsigned
result : longtext
error_message : text
started_at : datetime
completed_at : datetime
created_at : datetime
created_by : int(10) unsigned

v		foll7069_fta ai_logs
id : int(11)
type : varchar(50)
model : varchar(50)
input_tokens : int(11)
output_tokens : int(11)
cost_usd : decimal(10,6)
created_at : timestamp

v		foll7069_fta ai_photo_chat
id : int(11)
session_id : varchar(64)
role : enum('user','assistant','system')
content : text
tokens_used : int(11)
created_at : timestamp

v		foll7069_fta ai_photo_images
id : int(11)
job_id : int(11)
entity_type : enum('category','product','custom')
entity_id : int(11)
entity_name : varchar(255)
custom_prompt : text
final_prompt : text
image_url : varchar(500)
local_path : varchar(255)
revised_prompt : text
status : enum('pending','processing','completed','failed')
error_message : text
cost_usd : decimal(10,6)
retry_count : int(11)
created_at : timestamp
processed_at : timestamp

v		foll7069_fta ai_photo_jobs
id : int(11)
job_name : varchar(255)
reference_image : varchar(255)
reference_analysis : text
base_prompt : text
style_preset : varchar(50)
image_size : varchar(20)
total_count : int(11)
completed_count : int(11)
failed_count : int(11)
total_cost_usd : decimal(10,6)
status : enum('pending','processing','completed','failed','cancelled')
created_by : int(11)
created_at : timestamp
started_at : timestamp
completed_at : timestamp

v		foll7069_fta ai_queue_stats
batch_id : varchar(32)
total : bigint(21)
pending : decimal(23,0)
processing : decimal(23,0)
completed : decimal(23,0)
failed : decimal(23,0)
started : datetime
finished : datetime

v		foll7069_fta analytics_daily
id : int(11)
date : date
host : varchar(64)
visitors : int(11)
unique_visitors : int(11)
page_views : int(11)
avg_duration : int(11)
bounce_rate : decimal(5,2)
top_pages : longtext
devices : longtext
countries : longtext
referrers : longtext
hourly_stats : longtext
created_at : timestamp
updated_at : timestamp

v		foll7069_fta api_keys
id : int(10) unsigned
user_id : int(11)
api_key : varchar(64)
name : varchar(100)
permissions : text
rate_limit : int(10) unsigned
is_active : tinyint(1)
last_used_at : datetime
expires_at : datetime
ip_whitelist : text
total_requests : int(10) unsigned
created_at : datetime
updated_at : datetime

v		foll7069_fta api_key_requests
id : int(10) unsigned
user_id : int(11)
full_name : varchar(100)
email : varchar(150)
phone : varchar(30)
platform : varchar(150)
message : text
status : enum('pending','approved','rejected')
admin_note : text
reviewed_at : datetime
reviewed_by : int(11)
created_at : datetime

v		foll7069_fta api_logs
id : bigint(20) unsigned
api_key_id : int(10) unsigned
endpoint : varchar(100)
method : varchar(10)
request_params : text
response_code : smallint(5) unsigned
response_time_ms : int(10) unsigned
ip_address : varchar(45)
user_agent : varchar(255)
created_at : datetime

v		foll7069_fta approved_cards
id : int(11)
user_id : int(11)
card_fingerprint : varchar(64)
card_brand : varchar(32)
card_last4 : varchar(4)
card_country : varchar(4)
approved_by : int(11)
created_at : datetime

v		foll7069_fta banned_ips
id : int(11)
ip_address : varchar(45)
reason : text
banned_by : int(11)
expires_at : datetime
created_at : datetime
updated_at : datetime

v		foll7069_fta blog_packs
id : int(11)
name : varchar(255)
seed : varchar(255)
languages : longtext
scheduled_at : datetime
status : varchar(20)
created_at : datetime
updated_at : datetime

v		foll7069_fta blog_pack_items
id : int(11)
pack_id : int(11)
language_code : varchar(8)
topic : varchar(500)
topic_tr : varchar(500)
primary_keyword : varchar(255)
keywords : longtext
search_volume : int(11)
status : varchar(20)
blog_post_id : int(11)
error : text
generated_at : datetime
created_at : datetime
updated_at : datetime

v		foll7069_fta blog_posts
id : int(10) unsigned
user_id : int(10) unsigned
title : varchar(255)
slug : varchar(255)
excerpt : text
content : longtext
featured_image : varchar(255)
featured_image_alt : varchar(500)
featured_image_title : varchar(255)
status : enum('published','draft','scheduled')
ai_generated : tinyint(1)
published_at : timestamp
views : int(11)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
faqs : longtext
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)
internal_links_updated : datetime
lighthouse_score : int(3)
lighthouse_updated_at : datetime
in_sitemap : tinyint(1)
language : varchar(8)
pack_id : int(11)
featured_snippet_text : varchar(500)

v		foll7069_fta blog_post_translations
id : int(11)
blog_post_id : int(11)
language_code : varchar(5)
slug : varchar(500)
title : varchar(500)
content : longtext
excerpt : text
seo_title : varchar(255)
seo_description : text
seo_keywords : text
faq : text
created_at : timestamp
updated_at : timestamp
faqs : longtext
featured_snippet_text : varchar(500)

v		foll7069_fta blog_schedule
id : int(11)
topic : varchar(500)
keywords : text
primary_keyword : varchar(255)
target_languages : longtext
scheduled_time : time
scheduled_days : longtext
status : enum('pending','processing','active','paused','completed','failed')
last_generated_at : timestamp
next_run_at : timestamp
priority : int(11)
created_at : timestamp
updated_at : timestamp
language : varchar(8)
pack_id : int(11)

v		foll7069_fta bot_visit_log
id : int(11)
bot_type : varchar(50)
user_agent : varchar(500)
ip_address : varchar(45)
page_url : varchar(500)
visited_at : datetime

v		foll7069_fta carts
id : int(10) unsigned
user_id : int(10) unsigned
guest_token_hash : char(64)
anonymous_uuid : varchar(36)
status : enum('active','checkout','converted','abandoned','expired')
source_host : varchar(100)
source_lang : varchar(10)
currency : char(3)
created_at : datetime
updated_at : datetime
expires_at : datetime

v		foll7069_fta cart_items
id : int(10) unsigned
cart_id : int(10) unsigned
product_id : int(10) unsigned
quantity : int(10) unsigned
selection_type : enum('default','skin','be','level','dc_boost')
be_amount : int(10) unsigned
level_count : int(10) unsigned
unit_price : decimal(10,2)
currency : char(3)
product_snapshot_json : text
extra_options_json : text
created_at : datetime
updated_at : datetime

v		foll7069_fta categories
id : int(10) unsigned
parent_id : int(10) unsigned
display_type : enum('products','subcategories')
name : varchar(100)
slug : varchar(100)
description : text
icon : varchar(100)
image : varchar(255)
og_image : varchar(255)
icon_image : varchar(255)
color : varchar(20)
sort_order : int(11)
status : enum('active','inactive')
show_in_header : tinyint(1)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)
in_sitemap : tinyint(1)
google_category_id : int(11)
google_category_name : varchar(255)

v		foll7069_fta category_translations
id : int(10) unsigned
category_id : int(10) unsigned
language_code : varchar(5)
name : varchar(100)
description : text
short_description : text
slug : varchar(255)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)

v		foll7069_fta chatbot_messages
id : int(11)
conversation_id : varchar(36)
user_id : int(11)
ip_address : varchar(45)
role : enum('user','assistant','tool')
content : text
tool_name : varchar(64)
tool_args : longtext
tokens_input : int(11)
tokens_output : int(11)
language : varchar(8)
created_at : timestamp

v		foll7069_fta chatbot_quota
id : int(11)
identifier : varchar(100)
day : date
message_count : int(11)
token_count : int(11)

v		foll7069_fta checkout_email_verifications
id : int(10) unsigned
email : varchar(255)
code : char(6)
attempts : tinyint(3) unsigned
verified : tinyint(1)
ip_address : varchar(45)
user_agent : varchar(500)
language : varchar(5)
created_at : timestamp
last_sent_at : datetime
expires_at : datetime
verified_at : datetime

v		foll7069_fta company_checklist
id : int(11)
title : varchar(255)
category : varchar(100)
priority : enum('low','medium','high','critical')
planned_date : date
completed_at : datetime
is_completed : tinyint(1)
sort_order : int(11)
created_at : timestamp

v		foll7069_fta company_goals
id : int(11)
goal_name : varchar(255)
goal_type : varchar(50)
target_value : decimal(15,2)
target_date : date
description : text
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta contacts
id : int(10) unsigned
name : varchar(100)
email : varchar(100)
subject : varchar(255)
message : text
status : enum('new','read','replied','closed')
ip_address : varchar(45)
created_at : timestamp

v		foll7069_fta contact_messages
id : int(11)
name : varchar(100)
email : varchar(255)
subject : varchar(255)
message : text
ip_address : varchar(45)
is_read : tinyint(1)
created_at : timestamp

v		foll7069_fta coupons
id : int(11)
code : varchar(50)
type : enum('percentage','fixed')
value : decimal(10,2)
min_order : decimal(10,2)
max_order : decimal(12,5)
applicable_delivery_types : longtext
min_amount : decimal(10,2)
max_uses : int(11)
max_uses_per_user : int(11)
used_count : int(11)
expires_at : datetime
status : enum('active','inactive')
show_in_feed : tinyint(1)
created_at : datetime
affiliate_id : int(11)
source : enum('admin','affiliate')

v		foll7069_fta coupon_rate_limits
ip_hash : varchar(64)
attempts : int(11)
first_attempt : datetime

v		foll7069_fta coupon_usage
id : int(11)
coupon_id : int(11)
user_id : int(11)
order_id : int(11)
used_at : datetime

v		foll7069_fta cron_jobs
id : int(11)
job_name : varchar(100)
last_run : datetime
last_status : enum('success','error','running')
last_duration : float
last_error : text
run_count : int(11)
error_count : int(11)
created_at : datetime
updated_at : datetime

v		foll7069_fta customer_touchpoints
id : bigint(20) unsigned
client_id : varchar(64)
user_id : int(11)
visit_at : datetime
session_num : int(11)
page_url : varchar(500)
referrer : varchar(500)
gclid : varchar(200)
gbraid : varchar(200)
wbraid : varchar(200)
fbclid : varchar(200)
ttclid : varchar(200)
msclkid : varchar(200)
utm_source : varchar(100)
utm_medium : varchar(100)
utm_campaign : varchar(200)
utm_term : varchar(200)
utm_content : varchar(200)
device_type : varchar(20)
browser : varchar(50)
os : varchar(50)
ip : varchar(45)
user_agent : varchar(500)
language : varchar(16)
screen : varchar(16)

v		foll7069_fta device_fingerprints
id : int(11)
fingerprint : varchar(64)
user_id : int(10) unsigned
user_agent : varchar(500)
screen_resolution : varchar(20)
timezone : varchar(50)
language : varchar(10)
platform : varchar(50)
created_at : timestamp

v		foll7069_fta device_fingerprints_v2
id : int(11)
fp_hash : char(64)
raw_signals : longtext
persistent_uuid : char(36)
user_id : int(11)
ip_address : varchar(45)
user_agent : text
first_seen : datetime
last_seen : datetime
visit_count : int(11)

v		foll7069_fta drip_feed_queue
id : int(11) unsigned
order_item_id : int(11)
order_id : int(11)
user_id : int(11)
smm_service_id : int(11)
smm_panel_id : int(11)
link : varchar(500)
quantity_per_run : int(11)
total_runs : int(11)
completed_runs : int(11)
interval_minutes : int(11)
next_run_at : datetime
status : enum('active','completed','paused','failed')
last_smm_order_id : int(11)
last_run_at : datetime
error_message : text
created_at : datetime
updated_at : datetime

v		foll7069_fta email_queue
id : int(10) unsigned
batch_id : varchar(36)
to_email : varchar(255)
to_name : varchar(255)
subject : varchar(255)
body : text
priority : int(11)
status : varchar(20)
attempts : int(11)
max_attempts : int(11)
error_message : text
scheduled_at : timestamp
sent_at : timestamp
created_at : timestamp
updated_at : datetime

v		foll7069_fta email_templates
id : int(11)
name : varchar(100)
language : varchar(5)
display_name : varchar(255)
description : text
subject : varchar(255)
body : text
variables : text
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp

v		foll7069_fta email_verification_tokens
id : int(10) unsigned
user_id : int(10) unsigned
token : varchar(64)
expires_at : timestamp
created_at : timestamp

v		foll7069_fta express_login_tokens
id : int(11)
user_id : int(11)
token_hash : char(64)
expires_at : datetime
used_at : datetime
created_at : datetime

v		foll7069_fta faqs
id : int(11)
category : varchar(50)
sort_order : int(11)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp

v		foll7069_fta faq_translations
id : int(11)
faq_id : int(11)
language : varchar(5)
question : text
answer : text

v		foll7069_fta fp_bans
id : int(11)
fp_hash : char(64)
reason : varchar(255)
scope : enum('all','sms','register','login','chat')
banned_by : int(11)
banned_at : datetime

v		foll7069_fta fp_rate_limits
id : int(11)
fp_hash : char(64)
action : varchar(30)
count : int(11)
window_start : datetime
last_at : datetime

v		foll7069_fta game_credit_log
id : int(11)
user_id : int(11)
delta : int(11)
balance : int(11)
reason : varchar(64)
ref : varchar(191)
created_at : datetime

v		foll7069_fta game_requests
id : int(11)
game_name : varchar(255)
norm_name : varchar(255)
steam_game_id : int(11)
steam_app_id : int(11)
request_count : int(11)
user_id : int(11)
email : varchar(191)
last_ip : varchar(45)
lang : varchar(5)
status : enum('pending','added','rejected')
admin_note : varchar(255)
created_at : datetime
updated_at : datetime

v		foll7069_fta geo_prompts
id : int(11)
prompt : varchar(500)
intent : varchar(32)
locale : varchar(5)
location_code : int(11)
is_active : tinyint(1)
priority : int(11)
created_at : datetime

v		foll7069_fta geo_visibility_log
id : int(11)
prompt_id : int(11)
engine : varchar(32)
model : varchar(64)
locale : varchar(5)
mentioned : tinyint(1)
brand_cited : tinyint(1)
brand_rank : int(11)
sentiment : varchar(16)
competitors : text
cited_domains : text
answer_excerpt : text
raw_response : mediumtext
cost_usd : decimal(10,5)
error : text
checked_at : datetime

v		foll7069_fta gsc_page_reports
id : int(11)
url : varchar(1000)
status : varchar(100)
reason : varchar(255)
last_crawled : date
imported_at : datetime

v		foll7069_fta guest_emails
id : int(11)
name : varchar(100)
email : varchar(255)
source : varchar(50)
ip_address : varchar(45)
user_agent : text
language : varchar(5)
created_at : datetime

v		foll7069_fta handoff_tokens
id : int(10) unsigned
token_hash : char(64)
user_id : int(10) unsigned
cart_id : int(10) unsigned
anon_uuid : varchar(36)
source_host : varchar(100)
source_lang : varchar(10)
source_currency : char(3)
target_host : varchar(100)
target_lang : varchar(10)
status : enum('pending','consumed','expired')
expires_at : datetime
consumed_at : datetime
created_at : datetime
ip_hash : char(64)
ua_hash : char(64)

v		foll7069_fta help_articles
id : int(11)
category_id : int(11)
slug : varchar(160)
sort_order : int(11)
is_featured : tinyint(1)
status : varchar(20)
view_count : int(11)
helpful_yes : int(11)
helpful_no : int(11)
created_at : datetime
updated_at : datetime

v		foll7069_fta help_article_translations
id : int(11)
article_id : int(11)
language : varchar(8)
title : varchar(255)
excerpt : varchar(500)
body : longtext
meta_title : varchar(255)
meta_description : varchar(500)

v		foll7069_fta help_categories
id : int(11)
slug : varchar(120)
icon : varchar(40)
parent_id : int(11)
sort_order : int(11)
status : varchar(20)
created_at : datetime
updated_at : datetime

v		foll7069_fta help_category_translations
id : int(11)
category_id : int(11)
language : varchar(8)
name : varchar(255)
description : varchar(500)

v		foll7069_fta homepage_showcases
id : int(11)
title : varchar(150)
subtitle : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
autoplay_ms : int(11)
autoplay_ms_mobile : int(11)
view_all_url : varchar(255)
created_at : datetime
updated_at : datetime

v		foll7069_fta homepage_showcase_products
id : int(11)
showcase_id : int(11)
product_id : int(11)
sort_order : int(11)

v		foll7069_fta homepage_showcase_translations
id : int(11)
showcase_id : int(11)
language_code : varchar(5)
title : varchar(150)
subtitle : varchar(255)

v		foll7069_fta index_queue
id : int(11)
url : varchar(500)
url_type : enum('blog','product','page')
post_id : int(11)
status : enum('pending','submitted','indexed','failed')
priority : int(11)
submit_attempts : int(11)
last_attempt_at : datetime
indexed_at : datetime
created_at : datetime

v		foll7069_fta invoices
id : int(11)
order_id : int(11)
invoice_number : varchar(50)
invoice_data : text
uyumsoft_uuid : varchar(100)
status : enum('pending','created','sent','cancelled')
created_at : datetime

v		foll7069_fta invoice_sequences
id : int(11)
series : varchar(10)
year : int(11)
last_number : int(11)
prefix : varchar(10)
created_at : datetime
updated_at : datetime

v		foll7069_fta keyword_research
id : int(11)
keyword : varchar(255)
language_code : varchar(10)
location_code : int(11)
search_volume : int(11)
competition : decimal(5,4)
cpc : decimal(10,2)
keyword_difficulty : int(11)
trend_data : longtext
source : varchar(50)
used_in_blog : tinyint(1)
last_updated : datetime
created_at : datetime
competition_level : varchar(20)

v		foll7069_fta kyc_qr_sessions
id : int(10) unsigned
user_id : int(11)
submission_id : int(11)
token : varchar(64)
pc_ip : varchar(45)
pc_user_agent : varchar(255)
status : enum('pending','active','completed','expired')
mobile_accessed_at : datetime
completed_at : datetime
expires_at : datetime
created_at : datetime

v		foll7069_fta kyc_submissions
id : int(11)
user_id : int(11)
id_front : varchar(255)
id_back : varchar(255)
selfie : varchar(255)
card_photo : varchar(255)
status : varchar(20)
admin_note : text
rejected_fields : longtext
reviewed_by : int(11)
reviewed_at : datetime
expires_at : datetime
deposit_id : int(11)
created_at : datetime
updated_at : datetime
ai_similarity : decimal(5,2)
ai_decision : enum('approve','review','reject')
ai_reason : varchar(255)
ai_checked_at : datetime
id_full_name : varchar(200)
id_dob : varchar(50)
id_number : varchar(100)
id_number_hash : varchar(64)
id_number_last4 : varchar(4)
id_expiry : varchar(50)
id_doc_type : varchar(50)
id_name_match : tinyint(1)
id_not_expired : tinyint(1)
id_warnings : text
is_voluntary : tinyint(1)

v		foll7069_fta landing_pages
id : int(11)
slug : varchar(100)
title : varchar(255)
meta_title : varchar(255)
meta_description : text
noindex : tinyint(1)
nofollow : tinyint(1)
canonical_url : varchar(500)
hero_title : varchar(500)
hero_subtitle : text
hero_cta_text : varchar(100)
hero_cta_link : varchar(500)
hero_contact_link : varchar(500)
hero_background : varchar(500)
sections : longtext
show_products : tinyint(1)
product_ids : longtext
product_limit : int(11)
show_categories : tinyint(1)
category_ids : longtext
custom_css : text
template : varchar(50)
utm_source : varchar(100)
utm_medium : varchar(100)
utm_campaign : varchar(100)
status : enum('active','draft','archived')
views : int(11)
conversions : int(11)
created_at : datetime
updated_at : datetime
hero_badge_text : varchar(100)

v		foll7069_fta languages
id : int(11)
code : varchar(5)
name : varchar(50)
native_name : varchar(50)
flag_image : varchar(255)
flag_emoji : varchar(10)
is_active : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		foll7069_fta language_readiness_audit
id : bigint(20) unsigned
host : varchar(64)
language_code : varchar(8)
entity_type : enum('product','category','blog','static_page','homepage','shop','contact','faq')
entity_id : int(10) unsigned
entity_slug : varchar(255)
url : varchar(512)
http_status : smallint(6)
canonical_url : varchar(512)
canonical_ok : tinyint(1)
robots_indexable : tinyint(1)
hreflang_ok : tinyint(1)
sitemap_eligible : tinyint(1)
sitemap_included : tinyint(1)
readiness_status : enum('ready','missing_translation','fallback_detected','wrong_language_indexable','inactive_entity','wrong_canonical','hreflang_conflict','noindex_conflict','redirecting','not_found','gone','server_error','in_sitemap_but_not_ready','ready_but_missing_from_sitemap','sitemap_ineligible','needs_review')
issue_code : varchar(64)
issue_details_json : longtext
checked_at : timestamp

v		foll7069_fta lighthouse_cache
id : int(11)
url_hash : varchar(32)
url : varchar(500)
data : longtext
score : int(3)
created_at : datetime

v		foll7069_fta livechat_banned_ips
id : int(11)
ip_address : varchar(45)
anon_uuid : varchar(36)
user_id : int(11)
reason : varchar(255)
chat_id : int(11)
banned_by : int(11)
banned_at : datetime

v		foll7069_fta livechat_proactive_triggers
id : int(11)
name : varchar(80)
trigger_type : enum('time_on_page','cart_abandoned','exit_intent')
page_pattern : varchar(200)
delay_seconds : int(11)
message : text
priority : int(11)
is_active : tinyint(1)
created_at : datetime

v		foll7069_fta livechat_quick_replies
id : int(11)
label : varchar(60)
message : text
page_pattern : varchar(200)
sort_order : int(11)
is_active : tinyint(1)

v		foll7069_fta livechat_snippets
id : int(11)
slash_command : varchar(40)
message_template : text
is_active : tinyint(1)
created_at : datetime

v		foll7069_fta live_chats
id : int(11)
user_id : int(11)
guest_name : varchar(100)
guest_email : varchar(255)
user_language : varchar(8)
session_id : varchar(64)
ip_address : varchar(45)
anon_uuid : varchar(36)
telegram_message_id : bigint(20)
telegram_message_thread_id : bigint(20)
telegram_last_typing_at : datetime
status : enum('waiting','active','closed')
opened_via : varchar(60)
conversion_status : enum('pending','converted','no_conversion')
conversion_order_id : int(11)
conversion_value : decimal(10,2)
converted_at : datetime
admin_id : int(11)
typing_text : text
typing_at : datetime
last_message_at : datetime
unread_admin : int(11)
unread_user : int(11)
created_at : datetime
updated_at : datetime
closed_at : datetime

v		foll7069_fta live_chat_attachments
id : int(11)
chat_id : int(11)
message_id : int(11)
filename : varchar(255)
original_name : varchar(255)
file_type : varchar(80)
file_size : int(10) unsigned
width : smallint(5) unsigned
height : smallint(5) unsigned
duration_sec : smallint(5) unsigned
created_at : timestamp

v		foll7069_fta live_chat_messages
id : int(11)
chat_id : int(11)
sender_type : enum('user','admin','system')
sender_id : int(11)
message : text
original_message : text
translated_from : varchar(8)
is_read : tinyint(1)
created_at : datetime

v		foll7069_fta login_attempts
id : int(11)
email : varchar(255)
attempts : int(11)
ip_address : varchar(45)
locked_until : datetime
created_at : datetime
updated_at : datetime

v		foll7069_fta mass_email_logs
id : int(11)
admin_id : int(11)
target_group : varchar(50)
subject : varchar(255)
total_recipients : int(11)
sent_count : int(11)
failed_count : int(11)
created_at : datetime

v		foll7069_fta media_meta
id : int(11)
filename : varchar(255)
alt_text : varchar(500)
title : varchar(255)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta merchant_settings
id : int(11)
setting_key : varchar(100)
setting_value : text
updated_at : timestamp

v		foll7069_fta mm2_items
id : int(10) unsigned
asset_id : varchar(32)
product_id : int(10) unsigned
name : varchar(255)
type : varchar(64)
rarity : varchar(64)
listed : tinyint(1)
available : int(11)
in_stock : tinyint(1)
keyed_for_itemsatis : int(11)
ref_price_tl : decimal(10,2)
price_override_tl : decimal(10,2)
margin_override : decimal(6,2)
image_override : varchar(255)
in_catalogue : tinyint(1)
sync_error : varchar(255)
raw_json : text
synced_at : datetime
created_at : timestamp
image_original : varchar(255)
crop_x : int(11)
crop_y : int(11)
crop_size : int(11)
fit_mode : varchar(10)

v		foll7069_fta oauth_connections
id : int(10) unsigned
user_id : int(10) unsigned
provider : enum('google','facebook')
provider_id : varchar(255)
provider_email : varchar(255)
access_token : text
refresh_token : text
token_expires_at : timestamp
created_at : timestamp
updated_at : timestamp

v		foll7069_fta odesin_sessions
session_id : varchar(64)
order_number : varchar(40)
expected_amount_minor : int(11)
expected_currency : varchar(3)
created_at : datetime

v		foll7069_fta online_visitors
id : int(11)
session_id : varchar(64)
user_id : int(11)
ip_address : varchar(45)
page_url : varchar(500)
user_agent : varchar(500)
last_activity : timestamp
created_at : timestamp

v		foll7069_fta orders
id : int(10) unsigned
order_number : varchar(50)
user_id : int(10) unsigned
email : varchar(100)
phone : varchar(20)
subtotal : decimal(12,5)
discount : decimal(12,5)
coupon_code : varchar(50)
total : decimal(12,5)
refunded_total : decimal(10,2)
refund_status : enum('none','partial','full')
currency : varchar(3)
payment_method : varchar(50)
payment_id : varchar(255)
wise_expected_amount : decimal(12,2)
wise_expected_currency : varchar(3)
payment_url : varchar(500)
payment_status : enum('pending','completed','failed','refunded')
order_status : varchar(30)
notes : text
admin_notes : text
ip_address : varchar(45)
billing_country : varchar(5)
billing_state : varchar(5)
billing_zip : varchar(10)
tax_rate : decimal(5,4)
tax_amount : decimal(10,2)
us_invoice_id : int(11)
user_agent : text
completed_at : timestamp
created_at : timestamp
updated_at : timestamp
recovery_sent : tinyint(1)
recovery_sent_at : datetime
recovery_token : varchar(64)
gclid : varchar(200)
gbraid : varchar(200)
wbraid : varchar(200)
fbclid : varchar(200)
ttclid : varchar(200)
msclkid : varchar(200)
utm_source : varchar(100)
utm_medium : varchar(100)
utm_campaign : varchar(200)
utm_term : varchar(200)
utm_content : varchar(200)
referrer : varchar(500)
landing_page : varchar(500)
first_visit_at : datetime
session_count : int(11)
first_touch_source : varchar(100)
first_touch_medium : varchar(100)
first_touch_campaign : varchar(200)
first_touch_gclid : varchar(200)
first_touch_fbclid : varchar(200)
device_type : varchar(20)
browser : varchar(50)
os : varchar(50)
client_id : varchar(64)
fb_client_ip : varchar(64)
fb_client_ua : varchar(500)
fb_fbp : varchar(128)
fb_fbc : varchar(255)
fb_source_url : varchar(500)
purchase_capi_sent_at : datetime
purchase_pixel_sent_at : datetime
idempotency_key : varchar(36)
cart_hash : varchar(40)
is_express : tinyint(1)
trustpilot_invite_sent_at : datetime
trustpilot_wa_contacted_at : datetime

v		foll7069_fta order_deliveries
id : int(10) unsigned
order_id : int(10) unsigned
order_item_id : int(10) unsigned
delivery_type : enum('topup','account','instant','manual')
customer_input : longtext
delivery_data : text
smm_panel_id : int(11)
delivery_format : text
status : enum('pending','processing','delivered','failed')
delivered_at : timestamp
notes : text
created_at : timestamp
updated_at : timestamp

v		foll7069_fta order_items
id : int(10) unsigned
order_id : int(10) unsigned
product_id : int(10) unsigned
product_name : varchar(255)
quantity : int(11)
skin_count : int(11)
be_amount : int(11)
level_count : int(11)
price : decimal(12,5)
total : decimal(12,5)
delivered_data : text
sealed_at : timestamp
sealed_emails : text
delivered_at : timestamp
created_at : timestamp
customer_input : longtext
delivery_status : varchar(20)
delivery_data : text
delivery_type : varchar(50)
delivery_link : varchar(500)
smm_order_id : int(11)
smm_panel_id : int(11)
smm_start_count : int(11)
smm_delivered_count : int(11)
drip_feed_runs : int(11)
drip_feed_interval : int(11)
refund_amount : decimal(10,2)
refund_status : enum('none','pending','approved','partial','rejected')
refunded_at : datetime
variant_id : int(11)
claimed_at : datetime
delivered_quantity : int(11)
pending_quantity : int(11)
manual_claimed_at : datetime
guard_count : int(11)
guard_locked_until : datetime
guard_first_at : datetime

v		foll7069_fta otp_codes
id : bigint(20) unsigned
phone : varchar(20)
code_hash : varchar(255)
purpose : varchar(32)
provider : varchar(16)
attempts : int(10) unsigned
max_attempts : int(10) unsigned
expires_at : datetime
consumed_at : datetime
ip : varchar(64)
created_at : datetime

v		foll7069_fta otp_rate_limits
id : int(11)
identifier : varchar(255)
type : enum('ip','phone')
request_count : int(11)
first_request_at : datetime
last_request_at : datetime
blocked_until : datetime

v		foll7069_fta pages
id : int(10) unsigned
slug : varchar(100)
title : varchar(255)
content : longtext
status : enum('published','draft')
seo_title : varchar(255)
seo_description : text
created_at : timestamp
updated_at : timestamp
seo_keywords : varchar(255)
sort_order : int(11)
show_in_header : tinyint(1)
show_in_footer : tinyint(1)
no_index : tinyint(1)

v		foll7069_fta page_translations
id : int(10) unsigned
page_id : int(11)
static_slug : varchar(64)
language_code : varchar(8)
title : varchar(255)
slug : varchar(255)
content : longtext
meta_title : varchar(255)
meta_description : text
status : enum('published','draft')
readiness_status : enum('ready','draft','missing_translation','fallback_detected','needs_review')
source_type : enum('manual','seeded','generated','imported')
last_audited_at : timestamp
created_at : timestamp
updated_at : timestamp

v		foll7069_fta page_views
id : bigint(20)
session_id : varchar(64)
host : varchar(64)
page_url : varchar(500)
page_title : varchar(255)
duration : int(11)
viewed_at : datetime

v		foll7069_fta password_resets
id : int(11)
email : varchar(255)
token : varchar(255)
expires_at : datetime
created_at : timestamp

v		foll7069_fta password_reset_tokens
id : int(10) unsigned
user_id : int(10) unsigned
token : varchar(64)
expires_at : timestamp
used_at : timestamp
created_at : timestamp

v		foll7069_fta payment_attempts
id : int(11)
user_id : int(11)
ip_address : varchar(45)
amount : decimal(10,2)
status : enum('initiated','completed','failed','blocked')
created_at : datetime

v		foll7069_fta payop_payments
id : int(11)
order_number : varchar(100)
payop_invoice_id : varchar(100)
payop_transaction_id : varchar(100)
user_id : int(11)
method_code : varchar(50)
amount_usd : decimal(10,2)
amount_local : decimal(12,2)
currency : varchar(8)
status : enum('pending','processing','completed','failed','expired','refunded')
error_msg : text
raw_response : text
created_at : datetime
completed_at : datetime

v		foll7069_fta paypal_webhook_log
id : int(11)
event_id : varchar(100)
event_type : varchar(100)
resource_id : varchar(100)
payload : mediumtext
created_at : datetime

v		foll7069_fta pending_deposits
id : int(11)
user_id : int(11)
amount : decimal(10,2)
payment_reference : varchar(255)
session_id : varchar(255)
status : enum('pending','released','refunded','expired')
release_at : datetime
released_at : datetime
risk_flags : text
created_at : datetime
updated_at : datetime

v		foll7069_fta phone_otp_log
id : int(10) unsigned
user_id : int(10) unsigned
phone : varchar(20)
created_at : datetime

v		foll7069_fta phone_otp_tokens
id : int(11)
user_id : int(11)
phone : varchar(20)
otp_code : varchar(255)
expires_at : datetime
created_at : datetime

v		foll7069_fta pinterest_pins
id : int(10) unsigned
product_id : int(10) unsigned
language_code : varchar(5)
pinterest_pin_id : varchar(50)
board_id : varchar(50)
title : varchar(100)
description : varchar(800)
link : varchar(2048)
image_url : varchar(500)
status : enum('pending','published','failed')
error_message : text
pinned_by : int(10) unsigned
created_at : datetime
updated_at : datetime

v		foll7069_fta popups
id : int(11)
name : varchar(100)
status : enum('active','inactive')
start_date : datetime
end_date : datetime
delay_seconds : int(11)
close_countdown : int(11)
show_on_pages : text
hide_on_pages : text
show_to_guests : tinyint(1)
show_to_members : tinyint(1)
show_once_per_session : tinyint(1)
dont_show_hours : int(11)
badge_text : varchar(50)
badge_color : varchar(20)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta popup_translations
id : int(11)
popup_id : int(11)
language : varchar(5)
title : varchar(255)
subtitle : varchar(500)
content : text
button_text : varchar(100)
button_link : varchar(500)
button_text_logged_in : varchar(100)
button_link_logged_in : varchar(500)
dont_show_text : varchar(100)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta products
id : int(10) unsigned
category_id : int(10) unsigned
user_id : int(10) unsigned
name : varchar(255)
slug : varchar(255)
short_description : varchar(500)
description : text
price : decimal(12,5)
sale_price : decimal(12,5)
min_quantity : int(11)
max_quantity : int(11)
skin_min : int(11)
skin_max : int(11)
skin_min_price : decimal(12,5)
skin_max_price : decimal(12,5)
skin_price_tiers : longtext
be_enabled : tinyint(1)
be_min : int(11)
be_max : int(11)
be_price_per_1k : decimal(10,4)
be_presets : text
leveled_enabled : tinyint(1)
leveled_min : int(11)
leveled_max : int(11)
leveled_price_per_level : decimal(10,4)
leveled_presets : text
stock : int(11)
is_out_of_stock : tinyint(1)
sold : int(11)
image : varchar(255)
images : longtext
delivery_type : enum('instant','manual','api','account','topup','dc_boost','skinned','turkpin','rbxcrate','dc_member','steam_games','steam_games_credit','mm2')
credit_amount : int(11)
delivery_data : text
required_fields : longtext
delivery_format : text
delivery_time : varchar(100)
guide_slug : varchar(64)
smm_service_id : int(11)
smm_panel_id : int(11)
smm_platform : varchar(50)
drip_feed_enabled : tinyint(1)
status : enum('active','inactive','draft')
sort_order : int(11)
featured : tinyint(1)
show_email_badge : tinyint(1)
product_badges : text
rating : decimal(2,1)
reviews_count : int(11)
views : int(11)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
search_tags : varchar(500)
created_at : timestamp
updated_at : timestamp
features : text
meta_title : varchar(255)
meta_description : text
meta_keywords : varchar(500)
no_index : tinyint(1)
in_sitemap : tinyint(1)
has_variants : tinyint(1)
variant_label : varchar(50)
how_to_use : text
faq : text
fbt_config : text

v		foll7069_fta product_badge_definitions
id : int(11)
badge_key : varchar(64)
icon : varchar(64)
color : varchar(16)
is_system : tinyint(1)
sort_order : int(11)
created_at : timestamp

v		foll7069_fta product_badge_translations
id : int(11)
badge_id : int(11)
language_code : varchar(8)
label : varchar(255)

v		foll7069_fta product_images
id : int(11)
product_id : int(11)
image_path : varchar(255)
sort_order : int(11)
created_at : datetime

v		foll7069_fta product_stock
id : int(11)
product_id : int(11)
stock_data : text
is_sold : tinyint(1)
order_id : int(11)
order_item_id : int(11)
sold_at : datetime
created_at : datetime
notes : text

v		foll7069_fta product_translations
id : int(10) unsigned
product_id : int(10) unsigned
language_code : varchar(5)
name : varchar(255)
slug : varchar(255)
short_description : varchar(500)
description : text
meta_title : varchar(160)
meta_description : varchar(320)
seo_title : varchar(255)
seo_description : text
seo_keywords : text
created_at : timestamp
updated_at : timestamp
no_index : tinyint(1)
how_to_use : text
faq : text

v		foll7069_fta product_variants
id : int(11)
product_id : int(11)
variant_name : varchar(255)
credit_amount : int(11)
price : decimal(12,5)
sale_price : decimal(12,5)
stock : int(11)
turkpin_product_id : int(11)
turkpin_category_id : int(11)
smm_service_id : int(11)
smm_panel_id : int(11)
min_quantity : int(11)
max_quantity : int(11)
drip_feed_enabled : tinyint(1)
cost_price_try : decimal(10,2)
cost_price_usd : decimal(10,2)
sort_order : int(11)
status : enum('active','inactive')
created_at : datetime
updated_at : datetime
is_recommended : tinyint(1)

v		foll7069_fta push_queue
id : int(11)
user_id : int(11)
payload : text
status : enum('pending','processing','sent','failed')
attempts : tinyint(4)
error_msg : text
created_at : datetime
processed_at : datetime

v		foll7069_fta push_subscriptions
id : int(11)
user_id : int(11)
endpoint : varchar(500)
p256dh : varchar(200)
auth : varchar(100)
user_agent : varchar(500)
created_at : datetime
last_used_at : datetime

v		foll7069_fta quests
id : int(11)
slug : varchar(50)
balance_reward : decimal(10,2)
condition_type : varchar(50)
condition_value : int(11)
icon : varchar(50)
sort_order : int(11)
status : enum('active','inactive')
created_at : datetime

v		foll7069_fta recovery_log
id : int(11)
order_id : int(11)
user_id : int(11)
channel : enum('whatsapp','email')
reminder_num : tinyint(4)
status : enum('sent','failed','skipped')
postmark_message_id : varchar(64)
error_message : text
converted_at : datetime
created_at : datetime

v		foll7069_fta reviews
id : int(10) unsigned
product_id : int(10) unsigned
user_id : int(10) unsigned
order_id : int(10) unsigned
rating : tinyint(1)
comment : text
status : enum('pending','approved','rejected')
created_at : timestamp
updated_at : timestamp

v		foll7069_fta seller_applications
id : int(10) unsigned
user_id : int(10) unsigned
full_name : varchar(255)
email : varchar(255)
phone : varchar(50)
country : varchar(100)
telegram_handle : varchar(100)
business_name : varchar(255)
category : varchar(50)
experience_years : varchar(20)
expected_monthly_volume : varchar(50)
product_description : text
portfolio_url : varchar(500)
payment_method : varchar(50)
additional_notes : text
status : enum('pending','reviewing','approved','rejected','waitlist')
admin_notes : text
reviewed_by : int(10) unsigned
reviewed_at : datetime
ip_address : varchar(45)
user_agent : varchar(500)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta seo_index_monitor
id : int(11)
url : varchar(500)
url_type : varchar(20)
in_sitemap : tinyint(1)
in_google : tinyint(1)
google_clicks : int(11)
google_impressions : int(11)
google_position : decimal(5,1)
google_ctr : decimal(5,4)
status : enum('indexed','not_indexed','unwanted','pending')
first_seen_at : datetime
last_checked_at : datetime
created_at : datetime
updated_at : datetime

v		foll7069_fta settings
id : int(10) unsigned
key : varchar(100)
value : text
type : varchar(50)
group : varchar(50)
updated_at : timestamp

v		foll7069_fta shopier_payments
id : int(11)
order_number : varchar(100)
shopier_product_id : varchar(50)
shopier_order_id : varchar(50)
amount_usd : decimal(10,2)
amount_try : decimal(10,2)
usd_try_rate : decimal(10,4)
status : enum('pending','completed','expired','refunded')
created_at : datetime
completed_at : datetime
product_deleted_at : datetime

v		foll7069_fta sitemap_pings
id : int(11)
ping_type : enum('google','bing')
success : tinyint(1)
response_code : int(11)
created_at : datetime

v		foll7069_fta site_events
id : int(11)
title : varchar(255)
description : text
event_type : enum('event','announcement')
start_date : datetime
end_date : datetime
event_url : varchar(500)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta site_settings
id : int(10) unsigned
setting_key : varchar(100)
setting_value : longtext
setting_type : enum('text','textarea','number','boolean','json','image','color')
setting_group : varchar(50)
setting_label : varchar(255)
setting_description : text
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		foll7069_fta smm_order_logs
id : int(11)
order_item_id : int(11)
smm_order_id : int(11)
smm_panel_id : int(11)
status : varchar(50)
error_message : text
response_data : longtext
created_at : datetime

v		foll7069_fta smm_panels
id : int(11)
name : varchar(100)
slug : varchar(100)
api_url : varchar(500)
api_key : varchar(500)
status : enum('active','inactive')
is_default : tinyint(1)
balance : decimal(10,2)
currency : varchar(10)
last_sync_at : datetime
notes : text
created_at : datetime
updated_at : datetime

v		foll7069_fta sms_blocked_log
id : int(10) unsigned
phone_number : varchar(32)
country_code : varchar(8)
country_name : varchar(64)
reason : varchar(64)
source : varchar(32)
ip_address : varchar(64)
user_id : int(10) unsigned
fp_hash : varchar(128)
user_agent : varchar(500)
created_at : datetime

v		foll7069_fta sms_logs
id : int(11)
phone_number : varchar(20)
message : text
channel : enum('sms','whatsapp')
status : enum('sent','failed','pending')
error : text
message_sid : varchar(100)
created_at : datetime

v		foll7069_fta steam_games
id : int(11)
product_id : int(11)
ext_id : varchar(32)
app_id : int(11)
name : varchar(255)
slug : varchar(255)
image : varchar(255)
image_original : varchar(255)
image_source_url : text
price_original : decimal(10,2)
price_current : decimal(10,2)
currency : varchar(3)
is_free : tinyint(1)
featured : tinyint(1)
raw_json : text
steam_synced_at : datetime
synced_at : datetime
status : enum('active','hidden','error')
in_catalogue : tinyint(1)
sync_error : varchar(255)
created_at : timestamp
crop_x : int(11)
crop_y : int(11)
crop_size : int(11)
accounts_available : int(11)
code_cooldown_hours : int(11)
requires_ea : tinyint(1)
v1_synced_at : datetime
pc_requirements : mediumtext

v		foll7069_fta stripe_payments
id : int(11)
user_id : int(11)
payment_intent_id : varchar(100)
amount : decimal(10,2)
deposit_amount : decimal(10,2)
fee_amount : decimal(10,2)
currency : varchar(3)
status : varchar(30)
risk_score : int(11)
risk_level : varchar(20)
failure_reason : varchar(500)
ip_address : varchar(45)
created_at : datetime

v		foll7069_fta stripe_webhook_log
id : int(11)
event_id : varchar(100)
event_type : varchar(100)
payment_intent_id : varchar(100)
payload : text
status : varchar(20)
processed_at : datetime
created_at : datetime

v		foll7069_fta subscription_claims
id : int(11)
user_subscription_id : int(11)
user_id : int(11)
gift_game_id : int(11)
product_id : int(11)
steam_game_id : varchar(64)
period_start : datetime
claimed_at : datetime
status : enum('active','failed','expired','revoked')
created_at : datetime

v		foll7069_fta subscription_events
id : int(11)
provider : varchar(32)
event_id : varchar(191)
event_type : varchar(64)
user_subscription_id : int(11)
provider_charge_id : varchar(191)
amount : decimal(10,4)
currency : varchar(8)
period_start : datetime
period_end : datetime
payload : mediumtext
status : enum('received','processed','ignored','error')
created_at : datetime
processed_at : datetime

v		foll7069_fta subscription_plans
id : int(11)
code : varchar(32)
name_key : varchar(64)
claims_per_window : int(11)
window_hours : int(11)
monthly_cap : int(11)
catalog_scope : varchar(24)
catalog_filter : text
access_type : varchar(16)
price_usd : decimal(10,4)
provider : varchar(32)
provider_plan_ref : varchar(191)
provider_price_currency : varchar(8)
provider_price_amount : decimal(10,2)
billing_interval : varchar(12)
billing_interval_count : int(11)
sort_order : int(11)
status : enum('active','hidden','archived')
created_at : datetime
updated_at : datetime

v		foll7069_fta surprise_box_claims
id : int(11)
user_id : int(11)
ip_address : varchar(45)
fp_hash : varchar(64)
reward_type : enum('coupon','balance')
reward_value : decimal(10,2)
coupon_code : varchar(50)
user_agent : varchar(255)
claimed_at : datetime

v		foll7069_fta tax_nexus_states
id : int(11)
state_code : varchar(2)
state_name : varchar(50)
is_active : tinyint(1)
added_at : datetime

v		foll7069_fta tickets
id : int(11)
ticket_number : varchar(20)
user_id : int(11)
guest_email : varchar(255)
guest_name : varchar(100)
subject : varchar(255)
category : enum('general','order','payment','technical','refund','other')
priority : enum('low','medium','high','urgent')
status : enum('open','in_progress','answered','closed')
order_id : int(11)
created_at : timestamp
updated_at : timestamp
user_last_read_at : datetime
closed_at : timestamp

v		foll7069_fta ticket_attachments
id : int(11)
ticket_id : int(11)
reply_id : int(11)
filename : varchar(255)
original_name : varchar(255)
file_type : varchar(100)
file_size : int(11)
created_at : timestamp

v		foll7069_fta ticket_replies
id : int(11)
ticket_id : int(11)
user_id : int(11)
admin_id : int(11)
is_admin : tinyint(1)
message : text
created_at : timestamp

v		foll7069_fta transactions
id : int(10) unsigned
user_id : int(10) unsigned
type : enum('deposit','withdrawal','purchase','refund','bonus','transfer')
amount : decimal(10,2)
balance_after : decimal(10,2)
description : varchar(255)
reference : varchar(255)
reference_id : int(10) unsigned
reference_type : varchar(50)
status : enum('pending','completed','failed')
created_at : timestamp

v		foll7069_fta turkpin_order_logs
id : int(11)
order_item_id : int(11)
turkpin_order_id : varchar(100)
status : varchar(50)
error_message : text
created_at : datetime

v		foll7069_fta turkpin_price_logs
id : int(11)
product_id : int(11)
variant_id : int(11)
product_name : varchar(255)
old_price : decimal(10,2)
new_price : decimal(10,2)
cost_price_try : decimal(10,2)
change_percent : decimal(5,2)
created_at : datetime

v		foll7069_fta turkpin_products
id : int(11)
product_id : int(11)
turkpin_product_id : int(11)
turkpin_category_id : int(11)
turkpin_name : varchar(255)
cost_price_try : decimal(10,2)
cost_price_usd : decimal(10,2)
last_synced_at : datetime

v		foll7069_fta url_redirects
id : int(11)
old_url : varchar(500)
new_url : varchar(500)
redirect_type : smallint(6)
content_type : enum('product','category','blog','page','landing','custom')
content_id : int(11)
hit_count : int(10) unsigned
last_hit_at : datetime
is_active : tinyint(1)
created_at : datetime

v		foll7069_fta users
id : int(10) unsigned
username : varchar(50)
verified_first_name : varchar(100)
verified_last_name : varchar(100)
verified_full_name : varchar(200)
verified_name_at : datetime
email : varchar(100)
password : varchar(255)
name : varchar(100)
full_name : varchar(255)
phone : varchar(20)
ip_address : varchar(45)
country : varchar(100)
registration_source : varchar(100)
registration_source_url : varchar(500)
utm_source : varchar(100)
utm_medium : varchar(100)
utm_campaign : varchar(200)
phone_verified : tinyint(1)
email_verified : tinyint(1)
google_id : varchar(255)
facebook_id : varchar(255)
apple_id : varchar(255)
discord_id : varchar(255)
avatar_url : varchar(500)
notification_channel : enum('sms','whatsapp','email')
avatar : varchar(255)
role : enum('admin','user','seller')
balance : decimal(10,2)
pending_balance : decimal(10,2)
trust_level : enum('new','trusted','suspicious')
stripe_customer_id : varchar(50)
affiliate_balance : decimal(15,2)
status : varchar(20)
ban_reason : text
email_verified_at : timestamp
verification_code : varchar(255)
verification_expires : datetime
remember_token : varchar(100)
last_login_at : timestamp
last_login_ip : varchar(45)
created_at : timestamp
updated_at : timestamp
language : varchar(5)
preferred_currency : varchar(8)
marketing_emails : tinyint(1)
marketing_email_consent_at : datetime
completed_quests : int(11)
current_rank_id : int(11)
sms_marketing_consent : tinyint(1)
sms_consent_date : timestamp
user_agent : varchar(500)
device_fingerprint : varchar(64)
username_changed_at : datetime
whatsapp_consent : tinyint(1)
whatsapp_consent_date : datetime
client_id : varchar(64)
first_touch_source : varchar(100)
first_touch_channel : varchar(50)
first_touch_detail : varchar(200)
attribution_id : char(32)
signup_method : varchar(30)
first_touch_medium : varchar(100)
first_touch_campaign : varchar(200)
first_touch_term : varchar(200)
first_touch_at : datetime
first_landing_page : varchar(500)
first_referrer : varchar(500)
last_touch_source : varchar(100)
last_touch_medium : varchar(100)
last_touch_campaign : varchar(200)
last_touch_at : datetime
last_gclid : varchar(200)
last_fbclid : varchar(200)
last_device_type : varchar(20)
last_browser : varchar(50)
last_os : varchar(50)
twitch_id : varchar(40)
xbox_id : varchar(64)
steam_id : varchar(20)
telegram_id : varchar(64)
roblox_id : varchar(64)
paypal_id : varchar(64)
is_passwordless : tinyint(1)

v		foll7069_fta user_cards
id : int(11)
user_id : int(11)
card_fingerprint : varchar(64)
card_brand : varchar(32)
card_last4 : varchar(4)
card_country : varchar(4)
charged_amount : decimal(10,2)
charge_date : date
source : enum('kyc','card_verification','admin','deposit')
status : enum('pending','approved','rejected')
deposit_id : int(11)
card_proof : varchar(255)
admin_note : text
reviewed_by : int(11)
reviewed_at : datetime
created_at : datetime

v		foll7069_fta user_game_credits
id : int(11)
user_id : int(11)
balance : int(11)
total_granted : int(11)
total_used : int(11)
created_at : datetime
updated_at : datetime

v		foll7069_fta user_gift_games
id : int(11)
user_id : int(11)
source : varchar(16)
product_id : int(11)
steam_game_id : int(11)
game_name : varchar(255)
ftg_order_id : varchar(191)
delivered_data : text
threshold_usd : decimal(10,4)
granted_at : datetime
expires_at : datetime
status : enum('active','expired','revoked')
claim_ip : varchar(45)
admin_note : varchar(255)
created_at : datetime
updated_at : datetime
period_start : datetime

v		foll7069_fta user_notifications
id : int(11)
user_id : int(11)
type : varchar(50)
params : longtext
link : varchar(500)
pinned_until : datetime
is_read : tinyint(1)
read_at : datetime
created_at : datetime

v		foll7069_fta user_notification_preferences
user_id : int(11)
notification_type : varchar(50)
enabled : tinyint(1)
updated_at : datetime

v		foll7069_fta user_product_overrides
id : int(11)
user_id : int(11)
product_id : int(11)
override_type : enum('allow','block')
reason : varchar(255)
created_by : int(11)
created_at : datetime

v		foll7069_fta user_quests
id : int(11)
user_id : int(11)
quest_id : int(11)
progress : int(11)
is_completed : tinyint(1)
completed_at : datetime
reward_claimed : tinyint(1)
created_at : datetime

v		foll7069_fta user_ranks
id : int(11)
slug : varchar(50)
required_quests : int(11)
discount_percent : decimal(5,2)
badge_color : varchar(20)
badge_icon : varchar(50)
sort_order : int(11)
status : enum('active','inactive')
created_at : datetime

v		foll7069_fta user_sessions
id : int(11)
user_id : int(11)
session_token : varchar(64)
ip_address : varchar(45)
user_agent : varchar(255)
expires_at : datetime
created_at : datetime

v		foll7069_fta user_subscriptions
id : int(11)
user_id : int(11)
plan_id : int(11)
provider : varchar(32)
provider_ref : varchar(191)
provider_customer_ref : varchar(191)
reference_code : varchar(64)
session_id : varchar(191)
status : enum('pending','active','past_due','canceled','expired')
current_period_start : datetime
current_period_end : datetime
access_until : datetime
next_charge_at : datetime
billing_anchor : datetime
cancel_at_period_end : tinyint(1)
auto_renew : tinyint(1)
canceled_at : datetime
fb_fbp : varchar(128)
fb_fbc : varchar(191)
fb_client_ip : varchar(64)
fb_client_ua : varchar(255)
fb_subscribe_sent_at : datetime
created_at : datetime
updated_at : datetime
renewal_reminder_sent_at : datetime

v		foll7069_fta us_invoices
id : int(11)
order_id : int(11)
invoice_number : varchar(20)
company_name : varchar(255)
company_address : text
company_ein : varchar(20)
company_email : varchar(255)
company_phone : varchar(50)
company_website : varchar(255)
customer_name : varchar(255)
customer_email : varchar(255)
customer_country : varchar(5)
customer_state : varchar(5)
customer_zip : varchar(10)
subtotal : decimal(10,2)
tax_rate : decimal(5,4)
tax_amount : decimal(10,2)
discount : decimal(10,2)
total : decimal(10,2)
currency : varchar(3)
tax_jurisdiction : varchar(100)
is_tax_exempt : tinyint(1)
invoice_date : date
status : enum('created','sent','void')
pdf_path : varchar(500)
created_at : datetime
updated_at : datetime

v		foll7069_fta us_invoice_items
id : int(11)
invoice_id : int(11)
product_id : int(11)
product_name : varchar(255)
quantity : int(11)
unit_price : decimal(10,2)
tax_rate : decimal(5,4)
tax_amount : decimal(10,2)
total : decimal(10,2)
created_at : datetime

v		foll7069_fta verified_phones
id : int(11)
phone : varchar(20)
user_id : int(11)
bonus_granted : tinyint(1)
verified_at : datetime

v		foll7069_fta visitor_sessions
id : int(11)
session_id : varchar(64)
host : varchar(64)
user_id : int(11)
current_page : varchar(500)
page_title : varchar(255)
referrer : varchar(500)
fbclid : varchar(500)
gclid : varchar(500)
ttclid : varchar(500)
utm_source : varchar(100)
utm_medium : varchar(100)
utm_campaign : varchar(200)
landing_url : varchar(500)
device_type : enum('desktop','mobile','tablet')
browser : varchar(50)
os : varchar(50)
country : varchar(2)
city : varchar(100)
ip_hash : varchar(64)
pages_viewed : int(11)
session_start : datetime
last_activity : datetime
created_at : timestamp

v		foll7069_fta wa_blocked_numbers
id : int(11)
phone_number : varchar(20)
blocked_by : varchar(100)
reason : varchar(255)
blocked_at : datetime

v		foll7069_fta wa_business_logs
id : int(11)
phone_number : varchar(20)
message_type : enum('template','text')
template_name : varchar(100)
message : text
status : varchar(20)
error : text
message_id : varchar(100)
created_at : datetime

v		foll7069_fta wa_business_webhooks
id : int(11)
event_type : varchar(50)
phone_number : varchar(20)
message_id : varchar(100)
status : varchar(20)
payload : text
created_at : datetime

İlişki oluştur
FOREIGN KEY
on delete
on update