The decoded graphitron reading

Prefix: graphitron_.

What the generator understands the author to have asked for. Each row is the decoded reading of one directive application: the same information that stands in the schema documents, restated in the generator’s own vocabulary so later questions can be asked with plain joins instead of re-parsing strings. Decoding is tolerant: a value that does not fit the declared shape is quarantined rather than lost.

Where to start

graphitron_table: @table on a type: the author binds the type to a database table.
graphitron_field_reference: @reference on a field or input field: one row per application, because an application is a fact of its own.
graphitron_undecoded_argument: The tolerant-decode overflow: a graphitron application argument whose literal does not fit the declared shape decodes to NULL in its typed column and quarantines its raw text here, so the authored value is never lost and the malformed-literal detection has its row.

How this family meets the others

The normalization crossings declared for this family: rules by which a name written in one family’s vocabulary is matched against another’s census. Declared rows rather than a closed set, so a crossing nobody has declared does not appear here.

Declared crossings

intent_argmapping_key_column_candidate (graphitron_ spellings against the sql_ census): An argMapping path segment meets column names case-insensitively along the binding walk.
intent_field_reference_step_hop (graphitron_ spellings against the sql_ census): A written key reference meets the constraint census case-insensitively under the resolver’s namespace precedence: a qualifier binds hard, the SQL constraint name answers first, and the generated Keys-class constant is eligible only where no SQL constraint answers the name.
intent_spelled_table (graphitron_ spellings against the sql_ census): A written table reference meets the catalog census by case-insensitive match on pre-normalized spelling columns, one row per candidate.

Declared key edges

store_: 2 foreign keys from this family’s rows into that one.
graphql_: 49 foreign keys from this family’s rows into that one.

Why the name is right

What graphitron makes of the SDL document: the decoded directives, and the provenance of the rows macro expansion mints. A row here is a decode of a captured application rather than a conclusion drawn about the schema: it says what a directive application spelled, in graphitron’s vocabulary instead of the document’s. That makes it a derivation whose producer runs at capture cadence, not a second transcription.

graphitron_argument_binding

@field on an argument: the filter argument’s bound column.

