# _collections

id: pbc_2279338944
type: base
name: _mfas
indexes: ["CREATE INDEX `idx_mfas_collectionRef_recordRef` ON `_mfas` (collectionRef,recordRef)"]
options: {}
created: 2025-04-17 20:34:51.534Z
updated: 2025-05-01 22:57:54.990Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1582905952","max":0,"min":0,"name":"method","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]

listRule:
  @request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId

viewRule:
  @request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId


id: pbc_1638494021
type: base
name: _otps
indexes: ["CREATE INDEX `idx_otps_collectionRef_recordRef` ON `_otps` (collectionRef, recordRef)"]
options: {}
created: 2025-04-17 20:34:51.538Z
updated: 2025-05-01 22:57:54.992Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"cost":8,"hidden":true,"id":"password901924565","max":0,"min":0,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"","hidden":true,"id":"text3866985172","max":0,"min":0,"name":"sentTo","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]

listRule:
  @request.auth.id != '' && recordRef = @request.auth.id && collectionRef = @request.auth.collectionId

viewRule:
[cell repeats an earlier one in this file: 100 characters]


id: pbc_2281828961
type: base
name: _externalAuths
options: {}
created: 2025-04-17 20:34:51.540Z
updated: 2025-05-01 22:57:54.993Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text2462348188","max":0,"min":0,"name":"provider","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1044722854","max":0,"min":0,"name":"providerId","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]

indexes:
  ["CREATE UNIQUE INDEX `idx_externalAuths_record_provider` ON `_externalAuths` (collectionRef, recordRef, provider)","CREATE UNIQUE INDEX `idx_externalAuths_collection_provider` ON `_externalAuths` (collectionRef, provider, providerId)"]

listRule:
[cell repeats an earlier one in this file: 100 characters]

viewRule:
[cell repeats an earlier one in this file: 100 characters]

deleteRule:
[cell repeats an earlier one in this file: 100 characters]


id: pbc_4275539003
type: base
name: _authOrigins
options: {}
created: 2025-04-17 20:34:51.543Z
updated: 2025-05-01 22:57:54.995Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text455797646","max":0,"min":0,"name":"collectionRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text127846527","max":0,"min":0,"name":"recordRef","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text4228609354","max":0,"min":0,"name":"fingerprint","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]

indexes:
  ["CREATE UNIQUE INDEX `idx_authOrigins_unique_pairs` ON `_authOrigins` (collectionRef, recordRef, fingerprint)"]

listRule:
[cell repeats an earlier one in this file: 100 characters]

viewRule:
[cell repeats an earlier one in this file: 100 characters]

deleteRule:
[cell repeats an earlier one in this file: 100 characters]


