CREATE TABLE TBL_COURSE(
ID VARCHAR2(10) NOT NULL PRIMARY KEY
,CATEGORY VARCHAR2(10) NOT NULL
,CATEGORY2 VARCHAR2(10) NOT NULL
,NAME VARCHAR2(50) NOT NULL
,MENTO VARCHAR2(10) NOT NULL
,PRICE NUMBER(10) NOT NULL
,LEVEL NUMBER(2) DEFAULT 1
,DISCOUNT NUMBER(3) DEFAULT 0
,CONTENT VARCHAR2(1000)
,IMG VARCHAR2(1000)
,REGDATE DATE DEFAULT SYSDATE
,CONSTRAINT FK_COURSE_CATEGORY FOREIGN KEY(CATEGORY)
REFERENCES TBL_CATEGORY(ID)
,CONSTRAINT FK_COURSE_CATEGORY2 FOREIGN KEY(CATEGORY2)
REFERENCES TBL_CATEGORY(ID)
,CONSTRAINT FK_COURSE_MEMBER FOREIGN KEY(MENTO)
REFERENCES TBL_MEMBER(ID)
,CONSTRAINT C_LEVEL CHECK (LEVEL BETWEEN 1 AND 3)
);
왜 계속 오류가 나는가..... 어디서 틀렸지... !!!ㅜ-ㅜ
댓글 없음:
댓글 쓰기