create table PRODUCT (
	productId integer not null primary key,
	sku char(35) not null,
	name varchar(128) not null,
	description varchar(256),
	price float not null,
	currency char(3) not null
);

create table CATEGORY (
	categoryId integer not null primary key,
	name varchar(128) not null,
	description varchar(256) not null
);

create table CATEGORY_PROD (
	categoryId integer not null,
	productId integer not null,

	constraint CATEGORY_PROD_PK primary key (categoryId, productId),
	constraint CATEGORY_PROD_FK1 foreign key (categoryId) references CATEGORY (categoryId),
	constraint CATEGORY_PROD_FK2 foreign key (productId) references PRODUCT (productId)
);

insert into PRODUCT values (1, 'sku001', 'Columbia Snow Patrol Parka Mens', 'Offers low-profile warmth with exceptional range of motion and moisture management',
	114.99, 'USD');

insert into CATEGORY values (1, 'Apparel', 'Sports clothing for men and women');

insert into CATEGORY_PROD values (1, 1);