CREATE TABLE ADM_HISTORY ( SEQ NUMBER NOT NULL, USER_ID VARCHAR2(20) NOT NULL, CUD VARCHAR2(1) CHECK( CUD IN('C', 'U', 'D')) NOT NULL, TITLE VARCHAR2(2000) NOT NULL, URL VARCHAR2(500) NULL, REGDATE DATE DEFAULT SYSDATE, PRIMARY KEY ( SEQ ), FOREIGN KEY ( USER_ID ) REFERENCES ADM_USERS ( USER_ID ) );
create table check in
2011. 7. 6. 13:01