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.a0AdMD6Ej-djc6WqxEq0XGj83F_Vyv0AcPwl_HIoWl67O_DeBUa3uyB1Dg923AD5uwbJ_cKE4FQWiQotJc60i0tyFKr8TRIMMwF23FAkXepkm2xHtj3jpE0L6h-yYI4DZAN49XDtlOyPk3RdTxEtRMDxw7uqlinShVIK7vRkoEdGU1gEHbR1SGbWk3wac_oIob9eYD6XTvJKYk6qZfHHvwvdpOYQ-lLoL5yPqgXbQcd5mamxUivVyLZyOt86fCBcRRPTFgQsHIwUZJeaqFfUXWkpJXpv7jfwaCgYKAUwSARYSFQHGX2MiOXlSecSBxztg2HQQWUbKQw0293   eyJhbGciOiJSUzI1NiIsImtpZCI6ImYxMGY4NzQwNWE5NzljMWRmMzZkZjI2NjA2NzM0ZjMzY2Q4NWMyNzEiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMTYxNDI1NTQ0NDY0Mzc3NDM0NTgiLCJlbWFpbCI6Imt5bGlhbjU0MDAwQGdtYWlsLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjp0cnVlLCJhdF9oYXNoIjoiRHM1NWZrQWk1ZXgxSmNIeEItbXNiZyIsIm5hbWUiOiJLeWxpYW4gU2NobWl0dCIsInBpY3R1cmUiOiJodHRwczovL2xoMy5nb29nbGV1c2VyY29udGVudC5jb20vYS9BQ2c4b2NKZDZRaFM2OUFrOHYzZGJJM1RHVUpHSzJZb2IyX1VpTzRjbG5pckhDOVg3dGtqVkRCRT1zOTYtYyIsImdpdmVuX25hbWUiOiJLeWxpYW4iLCJmYW1pbHlfbmFtZSI6IlNjaG1pdHQiLCJpYXQiOjE3ODc3NzM3NjYsImV4cCI6MTc4Nzc3NzM2Nn0.iHtL5jCQkQ6Wp16ufoYkC4lj2KfYOBUB-zkIw8mSu-Kyk9g94ZNPdNFgVEqu2-dPgMVPTZ5h2xUz_h6CQBZuHeAehxgsDYXtGAdIgPEjZwyHgKQvOBTWYOnKXv6VHvr6aBqVCnQeprDiCIQGIM-y9IlFCPCQoiOzQsyyP3r0I9_Xpg96OapTOZOKfF0-URCa5viw9kFIGCB8JD8xSfGcRwjXQhtIDN0__twQm9_utmyNT7HHjWRRJvvwa8wVHRycQo5d4nn-5XRitjFwOfaYSnL0NyNtWxeX7kIOstceFjsH9XyxtZu_CVMZeVk7xaatDPVKRZmPuWwPcpzRZ0uJzA 1787777364148   https://www.googleapis.com/auth/userinfo.profile,https://www.googleapis.com/auth/userinfo.email,openid   1777409663069 1787773766164
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`);