[Oracle]테이블 만들때 Constraint 추가하기

CREATE TABLE S_EMP

(ID NUMBER(7),

LAST_NAME VARCHAR2(25) CONSTRAINT S_EMP_LAST_NAME_NN NOT NULL,

FIRST_NAME VARCHAR2(25),

USERID VARCHAR2(8) CONSTRAINT S_EMP_USERID_NN NOT NULL,

START_DATE DATE DEFAULT SYSDATE,

COMMENTS VARCHAR2(25),

MANAGER_ID NUMBER(7),

TITLE VARCHAR2(25),

DEPT_ID NUMBER(7),

SALARY NUMBER(11,2),

COMMISSION_PCT NUMBER(4,2),

CONSTRAINT S_EMP_ID_PK PRIMARY KEY(ID),

CONSTRAINT S_EMP_USERID_UK UNIQUE,

CONSTRAINT S_EMP_DEPT_ID_FK FOREIGN KEY(DEPT_ID)

REFERENCES S_DEPT(ID),

CONSTRAINT S_EMP_COMMISSION_PCT CHECK

(COMMISSION_PCT IN (10, 12.5, 15, 17.5, 20))) ;

 

[테이블 만들고 나서 추가하기]

 

alter table 사원 add constraint 사원_fk foreign key(부서) references 부서(부서코드);

alter table 가족 add constraint 가족_fk foreign key(사원번호) references 사원(사원번호);