mysql 테이블 생성

테이블 정의서

create table content_tb(
	CONTENT_NUM varchar(10) primary key not null,
	TITLE varchar(20) not null,
	CONTENT varchar(300) not null,
	create_dt datetime not null,
	del_yn varchar(1) not null
);

create table image_mng_tb(
	FILE_NUM varchar(10) primary key,
	CONTENT_NUM VARCHAR(10),
	CREAT_DT DATETIME not null,
	DEL_YN VARCHAR(1) not null
);

create table image_tb(
	FILE_NUM varchar(10),
	FILE_DETAIL_ID varchar(10),
	FILE_STRE_COURS varchar(2000),
	STRE_FILE_NAME varchar(255),
	ORIGIN_FILE_NAME varchar(255),
	FILE_EXTSN varchar(20),
	DEL_YN varchar(1),
	primary key (FILE_NUM, FILE_DETAIL_ID ),
	foreign key (FILE_NUM) references image_mng_tb(FILE_NUM)
);

image_mng_tb에 외래키가 빠져있어 추가해줬다
ALTER TABLE image_mng_tb ADD FOREIGN KEY(CONTENT_NUM) REFERENCES content_tb(CONTENT_NUM);