Channels
#exposed
Title
# exposed
y
Yoavya
05/05/2020, 9:28 AMHi, I was wondering, if I want to create a reference between one table and multiple other tables. is this possible?
For example: Lets say I have an Uploads table and I want Users table to have uploads and Posts table to have uploads as well. Can this be done with exposed? I mean with the
referencedOnreferrersOnt
tapac
05/05/2020, 12:45 PMWhat kind of relation do you want to setup?
Users -> many uploads
Posts -> many uploads ?
y
Yoavya
05/05/2020, 12:46 PMyes
but referencing by just ID is not enough since the two tables ids can collide, so I was thinking of adding a type column but I can’t reference by two columns just one
t
tapac
05/05/2020, 1:04 PMMaybe it's worth to add UserToUploads and PostToUpload tables and link them with
viay
Yoavya
05/05/2020, 1:39 PMI can do that, but then If I want to add something else that has uploads then I will have to create a connecting table for it
t
tapac
05/05/2020, 6:02 PM5 Views