PK: user_id
full_name
email (unique)
password_hash
phone_number
organization_name
country
role (buyer, supplier, analyst, admin)
created_at
last_login
PK: company_id
company_name
sector
address
website_url
verification_status (pending, verified, rejected)
registered_country
verified_by (FK → Users.user_id, admin role)
PK: contact_id
FK: company_id
name
designation
whatsapp_number
email
linked_to_user (FK Users.user_id, nullable)
PK: product_id
product_name
hs_code
category
description
PK: id
FK: product_id
capability_type (buyer, supplier, both)
yearly_capacity_metric
unit (tons, kg, liters, etc.)
PK: bookmark_id
FK: user_id
bookmarked_type (company, product)
bookmarked_record_id
PK: rfq_id
FK: buyer_id (Users.user_id)
quantity
unit
target_country
status (open, responded, closed)
PK: response_id
FK: rfq_id
FK: supplier_id (Companies.company_id)
price_offer
delivery_time_days
notes
response_date
PK: stat_id
year
import_volume
export_volume
avg_price
top_import_country
top_export_country
PK: price_id
region
date
price
source
PK: alert_id
severity (high, medium, low)
alert_type (price_spike, shortage, policy_change, anomaly_detected)
generated_at
explanation_text
PK: metric_id
revenue
performance_score
trust_score (AI/GNN generated)
PK: chat_id
query_text
response_text
timestamp
resolved_by_ai (boolean)
by gas
