# One parent, two children, four mappings: tables and insert SQL
# Hibernate ORM 7.4.16.Final, H2, JDK 25

== A. Unidirectional, plain @OneToMany (no mappedBy, no @JoinColumn)
tables: [JTCHILD, JTLISTPARENT, JTLISTPARENT_JTCHILD]
-- persist(parent with 2 children); commit
   sql> insert into JtListParent (id) values (default)
   sql> insert into JtChild (name,id) values (?,default)
   sql> insert into JtChild (name,id) values (?,default)
   sql> insert into JtListParent_JtChild (JtListParent_id,children_id) values (?,?)
   sql> insert into JtListParent_JtChild (JtListParent_id,children_id) values (?,?)

== B. Unidirectional with @JoinColumn(name = "parent_id")
tables: [JCCHILD, JCLISTPARENT]
-- persist(parent with 2 children); commit
   sql> insert into JcListParent (id) values (default)
   sql> insert into JcChild (name,id) values (?,default)
   sql> insert into JcChild (name,id) values (?,default)
   sql> update JcChild set parent_id=? where id=?
   sql> update JcChild set parent_id=? where id=?

== C. Bidirectional, mappedBy, child owns the foreign key
tables: [DEPARTMENTS, EMPLOYEES]
-- persist(department with 2 employees); commit
   sql> insert into departments (name,id) values (?,default)
   sql> insert into employees (dept_id,name,uuid,id) values (?,?,?,default)
   sql> insert into employees (dept_id,name,uuid,id) values (?,?,?,default)