Primary key: (graph_name, type_name, field_name, argument_name). Foreign key: (graph_name, type_name, field_name, argument_name) references graphql_argument_coordinate (graph_name, type_name, field_name, argument_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
name_ref (CHARACTER VARYING, not null): the name argument as written
name_ref_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_column’s column_name_upper and jooq_name_upper. Generated, so nothing writes it and nothing can. It exists for the reason its field-site twin does: an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_argument_condition

@condition on an argument: the same decode over the three-part coordinate.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
override (BOOLEAN, nullable): as written; NULL when omitted (the FALSE default is derivable)

graphitron_argument_condition_arg_mapping_pair

An ordered pair of an argument-site @condition’s argMapping. Position-keyed so an author’s duplicate parameter survives for the duplicate detection.

Primary key: (graph_name, type_name, field_name, argument_name, position). Foreign key: (graph_name, type_name, field_name, argument_name) references graphitron_argument_condition (graph_name, type_name, field_name, argument_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_argument_condition_context_arg

An ordered context argument of an argument-site @condition.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
position (INTEGER, not null): 0-based position within the owning list
name (CHARACTER VARYING, not null): the context argument name as written

graphitron_argument_lookup_key

@lookupKey on an argument: the live site, a marker.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_argument_node_id

@nodeId on an argument.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
node_type_ref (CHARACTER VARYING, nullable): the typeName argument as written; author-spelled, no FK

graphitron_argument_path_segment

What a dotted argMapping right-hand side is made of: one row per segment of one path, in order, as one site decoded it. The seven pair relations of this family each store such a path as a single string, and this states its decomposition at the coordinate whose site spelled it, so a reader asking which paths a field’s mappings segment into asks this relation instead of joining on a bare string. It anchors on graphql_field, whose key is the triple all seven owners lead with, rather than on any one of them: the coordinate is what the owners share, and picking one as the parent would be choosing a site for a fact that has several. Which of the seven a segment set came from is therefore not answered here, and a consumer needing it joins the pair relation on the coordinate and the path. A path text several coordinates spell is decomposed once per coordinate, and that duplication is deliberate rather than tolerated: argument_path with position determines segment_name totally, off a column in the same row, so there is no independently updatable fact for two copies to disagree about and no update anomaly for a normalisation to prevent. It is the same trade the folded companion columns elsewhere in this schema make, a derived duplicate kept because its invariant is structural. The value-keyed alternative reads as the tidier one and is not: a path text no relation declares gives the segments no owner to be constrained against, so a set nothing spells any more is not merely unreferenced but unconstrainable, and no question can be asked of it at a coordinate. Capture writes it because the parse that produces the pair rows already holds the segments and joins them back into a column, so the decomposition is something capture has in hand and throws away, not something a reader could recover: splitting a string is outside what this schema asks of a view, on intent_input_occurrence_path’s terms. Positions are dense from zero and the segments in order rejoin the path exactly, the lexer admitting no dot inside a segment, so the relation and the column it decodes cannot say different things. A bare argument name is one row rather than none, a single-segment decode being a decode.

Primary key: (graph_name, type_name, field_name, argument_path, position). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type the spelling site sits on; with the field below, the coordinate that owns this decode
field_name (CHARACTER VARYING, not null): the field name within the owning type; the coordinate all seven pair relations lead with, which is what makes this relation reachable from every one of them
argument_path (CHARACTER VARYING, not null): the path as written, spelled exactly as the pair relations of this family spell it; a pair row reaches its own decode by joining on the coordinate and this column, which is a coordinate join rather than a match on a bare string
position (INTEGER, not null): 0-based position of the segment within the path, dense from zero
segment_name (CHARACTER VARYING, not null): the segment itself, one name carrying no dot. Position zero is the head, naming an argument of the field the directive sits on, and each further position descends through an input-object field of the one before it; which of those a segment resolves to is a question for the derived stratum, and this relation only says what was written
segment_name_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against a node type’s resolved key columns where a trailing segment names one, which intent_resolved_node_key_projection spells. Generated, so nothing writes it and nothing can. An authored spelling is folded here for that crossing alone, which is the only reason anything in this schema is folded; a segment naming a GraphQL argument or input field is matched exactly, those names being case-sensitive in the language

graphitron_argument_reference

@reference on an argument: the same family over the three-part coordinate.

Primary key: (graph_name, type_name, field_name, argument_name, ordinal). Foreign key: (graph_name, type_name, field_name, argument_name) references graphql_argument_coordinate (graph_name, type_name, field_name, argument_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): capture-assigned position in document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_argument_reference_for

@referenceFor on an argument: the same family over the four-part coordinate. A sibling relation rather than an argument_name column on graphitron_reference_for, on the discipline the argument-site @reference family already keeps: the two coordinates are different lengths, so one relation over both would carry a column NULL by kind on half its rows and every reader would have to say which kind it meant. The participant set this row’s spelling is checked against is the consuming field’s own, which at this coordinate is the field the argument sits on rather than a set reached through the occurrence paths, so the whole-schema detection the input-field population needs is a local join here.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): capture-assigned position in document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
participant_type_ref (CHARACTER VARYING, not null): the type argument as written; author-spelled, no FK. Names a participant of the polymorphic type the owning field returns

graphitron_argument_reference_for_step

An ordered path element of one argument-site @referenceFor application: the participant’s complete path, read as the same element grammar as @reference. The direction is the coordinate’s and not this relation’s: at the one coordinate an argument-site application is admitted on today, a @nodeId decode leaf, the path departs the participant’s own table and reaches the decoded target’s.

Primary key: (graph_name, type_name, field_name, argument_name, ordinal, position). Foreign key: (graph_name, type_name, field_name, argument_name, ordinal) references graphitron_argument_reference_for (graph_name, type_name, field_name, argument_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): the owning @referenceFor application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
table_ref (CHARACTER VARYING, nullable): the table name as written (may carry a schema qualifier)
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
key_ref (CHARACTER VARYING, nullable): the constraint name as written (may carry a schema qualifier)
key_ref_namespace_part (CHARACTER VARYING, nullable): left of key_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it. This qualifier does not name the constraint’s own schema, because a constraint has none: it is scoped to its table, which is why sql_constraint takes its schema through the table. It names which schema’s table holds the constraint, disambiguating a constraint name that occurs in more than one, and the resolver reads it that way. Which namespace that is is dialect-dependent (the schema namespace in Oracle, the table namespace in PostgreSQL), which is why the column is not called a schema part
key_ref_name_part (CHARACTER VARYING, nullable): right of key_ref’s first period, or the whole value when none; joins sql_constraint.constraint_name narrowed by the source table the walk is standing on, not by this row alone
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint.table_schema_upper, the schema of the table holding the constraint. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint’s constraint_name_upper and jooq_name_upper, in that precedence. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_argument_reference_for_step_arg_mapping_pair

An ordered pair of an argument-site @referenceFor step condition’s argMapping. Capture is total across every SDL-legal location, so this relation is populated wherever the grammar admits a condition step even though the one coordinate consuming an argument-site application today rejects condition steps: the scoping is the validator’s, which is what lets a later widening be a validator change alone.

Primary key: (graph_name, type_name, field_name, argument_name, ordinal, step_position, position). Foreign key: (graph_name, type_name, field_name, argument_name, ordinal, step_position) references graphitron_argument_reference_for_step (graph_name, type_name, field_name, argument_name, ordinal, position).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): the owning @referenceFor application’s ordinal
step_position (INTEGER, not null): 0-based position of the owning step within its application’s path
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_argument_reference_step

An ordered path element of one argument-site @reference application; the step’s ExternalCodeReference condition flattens in place.

