ColumnConnection
The column connection object.
Learn more about pagination in GraphQL.
fields
cachedAt non-null DateTime
The time at which the columns were cached (i.e., the time at which they were introspected).
edges non-null array of ColumnEdge
The column connection's edges.
The column edge object.
Learn more about pagination in GraphQL.
nodes non-null array of Column
The column connection's nodes.
The column object.
Once a table introspection succeeds, it creates a new table object for every table it introspected. Within each table object, it also creates a column object for every column it introspected.
nodes.name non-null String
The column's name.
nodes.type non-null String
The column's type.
nodes.isNullable nullable Boolean
Whether the column is nullable, meaning whether it accepts a null value.
nodes.cachedAt non-null DateTime
The time at which the column was cached (i.e., the time at which it was introspected).
nodes.createdAt non-null DateTime
The time at which the column was created. This is the same as its
cachedAt
time.nodes.createdBy non-null String
The column's creator. This corresponds to the initiator of the table introspection. It can be either a User ID, an Application ID, or "system" if it was created by Propel.
nodes.suggestedDataPoolColumnType nullable ColumnType
This is the suggested Data Pool column type to use when converting this Data Source column to a Data Pool column. Propel makes this suggestion based on the Data Source column type. If the Data Source column type is unsupported, this field returns
null
.Sometimes, you know better which Data Pool column type to convert to. In these cases, you can refer to
supportedDataPoolColumnTypes
for the full set of supported conversions.The Propel data types.
BOOLEAN
True or false.
STRING
A variable-length string.
FLOAT
A 32-bit signed double-precision floating point number.
DOUBLE
A 64-bit signed double-precision floating point number.
INT8
An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.
INT16
A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.
INT32
A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.
INT64
A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.
DATE
A date without a timestamp. For example, "YYYY-MM-DD".
TIMESTAMP
A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".
JSON
A JavaScript Object Notation (JSON) document.
nodes.supportedDataPoolColumnTypes non-null array of ColumnType
This is the set of supported Data Pool column types you can use when converting this Data Source column to a Data Pool column. If the Data Source column type is unsupported, this field returns an empty array.
For example, a numeric Data Source column type could be converted to a narrower or wider numeric Data Pool column type; a string-valued Data Source column type could be mapped to a date or timestamp Data Pool column type.
To learn more about the supported conversions, refer to the docs for your particular Data Source.
The Propel data types.
BOOLEAN
True or false.
STRING
A variable-length string.
FLOAT
A 32-bit signed double-precision floating point number.
DOUBLE
A 64-bit signed double-precision floating point number.
INT8
An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.
INT16
A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.
INT32
A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.
INT64
A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.
DATE
A date without a timestamp. For example, "YYYY-MM-DD".
TIMESTAMP
A date with a timestamp. For example, "yyy-MM-dd HH:mm:ss".
JSON
A JavaScript Object Notation (JSON) document.
pageInfo non-null PageInfo
The column connection's page info.
The page info object used for pagination.
pageInfo.startCursor nullable String
Points to the first item returned in the results. Used when paginating backward.
pageInfo.endCursor nullable String
Points to the last item returned in the results. Used when paginating forward.
pageInfo.hasNextPage non-null Boolean
A boolean that indicates whether a next page of results exists. Can be used to display a "next page" button in user interfaces, for example.
pageInfo.hasPreviousPage non-null Boolean
A boolean that indicates whether a previous page of results exists. Can be used to display a "previous page" button in user interfaces, for example.