account
2 rows where user_id = "iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY"
This data as json, CSV (advanced)
| id ▼ | account_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 | 116142554446437743458 | Kylian Schmitt iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY | ya29.a0AQvPyIOr2L4Z3Mf7TxWV9kyEm9mx0kFqYAcXx4j-itZ3DbvkSagKGK4nMsmOVel-z3I3F_k3SuZZQC9y-f6UKIjNjDGYBUbewhs85RdGj3W4MnLpS-uUBXf9bAQ0gXIrJBLKvWo7bH7Akj4QqxY1ouZ50hR6hnVTYKkOUnHudUHabWYpcdDhkBb76rT-MhdY3pHPeyttJGf3irN8j6mZ7B5e3rVKLkv4X217r2yHJ1_fwFRHCIB2oGE3RlTu2UqioWOeJgK_3QWNh6KLqAIeLbPaB-bdaCgYKAWYSARYSFQHGX2Mi4Fk7CnbzTzEOA6GHVK7_uA0291 | eyJhbGciOiJSUzI1NiIsImtpZCI6IjgwNzZkZGJhYjQxNTU1NmUxNjkxNTRjNmE0YTBiZGJkNDQ2OWI3OWMiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI2Njg4MzkyOTE5NjUtdTZrbjBpa2w0NHVpbHAxNmtqb3VkMHNwdXBqbWRpNnIuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMTYxNDI1NTQ0NDY0Mzc3NDM0NTgiLCJlbWFpbCI6Imt5bGlhbjU0MDAwQGdtYWlsLmNvbSIsImVtYWlsX3ZlcmlmaWVkIjp0cnVlLCJhdF9oYXNoIjoiZnFvRGQ3WlU1YWNaZXQ3clpXRUJhUSIsIm5hbWUiOiJLeWxpYW4gU2NobWl0dCIsInBpY3R1cmUiOiJodHRwczovL2xoMy5nb29nbGV1c2VyY29udGVudC5jb20vYS9BQ2c4b2NKZDZRaFM2OUFrOHYzZGJJM1RHVUpHSzJZb2IyX1VpTzRjbG5pckhDOVg3dGtqVkRCRT1zOTYtYyIsImdpdmVuX25hbWUiOiJLeWxpYW4iLCJmYW1pbHlfbmFtZSI6IlNjaG1pdHQiLCJpYXQiOjE3Nzg1NTE4MjEsImV4cCI6MTc3ODU1NTQyMX0.XJ-5pDYb0NCq5knBMAblDpwjoB3Y71fLpHRi3M86fZUOdbGckrb3x8ULSxA_YpwhGZHKhGKqXF_F2MuD-K9xXnoWk2BAzzocq4lz4tmQ55D454gOnfddRHNZ3s7Kg32evqdmDZSRiXJJzc3GTqvB1_HahF050K72OCdM43XiBu7MiSgJSFh-Kbtz7t8e3evkMhFCqA4f8IZGrQadvuwUZk1YWaPmI02V736sub4JFtRzwzXCeY4tQwsVTNIGsDZtXlcFx6EWm0dm7ipGnYu8qts_i-1H0bWHkc0MqmfpN383T63r5Gr8Buq9yNoerlsEjnSSM8Zf-6D9alKegtxYiQ | 1778555419419 | https://www.googleapis.com/auth/userinfo.email,openid,https://www.googleapis.com/auth/userinfo.profile | 1777409663069 | 1778551821430 | ||||
| pXj3ME5yDXNsLSHOJcy9wQ1L2kskoqBS | 97967362 | github | Kylian Schmitt iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY | 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 | read:user,user:email | 1777411232404 | 1777411232404 |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);