CREATE DATABASE company;
USE company;
CREATE TABLE team (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(255),
);
CREATE TABLE member (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(255),
team_name VARCHAR(255),
ROLE TINYINT(1),
birthday DATE,
work_start_date DATE,
FOREIGN KEY (team_name) REFERENCES team(NAME)
);
컨트롤러
@RestController
public class TeamController {
private final TeamService teamService;
public TeamController(TeamService teamService) {
this.teamService = teamService;
}
@PostMapping("/team")
public void saveTeam(@RequestBody TeamCreateRequest request) {
teamService.saveTeam(request);
}
@GetMapping("/teams")
public List<TeamResponse> getTeams(){
return teamService.getTeams();
}
}