<div id="readability-page-1" class="page"><article id="mainContent">
                                <div>
                                    <p><a href="/m/category/Programming%21"><span>Programming!</span></a></p><h3>JPA ElementCollection</h3>
                                </div>
                                <p><cite>eclipse4j</cite>
                                    <span> 2023. 6. 2. 12:45</span>
                                </p>
                                                <div>
                                <p data-ke-size="size16">CollectionTable</p>
<p data-ke-size="size16">- Table 명 지정.</p>
<p data-ke-size="size16">- Collection Table의 주테이블 컬럼 명 지정. ( FK가 될 컬럼 )</p>
<p data-ke-size="size16">- FK 제약은 제거</p>
<p data-ke-size="size16">- 이경우 fk가 없으니 index 필요.&nbsp;</p>
<p data-ke-size="size16">- 인덱스 생성</p>
<p data-ke-size="size16">- order by 컬럼 지정</p>
<p data-ke-size="size16">- CollectionTable의 경우 Audit 불필요(주관적), Delete, Insert로 진행</p>
<pre id="code_1685677288333" data-ke-language="java" data-ke-type="codeblock"><code>    @ElementCollection(fetch = FetchType.LAZY)
    @CollectionTable(name = "memo_tag",
        joinColumns = [
            JoinColumn(name = "memo_id")
        ],
        foreignKey = ForeignKey(ConstraintMode.NO_CONSTRAINT),
        indexes = [
            Index(
                columnList = "memo_id",
                name = "idx_memo_tag_memo_id"
            )
        ]
    )
    @OrderBy("sort asc")
    var memoTags: MutableList&lt;MemoTagEntity&gt; = mutableListOf()</code></pre>
<p data-ke-size="size16">생성결과</p>
<figure data-ke-mobilestyle="widthOrigin" data-filename="스크린샷 2023-06-02 오후 12.51.01.png" data-origin-width="1942" data-origin-height="1086">
    <span data-url="https://blog.kakaocdn.net/dn/bNAZ57/btsijPnsUQH/2R7IRsc8dgl28e193Os5Ck/img.png" data-lightbox="lightbox">
        <img src="https://blog.kakaocdn.net/dn/bNAZ57/btsijPnsUQH/2R7IRsc8dgl28e193Os5Ck/img.png" onerror="this.onerror=null; this.src='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png'; this.srcset='//t1.daumcdn.net/tistory_admin/static/images/no-image-v1.png';" data-filename="스크린샷 2023-06-02 오후 12.51.01.png" data-origin-width="1942" data-origin-height="1086">
    </span>
    
</figure>
<p data-ke-size="size16"><a href="https://github.com/KimHyeongi/spring-boot3-kotlin/blob/main/core/src/main/kotlin/com/tistory/eclipse4j/core/primary/memo/entity/MemoEntity.kt" target="_blank" rel="noopener">https://github.com/KimHyeongi/spring-boot3-kotlin/blob/main/core/src/main/kotlin/com/tistory/eclipse4j/core/primary/memo/entity/MemoEntity.kt</a></p>

            
            
                </div>
                                            
            
                            </article></div>

eclipes4j's 개발은 언제나 즐겁다.- KEEP

CollectionTable
- Table 명 지정.
- Collection Table의 주테이블 컬럼 명 지정. ( FK가 될 컬럼 )
- FK 제약은 제거
- 이경우 fk가 없으니 index 필요. 
- 인덱스 생성
- order by 컬럼 지정
- CollectionTable의 경우 Audit 불필요(주관적), Delete, Insert로 진행
    @ElementCollection(fetch = FetchType.LAZY)
    @CollectionTable(name = "memo_tag",
        joinColumns = [
            JoinColumn(name = "memo_id")
        ],
        foreignKey = ForeignKey(ConstraintMode.NO_CONSTRAINT),
        indexes = [
            Index(
                columnList = "memo_id",
                name = "idx_memo_tag_memo_id"
            )
        ]
    )
    @OrderBy("sort asc")
    var memoTags: MutableList<MemoTagEntity> = mutableListOf()
생성결과
https://github.com/KimHyeongi/spring-boot3-kotlin/blob/main/core/src/main/kotlin/com/tistory/eclipse4j/core/primary/memo/entity/MemoEntity.kt

JPA ElementCollection

댓글