id: pbc_3142635823
type: auth
name: _superusers
created: 2025-04-17 20:34:51.545Z
updated: 2025-05-01 22:57:54.996Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":0,"hidden":true,"id":"password901924565","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9]{50}","hidden":true,"id":"text2504183744","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"email3885137012","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"},{"hidden":false,"id":"bool1547992806","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":true,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":true,"type":"autodate"}]

indexes:
  ["CREATE UNIQUE INDEX `idx_tokenKey_pbc_3142635823` ON `_superusers` (`tokenKey`)","CREATE UNIQUE INDEX `idx_email_pbc_3142635823` ON `_superusers` (`email`) WHERE `email` != ''"]

options:
  {"authRule":"","manageRule":null,"authAlert":{"enabled":true,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":null,"mappedFields":{"id":"","name":"","username":"","avatarURL":""},"enabled":false},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"IIgOa8O5OAuRUXJhPcajklRTylpJwiRMY1TaZdTSmajFeMWBKl","duration":86400},"passwordResetToken":{"secret":"3sT4kcJV00iPNcGletBl3stcXha3WPBHFSDDvMCYlKYBRx1XK4","duration":1800},"emailChangeToken":{"secret":"DGl4ZrZlOnRDCjIoQoqERckxrvRNXGVlxupmnVpgQzNRb2QITw","duration":1800},"verificationToken":{"secret":"gWksXJK3BbxgQCeunIYSBCl9wkYKwJX1lq9E4XX2YMEQUh4Jju","duration":259200},"fileToken":{"secret":"sMrjUsklMP9fAz9Yib7UdOTYpj0KwITfPzrfHqUTADPAWYX74G","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n  \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n  \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-password-reset/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n  \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}}


id: _pb_users_auth_
type: auth
name: users
deleteRule: @request.auth.provider = "google" || @request.auth.provider = "apple" || @request.auth.id != ""
created: 2025-04-17 20:34:51.550Z
updated: 2025-05-21 09:21:16.640Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cost":0,"hidden":true,"id":"password901924565","max":0,"min":8,"name":"password","pattern":"","presentable":false,"required":true,"system":true,"type":"password"},{"autogeneratePattern":"[a-zA-Z0-9]{50}","hidden":true,"id":"text2504183744","max":60,"min":30,"name":"tokenKey","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":true,"type":"text"},{"exceptDomains":null,"hidden":false,"id":"email3885137012","name":"email","onlyDomains":null,"presentable":false,"required":true,"system":true,"type":"email"},{"autogeneratePattern":"","hidden":false,"id":"text1579384326","max":255,"min":0,"name":"name","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text4166911607","max":20,"min":3,"name":"username","pattern":"^[a-zA-Z0-9_]+$","presentable":true,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"bool4026156869","name":"isPremium","presentable":false,"required":false,"system":false,"type":"bool"},{"autogeneratePattern":"","hidden":false,"id":"text3559392082","max":0,"min":0,"name":"subscriptionPlan","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text3009427015","max":0,"min":0,"name":"purchaseToken","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text3270783252","max":0,"min":0,"name":"transactionId","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text4036877950","max":0,"min":0,"name":"originalTransactionId","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"date730627375","max":"","min":"","name":"expiresAt","presentable":false,"required":false,"system":false,"type":"date"},{"hidden":false,"id":"bool305309887","name":"showUsername","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"bool3938116568","name":"isAchievementsPublic","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"bool1694014235","name":"termsAccepted","presentable":false,"required":true,"system":false,"type":"bool"},{"hidden":false,"id":"date1542800728","max":"","min":"","name":"termsAcceptedAt","presentable":false,"required":true,"system":false,"type":"date"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"},{"autogeneratePattern":"","hidden":false,"id":"text1154108520","max":0,"min":0,"name":"oauthId","pattern":"","presentable":false,"primaryKey":false,"required":false,"system":false,"type":"text"},{"hidden":false,"id":"bool256245529","name":"verified","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"bool1547992806","name":"emailVisibility","presentable":false,"required":false,"system":true,"type":"bool"},{"hidden":false,"id":"file376926767","maxSelect":1,"maxSize":0,"mimeTypes":["image/jpeg","image/png","image/svg+xml","image/gif","image/webp"],"name":"avatar","presentable":false,"protected":false,"required":false,"system":false,"thumbs":null,"type":"file"}]

indexes:
  ["CREATE UNIQUE INDEX `idx_tokenKey__pb_users_auth_` ON `users` (`tokenKey`)","CREATE UNIQUE INDEX `idx_email__pb_users_auth_` ON `users` (`email`) WHERE `email` != ''","CREATE INDEX `idx_ffgcyIJU7h` ON `users` (`username`)"]

