Car.kt

@Entity(
    foreignKeys = [
        ForeignKey(
            entity = Color::class,
            parentColumns = ["id"],
            childColumns = ["color_id"],
            onDelete = ForeignKey.CASCADE, // or any other strategy
            onUpdate = ForeignKey.CASCADE, // or any other strategy
            // deferred = true
        )
    ]
)
data class Car(
    @PrimaryKey val id: String,
    @ColumnInfo(name = "program_id", index = true) val colorId: String
)

@Entity
data class Color(
    @PrimaryKey val id: String,
    val name: String,
    val hex: String
)