테이블 컬럼과 요구사항


create table member(

member_id varchar(20) primary key check(regexp_like(member_id, '^[a-z0-9]{8,20}$')),

member_pw varchar(16) not null check(regexp_like(member_pw, '^(?=.*[a-zA-z])(?=.*[0-9])(?=.*[$`~!@$!%*#^?&\\(\\)\-_=+]).{8,16}$')),

member_nick varchar(30) not null unique check(regexp_like(member_nick, '^[가-힣0-9]{1,10}$')),

member_phone number(11) not null check(regexp_like(member_phone, '^010\d{4}\d{4}$')),

member_email varchar(100) check(regexp_like(member_email, '^[0-9a-zA-Z]([-_\.]?[0-9a-zA-Z])*@[0-9a-zA-Z]([-_\.]?[0-9a-zA-Z])*\.[a-zA-Z]{2,3}$')),

member_birth varchar(10) not null check(regexp_like(member_birth, '^(19|20)\d{2}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[0-1])$')),

member_post varchar(6) not null check(regexp_like(member_post, '^[0-9]{5,6}$')),

member_basic_address varchar(300) not null,

member_detail_address varchar(300),

member_point number(10) not null check(member_point >= 0),

member_grade char(12) not null check(type in ('일반회원', '우수회원','관리자')),

member_joindate date,

member_logindate date

);



밑에는 내가 짠 코드


근데 오류 떠


뭐가 문제일까?



오류 보고 -

ORA-02438: Column check constraint cannot reference other columns

02438. 00000 -  "Column check constraint cannot reference other columns"

*Cause:    attempted to define a column check constraint that references

           another column.

*Action:   define it as a table check constriant.