How to use OR in sequelize?

Question

SQLite

I am writing a CRM system. There are 2 tables: in one users (parents), in another children. The child has 2 columns for parents (mom, dad).

The question is, how do I get the right child if the parent can be in one of the child's two fields? I used findOne() before, is it possible to use or here?

Answer 1

create a Relationships table instead of parent1, parent2:
Autokey, PersonAID, PersonBID, RelationType
then you can add any type of relationship PersonAID to PersonBID, not only for User to Children but also User to User and even Children to Children
Where in your case there will be 2 records with different User.ID and the same Children.ID

Answer 2

Doesn't SQLite have an in operator?
check how in works if one of Parent is null. (recommendation if you don't know)
user.id in (Children.Parent1, Clildren.Parent2)