user_profile
1 row where user_id = "iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY"
This data as json, CSV (advanced)
| id ▼ | user_id | role | avatar_url | bio | created_at | updated_at |
|---|---|---|---|---|---|---|
| 01KQAXY831EQ9DZY1H073ZCNVG | Kylian Schmitt iBuK1HOsIw8dtGxDGPHwyfawnDerpMhY | admin | 1777409663 | 1777409663 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `user_profile` ( `id` text PRIMARY KEY NOT NULL, `user_id` text NOT NULL, `role` text DEFAULT 'user' NOT NULL, `avatar_url` text, `bio` text, `created_at` integer DEFAULT (unixepoch()) NOT NULL, `updated_at` integer DEFAULT (unixepoch()) NOT NULL, FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade ); CREATE UNIQUE INDEX `user_profile_user_id_unique` ON `user_profile` (`user_id`);