options:
  {"authRule":"","manageRule":null,"authAlert":{"enabled":false,"emailTemplate":{"subject":"Login from a new location","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eWe noticed a login to your {APP_NAME} account from a new location.\u003c/p\u003e\n\u003cp\u003eIf this was you, you may disregard this email.\u003c/p\u003e\n\u003cp\u003e\u003cstrong\u003eIf this wasn't you, you should immediately change your {APP_NAME} account password to revoke access from all other locations.\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}},"oauth2":{"providers":[{"pkce":null,"name":"google","clientId":"758363552639-473nr7gmqhjde1aoofuqaep2ne3brg4i.apps.googleusercontent.com","clientSecret":"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","authURL":"","tokenURL":"","userInfoURL":"","displayName":"","extra":null},{"pkce":null,"name":"apple","clientId":"loveroll.apple.login","clientSecret":"eyJhbGciOiJFUzI1NiIsImtpZCI6Ik5VNUdWSkdENVMiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiI1NzU4S0FGWDQ4Iiwic3ViIjoibG92ZXJvbGwuYXBwbGUubG9naW4iLCJhdWQiOlsiaHR0cHM6Ly9hcHBsZWlkLmFwcGxlLmNvbSJdLCJleHAiOjE3NjE4MDU1OTksImlhdCI6MTc0NjAyODU5OX0.S3EKbujk4HtQzEILvGFJwzKfdeXKPDMMVHWHj133n6nqVL6ApsDpsdg1o9RvPwmWcUmA5lUokCf_AdHL7eWQlQ","authURL":"","tokenURL":"","userInfoURL":"","displayName":"","extra":null}],"mappedFields":{"id":"oauthId","name":"name","username":"","avatarURL":"avatar"},"enabled":true},"passwordAuth":{"enabled":true,"identityFields":["email"]},"mfa":{"enabled":false,"duration":1800,"rule":""},"otp":{"enabled":false,"duration":180,"length":8,"emailTemplate":{"subject":"OTP for {APP_NAME}","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eYour one-time password is: \u003cstrong\u003e{OTP}\u003c/strong\u003e\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask for the one-time password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}},"authToken":{"secret":"8U5u27x03nBD2qYqL2svp3R7FWbIUCXFz2doIqMIy6hiC5qX4R","duration":7776000},"passwordResetToken":{"secret":"vAQwzxwNGbGXNdFHQLXXHC4WSWe27gY9Pv2110O54L2g729yvN","duration":1800},"emailChangeToken":{"secret":"NzZGBttgy0s59hcANuTIDG78FHuzCcut0JYCDAybI5P3sb2dDF","duration":1800},"verificationToken":{"secret":"6u9xrEMwaLZumSTjSMAumudZbnrrnR1cOtdCowivTBjAegzjVZ","duration":259200},"fileToken":{"secret":"PZedXDMbtxk8oZRSvDoHIf0oujGnu2sXmTidK6rBpmBdW5RUs4","duration":180},"verificationTemplate":{"subject":"Verify your {APP_NAME} email","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eThank you for joining us at {APP_NAME}.\u003c/p\u003e\n\u003cp\u003eClick on the button below to verify your email address.\u003c/p\u003e\n\u003cp\u003e\n  \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-verification/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eVerify\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"},"resetPasswordTemplate":{"subject":"Reset your {APP_NAME} password","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to reset your password.\u003c/p\u003e\n\u003cp\u003e\n  Reset password:\n  loveroll://reset?token={TOKEN}\n  \u003ca class=\"btn\" href=\"https://loveroll-app.gigaui.team/reset?token={TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eReset password\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to reset your password, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"},"confirmEmailChangeTemplate":{"subject":"Confirm your {APP_NAME} new email address","body":"\u003cp\u003eHello,\u003c/p\u003e\n\u003cp\u003eClick on the button below to confirm your new email address.\u003c/p\u003e\n\u003cp\u003e\n  \u003ca class=\"btn\" href=\"{APP_URL}/_/#/auth/confirm-email-change/{TOKEN}\" target=\"_blank\" rel=\"noopener\"\u003eConfirm new email\u003c/a\u003e\n\u003c/p\u003e\n\u003cp\u003e\u003ci\u003eIf you didn't ask to change your email address, you can ignore this email.\u003c/i\u003e\u003c/p\u003e\n\u003cp\u003e\n  Thanks,\u003cbr/\u003e\n  {APP_NAME} team\n\u003c/p\u003e"}}


id: pbc_2151843437
type: base
name: favorites
indexes: []
options: {}
created: 2025-04-18 12:49:25.577Z
updated: 2025-05-01 22:57:55.000Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cascadeDelete":false,"collectionId":"_pb_users_auth_","hidden":false,"id":"relation344172009","maxSelect":1,"minSelect":0,"name":"user","presentable":false,"required":true,"system":false,"type":"relation"},{"autogeneratePattern":"","hidden":false,"id":"text252309069","max":0,"min":0,"name":"myRes","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1681070533","max":0,"min":0,"name":"oppRes","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]


