DROP TABLE USER_INFO PURGE;
CREATE TABLE USER_INFO (
USER_ID VARCHAR2(20)
, USERNAME VARCHAR2(20)
, NAME VARCHAR2(20)
, PASSWORD VARCHAR2(256)
, EMAIL VARCHAR2(64)
, TEL_NO VARCHAR2(20)
, HP_NO VARCHAR2(20)
, USER_STATUS_CD VARCHAR2(2)
, CRDT_USER_ID VARCHAR2(20)
, CRDT_DTM DATE
, UPDT_USER_ID VARCHAR2(20)
, UPDT_DTM DATE
, CONSTRAINT USER_INFO_PK PRIMARY KEY(USER_ID)
);
CREATE INDEX USER_INFO_IDX01 ON USER_INFO(USERNAME);
COMMENT ON TABLE USER_INFO IS '사용자 정보';
COMMENT ON COLUMN USER_INFO.USER_ID IS '사용자 아이디';
COMMENT ON COLUMN USER_INFO.USERNAME IS '유저네임(사용자 등록 아이디)';
COMMENT ON COLUMN USER_INFO.NAME IS '사용자 명';
COMMENT ON COLUMN USER_INFO.PASSWORD IS '사용자 암호';
COMMENT ON COLUMN USER_INFO.EMAIL IS '이메일';
COMMENT ON COLUMN USER_INFO.TEL_NO IS '전화번호';
COMMENT ON COLUMN USER_INFO.HP_NO IS '핸드폰 번호';
COMMENT ON COLUMN USER_INFO.USER_STATUS_CD IS '사용자 상태 코드';
COMMENT ON COLUMN USER_INFO.CRDT_DTM IS '생성일시';
COMMENT ON COLUMN USER_INFO.CRDT_USER_ID IS '생성자 아이디';
COMMENT ON COLUMN USER_INFO.UPDT_DTM IS '수정일시';
COMMENT ON COLUMN USER_INFO.UPDT_USER_ID IS '수정자 아이디';
CREATE SEQUENCE USER_INFO_SEQ
MINVALUE 1
MAXVALUE 99999999999999999999
INCREMENT BY 1
START WITH 1
CACHE 100
CYCLE
;