{
  "schemas": [
    {
      "name": "app",
      "comment": null,
      "owner": "pgevolve",
      "grants": []
    }
  ],
  "extensions": [],
  "tables": [
    {
      "qname": {
        "schema": "app",
        "name": "orgs"
      },
      "columns": [
        {
          "name": "id",
          "ty": {
            "kind": "big_int"
          },
          "nullable": false,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        },
        {
          "name": "name",
          "ty": {
            "kind": "text"
          },
          "nullable": false,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        }
      ],
      "constraints": [
        {
          "qname": {
            "schema": "app",
            "name": "orgs_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": {}
      }
    },
    {
      "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": "org_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": "age",
          "ty": {
            "kind": "integer"
          },
          "nullable": true,
          "default": null,
          "identity": null,
          "generated": null,
          "collation": null,
          "storage": null,
          "compression": null,
          "comment": null
        }
      ],
      "constraints": [
        {
          "qname": {
            "schema": "app",
            "name": "users_age_check"
          },
          "kind": {
            "kind": "check",
            "expression": {
              "canonical_text": "age >= 0",
              "ast_hash": [
                79,
                86,
                78,
                57,
                66,
                135,
                87,
                95,
                197,
                239,
                220,
                154,
                12,
                201,
                134,
                187,
                72,
                248,
                151,
                115,
                151,
                247,
                61,
                174,
                150,
                232,
                213,
                255,
                213,
                223,
                101,
                26
              ]
            },
            "no_inherit": false
          },
          "deferrable": {
            "kind": "not_deferrable"
          },
          "comment": null
        },
        {
          "qname": {
            "schema": "app",
            "name": "users_email_key"
          },
          "kind": {
            "kind": "unique",
            "columns": [
              "email"
            ],
            "include": [],
            "nulls_distinct": true
          },
          "deferrable": {
            "kind": "not_deferrable"
          },
          "comment": null
        },
        {
          "qname": {
            "schema": "app",
            "name": "users_org_id_fkey"
          },
          "kind": {
            "kind": "foreign_key",
            "columns": [
              "org_id"
            ],
            "referenced_table": {
              "schema": "app",
              "name": "orgs"
            },
            "referenced_columns": [
              "id"
            ],
            "on_update": "no_action",
            "on_delete": "cascade",
            "match_type": "simple"
          },
          "deferrable": {
            "kind": "not_deferrable"
          },
          "comment": null
        },
        {
          "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": [],
  "sequences": [],
  "views": [],
  "materialized_views": [],
  "types": [],
  "functions": [],
  "procedures": [],
  "triggers": [],
  "publications": [],
  "statistics": [],
  "subscriptions": [],
  "default_privileges": []
}
