-- Create Table Statement for 'Clothing Article Design'
DROP TABLE IF EXISTS `CLOTHING_ARTICLE_DESIGN`;
CREATE TABLE `CLOTHING_ARTICLE_DESIGN` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	NAME varchar NOT NULL,
	CLOTHING_ARTICLE_FK bigint(20) NOT NULL,
	COUNT_OS int(11) NOT NULL,
	COUNT_XS int(11) NOT NULL,
	COUNT_S int(11) NOT NULL,
	COUNT_M int(11) NOT NULL,
	COUNT_L int(11) NOT NULL,
	COUNT_XL int(11) NOT NULL,
	COUNT_2XL int(11) NOT NULL,
	COUNT_3XL int(11) NOT NULL,
	COUNT_4XL int(11) NOT NULL,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;