Database Layout

JSON requirements from existing PDP

id

handle

sku

img = aws

shopify_id

primary_option

New Schema:

oomph_products

id = identity / PK

shopify_product_id

shopify_variant_id

enabled = bool (default = true)

primary_option = int (lookup to options table)

created_at

updated_at

oomph_aws_images

_id

product_id = ID from oomph_products

position = int (99 = default) sorted ASC

aws_id = varchar

aws_public_url

created_at

updated_at

oomph_options

*option_id

display_name

option_handle

oomph_option_values

* _id

option_id

option_value

option_handle

option_swatch_color

option_swatch_url

created_at

updated_at

oomph_option_links

_id

product_id

option_id

option_value_id