1 2 3 4 5 6 7 8 9 10 | 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