create table SizeUSStd (
	id NUMBER(10) PRIMARY KEY,
	notecode VARCHAR(2),
	
	size00    DECIMAL(2,3),
	size00max DECIMAL(2,3),
	size0    DECIMAL(2,3),
	size0max DECIMAL(2,3),
	size2    DECIMAL(2,3),
	size2max DECIMAL(2,3),
	size4    DECIMAL(2,3),
	size4max DECIMAL(2,3),
        ...
	size26    DECIMAL(2,3),
	size26max DECIMAL(2,3)
);	

create table SizePetite (
	id NUMBER(10) PRIMARY KEY,
	notecode VARCHAR(2),
	
	size0P    DECIMAL(2,3),
	size0Pmax DECIMAL(2,3),
	size2P    DECIMAL(2,3),
	size2Pmax DECIMAL(2,3),
        ...
	size12P    DECIMAL(2,3),
	size12Pmax DECIMAL(2,3)
);	

create table SizeSML (
	id NUMBER(10) PRIMARY KEY
	notecode VARCHAR(2),
	
	sizeXXS    DECIMAL(2,3),
	sizeXXSmax DECIMAL(2,3),
	sizeXS    DECIMAL(2,3),
	sizeXSmax DECIMAL(2,3),
	sizeS    DECIMAL(2,3),
	sizeSmax DECIMAL(2,3),
	sizeM    DECIMAL(2,3),
	sizeMmax DECIMAL(2,3),
	sizeL    DECIMAL(2,3),
	sizeLmax DECIMAL(2,3),
	sizeXL    DECIMAL(2,3),
	sizeXLmax DECIMAL(2,3),
	sizeXXL    DECIMAL(2,3),
	sizeXXLmax DECIMAL(2,3)	
);	

CREATE TABLE Measurement (
	id number(15) PRIMARY KEY,
	sizetype VARCHAR(3) NOT NULL,
	sizeid NUMBER(10) NOT NULL,
	type ENUM('bust', 'waist', 'hip', 'inseam', 'torso', 'height') NOT NULL
);	

ID   SIZETYPE   SIZEID TYPE
5    USS        2      waist
5    USS        3      hip
5    USS        4      inseam

CREATE TABLE Brand (
	id NUMBER(5) PRIMARY KEY,
	name VARCHAR(30) NOT NULL,
	measurementid NUMBER(15),
	storeid NUMBER(5)
);	
	
create table Store (
	id NUMBER(5) PRIMARY KEY,
	name VARCHAR(30) NOT NULL,
	measurementid NUMBER(15)
);	

create table Clothes (
	id NUMBER(10) PRIMARY KEY
	measurementid NUMBER(15),
	storeid NUMBER(5) NOT NULL, 
	brandid NUMBER(5) NOT NULL,
	category ENUM ('tops', 'jeans', 'bras', 'dresses') NOT NULL,
	description VARCHAR(300),
	createdate date
);	
	

create table sizes_master(
sm_id number primary key,
size_method varchar2(20));

create table sizes_detail(
sd_id number primary key, 
sm_id references sizes_master, 
size_name varchar2(20),
size_value number);

insert into sizes_master values(1,'SizeUSStd');
insert into sizes_master values(2,'SizePetite');
insert into sizes_master values(3,'SizeSML');

insert into sizes_detail values(1,1,'size00','0.0');
insert into sizes_detail values(2,1,'size00max',1.0);

SQL> select constraint_name, constraint_type, index_name
  2  from user_constraints
  3  where table_name in ('SIZES_MASTER', 'SIZES_DETAIL');

CONSTRAINT_NAME                C INDEX_NAME
------------------------------ - ------------------------------
SYS_C007131                    P SYS_C007131
SYS_C007132                    R
SYS_C007130                    P SYS_C007130

insert into sizes_master values(&Method_id,'&Method_name');

insert into sizes_detail values(&Size_id,&Method_id,'&Size_name','&Size_value');