account

2 rows where user_id = "iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ provider_id user_id access_token refresh_token id_token access_token_expires_at refresh_token_expires_at scope password created_at updated_at
AuZQ3ZQ5yBqf6AusMUFINmOSvIdaKNsc google Kylian Schmitt iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY ya29.a0AdMD6Eh8zgcGV6yt7Oec8iBtEBWt-KHvAeMfI-BxbewSPn-E686ZU1_8ygUtOK9cUo-uapTDITtQz3Q1WxPuHxgk3z-n6yTlfLOBgwwmThaFP49wEULY9WaeWyEKK0Ivvr6hxiBWLPhrfjzdVEybT6FGBBARfLUz__1HPuFe5L_SoziDB2VTlWSfORzy-pe7H_UDESYoQ_vHjzr6MCZFlYFS551i9OCtXjGE7FbJx9ERKwS478lC2lJsIus_-N13Xuo44TqXLqaefDkJFtyA8sDrbuT_IQaCgYKAfMSARYSFQHGX2MiSnLHgVd1TCx-v_rDF9pm_Q0293   eyJhbGciOiJSUzI1NiIsImtpZCI6ImYxMGY4NzQwNWE5NzljMWRmMzZkZjI2NjA2NzM0ZjMzY2Q4NWMyNzEiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMTYxNDI1NTQ0NDY0Mzc3NDM0NTgiLCJlbWFpbCI6Imt5bGlhbjU0MDAwQGdtYWlsLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjp0cnVlLCJhdF9oYXNoIjoieThaVG5yTm1Nang4TFJlTFRLOTA3dyIsIm5hbWUiOiJLeWxpYW4gU2NobWl0dCIsInBpY3R1cmUiOiJodHRwczovL2xoMy5nb29nbGV1c2VyY29udGVudC5jb20vYS9BQ2c4b2NKZDZRaFM2OUFrOHYzZGJJM1RHVUpHSzJZb2IyX1VpTzRjbG5pckhDOVg3dGtqVkRCRT1zOTYtYyIsImdpdmVuX25hbWUiOiJLeWxpYW4iLCJmYW1pbHlfbmFtZSI6IlNjaG1pdHQiLCJpYXQiOjE3ODg4ODQwMjgsImV4cCI6MTc4ODg4NzYyOH0.zx0fustBDwoKSrlWazoeXieCXhotodzFcmItC9xSmylx_S0uAC2XQFW-vCIantYwn6lUr3l0TDfBRA8rxa44G0OrpAWqx9077RUoA6NGptLrCYQejtjhbGRhA_gCfg1yWekfKVyIMMjKGl3EbRWMZ6_5ByyggDl6QQjBj0BnKEGOeXTGWTQwKFml1aBS2RyVa4R8B9WCjiu8cZrcsyztW8ECzB3HCG2XaeVvPeQl91iFR-GXeV-I-JV_mNymWIIdArjutZv5-GgJ4veqZxvkJ2igrff9eSKTxsksu16yIcZ6Dr2FyPJrlAnxg7eLeKB4TVjYkeO1ofvzHjVEwHeGrw 1788887626323   https://www.googleapis.com/auth/userinfo.profile,https://www.googleapis.com/auth/userinfo.email,openid   1777409663069 1788884028340
pXj3ME5yDXNsLSHOJcy9wQ1L2kskoqBS github Kylian Schmitt iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY 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         read:user,user:email   1777411232404 1777411232404

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE `account` (
	`id` text PRIMARY KEY NOT NULL,
	`account_id` text NOT NULL,
	`provider_id` text NOT NULL,
	`user_id` text NOT NULL,
	`access_token` text,
	`refresh_token` text,
	`id_token` text,
	`access_token_expires_at` integer,
	`refresh_token_expires_at` integer,
	`scope` text,
	`password` text,
	`created_at` integer DEFAULT (cast(unixepoch('subsecond') * 1000 as integer)) NOT NULL,
	`updated_at` integer NOT NULL,
	FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
);
CREATE INDEX `account_userId_idx` ON `account` (`user_id`);