shops

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
color_master.shop_id color_master_shop_id_fkey R
coordinates.shop_id coordinates_shop_id_fkey R
follows.shop_id follows_ibfk_2 R
gift_points.shop_id gift_points_ibfk_1 R
influencer_products.influencer_shop_id influencer_products_influencer_shop_id_fkey R
influencer_sales.influencer_shop_id influencer_sales_influencer_shop_id_fkey R
influencer_sales.original_shop_id influencer_sales_original_shop_id_fkey R
influencer_settings.shop_id influencer_settings_shop_id_fkey R
influencer_settlements.shop_id influencer_settlements_shop_id_fkey R
lives.shop_id lives_shop_id_fkey R
message_threads.shop_id message_threads_shop_id_fkey R
orders.shop_id orders_ibfk_2 R
products.shop_id products_shop_id_fkey R
report_email_settings.shop_id report_email_settings_shop_id_fkey R
review_replies.shop_id review_replies_shop_id_fkey R
shipping_rate_tables.shop_id shipping_rate_tables_shop_id_fkey R
shop_coupons.shop_id shop_coupons_shop_id_fkey R
shop_pages.shop_id shop_pages_shop_id_fkey R
shop_sales_daily.shop_id shop_sales_daily_shop_id_fkey R
shop_sales_monthly.shop_id shop_sales_monthly_shop_id_fkey R
shop_settings.shop_id shop_settings_shop_id_fkey R
shop_settlements.shop_id shop_settlements_shop_id_fkey R
shop_shipping_settings.shop_id shop_shipping_settings_shop_id_fkey R
shop_staffs.shop_id shop_staffs_ibfk_1 R
size_master.shop_id size_master_shop_id_fkey R
staff_accounts.shop_id staff_accounts_shop_id_fkey R
videos.shop_id videos_shop_id_fkey R
name VARCHAR 255 null
status enum('ACTIVE', 'INACTIVE') 8 null
created_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null
updated_at DATETIME 19 null
description TEXT 65535 √ null
avatar_url VARCHAR 255 √ null
VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_shops_name Performance Asc name
idx_shops_status_deleted_created Performance Asc/Asc/Asc status + deleted_at + created_at

Relationships

Close relationships within degrees of separation