Relations

{
  "type": "relation",
  "name": "department",
  "with": "Department",
  "relationType": "BelongsToOne",
  "nullable": true,
  "onDelete": "SET NULL",
  "desc": "부서"
}

{
  "type": "relation",
  "name": "childPosts",
  "with": "Post",
  "relationType": "HasMany",
  "joinColumn": "parent_post_id",
  "fromColumn": "id",
  "desc": "하위 게시글"
}

SELECT * FROM posts
WHERE posts.parent_post_id = {user.id}

CREATE TABLE posts__tags (
  id INTEGER PRIMARY KEY,
  post_id INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE,
  tag_id INTEGER NOT NULL REFERENCES tags(id) ON DELETE CASCADE,
  UNIQUE(post_id, tag_id)
);

{
  "type": "relation",
  "name": "latestPost",
  "with": "Post",
  "relationType": "OneToOne",
  "hasJoinColumn": false,
  "customJoinClause": "users.id = posts.user_id AND posts.is_published = true",
  "desc": "최신 발행 게시글"
}

{
  "subsets": {
    "A": [
      "id",
      "title",
      "user.username",
      "user.email",
      "tags.name"
    ]
  }
}

{
  "subsets": {
    "A": [
      "id",
      "title",
      "user.id",
      "user.username",
      "user.employee.department.name"
    ]
  }
}

FROM posts
LEFT JOIN users ON posts.user_id = users.id
LEFT JOIN employees ON users.id = employees.user_id
LEFT JOIN departments ON employees.department_id = departments.id

const posts = await this.puri()
  .orderBy("user.username", "asc")
  .many();