Akkoma users table

AKKOMA_USERS.asciidoc

Table 1. Table "public.users"

Column	Type	Collation	Nullable	Default
id	uuid		not null
email	citext
password_hash	character varying(255)
name	character varying(255)
nickname	citext
bio	text		not null
inserted_at	timestamp(0) without time zone		not null
updated_at	timestamp(0) without time zone		not null
ap_id	character varying(255)		not null
avatar	jsonb
local	boolean		not null	true
follower_address	character varying(255)
last_refreshed_at	timestamp without time zone
tags	character varying(255)[]			ARRAY[]::character varying[]
last_digest_emailed_at	timestamp(0) without time zone			now()
multi_factor_authentication_settings	jsonb			'\{}'::jsonb
following_address	character varying(255)
keys	text
banner	jsonb			'\{}'::jsonb
background	jsonb			'\{}'::jsonb
note_count	integer		not null	0
follower_count	integer		not null	0
following_count	integer		not null	0
is_locked	boolean		not null	false
is_confirmed	boolean		not null	true
password_reset_pending	boolean		not null	false
confirmation_token	text
default_scope	character varying(255)			'public'::character varying
blocks	text[]		not null	ARRAY[]::text[]
domain_blocks	text[]		not null	ARRAY[]::text[]
mutes	text[]		not null	ARRAY[]::text[]
muted_reblogs	text[]		not null	ARRAY[]::text[]
muted_notifications	text[]		not null	ARRAY[]::text[]
subscribers	text[]		not null	ARRAY[]::text[]
is_active	boolean		not null	true
no_rich_text	boolean		not null	false
ap_enabled	boolean		not null	false
is_moderator	boolean		not null	false
is_admin	boolean		not null	false
show_role	boolean		not null	true
mastofe_settings	jsonb
uri	text
hide_followers_count	boolean		not null	false
hide_follows_count	boolean		not null	false
hide_followers	boolean		not null	false
hide_follows	boolean		not null	false
hide_favorites	boolean		not null	true
email_notifications	jsonb			'\{"digest": false}'::jsonb
mascot	jsonb
emoji	jsonb		not null	'\{}'::jsonb
pleroma_settings_store	jsonb			'\{}'::jsonb
fields	jsonb		not null	'[]'::jsonb
raw_fields	jsonb		not null	'[]'::jsonb
is_discoverable	boolean		not null	false
invisible	boolean		not null	false
notification_settings	jsonb		not null	'\{"follows": true, "followers": true, "non_follows": true, "non_followers": true}'::jsonb
skip_thread_containment	boolean		not null	false
also_known_as	character varying(255)[]		not null	ARRAY[]::character varying[]
allow_following_move	boolean		not null	true
actor_type	character varying(255)		not null	'Person'::character varying
raw_bio	text
public_key	text
inbox	text
shared_inbox	text
accepts_chat_messages	boolean
is_approved	boolean		not null	true
registration_reason	text
last_active_at	timestamp(0) without time zone
pinned_objects	jsonb		not null	'\{}'::jsonb
featured_address	character varying(255)
disclose_client	boolean			true
is_suggested	boolean		not null	false
last_status_at	timestamp(0) without time zone
language	character varying(255)
status_ttl_days	integer

Indexes:
    "users_pkey" PRIMARY KEY, btree (id)
    "users_ap_id_COALESCE_follower_address_index" btree (ap_id, COALESCE(follower_address, ''::character varying))
    "users_ap_id_index" UNIQUE, btree (ap_id)
    "users_email_index" UNIQUE, btree (email)
    "users_featured_address_index" btree (featured_address)
    "users_follower_address_index" btree (follower_address)
    "users_following_address_index" btree (following_address)
    "users_fts_index" gin setweight(to_tsvector('simple'::regconfig, regexp_replace(nickname, '\W'::citext, ' '::text, 'g'::text, 'A'::"char") || setweight(to_tsvector('simple'::regconfig, regexp_replace(COALESCE(name, ''::character varying)::text, '\W'::text, ' '::text, 'g'::text)), 'B'::"char")))
    "users_invisible_index" btree (invisible)
    "users_is_active_index" btree (is_active)
    "users_is_admin_index" btree (is_admin)
    "users_is_discoverable_index" btree (is_discoverable)
    "users_is_moderator_index" btree (is_moderator)
    "users_is_suggested_index" btree (is_suggested)
    "users_last_active_at_index" btree (last_active_at)
    "users_last_status_at_index" btree (last_status_at)
    "users_local_index" btree (local)
    "users_nickname_index" UNIQUE, btree (nickname)
    "users_tags_index" gin (tags)
    "users_uri_index" btree (uri)
