---
source: crates/core/tests/extractors_snapshots.rs
assertion_line: 143
expression: body
input_file: crates/core/tests/fixtures/extractors/sql/users.sql
---
{
"defs": [
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:0",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
0,
252
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "schema",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
254,
285
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:288",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
288,
526
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
527,
707
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:id",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
556,
584
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:573",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
573,
584
],
"signature": "primary key",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:email",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
590,
622
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:607",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
607,
615
],
"signature": "not null",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:616",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
616,
622
],
"signature": "unique",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:name",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
628,
653
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:645",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
645,
653
],
"signature": "not null",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:created_at",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
659,
705
],
"signature": "timestamptz",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:683",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
683,
691
],
"signature": "not null",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users/constraint:692",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"position": [
692,
705
],
"signature": "default",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:710",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
710,
785
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
786,
845
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts/column:id",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts",
"position": [
824,
843
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts/constraint:832",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts",
"position": [
832,
843
],
"signature": "primary key",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:848",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
848,
918
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
919,
1079
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/column:user_id",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
952,
1017
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:966",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
966,
974
],
"signature": "not null",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:975",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
975,
1017
],
"signature": "foreign key",
"visibility": ""
},
{
"binding": "local",
"kind": "column",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/column:tag",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
1023,
1045
],
"signature": "text",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:1037",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
1037,
1045
],
"signature": "not null",
"visibility": ""
},
{
"binding": "local",
"kind": "constraint",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:1051",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"position": [
1051,
1077
],
"signature": "primary key",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1082",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1082,
1155
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1212",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1212,
1327
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
1328,
1460
],
"signature": "p_email:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1463",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1463,
1644
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
1645,
2208
],
"signature": "p_email:text,p_name:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:2211",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2211,
2339
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
2340,
2575
],
"signature": "p_tag:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:2578",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2578,
2692
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "view",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/view:recent_users",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users/schema:app",
"position": [
2693,
2819
],
"signature": "",
"visibility": ""
}
],
"refs": [
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:id",
"kind": "uses_type",
"position": [
568,
572
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:email",
"kind": "uses_type",
"position": [
602,
606
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:name",
"kind": "uses_type",
"position": [
640,
644
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:created_at",
"kind": "uses_type",
"position": [
671,
682
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:timestamptz"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:UserAccounts/column:id",
"kind": "uses_type",
"position": [
827,
831
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/column:user_id",
"kind": "uses_type",
"position": [
961,
965
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:975",
"kind": "references",
"position": [
986,
995
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/constraint:975",
"kind": "references",
"position": [
996,
998
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users/column:id"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags/column:tag",
"kind": "uses_type",
"position": [
1032,
1036
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "uses_type",
"position": [
1364,
1368
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "uses_type",
"position": [
1378,
1382
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "calls",
"position": [
12,
12
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:lower"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "calls",
"position": [
18,
18
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:split_part"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1685,
1689
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1698,
1702
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1712,
1721
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/type:users"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "calls",
"position": [
7,
7
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(text)"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "reads",
"position": [
29,
38
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "writes",
"position": [
12,
21
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "uses_type",
"position": [
2381,
2385
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "uses_type",
"position": [
2395,
2410
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/type:users"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "reads",
"position": [
25,
34
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "reads",
"position": [
46,
59
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/view:recent_users",
"kind": "reads",
"position": [
2761,
2770
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/table:users"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/view:recent_users",
"kind": "calls",
"position": [
2794,
2794
],
"receiver_hint": "",
"to": "code+moniker://app/sdk:sql/path:pg_catalog/path:now"
}
],
"root": "code+moniker://app/lang:sql/module:users"
}