{
  "schemas": [
    {
      "name": "app",
      "comment": null,
      "owner": "pgevolve",
      "grants": []
    }
  ],
  "extensions": [],
  "tables": [
    {
      "qname": {
        "schema": "app",
        "name": "users"
      },
      "columns": [
        {
          "name": "id",
          "ty": {
            "kind": "big_int"
          },
          "nullable": false,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        },
        {
          "name": "email",
          "ty": {
            "kind": "text"
          },
          "nullable": false,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        },
        {
          "name": "name",
          "ty": {
            "kind": "text"
          },
          "nullable": true,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        },
        {
          "name": "deleted_at",
          "ty": {
            "kind": "timestamp",
            "precision": null,
            "with_tz": true
          },
          "nullable": true,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        }
      ],
      "constraints": [
        {
          "qname": {
            "schema": "app",
            "name": "users_pkey"
          },
          "kind": {
            "kind": "primary_key",
            "columns": [
              "id"
            ],
            "include": []
          },
          "deferrable": {
            "kind": "not_deferrable"
          },
          "comment": null
        }
      ],
      "partition_by": null,
      "partition_of": null,
      "comment": null,
      "owner": "pgevolve",
      "grants": [],
      "rls_enabled": false,
      "rls_forced": false,
      "policies": [],
      "storage": {
        "fillfactor": null,
        "autovacuum": {
          "enabled": null,
          "vacuum_threshold": null,
          "vacuum_scale_factor": null,
          "vacuum_cost_delay": null,
          "vacuum_cost_limit": null,
          "analyze_threshold": null,
          "analyze_scale_factor": null,
          "freeze_max_age": null,
          "freeze_min_age": null,
          "freeze_table_age": null,
          "multixact_freeze_max_age": null,
          "multixact_freeze_min_age": null,
          "multixact_freeze_table_age": null,
          "vacuum_insert_threshold": null,
          "vacuum_insert_scale_factor": null,
          "log_min_duration": null
        },
        "parallel_workers": null,
        "toast_tuple_target": null,
        "user_catalog_table": null,
        "vacuum_truncate": null,
        "extra": {}
      }
    }
  ],
  "indexes": [
    {
      "qname": {
        "schema": "app",
        "name": "users_active_idx"
      },
      "on": {
        "kind": "table",
        "schema": "app",
        "name": "users"
      },
      "method": "b_tree",
      "columns": [
        {
          "expr": {
            "column": "email"
          },
          "collation": null,
          "opclass": null,
          "sort_order": "asc",
          "nulls_order": "nulls_last"
        }
      ],
      "include": [],
      "unique": false,
      "nulls_not_distinct": false,
      "predicate": {
        "canonical_text": "deleted_at is null",
        "ast_hash": [
          206,
          56,
          125,
          133,
          162,
          83,
          46,
          55,
          186,
          39,
          140,
          61,
          217,
          200,
          84,
          91,
          177,
          13,
          151,
          166,
          154,
          34,
          148,
          7,
          59,
          196,
          197,
          173,
          7,
          196,
          57,
          158
        ]
      },
      "tablespace": null,
      "comment": null,
      "storage": {
        "fillfactor": null,
        "fastupdate": null,
        "gin_pending_list_limit": null,
        "buffering": null,
        "deduplicate_items": null,
        "pages_per_range": null,
        "autosummarize": null,
        "extra": {}
      }
    },
    {
      "qname": {
        "schema": "app",
        "name": "users_email_idx"
      },
      "on": {
        "kind": "table",
        "schema": "app",
        "name": "users"
      },
      "method": "b_tree",
      "columns": [
        {
          "expr": {
            "column": "email"
          },
          "collation": null,
          "opclass": null,
          "sort_order": "asc",
          "nulls_order": "nulls_last"
        }
      ],
      "include": [],
      "unique": false,
      "nulls_not_distinct": false,
      "predicate": null,
      "tablespace": null,
      "comment": null,
      "storage": {
        "fillfactor": null,
        "fastupdate": null,
        "gin_pending_list_limit": null,
        "buffering": null,
        "deduplicate_items": null,
        "pages_per_range": null,
        "autosummarize": null,
        "extra": {}
      }
    },
    {
      "qname": {
        "schema": "app",
        "name": "users_email_lower_idx"
      },
      "on": {
        "kind": "table",
        "schema": "app",
        "name": "users"
      },
      "method": "b_tree",
      "columns": [
        {
          "expr": {
            "expression": {
              "canonical_text": "lower(email)",
              "ast_hash": [
                240,
                167,
                200,
                202,
                93,
                150,
                155,
                180,
                198,
                3,
                176,
                180,
                140,
                184,
                230,
                63,
                160,
                165,
                51,
                105,
                109,
                49,
                191,
                15,
                158,
                28,
                199,
                220,
                171,
                183,
                9,
                216
              ]
            }
          },
          "collation": null,
          "opclass": null,
          "sort_order": "asc",
          "nulls_order": "nulls_last"
        }
      ],
      "include": [],
      "unique": false,
      "nulls_not_distinct": false,
      "predicate": null,
      "tablespace": null,
      "comment": null,
      "storage": {
        "fillfactor": null,
        "fastupdate": null,
        "gin_pending_list_limit": null,
        "buffering": null,
        "deduplicate_items": null,
        "pages_per_range": null,
        "autosummarize": null,
        "extra": {}
      }
    },
    {
      "qname": {
        "schema": "app",
        "name": "users_email_uniq"
      },
      "on": {
        "kind": "table",
        "schema": "app",
        "name": "users"
      },
      "method": "b_tree",
      "columns": [
        {
          "expr": {
            "column": "email"
          },
          "collation": null,
          "opclass": null,
          "sort_order": "asc",
          "nulls_order": "nulls_last"
        }
      ],
      "include": [],
      "unique": true,
      "nulls_not_distinct": false,
      "predicate": null,
      "tablespace": null,
      "comment": null,
      "storage": {
        "fillfactor": null,
        "fastupdate": null,
        "gin_pending_list_limit": null,
        "buffering": null,
        "deduplicate_items": null,
        "pages_per_range": null,
        "autosummarize": null,
        "extra": {}
      }
    },
    {
      "qname": {
        "schema": "app",
        "name": "users_email_with_name"
      },
      "on": {
        "kind": "table",
        "schema": "app",
        "name": "users"
      },
      "method": "b_tree",
      "columns": [
        {
          "expr": {
            "column": "email"
          },
          "collation": null,
          "opclass": null,
          "sort_order": "asc",
          "nulls_order": "nulls_last"
        }
      ],
      "include": [
        "name"
      ],
      "unique": true,
      "nulls_not_distinct": false,
      "predicate": null,
      "tablespace": null,
      "comment": null,
      "storage": {
        "fillfactor": null,
        "fastupdate": null,
        "gin_pending_list_limit": null,
        "buffering": null,
        "deduplicate_items": null,
        "pages_per_range": null,
        "autosummarize": null,
        "extra": {}
      }
    }
  ],
  "sequences": [],
  "views": [],
  "materialized_views": [],
  "types": [],
  "functions": [],
  "procedures": [],
  "triggers": [],
  "publications": [],
  "statistics": [],
  "subscriptions": [],
  "default_privileges": []
}
