Page 1

access_tokens

Stores the access tokens for a user and developer tools.

This table in Canvas Data 2 will only share developer tool specific token metadata. All users have an option to create an access token based on their role and level of data access.

Parameters:

• id (int64): primary key The unique identifier for an access token record.

• developer_key_id (developer_keys): The unique identifier of a developer key.

• user_id (users | None): The unique ID of the user the token acts as.

account_users

Join table for accounts, users and roles.

Contains users’ roles within an account (this table includes the account admins).

Parameters:

id (int64): primary key The unique identifier for the users account association record.

user_id (users): The unique ID of a user.

created_at (datetime): Timestamp of when an account_users record was created.