 Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/gositeme/domains/lavocat.quebec/public_html/prisma/ |
SQLite format 3 @ � 8 � � .zp` Z /�����������������������~xrlZZZ ?
S- indexsqlite_autoindex_case_assignments_1case_assignments �/##�%tablepermissionspermissionsCREATE TABLE "permissions" (
"id" TEXT NOT NULL PRIMARY KEY,
"role" TEXT NOT NULL,
"resource" TEXT NOT NULL,
"action" TEXT NOT NULL,
"conditions" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)5I# indexsqlite_autoindex_permissions_1permissions �1##�)tableUserProfileUserProfileCREATE TABLE "UserProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"availability" TEXT,
"workingHours" TEXT,
CONSTRAINT "UserProfile_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)5I# indexsqlite_autoindex_UserProfile_1UserProfile�N�{tableusersusersCREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"linkedinUrl" TEXT,
"websiteUrl" TEXT,
"availability" TEXT,
"timezone" TEXT,
"pronouns" TEXT,
"isProfilePublic" BOOLEAN NOT NULL DEFAULT false,
"lastActive" DATETIME,
"hourlyRate" REAL,
"proBono" BOOLEAN NOT NULL DEFAULT false,
"boldnessRating" REAL,
"transparencyRating" REAL,
"winRate" REAL,
"totalCases" INTEGER NOT NULL DEFAULT 0,
"wonCases" INTEGER NOT NULL DEFAULT 0,
"lostCases" INTEGER NOT NULL DEFAULT 0,
"averageRating" REAL,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"xpPoints" INTEGER NOT NULL DEFAULT 0,
"level" INTEGER NOT NULL DEFAULT 1,
"currentStreak" INTEGER NOT NULL DEFAULT 0,
"totalBadges" INTEGER NOT NULL DEFAULT 0,
"reviewsWritten" INTEGER NOT NULL DEFAULT 0,
"forumPosts" INTEGER NOT NULL DEFAULT 0,
"helpedOthers" INTEGER NOT NULL DEFAULT 0,
"observationHours" REAL NOT NULL DEFAULT 0,
"reformProposals" INTEGER NOT NULL DEFAULT 0,
"wisdomScore" REAL NOT NULL DEFAULT 0,
"civicEngagement" REAL NOT NULL DEFAULT 0,
"accountBalance" REAL NOT NULL DEFAULT 0.0,
"isPaymentVerified" BOOLEAN NOT NULL DEFAULT false,
"donationTotal" REAL NOT NULL DEFAULT 0.0,
"subscriptionTier" TEXT,
"subscriptionExpiry" DATETIME,
"theme" TEXT NOT NULL DEFAULT 'light',
"gender" TEXT,
"phone" TEXT,
"address" TEXT,
"emergencyContact" TEXT,
"emergencyPhone" TEXT,
"dateOfBirth" DATETIME,
"occupation" TEXT,
"language" TEXT NOT NULL DEFAULT 'en',
"notifications" BOOLEAN NOT NULL DEFAULT true,
"lawFirmId" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"experience" INTEGER,
"rating" REAL,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
))= indexsqlite_autoindex_users_1users�Z11�_table_prisma_migrations_prisma_migrationsCREATE TABLE "_prisma_migrations" (
"id" TEXT PRIMARY KEY NOT NULL,
"checksum" TEXT NOT NULL,
"finished_at" DATETIME,
"migration_name" TEXT NOT NULL,
"logs" TEXT,
"rolled_back_at" DATETIME,
"started_at" DATETIME NOT NULL DEF �' � � � � �{ �l �e ́M ��7 ��' �� �� �� �� �� �} {s rk ib `[ UR NH GC <: 12 &(
O p�.
� � B �
�
G � V�^� z�;��O �
U�
Y 3f9758ef-5567-4d48-a9e7-806e65b8c5009fc6de7a5a15a130c05e9f76f67cfca071ba4d0374cca1b9ddd094abfd754868�VK�20250714094849_add_profile_views_field�VK �
U�
U f8724682-1288-43e3-beeb-1365eb7a640262eebf59d52e6ad9efcff41820d8c52d8133fdf708afbf1984a0955383bf0bd7�S��20250714094601_add_user_follow_model�S�\�%
U�
c 5fce1ba5-cc8e-4026-b276-2d1c9764735bc73edd2a6ac29f70e8261569fb5407fb54ca8c795357d289031a508776bd0699�Pi�20250714094224_add_total_endorsements_field�Pih�
U�
O dc88bfa2-b712-4825-9e4a-596cd3c4297762abbd48ba51833382c42bfb7f9588e79d748399734deac1bea68a93b0bfe906�CwL20250714092815_add_missing_models�Cw#�
U�
U a95fc42a-b02d-4c2e-bb58-daff3bef2bd6852606e58f951d6be13496a723aac69c64513d228937e36c9545a3173e41cc46�;�Z20250714091955_add_endorsement_model�;�?�!
U�
[ 1a989090-f229-40f9-a970-cb20de582632a746a134c0f702f3639f930117c87f11ba0d8128dd90a3009eab56448e9a8776�020250714090706_add_comment_report_model�0S�
U�
S df06a76a-0081-44fd-8b0e-d636d9665b817714630ca7aae889511921d15c77adcfbe4e1d18ce08f676489001c6ccdac94c��f�20250713165624_add_search_analytics��f��
U�
S 2db23faa-9db4-41e8-bdd9-3463f5a675f7537084de5625a995020e210df6974cffd9c00be34d5aac642943f5beefe56b9c����20250713160104_add_privacy_settings����!
U�
[ 740ad4fb-6057-4c9a-a7a4-b8352dbda47fedf458b5bfccf8a219903476b03c2b8218bd91d7271753cdb98a6ad089533372��� 20250713155654_add_show_friends_to_user���q�$
U�
a cccc35db-8f99-4604-9a8d-1d2b2465320cebfbe115209c0fae57af6e6f77fe0209e55f923677bdddad7a3eaff870eeb583�dG20250713152537_remove_duplicate_case_model�dF��*
U�
m 0a28eb77-5821-4275-b23c-5b1a83cc468a567f47b9c35d13002cba81ec6688ef1ebefd59c33758bf46be16afe23c873f4e�X�T20250713151254_add_friends_and_case_participants�X�#�/
U�
w 9ad84e5d-f9e8-4ebe-a11f-8d68b8cc2c59d709f97d3e3e21c726547decc04282efdd68b48e3b2cf99f3fc3c8e32a34f834���Ȫ20250711182922_add_public_and_description_to_document���� �
U�
M c600a3a5-57f2-49ce-ac37-5224860849a5e79cba40c2c0c95b029d9dee43d381fcf6b1b7282c252cf9074af7296a5b6f06����t20250710190336_add_case_logo_url����C�
U�
W a1c47619-9d73-466b-957e-3ef223b13f11630c4b088ded77733c600f64ee762c322e9a9582cb5d90c30a6462be3f4ad7a2��a� 20250709181021_add_case_chat_messages��a��!
U�
[ e9c806a7-51ea-411c-aaf9-04faef50f755a45b6c7acbdf8ca774a3aab603bdf1bc47e64cd9feeb69a003d6b9608d9e25ee��P�'20250708043510_add_barreau_profile_json��P��
U�
Y be812ce2-163f-4edb-8ca4-692d3ab3aeb178588ecc1eff58a59dda83b5b84f6a2b5e631a785d5ebaffbd47d22d3e814b96�� DC20250706140204_add_comment_attachments�� D8�1
U�
{ 7d767366-27b6-4ce0-932a-50ca21a4239c36526c369161743086572451435ca9c06d6aebeb0b246d209c0c33fb86e9f2cc��
w20250706032039_add_expires_at_to_impersonation_sessions��
d�&
U�
e e37aa0b2-2798-470b-b23f-59c4474e315d2610af766bd5645111d36cd95dbfad0e7059cc8d3bfd235e8d327b6fda0628cd��� 20250705192944_add_admin_verification_fields���
U�
Q 93e73e6f-5432-4671-a188-76992ad12022c5a968048597bc3f4694316e4dc2536c51e500ef94510656f068cd2550e4d64b���<y20250705181550_enrich_user_profile���<c�!
U�
[ 98d8fb00-40d3-43d9-9cfd-d5b4e4a8bf98f4adbd057fd8fa1e9019d60d189f95ecf9982764ed56d82e01fa2a430dc87400��_��20250705161612_add_barreau_verification��_�[�
U�
U fd0ebc18-5e3d-4662-8262-3fa465ada34fad449e6b01c52df9b71f4217ef4e73a86ac2af7be192b6d4222f693ffce7dba1��&��20250705103414_add_comment_reactions��&���
U�
U 2b802e2e-4592-4bf7-8023-ddc120123a5121e13da7e051f7650ce6328a29db3da16dd8cdfc282707154eec5634ab633a71��"�20250705102915_add_threaded_comments��"T�
U�
3 15f0aed3-f20b-4f08-95d3-f17f8688da5230c18cb724054b1c4a932b50881ab9642a1e7a75a6a7253bd5ef1255d862e8b2�� !�20250704151341_init��
R
��
�
q R �
��4]g ��>
� �
H � {� (U3f9758ef-5567-4d48-a9e7-806e65b8c500(Uf8724682-1288-43e3-beeb-1365eb7a6402(U5fce1ba5-cc8e-4026-b276-2d1c9764735b(Udc88bfa2-b712-4825-9e4a-596cd3c42977(Ua95fc42a-b02d-4c2e-bb58-daff3bef2bd6(U1a989090-f229-40f9-a970-cb20de582632(Udf06a76a-0081-44fd-8b0e-d636d9665b81(U2db23faa-9db4-41e8-bdd9-3463f5a675f7(U740ad4fb-6057-4c9a-a7a4-b8352dbda47f(Ucccc35db-8f99-4604-9a8d-1d2b2465320c(U0a28eb77-5821-4275-b23c-5b1a83cc468a
(U9ad84e5d-f9e8-4ebe-a11f-8d68b8cc2c59 (Uc600a3a5-57f2-49ce-ac37-5224860849a5 (Ua1c47619-9d73-466b-957e-3ef223b13f11
(Ue9c806a7-51ea-411c-aaf9-04faef50f755 (Ube812ce2-163f-4edb-8ca4-692d3ab3aeb1(U7d767366-27b6-4ce0-932a-50ca21a4239c(Ue37aa0b2-2798-470b-b23f-59c4474e315d(U93e73e6f-5432-4671-a188-76992ad12022(U98d8fb00-40d3-43d9-9cfd-d5b4e4a8bf98(Ufd0ebc18-5e3d-4662-8262-3fa465ada34f(U2b802e2e-4592-4bf7-8023-ddc120123a51'U 15f0aed3-f20b-4f08-95d3-f17f8688da52
� ���uO8����wZ9
�
�
�
�
e
D
� � 'Syalda.machouf-khadir@adwavocats.com$Mvirginie.dufresne@adwavocats.com+[virginie.dufresne-lemire@adwavocats.com
Ethomas.leblanc@adwavocats.ca Csophie.dubois@adwavocats.ca#Kolivia.malenfant@adwavocats.com"Immah.nora.toure@adwavocats.com Amarie.champion@lawfirm.com'Smarie-claude.tremblay@adwavocats.ca%Omarc-andre.bouchard@adwavocats.ca Ejustine.monty@adwavocats.com =justin.wee@adwavocats.ca Ejerome.aucoin@adwavocats.com Civan.lazarov@adwavocats.com$Misabella.rodriguez@adwavocats.ca
Aimane.melab@adwavocats.com Adavid.justice@advocates.ca =david.chen@adwavocats.ca3 dannywperez@msn.com%Odannywperez+1752157338554@msn.com"Iaudrey.labrecque@adwavocats.ca.aantoine.duranleau-hendrickx@adwavocats.com"Ialain.arsenault@adwavocats.com/admin@example.com
C ��������r[K:)������uZC 1yaldamachoufkhadir9virginiedufresnelemire
-virginiedufresne)thomas.leblanc 'sophie.dubois+oliviamalenfant'mmahnoratoure7marie-claude.tremblay)marie-champion5marc-andré.bouchard
justinwee%justinemonty%jeromeaucoin#ivanlazarov1isabella.rodriguez
!imanemelab!david.chen'david-justice
! dannyperez-audrey.labrecque ?antoineduranleauhendrickx)alainarsenault
� f� � ???-? ?cmcqvgmfj0007vj9gbx2qfsgkcmcqjb6o80009vjfk3wo56kx0cmcqfhsqx0001vjhc8ntsvvrcassistant_lawyer���<�cmcpzyavn0002vjz01slrcn51cmcpzyax8000avjz0ao7zkw1g� ???#? ?cmcqjb6om000cvjfkt0yeyvc4cmcqjb6o80009vjfk3wo56kx0cmcpzyawf0006vjz02w4s3ilalead_lawyer�۱ѓcmcpzyavn0002vjz01slrcn51cmcpzyax8000avjz0ao7zkw1g
� �� ?cmcqvgmfj0007vj9gbx2qfsgk ? cmcqjb6om000cvjfkt0yeyvc4
� =
���o=
t � �kk ?
S- indexsqlite_autoindex ?
S- indexsqlite_autoindex_case_assignments_1case_assignments 5I# indexsqlite_autoindex_permissions_1permissions �/##�%tablepermissionspermissionsCREATE TABLE "permissions" (
"id" TEXT NOT NULL PRIMARY KEY,
"role" TEXT NOT NULL,
"resource" TEXT NOT NULL,
"action" TEXT NOT NULL,
"conditions" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)5I# indexsqlite_autoindex_UserProfile_1UserProfile�1##�)tableUserProfileUserProfileCREATE TABLE "UserProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"availability" TEXT,
"workingHours" TEXT,
CONSTRAINT "UserProfile_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)
� ��{tableusersusersCREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" T� %%�tableRegistrationRegistrationCREATE TABLE "Registration" (
"id" TEXT NOT NULL PRIMARY KEY,
"firstName" TEXT NOT NULL,
"lastName" TEXT NOT NULL,
"email" TEXT NOT NULL,
"phone" TEXT NOT NULL,
"birthDate" DATETIME NOT NULL,
"gender" TEXT,
"relationship" TEXT NOT NULL,
"preferredLanguage" TEXT NOT NULL,
"preferredContactMethod" TEXT NOT NULL,
"message" TEXT,
"additionalNotes" TEXT,
"lawyerName" TEXT,
"lawyerEmail" TEXT,
"lawyerPhone" TEXT,
"lawFirm" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"userId" TEXT,
"createdBy" TEXT,
"reminders" TEXT DEFAULT '[]',
"previousLegalActions" TEXT,
"reasonForJoining" TEXT,
"howDidYouHearAboutUs" TEXT,
"representation" TEXT,
"urgentNeeds" TEXT,
"caseId" TEXT,
CONSTRAINT "Registration_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "Registration_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "Registration_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)?
S- indexsqlite_autoindex_case_assignments_1case_assignments �$ --�{tablecase_assignmentscase_assignments
CREATE TABLE "case_assignments" (
"id" TEXT NOT NULL PRIMARY KEY,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"role" TEXT NOT NULL,
"assignedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"assignedBy" TEXT NOT NULL,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"caseId" TEXT,
CONSTRAINT "case_assignments_assignedBy_fkey" FOREIGN KEY ("assignedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_assignments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_assignments_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "case_assignments_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)5I# indexsqlite_autoindex_permissions_1permissions � += indexsqlite_autoindex_users_1users�Z11�_table_prisma_migrations_prisma_migrationsCREATE TABLE "_prisma_migrations" (
"id" TEXT PRIMARY KEY NOT NULL,
"checksum" TEXT NOT NULL,
"finished_at" DATETIME,
"migration_name" TEXT NOT NULL,
"logs" TEXT,
"rolled_back_at" DATETIME,
"started_at" DATETIME NOT NULL DEFAULT current_timestamp,
"applied_steps_count" INTEGER UNSIGNED NOT NULL DEFAULT 0
)CW1 indexsqlite_autoindex__prisma_migrations_1_prisma_migrations
�
� �������
�
u
� F F 3G! indexsqlite_autoindex_FileUpload_1FileUpload�2�;tableSessionSessionCREATE T�.//� tableVerificationTokenVerificationTokenCREATE TABLE "VerificationToken" (
"identifier" TEXT NOT NULL,
"token" TEXT NOT NULL,
"expires" DATETIME NOT NULL
)-A indexsqlite_autoindex_Session_1Session�2�;tableSessionSessionCREATE TABLE "Session" (
"id" TEXT NOT NULL PRIMARY KEY,
"sessionToken" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"expires" DATETIME NOT NULL,
CONSTRAINT "Session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)7K% indexsqlite_autoindex_DetaineeInfo_1DetaineeInfo�G%%�QtableDetaineeInfoDetaineeInfoCREATE TABLE "DetaineeInfo" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"facility" TEXT NOT NULL,
"inmateId" TEXT NOT NULL,
"incarcerationDate" DATETIME NOT NULL,
"expectedReleaseDate" DATETIME,
"registrationId" TEXT NOT NULL,
CONSTRAINT "DetaineeInfo_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)-A indexsqlite_autoindex_Address_1Address�
�tableAddressAddressCREATE TABLE "Address" (
"id" TEXT NOT NULL PRIMARY KEY,
"street" TEXT NOT NULL,
"city" TEXT NOT NULL,
"state" TEXT NOT NULL,
"postalCode" TEXT NOT NULL,
"country" TEXT NOT NULL,
"registrationId" TEXT NOT NULL,
CONSTRAINT "Address_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)7 K% indexsqlite_autoindex_Registration_1Registration �%%�tableRegistrationRegistrationCREATE TABLE "Registration" (
"id" TEXT NOT NULL PRIMARY KEY,
"firstName" TEXT NOT NULL,
"lastName" TEXT NOT NULL,
"email" TEXT NOT NULL,
"phone" TEXT NOT NULL,
"birthDate" DATETIME NOT NULL,
"gender" TEXT,
"relationship" TEXT NOT NULL,
"preferredLanguage" TEXT NOT NULL,
"preferredContactMethod" TEXT NOT NULL,
"message" TEXT,
"additionalNotes" TEXT,
"lawyerName" TEXT,
"lawyerEmail" TEXT,
"lawyerPhone" TEXT,
"lawFirm" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"userId" TEXT,
"createdBy" TEXT,
"reminders" TEXT DEFAULT '[]',
"previousLegalActions" TEXT,
"reasonForJoining" TEXT,
"howDidYouHearAboutUs" TEXT,
"repr�] � tabledocumentsdocumentsCREATE TABLE "documents" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"title" TEXT,
"type" TEXT NOT NULL,
"url" TEXT NOT NULL,
"filePath" TEXT,
"fileSize" INTEGER,
"uploadedBy" TEXT,
"caseId" TEXT,
"status" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
CONSTRAINT "documents_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "documents_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "documents_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)3G! indexsqlite_autoindex_FileUpload_1FileUpload�s!!�1tableFileUploadFileUploadCREATE TABLE "FileUpload" (
"id" TEXT NOT NULL PRIMARY KEY,
"originalName" TEXT NOT NULL,
"storedName" TEXT NOT NULL,
"mimeType" TEXT NOT NULL,
"size" INTEGER NOT NULL,
"path" TEXT NOT NULL,
"registrationId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)�.//� tableVerificationTokenVerificationTokenCREATE TABLE "VerificationToken" (
"identifier" TEXT NOT NULL,
"token" TEXT NOT NULL,
"expires" DATETIME NOT NULL
)-A indexsqlite_autoindex_Session_1Session
9 9 �T ?3!�G�D ?3! ? ?cmcqjb6o80009vjfk3wo56kx0DannyPEREZdannywperez@msn.com4504217379 ���� maleselfenemailCOMPLETED�۱ш��`�cmcpzyavn0002vjz01slrcn51[]searchyescmcpzyax8000avjz0ao7zkw1g
� � ? cmcqjb6o80009vjfk3wo56kx0
� � v?=A?cmcqjb6o8000avjfk3bfiv8mh1651 Rte des Sept ChutesSainte-Emelie-de-l'EnergieQCJ0K2K0CAcmcqjb6o80009vjfk3wo56kx0
� � ? cmcqjb6o8000avjfk3bfiv8mh
� � \? ?cmcsnrp200021vji4n30neczkDannybordeaux568454856� a� ��� cmcqjb6o80009vjfk3wo56kx0
� � ? cmcsnrp200021vji4n30neczk
� � w8 � � �� a a �� a a � /!C indexsqlite_autoindex_Cha�I 11�=tableDocumentPermissionDocumentPermission CREATE TABLE "DocumentPermission" (
"id" TEXT NOT NULL PRIMARY KEY,
"documentId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"canEdit" BOOLEAN NOT NULL DEFAULT false,
"canComment" BOOLEAN NOT NULL DEFAULT false,
"canView" BOOLEAN NOT NULL DEFAULT true,
"grantedById" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "DocumentPermission_documentId_fkey" FOREIGN KEY ("documentId") REFERENCES "documents" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "DocumentPermission_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "DocumentPermission_grantedById_fkey" FOREIGN KEY ("grantedById") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
�//� tableVerificationTokenVerificationTokenCREATE TABLE "VerificationToken�v %%�/tableThemeProfileThemeProfile"CREATE TABLE "ThemeProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"colors" TEXT NOTC W1 indexsqlite_autoindex_DocumentPermission_1DocumentPermission!�.//� tableVerificationTokenVerificationTokenCREATE TABLE "VerificationToken" (
"identifier" TEXT NOT NULL,
"token" TEXT NOT NULL,
"expires" DATETIME NOT NULL
)-A indexsqlite_autoindex_Session_1Session=Q+ indexsqlite_autoindex_DocumentComment_1DocumentComment �++�itableDocumentCommentDocumentComment CREATE TABLE "DocumentComment" (
"id" TEXT NOT NULL PRIMARY KEY,
"documentId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"content" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "DocumentComment_documentId_fkey" FOREIGN KEY ("documentId") REFERENCES "documents" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "DocumentComment_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=Q+ indexsqlite_autoindex_DocumentVersion_1DocumentVersion �H++�GtableDocumentVersionDocumentVersion CREATE TABLE "DocumentVersion" (
"id" TEXT NOT NULL PRIMARY KEY,
"documentId" TEXT NOT NULL,
"version" INTEGER NOT NULL,
"content" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"createdById" TEXT NOT NULL,
CONSTRAINT "DocumentVersion_documentId_fkey" FOREIGN KEY ("documentId") REFERENCES "documents" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "DocumentVersion_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) >E indexsqlite_autoindex_documents_1documents � tabledocumentsdocumentsCREATE TABLE "documents" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"title" TEXT,
"type" TEXT NOT NULL,
"url" TEXT NOT NULL,
"filePath" TEXT,
"fileSize" INTEGER,
"uploadedBy" TEXT,
"caseId" TEXT,
"status" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
CONSTRAINT "documents_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "documents_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "documents_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)3G! indexsqlite_autoindex_FileUpload_1FileUpload�s!!�1tableFileUploadFileUploadCREATE TABLE "FileUpload" (
"id" TEXT NOT NULL PRIMARY KEY,
"originalName" TEXT NOT NULL,
"storedName" TEXT NOT NULL,
"mimeType" TEXT NOT NULL,
"size" INTEGER NOT NULL,
"path" TEXT NOT NULL,
"registrationId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)
� ?cmcy5e33j0005tp2gde7qx9el ?cmcy1zp2i0005tpf04o4f7ie5 ? cmcy1rs790003tpf08z714h41
� Ax
� � �
K z��#N���
'^ � � ? u ?cmcqixuq2000jvjk85vjomkobGénéralCanal de discussion général pour tous les membres.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨSʁF
?-�_ ?cmcqixups000ivjk8d1v69tszE.D. de RobervalCanal de discussion pour Établissement de détention de Roberval. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��`
?G�y ?cmcqixupk000hvjk8t73ri2jlE.D. de Rivière-des-PrairiesCanal de discussion pour Établissement de détention de Rivière-des-Prairies. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��^
?E�w ?cmcqixupc000gvjk8935afkrjE.D. de Montréal (Bordeaux)Canal de discussion pour Établissement de détention de Montréal (Bordeaux). Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��L
?3�e ?cmcqixup3000fvjk85a7xenzyE.D. de Sorel-TracyCanal de discussion pour Établissement de détention de Sorel-Tracy. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��T
?;�m ?cmcqixuou000evjk8qxth410oE.D. de Trois-RivièresCanal de discussion pour Établissement de détention de Trois-Rivières. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��:
?'�M ?cmcqixuol000dvjk8lf2pyqtbE.L. de LavalCanal de discussion pour Établissement Leclerc de Laval. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��R
?9�k ?cmcqixuoc000cvjk8y360qcjqE.D. de Saint-JérômeCanal de discussion pour Établissement de détention de Saint-Jérôme. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��>
?%�W ?cmcqixuo1000bvjk81eamzfd0E.D. de HullCanal de discussion pour Établissement de détention de Hull. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS��ۨS��N
?5�g ?cmcqixunn000avjk82vudaa8aE.D. de Havre-AubertCanal de discussion pour Établissement de détention de Havre-Aubert. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨSs�ۨSs�B
?)�[ ?cmcqixun90009vjk8zuhtt6c4E.D. de PercéCanal de discussion pour Établissement de détention de Percé. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨSe�ۨSe�N
?5�g ?cmcqixumu0008vjk88o2vr6uaE.D. de New CarlisleCanal de discussion pour Établissement de détention de New Carlisle. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨSV�ۨSV�J
?1�c ?cmcqixume0007vjk8nlpcu3e8E.D. de SherbrookeCanal de discussion pour Établissement de détention de Sherbrooke. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨSF�ۨSF�J
?1�c ?cmcqixum40006vjk870h6x59sE.D. de Sept-ÎlesCanal de discussion pour Établissement de détention de Sept-Îles. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS<�ۨS<�L
?3�e ?cmcqixulu0005vjk8ct91sosyE.D. de Baie-ComeauCanal de discussion pour Établissement de détention de Baie-Comeau. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS3�ۨS3�_
?7� ?cmcqixulk0004vjk8wd6or2moE.D. de Québec – MCanal de discussion pour Établissement de détention de Québec – secteur masculin. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS(�ۨS(�_
?7� ?cmcqixulb0003vjk88ow1xju9E.D. de Québec – FCanal de discussion pour Établissement de détention de Québec – secteur féminin. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS �ۨS �F
?-�_ ?cmcqixuku0002vjk8xawkn130E.D. de RimouskiCanal de discussion pour Établissement de détention de Rimouski. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS�ۨS�<
?#�U ?cmcqixukg0001vjk82atot77sE.D. d'AmosCanal de discussion pour Établissement de détention d'Amos. Ouvert à tous les membres concernés.GROUPcmcqixujd0000vjk80kvazthp�ۨS �ۨS
� ����kM/����{]?!
�
� ?cmcqixuq2000jvjk85vjomkob ?cmcqixups000ivjk8d1v69tsz ?cmcqixupk000hvjk8t73ri2jl ?cmcqixupc000gvjk8935afkrj ?cmcqixup3000fvjk85a7xenzy ?cmcqixuou000evjk8qxth410o ?cmcqixuol000dvjk8lf2pyqtb
?cmcqixuoc000cvjk8y360qcjq ?cmcqixuo1000bvjk81eamzfd0 ?cmcqixunn000avjk82vudaa8a
?cmcqixun90009vjk8zuhtt6c4 ?cmcqixumu0008vjk88o2vr6ua ?cmcqixume0007vjk8nlpcu3e8 ?cmcqixum40006vjk870h6x59s ?cmcqixulu0005vjk8ct91sosy ?cmcqixulk0004vjk8wd6or2mo ?cmcqixulb0003vjk88ow1xju9 ?cmcqixuku0002vjk8xawkn130 ? cmcqixukg0001vjk82atot77s
+ �+�
�
� @���� +e �F())�GtablePrivateMessagePrivateMessage-CREATE TABLE "PrivateMessage" (
"id" TEXT NOT NULL PRIMARY KEY,
"content" TEXT NOT NULL,
"type" TEXT NOT NULL DEFAULT 'TEXT',
"fileUrl" TEXT,
"fileName" TEXT,
"fileSize" INTEGER,
"mimeType" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"senderId" TEXT NOT NULL,
"privateChatId" TEXT NOT NULL,
CONSTRAINT "PrivateMessage_privateChatId_fkey" FOREIGN KEY ("privateChatId") REFERENCES "PrivateChat" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "PrivateMessage_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)5'I# indexsqlite_autoindex_PrivateChat_1PrivateChat,�v %%�/tableThemeProfileThemeProfile"CREATE TABLE "ThemeProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"colors" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"userId" TEXT NOT NULL,
CONSTRAINT "ThemeProfile_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)C W1 indexsqlite_autoindex_DocumentPermission_1DocumentPermission!�/&##�%tablePrivateChatPrivateChat+CREATE TABLE "PrivateChat" (
"id" TEXT NOT NULL PRIMARY KEY,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"adminId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "PrivateChat_adminId_fkey" FOREIGN KEY ("adminId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "PrivateChat_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "PrivateChat_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)-%A indexsqlite_autoindex_Message_1Message*�s$�=tableMessageMessage)CREATE TABLE "Message" (
"id" TEXT NOT NULL PRIMARY KEY,
"content" TEXT NOT NULL,
"type" TEXT NOT NULL DEFAULT 'TEXT',
"fileUrl" TEXT,
"fileName" TEXT,
"fileSize" INTEGER,
"mimeType" TEXT,
"editedAt" DATETIME,
"isEdited" BOOLEAN NOT NULL DEFAULT false,
"replyToId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"userId" TEXT NOT NULL,
"chatRoomId" TEXT NOT NULL,
CONSTRAINT "Message_replyToId_fkey" FOREIGN KEY ("replyToId") REFERENCES "Message" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "Message_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "Message_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)=#Q+ indexsqlite_autoindex_ChatParticipant_1ChatParticipant(�$"++�tableChatParticipantChatParticipant'CREATE TABLE "ChatParticipant" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"chatRoomId" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'MEMBER',
"joinedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "ChatParticipant_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "ChatParticipant_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)/!C indexsqlite_autoindex_ChatRoom_1ChatRoom%�m �-tableChatRoomChatRoom$CREATE TABLE "ChatRoom" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"type" TEXT NOT NULL DEFAULT 'GROUP',
"createdById" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "ChatRoom_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)7 K% indexsqlite_autoindex_ThemeProfile_1ThemeProfile#
� � \???cmcqjacjg0001vjfko755xp13cmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrjADMIN�۱8�
� � ? cmcqjacjg0001vjfko755xp13
% �
�% q? ??cmd43v5h7000ptp2s09pahj6kxvcncvnTEXT� ��{� ��{cmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrjp? ??cmd43v3k0000ntp2sj7t92zfedfhffjTEXT� ��� ��cmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrj�? ???cmcqjaj280007vjfk2vtpd0esyoTEXTcmcqjaep80005vjfkr18kuky3�۱Z�۱Zcmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrjl? ??cmcqjaep80005vjfkr18kuky3hiTEXT�۱C��۱C�cmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrj
� ���� ?cmd43v5h7000ptp2s09pahj6k ?cmd43v3k0000ntp2sj7t92zfe ?cmcqjaj280007vjfk2vtpd0es ? cmcqjaep80005vjfkr18kuky3
� � ^??? cmcqva0yg0003vj9g6pw6bgjxcmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51���U���U
� � ? cmcqva0yg0003vj9g6pw6bgjx
� �*�T
�
}
� : � i
? ??cmd565cbx000ftpbsjelo1q3qhiTEXT�p��p�cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxh ? ??cmcy541hl0003tp2gxwc8uu8w]TEXT��
���
�cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxl ? ??cmcy53zt00001tp2g2we4judijkljgTEXT�� �� cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxi ? ??cmcy2f7km0009tpf04v4cm16hhiTEXT��� ��� cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxh ? ??cmcy2es8j0007tpf0g8swrm6zhTEXT����o����ocmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxk ? ??cmcr7o9sb000xvj38shdtpkkmhihiTEXT��":���":�cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxi ? ??cmcr7mkrh000vvj38eb346ckbhiTEXT��!���!�cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxi ? ??cmcr7m0za000tvj38smn56lg9yaTEXT�� �v�� �vcmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxi ? ??cmcr7lsnn000rvj38zxk4wbymyiTEXT�� wT�� wTcmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjxi ? ??cmcr7lozg000pvj38sw8rwhr7yoTEXT�� d��� d�cmcpzyavn0002vjz01slrcn51cmcqva0yg0003vj9g6pw6bgjx
� ����kM/�� ?cmd565cbx000ftpbsjelo1q3q
?cmcy541hl0003tp2gxwc8uu8w ?cmcy53zt00001tp2g2we4judi ?cmcy2f7km0009tpf04v4cm16h ?cmcy2es8j0007tpf0g8swrm6z ?cmcr7o9sb000xvj38shdtpkkm ?cmcr7mkrh000vvj38eb346ckb ?cmcr7m0za000tvj38smn56lg9 ?cmcr7lsnn000rvj38zxk4wbym ? cmcr7lozg000pvj38sw8rwhr7
�
� � 7�t�!5
�
��}
�
� O3c= indexsqlite_autoindex_newsletter_subscriptions_1newsletter_subscriptions9�0++�YtableMessageReaction�22==�wtablenewsletter_subscriptionsnewsletter_subscriptions8CREATE TABLE "newsletter_subscriptions" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"language" TEXT NOT NULL DEFAULT 'en',
"source" TEXT NOT NULL DEFAULT 'website',
"subscriptionDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"confirmedAt" DATETIME,
"unsubscribedAt" DATETIME,
"tags" TEXT,
"metadata" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)�.++�Ytabletyping_statusestyping_statuses4CREATE TABLE "typing_statuses" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"chatRoomId" TEXT NOT NULL,
"isTyping" BOOLEAN NOT NULL DEFAULT false,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "typing_statuses_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "typing_statuses_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=/Q+ indexsqlite_autoindex_typing_statuses_1typing_statuses5�@,%%�Ctablestatus_notesstatus_notes2CREATE TABLE "status_notes" (
"id" TEXT NOT NULL PRIMARY KEY,
"content" TEXT NOT NULL,
"registrationId" TEXT NOT NULL,
"adminId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "status_notes_adminId_fkey" FOREIGN KEY ("adminId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "status_notes_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)7-K% indexsqlite_autoindex_status_notes_1status_notes3
=+Q+ indexsqlite_autoindex_direct_messages_1direct_messages0� *++�Itabledirect_messagesdirect_messages/CREATE TABLE "direct_messages" (
"id" TEXT NOT NULL PRIMARY KEY,
"content" TEXT NOT NULL,
"type" TEXT NOT NULL DEFAULT 'TEXT',
"fileUrl" TEXT,
"fileName" TEXT,
"fileSize" INTEGER,
"mimeType" TEXT,
"isRead" BOOLEAN NOT NULL DEFAULT false,
"caseId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"senderId" TEXT NOT NULL,
"recipientId" TEXT NOT NULL,
CONSTRAINT "direct_messages_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "direct_messages_recipientId_fkey" FOREIGN KEY ("recipientId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "direct_messages_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
);)O) indexsqlite_autoindex_PrivateMessage_1PrivateMessage. �))�GtablePrivateMessagePrivateMessage-CREATE TABL�F())�GtablePrivateMessagePrivateMessage-CREATE TABLE "PrivateMessage" (
"id" TEXT NOT NULL PRIMARY KEY,
"c=1Q+ indexsqlite_autoindex_MessageReaction_1MessageReaction7�0++�YtableMessageReactionMessageReaction6CREATE TABLE "MessageReaction" (
"id" TEXT NOT NULL PRIMARY KEY,
"messageId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"emoji" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "MessageReaction_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "MessageReaction_messageId_fkey" FOREIGN KEY ("messageId") REFERENCES "Message" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)
A �
��I ��
v y e
E : : =?Q+ indexsqlite_autoindex_segment_members_1segment_membersF=;Q+ indexsqlite_autoindex_campaign_events_1campaign_eventsB� 8//�mtablecampaign_variantscampaign_variants?CREATE TABLE "campaign_variants" (
"id" TEXT NOT NULL PRIMARY KEY,
"campaignId" TEXT NOT NULL,
"variant" TEXT NOT NULL,
"subject" TEXT NOT NULL,
"htmlContent" TEXT NOT NULL,
"textContent" TEXT,
"sentCount" INTEGER NOT NULL DEFAULT 0,
"openCount" INTEGER NOT NULL DEFAULT 0,
"clickCount" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "campaign_variants_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES "campaigns" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)A9U/ indexsqlite_autoindex_campaign_variants_1campaign_variants@�n6 �+tablecampaignscampaigns=CREATE TABLE "campaigns" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"subject" TEXT NOT NULL,
"templateId" TEXT,
"htmlContent" TEXT,
"textContent" TEXT,
"status" TEXT NOT NULL DEFAULT 'draft',
"targetLanguage" TEXT,
"targetTags" TEXT,
"segmentId" TEXT,
"scheduledAt" DATETIME,
"sentAt" DATETIME,
"createdBy" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"isAbTest" BOOLEAN NOT NULL DEFAULT false,
"abTestPercent" INTEGER,
"abTestWinner" TEXT,
"totalSent" INTEGER NOT NULL DEFAULT 0,
"totalOpened" INTEGER NOT NULL DEFAULT 0,
"totalClicked" INTEGER NOT NULL DEFAULT 0,
"totalBounced" INTEGER NOT NULL DEFAULT 0,
"totalUnsubscribed" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "campaigns_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "campaigns_segmentId_fkey" FOREIGN KEY ("segmentId") REFERENCES "segments" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "campaigns_templateId_fkey" FOREIGN KEY ("templateId") REFERENCES "email_templates" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)17E indexsqlite_autoindex_campaigns_1campaigns> 9 =5Q+ indexsqlite_autoindex_email_templates_1email_templates;�]4++�qtableemail_templatesemail_templates:CREATE TABLE "email_templates" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"subject" TEXT NOT NULL,
"htmlContent" TEXT NOT NULL,
"textContent" TEXT,
"thumbnail" TEXT,
"category" TEXT NOT NULL DEFAULT 'general',
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdBy" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "email_templates_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)O3c= indexsqlite_autoindex_newsletter_subscriptions_1newsletter_subscriptions9 ===�wtablenewsletter_subscriptionsnewsl�]< �
tablesegmentssegmentsCCREATE TABLE "segments" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT,
"conditions" TEXT NOT NULL,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdBy" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "segments_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) �C indexsqlite_autoindex_segments_1segmentsD�:++�Etablecampaign_eventscampaign_eventsACREATE TABLE "campaign_events" (
"id" TEXT NOT NULL PRIMARY KEY,
"campaignId" TEXT NOT NULL,
"subscriptionId" TEXT NOT NULL,
"eventType" TEXT NOT NULL,
"eventData" TEXT,
"userAgent" TEXT,
"ipAddress" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "campaign_events_subscriptionId_fkey" FOREIGN KEY ("subscriptionId") REFERENCES "newsletter_subscriptions" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "campaign_events_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES "campaigns" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)
y � �
����8���� � 5EI# indexsqlite_autoindex_leg�eB99�etableimpersonation_sessionsimpersonation_sessionsJCREATE TABLE "impersonation_sessions" (
"id" TEXT NOT NULL PRIMARY KEY,
"originalUserId" TEXT NOT NULL,
"impersonatedUserId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"endedAt" DATETIME,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"reason" TEXT,
"ipAddress" TEXT,
"userAgent" TEXT, "expiresAt" DATETIME,
CONSTRAINT "impersonation_sessions_impersonatedUserId_fkey" FOREIGN KEY ("impersonatedUserId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "impersonation_sessions_originalUserId_fkey" FOREIGN KEY ("originalUserId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)KC_9 indexsqlite_autoindex_impersonation_sessions_1impersonation_sessionsK�;@--�)tableautomation_rulesautomation_rulesHCREATE TABLE "automation_rules" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT,
"triggerType" TEXT NOT NULL,
"conditions" TEXT NOT NULL,
"actions" TEXT NOT NULL,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdBy" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "automation_rules_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)?AS- indexsqlite_autoindex_automation_rules_1automation_rulesI
3 =?Q+ indexsqlite_autoindex_segment_members_1segment_membersF� >++�wtablesegment_memberssegment_membersECREATE TABLE "segment_members" (
"id" TEXT NOT NULL PRIMARY KEY,
"segmentId" TEXT NOT NULL,
"subscriptionId" TEXT NOT NULL,
"addedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "segment_members_subscriptionId_fkey" FOREIGN KEY ("subscriptionId") REFERENCES "newsletter_subscriptions" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "segment_members_segmentId_fkey" FOREIGN KEY ("segmentId") REFERENCES "segments" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)/=C indexsqlite_autoindex_segments_1segmentsD�]< �
tablesegmentssegmentsCCREATE TABLE "segments" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT,
"conditions" TEXT NOT NULL,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdBy" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "segments_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=;Q+ indexsqlite_autoindex_campaign_events_1campaign_eventsB �++�Etablecampaign_eventscampaign_eventsACREATE TABLE "campaign_events" (
"id" TEXT NOT NULL PRIMARY KEY,
"campaignId" TEXT NOT NULL,
"subscriptionId" TEXT NOT NULL,
"eventType" TEXT NOT NULL,
"eventData" TEXT,
"userAgent" TEXT,
"ipAddress" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "campaign_events_subscriptionId_fkey" FOREIGN KEY ("subscriptionId") REFERENCES "newsletter_subscriptions" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "campaign_events_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES "campaigns" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)A9U/ indexsqlite_autoindex_campaign_variants_1campaign_variants@
K
�
j � �
� �X ??? E �-cmcxnuz1z0003tpekio7z4unkcmcr8nl8g0007vjkcmzk2w23ccmcr8nl8g0007vjkcmzk2w23c��`�Administrative impersonation127.0.0.1Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0����u�X ??? E �-cmcxnuftu0001tpekcw8ua60xcmcpzyavn0002vjz01slrcn51cmcr8nl8g0007vjkcmzk2w23c��`��Administrative impersonation127.0.0.1Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0���u �^ ???E �-cmcradm5h0003vjl85utkzxg7cmcr8nl8g0007vjkcmzk2w23ccmcr8nl8g0007vjkcmzk2w23c��g�e��g�{Administrative impersonation127.0.0.1Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0�ޞu�^ ???E �-cmcr4bz5c0003vjug6vgge0f5cmcqfhsqx0001vjhc8ntsvvrccmcqfhsqx0001vjhc8ntsvvrc��̖���̥�Administrative impersonation127.0.0.1Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0���- �??? E �-cmcr9v8hf0001vjxc47itydttcmcpzyavn0002vjz01slrcn51cmcr8nl8�X ??? E �-cmcra7qtv0001vjl8v9v87mi2cmcpzyavn0002vjz01slrcn51cmcr8nl8g0007vjkcmzk2w23c��cY�Administrative impersonation127.0.0.1Mozill�^ ???E �-cmcra7qtv0001vjl8v9v87mi2cmcpzyavn0002vjz01slrcn51cmcr8nl8g0007vjkcmzk2w23c��cY���^ �Administrative impersonation127.0.0.1Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0�ޚH
� M ��k�M ?cmcxnuz1z0003tpekio7z4unk ?cmcradm5h0003vjl85utkzxg7 ?cmcra7qtv0001vjl8v9v87mi2 ?cmcr4bz5c0003vjug6vgge0f5 cmcr9v8hf0001vjxc47itydtt ?cmcxnuftu0001tpekcw8ua60x
B p p �
�0?I�#%%% +! gI ??]cmcpzyax8000avjz0ao7zkw1gBordeaux Prison Case - UpdatedCase Overview
What is this case about?
This class action lawsuit challenges the Government of Quebec for systematic human rights violations at Bordeaux Prison from January 1, 2022 until the final judgment. The case addresses inhumane detention conditions, healthcare negligence, and violations of fundamental rights.
Who can participate?
Any person detained at Bordeaux Prison during the specified period, as well as their families and loved ones who suffered as a result of the inhumane conditions and rights violations.2024QCCS4539CLASS_ACTIONactiveQuebecCLASS_ACTIONhigh���q�L Prisoner RightsPrison LawURGENTN��HIGHA public summary of the Bordeaux Prison Case.["prison","bordeaux","urgent"]����� -2cmcpzyawf0006vjz02w4s3ilacmcpzyavn0002vjz01slrcn51AUCTION���6��https://localhost:3443/images/Logo_w.png� 2?g�G ;; - �i�! ?? cmcy0qyro0005tp60r8omsnlgWrongful Conviction Appeal - Michael ThompsonAppeal case for Michael Thompson who was wrongfully convicted of armed robbery in 2019. New evidence has emerged including DNA proof and witness recantation.appealactiveOntario Court of AppealOntario Court of Appealurgent�1� �O � CRIMINALCriminal AppealsURGENT| � ��HIGHFighting to overturn a wrongful conviction with new DNA evidence. Seeking experienced criminal appeals lawyer.["wrongful-conviction","dna-evidence","appeal","criminal-law","innocence"]���:����:�cmcy0qypj0001tp60jvd1rf7bcmcy0qypj0001tp60jvd1rf7b�22?[�7%%77 %% �E�- ?? cmcy0qyro0004tp60howbrwqlBordeaux Prison Conditions Class ActionHistoric class action against Quebec for systemic rights violations at Bordeaux Prison affecting thousands of detainees from January 2022 to present.2024QCCS4540class_actionactiveQuebec Superior CourtQuebec Superior Courthigh�/�x �q�L HUMAN_RIGHTSHuman RightsHIGH�Y��MEDIUMSeeking justice for inhumane conditions, inadequate healthcare, and rights violations at Bordeaux Prison. Join if you were detained during the class period.["prison-rights","class-action","human-rights","bordeaux","systemic-violations"]���:������cmcy0qypj0000tp6029gm0o4mcmcy0qypj0000tp6029gm0o4mK�?5�'%�R0?I�%%% +! gI ??]cmcpzyax8000avjz0ao7zkw1gBordeaux Prison Case - UpdatedUpdated description for the Bordeaux Prison case with improved details2024QCCS4539CLASS_ACTIONactiveQuebecCLASS_ACTIONhigh���q�L Prisoner RightsPrison LawURGENT���HIGHA public summary of the Bordeaux Prison Case.["prison","bordeaux","urgent"]�������Dcmcpzyawf0006vjz02w4s3ilacmcpzyavn0002vjz01slrcn51AUCTION���6��https://localhost:3443/images/Logo_w.png�(/?I�/ / '+ {7W[' ?? cmcwag3so0001tpskgft3kz3kTest Public Case for Live ChatThis is a test case created specifically for testing the live chat functionality. Users can join this case and test real-time messaging features.CIVILactiveTest Jurisdictionmedium Test CategoryTest Legal AreaNORMAL-'MEDIUMA public test case for live chat functionality testing.test,live-chat,public["Test Document 1","Test Document 2"]Open to all users for testing purposes.Test Law Firm��n�4��xEcmcpzyavn0002vjz01slrcn51cmcpzyavn0002vjz01slrcn51 �?5�'%+ 7 +! gI ??cmcpzyax8000avjz0ao7zkw1gBordeaux Prison CaseA high-profile case regarding prisoner rights and justice at Bordeaux Prison.2024QCCS4539Prisoner RightsactiveMontréalTribunal de Montréalhigh��5� Prisoner RightsPrison LawURGENT���HIGHA public summary of the Bordeaux Prison Case.["prison","bordeaux","urgent"]�������"cmcpzyawf0006vjz02w4s3ilacmcpzyavn0002vjz01slrcn51AUCTION���6��
� ���� ?cmcy0qyro0005tp60r8omsnlg ?cmcy0qyro0004tp60howbrwql ?cmcwag3so0001tpskgft3kz3k ? cmcpzyax8000avjz0ao7zkw1g
�
�
c �XD##�wtablelegal_caseslegal_casesLCREATE TABLE "legal_cases" (
"id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"description" TEXT NOT NULL,
"caseNumber" TEXT,
"caseType" TEXT NOT NULL,
"status" TEXT NOT NULL DEFAULT 'active',
"jurisdiction" TEXT NOT NULL,
"court" TEXT,
"priority" TEXT NOT NULL DEFAULT 'medium',
"budget" REAL,
"expectedDuration" INTEGER,
"filingDate" DATETIME,
"applicationDeadline" DATETIME,
"isAcceptingApplications" BOOLEAN NOT NULL DEFAULT true,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"category" TEXT,
"legalArea" TEXT,
"urgencyLevel" TEXT NOT NULL DEFAULT 'NORMAL',
"viewCount" INTEGER NOT NULL DEFAULT 0,
"supporterCount" INTEGER NOT NULL DEFAULT 0,
"estimatedValue" REAL,
"actualValue" REAL,
"startDate" DATETIME,
"expectedEndDate" DATETIME,
"actualEndDate" DATETIME,
"riskLevel" TEXT NOT NULL DEFAULT 'MEDIUM',
"publicSummary" TEXT,
"tags" TEXT,
"requiredDocuments" TEXT,
"eligibilityCriteria" TEXT,
"firmName" TEXT,
"clientId" TEXT,
"primaryLawyerId" TEXT,
"assistantLawyerId" TEXT,
"secretaryId" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"leadLawyerId" TEXT NOT NULL,
"createdBy" TEXT NOT NULL,
"competitionType" TEXT,
"competitionDeadline" DATETIME,
"minimumBid" REAL,
"currentHighestBid" REAL,
"totalBidders" INTEGER NOT NULL DEFAULT 0,
"averageBidAmount" REAL, "logoUrl" TEXT,
CONSTRAINT "legal_cases_leadLawyerId_fkey" FOREIGN KEY ("leadLawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "legal_cases_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "legal_cases_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "legal_cases_primaryLawyerId_fkey" FOREIGN KEY ("primaryLawyerId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "legal_cases_assistantLawyerId_fkey" FOREIGN KEY ("assistantLawyerId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "legal_cases_secretaryId_fkey" FOREIGN KEY ("secretaryId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)�0H �/tablelaw_firmslaw_firmsQCREATE TABLE "law_firms" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"shortName" TEXT,
"address" TEXT NOT NULL,
"city" TEXT NOT NULL,
"province" TEXT NOT NULL,
"postalCode" TEXT NOT NULL,
"phone" TEXT,
"email" TEXT,
"website" TEXT,
"barRegistration" TEXT,
"foundedYear" INTEGER,
"specializations" TEXT,
"partnershipType" TEXT NOT NULL DEFAULT 'partner',
"contractStart" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"contractEnd" DATETIME,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)�wF%%�1tablecase_updatescase_updatesOCREATE TABLE "case_updates" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"title" TEXT NOT NULL,
"description" TEXT NOT NULL,
"updateType" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"createdBy" TEXT NOT NULL,
CONSTRAINT "case_updates_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_updates_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)7GK% indexsqlite_autoindex_case_updates_1case_updatesP5EI# indexsqlite_autoindex_legal_cases_1legal_casesM
^ e�/
� � ^ � ??%]!?cmcyweuaa0001tpfgmhgn3b9bcmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural��ָ�cmcpzyavn0002vjz01slrcn51� ??%]!?cmcy5fexj0007tp2gpba1ibi8cmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural��#&Xcmcpzyavn0002vjz01slrcn51� ??%]!?cmcy3e15s0001tphw7fdzo218cmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural����]cmcpzyavn0002vjz01slrcn51� ??%]!?cmcqvya00000rvj9gdpk0io3hcmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural��� cmcpzyavn0002vjz01slrcn51� ??%]!?cmcqvjkie0009vj9ggdk3jhgycmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural���U�cmcpzyavn0002vjz01slrcn51� ??%]!?cmcqveyvt0005vj9g1aq2ztwhcmcpzyax8000avjz0ao7zkw1gCase UpdatedCase details were updated by Danny Perezprocedural���cmcpzyavn0002vjz01slrcn51
M ����kM ?cmcyweuaa0001tpfgmhgn3b9b ?cmcy5fexj0007tp2gpba1ibi8 ?cmcy3e15s0001tphw7fdzo218 ?cmcqvya00000rvj9gdpk0io3h ?cmcqvjkie0009vj9ggdk3jhgy ? cmcqveyvt0005vj9g1aq2ztwh
� �H �v?1+ 1/33#W cmcpi1i540000vj7on89m7b0aWee & Partners LLPWee LLP123 Justice AveBordeauxNouvelle-Aquitaine33000+33 5 56 00 00 00contact@wee�"?#A )1A%�5 cmcpzyavb0000vjz0gwgrte2cADW AvocatsADW3565, rue Berri, suite 240MontréalQuébecH2L 4G3(514) 527-8903adw@adwavocats.comhttps://www.adwavocats.comADW-2024-001�Litige civil, Violences sexuelles, Abus policiers et étatiques, Actions collectivespartner������������
� �� ?cmcpi1i540000vj7on89m7b0a ? cmcpzyavb0000vjz0gwgrte2c
�
� � .����T
�
� �
�
�
� 7SK% indexsqlite_autoindex_achievements_1achievements]� P##�]tableuser_badgesuser_badgesZCREATE TABLE "user_badges" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
�<R%%�;tableachievementsachievements\CREATE TABLE "achievements" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT NOT NULL,
"type" TEXT NOT NULL,
"target" INTEGER NOT NULL,
"xpReward" INTEGER NOT NULL DEFAULT 0,
"badgeReward" TEXT,
"isRepeatable" BOOLEAN NOT NULL DEFAULT false,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)�-N�5tablebadgesbadgesXCREATE TABLE "badges" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT NOT NULL,
"icon" TEXT NOT NULL,
"category" TEXT NOT NULL,
"requirements" TEXT NOT NULL,
"xpReward" INTEGER NOT NULL DEFAULT 0,
"rarity" TEXT NOT NULL DEFAULT 'COMMON',
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)+O? indexsqlite_autoindex_badges_1badgesY�.L##�#tablecase_offerscase_offersVCREATE TABLE "case_offers" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"receiverId" TEXT NOT NULL,
"clientId" TEXT,
"offerType" TEXT NOT NULL,
"message" TEXT,
"proposedRate" REAL,
"estimatedHours" INTEGER,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"expiresAt" DATETIME,
"collaborationType" TEXT,
"feeSplit" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "case_offers_receiverId_fkey" FOREIGN KEY ("receiverId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_offers_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_offers_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "case_offers_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)5MI# indexsqlite_autoindex_case_offers_1case_offersW
;KO) indexsqlite_autoindex_lawyer_ratings_1lawyer_ratingsT�0J))�tablelawyer_ratingslawyer_ratingsSCREATE TABLE "lawyer_ratings" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"caseId" TEXT,
"boldnessScore" INTEGER NOT NULL,
"transparencyScore" INTEGER NOT NULL,
"communicationScore" INTEGER NOT NULL,
"resultsScore" INTEGER NOT NULL,
"overallScore" REAL NOT NULL,
"review" TEXT,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "lawyer_ratings_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "lawyer_ratings_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lawyer_ratings_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)1IE indexsqlite_autoindex_law_firms_1law_firmsR � �/tablelaw_firmslaw_firmsQCREATE TABLE "law_firms" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TE7SK% indexsqlite_autoindex_achievements_1achievements]5QI# indexsqlite_autoindex_user_badges_1user_badges[� P##�]tableuser_badgesuser_badgesZCREATE TABLE "user_badges" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"badgeId" TEXT NOT NULL,
"earnedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"isVisible" BOOLEAN NOT NULL DEFAULT true,
CONSTRAINT "user_badges_badgeId_fkey" FOREIGN KEY ("badgeId") REFERENCES "badges" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_badges_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
�
� �???? #�q cmcy0qzag000ptp60f1rjjzfqcmcy0qyro0005tp60r8omsnlgcmcy0qypj0001tp60jvd1rf7bcmcy0qypj0001tp60jvd1rf7bCOLLABORATEI have extensive experience with wrongful conviction appeals and would love to collaborate on this important case.,xPENDING���='���='�v???? �U cmcy0qzaf000otp60d48q4vzwcmcy0qyro0004tp60howbrwqlcmcy0qypj0000tp6029gm0o4mcmcy0qypj0001tp60jvd1rf7bREPRESENTThis class action case aligns perfectly with my human rights practice. I offer my services pro bono.PPENDING���='���='
� �� ?cmcy0qzag000ptp60f1rjjzfq ? cmcy0qzaf000otp60d48q4vzw
� U�0
� � � ?)]#Q cmcy0qyt10008tp605i7nmgp9Justice SeekerSubmitted your first case for legal help⚖️ACHIEVEMENT{"action":"submit_case","count":1}2COMMON���:�� ?)E#W cmcy0qytb0009tp60cbrxxx5sCase SupporterSupported 25 different cases❤️ACHIEVEMENT{"action":"support_cases","count":25}dCOMMON���:��
?'C _ cmcy0qyu8000atp60pscft3x6Pro Bono HeroCompleted 10 pro bono cases🦸PRO_BONO{"action":"complete_pro_bono","count":10}�RARE���:� ?+Y O cmcy0qyt00007tp60mf0mgyupPlatform PatronDonated $1000+ to support the platform💎DONATION{"action":"donate","amount":1000} �RARE���:��( ?-u#W cmcy0qyt00006tp60dx4akeptDavid vs GoliathWon a case against a major corporation or government🏹ACHIEVEMENT{"action":"win_major_case","count":1}�EPIC���:�
k ��k�� ?cmcy0qyt10008tp605i7nmgp9 ?cmcy0qytb0009tp60cbrxxx5s ?cmcy0qyu8000atp60pscft3x6 ?cmcy0qyt00007tp60mf0mgyup ? cmcy0qyt00006tp60dx4akept
� �N� W??? cmcy0qzc0000vtp60j6oho423cmcy0qypj0000tp6029gm0o4mcmcy0qyt10008tp605i7nmgp9���=`W??? cmcy0qzbt000ttp60sn166226cmcy0qypj0001tp60jvd1rf7bcmcy0qyt00006tp60dx4akept���=ZW??? cmcy0qzbs000rtp60dozhf7u6cmcy0qypj0000tp6029gm0o4mcmcy0qyu8000atp60pscft3x6���=Y
� ��� ?cmcy0qzc0000vtp60j6oho423 ?cmcy0qzbt000ttp60sn166226 ? cmcy0qzbs000rtp60dozhf7u6
� �
h
% � k���� B =]Q+ indexs/[C indexsqlite_autoindex_payments_1paymentsf7SK% indexsqlite_autoindex_achievements_1achievements]�jZ �'tablepaymentspaymentseCREATE TABLE "payments" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"amount" REAL NOT NULL,
"currency" TEXT NOT NULL DEFAULT 'CAD',
"type" TEXT NOT NULL,
"description" TEXT,
"paymentMethod" TEXT NOT NULL,
"stripePaymentIntentId" TEXT,
"stripeChargeId" TEXT,
"stripeFeeAmount" REAL,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"failureReason" TEXT,
"caseId" TEXT,
"escrowId" TEXT,
"societyDiscount" REAL NOT NULL DEFAULT 0.0,
"xpEarned" INTEGER NOT NULL DEFAULT 0,
"platformFeeAmount" REAL NOT NULL DEFAULT 0.0,
"lawyerPayoutAmount" REAL NOT NULL DEFAULT 0.0,
"refundAmount" REAL NOT NULL DEFAULT 0.0,
"metadata" TEXT,
"paymentDate" DATETIME,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "payments_escrowId_fkey" FOREIGN KEY ("escrowId") REFERENCES "escrow_accounts" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "payments_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "payments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)1YE indexsqlite_autoindex_donations_1donationsd�PX �otabledonationsdonationscCREATE TABLE "donations" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT,
"amount" REAL NOT NULL,
"currency" TEXT NOT NULL DEFAULT 'CAD',
"type" TEXT NOT NULL,
"targetId" TEXT,
"message" TEXT,
"isAnonymous" BOOLEAN NOT NULL DEFAULT false,
"paymentMethod" TEXT NOT NULL,
"paymentId" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "donations_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)=WQ+ indexsqlite_autoindex_BusinessProfile_1BusinessProfileb�xV++�'tableBusinessProfileBusinessProfileaCREATE TABLE "BusinessProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"ownerId" TEXT NOT NULL,
"businessName" TEXT NOT NULL,
"businessType" TEXT NOT NULL,
"industry" TEXT,
"description" TEXT,
"logo" TEXT,
"website" TEXT,
"phone" TEXT,
"email" TEXT,
"address" TEXT,
"registrationNumber" TEXT,
"taxId" TEXT,
"employeeCount" TEXT,
"annualRevenue" TEXT,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"verificationStatus" TEXT NOT NULL DEFAULT 'PENDING',
"verificationNote" TEXT,
"verifiedAt" DATETIME,
CONSTRAINT "BusinessProfile_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)AUU/ indexsqlite_autoindex_user_achievements_1user_achievements_�T//�Ytableuser_achievementsuser_achievements^CREATE TABLE "user_achievements" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"achievementId" TEXT NOT NULL,
"currentProgress" INTEGER NOT NULL DEFAULT 0,
"isCompleted" BOOLEAN NOT NULL DEFAULT false,
"completedAt" DATETIME,
"lastUpdated" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "user_achievements_achievementId_fkey" FOREIGN KEY ("achievementId") REFERENCES "achievements" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_achievements_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
�
� �.??# )�)EA)1{% cmcqfih0g0001vjoolt160supcmcpzyawf0006vjz02w4s3ilaADW AvocatsLaw FirmLegal ServicesNous vous accompagnons face aux litiges civils, aux violences policières, aux agressions sexuelles et aux actions collectives. Notre mission est de redonner un sentiment de justice et d'aider notre clientèle à reprendre le contrôle face à des situations difficiles./images/lawyers/adw-logo.svghttps://www.adwavocats.com(514) 527-8903adw@adwavocats.com3565, rue Berri, suite 240, Montréal (Québec) H2L 4G3ADW-2024-00117��P}���D�BAPPROVED��P}�
� � ? cmcqfih0g0001vjoolt160sup
� �
��
�t �� Ie]7 indexsqlite_autoindex_society_pricing_tiers_1society_pricing_tiersq�]b++�qtablepayment_refundspayment_refundsnCREATE TABLE "pay�]b++�qtablepayment_refundspayment_refundsnCREATE TABLE "payment_refunds" (
"id" TEXT NOT NULL PRIMARY KEY,
"paymentId" TEXT NOT NULL,
"amount" REAL NOT NULL,
"reason" TEXT NOT NULL,
"stripeRefundId" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"processedAt" DATETIME,
"requestedBy" TEXT NOT NULL,
"approvedBy" TEXT,
"metadata" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "payment_refunds_approvedBy_fkey" FOREIGN KEY ("approvedBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "payment_refunds_requestedBy_fkey" FOREIGN KEY ("requestedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "payment_refunds_paymentId_fkey" FOREIGN KEY ("paymentId") REFERENCES "payments" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�j`%%�tabletransactionstransactionslCREATE TABLE "transactions" (
"id" TEXT NOT NULL PRIMARY KEY,
"paymentId" TEXT,
"userId" TEXT NOT NULL,
"type" TEXT NOT NULL,
"amount" REAL NOT NULL,
"currency" TEXT NOT NULL DEFAULT 'CAD',
"direction" TEXT NOT NULL,
"balanceBefore" REAL NOT NULL DEFAULT 0.0,
"balanceAfter" REAL NOT NULL DEFAULT 0.0,
"referenceId" TEXT,
"referenceType" TEXT,
"description" TEXT NOT NULL,
"metadata" TEXT,
"transactionDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "transactions_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "transactions_paymentId_fkey" FOREIGN KEY ("paymentId") REFERENCES "payments" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)7aK% indexsqlite_autoindex_transactions_1transactionsm�b^++�{tableescrow_releasesescrow_releasesjCREATE TABLE "escrow_releases" (
"id" TEXT NOT NULL PRIMARY KEY,
"escrowId" TEXT NOT NULL,
"amount" REAL NOT NULL,
"releaseType" TEXT NOT NULL,
"reason" TEXT NOT NULL,
"approvedBy" TEXT,
"milestoneDescription" TEXT,
"milestoneNumber" INTEGER,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"releasedAt" DATETIME,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "escrow_releases_approvedBy_fkey" FOREIGN KEY ("approvedBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "escrow_releases_escrowId_fkey" FOREIGN KEY ("escrowId") REFERENCES "escrow_accounts" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=_Q+ indexsqlite_autoindex_escrow_releases_1escrow_releasesk� =]Q+ indexsqlite_autoindex_escrow_accounts_1escrow_accountsh�4\++� tableescrow_accountsescrow_accountsgCREATE TABLE "escrow_accounts" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"clientId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"totalAmount" REAL NOT NULL,
"availableAmount" REAL NOT NULL,
"heldAmount" REAL NOT NULL DEFAULT 0.0,
"releasedAmount" REAL NOT NULL DEFAULT 0.0,
"milestoneReleases" TEXT,
"autoReleaseDate" DATETIME,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"disputeReason" TEXT,
"societyFeeDiscount" REAL NOT NULL DEFAULT 0.0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"userId" TEXT,
CONSTRAINT "escrow_accounts_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "escrow_accounts_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "escrow_accounts_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "escrow_accounts_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
) 1C indexsqlite_autoindex_payments_1paymentsf
� z ( N a�z
�
`
p
p =kQ+ indexsqlite_autoindex_mentor_sessions_1mentor_sessionsx� h11�itablecourse_enrollmentscourse_enrollmentsuCREATE TABLE "course_enrollments" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"courseId" TEXT NOT NULL,
"enrollmentDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"completionDate" DATETIME,
"status" TEXT NOT NULL DEFAULT 'IN_PROGRESS',
"progress" REAL NOT NULL DEFAULT 0.0,
"certificateUrl" TEXT,
CONSTRAINT "course_enrollments_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES "courses" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "course_enrollments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)CiW1 indexsqlite_autoindex_course_enrollments_1course_enrollmentsv�Pf33�Gtablefinancial_summariesfinancial_summariessCREATE TABLE "financial_summaries" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"totalEarnings" REAL NOT NULL DEFAULT 0.0,
"thisMonthEarnings" REAL NOT NULL DEFAULT 0.0,
"pendingPayouts" REAL NOT NULL DEFAULT 0.0,
"totalCaseFees" REAL NOT NULL DEFAULT 0.0,
"totalSpent" REAL NOT NULL DEFAULT 0.0,
"thisMonthSpent" REAL NOT NULL DEFAULT 0.0,
"escrowBalance" REAL NOT NULL DEFAULT 0.0,
"totalCommissionPaid" REAL NOT NULL DEFAULT 0.0,
"societyDiscountsSaved" REAL NOT NULL DEFAULT 0.0,
"currentTier" TEXT,
"nextTierProgress" REAL NOT NULL DEFAULT 0.0,
"paymentCount" INTEGER NOT NULL DEFAULT 0,
"refundCount" INTEGER NOT NULL DEFAULT 0,
"disputeCount" INTEGER NOT NULL DEFAULT 0,
"lastCalculated" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "financial_summaries_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)EgY3 indexsqlite_autoindex_financial_summaries_1financial_summariest g Ie]7 indexsqlite_autoindex_society_pricing_tiers_1society_pricing_tiersq�Wd77�Mtablesociety_pricing_tierssociety_pricing_tierspCREATE TABLE "society_pricing_tiers" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"track" TEXT NOT NULL,
"minDegreeNumber" INTEGER NOT NULL,
"minXP" INTEGER NOT NULL DEFAULT 0,
"minLevel" INTEGER NOT NULL DEFAULT 1,
"platformFeeDiscount" REAL NOT NULL DEFAULT 0.0,
"prioritySupport" BOOLEAN NOT NULL DEFAULT false,
"advancedFeatures" TEXT,
"customBranding" BOOLEAN NOT NULL DEFAULT false,
"baseCommissionRate" REAL NOT NULL DEFAULT 0.10,
"discountedRate" REAL,
"description" TEXT,
"benefits" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)=cQ+ indexsqlite_autoindex_payment_refunds_1payment_refundso �++�qtablepayment_refundspayment_refundsnCREATE TABLE "payment_refunds" (
"id" TEXT NOT NULL PRIMARY KEY,
"paymentId" TEXT NOT NULL,
"amount" REAL NOT NULL,
"reason" TEXT NOT NULL,
"stripeRefundId" TEXT,
"status" TEXT NO=kQ+ indexsqlite_autoindex_mentor_sessions_1mentor_sessionsx�^j++�stablementor_sessionsmentor_sessionswCREATE TABLE "mentor_sessions" (
"id" TEXT NOT NULL PRIMARY KEY,
"mentorId" TEXT NOT NULL,
"menteeId" TEXT NOT NULL,
"sessionDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"duration" INTEGER NOT NULL,
"notes" TEXT,
"status" TEXT NOT NULL DEFAULT 'SCHEDULED',
CONSTRAINT "mentor_sessions_menteeId_fkey" FOREIGN KEY ("menteeId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "mentor_sessions_mentorId_fkey" FOREIGN KEY ("mentorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
L �L X?? cmh0ts7y900011pgq9u8yejmtcmcqixujd0000vjk80kvazthp��<���B��=X?? cmd1zquqi0001tpmomml5r7orcmcpzyavn0002vjz01slrcn51������
� �� ?cmh0ts7y900011pgq9u8yejmt ? cmd1zquqi0001tpmomml5r7or
�
R �0?G� %3 �w cmcy0qz52000itp60v4eiksuhPrison Rights & Detention LawSpecialized course on prisoner rights and detention conditions.INTERMEDIATEDanny William Perez ,{"modules":["Prisoner Rights Overview","Detention Standards","Class Action Procedures","Systemic Reform Strategies"]} ����<g���<g�h?I� 3 ?S�u cmcy0qz52000gtp607l5exzt8Advanced Litigation StrategiesAdvanced techniques for complex litigation and case management.ADVANCEDJustice Robert Chen<�cmcy0qyt00006tp60dx4akept["constitutional_law_fundamentals"]{"modules":["Case Strategy Development","Evidence Presentation","Cross-Examination Techniques","Appeal Procedures"]}+���<f���<f�@?K�
5 � cmcy0qz52000htp60bzjlxpxzConstitutional Law FundamentalsMaster the foundations of constitutional law and charter rights.BEGINNERProf. Sarah Mitchell( �{"modules":["Introduction to Constitutional Law","Charter of Rights and Freedoms","Division of Powers","Constitutional Interpretation"]}���<f���<f
� ��� ?cmcy0qz52000itp60v4eiksuh ?cmcy0qz52000gtp607l5exzt8 ? cmcy0qz52000htp60bzjlxpxz
�
^
/
I
f'3��� BuU/ indexsqlite_autoindex_degree_ceremonies_1degree_ceremonies � u 8sK% indexsqlite_autoindex_user_degrees_1user_degrees ��qr%%�#tableuser_degreesuser_degrees �CREATE TABLE "user_degrees" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"degreeId" TEXT NOT NULL,
"achievedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"ceremonyCompleted" BOOLEAN NOT NULL DEFAULT false,
"ceremonyDate" DATETIME,
"presentedBy" TEXT,
"witnessedBy" TEXT,
"notes" TEXT,
"progressPercentage" REAL NOT NULL DEFAULT 0.0,
"isCurrentTarget" BOOLEAN NOT NULL DEFAULT false,
CONSTRAINT "user_degrees_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_degrees_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=qQ+ indexsqlite_autoindex_society_degrees_1society_degrees�%p++�tablesociety_degreessociety_degrees~CREATE TABLE "society_degrees" (
"id" TEXT NOT NULL PRIMARY KEY,
"degreeNumber" INTEGER NOT NULL,
"name" TEXT NOT NULL,
"title" TEXT,
"description" TEXT NOT NULL,
"requirements" TEXT NOT NULL,
"xpRequired" INTEGER NOT NULL,
"casesRequired" INTEGER NOT NULL DEFAULT 0,
"winRateRequired" REAL,
"clientsRequired" INTEGER NOT NULL DEFAULT 0,
"proBonoRequired" INTEGER NOT NULL DEFAULT 0,
"badgesRequired" TEXT,
"coursesRequired" TEXT,
"mentorshipRequired" INTEGER NOT NULL DEFAULT 0,
"track" TEXT NOT NULL DEFAULT 'LAWYER',
"trackSpecificReqs" TEXT,
"ceremonialText" TEXT,
"symbol" TEXT,
"color" TEXT,
"privileges" TEXT,
"previousDegreeId" TEXT,
"timeRequirement" INTEGER,
"lodgeLevel" TEXT NOT NULL DEFAULT 'BLUE',
"isSecret" BOOLEAN NOT NULL DEFAULT false,
"maxMembers" INTEGER,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "society_degrees_previousDegreeId_fkey" FOREIGN KEY ("previousDegreeId") REFERENCES "society_degrees" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)9oM' indexsqlite_autoindex_law_resources_1law_resources}�cn''�tablelaw_resourceslaw_resources|CREATE TABLE "law_resources" (
"id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"type" TEXT NOT NULL,
"category" TEXT NOT NULL,
"description" TEXT,
"author" TEXT,
"publisher" TEXT,
"publicationDate" DATETIME,
"isbn" TEXT,
"url" TEXT,
"coverImage" TEXT,
"preview" TEXT,
"fullContent" TEXT,
"tags" TEXT,
"difficultyLevel" TEXT NOT NULL DEFAULT 'BEGINNER',
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"viewCount" INTEGER NOT NULL DEFAULT 0,
"downloadCount" INTEGER NOT NULL DEFAULT 0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)-mA indexsqlite_autoindex_courses_1coursesz� l�tablecoursescoursesyCREATE TABLE "courses" (
"id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"description" TEXT NOT NULL,
"category" TEXT NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"instructor" TEXT,
"instructorId" TEXT,
"duration" INTEGER NOT NULL,
"xpReward" INTEGER NOT NULL DEFAULT 0,
"badgeReward" TEXT,
"prerequisites" TEXT,
"syllabus" TEXT NOT NULL,
"materials" TEXT,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"price" REAL NOT NULL DEFAULT 0.0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)
n �
� n � ?A �)7/ w% cmcy0qz7w000ktp60x4nuagw7Environmental Law HandbookBOOKLAND_LAWComprehensive handbook covering environmental protection lawsDr. Emma GreenLegal Education Press���� 978-0-123456-78-9["environment","regulations","land-use","protection"]INTERMEDIATE����<����<͂L?k!�5 y m% cmcy0qz83000ltp60uezl4snlCharter of Rights and Freedoms - Complete GuideSTATUTECIVIL_CODEComprehensive guide to the Canadian Charter of Rights and FreedomsGovernment of Canada ZM�< https://laws-lois.justice.gc.ca/eng/const/page-12.html["charter","constitutional","rights","freedoms"]INTERMEDIATE���<����<ӂ!?Q !�+; � cmcy0qz7w000jtp60mtow8fmcR. v. Oakes - Proportionality TestCASE_LAWCOMMON_LAWLandmark Supreme Court case establishing the Oakes test for Charter limitationsSupreme Court of Canada v�] ["oakes-test","charter","supreme-court","proportionality"]ADVANCED
]���<����<�
� ��� ?cmcy0qz7w000ktp60x4nuagw7 ?cmcy0qz83000ltp60uezl4snl ? cmcy0qz7w000jtp60mtow8fmc
; �
� m T
; � ? 3 �3O � cmcy0qyzj000btp60l2b0bpedInitiate of JusticeFirst step into the Society of Brothers. Learn the fundamentals of law and justice.{"xp":0,"badges":[],"courses":[]}LAWYERWelcome, Initiate, to the path of justice. Your journey begins here.🔰BLUE���;�� ?+ �s � cmcy0qyzj000ctp60g3v1312rSeeker of TruthThose who actively seek truth and justice in their legal practice.{"xp":500,"badges":["justice_seeker"],"courses":[]}�LAWYERYou have shown dedication to truth. Continue your quest with wisdom.🔍BLUE���;�� ?' ��# o cmcy0qyzj000etp60h6bkjwhvMaster of LawDeep understanding of legal principles and exceptional case results.{"xp":5000,"badges":["david_vs_goliath"],"courses":["advanced_litigation"]}�2LAWYERMaster, your wisdom guides others toward justice.⚖️BLUE���;��J ?; �I� � cmcy0qz0t000ftp60fhuevkig!Grand Master of JusticeThe highest degree. Reserved for those who have achieved legendary status in legal excellence.{"xp":20000,"badges":["all_legendary"],"courses":["all_advanced"]}N �LAWYERGrand Master, you embody the highest ideals of justice and wisdom.👑BLUE���;͂" ?1 �� � cmcy0qyzj000dtp60oogviehaGuardian of RightsProtector of fundamental human rights and civil liberties.{"xp":1500,"badges":["pro_bono_hero"],"courses":["constitutional_law"]}�
LAWYERAs Guardian, you pledge to protect the rights of all people.🛡️BLUE���;�
k k���� ?cmcy0qyzj000btp60l2b0bped ?cmcy0qyzj000ctp60g3v1312r ?cmcy0qyzj000etp60h6bkjwhv ?cmcy0qz0t000ftp60fhuevkig ? cmcy0qyzj000dtp60oogvieha
�
m � �X C�
� m
�
;
; � �|//�9tablelodge_membershipslodge_memberships �CREATE TABLE "lodge_memberships" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"lodgeId" TEXT NOT NULL,
"joinedDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"role" TEXT NOT NULL DEFAULT 'MEMBER',
"isActive" BOOLEAN NOT NULL DEFAULT true,
"contributions" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT "lodge_memberships_lodgeId_fkey" FOREIGN KEY ("lodgeId") REFERENCES "lodges" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lodge_memberships_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�x33�Stablementorship_sessionsmentorship_sessions �CREATE TABLE "mentorship_sessions" (
"id" TEXT NOT NULL PRIMARY KEY,
"mentorshipId" TEXT NOT NULL,
"sessionDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"duration" INTEGER,
"topic" TEXT NOT NULL,
"objectives" TEXT,
"outcomes" TEXT,
"nextSteps" TEXT,
"menteeProgress" INTEGER,
CONSTRAINT "mentorship_sessions_mentorshipId_fkey" FOREIGN KEY ("mentorshipId") REFERENCES "brotherhood_mentorships" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)FyY3 indexsqlite_autoindex_mentorship_sessions_1mentorship_sessions ��hv;;�etablebrotherhood_mentorshipsbrotherhood_mentorships �CREATE TABLE "brotherhood_mentorships" (
"id" TEXT NOT NULL PRIMARY KEY,
"mentorId" TEXT NOT NULL,
"menteeId" TEXT NOT NULL,
"degreeId" TEXT,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"startDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"endDate" DATETIME,
"sessionsCompleted" INTEGER NOT NULL DEFAULT 0,
"goalSessions" INTEGER NOT NULL DEFAULT 5,
"progressNotes" TEXT,
"wasSuccessful" BOOLEAN,
"mentorRating" INTEGER,
"menteeRating" INTEGER,
CONSTRAINT "brotherhood_mentorships_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "brotherhood_mentorships_menteeId_fkey" FOREIGN KEY ("menteeId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "brotherhood_mentorships_mentorId_fkey" FOREIGN KEY ("mentorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)Nwa; indexsqlite_autoindex_brotherhood_mentorships_1brotherhood_mentorships � � BuU/ indexsqlite_autoindex_degree_ceremonies_1degree_ceremonies ��1t//�tabledegree_ceremoniesdegree_ceremonies �CREATE TABLE "degree_ceremonies" (
"id" TEXT NOT NULL PRIMARY KEY,
"degreeId" TEXT NOT NULL,
"userDegreeId" TEXT NOT NULL,
"ceremonyDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"conductedBy" TEXT NOT NULL,
"witnesses" TEXT,
"location" TEXT,
"notes" TEXT,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
CONSTRAINT "degree_ceremonies_userDegreeId_fkey" FOREIGN KEY ("userDegreeId") REFERENCES "user_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "degree_ceremonies_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) K% indexsqlite_autoindex_user_degrees_1user_degrees ��qr%%�#tableuser_degreesuser_degrees �CREATE TABLE "user_degrees" (
"id" TEXT NOT NULL PRIMARY KEY,
:M' indexsqlite_autoindex_case_supports_1case_supports ��|//�9tablelodge_membersB}U/ indexsqlite_autoindex_lodge_memberships_1lodge_memberships �,{? indexsqlite_autoindex_lodges_1lodges ��xz�Itablelodgeslodges �CREATE TABLE "lodges" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT NOT NULL,
"lodgeLevel" TEXT NOT NULL,
"track" TEXT NOT NULL DEFAULT 'LAWYER',
"minimumDegree" INTEGER NOT NULL,
"maximumMembers" INTEGER,
"currentMembers" INTEGER NOT NULL DEFAULT 0,
"isSecret" BOOLEAN NOT NULL DEFAULT false,
"foundedDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"meetingSchedule" TEXT,
"meetingLocation" TEXT
)
� � V???cmcq40qp80001vj6ghbhfrn9jcmcpzyavn0002vjz01slrcn51cmcpzyax8000avjz0ao7zkw1g��)�+
� � ? cmcq40qp80001vj6ghbhfrn9j
$ �
��L � � � � N N F�Y3 indexsqlite_autoindex_client_testimonials_1client_testimonials � � 8�K% indexsqlite_autoindex_lawyer_stats_1lawyer_stats ��E�%%�Ktablelawyer_statslawyer_stats �CREATE TABLE "lawyer_stats" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"totalClients" INTEGER NOT NULL DEFAULT 0,
"activeClients" INTEGER NOT NULL DEFAULT 0,
"casesWon" INTEGER NOT NULL DEFAULT 0,
"casesLost" INTEGER NOT NULL DEFAULT 0,
"casesSettled" INTEGER NOT NULL DEFAULT 0,
"casesDismissed" INTEGER NOT NULL DEFAULT 0,
"winRate" REAL NOT NULL DEFAULT 0.0,
"totalRevenue" REAL NOT NULL DEFAULT 0.0,
"averageHourlyRate" REAL,
"totalProBonoHours" REAL NOT NULL DEFAULT 0.0,
"totalProBonoValue" REAL NOT NULL DEFAULT 0.0,
"averageSatisfaction" REAL NOT NULL DEFAULT 0.0,
"recommendationRate" REAL NOT NULL DEFAULT 0.0,
"totalTestimonials" INTEGER NOT NULL DEFAULT 0,
"lifeChangingCases" INTEGER NOT NULL DEFAULT 0,
"totalSettlementValue" REAL NOT NULL DEFAULT 0.0,
"lastCalculated" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "lawyer_stats_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) (a; indexsqlite_autoindex_relationship_milestones_1relationship_milestones � �;;�;tablerelationship_milestonesrelationship_milestones �CREATE TABLE "relationship_milestones" (
"id" TEXT NOT NULL PRIMARY KEY,
"relationshipId" TEXT NOT NULL,
"caseId" TEXT,
"milestoneType" TEXT NOT NULL,
"title" TEXT NOT NULL,
"description" TEXT,
"date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"amount" REAL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
CONSTRAINT "relationship_milestones_relationshipId_fkey" FOREIGN KEY ("relationshipId") REFERENCES "client_lawyer_relationships" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "relationship_milestones_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)V�iC indexsqlite_autoindex_client_lawyer_relationships_1client_lawyer_relationships ��.� CC�atableclient_lawyer_relationshipsclient_lawyer_relationships �CREATE TABLE "client_lawyer_relationships" (
"id" TEXT NOT NULL PRIMARY KEY,
"clientId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"caseId" TEXT,
"relationshipType" TEXT NOT NULL,
"startDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"endDate" DATETIME,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"totalHoursWorked" REAL,
"totalFeePaid" REAL,
"feeStructure" TEXT,
"caseStatus" TEXT,
"outcomeDescription" TEXT,
"settlementAmount" REAL,
"clientSatisfaction" INTEGER,
"wouldRecommend" BOOLEAN,
"impactLevel" TEXT,
"clientReview" TEXT,
"lawyerNotes" TEXT,
"publicTestimonial" TEXT,
"isTestimonialPublic" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "client_lawyer_relationships_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_lawyer_relationships_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "client_lawyer_relationships_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
):M' indexsqlite_autoindex_case_supports_1case_supports ��j~''�tablecase_supportscase_supports �CREATE TABLE "case_supports" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"caseId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "case_supports_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_supports_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
�F� �
u
�� _ D D [???cmd1qai8b0013tpjg0g62emn1cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51like� ��
??cmd1qai5h0011tpjg0t2y2m5pcmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51justice� �e\[???cmd4s19g60007tpmksngtlrtucmd4s11fh0001tpmkk2j621b3cmcpzyavn0002vjz01slrcn51love�b[???cmd43fq8m000ltp2sz3kzit7acmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51like� ���[ ???cmcz4w9ya0039tpfgvc110mmqcmcz2afud0017tpfgqilhx2licmcpzyavn0002vjz01slrcn51love���*b/ \??cmd1q0ek4000ltpjgsu4j85g0cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51wow���[ ???cmd12pw060001tplkiob6quhacmczesli70005tp54q9mlxea1cmcpzyavn0002vjz01slrcn51love���B[ ???cmd17xl8m0001tpfo7jbdo1cjcmcz29wyu0011tpfgrq39r33lcmcpzyavn0002vjz01slrcn51like�3D� Z??cmcz2hnws001htpfglwqn2z71cmcz2a56j0015tpfgu6tzhi0lcmcpzyavn0002vjz01slrcn51sad��r^
???cmd17xspi0005tpfo7cjtki26cmcz2a56j0015tpfgu6tzhi0lcmcpzyavn0002vjz01slrcn51justice�3j�[???cmcyz7jt30001tptwen8gfusqcmcyz17800003tpfgesru13r8cmcpzyaw30004vjz045cducwilike�� k[???cmcrrbike0007vjv46gope27wcmcrrbdui0005vjv4od1cn2stcmcpzyavn0002vjz01slrcn51like����[???cmcq43w400005vj6g685u1acbcmcq43pk80003vj6g9r7qmtxncmcpzyavn0002vjz01slrcn51love��,1P
�
� � +�� � � � � � � D� W1 indexsqlite_autoindex_user_subscriptions_1user_subscriptions ��C�11�/tablesubscription_planssubscription_plans �CREATE TABLE "subscription_plans" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT NOT NULL,
"price" REAL NOT NULL,
"currency" TEXT NOT NULL DEFAULT 'CAD',
"billingCycle" TEXT NOT NULL DEFAULT 'MONTHLY',
"features" TEXT NOT NULL,
"maxCases" INTEGER NOT NULL DEFAULT 10,
"maxUsers" INTEGER NOT NULL DEFAULT 10,
"maxTeamMembers" INTEGER NOT NULL DEFAULT 5,
"advancedAnalytics" BOOLEAN NOT NULL DEFAULT false,
"prioritySupport" BOOLEAN NOT NULL DEFAULT false,
"customBranding" BOOLEAN NOT NULL DEFAULT false,
"apiAccess" BOOLEAN NOT NULL DEFAULT false,
"societyDiscount" REAL NOT NULL DEFAULT 0.0,
"xpMultiplier" REAL NOT NULL DEFAULT 1.0,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"sortOrder" INTEGER NOT NULL DEFAULT 0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)� W1 D� W1 indexsqlite_autoindex_subscription_plans_1subscription_plans � fMY3 indexsqlite_autoindex_client_testimonials_1client_testimonials � f33�%tableclient_testimonialsclient_testimonials �CREATE TABLE "client_testimonials" (
"id" TEXT NOT NULL PRIMARY KEY,
"clientId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"relationshipId" TEXT,
"caseId" TEXT,
"title" TEXT NOT NULL,
"content" TEXT NOT NULL,
"beforeSituation" TEXT,
"afterSituation" TEXT,
"category" TEXT NOT NULL,
"impactLevel" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"isFeatured" BOOLEAN NOT NULL DEFAULT false,
"helpfulVotes" INTEGER NOT NULL DEFAULT 0,
"views" INTEGER NOT NULL DEFAULT 0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "client_testimonials_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_relationshipId_fkey" FOREIGN KEY ("relationshipId") REFERENCES "client_lawyer_relationships" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)8�K% indexsqlite_autoindex_lawyer_stats_1lawyer_stats � K%%�Ktablelawyer_statslawyer_stats �CREATE TABLE "lawyer_stats"J�
]D� W1 indexsqlite_autoindex_user_subscriptions_1user_subscriptions ���
11�1tableuser_subscriptionsuser_subscriptions �CREATE TABLE "user_subscriptions" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"planId" TEXT NOT NULL,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"currentPeriodStart" DATETIME NOT NULL,
"currentPeriodEnd" DATETIME NOT NULL,
"cancelAtPeriodEnd" BOOLEAN NOT NULL DEFAULT false,
"stripeSubscriptionId" TEXT,
"stripeCustomerId" TEXT,
"lastPaymentDate" DATETIME,
"nextPaymentDate" DATETIME,
"amountPaid" REAL NOT NULL DEFAULT 0.0,
"paymentMethodId" TEXT,
"amount" REAL,
"currency" TEXT,
"billingCycle" TEXT,
"metadata" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "user_subscriptions_planId_fkey" FOREIGN KEY ("planId") REFERENCES "subscription_plans" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_subscriptions_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
� � ����ii� N�a; indexsqlite_autoindex_document_collaborations_1document_collaborations � J >�Q+ indexsqlite_autoindex_calendar_events_1calendar_events ��3�++�tablecalendar_eventscalendar_events �CREATE TABLE "calendar_events" (
"id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"description" TEXT,
"eventType" TEXT NOT NULL,
"date" DATETIME NOT NULL,
"startTime" TEXT,
"endTime" TEXT,
"duration" INTEGER,
"priority" TEXT NOT NULL DEFAULT 'MEDIUM',
"caseId" TEXT,
"clientId" TEXT,
"lawyerId" TEXT NOT NULL,
"location" TEXT,
"isVirtual" BOOLEAN NOT NULL DEFAULT false,
"meetingLink" TEXT,
"courtJurisdiction" TEXT,
"documentsRequired" TEXT,
"notes" TEXT,
"reminders" TEXT,
"billingRate" REAL,
"estimatedHours" REAL,
"status" TEXT NOT NULL DEFAULT 'SCHEDULED',
"linkedEvents" TEXT,
"aiSuggestions" TEXT,
"participants" TEXT,
"createdBy" TEXT,
"type" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "calendar_events_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "calendar_events_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "calendar_events_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "calendar_events_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)*�= indexsqlite_autoindex_tasks_1tasks ��<��Utabletaskstasks �CREATE TABLE "tasks" (
"id" TEXT NOT NULL PRIMARY KEY,
"title" TEXT NOT NULL,
"description" TEXT,
"caseId" TEXT,
"assignedTo" TEXT NOT NULL,
"assignedBy" TEXT NOT NULL,
"priority" TEXT NOT NULL DEFAULT 'MEDIUM',
"status" TEXT NOT NULL DEFAULT 'PENDING',
"dueDate" DATETIME,
"completedAt" DATETIME,
"estimatedHours" REAL,
"actualHours" REAL,
"tags" TEXT,
"attachments" TEXT,
"notes" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "tasks_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "tasks_assignedBy_fkey" FOREIGN KEY ("assignedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "tasks_assignedTo_fkey" FOREIGN KEY ("assignedTo") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)J�
]7 indexsqlite_autoindex_consultation_bookings_1consultation_bookings ��� 77�+tableconsultation_bookingsconsultation_bookings �CREATE TABLE "consultation_bookings" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"clientId" TEXT NOT NULL,
"preferredDate" DATETIME NOT NULL,
"preferredTime" TEXT NOT NULL,
"duration" INTEGER NOT NULL DEFAULT 60,
"consultationType" TEXT NOT NULL DEFAULT 'GENERAL',
"status" TEXT NOT NULL DEFAULT 'PENDING',
"message" TEXT,
"hourlyRate" REAL,
"totalAmount" REAL,
"meetingLink" TEXT,
"meetingPlatform" TEXT,
"notes" TEXT,
"lawyerNotes" TEXT,
"clientNotes" TEXT,
"followUpDate" DATETIME,
"followUpNotes" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "consultation_bookings_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "consultation_bookings_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
� E
��
��G ���� @�S- indexsqlite_autoindex_automation_tasks_1automation_tasks ��$�''�tablenotificationsnotifications �CREATE TABLE "not�$�''�tablenotificationsnotifications �CREATE TABLE "notifications" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"type" TEXT NOT NULL,
"title" TEXT NOT NULL,
"message" TEXT NOT NULL,
"data" TEXT,
"isRead" BOOLEAN NOT NULL DEFAULT false,
"isArchived" BOOLEAN NOT NULL DEFAULT false,
"priority" TEXT NOT NULL DEFAULT 'NORMAL',
"scheduledFor" DATETIME,
"sentAt" DATETIME,
"readAt" DATETIME,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "notifications_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�}�11�#tableanalytics_trackinganalytics_tracking �CREATE TABLE "analytics_tracking" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT,
"caseId" TEXT,
"eventType" TEXT NOT NULL,
"eventData" TEXT,
"sessionId" TEXT,
"userAgent" TEXT,
"ipAddress" TEXT,
"timestamp" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"metadata" TEXT,
CONSTRAINT "analytics_tracking_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "analytics_tracking_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)D�W1 indexsqlite_autoindex_analytics_tracking_1analytics_tracking ���))�mtableclient_portalsclient_portals �CREATE TABLE "client_portals" (
"id" TEXT NOT NULL PRIMARY KEY,
"clientId" TEXT NOT NULL,
"caseId" TEXT,
"accessToken" TEXT NOT NULL,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"lastAccess" DATETIME,
"preferences" TEXT,
"notifications" BOOLEAN NOT NULL DEFAULT true,
"language" TEXT NOT NULL DEFAULT 'en',
"theme" TEXT NOT NULL DEFAULT 'light',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "client_portals_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_portals_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)<�O) indexsqlite_autoindex_client_portals_1client_portals �� N�a; indexsqlite_autoindex_document_collaborations_1document_collaborations ��v�;;�tabledocument_collaborationsdocument_collaborations �CREATE TABLE "document_collaborations" (
"id" TEXT NOT NULL PRIMARY KEY,
"documentId" TEXT NOT NULL,
"caseId" TEXT,
"title" TEXT NOT NULL,
"description" TEXT,
"filePath" TEXT NOT NULL,
"fileType" TEXT NOT NULL,
"fileSize" INTEGER NOT NULL,
"version" INTEGER NOT NULL DEFAULT 1,
"status" TEXT NOT NULL DEFAULT 'DRAFT',
"createdBy" TEXT NOT NULL,
"assignedTo" TEXT,
"dueDate" DATETIME,
"completedAt" DATETIME,
"comments" TEXT,
"changes" TEXT,
"permissions" TEXT,
"tags" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "document_collaborations_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "document_collaborations_assignedTo_fkey" FOREIGN KEY ("assignedTo") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "document_collaborations_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) :�M' indexsqlite_autoindex_notifications_1notifications �
�
�
l � rj!�c � �� Z�#mG indexsqlite_autoindex_case_competition_participants_1case_competition_participants � J >�!Q+ indexsqlite_autoindex_system_settings_1system_settings ��y� ++�'tablesystem_settingssystem_settings �CREATE TABLE "system_settings" (
"id" TEXT NOT NULL PRIMARY KEY,
"siteName" TEXT NOT NULL DEFAULT 'Liberté Meme en Cellule',
"siteDescription" TEXT,
"maintenanceMode" BOOLEAN NOT NULL DEFAULT false,
"maintenanceMessage" TEXT,
"allowRegistrations" BOOLEAN NOT NULL DEFAULT true,
"requireEmailVerification" BOOLEAN NOT NULL DEFAULT false,
"maxFileUploadSize" INTEGER NOT NULL DEFAULT 10485760,
"allowedFileTypes" TEXT,
"defaultLanguage" TEXT NOT NULL DEFAULT 'en',
"supportedLanguages" TEXT,
"timezone" TEXT NOT NULL DEFAULT 'UTC',
"dateFormat" TEXT NOT NULL DEFAULT 'YYYY-MM-DD',
"timeFormat" TEXT NOT NULL DEFAULT 'HH:mm',
"currency" TEXT NOT NULL DEFAULT 'USD',
"currencySymbol" TEXT NOT NULL DEFAULT '$',
"emailSettings" TEXT,
"smtpHost" TEXT,
"smtpPort" INTEGER,
"smtpUser" TEXT,
"smtpPassword" TEXT,
"smtpSecure" BOOLEAN NOT NULL DEFAULT true,
"fromEmail" TEXT,
"fromName" TEXT,
"logoUrl" TEXT,
"faviconUrl" TEXT,
"primaryColor" TEXT NOT NULL DEFAULT '#3B82F6',
"secondaryColor" TEXT NOT NULL DEFAULT '#1F2937',
"analyticsEnabled" BOOLEAN NOT NULL DEFAULT false,
"analyticsCode" TEXT,
"socialMediaLinks" TEXT,
"contactEmail" TEXT,
"contactPhone" TEXT,
"address" TEXT,
"termsOfService" TEXT,
"privacyPolicy" TEXT,
"cookiePolicy" TEXT,
"version" TEXT NOT NULL DEFAULT '1.0.0',
"lastUpdated" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedBy" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)F� Y3 indexsqlite_autoindex_retainer_agreements_1retainer_agreements ��� 33�-tableretainer_agreementsretainer_agreements �CREATE TABLE "retainer_agreements" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"clientId" TEXT NOT NULL,
"monthlyRate" REAL NOT NULL,
"services" TEXT NOT NULL,
"startDate" DATETIME NOT NULL,
"message" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"isActive" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "retainer_agreements_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "retainer_agreements_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)>� Q+ indexsqlite_autoindex_automation_logs_1automation_logs ��5� ++� tableautomation_logsautomation_logs �CREATE TABLE "automation_logs" (
"id" TEXT NOT NULL PRIMARY KEY,
"taskId" TEXT NOT NULL,
"status" TEXT NOT NULL,
"output" TEXT,
"error" TEXT,
"executionTime" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"duration" INTEGER,
CONSTRAINT "automation_logs_taskId_fkey" FOREIGN KEY ("taskId") REFERENCES "automation_tasks" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)@�S- indexsqlite_autoindex_automation_tasks_1automation_tasks ��M�--�Ktableautomation_tasksautomation_tasks �CREATE TABLE "automation_tasks" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"description" TEXT,
"type" TEXT NOT NULL,
"schedule" TEXT NOT NULL,
"enabled" BOOLEAN NOT NULL DEFAULT true,
"status" TEXT NOT NULL DEFAULT 'active',
"lastRun" DATETIME,
"nextRun" DATETIME,
"successCount" INTEGER NOT NULL DEFAULT 0,
"errorCount" INTEGER NOT NULL DEFAULT 0,
"lastError" TEXT,
"config" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)
� � �
= �
6 �� �RR <�)O) indexsqlite_autoindex_clerk_profiles_1clerk_profiles ��Z�&11�]tableassistant_profilesassistant_profiles �CREATE TABLE "assistant_profiles" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"firstName" TEXT NOT NULL DEFAULT '',
"lastName" TEXT NOT NULL DEFAULT '',
"email" TEXT NOT NULL DEFAULT '',
"phone" TEXT NOT NULL DEFAULT '',
"address" TEXT NOT NULL DEFAULT '',
"city" TEXT NOT NULL DEFAULT '',
"state" TEXT NOT NULL DEFAULT '',
"zipCode" TEXT NOT NULL DEFAULT '',
"country" TEXT NOT NULL DEFAULT '',
"dateOfBirth" TEXT NOT NULL DEFAULT '',
"gender" TEXT NOT NULL DEFAULT '',
"bio" TEXT NOT NULL DEFAULT '',
"experience" TEXT NOT NULL DEFAULT '',
"education" TEXT NOT NULL DEFAULT '',
"certifications" TEXT NOT NULL DEFAULT '',
"languages" TEXT NOT NULL DEFAULT '',
"specializations" TEXT NOT NULL DEFAULT '',
"softwareSkills" TEXT NOT NULL DEFAULT '',
"availability" TEXT NOT NULL DEFAULT '',
"hourlyRate" REAL NOT NULL DEFAULT 0,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"linkedinUrl" TEXT NOT NULL DEFAULT '',
"websiteUrl" TEXT NOT NULL DEFAULT '',
"profilePicture" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "assistant_profiles_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)D�'W1 indexsqlite_autoindex_assistant_profiles_1assistant_profiles ��h�$ � tablecase_bidscase_bids �CREATE TABLE "case_bids" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"bidAmount" REAL NOT NULL,
"message" TEXT NOT NULL,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "case_bids_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_bids_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)2�%E indexsqlite_autoindex_case_bids_1case_bids � Z�#mG indexsqlite_autoindex_case_competition_participants_1case_competition_participants ��~�"GG�ytablecase_competition_participantscase_competition_participants �CREATE TABLE "case_competition_participants" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"caseId" TEXT NOT NULL,
"joinedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"notes" TEXT,
CONSTRAINT "case_competition_participants_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_competition_participants_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)>�!Q+ indexsqlite_autoindex_system_settings_1system_settings �
l �
�
D�0�I�
t�j��� L �6�9]1�iindexDocumentPermission_documentId_userId_keyDocumentPermission �CREATE UNIQUE INDEX "DocumentPermission_documentId_userId_key" ON "DocumentPermission"("documentId", "userId")�-�8Y+�aindexDocumentVersion_documentId_version_keyDocumentVersion �CREATE UNIQUE INDEX "DocumentVersion_documentId_version_key" ON "DocumentVersion"("documentId", "version")�/�7Y/�aindexVerificationToken_identifier_token_keyVerificationToken �CREATE UNIQUE INDEX "VerificationToken_identifier_token_key" ON "VerificationToken"("identifier", "token")� �6C/�/indexVerificationToken_token_keyVerificationToken �CREATE UNIQUE INDEX "VerificationToken_token_key" ON "VerificationToken"("token")x�5=�#indexSession_sessionToken_keySession �CREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken")��4K%�?indexDetaineeInfo_registrationId_keyDetaineeInfo �CREATE UNIQUE INDEX "DetaineeInfo_registrationId_key" ON "DetaineeInfo"("registrationId")~�3A�+indexAddress_registrationId_keyAddress �CREATE UNIQUE INDEX "Address_registrationId_key" ON "Address"("registrationId")�:�2a-�qindexcase_assignments_registrationId_userId_keycase_assignments �CREATE UNIQUE INDEX "case_assignments_registrationId_userId_key" ON "case_assignments"("registrationId", "userId")�&�1U#�_indexpermissions_role_resource_action_keypermissions �CREATE UNIQUE INDEX "permissions_role_resource_action_key" ON "permissions"("role", "resource", "action")v�09#�indexUserProfile_userId_keyUserProfile �CREATE UNIQUE INDEX "UserProfile_userId_key" ON "UserProfile"("userId") �1� indexusers_username_keyusers �CREATE UNIQUE INDEX "users_username_key" ON "users"("username") ]+indexusers_email_keyusers �CREATE UNIQUE INDEX "users_email_key" ON "users"("email")� �-;;�Stable_BusinessProfileMembers_BusinessProfileMembers �CREATE TABLE "_BusinessProfileMembers" (
"A" TEXT NOT NULL,
"B" TEXT NOT NULL,
CONSTRAINT "_BusinessProfileMembers_A_fkey" FOREIGN KEY ("A") REFERENCES "BusinessProfile" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "_BusinessProfileMembers_B_fkey" FOREIGN KEY ("B") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�m�,++�table_UserLegalCases_UserLegalCases �CREATE TABLE "_UserLegalCases" (
"A" TEXT NOT NULL,
"B" TEXT NOT NULL,
CONSTRAINT "_UserLegalCases_A_fkey" FOREIGN KEY ("A") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "_UserLegalCases_B_fkey" FOREIGN KEY ("B") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)<�)O) indexsqlite_autoindex_clerk_profiles_1clerk_profiles ��y�())�+tableclerk_profilesclerk_profiles �CREATE TABLE "clerk_profiles" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"firstName" TEXT NOT NULL DEFAULT '',
"lastName" TEXT NOT NULL DEFAULT '',
"email" TEXT NOT NULL DEFAULT '',
"phone" TEXT NOT NULL DEFAULT '',
"address" TEXT NOT NULL DEFAULT '',
"city" TEXT NOT NULL DEFAULT '',
"state" TEXT NOT NULL DEFAULT '',
"zipCode" TEXT NOT NULL DEFAULT '',
"country" TEXT NOT NULL DEFAULT '',
"dateOfBirth" TEXT NOT NULL DEFAULT '',
"gender" TEXT NOT NULL DEFAULT '',
"bio" TEXT NOT NULL DEFAULT '',
"experience" TEXT NOT NULL DEFAULT '',
"education" TEXT NOT NULL DEFAULT '',
"certifications" TEXT NOT NULL DEFAULT '',
"languages" TEXT NOT NULL DEFAULT '',
"specializations" TEXT NOT NULL DEFAULT '',
"courtSystems" TEXT NOT NULL DEFAULT '',
"filingProcedures" TEXT NOT NULL DEFAULT '',
"availability" TEXT NOT NULL DEFAULT '',
"hourlyRate" REAL NOT NULL DEFAULT 0,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"linkedinUrl" TEXT NOT NULL DEFAULT '',
"websiteUrl" TEXT NOT NULL DEFAULT '',
"profilePicture" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "clerk_profiles_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
) � ��
{ � x � q
�
o � m�k�g�e�c�a��� �%�&w � ??? K cmcu4l7p80001tpygbd8rsr30cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��;����|! ????cmcu4lcuq0003tpygveyl7n75cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcu4l7p80001tpygbd8rsr30h��0S��0S| ????cmcspjq8f0001vjzkmak048jwcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcs8gc7r0005vjhshk226ondk������ ?e# ??? cmcy4g2va0005tphwpo6qk5whcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51ihl�� ���� ��d" ??? cmcy4enn50003tphw6en8hj4fcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi���1���1� ??? K cmcs8gc7r0005vjhshk226ondcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]�������$�d$ ??? cmcy4k0610007tphw2mg8pt83cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hh�� ���� �ف ??? K cmcrrbdui0005vjv4od1cn2stcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]������ >6| ????cmcrrb3cx0003vjv4os48hmg9cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrrazr90001vjv46lxlj7ndf��l���l�� ??? K cmcrrazr90001vjv46lxlj7ndcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��Z���z| ????cmcrqa2yp0015vjy8ck2l12cvcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrq9ynd0013vjy8f8pc2tftd������� ??? K cmcrq9ynd0013vjy8f8pc2tftcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]�������;| ????cmcrq0j90000zvjy878aum169cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrq0fyq000xvjy8dkmcj0uug��Gt��Gt� ??? K cmcrq0fyq000xvjy8dkmcj0uucmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��6���V�~ ????cmcrp0j5q000rvjy8hb0uajh8cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrp0fav000pvjy8rxdoewl3ffg��ޥ���ޥ�� ??? K cmcrp0fav000pvjy8rxdoewl3cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��ޒw����2| ????cmcroyrga000nvjy8sy2jxh98cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcroyp5u000lvjy8xzay82g9f���cz���cz� ??? K cmcroyp5u000lvjy8xzay82g9cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���W������| ????cmcroql65000jvjy82v46zgepcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcroqh4d000hvjy8rsp1sa8uh��ב���ב�� ??? K cmcroqh4d000hvjy8rsp1sa8ucmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���}-����
??? K cmcroceb5000dvjy88lllxe72cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���wq��Ͱ�| ????cmcrngwx00005vjy81h49payfcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrnepsv0001vjy8c2rl4mtbh�߷
��߷
��
??? K cmcrnepsv0001vjy8c2rl4mtbcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]�ߵ} ����� ????cmcr0vkj20003vjd0wksrqtm8cmcpzyax8000avjz0ao7zkw1gcmcpzyawf0006vjz02w4s3ilacmcr0vdv50001vjd0pe8u53xkrtrii��t���t�� ??? K cmcr0vdv50001vjd0pe8u53xkcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��s�����ܳ} ????cmcq4w5bz0005vjjoz1p6spxmcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq4ptga0003vjjo7i3rw5wrhi��@N���@N�� ??? K cmcq4ptga0003vjjo7i3rw5wrcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��;�[��Nv�} ????cmcq4fd01000bvj6g3inf3b95cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxnhi��4[���4[�| ????cmcq4c7lu0009vj6go7mpiwt6cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxnt��2 ���2 �~ ????cmcq45p9f0007vj6ghupp94urcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxntss��-{#��-{#� ??? K cmcq43pk80003vj6g9r7qmtxncmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]� 8
=� ����kM�/���{]?!
�
�
�
�
m
O
1 � � } _ �
� A # � � � � o Q 3
�
�
�
�
a
C
%
� � � � q S 5 �� ?cmd4s11fh0001tpmkk2j621b3B ?cmd17z4ic0009tpfov7i9jgr1A ?cmd17ye9a0007tpfodbxppcjt@ ?cmczesli70005tp54q9mlxea1? ?cmcz2afud0017tpfgqilhx2li> ?cmcz2a56j0015tpfgu6tzhi0l= ?cmcz29wyu0011tpfgrq39r33l< ?cmcz29pgw000ztpfg67xslkvb; ?cmcz29jij000xtpfgmqkmaeat: ?cmcz22lf8000vtpfga4e6mq019 ?cmcz22fz6000ttpfgwdv8m7vx8 ?cmcz1xh03000rtpfgdkh6y2qs7 ?cmcz1u06m000ptpfgbqte3ysa6 ?cmcz1t1q9000ntpfgv3pw16325 ?cmcz1s5rq000ltpfgh6hio1g44 ?cmcz14ene000jtpfgx7w8ljki3 ?cmcz0n2f0000ftpfglg6hr0sh2 ?cmcz0mjkj000dtpfgad63e9rj1 ?cmcz088pl000btpfg1ibabfrk0 ?cmcz0808x0009tpfgzy0muw51/ ?cmcz07jgs0007tpfg1124z4cx. ?cmcz05spm0003tpu8rhqdixz6- ?cmcz05soc0001tpu89x3hbiy7, ?cmcyzb6mp0003tp1cw55zhcae+ ?cmcyzb6m60001tp1cajvxcazx* ?cmcyzamqt0003tpmcawcvi4jq) ?cmcyzamqb0001tpmcb945cs7q( ?cmcyz17800003tpfgesru13r8' ?cmcy4tc9w0001tp8ogx597dxc& ?cmcy4swy00001tpoowc98jtr4% ?cmcu4lcuq0003tpygveyl7n75! ?cmcu4l7p80001tpygbd8rsr30 ?cmcspjq8f0001vjzkmak048jw ?cmcy4enn50003tphw6en8hj4f" ?cmcs8gc7r0005vjhshk226ond ?cmcy4k0610007tphw2mg8pt83$ ?cmcy4g2va0005tphwpo6qk5wh# ?cmcrrbdui0005vjv4od1cn2st ?cmcrrb3cx0003vjv4os48hmg9 ?cmcrrazr90001vjv46lxlj7nd ?cmcrqa2yp0015vjy8ck2l12cv ?cmcrq9ynd0013vjy8f8pc2tft ?cmcrq0j90000zvjy878aum169 ?cmcrq0fyq000xvjy8dkmcj0uu ?cmcrp0j5q000rvjy8hb0uajh8 ?cmcrp0fav000pvjy8rxdoewl3 ?cmcroyrga000nvjy8sy2jxh98 ?cmcroyp5u000lvjy8xzay82g9 ?cmcroql65000jvjy82v46zgep ?cmcroqh4d000hvjy8rsp1sa8u ?cmcrngwx00005vjy81h49payf ?cmcroceb5000dvjy88lllxe72
?cmcr0vkj20003vjd0wksrqtm8 ?cmcr0vdv50001vjd0pe8u53xk ?cmcrnepsv0001vjy8c2rl4mtb
?cmcq4w5bz0005vjjoz1p6spxm ?cmcq4ptga0003vjjo7i3rw5wr ?cmcq4fd01000bvj6g3inf3b95 ?cmcq4c7lu0009vj6go7mpiwt6 ?cmcq45p9f0007vj6ghupp94ur ? cmcq43pk80003vj6g9r7qmtxn
Y ��[$�H�
�
�
l
5 � � � Y 5??cmcqfih0g0001vjoolt160supcmcr8nl9a0008vjkckflkcp0t5??cmcqfih0g0001vjoolt160supcmcr8nl8g0007vjkcmzk2w23c5??cmcqfih0g0001vjoolt160supcmcr8nl7u0006vjkctb5suwc75??cmcqfih0g0001vjoolt160supcmcr8nl770005vjkce4bhgbhl5??cmcqfih0g0001vjoolt160supcmcr8nl6h0004vjkcpkv2nqun5
??cmcqfih0g0001vjoolt160supcmcr8nl5o0003vjkcxkkdsn5m5 ??cmcqfih0g0001vjoolt160supcmcr8nl4v0002vjkcyghd6gpm5 ??cmcqfih0g0001vjoolt160supcmcr8nl430001vjkcq8iprukc5 ??cmcqfih0g0001vjoolt160supcmcqfhvgx000dvjhc2ls6th025??cmcqfih0g0001vjoolt160supcmcqfhu8f0007vjhcove5lw8r5??cmcqfih0g0001vjoolt160supcmcqfhtcq0003vjhcm2e8yg8y5??cmcqfih0g0001vjoolt160supcmcqfhunh0009vjhck1pbja1u5
??cmcqfih0g0001vjoolt160supcmcr8nl380000vjkc8wfcezbu5??cmcqfih0g0001vjoolt160supcmcqfhv2d000bvjhc6q3z2yc05??cmcqfih0g0001vjoolt160supcmcqfhtu60005vjhchckp6tz55??cmcqfih0g0001vjoolt160supcmcqfhsqx0001vjhc8ntsvvrc5??cmcqfih0g0001vjoolt160supcmcpzyaw30004vjz045cducwi
A �������������������yk]OA
ADW-12352
ADW-12351
ADW-12350
ADW-12349
ADW-12348
ADW-12347
ADW-12346
ADW-12345
� �� 7??cmcqjb6o80009vjfk3wo56kx0cmcqfhsqx0001vjhc8ntsvvrc6?? cmcqjb6o80009vjfk3wo56kx0cmcpzyawf0006vjz02w4s3ila
� � ? cmcqjb6o80009vjfk3wo56kx0
� � ? cmcqjb6o80009vjfk3wo56kx0
X � ����Y
� � @ }
�
�����0� ��XS � � �-�RY+�aindexsociety_degrees_degreeNumber_track_keysociety_degrees �CREATE UNIQUE INDEX "society_degrees_degreeNumber_track_key" ON "society_degrees"("degreeNumber", "track")�Q�Qo+�indexmentor_session��OI3�;indexfinancial_summaries_userId_keyfinancial_summaries �CREATE UNIQUE INDEX "financial_summaries_userId_key" ON "financial_summaries"("userId")�6�9]1�iindexDocumentPermission_documentId_userId_keyDocumentPermission �CREATE UNIQUE INDEX "DocumentPermission_documentId_userId_key" ON "DocumentPermission"("documentId", "userId")�-�8Y+�aindexDocumentVersion_documentId_version_keyDocumentVersion �CREATE UNIQUE INDEX "DocumentVersion_documentId_version_key" ON "DocumentVersion"("documentId", "version") �I7�;indexsociety_pricing_tiers_name_keysociety_pricing_tiers �CREATE UNIQUE INDEX "society_pricing_tiers_name_key" ON "society_pricing_tiers"("name")� �MQ+�Kindexpayment_refunds_stripeRefundId_keypayment_refunds �CREATE UNIQUE INDEX "payment_refunds_stripeRefundId_key" ON "payment_refunds"("stripeRefundId")��LA+�+indexescrow_accounts_userId_keyescrow_accounts �CREATE UNIQUE INDEX "escrow_accounts_userId_key" ON "escrow_accounts"("userId")��KA+�+indexescrow_accounts_caseId_keyescrow_accounts �CREATE UNIQUE INDEX "escrow_accounts_caseId_key" ON "escrow_accounts"("caseId")��JC �/indexpayments_stripeChargeId_keypayments �CREATE UNIQUE INDEX "payments_stripeChargeId_key" ON "payments"("stripeChargeId")��IQ �Kindexpayments_stripePaymentIntentId_keypayments �CREATE UNIQUE INDEX "payments_stripePaymentIntentId_key" ON "payments"("stripePaymentIntentId")�;�Ha/�qindexuser_achievements_userId_achievementId_keyuser_achievements �CREATE UNIQUE INDEX "user_achievements_userId_achievementId_key" ON "user_achievements"("userId", "achievementId")t�G7%�indexachievements_name_keyachievements �CREATE UNIQUE INDEX "achievements_name_key" ON "achievements"("name")��FI#�Aindexuser_badges_userId_badgeId_keyuser_badges �CREATE UNIQUE INDEX "user_badges_userId_badgeId_key" ON "user_badges"("userId", "badgeId")[�E+indexbadges_name_keybadges �CREATE UNIQUE INDEX "badges_name_key" ON "badges"("name")�8�D_)�sindexlawyer_ratings_lawyerId_userId_caseId_keylawyer_ratings �CREATE UNIQUE INDEX "lawyer_ratings_lawyerId_userId_caseId_key" ON "lawyer_ratings"("lawyerId", "userId", "caseId")h�C1 � indexlaw_firms_name_keylaw_firms �CREATE UNIQUE INDEX "law_firms_name_key" ON "law_firms"("name")��BA#�+indexlegal_cases_caseNumber_keylegal_cases �CREATE UNIQUE INDEX "legal_cases_caseNumber_key" ON "legal_cases"("caseNumber")�X�Aq9�indeximpersonation_sessions_originalUserId_isActive_keyimpersonation_sessions �CREATE UNIQUE INDEX "impersonation_sessions_originalUserId_isActive_key" ON "impersonation_sessions"("originalUserId", "isActive")�?�@e+�yindexsegment_members_segmentId_subscriptionId_keysegment_members �CREATE UNIQUE INDEX "segment_members_segmentId_subscriptionId_key" ON "segment_members"("segmentId", "subscriptionId")�'�?Q=�Kindexnewsletter_subscriptions_email_keynewsletter_subscriptions �CREATE UNIQUE INDEX "newsletter_subscriptions_email_key" ON "newsletter_subscriptions"("email")�<�>a+�windexMessageReaction_messageId_userId_emoji_keyMessageReaction �CREATE UNIQUE INDEX "MessageReaction_messageId_userId_emoji_key" ON "MessageReaction"("messageId", "userId", "emoji")�*�=W+�]indextyping_statuses_userId_chatRoomId_keytyping_statuses �CREATE UNIQUE INDEX "typing_statuses_userId_chatRoomId_key" ON "typing_statuses"("userId", "chatRoomId")��<I#�;indexPrivateChat_registrationId_keyPrivateChat �CREATE UNIQUE INDEX "PrivateChat_registrationId_key" ON "PrivateChat"("registrationId")�*�;W+�]indexChatParticipant_userId_chatRoomId_keyChatParticipant �CREATE UNIQUE INDEX "ChatParticipant_userId_chatRoomId_key" ON "ChatParticipant"("userId", "chatRoomId")d�:/ �indexChatRoom_name_keyChatRoom �CREATE UNIQUE INDEX "ChatRoom_name_key" ON "ChatRoom"("name")
E �� �I6���hS�yb���E
Général-E.D. de Roberval!GE.D. de Rivière-des-Prairies EE.D. de Montréal (Bordeaux)3E.D. de Sorel-Tracy;E.D. de Trois-Rivières'E.L. de Laval
9E.D. de Saint-Jérôme %E.D. de Hull 5E.D. de Havre-Aubert
)E.D. de Percé 5E.D. de New Carlisle1E.D. de Sherbrooke1E.D. de Sept-Îles3E.D. de Baie-Comeau7E.D. de Québec – M7E.D. de Québec – F-E.D. de Rimouski# E.D. d'Amos
� � 6?? cmcpzyavn0002vjz01slrcn51cmcqixupc000gvjk8935afkrj
� � ? cmcqjb6o80009vjfk3wo56kx0
� G ���fG ? cmcr8nl8g0007vjkcmzk2w23c ?cmcr8nl8g0007vjkcmzk2w23c ?cmcpzyavn0002vjz01slrcn51 ?cmcqfhsqx0001vjhc8ntsvvrc cmcpzyavn0002vjz01slrcn51 ? cmcpzyavn0002vjz01slrcn51
� ���� %2024QCCS4540 % 2024QCCS4539
� �� 1Wee & Partners LLP# ADW Avocats
� ����� )Justice Seeker)Case Supporter'Pro Bono Hero+Platform Patron- David vs Goliath
Y Y�� 7??cmcy0qypj0000tp6029gm0o4mcmcy0qyt10008tp605i7nmgp97??cmcy0qypj0001tp60jvd1rf7bcmcy0qyt00006tp60dx4akept6?? cmcy0qypj0000tp6029gm0o4mcmcy0qyu8000atp60pscft3x6
� �� ?cmcqixujd0000vjk80kvazthp ? cmcpzyavn0002vjz01slrcn51
� > =� m
� �G��Y�� � >R�1
Q � a�,�� � �<�[c1�oindexuser_subscriptions_stripeSubscriptionId_keyuser_subscriptions �CREATE UNIQUE INDEX "user_subscriptions_stripeSubscriptionId_key" ON "user_subscriptions"("stripeSubscriptionId")� �ZC1�/indexsubscription_plans_name_keysubscription_plans �CREATE UNIQUE INDEX "subscription_plans_name_key" ON "subscription_plans"("name")� �Y?%�'indexlawyer_stats_lawyerId_keylawyer_stats �CREATE UNIQUE INDEX "lawyer_stats_lawyerId_key" ON "lawyer_stats"("lawyerId")��XK'�Eindexcase_supports_userId_caseId_keycase_supports �CREATE UNIQUE INDEX "case_supports_userId_caseId_key" ON "case_supports"("userId", "caseId")�)�WU/�Yindexlodge_memberships_userId_lodgeId_keylodge_memberships �CREATE UNIQUE INDEX "lodge_memberships_userId_lodgeId_key" ON "lodge_memberships"("userId", "lodgeId")[�V+indexlodges_name_keylodges �CREATE UNIQUE INDEX "lodges_name_key" ON "lodges"("name")�h�Uy;�'indexbrotherhood_mentorships_mentorId_menteeId_degreeId_keybrotherhood_mentorships �CREATE UNIQUE INDEX "brotherhood_mentorships_mentorId_menteeId_degreeId_key" ON "brotherhood_mentorships"("mentorId", "menteeId", "degreeId")� �TQ/�Kindexdegree_ceremonies_userDegreeId_keydegree_ceremonies �CREATE UNIQUE INDEX "degree_ceremonies_userDegreeId_key" ON "degree_ceremonies"("userDegreeId")��SM%�Iindexuser_degrees_userId_degreeId_keyuser_degrees �CREATE UNIQUE INDEX "user_degrees_userId_degreeId_key" ON "user_degrees"("userId", "degreeId") ! Y+��eK;�-index_BusinessProfileMembers_B_index_BusinessProfileMembers �CREATE INDEX "_BusinessProfileMembers_B_index" ON "_BusinessProfileMembers"("B")�$�dO;�Iindex_BusinessProfileMembers_AB_unique_BusinessProfileMembers �CREATE UNIQUE INDEX "_BusinessProfileMembers_AB_unique" ON "_BusinessProfileMembers"("A", "B")t�c;+�
index_UserLegalCases_B_index_UserLegalCases �CREATE INDEX "_UserLegalCases_B_index" ON "_UserLegalCases"("B")��OI3�;indexfinancial_summaries_userId_keyfinancial_summaries �CREATE UNIQUE INDEX "financial_summaries_userId_key" ON "financial_summaries"("userId")��NI7�;indexsociety_pricing_tiers_name_keysociety_pricing_tiers �CREATE UNIQUE INDEX "society_pricing_tiers_name_key" ON "society_pricing_tiers"("name")��b?+�)index_UserLegalCases_AB_unique_UserLegalCases �CREATE UNIQUE INDEX "_UserLegalCases_AB_unique" ON "_UserLegalCases"("A", "B")��a?)�'indexclerk_profiles_userId_keyclerk_profiles �CREATE UNIQUE INDEX "clerk_profiles_userId_key" ON "clerk_profiles"("userId")�-�RY+�aindexsociety_degrees_degreeNumber_track_keysociety_degrees �CREATE UNIQUE INDEX "society_degrees_degreeNumber_track_key" ON "society_degrees"("degreeNumber", "track")�Q�Qo+�indexmentor_sessions_mentorId_menteeId_sessionDate_keymentor_sessions �CREATE UNIQUE INDEX "mentor_sessions_mentorId_menteeId_sessionDate_key" ON "mentor_sessions"("mentorId", "menteeId", "sessionDate")�0�PY1�aindexcourse_enrollments_userId_courseId_keycourse_enrollments �CREATE UNIQUE INDEX "course_enrollments_userId_courseId_key" ON "course_enrollments"("userId", "courseId") �I3�;indexfinancial_summaries_userId_keyfinancial_summaries �CREATE UNIQUE INDEX "financial_summaries_userId_key" ON "financial_summaries"("userId")��`G1�7indexassistant_profiles_userId_keyassistant_profiles �CREATE UNIQUE INDEX "assistant_profiles_userId_key" ON "assistant_profiles"("userId")�\�_oG�
indexcase_competition_participants_lawyerId_caseId_keycase_competition_participants �CREATE UNIQUE INDEX "case_competition_participants_lawyerId_caseId_key" ON "case_competition_participants"("lawyerId", "caseId")��^I)�;indexclient_portals_accessToken_keyclient_portals �CREATE UNIQUE INDEX "client_portals_accessToken_key" ON "client_portals"("accessToken")��]C)�/indexclient_portals_clientId_keyclient_portals �CREATE UNIQUE INDEX "client_portals_clientId_key" ON "client_portals"("clientId")�*�\U1�Yindexuser_subscriptions_userId_planId_keyuser_subscriptions �CREATE UNIQUE INDEX "user_subscriptions_userId_planId_key" ON "user_subscriptions"("userId", "planId")
� ����� LAWYER LAWYER LAWYER !LAWYER LAWYER
� � 6?? cmcpzyavn0002vjz01slrcn51cmcpzyax8000avjz0ao7zkw1g
I ��yYA�! �
�
�
a
) � � � I 7??cmcqfih0g0001vjoolt160supcmcr8nl9a0008vjkckflkcp0t7??cmcqfih0g0001vjoolt160supcmcr8nl8g0007vjkcmzk2w23c7??cmcqfih0g0001vjoolt160supcmcr8nl7u0006vjkctb5suwc77??cmcqfih0g0001vjoolt160supcmcr8nl770005vjkce4bhgbhl7??cmcqfih0g0001vjoolt160supcmcr8nl6h0004vjkcpkv2nqun7??cmcqfih0g0001vjoolt160supcmcr8nl5o0003vjkcxkkdsn5m
7??cmcqfih0g0001vjoolt160supcmcr8nl4v0002vjkcyghd6gpm 7??cmcqfih0g0001vjoolt160supcmcr8nl430001vjkcq8iprukc 7??cmcqfih0g0001vjoolt160supcmcqfhvgx000dvjhc2ls6th02 7??cmcqfih0g0001vjoolt160supcmcqfhu8f0007vjhcove5lw8r7??cmcqfih0g0001vjoolt160supcmcqfhtcq0003vjhcm2e8yg8y7??cmcqfih0g0001vjoolt160supcmcqfhunh0009vjhck1pbja1u7??cmcqfih0g0001vjoolt160supcmcr8nl380000vjkc8wfcezbu
7??cmcqfih0g0001vjoolt160supcmcqfhv2d000bvjhc6q3z2yc07??cmcqfih0g0001vjoolt160supcmcqfhtu60005vjhchckp6tz57??cmcqfih0g0001vjoolt160supcmcqfhsqx0001vjhc8ntsvvrc6?? cmcqfih0g0001vjoolt160supcmcpzyaw30004vjz045cducwi
��/�M��k���{]?! ?cmcr8nl9a0008vjkckflkcp0t ?cmcr8nl8g0007vjkcmzk2w23c ?cmcr8nl7u0006vjkctb5suwc7 ?cmcr8nl770005vjkce4bhgbhl ?cmcr8nl6h0004vjkcpkv2nqun ?cmcr8nl5o0003vjkcxkkdsn5m
?cmcr8nl4v0002vjkcyghd6gpm ?cmcr8nl430001vjkcq8iprukc ?cmcqfhvgx000dvjhc2ls6th02 ?cmcqfhu8f0007vjhcove5lw8r ?cmcqfhtcq0003vjhcm2e8yg8y ?cmcqfhunh0009vjhck1pbja1u ?cmcr8nl380000vjkc8wfcezbu
?cmcqfhv2d000bvjhc6q3z2yc0 ?cmcqfhtu60005vjhchckp6tz5 ?cmcqfhsqx0001vjhc8ntsvvrc ? cmcpzyaw30004vjz045cducwi
� � k
t
7��� � � � V�oiC indexsqlite_autoindex_new_relationship_milestones_1new_relationship_milestones � � F�mY3 indexsqlite_autoindex_client_testimonials_1client_testimonials� �l33�7tableclient_testimonialsclient_testimonialsCREATE TABLE "client_testimonials" (
"id" TEXT NOT NULL PRIMARY KEY,
"clientId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"relationshipId" TEXT NOT NULL,
"caseId" TEXT,
"title" TEXT NOT NULL,
"content" TEXT NOT NULL,
"beforeSituation" TEXT,
"afterSituation" TEXT,
"category" TEXT NOT NULL,
"impactLevel" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
"isFeatured" BOOLEAN NOT NULL DEFAULT false,
"helpfulVotes" INTEGER NOT NULL DEFAULT 0,
"views" INTEGER NOT NULL DEFAULT 0,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "client_testimonials_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_relationshipId_fkey" FOREIGN KEY ("relationshipId") REFERENCES "client_lawyer_relationships" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)>�kQ+ indexsqlite_autoindex_lawyer_requests_1lawyer_requests�R�j++�Ytablelawyer_requestslawyer_requestsCREATE TABLE "lawyer_requests" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"clientId" TEXT NOT NULL,
"message" TEXT,
"proposedRate" REAL,
"estimatedHours" INTEGER,
"reasoning" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "lawyer_requests_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lawyer_requests_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lawyer_requests_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
):�iM' indexsqlite_autoindex_comment_likes_1comment_likes ��s�h''�#tablecomment_likescomment_likes �CREATE TABLE "comment_likes" (
"id" TEXT NOT NULL PRIMARY KEY,
"commentId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "comment_likes_commentId_fkey" FOREIGN KEY ("commentId") REFERENCES "case_comments" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "comment_likes_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
):�gM' indexsqlite_autoindex_case_comments_1case_comments ��T�f''�etablecase_commentscase_comments �CREATE TABLE "case_comments" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"parentId" TEXT,
"content" TEXT NOT NULL,
"likes" INTEGER NOT NULL DEFAULT 0,
"isEdited" BOOLEAN NOT NULL DEFAULT false,
"isDeleted" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "case_comments_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_comments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_comments_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "case_comments" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
�
\
i�@�"OE � � \ � � �e�{11�stablecase_chat_messagescase_chat_messagesCREATE TABLE "case_chat_messages" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"content" TEXT NOT NULL,
"senderId" TEXT NOT NULL,
"senderName" TEXT NOT NULL,
"senderAvatar" TEXT,
"senderRole" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"reactions" JSONB,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "case_chat_messages_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "case_chat_messages_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�Y�ss/�indexcomment_reactions_commentId_userId_reactionType_keycomment_reactionsCREATE UNIQUE INDEX "comment_reactions_commentId_userId_reactionType_key" ON "comment_reactions"("commentId", "userId", "reactionType")�)�q//�tablecomment_reactionscomment_reactions �CREATE TABLE "comment_reactions" (
"id" TEXT NOT NULL PRIMARY KEY,
"commentId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"reactionType" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "comment_reactions_commentId_fkey" FOREIGN KEY ("commentId") REFERENCES "case_comments" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "comment_reactions_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)B�rU/ indexsqlite_autoindex_comment_reactions_1comment_reactions
� � �pQ'�Qindexcomment_likes_commentId_userId_keycomment_likes �CREATE UNIQUE INDEX "comment_likes_commentId_userId_key" ON "comment_likes"("commentId", "userId")N�oa; indexsqlite_autoindex_relationship_milestones_1relationship_milestones ��T�n;;�=tablerelationship_milestonesrelationship_milestones �CREATE TABLE "relationship_milestones" (
"id" TEXT NOT NULL PRIMARY KEY,
"relationshipId" TEXT NOT NULL,
"caseId" TEXT,
"milestoneType" TEXT NOT NULL,
"title" TEXT NOT NULL,
"description" TEXT,
"date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"amount" REAL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,
CONSTRAINT "relationship_milestones_relationshipId_fkey" FOREIGN KEY ("relationshipId") REFERENCES "client_lawyer_relationships" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "relationship_milestones_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)F�mY3 indexsqlite_autoindex_client_testimonials_1client_testimonials��33�7tableclient_testimonialsclient_testimonialsCREATE TABLE "client_testimonials" (
"id" TEXT NOT NULL PRIMARY KEY,
"clientId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"relationshipId" TEXT NOT NULL,
"caseId" TEXT,
"title" TEXT NOT NULL,
"content" TEXT NOT NULL,
"beforeSituation" TEXT,
"afterSituation" TEXT,
"category" TEXT NOT NULL,
"impactLevel" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT false,F�zY3 indexsqlite_autoindex_comment_attachments_1comment_attachments�X�y33�Utablecomment_attachmentscomment_attachmentsCREATE TABLE "comment_attachments" (
"id" TEXT NOT NULL PRIMARY KEY,
"commentId" TEXT NOT NULL,
"name" TEXT NOT NULL,
"url" TEXT NOT NULL,
"type" TEXT NOT NULL,
"size" INTEGER NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "comment_attachments_commentId_fkey" FOREIGN KEY ("commentId") REFERENCES "case_comments" ("id") ON DELETE CASCADE ON UPDATE CASCADE
) Y3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId") �1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username") �+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email") -= indexsqlite_autoindex_users_1users
� ���M/�k��� ?cmd1qai8b0013tpjg0g62emn1k <cmd1qai5h0011tpjg0t2y2m5p ?cmd4s19g60007tpmksngtlrtu ?cmd12pw060001tplkiob6quha ?cmd17xl8m0001tpfo7jbdo1cj ?cmcz4w9ya0039tpfgvc110mmq ?cmd43fq8m000ltp2sz3kzit7a ?cmd17xspi0005tpfo7cjtki26
?cmcyz7jt30001tptwen8gfusq ?cmcrrbike0007vjv46gope27w ? cmcq43w400005vj6g685u1acb
c ��J�
�V
�
c �
� <??cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51like �cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51justice=<??cmd4s11fh0001tpmkk2j621b3cmcpzyavn0002vjz01slrcn51love<??cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51like<??cmcz2afud0017tpfgqilhx2licmcpzyavn0002vjz01slrcn51love � <cmd17z4ic0009tpfov7i9jgr1cmcpzyavn0002vjz01slrcn51wow<??cmczesli70005tp54q9mlxea1cmcpzyavn0002vjz01slrcn51love <??cmcz29wyu0011tpfgrq39r33lcmcpzyavn0002vjz01slrcn51like :cmcz2a56j0015tpfgu6tzhi0lcmcpzyavn0002vjz01slrcn51sa???cmcz2a56j0015tpfgu6tzhi0lcmcpzyavn0002vjz01slrcn51justice
<??cmcyz17800003tpfgesru13r8cmcpzyaw30004vjz045cducwilike<??cmcrrbdui0005vjv4od1cn2stcmcpzyavn0002vjz01slrcn51like;?? cmcq43pk80003vj6g9r7qmtxncmcpzyavn0002vjz01slrcn51love
� � ����X������ D�|W1 indexsqlite_autoindex_case_chat_messages_1case_chat_messages � �r�t�Atableusersusers
CREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"li� �++�stableSearchAnalyticsSearchAnalyticsCREATE TABLE "SearchAnalytics" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"query" TEXT NOT NULL,
"filters" JSONB,
"resultCount" INTEGER NOT NULL DEFAULT 0,
"clickedResult" TEXT,
"searchTime" INTEGER NOT NULL DEFAULT 0,
"userAgent" TEXT,
"ipAddress" TEXT,
"timestamp" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "SearchAnalytics_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)��I!�AindexFriendship_userId_friendId_keyFriendship CREATE UNIQUE INDEX "Friendship_userId_friendId_key" ON "Friendship"("userId", "friendId")3� G! indexsqlite_autoindex_Friendship_1Friendship��!!�}tableFriendshipFriendshipCREATE TABLE "Friendship" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"friendId" TEXT NOT NULL,
"status" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "Friendship_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "Friendship_friendId_fkey" FOREIGN KEY ("friendId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)2�~E indexsqlite_autoindex_documents_1documents�#�} �tabledocumentsdocumentsCREATE TABLE "documents" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"title" TEXT,
"type" TEXT NOT NULL,
"url" TEXT NOT NULL,
"filePath" TEXT,
"fileSize" INTEGER,
"uploadedBy" TEXT,
"caseId" TEXT,
"status" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"public" BOOLEAN NOT NULL DEFAULT false,
"description" TEXT,
CONSTRAINT "documents_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "documents_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "documents_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)D�|W1 indexsqlite_autoindex_case_chat_messages_1case_chat_messages 211�stablecase_chat_messagescase_chat_messagesCREATE TABLE "case_chat_messages" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"content" TEXT NOT NULL,
"senderId" TEXT NOT NULL,
"senderName" TEXT NOT NULL,
"senderAvatar" TEXT,
"senderRole" TEXT NOT NULL,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"reactions" JSONB,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
COg�3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId") �1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username") �+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email") -= indexsqlite_autoindex_users_1users
� � o . w G R� >�Q+ indexsqlite_autoindex_SearchAnalytics_1SearchAnalytics b g�3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId")c�
1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y� +indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")*� = indexsqlite_autoindex_users_1users ��[tableusersusers �CREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"linkedinUrl" TEXT,
"websiteUrl" TEXT,
"availability" TEXT,
"timezone" TEXT,
"pronouns" TEXT,
"isProfilePublic" BOOLEAN NOT NULL DEFAULT false,
"lastActive" DATETIME,
"hourlyRate" R�.�11�tableuser_level_historyuser_level_history#CREATE TABLE "user_level_history" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"oldLevel" INTEGER NOT NULL,
"newLevel" INTEGER NOT NULL,
"earnedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"reason" TEXT,
CONSTRAINT "user_level_history_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�6�a%�qindexendorsements_endorserId_endorsedUserId_keyendorsements"CREATE UNIQUE INDEX "endorsements_endorserId_endorsedUserId_key" ON "endorsements"("endorserId", "endorsedUserId")8�K% indexsqlite_autoindex_endorsements_1endorsements �,�%%�tableendorsementsendorsements!CREATE TABLE "endorsements" (
"id" TEXT NOT NULL PRIMARY KEY,
"endorserId" TEXT NOT NULL,
"endorsedUserId" TEXT NOT NULL,
"category" TEXT,
"message" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "endorsements_endorserId_fkey" FOREIGN KEY ("endorserId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "endorsements_endorsedUserId_fkey" FOREIGN KEY ("endorsedUserId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�3�]+�iindexcomment_reports_commentId_reportedBy_keycomment_reports CREATE UNIQUE INDEX "comment_reports_commentId_reportedBy_key" ON "comment_reports"("commentId", "reportedBy")>�Q+ indexsqlite_autoindex_comment_reports_1comment_reports �L�++�Mtablecomment_reportscomment_reports CREATE TABLE "comment_reports" (
"id" TEXT NOT NULL PRIMARY KEY,
"commentId" TEXT NOT NULL,
"reportedBy" TEXT NOT NULL,
"reason" TEXT NOT NULL,
"description" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"reviewedBy" TEXT,
"reviewedAt" DATETIME,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "comment_reports_commentId_fkey" FOREIGN KEY ("commentId") REFERENCES "case_comments" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "comment_reports_reportedBy_fkey" FOREIGN KEY ("reportedBy") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "comment_reports_reviewedBy_fkey" FOREIGN KEY ("reviewedBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)>�Q+ indexsqlite_autoindex_SearchAnalytics_1SearchAnalytics
# 9
W
&e,��79l
�
�
�
�
� �z�%%%�5tableuser_followsuser_follows �CREATE TABLE "user_follows" (
"id" TEXT NOT NULL PRIMARY KEY,
"followerId" TEXT NOT NULL,
"followingId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "user_follows_followerId_fkey" FOREIGN KEY ("followerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_follows_followingId_fkey" FOREIGN KEY ("followingId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�� K�Eindexreviews_lawyerId_reviewerId_keyreviews,CREATE UNIQUE INDEX "reviews_lawyerId_reviewerId_key" ON "reviews"("lawyerId", "reviewerId")�� %%�stabletestimonialstestimonials*CREATE TABLE "testimonials" (
"id" TEXT NOT NULL PRIMARY KEY,
"authorId" TEXT NOT NULL,
"targetUserId" TEXT NOT NULL,
"content" TEXT NOT NULL,
"rating" INTEGER,
"category" TEXT,
"caseType" TEXT,
"outcome" TEXT,
"helpfulCount" INTEGER NOT NULL DEFAULT 0,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"isPublic" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "testimonials_authorId_fkey" FOREIGN KEY ("authorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "testimonials_targetUserId_fkey" FOREIGN KEY ("targetUserId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)8� K% indexsqlite_autoindex_testimonials_1testimonials+
Y 6� I# indexsqlite_autoindex_forum_posts_1forum_posts(�=�##�?tableforum_postsforum_posts'CREATE TABLE "forum_posts" (
"id" TEXT NOT NULL PRIMARY KEY,
"authorId" TEXT NOT NULL,
"title" TEXT NOT NULL,
"content" TEXT NOT NULL,
"category" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "forum_posts_authorId_fkey" FOREIGN KEY ("authorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
).�A indexsqlite_autoindex_reviews_1reviews&�7��Ctablereviewsreviews%CREATE TABLE "reviews" (
"id" TEXT NOT NULL PRIMARY KEY,
"lawyerId" TEXT NOT NULL,
"reviewerId" TEXT NOT NULL,
"rating" INTEGER NOT NULL,
"comment" TEXT,
"caseType" TEXT,
"outcome" TEXT,
"helpfulCount" INTEGER NOT NULL DEFAULT 0,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "reviews_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "reviews_reviewerId_fkey" FOREIGN KEY ("reviewerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)D�W1 indexsqlite_autoindex_user_level_history_1user_level_history$� b11�tableuser_level_historyuser_level_history#CREATE TABLE "user_level_history" (
"id"�-�'[%�eindexuser_follows_followerId_followingId_keyuser_follows
CREATE UNIQUE INDEX "user_follows_followerId_followingId_key" ON "user_follows"("followerId", "followingId")8�&K% indexsqlite_autoindex_user_follows_1user_follows Y3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId") �1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username") �+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email") -= indexsqlite_autoindex_users_1users. � 8���� �X^?M=# -e�/W%=G )
U++ ? _' cmcpzyawp0008vjz0xl85mu96virginie.dufresne@adwavocats.comVirginie Dufresne-Lemirechangeme123LAWYER������ g�virginiedufresne/images/lawyers/virginie-dufresne-lemire.jpgAvant d’être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s’efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues.Avocate associéeLitige civil, Vulgarisation juridique2014-ADW-003
Barreau du Québec, 2014Ligue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoelle �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Vulgarisation juridique"]["Montréal"]ACTIVE�$`?=!# I� �e; /
U++ ? -Q' +� cmcpzyawf0006vjz02w4s3ilajustin.wee@adwavocats.caJustin Weechangeme123LAWYER������KJ justinwee/images/lawyers/justin-wee.jpgAdmis au Barreau en 2016, Me Wee a d'abord exercé en droit criminel et pénal. Aujourd'hui, sa pratique se concentre sur la défense des victimes d'abus d'autorité, dans des dossiers qui lui ont permis de plaider devant tous les tribunaux du Québec. Il a aussi donné plusieurs conférences traitant de la confidentialité dans le contexte des violences sexuelles. Depuis 2018, il siège au conseil d'administration du CRIPHASE, un organisme qui vient en aide aux hommes victimes d'agressions sexuelles.AssociéDéfense des victimes d'abus d'autorité, Droit criminel et pénal12346Barreau du Québec, Université de MontréalConférencier, CRIPHASEMontréal+1 (514) 555-0102https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui �@������lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12346�� h�VERIFIED_BARREAU["Droit immobilier et commercial"]["Montréal"]ACTIVEAvocat associéDroit criminel, Droit pénal, Violences sexuelles, Abus d'autorité�`?I+# )S�g+y%eG )
U++ ? �' +�5 cmcpzyaw30004vjz045cducwialain.arsenault@adwavocats.comAlain Arsenaultchangeme123LAWYER������KJ alainarsenault/images/lawyers/alain-arsenault.jpgEn 1982, membre de la Ligue des droits et libertés, il a joué un rôle clé dans l'Enquête sur la discrimination raciale dans l'industrie du taxi à Montréal. Il a également milité pour l'abolition du délai de prescription en matière d'agression sexuelle, abrogé en 2019. Depuis, les actions collectives contre les institutions religieuses permettent aux victimes de retrouver leur dignité et de légitimer leur récit.Avocat associéLitige civil, Actions collectives, Violences sexuelles1982-ADW-001*Université de Montréal, Barreau du QuébecLigue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui^@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Actions collectives, Violences sexuelles"]["Montréal"]ACTIVEAvocat associéLitige civil, Actions collectives, Violences sexuelles, Abus policiers et étatiques�m_?3#�! !�3+
++ ? cmcpzyavn0002vjz01slrcn51dannywperez@msn.comDanny Perez$2a$12$2pa02LgDazkUFM3FhK1yIeftivWnvdngUJLV9u4nHITv6vSUUgKKaSUPERADMIN�����B�dannyperez/uploads/profiles/cmcpzyavn0002vjz01slrcn51-1751805498408.jpgRepresentative and initiator of the Bordeaux Prison Case.Case RepresentativePrisoner Rights
MontréalSur rendez-vousAmerica/Torontoil/lui�߾�ylightencmcpzyavb0000vjz0g 7 6 5
1
m����kM/����{]?!
�
�
�
�
1
O ?cmcy0qypj0000tp6029gm0o4m ?cmcy0qypj0001tp60jvd1rf7b ?cmcgx0r7z0000vjcghrbty6il ?cmcr8nl9a0008vjkckflkcp0t ?cmcr8nl8g0007vjkcmzk2w23c ?cmcr8nl7u0006vjkctb5suwc7 ?cmcr8nl770005vjkce4bhgbhl ?cmcr8nl6h0004vjkcpkv2nqun ?cmcr8nl5o0003vjkcxkkdsn5m ?cmcr8nl4v0002vjkcyghd6gpm ?cmcr8nl430001vjkcq8iprukc ?cmcr8nl380000vjkc8wfcezbu
?cmcqixujd0000vjk80kvazthp ?cmcqfhvgx000dvjhc2ls6th02 ?cmcqfhv2d000bvjhc6q3z2yc0
?cmcqfhunh0009vjhck1pbja1u ?cmcqfhu8f0007vjhcove5lw8r ?cmcqfhtu60005vjhchckp6tz5 ?cmcqfhtcq0003vjhcm2e8yg8y ?cmcqfhsqx0001vjhc8ntsvvrc ?cmcpzyawp0008vjz0xl85mu96 ?cmcpzyawf0006vjz02w4s3ila ?cmcpzyaw30004vjz045cducwi ? cmcpzyavn0002vjz01slrcn51
\� �!??Os!cmd17z4ka000btpfooebmgiktcmd17z4ic0009tpfov7i9jgr1vpbi9594wl3d5yqvaugwv07jz.trashed/uploads/comments/vpbi9594wl3d5yqvaugwv07jz.trashedimage/jpeg �%�4\ځ!??Os!cmcz29x0l0013tpfgzk9sm69pcmcz29wyu0011tpfgrq39r33laonkmfq44ahygslhgpv1iqx5o.trashed/uploads/comments/aonkmfq44ahygslhgpv1iqx5o.trashedimage/jpeg �%��l�e�!??Os!cmcz0n2g9000htpfg6cutug4icmcz0n2f0000ftpfglg6hr0shuhc29szr9azz9r0weob5sahkc.trashed/uploads/comments/uhc29szr9azz9r0weob5sahkc.trashedimage/jpeg �%��C(
� ��� ?cmd17z4ka000btpfooebmgikt ?cmcz29x0l0013tpfgzk9sm69p ? cmcz0n2g9000htpfg6cutug4i
) . 0 1 2 3 4 - � 8�&K% indexsqlite_autoindex_user_follows_1user_follows b g�$3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId")c�#1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y�"+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")*�!= indexsqlite_autoindex_users_1users.�s� �Ctableusersusers-CREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"linkedinUrl" TEXT,
"websiteUrl" TEXT,
"availability" TEXT,
"timezone" TEXT,
"pronouns" TEXT,
"isProfilePublic" BOOLEAN NOT NULL DEFAULT false,
"lastActive" DATETIME,
"hourlyRate" REAL,
"proBono" BOOLEAN NOT NULL DEFAULT false,
"boldnessRating" REAL,
"transparencyRating" REAL,
"winRate" REAL,
"totalCases" INTEGER NOT NULL DEFAULT 0,
"wonCases" INTEGER NOT NULL DEFAULT 0,
"lostCases" INTEGER NOT NULL DEFAULT 0,
"averageRating" REAL,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"xpPoints" INTEGER NOT NULL DEFAULT 0,
"level" INTEGER NOT NULL DEFAULT 1,
"currentStreak" INTEGER NOT NULL DEFAULT 0,
"totalBadges" INTEGER NOT NULL DEFAULT 0,
"reviewsWritten" INTEGER NOT NULL DEFAULT 0,
"forumPosts" INTEGER NOT NULL DEFAULT 0,
"helpedOthers" INTEGER NOT NULL DEFAULT 0,
"totalEndorsements" INTEGER NOT NULL DEFAULT 0,
"observationHours" REAL NOT NULL DEFAULT 0,
"reformProposals" INTEGER NOT NULL DEFAULT 0,
"wisdomScore" REAL NOT NULL DEFAULT 0,
"civicEngagement" REAL NOT NULL DEFAULT 0,
"accountBalance" REAL NOT NULL DEFAULT 0.0,
"isPaymentVerified" BOOLEAN NOT NULL DEFAULT false,
"donationTotal" REAL NOT NULL DEFAULT 0.0,
"subscriptionTier" TEXT,
"subscriptionExpiry" DATETIME,
"theme" TEXT NOT NULL DEFAULT 'light',
"gender" TEXT,
"phone" TEXT,
"address" TEXT,
"emergencyContact" TEXT,
"emergencyPhone" TEXT,
"dateOfBirth" DATETIME,
"occupation" TEXT,
"language" TEXT NOT NULL DEFAULT 'en',
"notifications" BOOLEAN NOT NULL DEFAULT true,
"lawFirmId" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"experience" INTEGER,
"rating" REAL,
"barreauId" TEXT,
"barreauVerifiedAt" DATETIME,
"verificationStatus" TEXT NOT NULL DEFAULT 'PENDING',
"specializations" TEXT,
"regions" TEXT,
"acceptsLegalAid" BOOLEAN NOT NULL DEFAULT false,
"barreauStatus" TEXT,
"barreauProfileJson" JSONB,
"position" TEXT,
"practiceAreas" TEXT,
"verifiedBy" TEXT,
"verifiedAt" DATETIME,
"approvedBy" TEXT,
"approvedAt" DATETIME,
"verificationNotes" TEXT,
"showFriends" BOOLEAN NOT NULL DEFAULT true,
"showEmail" BOOLEAN NOT NULL DEFAULT false,
"showPhone" BOOLEAN NOT NULL DEFAULT false,
"showLocation" BOOLEAN NOT NULL DEFAULT false,
"allowMessages" BOOLEAN NOT NULL DEFAULT true,
"showOnlineStatus" BOOLEAN NOT NULL DEFAULT true,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
� |�~
�
{ � x � q
�
o � m�k�g�e�c�a��� �%�&w � ??? K cmcu4l7p80001tpygbd8rsr30cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��;���� �??? cmcu4lcuq0003tpygveyl7n75cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcu4l7p80001tpygbd8rsr30h��0S����| ???? cmcspjq8f0001vjzkmak048jwcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcs8gc7r0005vjhshk226ondk������� �?e# ??? cmcy4g2va0005tphwpo6qk5whcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51ihl�� �����5d" ??? cmcy4enn50003tphw6en8hj4fcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi���1��� � ??? K cmcs8gc7r0005vjhshk226ondcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��������� j?? cmcy4k0610007tphw2mg8pt83cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hh�� �����N� ??? K cmcrrbdui0005vjv4od1cn2stcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��������| ???? cmcrrb3cx0003vjv4os48hmg9cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrrazr90001vjv46lxlj7ndf��l������ ??? K cmcrrazr90001vjv46lxlj7ndcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��Z�����| ???? cmcrqa2yp0015vjy8ck2l12cvcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrq9ynd0013vjy8f8pc2tftd�������� ??? K cmcrq9ynd0013vjy8f8pc2tftcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]�������}| ???? cmcrq0j90000zvjy878aum169cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrq0fyq000xvjy8dkmcj0uug��Gt���t� ??? K cmcrq0fyq000xvjy8dkmcj0uucmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��6����X~ ???? cmcrp0j5q000rvjy8hb0uajh8cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrp0fav000pvjy8rxdoewl3ffg��ޥ����F� ??? K cmcrp0fav000pvjy8rxdoewl3cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��ޒw���8| ???? cmcroyrga000nvjy8sy2jxh98cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcroyp5u000lvjy8xzay82g9f���cz���(� ??? K cmcroyp5u000lvjy8xzay82g9cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���W����| ???? cmcroql65000jvjy82v46zgepcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcroqh4d000hvjy8rsp1sa8uh��ב������ ??? K cmcroqh4d000hvjy8rsp1sa8ucmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���}-����
??? K cmcroceb5000dvjy88lllxe72cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���wq����| ???? cmcrngwx00005vjy81h49payfcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrnepsv0001vjy8c2rl4mtbh�߷
������
??? K cmcrnepsv0001vjy8c2rl4mtbcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]�ߵ} ����� ???? cmcr0vkj20003vjd0wksrqtm8cmcpzyax8000avjz0ao7zkw1gcmcpzyawf0006vjz02w4s3ilacmcr0vdv50001vjd0pe8u53xkrtrii��t������ ??? K cmcr0vdv50001vjd0pe8u53xkcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��s�����n} ???? cmcq4w5bz0005vjjoz1p6spxmcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq4ptga0003vjjo7i3rw5wrhi��@N����9� ??? K cmcq4ptga0003vjjo7i3rw5wrcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��;�[����} ???? cmcq4fd01000bvj6g3inf3b95cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxnhi��4[�����| ???? cmcq4c7lu0009vj6go7mpiwt6cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxnt��2 �����~ ???? cmcq45p9f0007vj6ghupp94urcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq43pk80003vj6g9r7qmtxntss��-{#���o� ??? K cmcq43pk80003vj6g9r7qmtxncmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��,(���C
i T
�
R � J�H�d��k�l
�
y ��<�p
�>�L�g � i }8 ???? cmcz22fz6000ttpfgwdv8m7vxcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz1u06m000ptpfgbqte3ysahi��g�b��g��}7 ???? cmcz1xh03000rtpfgdkh6y2qscmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz1u06m000ptpfgbqte3ysaok��d!S��g�cd6 ??? cmcz1u06m000ptpfgbqte3ysacmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��a�k��g��}5 ???? cmcz1t1q9000ntpfgv3pw1632cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz1s5rq000ltpfgh6hio1g4hd��`���a�d4 ??? cmcz1s5rq000ltpfgh6hio1g4cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��`Y3��a � 3 ????) cmcz14ene000jtpfgx7w8ljkicmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz0n2f0000ftpfglg6hr0shhihihihihihihi��Op(��a�Qd2 ??? cmcz0n2f0000ftpfglg6hr0shcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��C���a�2d1 ??? cmcz0mjkj000dtpfgad63e9rjcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��B����a��d0 ??? cmcz088pl000btpfg1ibabfrkcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��8���8�Wd/ ??? cmcz0808x0009tpfgzy0muw51cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��8_A��8�#d. ??? cmcz07jgs0007tpfg1124z4cxcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��8
K��8 �6- ????� cmcz05spm0003tpu8rhqdixz6cmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwicmcz05soc0001tpu89x3hbiy7Test reply to the above comment - 2025-07-11T15:59:44.788Z��6̚��6̿� , ??? � cmcz05soc0001tpu89x3hbiy7cmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwiTest comment from Alain Arsenault - 2025-07-11T15:59:44.743Z��6�j��6��d$ ??? cmcy4k0610007tphw2mg8pt83cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hh�� �����Ne# ??? cmcy4g2va0005tphwpo6qk5whcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51ihl�� �����5d" ??? cmcy4enn50003tphw6en8hj4fcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi���1��� |! ???? cmcu4lcuq0003tpygveyl7n75cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcu4l7p80001tpygbd8rsr30h��0S����� ??? K cmcu4l7p80001tpygbd8rsr30cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��;����| ???? cmcspjq8f0001vjzkmak048jwcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcs8gc7r0005vjhshk226ondk������ׁ ??? K cmcs8gc7r0005vjhshk226ondcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]���������� ??? K cmcrrbdui0005vjv4od1cn2stcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��������| ???? cmcrrb3cx0003vjv4os48hmg9cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrrazr90001vjv46lxlj7ndf��l������ ??? K cmcrrazr90001vjv46lxlj7ndcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51[This comment has been deleted]��Z�����| ???? cmcrqa2yp0015vjy8ck2l12cvcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcrq9ynd0013vjy8f8pc2tftd��������$+ ????_ cmcyzb6mp0003tp1cw55zhcaecmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwicmcyzb6m60001tp1cajvxcazxThis is a test reply to the test comment.��!Q��!\�#* ??? �
cmcyzb6m60001tp1cajvxcazxcmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwiThis is a comprehensive test comment created by the test script.��!>��!\�$) ????_ cmcyzamqt0003tpmcawcvi4jqcmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwicmcyzamqb0001tpmcb945cs7qThis is a test reply to the test comment.�� ���� �ȁ#( ??? �
cmcyzamqb0001tpmcb945cs7qcmcpzyax8000avjz0ao7zkw1gcmcpzyaw30004vjz045cducwiThis is a comprehensive test comment created by the test script.�� ���� ��h' ??? cmcyz17800003tpfgesru13r8cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51kjgkjg������ ���& ????; cmcy4tc9w0001tp8ogx597dxccmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq45p9f0007vj6ghupp94urTest reply for deletion��od���g�% ????; cmcy4swy00001tpoowc98jtr4cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcq45p9f0007vj6ghupp94urTest reply for deletion��!����]
jv� �
�
'' 8 � j eB ??? cmd4s11fh0001tpmkk2j621b3cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51yoo�9v�m!4eA ??? cmd17z4ic0009tpfov7i9jgr1cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi �4\��m1
�@ ???? cmd17ye9a0007tpfodbxppcjtcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz29jij000xtpfgmqkmaeathihihihi�3�3��g< ??? cmcz29wyu0011tpfgrq39r33lcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hihi��l�&�4 �~> ???? cmcz2afud0017tpfgqilhx2licmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz2a56j0015tpfgu6tzhi0lyes��m\��4�~= ???? cmcz2a56j0015tpfgu6tzhi0lcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz29wyu0011tpfgrq39r33lyes��m&��4�d? ??? cmczesli70005tp54q9mlxea1cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi������3.�s*; ???? cmcz29pgw000ztpfg67xslkvbcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz29jij000xtpfgmqkmaeatokok��l�0�3��d: ??? cmcz29jij000xtpfgmqkmaeatcmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51hi��l� �3���9 ????% cmcz22lf8000vtpfga4e6mq01cmcpzyax8000avjz0ao7zkw1gcmcpzyavn0002vjz01slrcn51cmcz1xh03000rtpfgdkh6y2qshi that work��g����g��
R K~
�
R �.?9 !Y ?? cmd564nc0000dtpbs0fiy9k4zFranglette tv show.txttext/plain/uploads/ilqw1kgf8rhb1w7n6oozkfy3j.txt�o� �o� cmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51�+?3 !Y ?? cmd564gjk000btpbsh1ct9k5lcase management.txttext/plain/uploads/ndwm2hzwu97gogp447f6u4czw.txt�ov��ov�cmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51�J?i !a ?? cmcy5e33j0005tp2gde7qx9el.trashed-1753313340-PXL_20250623_232838206.jpgimage/jpeg/uploads/dftonkhlax4bhpasl5flqaemb.trashed��"4*��"4*cmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51�J?i !a ?? cmcy1zp2i0005tpf04o4f7ie5.trashed-1753308898-PXL_20250623_221301656.jpgimage/jpeg/uploads/d5wzdwlqtlhs05s6druhmz94o.trashed��������cmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51�2?A !Y ?? cmcy1rs790003tpf08z714h41PXL_20250623_233013882.jpgimage/jpeg/uploads/z6xufxgjupv2lrw98j9z9ohfa.jpg���p����p�cmcqjb6o80009vjfk3wo56kx0cmcpzyavn0002vjz01slrcn51
k ����k ?cmd564nc0000dtpbs0fiy9k4z ?cmd564gjk000btpbsh1ct9k5l ?cmcy5e33j0005tp2gde7qx9el ?cmcy1zp2i0005tpf04o4f7ie5 ? cmcy1rs790003tpf08z714h41
� � �
� ������� �|
??�A �- cmd55z4qw0009tpbsjicenxv3cmcpzyavn0002vjz01slrcn51bor{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1�k�ǂ
??�A?�- cmd55y8u80007tpbssifn04z1cmcpzyavn0002vjz01slrcn51bor{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}cmcpzyax8000avjz0ao7zkw1gMozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1�k
>�|
??�A �- cmd55y4d50005tpbsnecds5hwcmcpzyavn0002vjz01slrcn51bor{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1�j�{
??�A �- cmd55y3e20003tpbsc6au1iz2cmcpzyavn0002vjz01slrcn51br{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1�j
??�A �- cmd55y1bk0001tpbshk5vlhutcmcpzyavn0002vjz01slrcn51brdeaux{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1�j�+�
??�A?�- cmd43wov80013tp2s1nz0owtzcmcpzyavn0002vjz01slrcn51bo{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"} cmcpzyavn0002vjz01slrcn51Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ��{
??�A �- cmd43wg0o0011tp2stfmormbqcmcpzyavn0002vjz01slrcn51bo{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"} Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ���
??!�A �- cmd43we4w000ztp2sgdexjtukcmcpzyavn0002vjz01slrcn51type:cases{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� �ҏ�
??!�A �- cmd43we3x000xtp2se0730wwrcmcpzyavn0002vjz01slrcn51type:cases{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ��l�
??�A?�- cmd43w6pl000vtp2sdmdtx086cmcpzyavn0002vjz01slrcn51bor{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}cmcpzyax8000avjz0ao7zkw1gMozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ����|
??�A �- cmd43w334000ttp2svbnutxf7cmcpzyavn0002vjz01slrcn51bor{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"}Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ����{
??�A �- cmd43w2o3000rtp2sidbuzat8cmcpzyavn0002vjz01slrcn51bo{"type":"all","category":"all","jurisdiction":"all","verified":"all","sortBy":"relevance"} Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0127.0.0.1� ���
� ����kM/���� ?cmd55z4qw0009tpbsjicenxv3 ?cmd55y8u80007tpbssifn04z1 ?cmd55y4d50005tpbsnecds5hw
?cmd55y3e20003tpbsc6au1iz2 ?cmd55y1bk0001tpbshk5vlhut ?cmd43wov80013tp2s1nz0owtz ?cmd43wg0o0011tp2stfmormbq ?cmd43we4w000ztp2sgdexjtuk ?cmd43we3x000xtp2se0730wwr ?cmd43w6pl000vtp2sdmdtx086 ?cmd43w334000ttp2svbnutxf7 ? cmd43w2o3000rtp2sidbuzat8
� �� �
� � �X^?M=# -e�/W%=G )
U++ ? _' cmcpzyawp0008vjz0xl85mu96virginie.dufresne@adwavocats.comVirginie Dufresne-Lemirechangeme123LAWYER������ g�virginiedufresne/images/lawyers/virginie-dufresne-lemire.jpgAvant d’être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s’efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues.Avocate associéeLitige civil, Vulgarisation juridique2014-ADW-003
Barreau du Québec, 2014Ligue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoelle �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Vulgarisation juridique"]["Montréal"]ACTIVE�$`?=!# I� �e; /
U++ ? -Q' +� cmcpzyawf0006vjz02w4s3ilajustin.wee@adwavocats.caJustin Weechangeme123LAWYER������KJ justinwee/images/lawyers/justin-wee.jpgAdmis au Barreau en 2016, Me Wee a d'abord exercé en droit criminel et pénal. Aujourd'hui, sa pratique se concentre sur la défense des victimes d'abus d'autorité, dans des dossiers qui lui ont permis de plaider devant tous les tribunaux du Québec. Il a aussi donné plusieurs conférences traitant de la confidentialité dans le contexte des violences sexuelles. Depuis 2018, il siège au conseil d'administration du CRIPHASE, un organisme qui vient en aide aux hommes victimes d'agressions sexuelles.AssociéDéfense des victimes d'abus d'autorité, Droit criminel et pénal12346Barreau du Québec, Université de MontréalConférencier, CRIPHASEMontréal+1 (514) 555-0102https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui �@������lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12346�� h�VERIFIED_BARREAU["Droit immobilier et commercial"]["Montréal"]ACTIVEAvocat associéDroit criminel, Droit pénal, Violences sexuelles, Abus d'autorité�`?I+# )S�g+y%eG )
U++ ? �' +�5 cmcpzyaw30004vjz045cducwialain.arsenault@adwavocats.comAlain Arsenaultchangeme123LAWYER������KJ alainarsenault/images/lawyers/alain-arsenault.jpgEn 1982, membre de la Ligue des droits et libertés, il a joué un rôle clé dans l'Enquête sur la discrimination raciale dans l'industrie du taxi à Montréal. Il a également milité pour l'abolition du délai de prescription en matière d'agression sexuelle, abrogé en 2019. Depuis, les actions collectives contre les institutions religieuses permettent aux victimes de retrouver leur dignité et de légitimer leur récit.Avocat associéLitige civil, Actions collectives, Violences sexuelles1982-ADW-001*Université de Montréal, Barreau du QuébecLigue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui^@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Actions collectives, Violences sexuelles"]["Montréal"]ACTIVEAvocat associéLitige civil, Actions collectives, Violences sexuelles, Abus policiers et étatiques�m_?3#�! !�3+
++ ? cmcpzyavn0002vjz01slrcn51dannywperez@msn.comDanny Perez$2a$12$KdNTlvviYC6WHHow3MK2eet2xHeHMEKmsl.HvAL/.4JYFxdbxK9EmSUPERADMIN�������dannyperez/uploads/profiles/cmcpzyavn0002vjz01slrcn51-1751805498408.jpgRepresentative and initiator of the Bordeaux Prison Case.Case RepresentativePrisoner Rights
MontréalSur rendez-vousAmerica/Torontoil/lui�߾�ylightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING
! ! ! ! � 2� E indexsqlite_autoindex_new_users_1new_users�K�
�ctablenew_usersnew_users �CREATE TABLE "new_users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"linkedinUrl" TEXT,
"websiteUrl" TEXT,
"availability" TEXT,
"timezone" TEXT,
"pronouns" TEXT,
"isProfilePublic" BOOLEAN NOT NULL DEFAULT false,
"lastActive" DATETIME,
"hourlyRate" REAL,
"proBono" BOOLEAN NOT NULL DEFAULT false,
"boldnessRating" REAL,
"transparencyRating" REAL,
"winRate" REAL,
"totalCases" INTEGER NOT NULL DEFAULT 0,
"wonCases" INTEGER NOT NULL DEFAULT 0,
"lostCases" INTEGER NOT NULL DEFAULT 0,
"averageRating" REAL,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"xpPoints" INTEGER NOT NULL DEFAULT 0,
"level" INTEGER NOT NULL DEFAULT 1,
"currentStreak" INTEGER NOT NULL DEFAULT 0,
"totalBadges" INTEGER NOT NULL DEFAULT 0,
"reviewsWritten" INTEGER NOT NULL DEFAULT 0,
"forumPosts" INTEGER NOT NULL DEFAULT 0,
"helpedOthers" INTEGER NOT NULL DEFAULT 0,
"observationHours" REAL NOT NULL DEFAULT 0,
"reformProposals" INTEGER NOT NULL DEFAULT 0,
"wisdomScore" REAL NOT NULL DEFAULT 0,
"civicEngagement" REAL NOT NULL DEFAULT 0,
"accountBalance" REAL NOT NULL DEFAULT 0.0,
"isPaymentVerified" BOOLEAN NOT NULL DEFAULT false,
"donationTotal" REAL NOT NULL DEFAULT 0.0,
"subscriptionTier" TEXT,
"subscriptionExpiry" DATETIME,
"theme" TEXT NOT NULL DEFAULT 'light',
"gender" TEXT,
"phone" TEXT,
"address" TEXT,
"emergencyContact" TEXT,
"emergencyPhone" TEXT,
"dateOfBirth" DATETIME,
"occupation" TEXT,
"language" TEXT NOT NULL DEFAULT 'en',
"notifications" BOOLEAN NOT NULL DEFAULT true,
"lawFirmId" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"experience" INTEGER,
"rating" REAL,
"barreauId" TEXT,
"barreauVerifiedAt" DATETIME,
"verificationStatus" TEXT NOT NULL DEFAULT 'PENDING',
"specializations" TEXT,
"regions" TEXT,
"acceptsLegalAid" BOOLEAN NOT NULL DEFAULT false,
"barreauStatus" TEXT,
"barreauProfileJson" JSONB,
"position" TEXT,
"practiceAreas" TEXT,
"verifiedBy" TEXT,
"verifiedAt" DATETIME,
"approvedBy" TEXT,
"approvedAt" DATETIME,
"verificationNotes" TEXT,
"showFriends" BOOLEAN NOT NULL DEFAULT true,
"showEmail" BOOLEAN NOT NULL DEFAULT false,
"showPhone" BOOLEAN NOT NULL DEFAULT false,
"showLocation" BOOLEAN NOT NULL DEFAULT false,
"allowMessages" BOOLEAN NOT NULL DEFAULT true,
"showOnlineStatus" BOOLEAN NOT NULL DEFAULT true,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
� �w� � n � 2�)E indexsqlite_autoindex_new_users_1new_users �-�'[%�eindexuser_follows_followerId_followingId_keyuser_follows
CREATE UNIQUE INDEX "user_follows_followerId_followingId_key" ON "user_follows"("followerId", "followingId")8�&K% indexsqlite_autoindex_user_follows_1user_follows�z�%%%�5tableuser_followsuser_follows �CREATE TABLE "user_follows" (
"id" TEXT NOT NULL PRIMARY KEY,
"followerId" TEXT NOT NULL,
"followingId" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "user_follows_followerId_fkey" FOREIGN KEY ("followerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_follows_followingId_fkey" FOREIGN KEY ("followingId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)g�$3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId")c�#1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y�"+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")*�!= indexsqlite_autoindex_users_1users.
� 4���� �W]?M=# -e�/W%=G )
U++ ? _' cmcpzyawp0008vjz0xl85mu96virginie.dufresne@adwavocats.comVirginie Dufresne-Lemirechangeme123LAWYER������ g�virginiedufresne/images/lawyers/virginie-dufresne-lemire.jpgAvant d’être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s’efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues.Avocate associéeLitige civil, Vulgarisation juridique2014-ADW-003
Barreau du Québec, 2014Ligue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoelle �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Vulgarisation juridique"]["Montréal"]ACTIVE�#_?=!# I� �e; /
U++ ? -Q' +� cmcpzyawf0006vjz02w4s3ilajustin.wee@adwavocats.caJustin Weechangeme123LAWYER������KJ justinwee/images/lawyers/justin-wee.jpgAdmis au Barreau en 2016, Me Wee a d'abord exercé en droit criminel et pénal. Aujourd'hui, sa pratique se concentre sur la défense des victimes d'abus d'autorité, dans des dossiers qui lui ont permis de plaider devant tous les tribunaux du Québec. Il a aussi donné plusieurs conférences traitant de la confidentialité dans le contexte des violences sexuelles. Depuis 2018, il siège au conseil d'administration du CRIPHASE, un organisme qui vient en aide aux hommes victimes d'agressions sexuelles.AssociéDéfense des victimes d'abus d'autorité, Droit criminel et pénal12346Barreau du Québec, Université de MontréalConférencier, CRIPHASEMontréal+1 (514) 555-0102https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui �@������lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12346�� h�VERIFIED_BARREAU["Droit immobilier et commercial"]["Montréal"]ACTIVEAvocat associéDroit criminel, Droit pénal, Violences sexuelles, Abus d'autorité�_?I+# )S�g+y%eG )
U++ ? �' +�5 cmcpzyaw30004vjz045cducwialain.arsenault@adwavocats.comAlain Arsenaultchangeme123LAWYER������KJ alainarsenault/images/lawyers/alain-arsenault.jpgEn 1982, membre de la Ligue des droits et libertés, il a joué un rôle clé dans l'Enquête sur la discrimination raciale dans l'industrie du taxi à Montréal. Il a également milité pour l'abolition du délai de prescription en matière d'agression sexuelle, abrogé en 2019. Depuis, les actions collectives contre les institutions religieuses permettent aux victimes de retrouver leur dignité et de légitimer leur récit.Avocat associéLitige civil, Actions collectives, Violences sexuelles1982-ADW-001*Université de Montréal, Barreau du QuébecLigue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui^@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Actions collectives, Violences sexuelles"]["Montréal"]ACTIVEAvocat associéLitige civil, Actions collectives, Violences sexuelles, Abus policiers et étatiques�l^?3#�! !�3+
++ ? cmcpzyavn0002vjz01slrcn51dannywperez@msn.comDanny Perez$2a$12$2pa02LgDazkUFM3FhK1yIeftivWnvdngUJLV9u4nHITv6vSUUgKKaSUPERADMIN�����B�dannyperez/uploads/profiles/cmcpzyavn0002vjz01slrcn51-1751805498408.jpgRepresentative and initiator of the Bordeaux Prison Case.Case RepresentativePrisoner Rights
MontréalSur rendez-vousAmerica/Torontoil/lui�߾�ylightencmcpzyavb0000vjz0g 3 2 1
0
1
m����kM/����{]?!
�
�
�
�
1
O ?cmcy0qypj0000tp6029gm0o4m ?cmcy0qypj0001tp60jvd1rf7b ?cmcgx0r7z0000vjcghrbty6il ?cmcr8nl9a0008vjkckflkcp0t ?cmcr8nl8g0007vjkcmzk2w23c ?cmcr8nl7u0006vjkctb5suwc7 ?cmcr8nl770005vjkce4bhgbhl ?cmcr8nl6h0004vjkcpkv2nqun ?cmcr8nl5o0003vjkcxkkdsn5m ?cmcr8nl4v0002vjkcyghd6gpm ?cmcr8nl430001vjkcq8iprukc ?cmcr8nl380000vjkc8wfcezbu
?cmcqixujd0000vjk80kvazthp ?cmcqfhvgx000dvjhc2ls6th02 ?cmcqfhv2d000bvjhc6q3z2yc0
?cmcqfhunh0009vjhck1pbja1u ?cmcqfhu8f0007vjhcove5lw8r ?cmcqfhtu60005vjhchckp6tz5 ?cmcqfhtcq0003vjhcm2e8yg8y ?cmcqfhsqx0001vjhc8ntsvvrc ?cmcpzyawp0008vjz0xl85mu96 ?cmcpzyawf0006vjz02w4s3ila ?cmcpzyaw30004vjz045cducwi ? cmcpzyavn0002vjz01slrcn51
� ��Q�� g�,3�indexusers_barreauId_keyusers �CREATE UNIQUE INDEX "users_barreauId_key" ON "users"("barreauId")c�+1� indexusers_username_keyusersCREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y�*+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")*�)= indexsqlite_autoindex_users_1users�"�(�!tableusersusers
CREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'USER',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"resetPasswordToken" TEXT,
"resetPasswordTokenExpiry" DATETIME,
"reminders" TEXT,
"username" TEXT,
"profilePicture" TEXT,
"bio" TEXT,
"title" TEXT,
"specialization" TEXT,
"barNumber" TEXT,
"yearsOfExperience" INTEGER,
"education" TEXT,
"certifications" TEXT,
"officeLocation" TEXT,
"workPhone" TEXT,
"linkedinUrl" TEXT,
"websiteUrl" TEXT,
"availability" TEXT,
"timezone" TEXT,
"pronouns" TEXT,
"isProfilePublic" BOOLEAN NOT NULL DEFAULT false,
"lastActive" DATETIME,
"hourlyRate" REAL,
"proBono" BOOLEAN NOT NULL DEFAULT false,
"boldnessRating" REAL,
"transparencyRating" REAL,
"winRate" REAL,
"totalCases" INTEGER NOT NULL DEFAULT 0,
"wonCases" INTEGER NOT NULL DEFAULT 0,
"lostCases" INTEGER NOT NULL DEFAULT 0,
"averageRating" REAL,
"isVerified" BOOLEAN NOT NULL DEFAULT false,
"xpPoints" INTEGER NOT NULL DEFAULT 0,
"level" INTEGER NOT NULL DEFAULT 1,
"currentStreak" INTEGER NOT NULL DEFAULT 0,
"totalBadges" INTEGER NOT NULL DEFAULT 0,
"reviewsWritten" INTEGER NOT NULL DEFAULT 0,
"forumPosts" INTEGER NOT NULL DEFAULT 0,
"helpedOthers" INTEGER NOT NULL DEFAULT 0,
"totalEndorsements" INTEGER NOT NULL DEFAULT 0,
"profileViews" INTEGER NOT NULL DEFAULT 0,
"observationHours" REAL NOT NULL DEFAULT 0,
"reformProposals" INTEGER NOT NULL DEFAULT 0,
"wisdomScore" REAL NOT NULL DEFAULT 0,
"civicEngagement" REAL NOT NULL DEFAULT 0,
"accountBalance" REAL NOT NULL DEFAULT 0.0,
"isPaymentVerified" BOOLEAN NOT NULL DEFAULT false,
"donationTotal" REAL NOT NULL DEFAULT 0.0,
"subscriptionTier" TEXT,
"subscriptionExpiry" DATETIME,
"theme" TEXT NOT NULL DEFAULT 'light',
"gender" TEXT,
"phone" TEXT,
"address" TEXT,
"emergencyContact" TEXT,
"emergencyPhone" TEXT,
"dateOfBirth" DATETIME,
"occupation" TEXT,
"language" TEXT NOT NULL DEFAULT 'en',
"notifications" BOOLEAN NOT NULL DEFAULT true,
"lawFirmId" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"status" TEXT NOT NULL DEFAULT 'ACTIVE',
"experience" INTEGER,
"rating" REAL,
"barreauId" TEXT,
"barreauVerifiedAt" DATETIME,
"verificationStatus" TEXT NOT NULL DEFAULT 'PENDING',
"specializations" TEXT,
"regions" TEXT,
"acceptsLegalAid" BOOLEAN NOT NULL DEFAULT false,
"barreauStatus" TEXT,
"barreauProfileJson" JSONB,
"position" TEXT,
"practiceAreas" TEXT,
"verifiedBy" TEXT,
"verifiedAt" DATETIME,
"approvedBy" TEXT,
"approvedAt" DATETIME,
"verificationNotes" TEXT,
"showFriends" BOOLEAN NOT NULL DEFAULT true,
"showEmail" BOOLEAN NOT NULL DEFAULT false,
"showPhone" BOOLEAN NOT NULL DEFAULT false,
"showLocation" BOOLEAN NOT NULL DEFAULT false,
"allowMessages" BOOLEAN NOT NULL DEFAULT true,
"showOnlineStatus" BOOLEAN NOT NULL DEFAULT true,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
� �� � �W]?M=# -e�/W%=G )
U++ ? _' cmcpzyawp0008vjz0xl85mu96virginie.dufresne@adwavocats.comVirginie Dufresne-Lemirechangeme123LAWYER������ g�virginiedufresne/images/lawyers/virginie-dufresne-lemire.jpgAvant d’être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s’efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues.Avocate associéeLitige civil, Vulgarisation juridique2014-ADW-003
Barreau du Québec, 2014Ligue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoelle �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Vulgarisation juridique"]["Montréal"]ACTIVE�#_?=!# I� �e; /
U++ ? -Q' +� cmcpzyawf0006vjz02w4s3ilajustin.wee@adwavocats.caJustin Weechangeme123LAWYER������KJ justinwee/images/lawyers/justin-wee.jpgAdmis au Barreau en 2016, Me Wee a d'abord exercé en droit criminel et pénal. Aujourd'hui, sa pratique se concentre sur la défense des victimes d'abus d'autorité, dans des dossiers qui lui ont permis de plaider devant tous les tribunaux du Québec. Il a aussi donné plusieurs conférences traitant de la confidentialité dans le contexte des violences sexuelles. Depuis 2018, il siège au conseil d'administration du CRIPHASE, un organisme qui vient en aide aux hommes victimes d'agressions sexuelles.AssociéDéfense des victimes d'abus d'autorité, Droit criminel et pénal12346Barreau du Québec, Université de MontréalConférencier, CRIPHASEMontréal+1 (514) 555-0102https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui �@������lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12346�� h�VERIFIED_BARREAU["Droit immobilier et commercial"]["Montréal"]ACTIVEAvocat associéDroit criminel, Droit pénal, Violences sexuelles, Abus d'autorité�_?I+# )S�g+y%eG )
U++ ? �' +�5 cmcpzyaw30004vjz045cducwialain.arsenault@adwavocats.comAlain Arsenaultchangeme123LAWYER������KJ alainarsenault/images/lawyers/alain-arsenault.jpgEn 1982, membre de la Ligue des droits et libertés, il a joué un rôle clé dans l'Enquête sur la discrimination raciale dans l'industrie du taxi à Montréal. Il a également milité pour l'abolition du délai de prescription en matière d'agression sexuelle, abrogé en 2019. Depuis, les actions collectives contre les institutions religieuses permettent aux victimes de retrouver leur dignité et de légitimer leur récit.Avocat associéLitige civil, Actions collectives, Violences sexuelles1982-ADW-001*Université de Montréal, Barreau du QuébecLigue des droits et libertésMontréal(514) 527-8903https://www.adwavocats.com/a-propos/Sur rendez-vousAmerica/Torontoil/lui^@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEVERIFIED["Litige civil, Actions collectives, Violences sexuelles"]["Montréal"]ACTIVEAvocat associéLitige civil, Actions collectives, Violences sexuelles, Abus policiers et étatiques�l^?3#�! !�3+
++ ? cmcpzyavn0002vjz01slrcn51dannywperez@msn.comDanny Perez$2a$12$2pa02LgDazkUFM3FhK1yIeftivWnvdngUJLV9u4nHITv6vSUUgKKaSUPERADMIN�����B�dannyperez/uploads/profiles/cmcpzyavn0002vjz01slrcn51-1751805498408.jpgRepresentative and initiator of the Bordeaux Prison Case.Case RepresentativePrisoner Rights
MontréalSur rendez-vousAmerica/Torontoil/lui�߾�ylightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING
� ���� �,
]?M1� 1Y)M) / ? -U' = cmcqfhv2d000bvjhc6q3z2yc0isabella.rodriguez@adwavocats.caIsabella Rodriguez$2a$12$MW./sm/fVFHcVmu3zg.KLuRUhIvbObm6XfRoBlZBAC7qLgnP7jP0aLAWYER��P���F�isabella.rodriguez/images/lawyers/isabella-rodriguez.jpgÀ compléter.AvocateDroit immobilier et construction12351À compléter.Montréal+1 (514) 555-0107lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12351�� iEVERIFIED_BARREAU["Droit immobilier et construction"]["Montréal"]ACTIVEAvocateDroit de la construction�& ]?O5� 5[)A) / ? -I' A cmcqfhunh0009vjhck1pbja1umarc-andre.bouchard@adwavocats.caMarc-André Bouchard$2a$12$QUYlnE4MmsOLTNjLbjPaJepSznY1RkmibezcFx5Eng8hpHGgVDAv2LAWYER��P k��F�marc-andré.bouchard/images/lawyers/marc-andre-bouchard.jpgÀ compléter.AvocatDroit commercial et fiscal12350À compléter.Montréal+1 (514) 555-0106lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12350�� iVERIFIED_BARREAU["Droit commercial et fiscal"]["Montréal"]ACTIVEAvocatDroit commercial et fiscal�]?C'� 'O)A) / ? -I' A cmcqfhu8f0007vjhcove5lw8rsophie.dubois@adwavocats.caSophie Dubois$2a$12$jCW2Rruljcnf99HWTtxQz.2ls5AKb4Q2PcPAYJ1Z2nF8czA/WCLTeLAWYER��P
N��F�sophie.dubois/images/lawyers/sophie-dubois.jpgÀ compléter.AvocateDroit civil et successions12349À compléter.Montréal+1 (514) 555-0105lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12349�� h�VERIFIED_BARREAU["Droit civil et successions"]["Montréal"]ACTIVEAvocateDroit civil et successions�b]?=!� !I)-) / ? -5' - cmcqfhtu60005vjhchckp6tz5david.chen@adwavocats.caDavid Chen$2a$12$y3ZgOTppvEBq9ZB0rhwxNeWWaqM5E.FLnGcumvvYjj6OABSX318TuLAWYER��PL��F�david.chen/images/lawyers/david-chen.jpgÀ compléter.AvocatDroit du travail12348À compléter.Montréal+1 (514) 555-0104lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12348�� h�VERIFIED_BARREAU["Droit du travail"]["Montréal"]ACTIVEAvocatDroit du travail�]?S7� 7_)3) / ? -;' 3 cmcqfhtcq0003vjhcm2e8yg8ymarie-claude.tremblay@adwavocats.caMarie-Claude Tremblay$2a$12$OvCC8jF37mdCX4XY4sYaC.HFRx6xd8bt9ms20xxAiR2VDoG4MM8caLAWYER��P���F~marie-claude.tremblay/images/lawyers/marie-claude-tremblay.jpgÀ compléter.AvocateDroit de la famille12347À compléter.Montréal+1 (514) 555-0103lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12347�� h�VERIFIED_BARREAU["Droit de la famille"]["Montréal"]ACTIVEAvocateDroit de la famille�y^?I-� -U�5? Y / ? -G' M cmcqfhsqx0001vjhc8ntsvvrcaudrey.labrecque@adwavocats.caAudrey Labrecque$2a$12$QUhzG8q7.RApRBtzs0XsDuy8dbwlmSJvk3TlPWQqO55v3XerFpBa.LAWYER��P���KJ$audrey.labrecque/images/lawyers/audrey-labrecque.jpgMe Labrecque a été admise au Barreau en 2023. Elle a rejoint notre équipe en tant qu'étudiante en droit avant d'effectuer son stage en tant qu'auxiliaire juridique auprès d'un juge de la Cour fédérale en 2023. Avant d'entamer ses études en droit, elle a obtenu un baccalauréat en arts de l'Université McGill, avec une majeure en psychologie et une mineure en études sur le genre, la sexualité, le féminisme et la justice sociale.Associée principaleDroit civil et commercial12345Université McGill, Barreau du QuébecMontréal+1 (514) 555-0101 �@ lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12345�� h�VERIFIED_BARREAU["Droit civil et commercial"]["Montréal"]ACTIVEAvocateDroit civil, Actions collectives
�
�
UmO � �_]?C%5 #M�/ ] ? cmcr8nl5o0003vjkcxkkdsn5mivan.lazarov@adwavocats.comIvan Lazarovtemporarypassword123LAWYER��;^����oivanlazarov/images/lawyers/ivan-lazarov.jpgMembre du Barreau depuis 2017, Me Lazarov a commencé sa pratique en droit de la famille et en protection de la jeunesse. Il a également été enquêteur auprès de l'Ombudsman de l'Ontario. Il se concentre dans les dossiers d'actions collectives au sein de notre cabinet.Actions collectives, Droit de la famille �@fffffflightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�]?aC5 ?k�9 U ? cmcr8nl4v0002vjkcyghd6gpmantoine.duranleau-hendrickx@adwavocats.comAntoine Duranleau-Hendrickxtemporarypassword123LAWYER��;^����Bantoineduranleauhendrickx/images/lawyers/antoine-duranleau-hendrickx.jpgMe Duranleau-Hendrickx a été admis au Barreau en 2021, après avoir complété son stage à la Commission des droits de la personne et des droits de la jeunesse. Il consacre sa pratique aux actions collectives. En dehors de sa pratique, Me Duranleau Hendrickx siège en tant qu'administrateur pour le Service d'aide aux conjoints et est l'un des membres fondateurs de l'organisme Droit animalier Québec.Actions collectives, Droit animalier �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�e]?E+5 %O�% i ? cmcr8nl430001vjkcq8iprukcjerome.aucoin@adwavocats.comJérôme Aucointemporarypassword123LAWYER��;^����
jeromeaucoin/images/lawyers/jerome-aucoin.jpgAvant de devenir avocat en 2023, Me Aucoin a travaillé comme étudiant en droit et stagiaire au cabinet. Il est également titulaire d'un baccalauréat en relations internationales et droit international de l'UQAM et d'une maîtrise en pensée politique à l'université d'Ottawa. Il s'est impliqué bénévolement par le passé comme intervenant en prévention du suicide sur une ligne d'appel.Relations internationales, Droit international �@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�1
]?[=5 9e�} U ? cmcr8nl380000vjkc8wfcezbuvirginie.dufresne-lemire@adwavocats.comVirginie Dufresne-Lemiretemporarypassword123LAWYER��;^�����virginiedufresnelemire/images/lawyers/virginie-dufresne-lemire.jpgAvant d'être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s'efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues. Elle est membre de la Ligue des droits et libertés.Droit civil, Communication juridique
@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�@ \?/!# cmcqixujd0000vjk80kvazthpadmin@example.comAdmin Userpassword123ADMIN�ۨR��ۨR�lightenACTIVEPENDING�1 ]?E)� )Q)W) / ? -_' W cmcqfhvgx000dvjhc2ls6th02thomas.leblanc@adwavocats.caThomas Leblanc$2a$12$zn2kCkC.2khu7XlocDhTUORSf4NrReYZxOyB1wY3eD.K57mha6feSLAWYER��P���F�thomas.leblanc/images/lawyers/thomas-leblanc.jpgÀ compléter.AvocatDroit administratif et réglementaire12352À compléter.Montréal+1 (514) 555-0108lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12352�� ifVERIFIED_BARREAU["Droit administratif et réglementaire"]["Montréal"]ACTIVEAvocatDroit administratif et réglementaire
[ � 9[ �3]?E'5 %O�Q ] ? cmcr8nl8g0007vjkcmzk2w23cjustine.monty@adwavocats.comJustine Montytemporarypassword123LAWYER��;_@��� !justinemonty/images/lawyers/justine-monty.jpgAvocate depuis 2023, Me Monty a d'abord obtenu un baccalauréat en sciences politiques et en études féministes à l'Université McGill. Elle a ensuite poursuivi ses études à l'Université de Montréal, où elle a obtenu un baccalauréat en droit. Elle a rejoint le cabinet pour y effectuer son stage du Barreau et fait partie de notre équipe depuis.Sciences politiques, Études féministes �@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�%]?A#5 !K�G Y ? cmcr8nl7u0006vjkctb5suwc7imane.melab@adwavocats.comImane Melabtemporarypassword123LAWYER��;_+����imanemelab/images/lawyers/imane-melab.jpgAvocate depuis 2021, Me Melab détient un baccalauréat en droit de l'UQAM pendant lequel elle s'est vu décerner la bourse Juanita Westmorland Traoré pour son implication bénévole à des fins de promotion de la justice sociale au bénéfice des populations défavorisées et racisées. En plus des champs de pratique du cabinet, elle a également acquis une solide expérience en droit administratif et de l'emploi ayant travaillé lors de ses études auprès de la CNESST.Droit administratif, Droit de l'emploi �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�]?K-5 +U�c S ? cmcr8nl770005vjkce4bhgbhlolivia.malenfant@adwavocats.comOlivia Malenfanttemporarypassword123LAWYER��;_����oliviamalenfant/images/lawyers/olivia-malenfant.jpgMe Malenfant a rejoint notre cabinet en tant qu'étudiante avant d'y faire son stage. Titulaire d'un baccalauréat en relations internationales et droit international, ainsi que d'un baccalauréat en droit de l'UQAM, elle est membre du Barreau depuis 2023. En plus des champs de pratique du cabinet, Me Malenfant apporte son expertise à des OBNL. En dehors de sa pratique, Me Malenfant a été impliquée à la Clinique internationale de défense des droits humains de l'UQAM et s'investit dans des projets visant la protection des droits de la personne.Droit international, Droits humains �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�>]?S55 1]�1 [ ? cmcr8nl6h0004vjkcpkv2nqunyalda.machouf-khadir@adwavocats.comYalda Machouf Khadirtemporarypassword123LAWYER��;^�����yaldamachoufkhadir/images/lawyers/yalda-machouf-khadir.jpgMe Yalda Machouf-Khadir a entamé son parcours universitaire par un certificat en droit social et du travail à l'UQAM, avant de compléter son baccalauréat en droit. Membre du Barreau depuis 2019, elle a réorienté sa pratique en 2022 pour se concentrer sur les dossiers civils au sein de notre cabinet. En parallèle de sa carrière, Me Machouf-Khadir s'implique activement dans sa communauté iranienne, notamment à travers des projets culturels et politiques.Droit civil, Droit social et du travail �@ lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING
$ � � t$ �M`?A)� )��-)I � %) cmcy0qypj0000tp6029gm0o4mmarie.champion@lawfirm.comMarie Champion$2a$12$/h73tJ6ZidIIeKJ7NKVjp.VL2.aUAoijXKlcBkVE8HWvGvMIm7eoiLAWYER���:6���:6marie-championhttps://images.unsplash.com/photo-1594736797933-d0f06ba29d9e?w=400Passionate human rights lawyer with 15 years of experience fighting for justice.Senior PartnerHuman Rights & Civil LibertiesQC-98765McGill University Law School (LLB), Harvard Law School (LLM)Montreal, QC(514) 555-0001�@333333@������YH@ �lightenACTIVEPENDING�3_?A'� '��/-E W #) cmcy0qypj0001tp60jvd1rf7bdavid.justice@advocates.caDavid Justice$2a$12$rU1UGPwM2g027KN6ZSqfsueyUPd41vaba2cgdnTlG9l4xktDxTgN.LAWYER���:6���:6david-justicehttps://images.unsplash.com/photo-1507003211169-0a1dd7228f2d?w=400Criminal defense attorney specializing in prison rights and detention conditions.Principal LawyerCriminal Law & Prison RightsQC-54321 University of Toronto Law School (JD)Toronto, ON(416) 555-0002|@������@ffffffC3@������blightenACTIVEPENDING� ]?O#�! cmcgx0r7z0000vjcghrbty6ildannywperez+1752157338554@msn.comDanny PEREZ$2a$12$PvnvDt5jA9mP4C.vo7v.duwpDjMZQifsPixM0FRmsTwvDFC4UaJP2SUPERADMIN��;���;�lightenACTIVEVERIFIED�G]?I/5 'S�w K ? cmcr8nl9a0008vjkckflkcp0tmmah.nora.toure@adwavocats.comM'Mah Nora Tourétemporarypassword123LAWYER��;_^��� Ammahnoratoure/images/lawyers/mmah-nora-toure.jpgAvocate depuis 2021, Me Touré est titulaire d'un baccalauréat en droit et poursuit actuellement un programme de Juris Doctor – Common Law nord-américaine. En 2019, elle a effectué un premier stage au sein de l'Association du Barreau Canadien avant de rejoindre notre cabinet pour son stage du Barreau. En dehors de sa pratique, Me Touré s'engage activement au sein de la Ligue des Droits et Libertés et offre ses services en tant qu'avocate bénévole à la Clinique Juridique de Saint-Michel.Common Law, Droits et libertés �@ lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING
� � ��� �-
^?M1� 1Y)M) / ? -U' = cmcqfhv2d000bvjhc6q3z2yc0isabella.rodriguez@adwavocats.caIsabella Rodriguez$2a$12$MW./sm/fVFHcVmu3zg.KLuRUhIvbObm6XfRoBlZBAC7qLgnP7jP0aLAWYER��P���F�isabella.rodriguez/images/lawyers/isabella-rodriguez.jpgÀ compléter.AvocateDroit immobilier et construction12351À compléter.Montréal+1 (514) 555-0107lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12351�� iEVERIFIED_BARREAU["Droit immobilier et construction"]["Montréal"]ACTIVEAvocateDroit de la construction�' ^?O5� 5[)A) / ? -I' A cmcqfhunh0009vjhck1pbja1umarc-andre.bouchard@adwavocats.caMarc-André Bouchard$2a$12$QUYlnE4MmsOLTNjLbjPaJepSznY1RkmibezcFx5Eng8hpHGgVDAv2LAWYER��P k��F�marc-andré.bouchard/images/lawyers/marc-andre-bouchard.jpgÀ compléter.AvocatDroit commercial et fiscal12350À compléter.Montréal+1 (514) 555-0106lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12350�� iVERIFIED_BARREAU["Droit commercial et fiscal"]["Montréal"]ACTIVEAvocatDroit commercial et fiscal�^?C'� 'O)A) / ? -I' A cmcqfhu8f0007vjhcove5lw8rsophie.dubois@adwavocats.caSophie Dubois$2a$12$jCW2Rruljcnf99HWTtxQz.2ls5AKb4Q2PcPAYJ1Z2nF8czA/WCLTeLAWYER��P
N��F�sophie.dubois/images/lawyers/sophie-dubois.jpgÀ compléter.AvocateDroit civil et successions12349À compléter.Montréal+1 (514) 555-0105lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12349�� h�VERIFIED_BARREAU["Droit civil et successions"]["Montréal"]ACTIVEAvocateDroit civil et successions�c^?=!� !I)-) / ? -5' - cmcqfhtu60005vjhchckp6tz5david.chen@adwavocats.caDavid Chen$2a$12$y3ZgOTppvEBq9ZB0rhwxNeWWaqM5E.FLnGcumvvYjj6OABSX318TuLAWYER��PL��F�david.chen/images/lawyers/david-chen.jpgÀ compléter.AvocatDroit du travail12348À compléter.Montréal+1 (514) 555-0104lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12348�� h�VERIFIED_BARREAU["Droit du travail"]["Montréal"]ACTIVEAvocatDroit du travail�^?S7� 7_)3) / ? -;' 3 cmcqfhtcq0003vjhcm2e8yg8ymarie-claude.tremblay@adwavocats.caMarie-Claude Tremblay$2a$12$OvCC8jF37mdCX4XY4sYaC.HFRx6xd8bt9ms20xxAiR2VDoG4MM8caLAWYER��P���F~marie-claude.tremblay/images/lawyers/marie-claude-tremblay.jpgÀ compléter.AvocateDroit de la famille12347À compléter.Montréal+1 (514) 555-0103lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12347�� h�VERIFIED_BARREAU["Droit de la famille"]["Montréal"]ACTIVEAvocateDroit de la famille�z_?I-� -U�5? Y / ? -G' M cmcqfhsqx0001vjhc8ntsvvrcaudrey.labrecque@adwavocats.caAudrey Labrecque$2a$12$QUhzG8q7.RApRBtzs0XsDuy8dbwlmSJvk3TlPWQqO55v3XerFpBa.LAWYER��P���KJ$audrey.labrecque/images/lawyers/audrey-labrecque.jpgMe Labrecque a été admise au Barreau en 2023. Elle a rejoint notre équipe en tant qu'étudiante en droit avant d'effectuer son stage en tant qu'auxiliaire juridique auprès d'un juge de la Cour fédérale en 2023. Avant d'entamer ses études en droit, elle a obtenu un baccalauréat en arts de l'Université McGill, avec une majeure en psychologie et une mineure en études sur le genre, la sexualité, le féminisme et la justice sociale.Associée principaleDroit civil et commercial12345Université McGill, Barreau du QuébecMontréal+1 (514) 555-0101 �@ lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12345�� h�VERIFIED_BARREAU["Droit civil et commercial"]["Montréal"]ACTIVEAvocateDroit civil, Actions collectives
�
�
RiJ � �`^?C%5 #M�/ ] ? cmcr8nl5o0003vjkcxkkdsn5mivan.lazarov@adwavocats.comIvan Lazarovtemporarypassword123LAWYER��;^����oivanlazarov/images/lawyers/ivan-lazarov.jpgMembre du Barreau depuis 2017, Me Lazarov a commencé sa pratique en droit de la famille et en protection de la jeunesse. Il a également été enquêteur auprès de l'Ombudsman de l'Ontario. Il se concentre dans les dossiers d'actions collectives au sein de notre cabinet.Actions collectives, Droit de la famille �@fffffflightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING� ^?aC5 ?k�9 U ? cmcr8nl4v0002vjkcyghd6gpmantoine.duranleau-hendrickx@adwavocats.comAntoine Duranleau-Hendrickxtemporarypassword123LAWYER��;^����Bantoineduranleauhendrickx/images/lawyers/antoine-duranleau-hendrickx.jpgMe Duranleau-Hendrickx a été admis au Barreau en 2021, après avoir complété son stage à la Commission des droits de la personne et des droits de la jeunesse. Il consacre sa pratique aux actions collectives. En dehors de sa pratique, Me Duranleau Hendrickx siège en tant qu'administrateur pour le Service d'aide aux conjoints et est l'un des membres fondateurs de l'organisme Droit animalier Québec.Actions collectives, Droit animalier �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�f^?E+5 %O�% i ? cmcr8nl430001vjkcq8iprukcjerome.aucoin@adwavocats.comJérôme Aucointemporarypassword123LAWYER��;^����
jeromeaucoin/images/lawyers/jerome-aucoin.jpgAvant de devenir avocat en 2023, Me Aucoin a travaillé comme étudiant en droit et stagiaire au cabinet. Il est également titulaire d'un baccalauréat en relations internationales et droit international de l'UQAM et d'une maîtrise en pensée politique à l'université d'Ottawa. Il s'est impliqué bénévolement par le passé comme intervenant en prévention du suicide sur une ligne d'appel.Relations internationales, Droit international �@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�2
^?[=5 9e�} U ? cmcr8nl380000vjkc8wfcezbuvirginie.dufresne-lemire@adwavocats.comVirginie Dufresne-Lemiretemporarypassword123LAWYER��;^�����virginiedufresnelemire/images/lawyers/virginie-dufresne-lemire.jpgAvant d'être admise au Barreau en 2014, elle a obtenu des baccalauréats en communication et en droit. En plus de représenter sa clientèle dans des poursuites civiles et autres recours (enquête du coroner, etc.), elle œuvre activement à la vulgarisation des enjeux juridiques complexes à travers les médias. Elle s'efforce de rendre le système judiciaire plus accessible et compréhensible pour sa clientèle et le grand public, tout en sensibilisant à des problématiques souvent ignorées ou méconnues. Elle est membre de la Ligue des droits et libertés.Droit civil, Communication juridique
@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�A ]?/!# cmcqixujd0000vjk80kvazthpadmin@example.comAdmin Userpassword123ADMIN�ۨR��ۨR�lightenACTIVEPENDING�2 ^?E)� )Q)W) / ? -_' W cmcqfhvgx000dvjhc2ls6th02thomas.leblanc@adwavocats.caThomas Leblanc$2a$12$zn2kCkC.2khu7XlocDhTUORSf4NrReYZxOyB1wY3eD.K57mha6feSLAWYER��P���F�thomas.leblanc/images/lawyers/thomas-leblanc.jpgÀ compléter.AvocatDroit administratif et réglementaire12352À compléter.Montréal+1 (514) 555-0108lightfrcmcpzyavb0000vjz0gwgrte2cACTIVEADW-12352�� ifVERIFIED_BARREAU["Droit administratif et réglementaire"]["Montréal"]ACTIVEAvocatDroit administratif et réglementaire
W � 7W �4^?E'5 %O�Q ] ? cmcr8nl8g0007vjkcmzk2w23cjustine.monty@adwavocats.comJustine Montytemporarypassword123LAWYER��;_@��� !justinemonty/images/lawyers/justine-monty.jpgAvocate depuis 2023, Me Monty a d'abord obtenu un baccalauréat en sciences politiques et en études féministes à l'Université McGill. Elle a ensuite poursuivi ses études à l'Université de Montréal, où elle a obtenu un baccalauréat en droit. Elle a rejoint le cabinet pour y effectuer son stage du Barreau et fait partie de notre équipe depuis.Sciences politiques, Études féministes �@333333lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�&^?A#5 !K�G Y ? cmcr8nl7u0006vjkctb5suwc7imane.melab@adwavocats.comImane Melabtemporarypassword123LAWYER��;_+����imanemelab/images/lawyers/imane-melab.jpgAvocate depuis 2021, Me Melab détient un baccalauréat en droit de l'UQAM pendant lequel elle s'est vu décerner la bourse Juanita Westmorland Traoré pour son implication bénévole à des fins de promotion de la justice sociale au bénéfice des populations défavorisées et racisées. En plus des champs de pratique du cabinet, elle a également acquis une solide expérience en droit administratif et de l'emploi ayant travaillé lors de ses études auprès de la CNESST.Droit administratif, Droit de l'emploi �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�^?K-5 +U�c S ? cmcr8nl770005vjkce4bhgbhlolivia.malenfant@adwavocats.comOlivia Malenfanttemporarypassword123LAWYER��;_����oliviamalenfant/images/lawyers/olivia-malenfant.jpgMe Malenfant a rejoint notre cabinet en tant qu'étudiante avant d'y faire son stage. Titulaire d'un baccalauréat en relations internationales et droit international, ainsi que d'un baccalauréat en droit de l'UQAM, elle est membre du Barreau depuis 2023. En plus des champs de pratique du cabinet, Me Malenfant apporte son expertise à des OBNL. En dehors de sa pratique, Me Malenfant a été impliquée à la Clinique internationale de défense des droits humains de l'UQAM et s'investit dans des projets visant la protection des droits de la personne.Droit international, Droits humains �@������lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING�?^?S55 1]�1 [ ? cmcr8nl6h0004vjkcpkv2nqunyalda.machouf-khadir@adwavocats.comYalda Machouf Khadirtemporarypassword123LAWYER��;^�����yaldamachoufkhadir/images/lawyers/yalda-machouf-khadir.jpgMe Yalda Machouf-Khadir a entamé son parcours universitaire par un certificat en droit social et du travail à l'UQAM, avant de compléter son baccalauréat en droit. Membre du Barreau depuis 2019, elle a réorienté sa pratique en 2022 pour se concentrer sur les dossiers civils au sein de notre cabinet. En parallèle de sa carrière, Me Machouf-Khadir s'implique activement dans sa communauté iranienne, notamment à travers des projets culturels et politiques.Droit civil, Droit social et du travail �@ lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING
� � q �Na?A)� )��-)I � %) cmcy0qypj0000tp6029gm0o4mmarie.champion@lawfirm.comMarie Champion$2a$12$/h73tJ6ZidIIeKJ7NKVjp.VL2.aUAoijXKlcBkVE8HWvGvMIm7eoiLAWYER���:6���:6marie-championhttps://images.unsplash.com/photo-1594736797933-d0f06ba29d9e?w=400Passionate human rights lawyer with 15 years of experience fighting for justice.Senior PartnerHuman Rights & Civil LibertiesQC-98765McGill University Law School (LLB), Harvard Law School (LLM)Montreal, QC(514) 555-0001�@333333@������YH@ �lightenACTIVEPENDING�4`?A'� '��/-E W #) cmcy0qypj0001tp60jvd1rf7bdavid.justice@advocates.caDavid Justice$2a$12$rU1UGPwM2g027KN6ZSqfsueyUPd41vaba2cgdnTlG9l4xktDxTgN.LAWYER���:6���:6david-justicehttps://images.unsplash.com/photo-1507003211169-0a1dd7228f2d?w=400Criminal defense attorney specializing in prison rights and detention conditions.Principal LawyerCriminal Law & Prison RightsQC-54321 University of Toronto Law School (JD)Toronto, ON(416) 555-0002|@������@ffffffC3@������blightenACTIVEPENDING�
^?O#�! cmcgx0r7z0000vjcghrbty6ildannywperez+1752157338554@msn.comDanny PEREZ$2a$12$PvnvDt5jA9mP4C.vo7v.duwpDjMZQifsPixM0FRmsTwvDFC4UaJP2SUPERADMIN��;���;�lightenACTIVEVERIFIED�H^?I/5 'S�w K ? cmcr8nl9a0008vjkckflkcp0tmmah.nora.toure@adwavocats.comM'Mah Nora Tourétemporarypassword123LAWYER��;_^��� Ammahnoratoure/images/lawyers/mmah-nora-toure.jpgAvocate depuis 2021, Me Touré est titulaire d'un baccalauréat en droit et poursuit actuellement un programme de Juris Doctor – Common Law nord-américaine. En 2019, elle a effectué un premier stage au sein de l'Association du Barreau Canadien avant de rejoindre notre cabinet pour son stage du Barreau. En dehors de sa pratique, Me Touré s'engage activement au sein de la Ligue des Droits et Libertés et offre ses services en tant qu'avocate bénévole à la Clinique Juridique de Saint-Michel.Common Law, Droits et libertés �@ lightencmcpzyavb0000vjz0gwgrte2cACTIVEPENDING