id: pbc_3085411453
type: base
name: rooms
indexes: []
listRule: @request.auth.id != ""
viewRule: @request.auth.id != ""
createRule: @request.auth.id != ""
updateRule: @request.auth.id != ""
options: {}
created: 2025-04-18 12:49:25.583Z
updated: 2025-05-06 11:24:46.235Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text2758018014","max":0,"min":0,"name":"roomId","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text2061365800","max":0,"min":0,"name":"gameType","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"json642663334","maxSize":0,"name":"players","presentable":false,"required":false,"system":false,"type":"json"},{"hidden":false,"id":"json2678318100","maxSize":0,"name":"results","presentable":false,"required":false,"system":false,"type":"json"},{"hidden":false,"id":"json3783284288","maxSize":0,"name":"lastRoll","presentable":false,"required":false,"system":false,"type":"json"},{"hidden":false,"id":"json1515332622","maxSize":0,"name":"lastReset","presentable":false,"required":false,"system":false,"type":"json"}]


id: pbc_1649388127
type: base
name: progress
indexes: []
options: {}
created: 2025-04-18 12:49:25.584Z
updated: 2025-05-01 22:57:55.004Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cascadeDelete":false,"collectionId":"_pb_users_auth_","hidden":false,"id":"relation2375276105","maxSelect":1,"minSelect":0,"name":"user","presentable":false,"required":true,"system":false,"type":"relation"},{"autogeneratePattern":"","hidden":false,"id":"text252309069","max":0,"min":0,"name":"myRes","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"autogeneratePattern":"","hidden":false,"id":"text1681070533","max":0,"min":0,"name":"oppRes","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]


id: user_achievements_4948
type: base
name: user_achievements
indexes: []
listRule: @request.auth.id != ""
viewRule: @request.auth.id != ""
createRule: @request.auth.id != ""
updateRule: @request.auth.id != ""
deleteRule: @request.auth.id = user.id
options: {}
created: 2025-05-01 22:35:42.663Z
updated: 2025-05-04 17:14:49.604Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cascadeDelete":true,"collectionId":"_pb_users_auth_","hidden":false,"id":"relation2375276105","maxSelect":1,"minSelect":0,"name":"user","presentable":false,"required":true,"system":false,"type":"relation"},{"autogeneratePattern":"","hidden":false,"id":"text724990059","max":100,"min":1,"name":"title","pattern":"","presentable":false,"primaryKey":false,"required":true,"system":false,"type":"text"},{"hidden":false,"id":"bool17505815","name":"unlocked","presentable":false,"required":true,"system":false,"type":"bool"},{"hidden":false,"id":"bool4208731335","name":"isPublic","presentable":false,"required":false,"system":false,"type":"bool"},{"hidden":false,"id":"number2199029708","max":null,"min":0,"name":"likesCount","onlyInt":false,"presentable":false,"required":false,"system":false,"type":"number"},{"hidden":false,"id":"autodate2011722078","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"}]


id: pbc_2190274710
type: base
name: achievement_likes
indexes: ["CREATE UNIQUE INDEX idx_user_achievement ON achievement_likes (user, achievement);"]
listRule: @request.auth.id != "" && user.id = @request.auth.id
viewRule: @request.auth.id != "" && user.id = @request.auth.id
createRule: @request.auth.id != "" && achievement != ""
deleteRule: @request.auth.id != "" && user.id = @request.auth.id
options: {}
created: 2025-05-02 22:55:17.428Z
updated: 2025-05-03 00:50:48.421Z
fields:
  [{"autogeneratePattern":"[a-z0-9]{15}","hidden":false,"id":"text3208210256","max":15,"min":15,"name":"id","pattern":"^[a-z0-9]+$","presentable":false,"primaryKey":true,"required":true,"system":true,"type":"text"},{"cascadeDelete":true,"collectionId":"_pb_users_auth_","hidden":false,"id":"relation2375276105","maxSelect":1,"minSelect":0,"name":"user","presentable":false,"required":false,"system":false,"type":"relation"},{"cascadeDelete":true,"collectionId":"user_achievements_4948","hidden":false,"id":"relation2524151793","maxSelect":1,"minSelect":0,"name":"achievement","presentable":false,"required":true,"system":false,"type":"relation"},{"hidden":false,"id":"autodate2990389176","name":"created","onCreate":true,"onUpdate":false,"presentable":false,"system":false,"type":"autodate"},{"hidden":false,"id":"autodate3332085495","name":"updated","onCreate":true,"onUpdate":true,"presentable":false,"system":false,"type":"autodate"}]


