Results 2 comments of oldwang

I have no idea about vector DB, will learn and support in future.

JOIN is ok, foreign key should be avoided, do you have real requirements?