CREATE TABLE school_user (
user_id VARCHAR2(20) NOT NULL,
user_pass VARCHAR2(20) NOT NULL,
name VARCHAR2(21) NOT NULL,
address VARCHAR2(50) NOT NULL,
tel char(13),
birth CHAR(6) NOT NULL,
sex CHAR(1) NOT NULL,
grade NUMBER(1) NOT NULL,
class NUMBER(1) NOT NULL,
protector_name VARCHAR2(21) DEFAULT '담당교사',
protector_tel CHAR(13),
classify VARCHAR2(10) NOT NULL,
CONSTRAINTS user_pk PRIMARY KEY(user_id),
CONSTRAINTS user_uk UNIQUE (class, grade, classify),
CONSTRAINTS user_fk FOREIGN KEY(classify) REFERENCES com_table(ch_code)
);
이렇게 테이블을 만들었고 protector_name 에 null 값을 입력했으나 '담당교사' 가 아닌 null 값이 들어갑니다 ㅠㅠ
왜그러는걸까요?ㅠ