CREATE TABLE user(
	id INT AUTO_INCREMENT PRIMARY KEY,
	user_id VARCHAR(30) NOT NULL UNIQUE,
	user_name VARCHAR(10) NOT NULL,
	user_password VARCHAR(30) NOT NULL
);

CREATE TABLE posts(
	post_id INT AUTO_INCREMENT PRIMARY KEY,
	post_title VARCHAR(30) NOT NULL,
	post_content TEXT NOT NULL,
	created_at DATE NOT NULL,
	last_modified_at DATE NOT NULL,
	FOREIGN KEY (user_id)
	REFERENCES user(user_id) DELETE ON CASCADE
);

추가 시간 / 수정 시간 컬럼은 추후 추가

• 조회수, 좋아요수