# this is a comment

# @schema "public"
# @include "file"
# @reserve table, table, table...
#
#@reflect users.last_post_id nil

alice: Users
  name: "Alice"
  age: 20
  groups: [supers, users]
  picture:
    title: Picture of Alice
    blob: "image"
  role: &alices_role # this is a comment
    name: "Administrator" # this is a comment
    active: true # this is a comment

alice: Users
  last_post: *alices_first_post

alices_blog: Blogs
  user: *alice
  title: "Alice's Blog"

Roles
  - &user_role
    name: "User"
    active: true
  - &anon_role
    name: "Anon"
    active: true

Posts
  - &alices_first_post
    blog: *alices_blog
    head: My first blog post
    body: This is the first post in my new blog
    created_at: "1970-01-01"

bob: Users
  name: "Bob"
  role: *alices_role
  last_post: *bobs_last_post
  groups: ["42", "43"]
  blogs:
    - title: "Bob's Blog"
      posts:
        - &bobs_first_post
          head: Bobs first blog post
          body: Hi Alice!
          created_at: "1970-01-01"
        - &bobs_last_post
          head: Happy birthday!
          body: Cakeday!
          created_at: "1970-01-02"

bill: Users
  name: Bill
  role: *user_role
  groups: []

Comments
  - author: *bill
    post: *alices_first_post
    head: Congratulations !
    body: Good luck
    created_at: "1970-01-01 00:00"
  - author: &lizzy
      name: Lizzy
      role: *user_role
      comments:
        - post: *bobs_first_post
          head: "Me too"
          body: "Hugs from Lizzy"
          created_at: "1970-01-03"

    post: *alices_first_post
    head: ""
    body: Same from me
    created_at: "1970-01-01 00:01"