Store sales_transaction_header and sales_transaction_line data as a JSON data type in a single table.

Create separate sales_transaction_header and sales_transaction_line tables, and prioritize sales_transaction_line in the WHERE clause during queries.

Design a sales_transaction table with sales_transaction_header information as rows and sales_transaction_line rows as nested and repeated fields.

Combine sales_transaction_header and sales_transaction_line into a single table, duplicating header data for each line.