products_id int not_null comment(FK to products table - product this description belongs to)
language_id int default(1) not_null comment(FK to languages table - language of this description)
products_name varchar(255) default('') not_null comment(Product name in this language)
products_description text comment(Full product description in this language - HTML allowed)
products_url varchar(255) comment(External product URL for more information)
products_viewed int(5) default(0) comment(Number of times product has been viewed)
products_seo_url varchar(255) comment(SEO-friendly URL slug for this product)
products_head_title_tag text null comment(HTML title tag content for SEO)
products_head_desc_tag text null comment(HTML meta description tag content for SEO)
products_head_keywords_tag text null comment(HTML meta keywords tag content for SEO)
products_head_tag text null comment(Additional HTML head tags for this product)
products_shipping_delay varchar(255) comment(Shipping delay message when product is in stock)
products_description_summary text comment(Short product description or summary)
products_shipping_delay_out_of_stock varchar(255) comment(Shipping delay message when product is out of stock)
--
primary products_id language_id
products_name products_name
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci