CREATE TABLE CLIENT
(
  USER_CODE   NUMBER(12)   primary key
, ID    VARCHAR2(15)   NOT NULL
, NAME    VARCHAR2(15)   NOT NULL
, PASSWORD   VARCHAR2(20)   NOT NULL
, BIRTHDAY   DATE    NOT NULL
, GENDER   CHAR(1)    NOT NULL
, HOUSENUMBER   VARCHAR2(11)
, EMAIL    VARCHAR2(30)   NOT NULL
, ZIPCODE   CHAR(5)    NOT NULL
, PRIMARY_ADDRESS  VARCHAR2(100)   NOT NULL
, DETAILED_ADDRESS  VARCHAR2(100)   NOT NULL
, JOIN_DATE   DATE    NOT NULL
, POINT    NUMBER(5)   NOT NULL
, NON_MEMBER   CHAR(12)
, PHONENUMBER   NUMBER(11)   NOT NULL
, USER_GRADE_CODE  NUMBER(2)     
, foreign key (brand_code) references brand(brand_code)
, PRODUCT_TYPE_CODE  NUMBER(2) );    



CREATE TABLE BRAND (
  BRAND_CODE   NUMBER(2)  primary key
, BRAND_NAME   VARCHAR2(40)
, BRAND_LOGO   VARCHAR2(100)
);



select * from brand;

insert into brand values(12,'dsadsa','dasdasd');



brand 를 fk 로 설정하고싶은데 오류가떠 ...


이거 두 테이블만 만들어지면된느데..


왜생성안되는거지?