1. 문제 관심사용자에 등록하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary key, TITLE VAR..

1. 문제 게시글의 북마크를 추가/삭제하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary key, TIT..

1. 문제 게시글의 스크랩을 삭제하는 API 2. 풀이 - BoardService.java package com.example.jpa.sample.board.service; import com.example.jpa.sample.board.entity.BoardBadReport; import com.example.jpa.sample.board.entity.BoardType; import com.example.jpa.sample.board.model.*; import java.util.List; public interface BoardService { ServiceResult addBoard(BoardTypeInput boardTypeInput); ServiceResult updateBoard(Long id..

1. 문제 게시글의 스크랩을 추가하는 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment primary key, TITLE ..

1. 문제 게시글의 신고하기 목록을 조회하는 API 2. 풀이 - BoardService.java package com.example.jpa.sample.board.service; import com.example.jpa.sample.board.entity.BoardBadReport; import com.example.jpa.sample.board.entity.BoardType; import com.example.jpa.sample.board.model.*; import java.util.List; public interface BoardService { ServiceResult addBoard(BoardTypeInput boardTypeInput); ServiceResult updateBoard(Lon..

1. 문제 게시된 게시글에 대해서 문제가 있는 게시글을 신고하는 기능의 API 2. 풀이 - schema.sql DROP TABLE IF EXISTS USER; DROP TABLE IF EXISTS NOTICE; create table USER ( ID BIGINT auto_increment primary key, EMAIL VARCHAR(255), NAME VARCHAR(255), PASSWORD VARCHAR(255), PHONE VARCHAR(255), REG_DATE TIMESTAMP, UPDATE_DATE TIMESTAMP, STATUS INTEGER, LOCK_YN BOOLEAN DEFAULT FALSE ); create table NOTICE ( ID BIGINT auto_increment ..