Home

Architecture

• DevelopmentOperations
  

• DataBase ERD
  

• ClassDiagram
  

프로시저 코드
CREATE PROCEDURE MenMeetDatabase.showPostList(IN _category INT, IN _isMentor INT, IN _keyword VARCHAR(20), IN _pageNum INT) BEGIN SELECT * FROM mentoring_post mp WHERE IF (_category IS NULL, mp.category IS NOT NULL , mp.category = _category) AND IF (_isMentor IS NULL, mp.mentoring_target IS NOT NULL, mp.mentoring_target = _isMentor) AND IF (_keyword IS NULL, mp.title IS NOT NULL, mp.title LIKE CONCAT('%',_keyword,'%')OR mp.content LIKE CONCAT('%',_keyword,'%')) ; END

Skill & Spec & Tool

• React
• SpringBoot - Java11
• JPA - Hibernate
• AWS EC2 - UbuntuOs
• AWS RDS - MariaDB
• ETC Tool
  JIRA (협업 관리 도구)
  PostMan (HTTP 동작 확인)
  MobaXterm (AWS EC2 console 접근)
  DBeaver (AWS RDS 접근)