I have table song and table genre. Song can contains more genres. So I want reference genreIds from table genre. How I can reference to array of foreign keys in jetbrains.exposed.sql?
For single reference is syntax (integer("genre_id") references GenreTable.id). Any idea?
object SongTable : Table() {
val id = integer("id").primaryKey().autoIncrement()
val name = text("name")
val genreIds = (integer("genre_id") references GenreTable.id) //THERE I WANT MORE IDS
}
object GenreTable : Table() {
val id = integer("id").primaryKey().autoIncrement()
val logo = text("logo")
}