Referenced by:
    TABLE "announcement_read_relationships" CONSTRAINT "announcement_read_relationships_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "apps" CONSTRAINT "apps_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "backups" CONSTRAINT "backups_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "bookmarks" CONSTRAINT "bookmarks_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "chats" CONSTRAINT "chats_recipient_fkey" FOREIGN KEY (recipient) REFERENCES users(ap_id) ON DELETE CASCADE
    TABLE "chats" CONSTRAINT "chats_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "conversation_participation_recipient_ships" CONSTRAINT "conversation_participation_recipient_ships_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "conversation_participations" CONSTRAINT "conversation_participations_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "deliveries" CONSTRAINT "deliveries_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "filters" CONSTRAINT "filters_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "following_relationships" CONSTRAINT "following_relationships_follower_id_fkey" FOREIGN KEY (follower_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "following_relationships" CONSTRAINT "following_relationships_following_id_fkey" FOREIGN KEY (following_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "lists" CONSTRAINT "lists_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "markers" CONSTRAINT "markers_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "mfa_tokens" CONSTRAINT "mfa_tokens_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "notifications" CONSTRAINT "notifications_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "oauth_authorizations" CONSTRAINT "oauth_authorizations_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "oauth_tokens" CONSTRAINT "oauth_tokens_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "password_reset_tokens" CONSTRAINT "password_reset_tokens_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "push_subscriptions" CONSTRAINT "push_subscriptions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "registrations" CONSTRAINT "registrations_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "report_notes" CONSTRAINT "report_notes_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "scheduled_activities" CONSTRAINT "scheduled_activities_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "thread_mutes" CONSTRAINT "thread_mutes_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_follows_hashtag" CONSTRAINT "user_follows_hashtag_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_frontend_setting_profiles" CONSTRAINT "user_frontend_setting_profiles_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_notes" CONSTRAINT "user_notes_source_id_fkey" FOREIGN KEY (source_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_notes" CONSTRAINT "user_notes_target_id_fkey" FOREIGN KEY (target_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_relationships" CONSTRAINT "user_relationships_source_id_fkey" FOREIGN KEY (source_id) REFERENCES users(id) ON DELETE CASCADE
    TABLE "user_relationships" CONSTRAINT "user_relationships_target_id_fkey" FOREIGN KEY (target_id) REFERENCES users(id) ON DELETE CASCADE

example_user.asciidoc

id	email	password_hash	name	nickname	bio	inserted_at	updated_at	ap_id	avatar	local	follower_address	last_refreshed_at	tags	last_digest_emailed_at	multi_factor_authentication_settings	following_address	keys	banner	background	note_count	follower_count	following_count	is_locked	is_confirmed	password_reset_pending	confirmation_token	default_scope	blocks	domain_blocks	mutes	muted_reblogs	muted_notifications	subscribers	is_active	no_rich_text	ap_enabled	is_moderator	is_admin	show_role	mastofe_settings	uri	hide_followers_count	hide_follows_count	hide_followers	hide_follows	hide_favorites	email_notifications	mascot	emoji	pleroma_settings_store	fields	raw_fields	is_discoverable	invisible	notification_settings	skip_thread_containment	also_known_as	allow_following_move	actor_type	raw_bio	public_key	inbox	shared_inbox	accepts_chat_messages	is_approved	registration_reason	last_active_at	pinned_objects	featured_address	disclose_client	is_suggested	last_status_at	language	status_ttl_days
00000185-2809-83a3-3ad0-7c4c80080000	copypaste@kittens.ph	$pbkdf2-sha512$160000$OLQk3eagLahc5Rb6XnZgNw$WEI3chiypzYvmjGbd1a4plral1.zOnBDOpzNzl98O7.Npbwuk6zk/UJcmPtE1p5dkwaRgkCxIycGt5tNVzGdLA	copypaste	copypaste		2022-12-19 01:39:50	2022-12-19 01:39:50	https://akkoma.example.com/users/copypaste	\{}	t	https://akkoma.example.com/users/copypaste/followers		\{}	2022-12-19 01:39:50	\{}	https://akkoma.example.com/users/copypaste/following	-----BEGIN RSA PRIVATE KEY----- MIIEowIBAAKCAQEA3byWfy6Wh+/drE7DqiH7hLc3blKCh14pzc1mRiG/kKAH2KqR AATAqgHP+DDgoPHlX2RRqxFVP/cX/9edhSUAIE1/yJFANPkBG9/ddPjh2jXPGvG+ ObFs3S9lAaopv5HQc5/pTfpkecXXcNAGN7z5AaLf25IEToxCE3obf4IktdgBVTrk zjqdKElUVMpeMXYK+ysMkzrlRmBuovNzyk8bevP1ssnADXZm0AlAvH/E/KTtY+yT CqMDZhZ6ncyRNZUczQZJH3c+UcbdKbwHM08MfriqkC9VpWQO0m142wzIO4rsJcSH oU9ICg6gtjJl25TPRIqD05WBKRGWUiQbQSoNawIDAQABAoIBAESt5ANyn6dtMUDs iIhKzEfYI/Ak2E8raFFZXGM+ksIt/yAp/I1/61j9BLiAEyNmqT/5p54P2VLdqu5Q j3as9jQLLRgnfTarJZ/HoCVZ7UKURhi3Zc8i2HBN/MAeP54ZgPI/RpkjhDl/gPJt TG+5NXs/Qo0U1gaqRNEZkijVW5+Cu4wzIG1HD7XtVJ7+hqF8aglx3XVuSTY0MmQ5 Qe55wwNsHOE4bE8cUoyG6e5zaLC1SQJmVhTNVpDfWolqn1cAbmfbjtivKFEsir3L kVQmyuOpoXh1/5DVq3lvTjL908WUJhq/f1Zeqm8AmJzm5Nj91+NRKDo7fGn6l54K U74uHQECgYEA9Bza1ZDWtQYrzCrMRjQ/bUaOq2tmfbnmYiQThKXcRhFr4XgFJdZD UEvVmkFLBTu9R7XSZwL1a363e27OfGNi9+m6HiYvZlhY7mjfUEak16ibF+3RFqXi lwf3gd9/GuoBdj0KPVTA8NdAvcOmXE3r98PRk3N3p1kUUuO/tGCvPYECgYEA6IjK PXfjfz5wr1f/TyONNls8FGLKn1xiVO42j2/4SCyXZewht/9Fu2NOJCZdTkL0XPQq ya8gtMTN2KvLIlUrM+EXSrBCn1t5Aa3NZxW563UJ3zwvJ5FuEU8Ped+LBNy0lUmm 2tpvVN6Y329oHEUsOsDDST5ViO3nUxYwN+fImOsCgYEA8MlVgbswTbcclHLSs5zt w1gJekSh//nSqZN0PS9tKyAcDXZZfYzvMNDcjR9CZJMcjRNnynw8oB+J1JLj0gYm pOtCzmJT9tvGPMPtIj3Mc3y4Hs5Ro8lUzCzrkotl0KJpdruW0hA7kFSCY6wM+JdT 3jylCJCowcU4KtrDSaTktgECgYBof/DDJvmp2Vmysw0dd5CieOXLE4qTi2T1XghO 9bbSWJfBShjtI18nEz2uqT8NSLGghGomMPm1wyvuz2V+jF/Z9LIO8p8+FlGPG5hP V0gyNGq3U8itM4IPbUQ7NOa4zKaq4GqHt9qIfXCeGObkrYFu9enNJKIz4xYuFK6e sR9I+QKBgDsjpnoJv9M0fn5UmEl6/kwQyE1GYBIbzYmandlclWC/OvheOCtwaLBW UfKpAkpUDvHyA0X/x5bqsYi7t+78x5iupmU45DiEPtv0yCzhSv56huVA/I/5pqAj EB/ron5ZLc2hZjy4a/Usf0dMPrWB713wBm2udcPuXXpTIz+ZAyzo -----END RSA PRIVATE KEY-----	\{}	\{}	0	0	0	f	t	f		public	\{}	\{}	\{}	\{}	\{}	\{}	t	f	f	f	t	t			f	f	f	f	t	\{"digest": false}		\{}	\{}	[]	[]	f	f	\{"follows": true, "followers": true, "non_follows": true, "non_followers": true}	f	\{}	t	Person						t			\{}	https://akkoma.example.com/users/copypaste/collections/featured	t	f

(1 row)

example_userv.asciidoc

Record 1
id	00000185-2809-83a3-3ad0-7c4c80080000
email	copypaste@kittens.ph
password_hash	$pbkdf2-sha512$160000$OLQk3eagLahc5Rb6XnZgNw$WEI3chiypzYvmjGbd1a4plral1.zOnBDOpzNzl98O7.Npbwuk6zk/UJcmPtE1p5dkwaRgkCxIycGt5tNVzGdLA
name	copypaste
nickname	copypaste
bio
inserted_at	2022-12-19 01:39:50
updated_at	2022-12-19 01:39:50
ap_id	https://akkoma.example.com/users/copypaste
avatar	\{}
local	t
follower_address	https://akkoma.example.com/users/copypaste/followers
last_refreshed_at
tags	\{}
last_digest_emailed_at	2022-12-19 01:39:50
multi_factor_authentication_settings	\{}
following_address	https://akkoma.example.com/users/copypaste/following
keys	-----BEGIN RSA PRIVATE KEY----- MIIEowIBAAKCAQEA3byWfy6Wh+/drE7DqiH7hLc3blKCh14pzc1mRiG/kKAH2KqR AATAqgHP+DDgoPHlX2RRqxFVP/cX/9edhSUAIE1/yJFANPkBG9/ddPjh2jXPGvG+ ObFs3S9lAaopv5HQc5/pTfpkecXXcNAGN7z5AaLf25IEToxCE3obf4IktdgBVTrk zjqdKElUVMpeMXYK+ysMkzrlRmBuovNzyk8bevP1ssnADXZm0AlAvH/E/KTtY+yT CqMDZhZ6ncyRNZUczQZJH3c+UcbdKbwHM08MfriqkC9VpWQO0m142wzIO4rsJcSH oU9ICg6gtjJl25TPRIqD05WBKRGWUiQbQSoNawIDAQABAoIBAESt5ANyn6dtMUDs iIhKzEfYI/Ak2E8raFFZXGM+ksIt/yAp/I1/61j9BLiAEyNmqT/5p54P2VLdqu5Q j3as9jQLLRgnfTarJZ/HoCVZ7UKURhi3Zc8i2HBN/MAeP54ZgPI/RpkjhDl/gPJt TG+5NXs/Qo0U1gaqRNEZkijVW5+Cu4wzIG1HD7XtVJ7+hqF8aglx3XVuSTY0MmQ5 Qe55wwNsHOE4bE8cUoyG6e5zaLC1SQJmVhTNVpDfWolqn1cAbmfbjtivKFEsir3L kVQmyuOpoXh1/5DVq3lvTjL908WUJhq/f1Zeqm8AmJzm5Nj91+NRKDo7fGn6l54K U74uHQECgYEA9Bza1ZDWtQYrzCrMRjQ/bUaOq2tmfbnmYiQThKXcRhFr4XgFJdZD UEvVmkFLBTu9R7XSZwL1a363e27OfGNi9+m6HiYvZlhY7mjfUEak16ibF+3RFqXi lwf3gd9/GuoBdj0KPVTA8NdAvcOmXE3r98PRk3N3p1kUUuO/tGCvPYECgYEA6IjK PXfjfz5wr1f/TyONNls8FGLKn1xiVO42j2/4SCyXZewht/9Fu2NOJCZdTkL0XPQq ya8gtMTN2KvLIlUrM+EXSrBCn1t5Aa3NZxW563UJ3zwvJ5FuEU8Ped+LBNy0lUmm 2tpvVN6Y329oHEUsOsDDST5ViO3nUxYwN+fImOsCgYEA8MlVgbswTbcclHLSs5zt w1gJekSh//nSqZN0PS9tKyAcDXZZfYzvMNDcjR9CZJMcjRNnynw8oB+J1JLj0gYm pOtCzmJT9tvGPMPtIj3Mc3y4Hs5Ro8lUzCzrkotl0KJpdruW0hA7kFSCY6wM+JdT 3jylCJCowcU4KtrDSaTktgECgYBof/DDJvmp2Vmysw0dd5CieOXLE4qTi2T1XghO 9bbSWJfBShjtI18nEz2uqT8NSLGghGomMPm1wyvuz2V+jF/Z9LIO8p8+FlGPG5hP V0gyNGq3U8itM4IPbUQ7NOa4zKaq4GqHt9qIfXCeGObkrYFu9enNJKIz4xYuFK6e sR9I+QKBgDsjpnoJv9M0fn5UmEl6/kwQyE1GYBIbzYmandlclWC/OvheOCtwaLBW UfKpAkpUDvHyA0X/x5bqsYi7t+78x5iupmU45DiEPtv0yCzhSv56huVA/I/5pqAj EB/ron5ZLc2hZjy4a/Usf0dMPrWB713wBm2udcPuXXpTIz+ZAyzo -----END RSA PRIVATE KEY-----
banner	\{}
background	\{}
note_count	0
follower_count	0
following_count	0
is_locked	f
is_confirmed	t
password_reset_pending	f
confirmation_token
default_scope	public
blocks	\{}
domain_blocks	\{}
mutes	\{}
muted_reblogs	\{}
muted_notifications	\{}
subscribers	\{}
is_active	t
no_rich_text	f
ap_enabled	f
is_moderator	f
is_admin	t
show_role	t
mastofe_settings
uri
hide_followers_count	f
hide_follows_count	f
hide_followers	f
hide_follows	f
hide_favorites	t
email_notifications	\{"digest": false}
mascot
emoji	\{}
pleroma_settings_store	\{}
fields	[]
raw_fields	[]
is_discoverable	f
invisible	f
notification_settings	\{"follows": true, "followers": true, "non_follows": true, "non_followers": true}
skip_thread_containment	f
also_known_as	\{}
allow_following_move	t
actor_type	Person
raw_bio
public_key
inbox
shared_inbox
accepts_chat_messages
is_approved	t
registration_reason
last_active_at
pinned_objects	\{}
featured_address	https://akkoma.example.com/users/copypaste/collections/featured
disclose_client	t
is_suggested	f
last_status_at
language
status_ttl_days

1 row