Types

Below is a mapping of GraphQL schema types to their database equivalents.

Sway Type	GraphQL Schema Type	Postgres Type	SQLite Type
u64	ID	bigint primary key	bigint
b256	Address	varchar(64)	text
str[4]	Bytes4	varchar(16)	text
str[8]	Bytes8	varchar(64)	text
str[32]	Bytes32	varchar(64)	text
str[32]	AssetId	varchar(64)	text
b256	ContractId	varchar(64)	text
str[32]	Salt	varchar(64)	text
u32	UInt4	integer	integer
u64	UInt8	bigint	integer
i64	Timestamp	timestamp	text
str[]	Blob	bytes	text
str[32]	MessageId	varchar(64)	text
bool	Boolean	bool	text
	Json	json	text
	Charfield	varchar(255)	text
	Blob	varchar(10485760)	text

Example

Let's define an Event struct in a Sway contract:

struct Event {
    id: u64,
    address: Address,
    block_height: u64,
}

The corresponding GraphQL schema to mirror this Event struct would resemble:

type Event {
    id: ID!
    account: Address!
    block_height: UInt8!
}

And finally, this GraphQL schema will generate the following Postgres schema:

                                           Table "schema.event"
    Column   |     Type    | Collation | Nullable | Default | Storage  | Compression | Stats target | Description
--------------+-------------+-----------+----------+---------+----------+-------------+--------------+-------------
 id           |    bigint   |           | not null |         | plain        |             |              |
 block_height |    bigint   |           | not null |         | plain    |             |              |
 address      | varchar(64) |           | not null |         | plain    |             |              |
 object       |    bytea    |           | not null |         | extended |             |              |
Indexes:
    "event_pkey" PRIMARY KEY, btree (id)
Access method: heap