shop_pages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
shop_content_blocks.page_id shop_content_blocks_page_id_fkey R
shop_id INT 10 null
shops.id shop_pages_shop_id_fkey R
shop_setting_id INT 10 √ null
shop_settings.id shop_pages_shop_setting_id_fkey N
layout_data JSON 1073741824 √ null
theme_settings JSON 1073741824 √ null
is_published BIT 1 0
created_at DATETIME 23 CURRENT_TIMESTAMP(3)
updated_at DATETIME 23 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
shop_pages_shop_id_fkey Performance Asc shop_id
shop_pages_shop_setting_id_fkey Performance Asc shop_setting_id

Relationships

Close relationships within degrees of separation