shop.yaml

name: "shop"
schema: public
tables:
  products:
    columns:
      id:
        type: uuid
        pk: true
      created_at:
        type: timestamptz
      updated_at:
        type: timestamptz
      deleted_at:
        type: timestamptz
        nullable: true
      category_id:
        type: uuid
      name:
        type: varchar
      code:
        type: varchar
      unit:
        type: varchar
    indexes:
      products_deleted_at:
        columns: [deleted_at]
      products_category_id:
        columns: [category_id]
      products_code:
        columns: [code]
    relations:
      categories:
        name: product_category_rel
        columns: [category_id]
        parentColumns: [id]
        onDelete: CASCADE
  categories:
    columns:
      id:
        type: uuid
        pk: true
      created_at:
        type: timestamptz
      updated_at:
        type: timestamptz
      deleted_at:
        type: timestamptz
        nullable: true
      parent_id:
        type: uuid
        nullable: true
      name:
        type: varchar
      is_disabled:
        type: boolean
        default: false
    indexes:
      categories_deleted_at:
        columns: [deleted_at]
      categories_parent_id:
        columns: [parent_id]
    relations:
      categories:
          name: category_parent_rel
          columns: [parent_id]
          parentColumns: [id]
          onDelete: CASCADE