Tables


SchemaSpy Analysis of live_commerce_app.live_commerce_app

Generated on Thu Oct 30 14:50 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 134
VIEWS 0
COLUMNS 882
Constraints 179
Anomalies 0
Routines 0

Database Properties

Database Type: MySQL - 8.4.6

Tables

Table / View Children Parents Columns Rows Type Comments
_prisma_migrations 0 0 8 70 Table
favorite_notifications 0 2 7 0 Table
raffle_purchases 0 2 7 0 Table
shipping_rate_tables 2 1 3 0 Table
size_master 1 1 5 40 Table
shop_coupon_uses 0 2 6 0 Table
notification_settings 0 1 7 0 Table
live_ratings 0 2 5 0 Table
live_archives 0 1 5 0 Table
inventory_reserves 0 1 8 0 Table
coordinate_products 0 2 4 0 Table
comment_ng_words 0 0 3 0 Table
maintenance_logs 0 1 7 0 Table
live_staffs 0 2 6 0 Table
coordinate_tags 0 1 3 0 Table
inventory_logs 0 1 6 0 Table
product_categories 3 1 8 674 Table
access_logs 0 1 6 0 Table
payments 2 1 9 0 Table
auctions 3 0 11 0 Table
live_analytics 1 1 9 0 Table
bgm_copyrights 0 1 6 0 Table
notification_targets 0 2 6 0 Table
shipping_rates 0 2 6 0 Table
staff_performance 0 1 5 0 Table
user_follows 0 2 5 0 Table
live_promotions 1 2 6 0 Table
raffle_entries 0 2 7 0 Table
live_products 0 2 4 100 Table
user_coupons 0 2 6 0 Table
influencer_product_sales 0 2 6 0 Table
influencer_settlements 0 1 8 0 Table
shop_pages 1 2 8 0 Table
users 48 0 12 25 Table
coordinates 3 2 9 20 Table
admin_sessions 0 1 7 0 Table
product_apparel_details 0 1 5 2 Table
receipts 0 1 8 0 Table
product_shipping 0 2 3 0 Table
cart_items 0 2 6 0 Table
shipping_tracking 0 2 9 0 Table
return_messages 0 2 5 0 Table
messages 1 1 11 0 Table
payment_logs 0 1 5 0 Table
block_history 0 2 5 0 Table
report_actions 0 2 5 0 Table
video_products 0 2 4 100 Table
notifications 2 0 6 0 Table
pinned_comments 0 3 5 0 Table
shipping_labels 0 1 3 0 Table
system_metrics 0 0 6 0 Table
product_variants 4 4 11 400 Table
user_devices 0 1 8 0 Table
message_threads 1 3 6 0 Table
shop_shipping_settings 0 1 6 0 Table
shop_sales_monthly 0 1 6 0 Table
influencer_sales 0 2 6 0 Table
gift_types 1 0 8 0 Table
tutorial_steps 0 0 6 0 Table
influencer_products 2 2 6 0 Table
color_master 1 1 5 46 Table
live_product_sales 0 3 9 0 Table
social_accounts 0 1 7 0 Table
notification_channels 0 1 5 0 Table
report_email_settings 1 1 6 0 Table
search_histories 0 1 7 0 Table
influencer_settings 0 1 5 0 Table
error_logs 0 0 5 0 Table
product_images 1 1 7 400 Table
shop_settlements 1 1 9 0 Table
user_suspensions 0 1 7 0 Table
shop_templates 0 0 7 0 Table
inventory 1 1 6 400 Table
mail 0 1 11 0 Table
staff_permissions 0 1 4 0 Table
reports 2 1 9 0 Table
orders 12 2 9 0 Table
favorites 1 1 6 1 Table
promotion_purchases 0 2 5 0 Table
coordinate_images 0 1 4 0 Table
platform_sales 0 0 7 0 Table
category_products_count 0 1 2 0 Table
user_sessions 0 1 7 50 Table
auction_winners 1 2 8 0 Table
product_image_comments 0 1 4 0 Table
reviews 2 4 11 7749 Table
shop_sales_daily 0 1 5 0 Table
refunds 0 2 5 0 Table
auction_settings 0 1 7 0 Table
product_other_details 0 1 7 500 Table
live_viewers 0 2 5 0 Table
shops 27 0 9 10 Table
auction_auto_payments 0 2 7 0 Table
order_items 0 3 9 0 Table
gift_transactions 0 2 9 0 Table
gift_points 0 1 6 0 Table
products 16 2 11 100 Table
lives 13 1 9 100 Table
return_requests 2 1 5 0 Table
live_comments 2 2 7 0 Table
shop_coupon_products 0 2 3 0 Table
comment_history 0 2 7 0 Table
videos 2 2 11 100 Table
influencer_product_cancellations 0 1 7 0 Table
video_views 0 2 4 0 Table
admins 4 0 8 2 Table
shop_settings 1 1 7 0 Table
review_images 0 1 7 1200 Table
product_variant_images 0 1 3 400 Table
staff_accounts 2 1 7 0 Table
raffles 2 0 10 0 Table
shop_coupons 3 1 16 0 Table
user_blocks 1 2 5 0 Table
shop_content_blocks 0 1 7 0 Table
prefectures 1 0 2 0 Table
live_rating_stats 0 1 6 0 Table
admin_notifications 0 1 4 0 Table
follows 0 2 6 0 Table
live_kicks 0 3 6 0 Table
backup_logs 0 0 5 0 Table
order_commissions 0 1 5 0 Table
shipping_addresses 0 1 7 0 Table
auction_bids 0 2 8 0 Table
review_replies 0 2 8 5868 Table
shop_staffs 0 2 7 14 Table
raffle_winners 1 2 8 0 Table
transfer_logs 0 1 7 0 Table
bgm_tracks 1 0 9 0 Table
product_sizes 1 1 6 400 Table
shipments 1 1 8 0 Table
report_responses 0 2 8 0 Table
live_likes 0 2 4 0 Table
user_tutorial_status 0 1 6 0 Table
tutorial_skip_logs 0 1 4 0 Table