CREATE TABLE TB_USER
(
	NM                   VARCHAR2(50) NOT NULL ,
	USER_ID              VARCHAR2(20) NOT NULL ,
	PASSWORD             VARCHAR2(128) NULL ,
	EMAIL                VARCHAR2(100) NULL ,
	USER_TY              VARCHAR2(10) DEFAULT  '01'  NOT NULL,
	USE_AT               CHAR(1) DEFAULT  'Y'  NOT NULL,
	RSPOFC               VARCHAR2(50) NULL ,
	CLSF                 VARCHAR2(50) NULL,
	AHRZT_IDNTFCNO 		 VARCHAR2(300) NULL,
	CREAT_DT             DATE DEFAULT SYSDATE  NOT NULL ,
	CRTR                 VARCHAR2(100) NOT NULL ,
	UPDT_DT              DATE DEFAULT SYSDATE NOT NULL ,
	UPDUSR               VARCHAR2(100) NOT NULL
);

CREATE UNIQUE INDEX XPKTB_USER ON TB_USER
(USER_ID   ASC);

ALTER TABLE TB_USER
    ADD CONSTRAINT  XPKTB_USER PRIMARY KEY (USER_ID);









