태그 관련 테이블
태그 테이블
CREATE TABLE IF NOT EXISTS tag(
tag_id VARCHAR(20) NOT NULL,
PRIMARY KEY(tag_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;게시물 - 태그 테이블
CREATE TABLE IF NOT EXISTS post_tag(
post_id INT NOT NULL,
tag_id VARCHAR(20) NOT NULL,
PRIMARY KEY(post_id, tag_id),
FOREIGN KEY(post_id) REFERENCES post(post_id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY(tag_id) REFERENCES tag(tag_id) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;사용자 - 태그 테이블
CREATE TABLE IF NOT EXISTS user_tag(
user_id VARCHAR(20) NOT NULL,
tag_id VARCHAR(20) NOT NULL,
PRIMARY KEY(user_id, tag_id),
FOREIGN KEY(user_id) REFERENCES user(user_id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY(tag_id) REFERENCES tag(tag_id) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;Last updated
Was this helpful?