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