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 )
);

+ Recent posts