create table shop.ProductOptions (
_Id int identity(1,1) not null
,_AppId int not null
,_DateInserted datetime not null
,_DateUpdated datetime null
,_ProductId int not null
,ShopifyId nvarchar(128) not null
,OptionIndex int not null
,OptionName nvarchar(255) not null
,OptionValue nvarchar(255) not null
);
go
alter table shop.ProductOptions add constraint PK_ProductOptions primary key clustered (_Id);
alter table shop.ProductOptions add constraint NK_ProductOptions unique(_AppId, ShopifyId, OptionValue);