orders_total_id int unsigned not_null auto_increment comment(Primary key - unique identifier for each order total line)
orders_id int not_null comment(FK to orders table - order this total line belongs to)
title text not_null comment(Display title for this total line - e.g. Subtotal, Tax, Shipping, Total)
text varchar(255) not_null comment(Formatted text value for display - e.g. $10.00, Free Shipping)
value decimal(15,4) not_null comment(Numeric value for calculations)
class varchar(255) not_null comment(Total module class name - identifies the type of total)
sort_order int(3) not_null comment(Display order for total lines - subtotal first, grand total last)
--
primary orders_total_id
idx_orders_total_orders_id orders_id
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci