Untitled

Untitled

Untitled

Untitled

cardData usersData boardsData columnsData
34000개 30개 330개 46000개
  1. List<Card> findByColumns(Columns columns);

→ SELECT * FROM card WHERE column_id = ?;

  1. List<Card> findAllByCollaboratorAndBoardId(String collaborator, Long boardId);

→ SELECT * FROM card WHERE collaborator = ? AND board_id = ?;

  1. @Query("SELECT MAX(c.cardIndex) FROM Card c WHERE c.columns = :columns") Long findMaxCardIndexByColumns(@Param("columns") Columns columns);

→ SELECT MAX(card_index) FROM card WHERE column_id = ?;

  1. List<Columns> findAllByBoardOrderByColumnIndex(Board board);

→ SELECT * FROM columns WHERE board_id = ? ORDER BY column_index;