home / app

user_profile

1 row where user_id = "GjvvzIWQOqQqo3zCMRff8IOJ4xcPuNAY"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ user_id role avatar_url bio created_at updated_at
01KQFVYAJK2JB82HXGER2CH48V Slackliniste GjvvzIWQOqQqo3zCMRff8IOJ4xcPuNAY user     1777575340 1777575340

Advanced export

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

CSV options:

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`);
Powered by Datasette · Queries took 18.529ms