CREATE TABLE "ARSAMSUSER"."LINK_TYPE_CODE"
(
	LINK_TYPE     		VARCHAR2(20) NOT NULL,
	DCD_NO        		VARCHAR2(1) NULL,
	IS_ONE_TO_ONE 		VARCHAR2(1) NULL CHECK(IS_ONE_TO_ONE IS NULL OR(IS_ONE_TO_ONE IN(Y,N,NULL))),
	IS_DRAWN      		VARCHAR2(1) NULL CHECK(IS_DRAWN IS NULL OR(IS_DRAWN IN(Y,N,NULL))),
	DESCRIPTION   		VARCHAR2(60) NULL,
	LENGTH_OPERATION      	VARCHAR2(4) NULL,
	WIDTH_OPERATION       	VARCHAR2(4) NULL,
	HEIGHT_OPERATION      	VARCHAR2(4) NULL,
	WEIGHT_OPERATION      	VARCHAR2(4) NULL,
	AREA_OPERATION        	VARCHAR2(4) NULL,
	PRIMARY KEY (LINK_TYPE) 
)
TABLESPACE ARSAMS
/

##</code><code>##

s/\CHECK\b//i;

##</code><code>##

CREATE TABLE "ARSAMSUSER"."LINK_TYPE_CODE"
(
	LINK_TYPE     		VARCHAR2(20) NOT NULL,
	DCD_NO        		VARCHAR2(1) NULL,
	IS_ONE_TO_ONE 		VARCHAR2(1) NULL,
	CHECK(IS_ONE_TO_ONE IS NULL OR(IS_ONE_TO_ONE IN(Y,N,NULL))),
	IS_DRAWN      		VARCHAR2(1) NULL,
	DESCRIPTION   		VARCHAR2(60) NULL,
	LENGTH_OPERATION      	VARCHAR2(4) NULL,
	WIDTH_OPERATION       	VARCHAR2(4) NULL,
	HEIGHT_OPERATION      	VARCHAR2(4) NULL,
	WEIGHT_OPERATION      	VARCHAR2(4) NULL,
	AREA_OPERATION        	VARCHAR2(4) NULL,
	CHECK(IS_DRAWN IS NULL OR(IS_DRAWN IN(Y,N,NULL))),
	PRIMARY KEY (LINK_TYPE) 
)
TABLESPACE ARSAMS
/