Skip to content

Instantly share code, notes, and snippets.

@justindbaur
Created December 29, 2022 14:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save justindbaur/344281b76640f3318cb873c65151e96d to your computer and use it in GitHub Desktop.
Save justindbaur/344281b76640f3318cb873c65151e96d to your computer and use it in GitHub Desktop.
An example of a couple rows in the Bitwarden Database
Id UserId OrganizationId Type Data Favorites Folders Attachments CreationDate RevisionDate DeletedDate Reprompt
082db5fe-672d-4fe2-a408-aeaf00cfba97 d5f4a43b-d63b-48d4-ae35-aeae0132e6b1 NULL 1 {"Uris":[{"Uri":"2.a1+qHnq2WrpgAzWfMUEONg==|l0GkuwJXxz5RenMW8/9XrU3Kwo3ReYUpNjgcOtloSF8eKc5/uw/cW1ILTdABe5yY|JziTV78cdnLzPCHZYWpyHx3pAy2JDC97n1+K+Oy6Hf8="}],"Username":"2.Th3koMGmv+MygdZ8wK2Vrg==|sFsLK3PSaRtEAUU7Sk2g1g==|4dWvwEGBX4rwYYzOUEMPO9TmUc9uEHNiv/J8J+vvC/o=","Password":"2.SctMJiLmKL91oKl1xX90MA==|3QWIZvege3s2uVyFk+s3mQ==|x7669Eef8faZOL4Zuh70KVX7BQ3gRHKwZWCCoXUbuLk=","PasswordRevisionDate":"2022-12-29T14:13:16.392Z","Name":"2.NZwczlu5Y3FAY8DC02DmUw==|nnATSql7S0/dfqSnYsoC9dfxIxiXJqQezbZ5QnARN3E=|D8M9dftTvAARpYi3AAP4wgTAZ9KQPTwfiRK9VCb5fmA=","PasswordHistory":[{"Password":"2.yJMIvogMOpOAbHxHi8ArZQ==|IIV4d2XUlHPXvYx+k1pDKw==|zDH9xc0AzImXJasUXI4Pv16wkD537d8cl+UgICdk0zQ=","LastUsedDate":"2022-12-29T14:13:16.392Z"}]} {"D5F4A43B-D63B-48D4-AE35-AEAE0132E6B1":true} NULL NULL 2022-06-09 12:36:18.9300000 2022-12-29 14:13:29.3400000 NULL 1
Id UserId Name Type Identifier PushToken CreationDate RevisionDate
094d5d66-9926-4988-b794-aeae013319a2 d5f4a43b-d63b-48d4-ae35-aeae0132e6b1 firefox 10 f1d68af8-4934-4f26-9a33-fcda3f6f9079 NULL 2022-06-08 18:38:07.0400000 2022-06-08 18:38:07.0400000
Id Name BusinessName BillingEmail Plan PlanType Seats MaxCollections UseGroups UseDirectory UseTotp SelfHost Storage MaxStorageGb Gateway GatewayCustomerId GatewaySubscriptionId Enabled LicenseKey ExpirationDate CreationDate RevisionDate BusinessAddress1 BusinessAddress2 BusinessAddress3 BusinessCountry BusinessTaxNumber UsersGetPremium UseEvents Use2fa TwoFactorProviders UseApi UsePolicies Identifier ReferenceData UseSso UseResetPassword PublicKey PrivateKey OwnersNotifiedOfAutoscaling MaxAutoscaleSeats UseKeyConnector UseScim UseCustomPermissions
64758741-98f9-4ed7-9d27-aeba01172990 Enterprise Org NULL test+enterprise@email.com Enterprise (Annually) 11 29 NULL 1 1 1 1 NULL 1 0 cus_changedcusjustincase sub_changedsubjustincase 1 GUmf6MWLtSUE9i4raH44 2022-07-27 16:56:25.0000000 2022-06-20 16:56:23.9433333 2022-06-20 16:56:23.9433333 NULL NULL NULL NULL NULL 1 1 1 NULL 1 1 NULL {"id":null} 1 1 MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA7v0rGhnq6wGZkI6KmfKAyjcMrpA6HRayDpLwlBUTPVZmz0f3lNGE4YUOZN2f8ImheWE9ankffJWbJeW+enhW5f9BYVw84lTn+KZmhzk/crgBDFoz3fO/q03fjtpvrTVJVWXvCXM4pImOPaJiGIEtdAZIqjJgIkkw8kSD8guHfx/B0Yrygd1V8iHndrpe7xFC6Z0TGetC+tMw4Pxi5mpUrpkm8nOvs8R9YZofz9d0iO5/JCJO1knFqSMByPK0IG1nD4fUjkEVCixNl8Fjknd8a25LXQVvOe1M4i3EZU6yrLARqNFPSg4SwhubKiP0TlAxsujOZbYU3ZWPbuYfKMmjgQIDAQAB 2.Y0cOb2Pb2Y+bqRhVrMdhpA==|4rEv8EGIdXgJ39J00WTYFA1jY+oh6+ZqDnAwlnX2ULp1jES2drFQHDw1mdAYhPe8AdNen30eosnGDtOed064lCBmMeM4BRvbFXJixX56/brkwN7xVXzCvu7OaI1wuQuQ0yQdz2qob0diAVIaArhom4aRHzZhBx3VKxKPXywN86ldypYWtsf8fatBeNC7dm0IZpDeooVbBq06StakhLZAFwPMYFy4Sect59NBxqyxBw0ynlLmSynCGb+CF/T9ZzBTnW4WP7W9OgGVzVYPb5b+OnCtbqp4pAbR7HL/Sw0tcayBLLx/1x3z6Dqvu62dI1/+Oa/mYqper/oRKIWhF8/ZJUtYnZ6prx930FMvJqxBAAVRint2qfkVcXxZJfWESOqiektPWf6deXj+1I3A9TyfUzcucb2HgYYykj5535x74ZEm2SNBK5VQAwb+p6S7FxIT2Gb856oiz4ooFoHO4oy0bFOGxoueS9vqtUJMHjT0UCbMYKyJPnN2y4jqtrG5E9jMVzb5ZneE07iqOnVuVhIEm96XievhO7WC8uL4IlRSEIhRlcuW28wSIfOYBJRVlQVc/V6x6a8vdAu5mjhWPtmbITByc3lo+iKuaQsqjfEimqac8f9yiJCupGOTIXTfMRZhTgGDxbM6DyjTIvco+8XFWoAHSdjc3QsHpAH+lCdxW1Qj+3TzLyGFKsCinyvSx/WyAcZVZsLNNMlHLJ3imnR3DEYHPAEzsUmEla52VyppIf543UCiq7H8c4E2bOfvlASfT0F4nB7Cz8QepBT6E2Zzx8fss2LcGb1V0pBUQKQVlLnB/rByk+CzGHUH6sMAU0YamPCgB4LwUch+dHeFP6o0w/vntqWSn5T6JvZ11lfiZIdinWc2//Gu6bIVl8Ojxvj2Evy52/DoCzv/GR9X2+o08iCqrMLPKKgkWAvYrYmmhO/AUwDDqAQ6hzguk4slEIeA9Y9tiZv9kKwKDFcCvjMh+eYy8ovqufjn/79RqXRN9G/QQbkcaEuy4Li61xkh3SwkXGJLTq65RGie8rZERJGplPnWSvCvXnZdNI3DZMH9VzjdEGLX8/rnergZzmVvbAkhURXEP5vzjxYERtXslK2dCAGGrW2KTre2jzd8UrJ3QZmKthvaGBKBv1XJjAfrk6EphKE7ISSITHahTqf3ANWE9VFvO+tSLPCo01dO096sC+yQ9xRbfq3Ap+ItnKePEFogYvipdyKqkOAAf0rBJ9ZQBuxgzZKKS7htkfhBF/Nm7wc8DWBidl5fzfiKtB3361jaWLk5Nq8gnjGrSEdBPwR2SoTrb5d7NlrTXpOwthtu3xokJo1IJpIJdS8KyqOW2dS0d0oTOMGGXpBih4s6i4XKYWlXpmquDiMiXx2HJ8FLIxb3w0Tr3t0vVjmu5sS/DmrsalZM2qRlWrP0uhG8SgngptrcIv+V1x31znIrPrPvLdpmzj+EmDJWyQ1w4j+0mCKLEOdt4Yo/UzHP0bOlmYguis4720NwMARo3kYhesBgitSJfRamG9umkqSAVhL+/Wh224VTemP4i5xgCsOm+4TXZCZa5TI/KLPIHWH/RO0v3ZW43BdksRQ1xXD5/FwC51VNeZnRxAmatN4KHqmz89c3PjpgKa6P7jJaUqAOyat18WU=|oOgqZaUkcydo0ncbnx46+N+6PS1l2d1aqwBWgfETstE= 2022-09-14 11:59:41.7900000 NULL 0 0 1
Id Name Email EmailVerified MasterPassword MasterPasswordHint Culture SecurityStamp TwoFactorProviders TwoFactorRecoveryCode EquivalentDomains ExcludedGlobalEquivalentDomains AccountRevisionDate Key PublicKey PrivateKey Premium PremiumExpirationDate Storage MaxStorageGb Gateway GatewayCustomerId GatewaySubscriptionId LicenseKey CreationDate RevisionDate RenewalReminderDate Kdf KdfIterations ReferenceData ApiKey ForcePasswordReset UsesKeyConnector FailedLoginCount LastFailedLoginDate UnknownDeviceVerificationEnabled
d5f4a43b-d63b-48d4-ae35-aeae0132e6b1 My Enterprise Owner test+enterprise@email.com 0 AQAAAAEAAYagAAAAEOYrt/xn1iO3KrIP/VfvZ5Uxj6LGeuJG9WPQJMUZq0I8q80XCKQgGKJVK4c02fOMRQ== NULL en-US IOOO47RPSTEZATDYUC5OEJ4NX5GAJU4R NULL NULL NULL NULL 2022-12-29 14:13:29.3433333 2.cpoarSIIqhdlQPaA2VbFqw==|vE3oCaEvfhMtmyo6yLOG4VbQfTqpxRU0Vg0Gq6shTmtdoo+mtHQT/GqJ+0fHRXpAKubuaOvCXF/Y63OhBpnPJtTPQtPO2dCshtLgkZz6RHA=|MC7O31b0qqfOKnRE5yvZVxRwCtA+EF9SqDcV5p6PZfs= MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1txPyk/VL8LpKpKqic3pDksE386E3p0Oy29tdgTs3z0d1/wSUwOT+ENkogwa+PLL2ePXdWQE6LcA6mnl03OC7eVHUNpjuhr+ZlCEfV02s3vScFOFFV8yt7DMpCIA2ZJZRZk2opNwXaMUCZX7S/Bgtc+5Hzt7lxaY8HHbVBWKtMj95bPdE6584fZSBN0KRLiyaTgDtTQ+ntJVu+l8zc7y+ELcuC74pVDK4WCTE5dl4IfdASgRxMWWEtMNqnx8i9FlLK/W+BgP4q4v3hH9k/YuWMPJxkBWf+5Wl3k9C+IDuYhXjUWcEGO3T+06Yd3cEpXmQH03cDq/b00HOg6QXzGk5QIDAQAB 2.Z/Ehw2ukn6zg7YDEiXeowg==|OFQKnels+I9Si5uUCPUPlTz4kDikkdIDHIsWz040nPFWcyubdSbXa5tQHnevNuHvEc6hvbt0SlGQu7cLzaQ7DIYL2ZId+Zi3hcmYNSiTgfTPQwQibEalKzJM5kp43lJHCNvI6/k+hkPhov7TuZ4FJRcx89RLSlRpgFMDi+Tu59KzbWZ5V/2lqJFTmAsLFvGpobYK5Z8WGBNrbCzsPna/wfE4YTNULU2HgTns3ZvU1OUwxFFLTquns9GMGPR721wVkNpcsrM8z6cJa/amtTBRUUMKDkj+IF+YZ/18a0imt00d6fxfzC0i26rmu1hkG/V1E9Muvkt25ZkQtrFxNJOcOmyqG3Px8KzyIWU7vqqc4fKq09RGfCh7hvPx2KbG7GfNHbFzJ0sLAj7op1IrVhJBJ1N6Cl4IegTTK/8pKV31SOfn1Qd9UZ9TDyP8+2hSVvTS16QOBrwuOE0Meg820wdt7GvyCBlF9vZ8Qpk3W4wqBXUZUtCyTiKyysPl5BZjAmZzxHK+l5coW1tuZ40R3uKhv7tXDuM0GNccDwuIx9kM3l5W0v2Oo78G7HYEtGe9ZbGN7md0Lw2/zpv9SUtTLhgtVD3kZvavd5TIUxRRHIhE+mHu/AtkBy4f18BfQlr8LLEYdAKMhB7jqA0ASh66DFxanE7a7aPH5tiXe3FmUutIuHtsnfOPZSjXDqbh6BsT8YdqxvHNWYgyhFaqOaatxo62GsRUqTCS2ASuFUkrY/87M0z8J3G373hJR7RaQYIJuP6kNwYGjH76AJCajsP4/ze0xQuLAHo9fVTIF5hssK0VbDNbLDPIa80r6stgNqVh4q03qPRTYyVHDeYjS+E6tPs8k0r3b44v5RQvM05tNCtPk+QHCueyxUfMO6uAcqsoYk0w4vdKEKjXuKfnXuXFXsYf5W8v+d+rcP7mi+5hV+GsqgQBydG1jumt5OvYTy0jh7y4dppXfZon2JoSlqrXvVSVEIdYePgSsJRi08tWGljZX6LDbsV6oaDYcmwt3yEB4gDQl5QHV/tzkr+DPqt2aa8wE0Q+BHxjF1oyTrsnfbbrzgeGdHPaUxGEZFGB38Z5uCDzaJLppQBZAZlhGwgab8sKa0bCq/1LKq7URL1Cy1BCCNN5nd5MC7aR8O3BAt2AX7aVRGOHu7a5iCCAJpOxbvx8rgMRbZ0Qhqoik/mWrnaWVamj/p7R4xY64+4czF6KUUGbaTI8ZMx/HEJxShr+nT+FZRP9MNPmk6+s45SE8hey19idL+5CQLS2cGss0IZ/4V++Kz+xE7e+W1rGk2FS2MKu4J+CFQcj53UCMDgjNGCDwA3FcrJ58hxCFuwgHa7jhw6GtHcIN+O/SBL8O1H5KJJvuHPNUag30STSl5X8yXFyfjSL2YnBtPnw13y4MhqM7tyje13f6A30oZBlB2whDoF/k4ger+tVxW13yp3O5v5XJz+y0JDh5CQZRl4/Vlg7Ia2XUPZSvcLlW1RBosDctnSKrpgG3WuyxNQLhnozwwrir4dIXug8wKSAGVA417otIMNi12APi0FKiAqFC3Ckt+fm3i10+nhxaaN7Lc7o8IA3MJMrW8FKNyIrBjHutcoaY1KO7xgNQXY1XixpOJ0vSRiHn4fYuM+WPyEcuFOHf9TNHUU=|6ePd3s9LKUZbXCsbcsyO8qjlV9bRYKDhNf1Ht6z/RkE= 1 2023-06-08 18:49:36.0000000 NULL 1 0 cus_changedcusjustincase sub_changedsubjustincase 2yvThwUhiqol0ANDZZ0w 2022-06-08 18:37:23.2500000 2022-09-07 15:38:09.1600000 NULL 0 100000 {"id":null} 62602XgV5L8tkbfSqUeFCtHA91OiBy 0 0 0 2022-09-07 15:37:57.5566667 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment