이력서 관리 사이트 personalMain페이지

화면 설계서 초안

1. 회사 공고들을 모두 보여줄 DB쿼리문

		SELECT company_board.company_board_id,
		company.company_name,
		company_board.company_board_title,
		company_board.company_board_content,
		company_board.company_board_deadline,
		company_board.company_board_picture
		FROM company
		JOIN company_board ON company.company_id = company_board.company_id;

 

2. 특정 키워드를 눌렀을때 필터링해서 보여줄 기능은 

백엔드에서는 필요한 정보만 넘겨주고 프론트에서 Ajax통신으로 작업.

사용될 쿼리문 

SELECT company.company_id,
company.company_name,
company_board.company_board_title,
company_board.company_board_content,
company_board.company_board_deadline,
company_board.company_board_picture,
category.frontend,
category.backend,
category.devops,
category.etc
FROM company
INNER JOIN category 
ON company.company_category = category.category_id
LEFT OUTER JOIN company_board
ON company_board.company_id = company.company_id;