Android Room Add Unique Contraint to Table (Kotlin)

Oct 21, 2018

Single column unique (e.g. key only).

@Entity(tableName = "item", indices = [Index(value = "id_key", unique = true)])data class Item (}

Combine two columns to be unique (e.g. type and key).

@Entity(tableName = "item", indices = [Index(value = ["item_type", "id_key"], unique = true)])data class Item (}

Multiple unique constaints.

@Entity(tableName = "item", indices = [Index(value = "id_key", unique = true), Index(value = ["item_type", "another_key"], unique = true)])data class Item (}

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.

Tags
Related articles
Android Room Upgrade Database Add New Table (Migration) - KotlinAndroid Room Database Migration Instrumented Unit Test (Kotlin)Android Room Database Migration (Upgrade Version) - KotlinGuide to learning Android Dev with Kotlin and Architecture Components (ViewModel, LiveData and Room)Sqlite Query Equal String Even if NullAndroid Convert Room LiveData Async to SyncAndroid Room Database TransactionAndroid Room Batch Insert Or Update (Kotlin)Access Android Room Database Version At RuntimeAndroid Room Insert or UpdateAndroid Room Use Nullable Variable for EmbededAndroid Instrumented Unit Test With Room Using In Memory Database And LiveDataJava.Time.LocalDateTime Converter For Room (Kotlin)