Replacing one-to-many relationships with association tables automatically (for keywords of a dataset) #17

New issue

Closed

opened 2021-05-31 16:27:32 +02:00 by kaiarn · 0 comments

kaiarn commented

2021-05-31 16:27:32 +02:00

Owner

change the one-to-many relationship between 'document' (dataset) and 'document_subjects' (keyword) table to a many-to-many relationship
ad an association table
reason: many keywords are named identical, same keyword can hav many datasets

- change the one-to-many relationship between 'document' (dataset) and 'document_subjects' (keyword) table to a many-to-many relationship - ad an association table - reason: many keywords are named identical, same keyword can hav many datasets ![grafik](/attachments/c87b5861-c344-48ce-805a-6d55feb16500)

grafik.png

70 KiB