Size of OAUTH tokens and twitch user ID for DB storage (account mapping)

[streamermoose]

Hello,

I’m currently working to provide functionality for players of a game to link their Twitch account and game account from a website that I provide.

In the guide that I am using to help achieve this (https://github.com/twitchdev/partner-documentation-e2/blob/main/docs/drops/README.md – only accessible if permission is given), it states:

“When viewers link their accounts, we recommend that you save the following information:
• Game Account ID
• Twitch OAuth token
• Twitch Refresh Token
• Twitch User ID”

In order to store this info in my database, I’ll need to know more information about what data type each of these values are (e.g. varchar(50)).

Does someone know where I can find exactly what SQL data types each of these values should be stored as (e.g. VARCHAR(50))?

(Also, please feel free to let me know if there are any other details/comments you wish to provide regarding this topic).

Thanks.

[streamermoose]

I made a mistake in my previous post.

When I said

“In the guide that I am using to help achieve this (https://github.com/twitchdev/partner-documentation-e2/blob/main/docs/drops/README.md – only accessible if permission is given), it states…”,

I referenced the wrong documentation link.

The correct documentation link is actually:

Drops