html&css&js/DB

create table check in

ddakker 2011. 7. 6. 13:01

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