Primary key: (graph_name, type_name, field_name, argument_name, ordinal, position). Foreign key: (graph_name, type_name, field_name, argument_name, ordinal) references graphitron_argument_reference (graph_name, type_name, field_name, argument_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): the owning @reference application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
table_ref (CHARACTER VARYING, nullable): the table name as written (may carry a schema qualifier)
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
key_ref (CHARACTER VARYING, nullable): the constraint name as written (may carry a schema qualifier)
key_ref_namespace_part (CHARACTER VARYING, nullable): left of key_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it. This qualifier does not name the constraint’s own schema, because a constraint has none: it is scoped to its table, which is why sql_constraint takes its schema through the table. It names which schema’s table holds the constraint, disambiguating a constraint name that occurs in more than one, and the resolver reads it that way. Which namespace that is is dialect-dependent (the schema namespace in Oracle, the table namespace in PostgreSQL), which is why the column is not called a schema part
key_ref_name_part (CHARACTER VARYING, nullable): right of key_ref’s first period, or the whole value when none; joins sql_constraint.constraint_name narrowed by the source table the walk is standing on, not by this row alone
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint.table_schema_upper, the schema of the table holding the constraint. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint’s constraint_name_upper and jooq_name_upper, in that precedence. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_argument_reference_step_arg_mapping_pair

An ordered pair of an argument-site @reference step condition’s argMapping.

Primary key: (graph_name, type_name, field_name, argument_name, ordinal, step_position, position). Foreign key: (graph_name, type_name, field_name, argument_name, ordinal, step_position) references graphitron_argument_reference_step (graph_name, type_name, field_name, argument_name, ordinal, position).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
ordinal (INTEGER, not null): the owning @reference application’s ordinal
step_position (INTEGER, not null): 0-based position of the owning step within its application’s path
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_connection

@asConnection on a field: the macro’s spec, as authored. The expansion’s output is provenance-marked rows in the graphql_ tables, below.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
default_first_value (INTEGER, nullable): as written; NULL when omitted
connection_name (CHARACTER VARYING, nullable): the deprecated shared-type override, as written; honoured by the expansion, deprecation is a lint detection

graphitron_default_order

@defaultOrder on a field: the same specification shape plus the directive-level direction that serves as the per-entry fallback.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
index_ref (CHARACTER VARYING, nullable): the database index name as written
primary_key (BOOLEAN, nullable): as written; NULL when omitted
direction (CHARACTER VARYING, nullable): as written; open column, the ASC default is a derivation

graphitron_default_order_field

An ordered FieldSort entry of a @defaultOrder.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_default_order (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position within the owning list
name_ref (CHARACTER VARYING, not null): the name argument as written
collate (CHARACTER VARYING, nullable): the collation as written, when declared
direction (CHARACTER VARYING, nullable): the sort direction as written; author-spelled enum literal, open column

graphitron_discriminate

@discriminate on an interface or union: the discriminator column.

Primary key: (graph_name, type_name). Foreign key: (graph_name, type_name) references graphql_type_coordinate (graph_name, type_name). Foreign key: (graph_name, type_name, source_name, declaration_line, declaration_column) references graphql_type_declaration (graph_name, type_name, source_name, source_line, source_column).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
on_column (CHARACTER VARYING, not null): the on: argument as written; catalog resolution is a derivation

graphitron_discriminator

@discriminator on an object type: the participant’s discriminator value.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
discriminator_value (CHARACTER VARYING, not null): the value: argument as written (VALUE alone is an H2 reserved word)

graphitron_enum

@enum on an enum type. The full ExternalCodeReference is captured as written, though today only arg_mapping is consumed (to reject a non-blank value; the Java binding is derived by reflection and the per-value mapping comes from graphitron_enum_value_binding).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): enumReference.className as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): structurally inert here; raw column only, no pair child

graphitron_enum_value_binding

@field on an enum value: the database string (or Java constant) the value maps to. The pivot vocabulary decode reads this relation too.

