A modern programming language that makes developers happier.

kotlinlang

Reference_to_array_of_foreign_keys.kt

Hi, 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? For single reference is syntax (integer(“genre_id”) references GenreTable.id) it is working but what about more values?. Or I use it bad?

You need an additional table to link many-to-many (songs-to-genres)
<https://github.com/JetBrains/Exposed/wiki/DAO#many-to-many-reference>

maybe also post the answer to SO for other people

<https://stackoverflow.com/questions/52651601/reference-to-array-of-foreign-keys-jetbrains-exposed-sql/52665582#52665582>