schema.postgres.prisma•70 kB
// Taken from https://github.com/prisma/introspection-ci/blob/automated/dev/introspection-analysis/output/postgresql_public/mastodon.log
generator client {
provider = "prisma-client-js"
output = "client"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model account_aliases {
id BigInt @id @default(autoincrement())
account_id BigInt?
acct String @default("") @db.VarChar
uri String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_fc91575d08")
@@index([account_id], map: "index_account_aliases_on_account_id")
}
model account_conversations {
id BigInt @id @default(autoincrement())
account_id BigInt?
conversation_id BigInt?
participant_account_ids BigInt[] @default([])
status_ids BigInt[] @default([])
last_status_id BigInt?
lock_version Int @default(0)
unread Boolean @default(false)
conversations conversations? @relation(fields: [conversation_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_1491654f9f")
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_6f5278b6e9")
@@unique([account_id, conversation_id, participant_account_ids], map: "index_unique_conversations")
@@index([account_id], map: "index_account_conversations_on_account_id")
@@index([conversation_id], map: "index_account_conversations_on_conversation_id")
}
model account_domain_blocks {
id BigInt @id @default(autoincrement())
domain String? @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt?
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_206c6029bd")
@@unique([account_id, domain], map: "index_account_domain_blocks_on_account_id_and_domain")
}
model account_identity_proofs {
id BigInt @id @default(autoincrement())
account_id BigInt?
provider String @default("") @db.VarChar
provider_username String @default("") @db.VarChar
token String @default("")
verified Boolean @default(false)
live Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_6a219ca385")
@@unique([account_id, provider, provider_username], map: "index_account_proofs_on_account_and_provider_and_username")
@@index([account_id], map: "index_account_identity_proofs_on_account_id")
}
model account_migrations {
id BigInt @id @default(autoincrement())
account_id BigInt?
acct String @default("") @db.VarChar
followers_count BigInt @default(0)
target_account_id BigInt?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts_account_migrations_account_idToaccounts accounts? @relation("account_migrations_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_c9f701caaf")
accounts_account_migrations_target_account_idToaccounts accounts? @relation("account_migrations_target_account_idToaccounts", fields: [target_account_id], references: [id], onUpdate: NoAction, map: "fk_rails_d9a8dad070")
@@index([account_id], map: "index_account_migrations_on_account_id")
@@index([target_account_id], map: "index_account_migrations_on_target_account_id")
}
model account_moderation_notes {
id BigInt @id @default(autoincrement())
content String
account_id BigInt
target_account_id BigInt
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts_account_moderation_notes_account_idToaccounts accounts @relation("account_moderation_notes_account_idToaccounts", fields: [account_id], references: [id], onDelete: NoAction, onUpdate: NoAction, map: "fk_rails_3f8b75089b")
accounts_account_moderation_notes_target_account_idToaccounts accounts @relation("account_moderation_notes_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: NoAction, onUpdate: NoAction, map: "fk_rails_dd62ed5ac3")
@@index([account_id], map: "index_account_moderation_notes_on_account_id")
@@index([target_account_id], map: "index_account_moderation_notes_on_target_account_id")
}
model account_pins {
id BigInt @id @default(autoincrement())
account_id BigInt?
target_account_id BigInt?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts_account_pins_target_account_idToaccounts accounts? @relation("account_pins_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a176e26c37")
accounts_account_pins_account_idToaccounts accounts? @relation("account_pins_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_d44979e5dd")
@@unique([account_id, target_account_id], map: "index_account_pins_on_account_id_and_target_account_id")
@@index([account_id], map: "index_account_pins_on_account_id")
@@index([target_account_id], map: "index_account_pins_on_target_account_id")
}
model account_stats {
id BigInt @id @default(autoincrement())
account_id BigInt @unique(map: "index_account_stats_on_account_id")
statuses_count BigInt @default(0)
following_count BigInt @default(0)
followers_count BigInt @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
last_status_at DateTime? @db.Timestamp(6)
lock_version Int @default(0)
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_215bb31ff1")
}
model account_tag_stats {
id BigInt @id @default(autoincrement())
tag_id BigInt @unique(map: "index_account_tag_stats_on_tag_id")
accounts_count BigInt @default(0)
hidden Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
tags tags @relation(fields: [tag_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_1fa34bab2d")
}
model account_warning_presets {
id BigInt @id @default(autoincrement())
text String @default("")
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model account_warnings {
id BigInt @id @default(autoincrement())
account_id BigInt?
target_account_id BigInt?
action Int @default(0)
text String @default("")
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts_account_warnings_account_idToaccounts accounts? @relation("account_warnings_account_idToaccounts", fields: [account_id], references: [id], onUpdate: NoAction, map: "fk_rails_a65a1bf71b")
accounts_account_warnings_target_account_idToaccounts accounts? @relation("account_warnings_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a7ebbb1e37")
@@index([account_id], map: "index_account_warnings_on_account_id")
@@index([target_account_id], map: "index_account_warnings_on_target_account_id")
}
/// This model contains an expression index which requires additional setup for migrations. Visit https://pris.ly/d/expression-indexes for more info.
model accounts {
id BigInt @id @default(autoincrement())
username String @default("") @db.VarChar
domain String? @db.VarChar
secret String @default("") @db.VarChar
private_key String?
public_key String @default("")
remote_url String @default("") @db.VarChar
salmon_url String @default("") @db.VarChar
hub_url String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
note String @default("")
display_name String @default("") @db.VarChar
uri String @default("") @db.VarChar
url String? @db.VarChar
avatar_file_name String? @db.VarChar
avatar_content_type String? @db.VarChar
avatar_file_size Int?
avatar_updated_at DateTime? @db.Timestamp(6)
header_file_name String? @db.VarChar
header_content_type String? @db.VarChar
header_file_size Int?
header_updated_at DateTime? @db.Timestamp(6)
avatar_remote_url String? @db.VarChar
subscription_expires_at DateTime? @db.Timestamp(6)
locked Boolean @default(false)
header_remote_url String @default("") @db.VarChar
last_webfingered_at DateTime? @db.Timestamp(6)
inbox_url String @default("") @db.VarChar
outbox_url String @default("") @db.VarChar
shared_inbox_url String @default("") @db.VarChar
followers_url String @default("") @db.VarChar
protocol Int @default(0)
memorial Boolean @default(false)
moved_to_account_id BigInt?
featured_collection_url String? @db.VarChar
fields Json?
actor_type String? @db.VarChar
discoverable Boolean?
also_known_as String[] @db.VarChar
silenced_at DateTime? @db.Timestamp(6)
suspended_at DateTime? @db.Timestamp(6)
trust_level Int?
account_aliases account_aliases[]
account_conversations account_conversations[]
account_domain_blocks account_domain_blocks[]
account_identity_proofs account_identity_proofs[]
account_migrations_account_migrations_account_idToaccounts account_migrations[] @relation("account_migrations_account_idToaccounts")
account_migrations_account_migrations_target_account_idToaccounts account_migrations[] @relation("account_migrations_target_account_idToaccounts")
account_moderation_notes_account_moderation_notes_account_idToaccounts account_moderation_notes[] @relation("account_moderation_notes_account_idToaccounts")
account_moderation_notes_account_moderation_notes_target_account_idToaccounts account_moderation_notes[] @relation("account_moderation_notes_target_account_idToaccounts")
account_pins_account_pins_target_account_idToaccounts account_pins[] @relation("account_pins_target_account_idToaccounts")
account_pins_account_pins_account_idToaccounts account_pins[] @relation("account_pins_account_idToaccounts")
account_stats account_stats?
account_warnings_account_warnings_account_idToaccounts account_warnings[] @relation("account_warnings_account_idToaccounts")
account_warnings_account_warnings_target_account_idToaccounts account_warnings[] @relation("account_warnings_target_account_idToaccounts")
accounts accounts? @relation("accountsToaccounts", fields: [moved_to_account_id], references: [id], onUpdate: NoAction, map: "fk_rails_2320833084")
other_accounts accounts[] @relation("accountsToaccounts")
admin_action_logs admin_action_logs[]
announcement_mutes announcement_mutes[]
announcement_reactions announcement_reactions[]
blocks_blocks_account_idToaccounts blocks[] @relation("blocks_account_idToaccounts")
blocks_blocks_target_account_idToaccounts blocks[] @relation("blocks_target_account_idToaccounts")
bookmarks bookmarks[]
conversation_mutes conversation_mutes[]
custom_filters custom_filters[]
favourites favourites[]
featured_tags featured_tags[]
follow_requests_follow_requests_account_idToaccounts follow_requests[] @relation("follow_requests_account_idToaccounts")
follow_requests_follow_requests_target_account_idToaccounts follow_requests[] @relation("follow_requests_target_account_idToaccounts")
follows_follows_account_idToaccounts follows[] @relation("follows_account_idToaccounts")
follows_follows_target_account_idToaccounts follows[] @relation("follows_target_account_idToaccounts")
imports imports[]
list_accounts list_accounts[]
lists lists[]
media_attachments media_attachments[]
mentions mentions[]
mutes_mutes_account_idToaccounts mutes[] @relation("mutes_account_idToaccounts")
mutes_mutes_target_account_idToaccounts mutes[] @relation("mutes_target_account_idToaccounts")
notifications_notifications_account_idToaccounts notifications[] @relation("notifications_account_idToaccounts")
notifications_notifications_from_account_idToaccounts notifications[] @relation("notifications_from_account_idToaccounts")
poll_votes poll_votes[]
polls polls[]
report_notes report_notes[]
reports_reports_account_idToaccounts reports[] @relation("reports_account_idToaccounts")
reports_reports_action_taken_by_account_idToaccounts reports[] @relation("reports_action_taken_by_account_idToaccounts")
reports_reports_target_account_idToaccounts reports[] @relation("reports_target_account_idToaccounts")
reports_reports_assigned_account_idToaccounts reports[] @relation("reports_assigned_account_idToaccounts")
scheduled_statuses scheduled_statuses[]
status_pins status_pins[]
statuses_statuses_account_idToaccounts statuses[] @relation("statuses_account_idToaccounts")
statuses_statuses_in_reply_to_account_idToaccounts statuses[] @relation("statuses_in_reply_to_account_idToaccounts")
tombstones tombstones[]
users users[]
@@index([moved_to_account_id], map: "index_accounts_on_moved_to_account_id")
@@index([uri], map: "index_accounts_on_uri")
@@index([url], map: "index_accounts_on_url")
}
model accounts_tags {
account_id BigInt
tag_id BigInt
@@unique([tag_id, account_id], map: "index_accounts_tags_on_tag_id_and_account_id")
@@index([account_id, tag_id], map: "index_accounts_tags_on_account_id_and_tag_id")
}
model admin_action_logs {
id BigInt @id @default(autoincrement())
account_id BigInt?
action String @default("") @db.VarChar
target_type String? @db.VarChar
target_id BigInt?
recorded_changes String @default("")
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a7667297fa")
@@index([account_id], map: "index_admin_action_logs_on_account_id")
@@index([target_type, target_id], map: "index_admin_action_logs_on_target_type_and_target_id")
}
model announcement_mutes {
id BigInt @id @default(autoincrement())
account_id BigInt?
announcement_id BigInt?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_9c99f8e835")
announcements announcements? @relation(fields: [announcement_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_e35401adf1")
@@unique([account_id, announcement_id], map: "index_announcement_mutes_on_account_id_and_announcement_id")
@@index([account_id], map: "index_announcement_mutes_on_account_id")
@@index([announcement_id], map: "index_announcement_mutes_on_announcement_id")
}
model announcement_reactions {
id BigInt @id @default(autoincrement())
account_id BigInt?
announcement_id BigInt?
name String @default("") @db.VarChar
custom_emoji_id BigInt?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_7444ad831f")
announcements announcements? @relation(fields: [announcement_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a1226eaa5c")
custom_emojis custom_emojis? @relation(fields: [custom_emoji_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_b742c91c0e")
@@unique([account_id, announcement_id, name], map: "index_announcement_reactions_on_account_id_and_announcement_id")
@@index([account_id], map: "index_announcement_reactions_on_account_id")
@@index([announcement_id], map: "index_announcement_reactions_on_announcement_id")
@@index([custom_emoji_id], map: "index_announcement_reactions_on_custom_emoji_id")
}
model announcements {
id BigInt @id @default(autoincrement())
text String @default("")
published Boolean @default(false)
all_day Boolean @default(false)
scheduled_at DateTime? @db.Timestamp(6)
starts_at DateTime? @db.Timestamp(6)
ends_at DateTime? @db.Timestamp(6)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
published_at DateTime? @db.Timestamp(6)
announcement_mutes announcement_mutes[]
announcement_reactions announcement_reactions[]
}
model ar_internal_metadata {
key String @id @db.VarChar
value String? @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model backups {
id BigInt @id @default(autoincrement())
user_id BigInt?
dump_file_name String? @db.VarChar
dump_content_type String? @db.VarChar
dump_updated_at DateTime? @db.Timestamp(6)
processed Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
dump_file_size BigInt?
users users? @relation(fields: [user_id], references: [id], onUpdate: NoAction, map: "fk_rails_096669d221")
}
model blocks {
id BigInt @id @default(autoincrement())
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
target_account_id BigInt
uri String? @db.VarChar
accounts_blocks_account_idToaccounts accounts @relation("blocks_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_4269e03e65")
accounts_blocks_target_account_idToaccounts accounts @relation("blocks_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_9571bfabc1")
@@unique([account_id, target_account_id], map: "index_blocks_on_account_id_and_target_account_id")
@@index([target_account_id], map: "index_blocks_on_target_account_id")
}
model bookmarks {
id BigInt @id @default(autoincrement())
account_id BigInt
status_id BigInt
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
statuses statuses @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_11207ffcfd")
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_9f6ac182a6")
@@unique([account_id, status_id], map: "index_bookmarks_on_account_id_and_status_id")
@@index([account_id], map: "index_bookmarks_on_account_id")
@@index([status_id], map: "index_bookmarks_on_status_id")
}
model conversation_mutes {
id BigInt @id @default(autoincrement())
conversation_id BigInt
account_id BigInt
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_225b4212bb")
conversations conversations @relation(fields: [conversation_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_5ab139311f")
@@unique([account_id, conversation_id], map: "index_conversation_mutes_on_account_id_and_conversation_id")
}
model conversations {
id BigInt @id @default(autoincrement())
uri String? @unique(map: "index_conversations_on_uri") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_conversations account_conversations[]
conversation_mutes conversation_mutes[]
}
model custom_emoji_categories {
id BigInt @id @default(autoincrement())
name String? @unique(map: "index_custom_emoji_categories_on_name") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model custom_emojis {
id BigInt @id @default(autoincrement())
shortcode String @default("") @db.VarChar
domain String? @db.VarChar
image_file_name String? @db.VarChar
image_content_type String? @db.VarChar
image_file_size Int?
image_updated_at DateTime? @db.Timestamp(6)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
disabled Boolean @default(false)
uri String? @db.VarChar
image_remote_url String? @db.VarChar
visible_in_picker Boolean @default(true)
category_id BigInt?
announcement_reactions announcement_reactions[]
@@unique([shortcode, domain], map: "index_custom_emojis_on_shortcode_and_domain")
}
model custom_filters {
id BigInt @id @default(autoincrement())
account_id BigInt?
expires_at DateTime? @db.Timestamp(6)
phrase String @default("")
context String[] @default([]) @db.VarChar
irreversible Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
whole_word Boolean @default(true)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_8b8d786993")
@@index([account_id], map: "index_custom_filters_on_account_id")
}
model domain_allows {
id BigInt @id @default(autoincrement())
domain String @unique(map: "index_domain_allows_on_domain") @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model domain_blocks {
id BigInt @id @default(autoincrement())
domain String @unique(map: "index_domain_blocks_on_domain") @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
severity Int? @default(0)
reject_media Boolean @default(false)
reject_reports Boolean @default(false)
private_comment String?
public_comment String?
}
model email_domain_blocks {
id BigInt @id @default(autoincrement())
domain String @unique(map: "index_email_domain_blocks_on_domain") @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model favourites {
id BigInt @id @default(autoincrement())
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
status_id BigInt
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_5eb6c2b873")
statuses statuses @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_b0e856845e")
@@unique([account_id, status_id], map: "index_favourites_on_account_id_and_status_id")
@@index([account_id, id], map: "index_favourites_on_account_id_and_id")
@@index([status_id], map: "index_favourites_on_status_id")
}
model featured_tags {
id BigInt @id @default(autoincrement())
account_id BigInt?
tag_id BigInt?
statuses_count BigInt @default(0)
last_status_at DateTime? @db.Timestamp(6)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_174efcf15f")
tags tags? @relation(fields: [tag_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_23a9055c7c")
@@index([account_id], map: "index_featured_tags_on_account_id")
@@index([tag_id], map: "index_featured_tags_on_tag_id")
}
model follow_requests {
id BigInt @id @default(autoincrement())
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
target_account_id BigInt
show_reblogs Boolean @default(true)
uri String? @db.VarChar
accounts_follow_requests_account_idToaccounts accounts @relation("follow_requests_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_76d644b0e7")
accounts_follow_requests_target_account_idToaccounts accounts @relation("follow_requests_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_9291ec025d")
@@unique([account_id, target_account_id], map: "index_follow_requests_on_account_id_and_target_account_id")
}
model follows {
id BigInt @id @default(autoincrement())
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
target_account_id BigInt
show_reblogs Boolean @default(true)
uri String? @db.VarChar
accounts_follows_account_idToaccounts accounts @relation("follows_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_32ed1b5560")
accounts_follows_target_account_idToaccounts accounts @relation("follows_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_745ca29eac")
list_accounts list_accounts[]
@@unique([account_id, target_account_id], map: "index_follows_on_account_id_and_target_account_id")
@@index([target_account_id], map: "index_follows_on_target_account_id")
}
model identities {
id BigInt @id @default(autoincrement())
provider String @default("") @db.VarChar
uid String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
user_id BigInt?
users users? @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_bea040f377")
@@index([user_id], map: "index_identities_on_user_id")
}
model imports {
id BigInt @id @default(autoincrement())
type Int
approved Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
data_file_name String? @db.VarChar
data_content_type String? @db.VarChar
data_file_size Int?
data_updated_at DateTime? @db.Timestamp(6)
account_id BigInt
overwrite Boolean @default(false)
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_6db1b6e408")
}
model invites {
id BigInt @id @default(autoincrement())
user_id BigInt
code String @unique(map: "index_invites_on_code") @default("") @db.VarChar
expires_at DateTime? @db.Timestamp(6)
max_uses Int?
uses Int @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
autofollow Boolean @default(false)
comment String?
users_invites_user_idTousers users @relation("invites_user_idTousers", fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_ff69dbb2ac")
users_users_invite_idToinvites users[] @relation("users_invite_idToinvites")
@@index([user_id], map: "index_invites_on_user_id")
}
model list_accounts {
id BigInt @id @default(autoincrement())
list_id BigInt
account_id BigInt
follow_id BigInt?
follows follows? @relation(fields: [follow_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_40f9cc29f1")
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_85fee9d6ab")
lists lists @relation(fields: [list_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_e54e356c88")
@@unique([account_id, list_id], map: "index_list_accounts_on_account_id_and_list_id")
@@index([follow_id], map: "index_list_accounts_on_follow_id")
@@index([list_id, account_id], map: "index_list_accounts_on_list_id_and_account_id")
}
model lists {
id BigInt @id @default(autoincrement())
account_id BigInt
title String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
list_accounts list_accounts[]
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_3853b78dac")
@@index([account_id], map: "index_lists_on_account_id")
}
model markers {
id BigInt @id @default(autoincrement())
user_id BigInt?
timeline String @default("") @db.VarChar
last_read_id BigInt @default(0)
lock_version Int @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
users users? @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a7009bc2b6")
@@unique([user_id, timeline], map: "index_markers_on_user_id_and_timeline")
@@index([user_id], map: "index_markers_on_user_id")
}
model media_attachments {
id BigInt @id @default(autoincrement())
status_id BigInt?
file_file_name String? @db.VarChar
file_content_type String? @db.VarChar
file_file_size Int?
file_updated_at DateTime? @db.Timestamp(6)
remote_url String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
shortcode String? @unique(map: "index_media_attachments_on_shortcode") @db.VarChar
type Int @default(0)
file_meta Json? @db.Json
account_id BigInt?
description String?
scheduled_status_id BigInt?
blurhash String? @db.VarChar
accounts accounts? @relation(fields: [account_id], references: [id], onUpdate: NoAction, map: "fk_96dd81e81b")
scheduled_statuses scheduled_statuses? @relation(fields: [scheduled_status_id], references: [id], onUpdate: NoAction, map: "fk_rails_31fc5aeef1")
statuses statuses? @relation(fields: [status_id], references: [id], onUpdate: NoAction, map: "fk_rails_3ec0cfdd70")
@@index([account_id], map: "index_media_attachments_on_account_id")
@@index([scheduled_status_id], map: "index_media_attachments_on_scheduled_status_id")
@@index([status_id], map: "index_media_attachments_on_status_id")
}
model mentions {
id BigInt @id @default(autoincrement())
status_id BigInt?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt?
silent Boolean @default(false)
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_970d43f9d1")
statuses statuses? @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_59edbe2887")
@@unique([account_id, status_id], map: "index_mentions_on_account_id_and_status_id")
@@index([status_id], map: "index_mentions_on_status_id")
}
model mutes {
id BigInt @id @default(autoincrement())
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
hide_notifications Boolean @default(true)
account_id BigInt
target_account_id BigInt
accounts_mutes_account_idToaccounts accounts @relation("mutes_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_b8d8daf315")
accounts_mutes_target_account_idToaccounts accounts @relation("mutes_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_eecff219ea")
@@unique([account_id, target_account_id], map: "index_mutes_on_account_id_and_target_account_id")
@@index([target_account_id], map: "index_mutes_on_target_account_id")
}
model notifications {
id BigInt @id @default(autoincrement())
activity_id BigInt
activity_type String @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
from_account_id BigInt
accounts_notifications_account_idToaccounts accounts @relation("notifications_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_c141c8ee55")
accounts_notifications_from_account_idToaccounts accounts @relation("notifications_from_account_idToaccounts", fields: [from_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_fbd6b0bf9e")
@@unique([account_id, activity_id, activity_type], map: "account_activity")
@@index([account_id, id(sort: Desc)], map: "index_notifications_on_account_id_and_id")
@@index([activity_id, activity_type], map: "index_notifications_on_activity_id_and_activity_type")
@@index([from_account_id], map: "index_notifications_on_from_account_id")
}
model oauth_access_grants {
id BigInt @id @default(autoincrement())
token String @unique(map: "index_oauth_access_grants_on_token") @db.VarChar
expires_in Int
redirect_uri String
created_at DateTime @db.Timestamp(6)
revoked_at DateTime? @db.Timestamp(6)
scopes String? @db.VarChar
application_id BigInt
resource_owner_id BigInt
oauth_applications oauth_applications @relation(fields: [application_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_34d54b0a33")
users users @relation(fields: [resource_owner_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_63b044929b")
@@index([resource_owner_id], map: "index_oauth_access_grants_on_resource_owner_id")
}
model oauth_access_tokens {
id BigInt @id @default(autoincrement())
token String @unique(map: "index_oauth_access_tokens_on_token") @db.VarChar
refresh_token String? @unique(map: "index_oauth_access_tokens_on_refresh_token") @db.VarChar
expires_in Int?
revoked_at DateTime? @db.Timestamp(6)
created_at DateTime @db.Timestamp(6)
scopes String? @db.VarChar
application_id BigInt?
resource_owner_id BigInt?
users users? @relation(fields: [resource_owner_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_e84df68546")
oauth_applications oauth_applications? @relation(fields: [application_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_f5fc4c1ee3")
session_activations session_activations[]
web_push_subscriptions web_push_subscriptions[]
@@index([resource_owner_id], map: "index_oauth_access_tokens_on_resource_owner_id")
}
model oauth_applications {
id BigInt @id @default(autoincrement())
name String @db.VarChar
uid String @unique(map: "index_oauth_applications_on_uid") @db.VarChar
secret String @db.VarChar
redirect_uri String
scopes String @default("") @db.VarChar
created_at DateTime? @db.Timestamp(6)
updated_at DateTime? @db.Timestamp(6)
superapp Boolean @default(false)
website String? @db.VarChar
owner_type String? @db.VarChar
owner_id BigInt?
confidential Boolean @default(true)
oauth_access_grants oauth_access_grants[]
oauth_access_tokens oauth_access_tokens[]
users_oauth_applications_owner_idTousers users? @relation("oauth_applications_owner_idTousers", fields: [owner_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_b0988c7c0a")
users_users_created_by_application_idTooauth_applications users[] @relation("users_created_by_application_idTooauth_applications")
@@index([owner_id, owner_type], map: "index_oauth_applications_on_owner_id_and_owner_type")
}
model pghero_space_stats {
id BigInt @id @default(autoincrement())
database String?
schema String?
relation String?
size BigInt?
captured_at DateTime? @db.Timestamp(6)
@@index([database, captured_at], map: "index_pghero_space_stats_on_database_and_captured_at")
}
model poll_votes {
id BigInt @id @default(autoincrement())
account_id BigInt?
poll_id BigInt?
choice Int @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
uri String? @db.VarChar
polls polls? @relation(fields: [poll_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_a6e6974b7e")
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_b6c18cf44a")
@@index([account_id], map: "index_poll_votes_on_account_id")
@@index([poll_id], map: "index_poll_votes_on_poll_id")
}
model polls {
id BigInt @id @default(autoincrement())
account_id BigInt?
status_id BigInt?
expires_at DateTime? @db.Timestamp(6)
options String[] @default([]) @db.VarChar
cached_tallies BigInt[] @default([])
multiple Boolean @default(false)
hide_totals Boolean @default(false)
votes_count BigInt @default(0)
last_fetched_at DateTime? @db.Timestamp(6)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
lock_version Int @default(0)
voters_count BigInt?
poll_votes poll_votes[]
statuses statuses? @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_3e0d9f1115")
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_5b19a0c011")
@@index([account_id], map: "index_polls_on_account_id")
@@index([status_id], map: "index_polls_on_status_id")
}
model preview_cards {
id BigInt @id @default(autoincrement())
url String @unique(map: "index_preview_cards_on_url") @default("") @db.VarChar
title String @default("") @db.VarChar
description String @default("") @db.VarChar
image_file_name String? @db.VarChar
image_content_type String? @db.VarChar
image_file_size Int?
image_updated_at DateTime? @db.Timestamp(6)
type Int @default(0)
html String @default("")
author_name String @default("") @db.VarChar
author_url String @default("") @db.VarChar
provider_name String @default("") @db.VarChar
provider_url String @default("") @db.VarChar
width Int @default(0)
height Int @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
embed_url String @default("") @db.VarChar
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by Prisma Client.
model preview_cards_statuses {
preview_card_id BigInt
status_id BigInt
@@index([status_id, preview_card_id], map: "index_preview_cards_statuses_on_status_id_and_preview_card_id")
@@ignore
}
model relays {
id BigInt @id @default(autoincrement())
inbox_url String @default("") @db.VarChar
follow_activity_id String? @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
state Int @default(0)
}
model report_notes {
id BigInt @id @default(autoincrement())
content String
report_id BigInt
account_id BigInt
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
reports reports @relation(fields: [report_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_7fa83a61eb")
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_cae66353f3")
@@index([account_id], map: "index_report_notes_on_account_id")
@@index([report_id], map: "index_report_notes_on_report_id")
}
model reports {
id BigInt @id @default(autoincrement())
status_ids BigInt[] @default([])
comment String @default("")
action_taken Boolean @default(false)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
account_id BigInt
action_taken_by_account_id BigInt?
target_account_id BigInt
assigned_account_id BigInt?
uri String? @db.VarChar
report_notes report_notes[]
accounts_reports_account_idToaccounts accounts @relation("reports_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_4b81f7522c")
accounts_reports_action_taken_by_account_idToaccounts accounts? @relation("reports_action_taken_by_account_idToaccounts", fields: [action_taken_by_account_id], references: [id], onUpdate: NoAction, map: "fk_bca45b75fd")
accounts_reports_target_account_idToaccounts accounts @relation("reports_target_account_idToaccounts", fields: [target_account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_eb37af34f0")
accounts_reports_assigned_account_idToaccounts accounts? @relation("reports_assigned_account_idToaccounts", fields: [assigned_account_id], references: [id], onUpdate: NoAction, map: "fk_rails_4e7a498fb4")
@@index([account_id], map: "index_reports_on_account_id")
@@index([target_account_id], map: "index_reports_on_target_account_id")
}
model scheduled_statuses {
id BigInt @id @default(autoincrement())
account_id BigInt?
scheduled_at DateTime? @db.Timestamp(6)
params Json?
media_attachments media_attachments[]
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_23bd9018f9")
@@index([account_id], map: "index_scheduled_statuses_on_account_id")
@@index([scheduled_at], map: "index_scheduled_statuses_on_scheduled_at")
}
model schema_migrations {
version String @id @db.VarChar
}
model session_activations {
id BigInt @id @default(autoincrement())
session_id String @unique(map: "index_session_activations_on_session_id") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
user_agent String @default("") @db.VarChar
ip String? @db.Inet
access_token_id BigInt?
user_id BigInt
web_push_subscription_id BigInt?
oauth_access_tokens oauth_access_tokens? @relation(fields: [access_token_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_957e5bda89")
users users @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_e5fda67334")
@@index([access_token_id], map: "index_session_activations_on_access_token_id")
@@index([user_id], map: "index_session_activations_on_user_id")
}
model settings {
id BigInt @id @default(autoincrement())
var String @db.VarChar
value String?
thing_type String? @db.VarChar
created_at DateTime? @db.Timestamp(6)
updated_at DateTime? @db.Timestamp(6)
thing_id BigInt?
@@unique([thing_type, thing_id, var], map: "index_settings_on_thing_type_and_thing_id_and_var")
}
model site_uploads {
id BigInt @id @default(autoincrement())
var String @unique(map: "index_site_uploads_on_var") @default("") @db.VarChar
file_file_name String? @db.VarChar
file_content_type String? @db.VarChar
file_file_size Int?
file_updated_at DateTime? @db.Timestamp(6)
meta Json? @db.Json
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
}
model status_pins {
id BigInt @id @default(autoincrement())
account_id BigInt
status_id BigInt
created_at DateTime @default(now()) @db.Timestamp(6)
updated_at DateTime @default(now()) @db.Timestamp(6)
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_d4cb435b62")
statuses statuses @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_65c05552f1")
@@unique([account_id, status_id], map: "index_status_pins_on_account_id_and_status_id")
}
model status_stats {
id BigInt @id @default(autoincrement())
status_id BigInt @unique(map: "index_status_stats_on_status_id")
replies_count BigInt @default(0)
reblogs_count BigInt @default(0)
favourites_count BigInt @default(0)
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
statuses statuses @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_4a247aac42")
}
model statuses {
id BigInt @id @default(dbgenerated("timestamp_id('statuses'::text)"))
uri String? @unique(map: "index_statuses_on_uri") @db.VarChar
text String @default("")
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
in_reply_to_id BigInt?
reblog_of_id BigInt?
url String? @db.VarChar
sensitive Boolean @default(false)
visibility Int @default(0)
spoiler_text String @default("")
reply Boolean @default(false)
language String? @db.VarChar
conversation_id BigInt?
local Boolean?
account_id BigInt
application_id BigInt?
in_reply_to_account_id BigInt?
poll_id BigInt?
deleted_at DateTime? @db.Timestamp(6)
bookmarks bookmarks[]
favourites favourites[]
media_attachments media_attachments[]
mentions mentions[]
polls polls[]
status_pins status_pins[]
status_stats status_stats?
accounts_statuses_account_idToaccounts accounts @relation("statuses_account_idToaccounts", fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_9bda1543f7")
accounts_statuses_in_reply_to_account_idToaccounts accounts? @relation("statuses_in_reply_to_account_idToaccounts", fields: [in_reply_to_account_id], references: [id], onUpdate: NoAction, map: "fk_c7fa917661")
statuses_statuses_reblog_of_idTostatuses statuses? @relation("statuses_reblog_of_idTostatuses", fields: [reblog_of_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_256483a9ab")
other_statuses_statuses_reblog_of_idTostatuses statuses[] @relation("statuses_reblog_of_idTostatuses")
statuses_statuses_in_reply_to_idTostatuses statuses? @relation("statuses_in_reply_to_idTostatuses", fields: [in_reply_to_id], references: [id], onUpdate: NoAction, map: "fk_rails_94a6f70399")
other_statuses_statuses_in_reply_to_idTostatuses statuses[] @relation("statuses_in_reply_to_idTostatuses")
statuses_tags statuses_tags[]
@@index([in_reply_to_account_id], map: "index_statuses_on_in_reply_to_account_id")
@@index([in_reply_to_id], map: "index_statuses_on_in_reply_to_id")
@@index([reblog_of_id, account_id], map: "index_statuses_on_reblog_of_id_and_account_id")
}
model statuses_tags {
status_id BigInt
tag_id BigInt
tags tags @relation(fields: [tag_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_3081861e21")
statuses statuses @relation(fields: [status_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_df0fe11427")
@@unique([tag_id, status_id], map: "index_statuses_tags_on_tag_id_and_status_id")
@@index([status_id], map: "index_statuses_tags_on_status_id")
}
/// This model contains an expression index which requires additional setup for migrations. Visit https://pris.ly/d/expression-indexes for more info.
model tags {
id BigInt @id @default(autoincrement())
name String @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
usable Boolean?
trendable Boolean?
listable Boolean?
reviewed_at DateTime? @db.Timestamp(6)
requested_review_at DateTime? @db.Timestamp(6)
last_status_at DateTime? @db.Timestamp(6)
max_score Float?
max_score_at DateTime? @db.Timestamp(6)
account_tag_stats account_tag_stats?
featured_tags featured_tags[]
statuses_tags statuses_tags[]
}
model tombstones {
id BigInt @id @default(autoincrement())
account_id BigInt?
uri String @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
by_moderator Boolean?
accounts accounts? @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_f95b861449")
@@index([account_id], map: "index_tombstones_on_account_id")
@@index([uri], map: "index_tombstones_on_uri")
}
model user_invite_requests {
id BigInt @id @default(autoincrement())
user_id BigInt?
text String?
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
users users? @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_3773f15361")
@@index([user_id], map: "index_user_invite_requests_on_user_id")
}
model users {
id BigInt @id @default(autoincrement())
email String @unique(map: "index_users_on_email") @default("") @db.VarChar
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
encrypted_password String @default("") @db.VarChar
reset_password_token String? @unique(map: "index_users_on_reset_password_token") @db.VarChar
reset_password_sent_at DateTime? @db.Timestamp(6)
remember_created_at DateTime? @db.Timestamp(6)
sign_in_count Int @default(0)
current_sign_in_at DateTime? @db.Timestamp(6)
last_sign_in_at DateTime? @db.Timestamp(6)
current_sign_in_ip String? @db.Inet
last_sign_in_ip String? @db.Inet
admin Boolean @default(false)
confirmation_token String? @unique(map: "index_users_on_confirmation_token") @db.VarChar
confirmed_at DateTime? @db.Timestamp(6)
confirmation_sent_at DateTime? @db.Timestamp(6)
unconfirmed_email String? @db.VarChar
locale String? @db.VarChar
encrypted_otp_secret String? @db.VarChar
encrypted_otp_secret_iv String? @db.VarChar
encrypted_otp_secret_salt String? @db.VarChar
consumed_timestep Int?
otp_required_for_login Boolean @default(false)
last_emailed_at DateTime? @db.Timestamp(6)
otp_backup_codes String[] @db.VarChar
filtered_languages String[] @default([]) @db.VarChar
account_id BigInt
disabled Boolean @default(false)
moderator Boolean @default(false)
invite_id BigInt?
remember_token String? @unique(map: "index_users_on_remember_token") @db.VarChar
chosen_languages String[] @db.VarChar
created_by_application_id BigInt?
approved Boolean @default(true)
backups backups[]
identities identities[]
invites_invites_user_idTousers invites[] @relation("invites_user_idTousers")
markers markers[]
oauth_access_grants oauth_access_grants[]
oauth_access_tokens oauth_access_tokens[]
oauth_applications_oauth_applications_owner_idTousers oauth_applications[] @relation("oauth_applications_owner_idTousers")
session_activations session_activations[]
user_invite_requests user_invite_requests[]
accounts accounts @relation(fields: [account_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_50500f500d")
invites_users_invite_idToinvites invites? @relation("users_invite_idToinvites", fields: [invite_id], references: [id], onUpdate: NoAction, map: "fk_rails_8fb2a43e88")
oauth_applications_users_created_by_application_idTooauth_applications oauth_applications? @relation("users_created_by_application_idTooauth_applications", fields: [created_by_application_id], references: [id], onUpdate: NoAction, map: "fk_rails_ecc9536e7c")
web_push_subscriptions web_push_subscriptions[]
web_settings web_settings?
@@index([account_id], map: "index_users_on_account_id")
@@index([created_by_application_id], map: "index_users_on_created_by_application_id")
}
model web_push_subscriptions {
id BigInt @id @default(autoincrement())
endpoint String @db.VarChar
key_p256dh String @db.VarChar
key_auth String @db.VarChar
data Json? @db.Json
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
access_token_id BigInt?
user_id BigInt?
oauth_access_tokens oauth_access_tokens? @relation(fields: [access_token_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_751a9f390b")
users users? @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_rails_b006f28dac")
@@index([access_token_id], map: "index_web_push_subscriptions_on_access_token_id")
@@index([user_id], map: "index_web_push_subscriptions_on_user_id")
}
model web_settings {
id BigInt @id @default(autoincrement())
data Json? @db.Json
created_at DateTime @db.Timestamp(6)
updated_at DateTime @db.Timestamp(6)
user_id BigInt @unique(map: "index_web_settings_on_user_id")
users users @relation(fields: [user_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "fk_11910667b2")
}