Spring Session Table - ORACLE
CREATE TABLE SPRING_SESSION ( PRIMARY_ID CHAR(36) NOT NULL, SESSION_ID CHAR(36) NOT NULL, CREATION_TIME NUMBER(19,0) NOT NULL, LAST_ACCESS_TIME NUMBER(19,0) NOT NULL, MAX_INACTIVE_INTERVAL NUMBER(10,0) NOT NULL, EXPIRY_TIME NUMBER(19,0) NOT NULL, PRINCIPAL_NAME VARCHAR2(100 CHAR), CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (PRIMARY_ID) ); CREATE UNIQUE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (S..
더보기
공통코드
DROP TABLE COMM_CD_GRP PURGE; CREATE TABLE COMM_CD_GRP ( CODE_GRP_ID VARCHAR2(20) , CODE_GRP_ID_NM VARCHAR2(128) , ETC1 VARCHAR2(128) , ETC2 VARCHAR2(128) , ETC3 VARCHAR2(128) , APPL_STRT_DTM DATE , APPL_END_DTM DATE , USE_YN VARCHAR2(2) , CRDT_USER_ID VARCHAR2(20) , CRDT_DTM DATE , UPDT_USER_ID VARCHAR2(20) , UPDT_DTM DATE , CONSTRAINT COMM_CD_PK PRIMARY KEY(CODE_GRP_ID) ); COMMENT ON TABLE COM..
더보기
user
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_I..
더보기