Primary key: (graph_name, type_name, value_name). Foreign key: (graph_name, type_name, value_name) references graphql_enum_value_coordinate (graph_name, type_name, value_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
value_name (CHARACTER VARYING, not null): the enum value name within the owning enum type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
name_ref (CHARACTER VARYING, not null): the name argument as written

graphitron_error

@error on an object type: presence; the handlers list decodes into the ordered child, and every cross-field handler rule is a detection.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_error_handler

An ordered ErrorHandler of an @error application.

Primary key: (graph_name, type_name, position). Foreign key: (graph_name, type_name) references graphitron_error (graph_name, type_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
position (INTEGER, not null): 0-based position within the owning list
handler (CHARACTER VARYING, not null): GENERIC / DATABASE / VALIDATION as written; open column
class_name (CHARACTER VARYING, nullable): the exception class as written
code (CHARACTER VARYING, nullable): the database error code the handler matches on
sql_state (CHARACTER VARYING, nullable): the SQL state code the handler matches on
matches (CHARACTER VARYING, nullable): a substring the exception message must contain
description (CHARACTER VARYING, nullable): SDL description string, when the author wrote one

graphitron_external_field

@externalField on a field: the static jOOQ-Field method. The omitted-method fallback (the field name) is a derivation; arg_mapping is inert here (raw column only, its rejection is presence-triggered).

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode

graphitron_facet

@asFacet on an input field: a marker; the bound column comes from graphitron_field_binding, and every misuse arm is a detection.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_federation_key

Federation @key as the author wrote it, decoded for consumption (its verbatim twin lives in graphql_type_directive for re-emission; a gate query pins agreement). Authored applications alone, which is what this family’s charter says a decode is: the key federation synthesizes for a node type is a derivation over these rows and the node metadata, and it lives in intent_synthesized_federation_key. A reader wanting every key the emitted schema carries reads intent_federation_key, which unions the two.

Primary key: (graph_name, type_name, ordinal). Foreign key: (graph_name, type_name) references graphql_type_coordinate (graph_name, type_name). Foreign key: (graph_name, type_name, source_name, declaration_line, declaration_column) references graphql_type_declaration (graph_name, type_name, source_name, source_line, source_column).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
ordinal (INTEGER, not null): @key is repeatable; document order
source_name (CHARACTER VARYING, not null): the applying declaration site, which every row here has, the relation holding authored applications alone
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
fields_sdl (CHARACTER VARYING, not null): the field-set literal as written
resolvable (BOOLEAN, nullable): as written; NULL when omitted

graphitron_federation_key_field

An ordered element of a @key field set (the field-set grammar is a parse boundary, so the decode happens at capture). One row per leaf selection, in written order, and the row is the position alone: what the selection names is the segment child, because the grammar admits nesting and a decoded grammar lands as rows rather than as a rendered string. A top-level selection is one segment, so the child is never empty. That today’s consumer rejects nesting is a detection, not a capture limit.

Primary key: (graph_name, type_name, ordinal, position). Foreign key: (graph_name, type_name, ordinal) references graphitron_federation_key (graph_name, type_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
ordinal (INTEGER, not null): capture-assigned position in document order
position (INTEGER, not null): 0-based within the field set

graphitron_federation_key_field_segment

What one @key selection names, segment by segment: the nesting the field-set parser computes, recorded rather than rendered. A reader asking which leaf a key selects, and under what parent, joins instead of splitting a dotted string, which is the whole reason the parser’s prefix stack reaches the store at all. Positions are dense from zero and a selection always has a position-zero segment, an unnested one having only that.

Primary key: (graph_name, type_name, ordinal, position, segment_position). Foreign key: (graph_name, type_name, ordinal, position) references graphitron_federation_key_field (graph_name, type_name, ordinal, position).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
ordinal (INTEGER, not null): the owning @key application’s ordinal
position (INTEGER, not null): the owning selection’s 0-based position within the field set
segment_position (INTEGER, not null): 0-based position of the segment within the selection, dense from zero; position zero names a field of the type the @key sits on, and each further position descends into the one before it
segment_name (CHARACTER VARYING, not null): the segment itself, one name carrying no dot; what a reader would otherwise have recovered by splitting a path

graphitron_field_binding

@field on an output or input-object field: the slot’s bound name. A column, a Java accessor, or a Java member depending on the backing, which is classification’s business; the $source / $errors sigil forms are stored as written, their recognition being a prefix test SQL can express.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the application’s own position, here and below
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
name_ref (CHARACTER VARYING, not null): the name argument as written
name_ref_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_column’s column_name_upper and jooq_name_upper. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_field_condition

@condition on a field or input field (shared coordinate; the parent kind decides which SDL site this was).

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): ExternalCodeReference.className as written
method (CHARACTER VARYING, nullable): ExternalCodeReference.method as written
arg_mapping (CHARACTER VARYING, nullable): ExternalCodeReference.argMapping as written; the pair child below is its decode, the type_sdl-plus-decode pattern
override (BOOLEAN, nullable): as written; NULL when omitted (the FALSE default is derivable)

graphitron_field_condition_arg_mapping_pair

An ordered pair of a field-site @condition’s argMapping. Position-keyed so an author’s duplicate parameter survives for the duplicate detection.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_field_condition (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java parameter (left side)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_field_condition_context_arg

An ordered context argument of a field-site @condition.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_field_condition (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position in the contextArguments list
name (CHARACTER VARYING, not null): the context argument name as written

graphitron_field_lookup_key

@lookupKey on an input field: the retired site; the sole consumer is the located migration rejection.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_field_node_id

@nodeId on a field or input field.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
node_type_ref (CHARACTER VARYING, nullable): typeName as written; author-spelled type reference, no FK, inference when NULL is a derivation

graphitron_field_reference

@reference on a field or input field: one row per application, because an application is a fact of its own. An empty path means FK auto-discovery between the endpoints, and the rule that every application in a multi-application chain must carry an element is per-application; both are invisible in a flat concatenated chain. The effective chain the consumers read is the steps ordered by (ordinal, position), and the written-order interleaving with @routine applications on the same field is an ORDER BY over the two relations' source positions.

Primary key: (graph_name, type_name, field_name, ordinal). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): repeatable; document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_field_reference_step

An ordered path element of one @reference application; the step’s ExternalCodeReference condition flattens in place.

Primary key: (graph_name, type_name, field_name, ordinal, position). Foreign key: (graph_name, type_name, field_name, ordinal) references graphitron_field_reference (graph_name, type_name, field_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @reference application’s ordinal
position (INTEGER, not null): 0-based within the application’s path
table_ref (CHARACTER VARYING, nullable): ReferenceElement.table as written (may carry a schema qualifier); it resolves through findTable, the same route the argument-site sibling takes
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
key_ref (CHARACTER VARYING, nullable): ReferenceElement.key as written (may carry a schema qualifier)
key_ref_namespace_part (CHARACTER VARYING, nullable): left of key_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it. This qualifier does not name the constraint’s own schema, because a constraint has none: it is scoped to its table, which is why sql_constraint takes its schema through the table. It names which schema’s table holds the constraint, disambiguating a constraint name that occurs in more than one, and the resolver reads it that way. Which namespace that is is dialect-dependent (the schema namespace in Oracle, the table namespace in PostgreSQL), which is why the column is not called a schema part
key_ref_name_part (CHARACTER VARYING, nullable): right of key_ref’s first period, or the whole value when none; joins sql_constraint.constraint_name narrowed by the source table the walk is standing on, not by this row alone
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint.table_schema_upper, the schema of the table holding the constraint. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint’s constraint_name_upper and jooq_name_upper, in that precedence. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_field_reference_step_arg_mapping_pair

An ordered pair of a step condition’s argMapping.

Primary key: (graph_name, type_name, field_name, ordinal, step_position, position). Foreign key: (graph_name, type_name, field_name, ordinal, step_position) references graphitron_field_reference_step (graph_name, type_name, field_name, ordinal, position).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @reference application’s ordinal
step_position (INTEGER, not null): 0-based position of the owning step within its application’s path
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_field_synthesis

A field’s type expression was rewritten by a macro; the expression the field was written with survives here while the field’s graphql_field row holds the expansion’s result.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name). Check: "MACRO" = 'CONNECTION'.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
macro (CHARACTER VARYING, not null): which expansion rewrote the type expression
authored_type_sdl (CHARACTER VARYING, not null): the type expression as the author wrote it, pre-expansion

graphitron_index

@index on an enum value: the deprecated alias of @order(index:), still honoured when @order is absent; the deprecation is a lint detection.

Primary key: (graph_name, type_name, value_name). Foreign key: (graph_name, type_name, value_name) references graphql_enum_value_coordinate (graph_name, type_name, value_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
value_name (CHARACTER VARYING, not null): the enum value name within the owning enum type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
index_ref (CHARACTER VARYING, nullable): the name argument, which the declaration leaves optional

graphitron_link

@link on the schema definition, decoded. All @link applications decode here (the verbatim twin sits in graphql_schema_directive); whether a link is the federation opt-in is a predicate over url, a derivation. @tag and @shareable get no decoded relations: their only readers are the expansion machinery itself, which is the capture walk with the AST in hand, so downstream consumers see them only as fidelity rows for re-emission.

Primary key: (graph_name, ordinal). Foreign key: (graph_name) references store_graph (graph_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
ordinal (INTEGER, not null): @link is repeatable; document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
url (CHARACTER VARYING, nullable): as written

graphitron_link_import

An ordered import entry of an @link, covering both the string form and the object form.

Primary key: (graph_name, link_ordinal, position). Foreign key: (graph_name, link_ordinal) references graphitron_link (graph_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
link_ordinal (INTEGER, not null): the owning @link application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
name (CHARACTER VARYING, not null): the imported name (the object form’s name:)
alias (CHARACTER VARYING, nullable): the object form’s as:, when written

graphitron_multitable_reference

@multitableReference (removed) on a field; routes is never read.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_mutation

@mutation on a field: the DML statement spec.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
operation (CHARACTER VARYING, not null): the typeName argument as written (INSERT / UPDATE / DELETE / UPSERT); open column per the enum-literal rule
multi_row (BOOLEAN, nullable): as written; NULL when omitted
table_ref (CHARACTER VARYING, nullable): the table argument as written (may carry a schema qualifier); it names the write target of a DELETE, INSERT or UPDATE, the three verbs the resolver accepts it for, and resolves through the same qualified-name route a @table binding takes
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_node

@node on an object type: node identity. The type-name fallback for typeId and the catalog-PK fallback for key columns are derivations; the SDL-versus-jOOQ-metadata precedence rules are detections.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
type_id (CHARACTER VARYING, nullable): as written

graphitron_node_key_column

An ordered keyColumns entry of an @node.

Primary key: (graph_name, type_name, position). Foreign key: (graph_name, type_name) references graphitron_node (graph_name, type_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
position (INTEGER, not null): 0-based position within the owning list
column_ref (CHARACTER VARYING, not null): the key column as written

graphitron_order

@order on an enum value: a sorting specification. The exactly-one-of rule over index, fields, and primaryKey is a detection.

Primary key: (graph_name, type_name, value_name). Foreign key: (graph_name, type_name, value_name) references graphql_enum_value_coordinate (graph_name, type_name, value_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
value_name (CHARACTER VARYING, not null): the enum value name within the owning enum type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
index_ref (CHARACTER VARYING, nullable): database index name as written
primary_key (BOOLEAN, nullable): as written; NULL when omitted

graphitron_order_by

@orderBy on an argument: a marker; the input shape rules are detections.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
argument_name (CHARACTER VARYING, not null): the argument name within the owning field
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_order_field

An ordered FieldSort entry of an @order.

Primary key: (graph_name, type_name, value_name, position). Foreign key: (graph_name, type_name, value_name) references graphitron_order (graph_name, type_name, value_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
value_name (CHARACTER VARYING, not null): the enum value name within the owning enum type
position (INTEGER, not null): 0-based position within the owning list
name_ref (CHARACTER VARYING, not null): FieldSort.name, a column reference as written
collate (CHARACTER VARYING, nullable): the collation as written, when declared
direction (CHARACTER VARYING, nullable): as written; author-spelled enum literal, open column

graphitron_pivot

@pivot on a field: the aggregate-projection spec.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
on_column (CHARACTER VARYING, not null): the on: argument, the discriminator column as written
value_column (CHARACTER VARYING, not null): the value: argument as written
vocabulary_ref (CHARACTER VARYING, nullable): names an enum type; author-spelled, no FK

graphitron_record

@record (deprecated, ignored) on an object or input type. class_name is the one payload value a consumer reads: the warning arms compare it against the reflected backing class.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): record.className as written

graphitron_reference_for

@referenceFor at a field coordinate: an explicit join path for one participant of a multi-table interface or union. Two populations share the relation, and they share it because graphql_field spans both: an output field, where the path runs from the parent’s table to the participant’s, and a @nodeId filter input field, where it runs from the participant’s own table to the decoded target’s. Which of the two a row is about is a fact of the owning coordinate’s type kind and is not restated as a column here, on graphql_field’s own terms: the join decides. Keyed by ordinal per the repeatable rule; the consumption-side keying by participant makes a repeated participant a detection, never a collision.

Primary key: (graph_name, type_name, field_name, ordinal). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): capture-assigned position in document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
participant_type_ref (CHARACTER VARYING, not null): the type argument as written; author-spelled, no FK. It names a participant of the polymorphic type the consuming field returns, and which field that is differs by coordinate: an output field consumes its own named type, while an input field is consumed by every field whose argument surface reaches it, possibly several with different participant sets. That is why a spelling matching no participant is a whole-schema detection over the occurrence paths rather than a check one row can carry, and why no FK could stand here even if the participant set were a relation: at an input coordinate there is no single consumer for it to point at.

graphitron_reference_for_step

An ordered path element of one @referenceFor application: the participant’s complete path from the parent’s table, read as the same element grammar as @reference.

Primary key: (graph_name, type_name, field_name, ordinal, position). Foreign key: (graph_name, type_name, field_name, ordinal) references graphitron_reference_for (graph_name, type_name, field_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @referenceFor application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
table_ref (CHARACTER VARYING, nullable): the table name as written (may carry a schema qualifier)
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
key_ref (CHARACTER VARYING, nullable): the constraint name as written (may carry a schema qualifier)
key_ref_namespace_part (CHARACTER VARYING, nullable): left of key_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it. This qualifier does not name the constraint’s own schema, because a constraint has none: it is scoped to its table, which is why sql_constraint takes its schema through the table. It names which schema’s table holds the constraint, disambiguating a constraint name that occurs in more than one, and the resolver reads it that way. Which namespace that is is dialect-dependent (the schema namespace in Oracle, the table namespace in PostgreSQL), which is why the column is not called a schema part
key_ref_name_part (CHARACTER VARYING, nullable): right of key_ref’s first period, or the whole value when none; joins sql_constraint.constraint_name narrowed by the source table the walk is standing on, not by this row alone
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint.table_schema_upper, the schema of the table holding the constraint. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
key_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_constraint’s constraint_name_upper and jooq_name_upper, in that precedence. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_reference_for_step_arg_mapping_pair

An ordered pair of a @referenceFor step condition’s argMapping.

Primary key: (graph_name, type_name, field_name, ordinal, step_position, position). Foreign key: (graph_name, type_name, field_name, ordinal, step_position) references graphitron_reference_for_step (graph_name, type_name, field_name, ordinal, position).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @referenceFor application’s ordinal
step_position (INTEGER, not null): 0-based position of the owning step within its application’s path
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_routine

@routine on a field: one row per application (repeatable). The table chain interleaves these with graphitron_field_reference rows in written order.

Primary key: (graph_name, type_name, field_name, ordinal). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): capture-assigned position in document order
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
routine_ref (CHARACTER VARYING, not null): the routine name as written (may carry a schema qualifier)
routine_ref_namespace_part (CHARACTER VARYING, nullable): left of routine_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a routine name this namespace is the SQL schema in every dialect jOOQ models as one. Written by capture, because splitting on a period is a decode and decodes happen there
routine_ref_name_part (CHARACTER VARYING, nullable): right of routine_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode
column_mapping (CHARACTER VARYING, nullable): the columnMapping string as written; the pair child is its decode
routine_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name, a routine result being a catalog table. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
routine_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name, a routine result being a catalog table. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_routine_arg_mapping_pair

An ordered pair of a @routine’s argMapping, binding a routine IN parameter to a GraphQL argument.

Primary key: (graph_name, type_name, field_name, ordinal, position). Foreign key: (graph_name, type_name, field_name, ordinal) references graphitron_routine (graph_name, type_name, field_name, ordinal).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @routine application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_routine_column_mapping_pair

columnMapping pairs bind routine parameters to previous-node columns; a dotted right side is captured as written and rejected by detection.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
ordinal (INTEGER, not null): the owning @routine application’s ordinal
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
column_ref (CHARACTER VARYING, not null): the previous-node column as written; a dotted right side is captured and rejected by detection

graphitron_scalar_type

@scalarType on a scalar: the Java constant backing it. Under registry capture the application is read like any other; the SDL pre-pass the current consumer needs (assembly strips directives off spec built-in redeclarations) dies with the assembled source.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): half of the site FK, so NOT NULL; a graphitron application always has an SDL position
declaration_line (INTEGER, not null): line of the contributing declaration site, keyed with source_name
declaration_column (INTEGER, not null): column of the contributing declaration site, the site key’s fourth part
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
scalar_ref (CHARACTER VARYING, not null): the fully-qualified Java constant reference as written

graphitron_service

@service on a field: the external service reference.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, nullable): the fully-qualified Java class name as written
method (CHARACTER VARYING, nullable): the Java method name as written
arg_mapping (CHARACTER VARYING, nullable): the argMapping string as written; the pair child is its decode

graphitron_service_arg_mapping_pair

An ordered pair of a @service’s argMapping, binding a Java method parameter to a GraphQL argument.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_service (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position within the owning list
param_name (CHARACTER VARYING, not null): the Java or routine parameter (left side of the pair)
argument_path (CHARACTER VARYING, not null): the right side as written, and written is the whole of what this column claims: capture records the author’s spelling verbatim and resolves nothing. A dot opens the thing at that position, and what a thing opens into depends on what it is: an input object opens into its fields, and an ID carrying @nodeId opens into the key columns of the node type it names, so a trailing segment may be a key column rather than a field of any SDL type. Which of those a segment turned out to be is intent_argmapping_segment_binding’s answer and the key projection’s beside it; enumerating the forms here would be a second statement of a resolution those views own, and the enumeration this column carried before the key-column form existed was exactly that mistake caught late. graphitron_argument_path_segment holds the decomposition, so nothing splits this string

graphitron_service_arg_mapping_sigil

A sigil entry of a @service’s argMapping, the sibling of graphitron_service_arg_mapping_pair for entries whose right-hand side is a recognized sigil rather than an argument path. A recognized sigil is a decode decision carried as a fact, not a string left for readers to re-peek: it must not land in the pair relation (whose argument_path is a closed two-alternative statement feeding dangling-author-reference detection) and must not quarantine as graphitron_undecoded_argument (a valid literal is not malformed overflow). The lifting happens before tokenization, through the same sigil owner the build-side parse uses, so the two sides cannot drift on what a sigil is.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_service (graph_name, type_name, field_name). Check: "SIGIL" = '$session'.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position among the argMapping’s sigil entries, document order
param_name (CHARACTER VARYING, not null): the Java parameter the sigil binds (left side of the entry)
sigil (CHARACTER VARYING, not null): the recognized sigil literal, a closed taxonomy: $session binds the parameter to the session handle the <sessionState> mount returned

graphitron_service_context_arg

An ordered contextArguments entry of a @service application; the value is supplied on the GraphQLContext at run time.

Primary key: (graph_name, type_name, field_name, position). Foreign key: (graph_name, type_name, field_name) references graphitron_service (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
position (INTEGER, not null): 0-based position within the owning list
name (CHARACTER VARYING, not null): the context argument name as written

graphitron_source_row

@sourceRow on a field: the parent-side key producer, a join key on a join-resolved field and a batch key on an @service one. Flat arguments by declaration, not an ExternalCodeReference.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention
class_name (CHARACTER VARYING, not null): the lifter class as written
method (CHARACTER VARYING, not null): the static lifter method name as written

graphitron_split_query

@splitQuery on a field: a marker.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_table

@table on a type: the author binds the type to a database table. On an INPUT_OBJECT the application is captured like any other; the ignored-and- warned status of that site is a detection.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the OBJECT, INPUT_OBJECT, or INTERFACE carrying @table
source_name (CHARACTER VARYING, not null): the applying declaration site (keyed with the line and column below); doubles as the file of the position columns
declaration_line (INTEGER, not null): line of the applying declaration site
declaration_column (INTEGER, not null): column of the applying declaration site
source_line (INTEGER, nullable): the application’s own position
source_column (INTEGER, nullable): the application’s own column
table_ref (CHARACTER VARYING, nullable): the name argument as written (may carry a schema qualifier); NULL when omitted, the type-name fallback is a derivation
table_ref_namespace_part (CHARACTER VARYING, nullable): left of table_ref’s first period, NULL when no period appeared and the empty string when one appeared with nothing before it; for a table name this namespace is the SQL schema in every dialect jOOQ models. Written by capture, because splitting on a period is a decode and decodes happen there
table_ref_name_part (CHARACTER VARYING, nullable): right of table_ref’s first period, or the whole value when none; the empty string when a period was written with nothing after it, which joins nothing and is meant to
type_name_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table.table_name_upper where @table(name:) was omitted and the type name stands in as a table spelling. Generated, so nothing writes it and nothing can. A GraphQL type name is folded here for that crossing alone; nothing compares one to another case-insensitively
table_ref_namespace_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded
table_ref_name_part_upper (CHARACTER VARYING, nullable): the upper-cased form of the column beside it, for the case-insensitive match against sql_table’s schema and name. Generated, so nothing writes it and nothing can. It exists because an authored spelling meets a catalog name here, which is the only reason anything in this schema is folded

graphitron_tenant_fan_out

@tenantFanOut on a field: a marker; its many conflict arms are detections.

Primary key: (graph_name, type_name, field_name). Foreign key: (graph_name, type_name, field_name) references graphql_field_coordinate (graph_name, type_name, field_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
field_name (CHARACTER VARYING, not null): the field name within the owning type
source_name (CHARACTER VARYING, nullable): the SDL file the row was captured from
source_line (INTEGER, nullable): source line, 1-based per the graphql-java convention
source_column (INTEGER, nullable): source column, 1-based per the graphql-java convention

graphitron_type_declaration_synthesis

A declaration site was contributed by a macro rather than the author: a definition site when the macro creates the type (Connection, Edge, facet shapes, at merge_ordinal 0), and an empty extension site when a later carrier touches a shared machinery type (PageInfo), so carrier multiplicity is the site count. Synthesized element rows hang off these sites through the ordinary declaration reference, which is what marks additions without per-element provenance; a type is synthesized exactly when its merge_ordinal-0 site is.

Primary key: (graph_name, type_name, source_name, source_line, source_column). Foreign key: (graph_name, type_name, source_name, source_line, source_column) references graphql_type_declaration (graph_name, type_name, source_name, source_line, source_column). Check: "MACRO" = 'CONNECTION'.

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
type_name (CHARACTER VARYING, not null): the GraphQL type this row is about
source_name (CHARACTER VARYING, not null): the causing application’s position, which is the site’s identity
source_line (INTEGER, not null): line of the causing application, which is the site’s identity
source_column (INTEGER, not null): the site key’s fourth part, as on graphql_type_declaration
macro (CHARACTER VARYING, not null): which expansion contributed the site
carrier_type_name (CHARACTER VARYING, nullable): the causing coordinate; NULL for schema-level causes (@link)
carrier_field_name (CHARACTER VARYING, nullable): the causing field coordinate; NULL for type- and schema-level causes

graphitron_undecoded_argument

The tolerant-decode overflow: a graphitron application argument whose literal does not fit the declared shape decodes to NULL in its typed column and quarantines its raw text here, so the authored value is never lost and the malformed-literal detection has its row. Empty while assembly runs upstream.

Primary key: (graph_name, source_name, source_line, source_column, directive_name, directive_argument_name). Foreign key: (graph_name) references store_graph (graph_name).

Columns

graph_name (CHARACTER VARYING, not null): the owning graph’s partition, anchored by store_graph; the leading key dimension that keeps one workspace’s graphs apart
source_name (CHARACTER VARYING, not null): the application’s position identifies the row; authored applications always have one
source_line (INTEGER, not null): line of the application carrying the undecodable literal
source_column (INTEGER, not null): column of the application carrying the undecodable literal
directive_name (CHARACTER VARYING, not null): the applied or defined directive name, without the leading @
directive_argument_name (CHARACTER VARYING, not null): the definition’s formal argument this value binds
value_sdl (CHARACTER VARYING, not null): the literal as written, rendered from the AST

← Schema index