 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 @ � � 0 � .zp � ����������������������� 7K% indexsqlite_autoindex_DetaineeInfo_1DetaineeInfo� �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
)-A indexsqlite_autoindex_Address_1Address�.Y/�aindexVerificationToken_identifier_token_keyVerificationTokenCREATE UNIQUE INDEX "VerificationToken_identifier_token_key" ON "VerificationToken"("identifier", "token")�
C/�/indexVerificationToken_token_keyVerificationTokenCREATE UNIQUE INDEX "VerificationToken_token_key" ON "VerificationToken"("token")w
=�#indexSession_sessionToken_keySessionCREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken")U ){indexUser_email_keyUser
CREATE UNIQUE INDEX "User_email_key" ON "User"("email")�s
!!�1tableFileUploadFileUpload CREATE 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
)3 G! indexsqlite_autoindex_FileUpload_1FileUpload �. //� tableVerificationTokenVerificationToken
CREATE TABLE "VerificationToken" (
"identifier" TEXT NOT NULL,
"token" TEXT NOT NULL,
"expires" DATETIME NOT NULL
)�1�9tableSessionSessionCREATE 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 "User" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)-A indexsqlite_autoindex_Session_1Session �(%%�tableRegistrationRegistrationCREATE TABLE "Registration" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT,
"name" TEXT NOT NULL,
"email" TEXT NOT NULL,
"phone" TEXT,
"birthDate" DATETIME,
"relationship" TEXT,
"message" TEXT,
"address" JSONB,
"detaineeInfo" JSONB,
"preferredLanguage" TEXT NOT NULL DEFAULT 'en',
"preferredContactMethod" TEXT NOT NULL DEFAULT 'email',
"additionalContacts" JSONB,
"legalRepresentation" JSONB,
"documents" JSONB,
"uploadedFiles" JSONB,
"status" TEXT NOT NULL DEFAULT 'pending',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "Registration_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)7K% indexsqlite_autoindex_Registration_1Registration�+�9tableUserUserCREATE TABLE "User" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT NOT NULL,
"password" TEXT NOT NULL,
"role" TEXT NOT NULL DEFAULT 'user',
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)'; indexsqlite_autoindex_User_1User�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_st ς" Ȃ �� �� �� ��w ��r ��f ��Y ��P ��B x�< m�1 b�' \� P� B� 8y 3o %c Q C � S�
� � T �
o � 2��-��c�/��<� � U �#
U�
_ 2b31c2d6-f342-452b-a7ec-5bb0c81c6ab031dbc1a13c65ab4c3ed3755c326ebf8f65e807343b14c8031e22b43ee34b0554����20250624232138_add_role_based_permissions�����
U�
O f19c6d0c-41b6-487f-a7fe-f7349a78ba2600ca18c59aa6b69dc4a5acaab5afb0ff88b7238085c5ee4cbe007346a8391d0e����20250624230108_add_username_field�����
U�
Y 9d20b9df-4460-4b25-b616-48f950284bdb4bc2eea2753a75354447d35f68021f2f55cb2361bd533a05adde97b4605b9cf1����20250624222727_add_user_profile_fields���v�)
U�
k 949396cc-73ff-47c4-8833-38c7be3205a7ce3816942c6c99184eba673285e944f29ae93dde8bbe5cc8de248f1db2eff72c���t20250624214758_add_advanced_newsletter_features���U�%
U�
c 9da0f458-e966-4fb8-b37b-052de4f87e87acd1144c47d49c9cfd1f92b6b26d7bde613b3bfbd93132c304c9816fb2e85f78���R20250624214237_add_newsletter_subscriptions�����
U�
Q 655fc11b-3d5b-444d-aee2-fd268d0b6c92e35533fa6b7da10c9884bd07915dde5707ecdc0cced9747db90f4e3e9bff489d����20250622165631_add_direct_messages����
U�
3 87e58126-b72e-4601-a010-59790b8e2ca2115f99ba97753b67caa3bb67c9756514798e548d5acb7e3ec3f3b004a356dc78����20250621184100_init���w�!
U�
[ 0c07f493-3806-4fb7-9dc7-5b2cc1327847033a75dc96b1b03a19f6fb0f37225f57f47f05b1d4e6e3f728c3cc52d81d4fba���u20250621043731_add_direct_message_model���e�
U�
I dab86b20-370d-42aa-83fa-dd549135323690ed2bd905dca043379746beb55a12d83b3c37ea0226a51e60f444c44a925e93���b20250621033857_add_chat_system���E�
U�
Q e62092f2-e306-495b-af7c-fb4d1e107ec1ca0f8914e77f1c6b475b747ebaa46dd009bc7ddf1b14d420ce31aece9723da1a���A20250620032358_remove_status_notes���8�
U�
3 e1540079-fb15-431a-ab05-d52c539c6587b49c37e65426adc5724e99bab53ddcb5f7f23874d0fbfbce7bd3e2042850f55c���520250616230336_init����'
U�
g 26a98149-7df6-47bc-a295-5a7dc80041c3fb6292b5487725b0286d51d95b0136067ad7070328cae59a83ef0af773d792eb����20250615040251_add_messages_and_typing_status����+
U�
o 2b064000-b97b-4919-8089-4460fe3833e95e0b095890b16bc1dbf3d2d1c625dbd471c825871d1abf9af5f6b756bfdeda9b����20250615004455_add_admin_relation_to_status_notes���Ł*
U�
m 17ca3f08-3e60-415c-a31f-4e995eeb56ff41eb5dae876c7510685b8f5ead37699e5323cca5c2c42e2280db96e0ac32f727����20250614194111_add_registration_id_to_statusnote�����
U�
M b37d0463-7c1a-477d-aa18-8b48996fb37fc21c3df255ef65513d48c4bff0a41a95f694dd6d06a94b7129d821f0c46865cf���}20250613074746_fix_schema_issues���G�
U�
S 65123566-471a-4189-8ef7-d2899067091d4817009465719f043f1f63849209a5d4a898bd570e5c4a6363c4f0975a50cd01���D20250613002530_add_additional_notes���6�&
U�
e e95ec2a7-f459-43a0-9b1f-45609e76e0d767c1d304e40b29ebcfd9cfb761039138b383cf76252ba91164eca2c1201faa75���320250613000613_add_registration_extra_fields��� �
U�
M 742a96fd-2412-4217-aa50-6c10440d4aef6d522349f9efa63b2a98cea18f579db48b6329d747b0201d29e90896b9f92d32��� 20250612213418_add_lawyer_fields����
U�
Q fbfc9774-3977-4764-a510-10eee3fb436b7507f8e0fda6804fdebd97cf0e2c8e120953bc7b63d54e36f25e8aab8f2ea8b9���20250611055556_add_reminders_field�����"
U�
] 6a75ff61-ab5b-499d-a3c4-7d13f53015a349f18eb6ca0b94d99447ef0650b19831f15c8ce1b819b23541a74fd03de6a104����20250611042458_add_reset_password_fields����
U�
M c9304b65-0e72-429b-ab2e-33f773e7e35c77dcbe2f47ad88680b592f3503d84b813cd5ba06de6ce8184d19f6de1c54673e����20250610190944_add_theme_profile���ځ
U�
S f7926bd0-6f5f-4b6b-ad27-18ce44bbc652fc4cab989dc81aee963307824a58b87f4a304aae93352055a673ea15fec02230����20250606102655_add_document_cascade���Ł
U�
O a171ae98-d249-4ce2-a43e-d355ebc389b7c30385422b7b1286f22203641c22f339797d01e50bb2f774e314c2953cb93fda����20250603000628_add_document_table�����
U�
K 16c7c1ad-2f06-4864-bf83-7fd3e6a03c40bf7d7e28b64b1366ac97678b667fc7642bbc0b8a896af9f6f2a9330185b8c2cf����20250602224217_add_gender_field�����
U�
3 6e9af260-7758-4e24-8a33-eaf39a7e3db66d54e4a7969ab4883ea8797f36b74af4c61ec8d1aef5711fc80ad0fcdf76e42d����20250601222438_init R
$
=
� 3
�
�
� �g � �� � {
� R �
f�
=> � \4
H �
�
q� )]�
� (Ua21c2ead-462d-4d12-8002-b861190c7f34$(Ua0246d3d-7b5c-411b-afc4-5b9cd207f00a#(Uffa21822-0581-4dc6-b92c-66bd6d8c9e40"(U9bbcce58-010a-48a9-b2cc-eacf9bb9393c!(U4865b953-acaf-4611-9b5f-5eef99f5dbb1 (U2aa9f150-1d50-4a24-80e5-7c375a8f4a61 (U17080b55-da14-4b47-b6d3-320168577e05 (Ubb539f16-b84b-4236-9302-eead3a446b09 (U64577483-32f4-408a-8530-479c78225fab (Udce2cc0b-f7a0-4808-96c0-9c8f0bb16efa(Ub4504310-c37c-4727-8ff3-23b8ee3ad3e9(U2b31c2d6-f342-452b-a7ec-5bb0c81c6ab0(Uf19c6d0c-41b6-487f-a7fe-f7349a78ba26(U9d20b9df-4460-4b25-b616-48f950284bdb(U949396cc-73ff-47c4-8833-38c7be3205a7(U9da0f458-e966-4fb8-b37b-052de4f87e87(U655fc11b-3d5b-444d-aee2-fd268d0b6c92(U87e58126-b72e-4601-a010-59790b8e2ca2(U0c07f493-3806-4fb7-9dc7-5b2cc1327847(Udab86b20-370d-42aa-83fa-dd5491353236(Ue62092f2-e306-495b-af7c-fb4d1e107ec1(Ue1540079-fb15-431a-ab05-d52c539c6587(U26a98149-7df6-47bc-a295-5a7dc80041c3(U2b064000-b97b-4919-8089-4460fe3833e9
(U17ca3f08-3e60-415c-a31f-4e995eeb56ff (Ub37d0463-7c1a-477d-aa18-8b48996fb37f (U65123566-471a-4189-8ef7-d2899067091d
(Ue95ec2a7-f459-43a0-9b1f-45609e76e0d7 (U742a96fd-2412-4217-aa50-6c10440d4aef(Ufbfc9774-3977-4764-a510-10eee3fb436b(U6a75ff61-ab5b-499d-a3c4-7d13f53015a3(Uc9304b65-0e72-429b-ab2e-33f773e7e35c(Uf7926bd0-6f5f-4b6b-ad27-18ce44bbc652(Ua171ae98-d249-4ce2-a43e-d355ebc389b7(U16c7c1ad-2f06-4864-bf83-7fd3e6a03c40'U 6e9af260-7758-4e24-8a33-eaf39a7e3db6
� �
v
��� �8�1�
�
}�
�
� �� �
�UOn
\
> �� 3dannywperez@msn.com ;lucie.morin@example.com ;marc.dubois@example.com Csophie.levesque@example.com ?jean.bouchard@example.com Amarie.tremblay@example.com ?sofia.rodriguez@email.com7robert.chen@email.com7aisha.patel@email.com9james.wilson@email.com =maria.gonzalez@email.com =assistant.lawyer@lmep.ca7lead.attorney@lmep.ca;legal.secretary@lmep.ca/law.clerk@lmep.ca ?david.justice@example.com Amarie.champion@example.com Amarie.champion@lawfirm.com
Adavid.justice@advocates.ca Ethomas.leblanc@adwavocats.ca $Misabella.rodriguez@adwavocats.ca
%Omarc-andre.bouchard@adwavocats.ca Csophie.dubois@adwavocats.ca =david.chen@adwavocats.ca'Smarie-claude.tremblay@adwavocats.ca =justin.wee@adwavocats.ca"Iaudrey.labrecque@adwavocats.ca1client@example.com1lawyer@example.com/ admin@example.com
� ����kM�/ ?cmcgwaq4s0004vjbs05zudlt2 ?cmcgwaq4s000avjbsjvrslqgt ?cmcgwaq4s0005vjbsw8kfjap1 ?cmcgw396a0007vjc4hz2a39t2 ?cmcgw396a0005vjc43teicejp ?cmcgw396a0004vjc4f1043ued ?cmcgvzw0x0006vjx8thw6qeif ?cmcgvzw0x0005vjx849zfwaxm ? cmcgvzw0x0004vjx8t0f7kd33
� ����kM�/ ?cmcgwaq4s0004vjbs05zudlt2 ?cmcgwaq4s000avjbsjvrslqgt ?cmcgwaq4s0005vjbsw8kfjap1 ?cmcgw396a0007vjc4hz2a39t2 ?cmcgw396a0005vjc43teicejp ?cmcgw396a0004vjc4f1043ued ?cmcgvzw0x0006vjx8thw6qeif ?cmcgvzw0x0005vjx849zfwaxm ? cmcgvzw0x0004vjx8t0f7kd33
. �+�I
�
t
� . h ?3 ?cmcgwaq4s0007vjbsubgef732123 Rue Saint-DenisMontrealQuebecH2X 1K5Canadacmcgwaq4s0004vjbs05zudlt2i?1!?cmcgwaq4s000cvjbs54j6py34789 Rue King OuestSherbrookeQuebecJ1H 1R3Canadacmcgwaq4s000avjbsjvrslqgto?G?cmcgwaq4s0009vjbsbtfevsf2456 Boulevard René-LévesqueLavalQuebecH7M 2G8Canadacmcgwaq4s0005vjbsw8kfjap1i?1!?cmcgw396b000cvjc4j6usbgvg789 Rue King OuestSherbrookeQuebecJ1H 1R3Canadacmcgw396a0007vjc4hz2a39t2h?3 ?cmcgw396b000bvjc4xpxv58qg123 Rue Saint-DenisMontrealQuebecH2X 1K5Canadacmcgw396a0005vjc43teicejpo?G?cmcgw396a0009vjc45ebhfwbe456 Boulevard René-LévesqueLavalQuebecH7M 2G8Canadacmcgw396a0004vjc4f1043uedo?G?cmcgvzw0x000cvjx8518swt26456 Boulevard René-LévesqueLavalQuebecH7M 2G8Canadacmcgvzw0x0006vjx8thw6qeifh?3 ?cmcgvzw0x000bvjx83noj7pe6123 Rue Saint-DenisMontrealQuebecH2X 1K5Canadacmcgvzw0x0005vjx849zfwaxmi?1!?cmcgvzw0x000avjx81yyowmk6789 Rue King OuestSherbrookeQuebecJ1H 1R3Canadacmcgvzw0x0004vjx8t0f7kd33
� ����kM�/ ?cmcgwaq4s0007vjbsubgef732 ?cmcgwaq4s000cvjbs54j6py34 ?cmcgwaq4s0009vjbsbtfevsf2 ?cmcgw396b000cvjc4j6usbgvg ?cmcgw396b000bvjc4xpxv58qg ?cmcgw396a0009vjc45ebhfwbe ?cmcgvzw0x000cvjx8518swt26 ?cmcgvzw0x000bvjx83noj7pe6 ? cmcgvzw0x000avjx81yyowmk6
L �,�\
�
�
� L h ?) %?cmcgwaq4s0006vjbs01tecwkcPierre LeblancbordeauxBDX-2024-001�tA ��z� cmcgwaq4s0004vjbs05zudlt2h?%!%?cmcgwaq4s000bvjbs7aca2bx9Robert CaronsherbrookeSHB-2024-089�|cX �=%� cmcgwaq4s000avjbsjvrslqgtf?'%?cmcgwaq4s0008vjbse4n0wb33Marc BouchardleclercLCL-2024-045�
j� �gB� cmcgwaq4s0005vjbsw8kfjap1h?%!%?cmcgw396a000avjc4patjba5fRobert CaronsherbrookeSHB-2024-089�|cX �=%� cmcgw396a0007vjc4hz2a39t2h?) %?cmcgw396a0008vjc4py23ykniPierre LeblancbordeauxBDX-2024-001�tA ��z� cmcgw396a0005vjc43teicejpf?'%?cmcgw396a0006vjc4pblha0j6Marc BouchardleclercLCL-2024-045�
j� �gB� cmcgw396a0004vjc4f1043uedf?'%?cmcgvzw0x0009vjx8jwdts8lmMarc BouchardleclercLCL-2024-045�
j� �gB� cmcgvzw0x0006vjx8thw6qeifh?) %?cmcgvzw0x0008vjx8kpd4vql8Pierre LeblancbordeauxBDX-2024-001�tA ��z� cmcgvzw0x0005vjx849zfwaxmh?%!%?cmcgvzw0x0007vjx85r7j44amRobert CaronsherbrookeSHB-2024-089�|cX �=%� cmcgvzw0x0004vjx8t0f7kd33
� ����kM�/ ?cmcgwaq4s0006vjbs01tecwkc ?cmcgwaq4s000bvjbs7aca2bx9 ?cmcgwaq4s0008vjbse4n0wb33 ?cmcgw396a000avjc4patjba5f ?cmcgw396a0008vjc4py23ykni ?cmcgw396a0006vjc4pblha0j6 ?cmcgvzw0x0009vjx8jwdts8lm ?cmcgvzw0x0008vjx8kpd4vql8 ? cmcgvzw0x0007vjx85r7j44am
` #
�
- � �
�
D�v�s�`����n� �9%%�5tableRegistrationRegistrationCREATE TABLE "Registration" (
"id" TEXT NOT NULL PRIMARY KEY,
"firstName" TEXT NOT NULL,
"lastN/ C indexsqlite_autoindex_Document_1Document �K%�?indexDetaineeInfo_r)D= indexsqlite_autoindex_users_1users�C�etableusersusersCREATE 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
) �C indexsqlite_autoindex_Document_1Document � �QtableDocumentDocumentCREATE TABLE "Document" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"type" TEXT NOT NULL,
"url" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"registrationId" TEXT NOT NULL,
CONSTRAINT "Document_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�K%�?indexDetaineeInfo_registrationId_keyDetaineeInfo
CREATE UNIQUE INDEX "DetaineeInfo_registrationId_key" ON "DetaineeInfo"("registrationId")}A�+indexAddress_registrationId_keyAddressCREATE UNIQUE INDEX "Address_registrationId_key" ON "Address"("registrationId")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
)�.Y/�aindexVerificationToken_identifier_token_keyVerificationTokenCREATE UNIQUE INDEX "VerificationToken_identifier_token_key" ON "VerificationToken"("identifier", "token")�
C/�/indexVerificationToken_token_keyVerificationTokenCREATE UNIQUE INDEX "VerificationToken_token_key" ON "VerificationToken"("token")3 G! indexsqlite_autoindex_FileUpload_1FileUpload �s
!!�1tableFileUploadFileUpload CREATE 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
)�. //� tableVerificationTokenVerificationToken
CREATE TABLE "VerificationToken" (
"identifier" TEXT NOT NULL,
"token" TEXT NOT NULL,
"expires" DATETIME NOT NULL
)CW1 indexsqlite_autoindex__prisma_migrations_1_prisma_migrations�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
)
| � UjzI�
� X d ' ' ' ' �K�ytableMessageMessageCREATE 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,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"userId" TEXT NOT NULL,
"chatRoomId" TEXT NOT NULL,
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
)cJ/ �indexChatRoom_name_keyChatRoomCREATE UNIQUE INDEX "ChatRoom_name_key" ON "ChatRoom"("name")/IC indexsqlite_autoindex_ChatRoom_1ChatRoom(�mH �-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
)�)GW+�]indexChatParticipant_userId_chatRoomId_keyChatParticipant CREATE UNIQUE INDEX "ChatParticipant_userId_chatRoomId_key" ON "ChatParticipant"("userId", "chatRoomId")=FQ+ indexsqlite_autoindex_ChatParticipant_1ChatParticipant*�$E++�tableChatParticipantChatParticipantCREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "ChatParticipant_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE CASCADE ON UPDATE CASCADE
) - �= indexsqlite_autoindex_users_1users�C�etableusersusersCREATE TABLE "users" (
"id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"name" TEXT,;QO) indexsqlite_autoindex_PrivateMessage_1PrivateMessage)�FP))�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_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "PrivateMessage_privateChatId_fkey" FOREIGN KEY ("privateChatId") REFERENCES "PrivateChat" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)� += indexsqlite_autoindex_users_1users�
OI#�;indexPrivateChat_registrationId_keyPrivateChat#CREATE UNIQUE INDEX "PrivateChat_registrationId_key" ON "PrivateChat"("registrationId")5NI# indexsqlite_autoindex_PrivateChat_1PrivateChat"�/M##�%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_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "PrivateChat_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "PrivateChat_adminId_fkey" FOREIGN KEY ("adminId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
) /A indexsqlite_autoindex_Message_1Message+
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 � ��
�
n � d � \
�
X � ?�$�"���j�@�� � W � ???? ?cmcgwbmmi000wvjbsllb2qsnwcmcgwbmm7000uvjbsm7pcfg4ccmcgwbm4r0003vjbswoy2zxrzCLIENT����Kcmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwbmlw000svjbst23t5ieycmcgwbmlj000qvjbstx5y1qr2cmcgwbm4r0003vjbswoy2zxrzCLIENT����4cmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwbml9000ovjbszhoj7eyxcmcgwbmky000mvjbs7rle8l9mcmcgwblrj0002vjbsp9mq6vcaCLIENT���� cmcgk36ax0000vjxwf93zgfwicmcgvz1y70004vjx8hl4gu8q0� ???? ?cmcgwbmkp000kvjbsk0kgfrdycmcgwbmkf000ivjbsu969m114cmcgwblck0001vjbsadc46bi0CLIENT����
cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwbmk6000gvjbsge17x8ancmcgwbmjw000evjbscolzgi52cmcgwbkyj0000vjbsv0glcolaCLIENT����cmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwbmjo000cvjbs171eo2pgcmcgwbmjf000avjbsrwe0gdrwcmcgwbkyj0000vjbsv0glcolaCLIENT�����cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd� ???? ?cmcgwbmj60008vjbshxmjkvfycmcgwbmit0006vjbsk1kwtvj8cmcgwbkyj0000vjbsv0glcolaCLIENT�����cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwarta0007vj9sx0h2xwr5cmcgwart30005vj9spp80pfk8cmcgk36ee0001vjxw6rfrkd2kCLIENT���KNcmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwarsw0003vj9sz7qyr7gwcmcgwarsn0001vj9sgtjepgp5cmcgk36ee0001vjxw6rfrkd2kCLIENT���K@cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd� ???-? cmcgwaq5t000ovjbs0ofdwf6scmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0002vjx8cm1h0307assistant_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5t000nvjbsglbximb7cmcgwaq4s000avjbsjvrslqgtcmcgvzvyt0000vjx81k9vbo5qprimary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5p000ivjbs7r5m9cgjcmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0003vjx878qe6kd7primary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5p000hvjbsxxwtqy5jcmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0003vjx878qe6kd7primary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7| ??? ? cmcgwaq5p000jvjbswgmr17ricmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0001vjx8bgd56xcisecretary���B�cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgwaq5p000kvjbsi22409lzcmcgwaq4s0004vjbs05zudlt2cmcgvzvyt0000vjx81k9vbo5qassistant_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???? ?cmcgwa52q0007vj6chr3332ugcmcgwa52j0005vj6caca6ind9cmcgk36ee0001vjxw6rfrkd2kCLIENT����2cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd�
???? ?cmcgwa52a0003vj6c9veynx40cmcgwa51x0001vj6c6sfx11dxcmcgk36ee0001vjxw6rfrkd2kCLIENT����"cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???)? cmcgw397m000ovjc4av1f8wn1cmcgw396a0007vjc4hz2a39t2cmcgvzvyt0000vjx81k9vbo5qprimary_lawyer����_cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgw397m000nvjc4k183h790cmcgw396a0004vjc4f1043uedcmcgvzvyu0002vjx8cm1h0307assistant_lawyer����_cmcgvzvyu0003vjx878qe6kd7|
??? ? cmcgw397i000ivjc4hz3k56macmcgw396a0005vjc43teicejpcmcgvzvyu0001vjx8bgd56xcisecretary����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgw397i000kvjc4brc9s1tzcmcgw396a0005vjc43teicejpcmcgvzvyu0003vjx878qe6kd7primary_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgw397i000hvjc4nlajc73pcmcgw396a0004vjc4f1043uedcmcgvzvyu0003vjx878qe6kd7primary_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgw397i000jvjc4gsobofn3cmcgw396a0005vjc43teicejpcmcgvzvyt0000vjx81k9vbo5qassistant_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw25000ovjx84brbin5xcmcgvzw0x0004vjx8t0f7kd33cmcgvzvyt0000vjx81k9vbo5qprimary_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgvzw25000nvjx8d2zykmg7cmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0002vjx8cm1h0307assistant_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgvzw22000jvjx8o86z80l3cmcgvzw0x0005vjx849zfwaxmcmcgvzvyt0000vjx81k9vbo5qassistant_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw22000kvjx8obcnm03ucmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0003vjx878qe6kd7primary_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw22000hvjx8kioglk2lcmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0003vjx878qe6kd7primary_lawyer���
cmcgvzvyu0003vjx878qe6kd7| ??? ? cmcgvzw22000ivjx8xpcluv41cmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0001vjx8bgd56xcisecretary���
cmcgvzvyu0003vjx878q �
� Ax
� � �
K z��#N���
'^ � � ? u ?cmcgj2b36000jvjlkuv98bfmmGénéralCanal de discussion général pour tous les membres.GROUPcmcgj2ax40000vjlkn95vza40���������F
?-�_ ?cmcgj2b2r000ivjlktbpy7gydE.D. de RobervalCanal de discussion pour Établissement de détention de Roberval. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40�������`
?G�y ?cmcgj2b2j000hvjlkpixlpj6bE.D. de Rivière-des-PrairiesCanal de discussion pour Établissement de détention de Rivière-des-Prairies. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40�������^
?E�w ?cmcgj2b2b000gvjlkx8vwj7vyE.D. de Montréal (Bordeaux)Canal de discussion pour Établissement de détention de Montréal (Bordeaux). Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40�������L
?3�e ?cmcgj2b22000fvjlkszk3qb8tE.D. de Sorel-TracyCanal de discussion pour Établissement de détention de Sorel-Tracy. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���z���T
?;�m ?cmcgj2b1t000evjlkmkprcgu6E.D. de Trois-RivièresCanal de discussion pour Établissement de détention de Trois-Rivières. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���q���:
?'�M ?cmcgj2b1k000dvjlkxmka1514E.L. de LavalCanal de discussion pour Établissement Leclerc de Laval. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���i���}�R
?9�k ?cmcgj2b1a000cvjlkzbn7g025E.D. de Saint-JérômeCanal de discussion pour Établissement de détention de Saint-Jérôme. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���_���t�>
?%�W ?cmcgj2b11000bvjlk5zrqswscE.D. de HullCanal de discussion pour Établissement de détention de Hull. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���V���m�N
?5�g ?cmcgj2b0s000avjlkyyjy0ijgE.D. de Havre-AubertCanal de discussion pour Établissement de détention de Havre-Aubert. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���L���d�B
?)�[ ?cmcgj2b0h0009vjlkv1zi4mdpE.D. de PercéCanal de discussion pour Établissement de détention de Percé. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���A���\�N
?5�g ?cmcgj2b080008vjlk5gu0zi22E.D. de New CarlisleCanal de discussion pour Établissement de détention de New Carlisle. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���8���T�J
?1�c ?cmcgj2azy0007vjlk4wjenqfoE.D. de SherbrookeCanal de discussion pour Établissement de détention de Sherbrooke. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���.���K�J
?1�c ?cmcgj2azn0006vjlkpfj3kkh5E.D. de Sept-ÎlesCanal de discussion pour Établissement de détention de Sept-Îles. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40���#���B�L
?3�e ?cmcgj2aze0005vjlk3xstb3lvE.D. de Baie-ComeauCanal de discussion pour Établissement de détention de Baie-Comeau. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40������8�_
?7� ?cmcgj2az30004vjlkbzh08weyE.D. de Québec – MCanal de discussion pour Établissement de détention de Québec – secteur masculin. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40������1�_
?7� ?cmcgj2ays0003vjlk73toorjuE.D. de Québec – FCanal de discussion pour Établissement de détention de Québec – secteur féminin. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40������&�F
?-�_ ?cmcgj2ayh0002vjlkdm2ieddrE.D. de RimouskiCanal de discussion pour Établissement de détention de Rimouski. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40������� �<
?#�U ?cmcgj2ay40001vjlk46xzdfooE.D. d'AmosCanal de discussion pour Établissement de détention d'Amos. Ouvert à tous les membres concernés.GROUPcmcgj2ax40000vjlkn95vza40�������
�
�
y
�N�wc$
�
z 1 ) � ` =_Q+ indexsqlite_autoindex_typing_statuses_1typing_statuses0�^++�Ytabletyping_statusestyping_statuses/CREATE TABLE "typing_statuses" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" TEXT NOT NULL,
"chatRoomId" �`++�YtableMessageReactionMessageReaction1CREATE 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_messageId_fkey" FOREIGN KEY ("messageId") REFERENCES "Message" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "MessageReaction_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)=_Q+ indexsqlite_autoindex_typing_statuses_1typing_statuses0�^++�Ytabletyping_statusestyping_statuses/CREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "typing_statuses_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)7]K% indexsqlite_autoindex_status_notes_1status_notes.�@\%%�Ctablestatus_notesstatus_notes-CREATE 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_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "status_notes_adminId_fkey" FOREIGN KEY ("adminId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) � +indexusers_email_key=aQ+ indexsqlite_autoindex_MessageReaction_1MessageReaction27XK% indexsqlite_autoindex_ThemeProfile_1ThemeProfile�vW%%�/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
)wV=�#indexSession_sessionToken_keySessionCREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken")-UA indexsqlite_autoindex_Session_1Session�2T�;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
) �K% indexsqlite_autoindex_Registration_1Registration' �%%�tableRegistrationRegistration&CREATE 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,
"preOcc= indexsqlite_autoindex_newsletter_subscriptions_1newsletter_subscriptions5�2b==�wtablenewsletter_subscriptionsnewsletter_subscriptions4CREATE 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
)
� �������������������>��c�z+��P 1david-justice-demo3marie-champion-demo)marie-champion
'david-justice )thomas.leblanc 1isabella.rodriguez
5marc-andré.bouchard 'sophie.dubois!david.chen7marie-claude.tremblay!justin.wee-audrey.labrecque
&
� ����kM/����{]?!
�
� ?cmcgj2b36000jvjlkuv98bfmm ?cmcgj2b2r000ivjlktbpy7gyd ?cmcgj2b2j000hvjlkpixlpj6b ?cmcgj2b2b000gvjlkx8vwj7vy ?cmcgj2b22000fvjlkszk3qb8t ?cmcgj2b1t000evjlkmkprcgu6 ?cmcgj2b1k000dvjlkxmka1514
?cmcgj2b1a000cvjlkzbn7g025 ?cmcgj2b11000bvjlk5zrqswsc ?cmcgj2b0s000avjlkyyjy0ijg
?cmcgj2b0h0009vjlkv1zi4mdp ?cmcgj2b080008vjlk5gu0zi22 ?cmcgj2azy0007vjlk4wjenqfo ?cmcgj2azn0006vjlkpfj3kkh5 ?cmcgj2aze0005vjlk3xstb3lv ?cmcgj2az30004vjlkbzh08wey ?cmcgj2ays0003vjlk73toorju ?cmcgj2ayh0002vjlkdm2ieddr ? cmcgj2ay40001vjlk46xzdfoo
! # ����kM�/���{]
�!?
�
�
�
m
O
1
� � � � } _ A # ?cmcgwbmoo001cvjbs5m561aso! ?cmcgwbmo40018vjbsfpzcjhtu ?cmcgwbmnl0014vjbslbxnhvwu ?cmcgwbmn10010vjbsb6d5zqe4 ?cmcgwbmmi000wvjbsllb2qsnw ?cmcgwbmlw000svjbst23t5iey ?cmcgwbml9000ovjbszhoj7eyx ?cmcgwbmkp000kvjbsk0kgfrdy ?cmcgwbmk6000gvjbsge17x8an ?cmcgwbmjo000cvjbs171eo2pg ?cmcgwbmj60008vjbshxmjkvfy ?cmcgwarta0007vj9sx0h2xwr5 ?cmcgwarsw0003vj9sz7qyr7gw ?cmcgwaq5t000ovjbs0ofdwf6s ?cmcgwaq5t000nvjbsglbximb7 ?cmcgwaq5p000ivjbs7r5m9cgj ?cmcgwaq5p000hvjbsxxwtqy5j ?cmcgwaq5p000jvjbswgmr17ri ?cmcgwaq5p000kvjbsi22409lz ?cmcgwa52q0007vj6chr3332ug ?cmcgwa52a0003vj6c9veynx40
?cmcgw397m000ovjc4av1f8wn1 ?cmcgw397m000nvjc4k183h790 ?cmcgw397i000ivjc4hz3k56ma
?cmcgw397i000kvjc4brc9s1tz ?cmcgw397i000hvjc4nlajc73p ?cmcgw397i000jvjc4gsobofn3 ?cmcgvzw25000ovjx84brbin5x ?cmcgvzw25000nvjx8d2zykmg7 ?cmcgvzw22000jvjx8o86z80l3 ?cmcgvzw22000kvjx8obcnm03u ?cmcgvzw22000hvjx8kioglk2l ? cmcgvzw22000ivjx8xpcluv41
,
� C
�
�
T��CCC �� �nd W �nd//� tablenew_DirectMessagenew_DirectMess5iI# indexsqlite_autoindex_new_Message_1new�;pa+�windexMessageReaction_messageId_userId_emoji_keyMessageReaction CREATE UNIQUE INDEX "MessageReaction_messageId_userId_emoji_key" ON "MessageReaction"("messageId", "userId", "emoji")�)oW+�]indextyping_statuses_userId_chatRoomId_keytyping_statusesCREATE UNIQUE INDEX "typing_statuses_userId_chatRoomId_key" ON "typing_statuses"("userId", "chatRoomId") �K% indexsqlite_autoindex_Registration_1Registration+ �%%�KtableRegistrationRegistrationCREATE 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,
CONSTRAINT "Registration_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "Registration_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)-iA indexsqlite_autoindex_Message_1Message �sh�=tableMessageMessageCREATE 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_chatRoomId_fkey" FOREIGN KEY ("chatRoomId") REFERENCES "ChatRoom" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "Message_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "Message_replyToId_fkey" FOREIGN KEY ("replyToId") REFERENCES "Message" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)/gC indexsqlite_autoindex_Document_1Document,�Xf �tableDocumentDocument CREATE TABLE "Document" (
"id" TEXT NOT NULL PRIMARY KEY,
"name" TEXT NOT NULL,
"type" TEXT NOT NULL,
"url" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
CONSTRAINT "Document_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "Document_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)9eM' indexsqlite_autoindex_DirectMessage_1DirectMessage7�bd''�tableDirectMessageDirectMessage6CREATE TABLE "DirectMessage" (
"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,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"senderId" TEXT NOT NULL,
"recipientId" TEXT NOT NULL,
CONSTRAINT "DirectMessage_recipientId_fkey" FOREIGN KEY ("recipientId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "DirectMessage_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)
� �W � ���r/�� U � E E =yQ+ indexsql/{C indexsqlite_autoindex_segments_1segmentsD�]z �
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 DEF=yQ+ indexsqlite_autoindex_campaign_events_1campaign_eventsA�;pa+�windexMessageReaction_messageId_userId_emoji_keyMessageReaction CREATE UNIQUE INDEX "MessageReaction_messageId_userId_emoji_key" ON "MessageReaction"("messageId", "userId", "emoji")�x++�Etablecampaign_eventscampaign_events@CREATE 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_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES "campaigns" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "campaign_events_subscriptionId_fkey" FOREIGN KEY ("subscriptionId") REFERENCES "newsletter_subscriptions" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)AwU/ indexsqlite_autoindex_campaign_variants_1campaign_variants?� v//�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
)1uE indexsqlite_autoindex_campaigns_1campaigns=�nt �+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_templateId_fkey" FOREIGN KEY ("templateId") REFERENCES "email_templates" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "campaigns_segmentId_fkey" FOREIGN KEY ("segmentId") REFERENCES "segments" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "campaigns_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=sQ+ indexsqlite_autoindex_email_templates_1email_templates;�]r++�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
)�&qQ=�Kindexnewsletter_subscriptions_email_keynewsletter_subscriptions9CREATE UNIQUE INDEX "newsletter_subscriptions_email_key" ON "newsletter_subscriptions"("email")
� � ��
�
� `
]�\ ��g
� ?�S- indexsqlite_autoindex_case_assignments_1case_assignmentsN��--�?tablecase_assignmentscase_assignmentsMCREATE TABLE "case_assignments" (
"id" TEXT NOT NULL PRIMARY KEY,
"registrationId" TEXT NOT NULL,
"userId" TEXT NOT NULL,
"role" TEXT NOT NULL,
"assignedAt" DATE5�I# indexsqlite_autoindex_permissions_1permissionsL�/�##�%tablepermissionspermissions'CREATE 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
)� <1� indexusers_username_keyusers&CREATE UNIQUE INDEX "K� _9 indexsqlite_autoindex_impersonation_sessions_1impersonation_sessionsU5�I# indexsqlite_autoindex_permissions_1permissionsL/{C indexsqlite_autoindex_segments_1segmentsD�]z �
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)�= indexsqlite_autoindex_users_1usersK y�ItableusersusersJCREATE 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_TI�O� 99�9tableimpersonation_sessionsimpersonation_sessionsTCREATE 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,
CONSTRAINT "impersonation_sessions_originalUserId_fkey" FOREIGN KEY ("originalUserId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "impersonation_sessions_impersonatedUserId_fkey" FOREIGN KEY ("impersonatedUserId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�%� U#�_indexpermissions_role_resource_action_keypermissionsOCREATE UNIQUE INDEX "permissions_role_resource_action_key" ON "permissions"("role", "resource", "action")�>� e+�yindexsegment_members_segmentId_subscriptionId_keysegment_membersICREATE UNIQUE INDEX "segment_members_segmentId_subscriptionId_key" ON "segment_members"("segmentId", "subscriptionId")?S- indexsqlite_autoindex_automation_rules_1automation_rulesH�;~--�)tableautomation_rulesautomation_rulesGCREATE 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
)=}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_segmentId_fkey" FOREIGN KEY ("segmentId") REFERENCES "segments" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "segment_members_subscriptionId_fkey" FOREIGN KEY ("subscriptionId") REFERENCES "newsletter_subscriptions" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)
� � J & # ADW Avocats
!� �!�Y��
�Ay
�
a
) � � � � I � i 1
�
�
�
Q
� � q 9 � 7??cmcgwbmog001avjbsug1zzv8qcmcgwbmi50004vjbsodualz0j!7??cmcgwbmnx0016vjbsrjyj8ohqcmcgwbmi50004vjbsodualz0j 7??cmcgwbmne0012vjbs6z38vq4dcmcgwbmi50004vjbsodualz0j 7??cmcgwbmms000yvjbsfl39ecpwcmcgwbm4r0003vjbswoy2zxrz 7??cmcgwbmm7000uvjbsm7pcfg4ccmcgwbm4r0003vjbswoy2zxrz 7??cmcgwbmlj000qvjbstx5y1qr2cmcgwbm4r0003vjbswoy2zxrz 7??cmcgwbmky000mvjbs7rle8l9mcmcgwblrj0002vjbsp9mq6vca7??cmcgwbmkf000ivjbsu969m114cmcgwblck0001vjbsadc46bi07??cmcgwbmjw000evjbscolzgi52cmcgwbkyj0000vjbsv0glcola7??cmcgwbmjf000avjbsrwe0gdrwcmcgwbkyj0000vjbsv0glcola7??cmcgwbmit0006vjbsk1kwtvj8cmcgwbkyj0000vjbsv0glcola7??cmcgwart30005vj9spp80pfk8cmcgk36ee0001vjxw6rfrkd2k7??cmcgwarsn0001vj9sgtjepgp5cmcgk36ee0001vjxw6rfrkd2k7??cmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0002vjx8cm1h03077??cmcgwaq4s000avjbsjvrslqgtcmcgvzvyt0000vjx81k9vbo5q7??cmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0003vjx878qe6kd77??cmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0003vjx878qe6kd77??cmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0001vjx8bgd56xci7??cmcgwaq4s0004vjbs05zudlt2cmcgvzvyt0000vjx81k9vbo5q7??cmcgwa52j0005vj6caca6ind9cmcgk36ee0001vjxw6rfrkd2k7??cmcgwa51x0001vj6c6sfx11dxcmcgk36ee0001vjxw6rfrkd2k
7??cmcgw396a0007vjc4hz2a39t2cmcgvzvyt0000vjx81k9vbo5q 7??cmcgw396a0004vjc4f1043uedcmcgvzvyu0002vjx8cm1h0307 7??cmcgw396a0005vjc43teicejpcmcgvzvyu0001vjx8bgd56xci
7??cmcgw396a0005vjc43teicejpcmcgvzvyu0003vjx878qe6kd7 7??cmcgw396a0004vjc4f1043uedcmcgvzvyu0003vjx878qe6kd77??cmcgw396a0005vjc43teicejpcmcgvzvyt0000vjx81k9vbo5q7??cmcgvzw0x0004vjx8t0f7kd33cmcgvzvyt0000vjx81k9vbo5q7??cmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0002vjx8cm1h03077??cmcgvzw0x0005vjx849zfwaxmcmcgvzvyt0000vjx81k9vbo5q7??cmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0003vjx878qe6kd77??cmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0003vjx878qe6kd76?? cmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0001vjx8bgd56xci
� � /�A
� � � � " � � ; 1�E� �%%�tableRegistrationRegistration]CREATE 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_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("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_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)1�E indexsqlite_autoindex_law_firms_1law_firms[�0� �/tablelaw_firmslaw_firmsZCREATE 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
)7�K% indexsqlite_autoindex_case_updates_1case_updatesY�w�%%�1tablecase_updatescase_updatesXCREATE 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_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "case_updates_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) VI# indexsqlite_autoindex_legal_cases_1legal_casesW ##�{tablelegal_caseslegal_casesVCREATE 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,
"leadLawyerId" TEXT NOT NULL,
"firmName" TEXT,
"filingDate" DATETIME,
"expectedDuration" INTEGER,
"priority" TEXT NOT NULL DEFAULT 'medium',
"budget" REAL,
"isAcceptingApplications" BOOLEAN NOT NULL DEFAULT true,
"applicationDeadline" DATETIME,
"requiredDocuments" TEXT,
"eligibilityCriteria" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"createdBy" TEXT NOT NULL,
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
)
� ����� )Justice Seeker+Platform Patron-David vs Goliath)Case Supporter' Pro Bono Hero
U p�6
� � T �
o � 2��-��c�/��<� � U �#
U�
_ 2b31c2d6-f342-452b-a7ec-5bb0c81c6ab031dbc1a13c65ab4c3ed3755c326ebf8f65e807343b14c8031e22b43ee34b0554����20250624232138_add_role_based_permissions�����
U�
O f19c6d0c-41b6-487f-a7fe-f7349a78ba2600ca18c59aa6b69dc4a5acaab5afb0ff88b7238085c5ee4cbe007346a8391d0e����20250624230108_add_username_field�����
U�
Y 9d20b9df-4460-4b25-b616-48f950284bdb4bc2eea2753a75354447d35f68021f2f55cb2361bd533a05adde97b4605b9cf1����20250624222727_add_user_profile_fields���v�)
U�
k 949396cc-73ff-47c4-8833-38c7be3205a7ce3816942c6c99184eba673285e944f29ae93dde8bbe5cc8de248f1db2eff72c���t20250624214758_add_advanced_newsletter_features���U�%
U�
c 9da0f458-e966-4fb8-b37b-052de4f87e87acd1144c47d49c9cfd1f92b6b26d7bde613b3bfbd93132c304c9816fb2e85f78���R20250624214237_add_newsletter_subscriptions�����
U�
Q 655fc11b-3d5b-444d-aee2-fd268d0b6c92e35533fa6b7da10c9884bd07915dde5707ecdc0cced9747db90f4e3e9bff489d����20250622165631_add_direct_messages����
U�
3 87e58126-b72e-4601-a010-59790b8e2ca2115f99ba97753b67caa3bb67c9756514798e548d5acb7e3ec3f3b004a356dc78����20250621184100_init���w�!
U�
[ 0c07f493-3806-4fb7-9dc7-5b2cc1327847033a75dc96b1b03a19f6fb0f37225f57f47f05b1d4e6e3f728c3cc52d81d4fba���u20250621043731_add_direct_message_model���e�
U�
I dab86b20-370d-42aa-83fa-dd549135323690ed2bd905dca043379746beb55a12d83b3c37ea0226a51e60f444c44a925e93���b20250621033857_add_chat_system���E�
U�
Q e62092f2-e306-495b-af7c-fb4d1e107ec1ca0f8914e77f1c6b475b747ebaa46dd009bc7ddf1b14d420ce31aece9723da1a���A20250620032358_remove_status_notes���8�
U�
3 e1540079-fb15-431a-ab05-d52c539c6587b49c37e65426adc5724e99bab53ddcb5f7f23874d0fbfbce7bd3e2042850f55c���520250616230336_init����'
U�
g 26a98149-7df6-47bc-a295-5a7dc80041c3fb6292b5487725b0286d51d95b0136067ad7070328cae59a83ef0af773d792eb����20250615040251_add_messages_and_typing_status����+
U�
o 2b064000-b97b-4919-8089-4460fe3833e95e0b095890b16bc1dbf3d2d1c625dbd471c825871d1abf9af5f6b756bfdeda9b����20250615004455_add_admin_relation_to_status_notes���Ł*
U�
m 17ca3f08-3e60-415c-a31f-4e995eeb56ff41eb5dae876c7510685b8f5ead37699e5323cca5c2c42e2280db96e0ac32f727����20250614194111_add_registration_id_to_statusnote�����
U�
M b37d0463-7c1a-477d-aa18-8b48996fb37fc21c3df255ef65513d48c4bff0a41a95f694dd6d06a94b7129d821f0c46865cf���}20250613074746_fix_schema_issues���G�
U�
S 65123566-471a-4189-8ef7-d2899067091d4817009465719f043f1f63849209a5d4a898bd570e5c4a6363c4f0975a50cd01���D20250613002530_add_additional_notes���6�&
U�
e e95ec2a7-f459-43a0-9b1f-45609e76e0d767c1d304e40b29ebcfd9cfb761039138b383cf76252ba91164eca2c1201faa75���320250613000613_add_registration_extra_fields��� �
U�
M 742a96fd-2412-4217-aa50-6c10440d4aef6d522349f9efa63b2a98cea18f579db48b6329d747b0201d29e90896b9f92d32��� 20250612213418_add_lawyer_fields����
U�
Q fbfc9774-3977-4764-a510-10eee3fb436b7507f8e0fda6804fdebd97cf0e2c8e120953bc7b63d54e36f25e8aab8f2ea8b9���20250611055556_add_reminders_field�����"
U�
] 6a75ff61-ab5b-499d-a3c4-7d13f53015a349f18eb6ca0b94d99447ef0650b19831f15c8ce1b819b23541a74fd03de6a104����20250611042458_add_reset_password_fields����
U�
M c9304b65-0e72-429b-ab2e-33f773e7e35c77dcbe2f47ad88680b592f3503d84b813cd5ba06de6ce8184d19f6de1c54673e����20250610190944_add_theme_profile���ځ
U�
S f7926bd0-6f5f-4b6b-ad27-18ce44bbc652fc4cab989dc81aee963307824a58b87f4a304aae93352055a673ea15fec02230����20250606102655_add_document_cascade���Ł
U�
O a171ae98-d249-4ce2-a43e-d355ebc389b7c30385422b7b1286f22203641c22f339797d01e50bb2f774e314c2953cb93fda����20250603000628_add_document_table�����
U�
K 16c7c1ad-2f06-4864-bf83-7fd3e6a03c40bf7d7e28b64b1366ac97678b667fc7642bbc0b8a896af9f6f2a9330185b8c2cf����20250602224217_add_gender_field�����
U�
3 6e9af260-7758-4e24-8a33-eaf39a7e3db66d54e4a7969ab4883ea8797f36b74af4c61ec8d1aef5711fc80ad0fcdf76e42d����20250601222438_init���]
� _�
Z � ]
�
n� �%$
U�
c a21c2ead-462d-4d12-8002-b861190c7f34e34023838d6b49e0ab153919b8ae8b81db63e1da47b5fbf7c1c3ec1fbca9ee26����320250628192116_add_document_collab_features���� � #
U�
U a0246d3d-7b5c-411b-afc4-5b9cd207f00a69412f83b08a0fae3ae3bb71cf8ec49e6572ab52d9e825d4cabcd101fb14303c��ܝ�20250628184618_add_automation_system��ܝ�� "
U�
Y ffa21822-0581-4dc6-b92c-66bd6d8c9e40a092d2fd736f01f83a0bfd859dd2cd42cdde9e5dc96a04be6fcea0235396590d���4�20250628174124_add_consultation_system���4��(!
U�
i 9bbcce58-010a-48a9-b2cc-eacf9bb9393cde7a1c6566e8cf5c86a6e79cc4ee46c316e9ed08fb97edad44ef32104950fd44���z20250627215012_add_subscription_plans_phase_3b���1�!
U�
[ 4865b953-acaf-4611-9b5f-5eef99f5dbb1631160fbb9cdf9793033194a8af1e4782148ec19fdded7b429914d7f200ef563���.20250627161326_add_client_society_track����%
U�
c 2aa9f150-1d50-4a24-80e5-7c375a8f4a614ccdcbf0ec8addc85b6d407f49f798a8dc6d8572fce2d2826b2be6f803b7ad18����20250627160014_add_33_degree_society_system�����.
U�
u 17080b55-da14-4b47-b6d3-320168577e056db72e7adb811e0175046d025615adf4adea9fea21be572700bf2fd04ce22a9e����20250627154459_add_client_lawyer_relationship_system�����+
U�
o bb539f16-b84b-4236-9302-eead3a446b09ce7f9de3b5311647d99896cb563a77a5d0e7713c082c27a7e4ebc7bc9a343264����20250627151432_add_case_support_and_offers_system�����2
U�
} 64577483-32f4-408a-8530-479c78225fabd98898b9c3c435cbe15da111d9eac79078e60e8702a879496b371ebe5155ed7d����20250627150522_add_comprehensive_legal_platform_features����
U�
W dce2cc0b-f7a0-4808-96c0-9c8f0bb16efa03cc4feae1d9ed42131022c8b512f1623150ceade9f1584676cc2263430416a4���20250626014417_add_case_number_unique�����
U�
U b4504310-c37c-4727-8ff3-23b8ee3ad3e96918beae3b5da1b0c03afe210bfb40421d8858ccad9e47a51bcb98f9b1964b82����20250626014244_add_multi_case_system����
� ���� #PRIV2024002!ENV2024001%2024QCCS4540
� � �?# ? /17%�9 cmcgr3oqq0000vjcg8m4ltykhADW Avocats1234 Rue Sherbrooke OuestMontréalQCH3A 1H5+1 (514) 555-0123info@adwavocats.cahttps://adwavocats.caADW-2024-001�Droit civil, Droit commercial, Droit immobilier, Droit de la famille, Droit du travailpartner��o��o��o
� � ? cmcgr3oqq0000vjcg8m4ltykh
- �
OC� �� ��� Y�+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")�9�a-�qindexcase_assignments_registrationId_userId_keycase_assignmentsMCREATE UNIQUE INDEX "case_assignments_registrationId_userId_key" ON "case_assignments"("registrationId", "userId")�$�--�{tablecase_assignmentscase_assignmentsCREATE 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_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "case_assignments_registrationId_fkey" FOREIGN KEY ("registrationId") REFERENCES "Registration" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "case_assignments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_assignments_assignedBy_fkey" FOREIGN KEY ("assignedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)?�S- indexsqlite_autoindex_case_assignments_1case_assignments+ a�%%�tableRegistrationRegistration]CREATE 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 DEFAUL�� A#�+indexlegal_cases_caseNumber_keylegal_cases_CREATE UNIQUE INDEX "legal_cases_caseNumber_key" ON "legal_cases"("caseNumber")g� 1 � indexlaw_firms_name_keylaw_firmsKCREATE UNIQUE INDEX "law_firms_name_key" ON "law_firms"("name")�W� q9�indeximpersonation_sessions_originalUserId_isActive_keyimpersonation_sessionsJCREATE UNIQUE INDEX "impersonation_sessions_originalUserId_isActive_key" ON "impersonation_sessions"("originalUserId", "isActive")
� �1� indexusers_username_keyusers&CREATE UNIQUE INDEX "users_username_key" ON "users"("username")
� �+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")
� ,= indexsqlite_autoindex_users_1usersQ7�K% indexsqlite_autoindex_Registration_1Registration^ wE indexsqlite_autoindex_law_firms_1law_firms[)�= indexsqlite_autoindex_users_1usersQ���tableusersusersNCREATE 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,
"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,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
) � �� �
r tx}QS7<?5 , � ? A%W ?? ?cmcgwbmjf000avjbsrwe0gdrwMarieTremblaymarie.tremblay@example.com514-555-0101 ��< OtherCLIENTfremailDemo registration for case ENV2024001PENDING����������cmcgwbkyj0000vjbsv0glcolacmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd� ? A%Y ?? ?cmcgwbmit0006vjbsk1kwtvj8MarieTremblaymarie.tremblay@example.com514-555-0101 ��< OtherCLIENTfremailDemo registration for case PRIV2024002PENDING����������cmcgwbkyj0000vjbsv0glcolacmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4�z
?1%[ ?? ?cmcgwart30005vj9spp80pfk8JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case 2024QCCS4540PENDING���KG���KGcmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70005vjx818yw9sv1�x ?1%W ?? ?cmcgwarsn0001vj9sgtjepgp5JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case ENV2024001PENDING���K7���K7cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd� ?=%{ e O cmcgwaq4s0004vjbs05zudlt2PierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING���B����B�[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�{
?9%] Y A cmcgwaq4s000avjbsjvrslqgtRobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED���B����B�[]Sentence seems excessive for the crimeAppeal deadline in 60 days�) ? =%i 9 s M cmcgwaq4s0005vjbsw8kfjap1MarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW���B����B�[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week�x ?1%W ?? ?cmcgwa52j0005vj6caca6ind9JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case ENV2024001PENDING����+����+cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd�y ?1%Y ?? ?cmcgwa51x0001vj6c6sfx11dxJaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case PRIV2024002PENDING��������cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4�{ ?9%] Y A cmcgw396a0007vjc4hz2a39t2RobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED����3����3[]Sentence seems excessive for the crimeAppeal deadline in 60 days� ?=%{ e O cmcgw396a0005vjc43teicejpPierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING����3����3[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�) ? =%i 9 s M cmcgw396a0004vjc4f1043uedMarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW����3����3[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week�) ? =%i 9 s M cmcgvzw0x0006vjx8thw6qeifMarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW��������[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week� ?=%{ e O cmcgvzw0x0005vjx849zfwaxmPierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING��������[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�{ ?9%] Y A cmcgvzw0x0004vjx8t0f7kd33RobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED��������[]Sentence seems excessive for the crimeAppeal deadline in 60 �
1 ����kM/����{]?!
�
�
�
�
m
O
1 ?cmcgwbmog001avjbsug1zzv8q ?cmcgwbmnx0016vjbsrjyj8ohq ?cmcgwbmne0012vjbs6z38vq4d ?cmcgwbmms000yvjbsfl39ecpw ?cmcgwbmm7000uvjbsm7pcfg4c ?cmcgwbmlj000qvjbstx5y1qr2 ?cmcgwbmky000mvjbs7rle8l9m ?cmcgwbmkf000ivjbsu969m114 ?cmcgwbmjw000evjbscolzgi52 ?cmcgwbmjf000avjbsrwe0gdrw ?cmcgwbmit0006vjbsk1kwtvj8 ?cmcgwart30005vj9spp80pfk8
?cmcgwarsn0001vj9sgtjepgp5 ?cmcgwaq4s0004vjbs05zudlt2 ?cmcgwaq4s000avjbsjvrslqgt
?cmcgwaq4s0005vjbsw8kfjap1 ?cmcgwa52j0005vj6caca6ind9 ?cmcgwa51x0001vj6c6sfx11dx ?cmcgw396a0007vjc4hz2a39t2 ?cmcgw396a0005vjc43teicejp ?cmcgw396a0004vjc4f1043ued ?cmcgvzw0x0006vjx8thw6qeif ?cmcgvzw0x0005vjx849zfwaxm ? cmcgvzw0x0004vjx8t0f7kd33
W &
M � � V� ��
����
�
� O 7�(K% indexsqlite_autoindex_achievements_1achievementsj� �%##�]tableuser_badgesuser_badgesgCREATE TABLE "user_badges" (
"id" TE�<�'%%�;tableachievementsachievementsiCREATE 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
)5�&I# indexsqlite_autoindex_user_badges_1user_badgesh�-�#�5tablebadgesbadgeseCREATE 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
)+�$? indexsqlite_autoindex_badges_1badgesf�b�!##� tablecase_offerscase_offerscCREATE TABLE "case_offers" (
"id" TEXT NOT NULL PRIMARY KEY,
"caseId" TEXT NOT NULL,
"lawyerId" TEXT NOT NULL,
"receiverId" TEXT NOT NULL,
"offerType" TEXT NOT NULL,
"message" TEXT,
"proposedRate" REAL,
"estimatedHours" INTEGER,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"expiresAt" DATETIME,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "case_offers_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("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_receiverId_fkey" FOREIGN KEY ("receiverId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)5�"I# indexsqlite_autoindex_case_offers_1case_offersd
H ;� O) indexsqlite_autoindex_lawyer_ratings_1lawyer_ratingsa�0� ))�tablelawyer_ratingslawyer_ratings`CREATE 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_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lawyer_ratings_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lawyer_ratings_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
) �A#�+indexlegal_cases_caseNumb�� A#�+indexlegal_cases_caseNumber_keylegal_cases_CREATE UNIQUE INDEX "legal_cases_caseNumber_key" ON "legal_cases"("caseNumber")� �%##�]tableuser_badgesuser_badgesgCREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_badges_badgeId_fkey" FOREIGN KEY ("badgeId") REFERENCES "badges" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
� �s???? �U cmcgvz25x000pvjx80f2eaphscmcgvz1y70005vjx818yw9sv1cmcgvz1ww0001vjx8aacytjwtcmcgvz1ww0000vjx82ysl0nemREPRESENTThis class action case aligns perfectly with my human rights practice. I offer my services pro bono.PPENDING��������????#�q cmcgvz25x000ovjx89nez2itbcmcgvz1y70004vjx8hl4gu8q0cmcgvz1ww0000vjx82ysl0nemcmcgvz1ww0000vjx82ysl0nemCOLLABORATEI have extensive experience with wrongful conviction appeals and would love to collaborate on this important case.,xPENDING��������
� �� ?cmcgvz25x000pvjx80f2eaphs ? cmcgvz25x000ovjx89nez2itb
� p�1
� � � ?)]#Q cmcgvz1yv0007vjx80biiuan1Justice SeekerSubmitted your first case for legal help⚖️ACHIEVEMENT{"action":"submit_case","count":1}2COMMON���� ?+Y O cmcgvz1yz000avjx8nd7n8j61Platform PatronDonated $1000+ to support the platform💎DONATION{"action":"donate","amount":1000} �RARE����( ?-u#W cmcgvz1yz0008vjx8w9rtabeiDavid vs GoliathWon a case against a major corporation or government🏹ACHIEVEMENT{"action":"win_major_case","count":1}�EPIC���� ?)E#W cmcgvz1yz0009vjx82i7tf1hpCase SupporterSupported 25 different cases❤️ACHIEVEMENT{"action":"support_cases","count":25}dCOMMON����
?'C _ cmcgvz1yv0006vjx8s6att3n1Pro Bono HeroCompleted 10 pro bono cases🦸PRO_BONO{"action":"complete_pro_bono","count":10}�RARE����
k �k��� ?cmcgvz1yv0007vjx80biiuan1 ?cmcgvz1yz000avjx8nd7n8j61 ?cmcgvz1yz0008vjx8w9rtabei ?cmcgvz1yz0009vjx82i7tf1hp ? cmcgvz1yv0006vjx8s6att3n1
� �N� W??? cmcgvz26f000uvjx89zp50xaucmcgvz1ww0001vjx8aacytjwtcmcgvz1yv0007vjx80biiuan1�����W??? cmcgvz26f000vvjx82f6zs2sfcmcgvz1ww0000vjx82ysl0nemcmcgvz1yz0008vjx8w9rtabei�����W??? cmcgvz26f000tvjx8tmf15j2mcmcgvz1ww0001vjx8aacytjwtcmcgvz1yv0006vjx8s6att3n1�����
� ��� ?cmcgvz26f000uvjx89zp50xau ?cmcgvz26f000vvjx82f6zs2sf ? cmcgvz26f000tvjx8tmf15j2m
X -
����$ - - - - -
C - � �111�itablecourse_enrollmentscourse_enrollmentstCREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "course_enrollments_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES "courses" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�P�- �otabledonationsdonationspCREATE 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
)1�.E indexsqlite_autoindex_donations_1donationsq �\//�Etablebusiness_profilesbusiness_profilesnCREATE TABLE "business_profiles" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" 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,
CONSTRAINT "business_profiles_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)A�,U/ indexsqlite_autoindex_business_profiles_1business_profileso � A�*U/ indexsqlite_autoindex_user_achievements_1user_achievementsl��)//�Ytableuser_achievementsuser_achievementskCREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_achievements_achievementId_fkey" FOREIGN KEY ("achievementId") REFERENCES "achievements" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=K% indexsqli�'�/ �!tablepaymentspaymentsrCREATE 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,
"paymentId" TEXT,
"status" TEXT NOT NULL DEFAULT 'PENDING',
"metadata" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "payments_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)7�(K% indexsqlite_autoindex_achievements_1achievementsj �%%�;tableachievementsachievementsiCREATE 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
)5�&I/�0C indexsqlite_autoindex_payments_1paymentss
6 6 �G??# )�oE7/1m% cmcgtcmo7000hvjq05iuhgj9icmcgtcjzc0001vjq0gqs732clADW AvocatsLaw FirmLegal ServicesCabinet d'avocats spécialisé en droit civil, commercial et immobilier. Notre équipe expérimentée offre des services juridiques de qualité avec une approche personnalisée./images/lawyers/adw-logo.svghttps://adwavocats.ca+1 (514) 555-0123info@adwavocats.ca1234 Rue Sherbrooke Ouest, Montréal, QC H3A 1H5ADW-2024-0018����������APPROVED�����
� � n ? cmcgtcmo7000hvjq05iuhgj9i
r
� �
�$���� / / / / . . =�:Q+ indexsqlite_autoindex_society_degrees_1society_degrees~�c�7''�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
)9�8M' indexsqlite_autoindex_law_resources_1law_resources|� �5�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
)-�6A indexsqlite_autoindex_courses_1coursesz
� =�4Q+ indexsqlite_autoindex_mentor_sessions_1mentor_sessionsw�^�3++�stablementor_sessionsmentor_sessionsvCREATE 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_mentorId_fkey" FOREIGN KEY ("mentorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "mentor_sessions_menteeId_fkey" FOREIGN KEY ("menteeId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)C�2W1 indexsqlite_autoindex_course_enrollments_1course_enrollmentsu 411�itablecourse_enrollmentscourse_enrollmentstCREATE TABLE "course_enrollments" (
"id" >8�<K% indexsqlite_autoindex_user_degrees_1user_degrees � �%%�5tableuser_degreesuser_degreesCREATE 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,
"notes" TEXT,
CONSTRAINT "user_degrees_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_degrees_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) YQ+ indexsqlite_autoindex_society_degrees_1society_degrees~ ++�atablesociety_degreessociety_degrees}CREATE TABLE "society_degrees" (
"id" TEXT NOT NULL PRIMARY KEY,
"degreeNumber" INTEGER NOT NULL,
"name" TEXT NOT NULL,
"description" TEXT NOT NULL,
"requirements" TEXT NOT NULL,
"xpRequired" INTEGER NOT NULL,
"casesRequired" INTEGER NOT NULL DEFAULT 0,
"badgesRequired" TEXT,
"coursesRequired" TEXT,
"ceremonialText" TEXT,
"symbol" TEXT,
"isActive" BOOLEAN NOT NULL DEFAULT true,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)
�
R �0?G� %3 �w cmcgvz241000ivjx8cvl9ebkqPrison 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"]} �����r����r�@?K�
5 � cmcgvz241000hvjx8aymopyyqConstitutional 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"]}����r����r�h?I� 3 ?S�u cmcgvz241000gvjx8vnxwt0m1Advanced Litigation StrategiesAdvanced techniques for complex litigation and case management.ADVANCEDJustice Robert Chen<�cmcgvz1yz0008vjx8w9rtabei["constitutional_law_fundamentals"]{"modules":["Case Strategy Development","Evidence Presentation","Cross-Examination Techniques","Appeal Procedures"]}+����r����r
� ��� ?cmcgvz241000ivjx8cvl9ebkq ?cmcgvz241000hvjx8aymopyyq ? cmcgvz241000gvjx8vnxwt0m1
n �
� n �!?Q !�+; � cmcgvz251000jvjx843kk2jajR. 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
]��������L?k!�5 y m% cmcgvz251000kvjx884t4h2wcCharter 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�������� ?A �)7/ w% cmcgvz251000lvjx8f7zljj8pEnvironmental Law HandbookBOOKLAND_LAWComprehensive handbook covering environmental protection lawsDr. Emma GreenLegal Education Press���� 978-0-123456-78-9["environment","regulations","land-use","protection"]INTERMEDIATE���������
� ��� ?cmcgvz251000jvjx843kk2jaj ?cmcgvz251000kvjx884t4h2wc ? cmcgvz251000lvjx8f7zljj8p
� ����� !LAWYER LAWYER LAWYER LAWYER LAWYER
9
�
� 9 �K ?M�#%'; %=�9M??cmcgvz7af0005vj94ujm1qwo4Digital Privacy Rights ChallengeConstitutional challenge to government surveillance programs.PRIV2024002class_actionactiveFederal CourtFederal Court of Canadamedium�
j� CIVIL_RIGHTSPrivacy & Digital RightsNORMALn LK@MEDIUMSample case for testing: Constitutional challenge to government surveillance programs.["sample","demo","civil_rights"]��������cmcgtcjzc0001vjq0gqs732clcmcgtcjzc0001vjq0gqs732cl�b ?Q�#!%'; '/�UO??cmcgvz7a70003vj946t0ujejdEnvironmental Justice Class ActionClass action against industrial pollution affecting indigenous communities.ENV2024001class_actionactiveFederal CourtFederal Court of Canadamedium�
j� ENVIRONMENTALEnvironmental LawHIGH7 LK@MEDIUMSample case for testing: Class action against industrial pollution affecting indigenous communities.["sample","demo","environmental"]��������cmcgk36ax0000vjxwf93zgfwicmcgk36ax0000vjxwf93zgfwi� ?[�7%%77 %%�E�-??cmcgvz1y70005vjx818yw9sv1Bordeaux 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"]��������cmcgvz1ww0001vjx8aacytjwtcmcgvz1ww0001vjx8aacytjwt�n ?g�G ;; -�i�!??cmcgvz1y70004vjx8hl4gu8q0Wrongful 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"]��������cmcgvz1ww0000vjx82ysl0nemcmcgvz1ww0000vjx82ysl0nem
� ���� ?cmcgvz7af0005vj94ujm1qwo4 ?cmcgvz7a70003vj946t0ujejd ?cmcgvz1y70005vjx818yw9sv1 ? cmcgvz1y70004vjx8hl4gu8q0
�
�
���' l �7�D_)�sindexlawyer_ratings_lawyerId_userId_caseId_keylawyer_ratingsNCREATE UNIQUE INDEX "lawyer_ratings_lawyerId_userId_caseId_key" ON "lawyer_ratings"("lawyerId", "userId", "caseId")c�C1� indexusers_username_keyusers&CREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y�B+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email") -= indexsqlite_autoindex_users_1users_ �YtableusersusersWCREATE 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,
"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,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)��?A#�+indexlegal_cases_caseNumber_keylegal_casesVCREATE UNIQUE INDEX "legal_cases_caseNumber_key" ON "legal_cases"("caseNumber")6�>I# indexsqlite_autoindex_legal_cases_1legal_cases ��(�=##�tablelegal_caseslegal_cases �CREATE 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,
"riskLevel" TEXT NOT NULL DEFAULT 'MEDIUM',
"publicSummary" TEXT,
"tags" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
"leadLawyerId" TEXT NOT NULL,
"createdBy" TEXT NOT NULL,
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
)
� � ���
�
$ O )�R D ; � �T N�Sa; indexsqlite_autoindex_relationship_milestones_1relationship_milestones ��.�R;;�qtablerelationship_milestonesrelationship_milestones �CREATE TABLE "relationship_milestones" (
"id" TEXT NOT NULL PRIMARY KEY,
"relationshipId" TEXT NOT NULL,
"milestoneType" TEXT NOT NULL,
"title" TEXT NOT NULL,
"description" TEXT,
"date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"amount" REAL,
"isPublic" BOOLEAN N�7�D_)�sindexlawyer_ratings_lawyerId_userId_caseId_keylawyer_ratingsNCREATE UNIQUE INDEX "lawyer_ratings_lawyerId_userId_caseId_key" ON "lawyer_ratings"("lawyerId", "userId", "caseId") f1� indexusers_username_keyusers&CREATE UNIQUE INDEX "users_username_key" ON "users"("username")�.�PCC�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_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT 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_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)��OK'�Eindexcase_supports_userId_caseId_keycase_supports �CREATE UNIQUE INDEX "case_supports_userId_caseId_key" ON "case_supports"("userId", "caseId"):�NM' indexsqlite_autoindex_case_supports_1case_supports ��j�M''�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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "case_supports_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
) 8M%�Iindexuser_degrees_userId_degreeId_keyuser_degrees �CREATE UNIQUE INDEX "user_degrees_userId_degreeId_key" ON "user_degrees"("userId", "degreeId") �M+�Cindexsociety_degrees_degreeNumber_keysociety_degrees �CREATE UNIQUE INDEX "society_degrees_degreeNumber_key" ON "society_degrees"("degreeNumber")�Q�Jo+�indexmentor_sessions_mentorId_menteeId_sessionDate_keymentor_sessions �CREATE UNIQUE INDEX "mentor_sessions_mentorId_menteeId_sessionDate_key" ON "mentor_sessions"("mentorId", "menteeId", "sessionDate")�0�IY1�aindexcourse_enrollments_userId_courseId_keycourse_enrollments �CREATE UNIQUE INDEX "course_enrollments_userId_courseId_key" ON "course_enrollments"("userId", "courseId")�;�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")Z�E+indexbadges_name_keybadgesQCREATE UNIQUE INDEX "badges_name_key" ON "badges"("name")
Y ��Y 7??cmcgvz1ww0001vjx8aacytjwtcmcgvz1yv0007vjx80biiuan17??cmcgvz1ww0000vjx82ysl0nemcmcgvz1yz0008vjx8w9rtabei6?? cmcgvz1ww0001vjx8aacytjwtcmcgvz1yv0006vjx8s6att3n1
~ }
�
2
� f
�2 �J??? # #m #�i cmcgw3fbg0005vjkoo63w65ggcmcgw0bau0002vj9kt3sprq4ecmcgtcjzc0001vjq0gqs732clDIRECT_HIRE���L��0 C �PCONTINGENCYSETTLEDSecured $150,000 settlement for workplace injuryI�SIGNIFICANTExcellent negotiation skills. Got me far more than I expected and handled all the insurance company headaches.���L���L�??? m '�c �? cmcgw3faz0003vjkovofiimvfcmcgw0baj0001vj9k49sksc1kcmcgk36ax0000vjxwf93zgfwiPRO_BONO���;���� PRO_BONOSETTLEDSecured full custody and child support agreementLIFE_CHANGINGDavid took my case pro bono when I had nowhere else to turn. He helped me get full custody of my children and ensured they would be safe. He is a true champion of justice.When I was a single mother with no resources, David Justice stepped up and fought for my children pro bono. We won full custody and my kids are now safe.���;���;�}????) �
'� �u cmcgw3fah0001vjkoiuhq634wcmcgw0b9y0000vj9kmuqzux5mcmcgj2ax40000vjlkn95vza40cmcgvz1y70004vjx8hl4gu8q0PLATFORM_MATCH���)�?h� @F� #�HOURLYWONAll charges dropped after successful motion to suppress evidenceLIFE_CHANGINGSarah Chen literally saved my life. The police violated my rights during the search, and she fought tirelessly to get the evidence thrown out. Professional, compassionate, and incredibly skilled.I was facing serious criminal charges that could have ruined my career and family. Sarah fought for me every step of the way and got all charges dropped. I cannot thank her enough.���)���)�J??? # #m #�i cmcgw0ft50005vje0j7oqk123cmcgw0bau0002vj9kt3sprq4ecmcgtcjzc0001vjq0gqs732clDIRECT_HIRE���� ��0 C �PCONTINGENCYSETTLEDSecured $150,000 settlement for workplace injuryI�SIGNIFICANTExcellent negotiation skills. Got me far more than I expected and handled all the insurance company headaches.���� ���� �??? m '�c �? cmcgw0fst0003vje0bt6n1q51cmcgw0baj0001vj9k49sksc1kcmcgk36ax0000vjxwf93zgfwiPRO_BONO�������� PRO_BONOSETTLEDSecured full custody and child support agreementLIFE_CHANGINGDavid took my case pro bono when I had nowhere else to turn. He helped me get full custody of my children and ensured they would be safe. He is a true champion of justice.When I was a single mother with no resources, David Justice stepped up and fought for my children pro bono. We won full custody and my kids are now safe.��������}????) �
'� �u cmcgw0fsc0001vje09icldaa1cmcgw0b9y0000vj9kmuqzux5mcmcgj2ax40000vjlkn95vza40cmcgvz1y70004vjx8hl4gu8q0PLATFORM_MATCH������?h� @F� #�HOURLYWONAll charges dropped after successful motion to suppress evidenceLIFE_CHANGINGSarah Chen literally saved my life. The police violated my rights during the search, and she fought tirelessly to get the evidence thrown out. Professional, compassionate, and incredibly skilled.I was facing serious criminal charges that could have ruined my career and family. Sarah fought for me every step of the way and got all charges dropped. I cannot thank her enough.����������
M ����kM ?cmcgw3fbg0005vjkoo63w65gg ?cmcgw3faz0003vjkovofiimvf ?cmcgw3fah0001vjkoiuhq634w ?cmcgw0ft50005vje0j7oqk123 ?cmcgw0fst0003vje0bt6n1q51 ? cmcgw0fsc0001vje09icldaa1
� S�
l � ? �
�
b � {�.��T� �
??'%m cmcgw3fe6000nvjko0d3vh9wwcmcgw3fbg0005vjkoo63w65ggCASE_RESOLVEDCase settledSecured $150,000 settlement for workplace injury��0 I� ??-3 cmcgw3fdx000lvjko07l8mhbbcmcgw3fbg0005vjkoo63w65ggCOURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sm�L�*
??%I� cmcgw3fdo000jvjko54yv4gbmcmcgw3fbg0005vjkoo63w65ggCASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��lL�
??'%m cmcgw3fdd000hvjkob78jf1rpcmcgw3faz0003vjkovofiimvfCASE_RESOLVEDCase settledSecured full custody and child support agreement���� � ??-3 cmcgw3fd1000fvjkonlz90jx8cmcgw3faz0003vjkovofiimvfCOURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sm�;�*
??%I� cmcgw3fcs000dvjkoldenx9ygcmcgw3faz0003vjkovofiimvfCASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��l;�
??' �
cmcgw3fci000bvjkolkcfrp5scmcgw3fah0001vjkoiuhq634wCASE_RESOLVEDCase wonAll charges dropped after successful motion to suppress evidence�?h� � ??-3 cmcgw3fc90009vjkob0fla91zcmcgw3fah0001vjkoiuhq634wCOURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sm�)�*
??%I� cmcgw3fbv0007vjkods6iyrghcmcgw3fah0001vjkoiuhq634wCASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��l)�
??'%m cmcgw0fv3000nvje0shtlfpemcmcgw0ft50005vje0j7oqk123CASE_RESOLVEDCase settledSecured $150,000 settlement for workplace injury��0 I� ??-3 cmcgw0fux000lvje0bikqqnnccmcgw0ft50005vje0j7oqk123COURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sk� �*
??%I� cmcgw0fuq000jvje0cj39uf34cmcgw0ft50005vje0j7oqk123CASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��L �
??'%m cmcgw0fuj000hvje0xi1vk8nxcmcgw0fst0003vje0bt6n1q51CASE_RESOLVEDCase settledSecured full custody and child support agreement���� � ??-3 cmcgw0fub000fvje099ihluhacmcgw0fst0003vje0bt6n1q51COURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sk���*
??%I� cmcgw0fu4000dvje0phdw9585cmcgw0fst0003vje0bt6n1q51CASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��K��
??' �
cmcgw0ftx000bvje0kilkim6icmcgw0fsc0001vje09icldaa1CASE_RESOLVEDCase wonAll charges dropped after successful motion to suppress evidence�?h� � ??-3 cmcgw0ftp0009vje0qfxgjkivcmcgw0fsc0001vje09icldaa1COURT_APPEARANCEFirst court hearingAppeared in court for initial hearing and case management�Sk��*
??%I� cmcgw0fth0007vje0lzp5uh0gcmcgw0fsc0001vje09icldaa1CASE_STARTEDInitial consultation completedFirst meeting with client to discuss case details and strategy��K�
� ����kM/����{]?!
� ?cmcgw3fe6000nvjko0d3vh9ww ?cmcgw3fdx000lvjko07l8mhbb ?cmcgw3fdo000jvjko54yv4gbm ?cmcgw3fdd000hvjkob78jf1rp ?cmcgw3fd1000fvjkonlz90jx8 ?cmcgw3fcs000dvjkoldenx9yg
?cmcgw3fci000bvjkolkcfrp5s ?cmcgw3fc90009vjkob0fla91z ?cmcgw3fbv0007vjkods6iyrgh
?cmcgw0fv3000nvje0shtlfpem ?cmcgw0fux000lvje0bikqqnnc ?cmcgw0fuq000jvje0cj39uf34 ?cmcgw0fuj000hvje0xi1vk8nx ?cmcgw0fub000fvje099ihluha ?cmcgw0fu4000dvje0phdw9585 ?cmcgw0ftx000bvje0kilkim6i ?cmcgw0ftp0009vje0qfxgjkiv ? cmcgw0fth0007vje0lzp5uh0g
�
��M�f
�
|
. � � D � � Z V?? cmcgw0fw7000tvje0fphr0y3acmcgj2ax40000vjlkn95vza40dGd����L?? cmcgw0g0n001nvje0hc8atheycmcgvzvyt0000vjx81k9vbo5q����L?? cmcgw0g0b001lvje0gzpsh4iacmcgvzvyu0003vjx878qe6kd7����L?? cmcgw0fzz001jvje0eykzwy9ocmcgvz79u0001vj94w8ytx52x����L
?? cmcgw0fzo001hvje0wlnmv215cmcgvz6ws0000vj94x9t55dmu���zL ?? cmcgw0fzf001fvje05vbando8cmcgvz1ww0001vjx8aacytjwt���mL ?? cmcgw0fz5001dvje0lucffs7ucmcgvz1ww0000vjx82ysl0nem���cL
?? cmcgw0fyv001bvje0deqhvpmfcmcgtcmmo000fvjq0bxls2vfw���XL ?? cmcgw0fyl0019vje0743j9nbtcmcgtcm9p000dvjq0bcl0k8l6���KL?? cmcgw0fyb0017vje0rq48zj8ocmcgtclw7000bvjq0qp9ay77y���@L?? cmcgw0fxz0015vje083by5f6ucmcgtclj00009vjq0cyr0bfk7���3L?? cmcgw0fxq0013vje0i63yilm5cmcgtcl5x0007vjq0ra2x2m70���%L?? cmcgw0fxf0011vje0cs7mpubmcmcgtcksz0005vjq04hjtch8f���L?? cmcgw0fx5000zvje0j4whv5sycmcgtckg20003vjq0m05v47ym��� K? cmcgw0fwu000xvje0g2p4uoiwcmcgtcjzc0001vjq0gqs732cld �X?? cmcgw0fwu000xvje0g2p4uoiwcmcgtcjzc0001vjq0gqs732cld��d������W?? cmcgw0fwk000vvje0b6xt0rnocmcgk36ax0000vjxwf93zgfwid8+�d����
! ����kM/����{]?! ?cmcgw0g0n001nvje0hc8athey ?cmcgw0g0b001lvje0gzpsh4ia ?cmcgw0fzz001jvje0eykzwy9o ?cmcgw0fzo001hvje0wlnmv215
?cmcgw0fzf001fvje05vbando8 ?cmcgw0fz5001dvje0lucffs7u ?cmcgw0fyv001bvje0deqhvpmf
?cmcgw0fyl0019vje0743j9nbt ?cmcgw0fyb0017vje0rq48zj8o ?cmcgw0fxz0015vje083by5f6u ?cmcgw0fxq0013vje0i63yilm5 ?cmcgw0fxf0011vje0cs7mpubm ?cmcgw0fx5000zvje0j4whv5sy ?cmcgw0fwu000xvje0g2p4uoiw ?cmcgw0fwk000vvje0b6xt0rno ? cmcgw0fw7000tvje0fphr0y3a
��� f +'S� �1�Y//�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_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "degree_ceremonies_userDegreeId_fkey" FOREIGN KEY ("userDegreeId") REFERENCES "user_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)� �X?%�'indexlawyer_stats_lawyerId_keylawyer_stats �CREATE UNIQUE INDEX "lawyer_stats_lawyerId_key" ON "lawyer_stats"("lawyerId")F�WY3 indexsqlite_autoindex_client_testimonials_1client_testimonials ��.�R;;�qtablerelationship_milestonesrelationship_milestones �CREATE TABLE "relationship_milestones" (
"id" TEXT NOT NULL PRIMARY KEY,
"relationshipId" TEXT NOT NULL,
"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
)V�QiC indexsqlite_autoindex_client_lawyer_relationships_1client_lawyer_relationships �� �V33�%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_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("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_relationshipId_fkey" FOREIGN KEY ("relationshipId") REFERENCES "client_lawyer_relationships" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "client_testimonials_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)8�UK% indexsqlite_autoindex_lawyer_stats_1lawyer_stats ��E�T%%�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
)N�Sa; indexsqlite_autoindex_relationship_milestones_1relationship_milestones �
�
Wn� �=???? G� �� !' cmcgw3fez000rvjkor0b2sm5scmcgw0baj0001vj9k49sksc1kcmcgk36ax0000vjxwf93zgfwicmcgw3faz0003vjkovofiimvfPro Bono Hero - David JusticeAs a single mother with limited resources, I thought I would never be able to afford a good lawyer to help me get custody of my children. David Justice took my case pro bono and fought as hard as if I was paying him millions. He secured full custody and child support, ensuring my children would be safe and provided for. David truly lives up to his name - he is justice personified.Single mother unable to afford legal help, children in unsafe situationFull custody secured, children safe, child support establishedFAMILY_LAWLIFE_CHANGING�������˅f?????I�/� �-' cmcgw3fei000pvjkovkwzwig5cmcgw0b9y0000vj9kmuqzux5mcmcgj2ax40000vjlkn95vza40cmcgw3fah0001vjkoiuhq634wcmcgvz1y70004vjx8hl4gu8q0How Sarah Chen Saved My FutureI was facing serious criminal charges that could have destroyed my career and family. Sarah Chen took my case and immediately got to work. She discovered that the police had violated my constitutional rights during the search of my property. Her meticulous attention to detail and aggressive defense strategy led to all charges being dropped. Sarah is not just a lawyer - she is a fighter for justice.Facing multiple felony charges with potential 10+ year sentenceAll charges dropped, record cleared, career and family intactCRIMINAL_DEFENSELIFE_CHANGING���������=???? G� �� !' cmcgw0fvp000rvje0hsc078o0cmcgw0baj0001vj9k49sksc1kcmcgk36ax0000vjxwf93zgfwicmcgw0fst0003vje0bt6n1q51Pro Bono Hero - David JusticeAs a single mother with limited resources, I thought I would never be able to afford a good lawyer to help me get custody of my children. David Justice took my case pro bono and fought as hard as if I was paying him millions. He secured full custody and child support, ensuring my children would be safe and provided for. David truly lives up to his name - he is justice personified.Single mother unable to afford legal help, children in unsafe situationFull custody secured, children safe, child support establishedFAMILY_LAWLIFE_CHANGING����e����e�f?????I�/� �-' cmcgw0fvc000pvje0sxvof0edcmcgw0b9y0000vj9kmuqzux5mcmcgj2ax40000vjlkn95vza40cmcgw0fsc0001vje09icldaa1cmcgvz1y70004vjx8hl4gu8q0How Sarah Chen Saved My FutureI was facing serious criminal charges that could have destroyed my career and family. Sarah Chen took my case and immediately got to work. She discovered that the police had violated my constitutional rights during the search of my property. Her meticulous attention to detail and aggressive defense strategy led to all charges being dropped. Sarah is not just a lawyer - she is a fighter for justice.Facing multiple felony charges with potential 10+ year sentenceAll charges dropped, record cleared, career and family intactCRIMINAL_DEFENSELIFE_CHANGING����X����X
� ���� ?cmcgw3fez000rvjkor0b2sm5s ?cmcgw3fei000pvjkovkwzwig5 ?cmcgw0fvp000rvje0hsc078o0 ? cmcgw0fvc000pvje0sxvof0ed
! ����kM/����{]!? ?cmcgvzvyt0000vjx81k9vbo5q ?cmcgvzvyu0003vjx878qe6kd7 ?cmcgvz79u0001vj94w8ytx52x ?cmcgvz6ws0000vj94x9t55dmu
?cmcgvz1ww0001vjx8aacytjwt ?cmcgvz1ww0000vjx82ysl0nem ?cmcgtcmmo000fvjq0bxls2vfw
?cmcgtcm9p000dvjq0bcl0k8l6 ?cmcgtclw7000bvjq0qp9ay77y ?cmcgtclj00009vjq0cyr0bfk7 ?cmcgtcl5x0007vjq0ra2x2m70 ?cmcgtcksz0005vjq04hjtch8f ?cmcgtckg20003vjq0m05v47ym ?cmcgtcjzc0001vjq0gqs732cl ?cmcgk36ax0000vjxwf93zgfwi ? cmcgj2ax40000vjlkn95vza40
� � 9M���
v
1� � �K x x x F�dY3 indexsqlite_autoindex_new_society_degrees_1new_society_degrees ���a//�9tablelodge_membershipslodge_memberships �CREATE TABLE "lodge_memberships" (
"id" TEXT NOT NULL �\�c++�mtablesociety_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,
"winRateRequ�p�f%%�#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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_degrees_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)��]33�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
)F�^Y3 indexsqlite_autoindex_mentorship_sessions_1mentorship_sessions � ~ N�\a; indexsqlite_autoindex_brotherhood_mentorships_1brotherhood_mentorships ��h�[;;�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_mentorId_fkey" FOREIGN KEY ("mentorId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "brotherhood_mentorships_menteeId_fkey" FOREIGN KEY ("menteeId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "brotherhood_mentorships_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)B�ZU/ indexsqlite_autoindex_degree_ceremonies_1degree_ceremonies � �//�tabledegree_ceremoniesdegree_ceremonies �CREATE TABLE "degree_ceremonies" (
"id" TEXT NOT NULL PRIM>�dQ+ indexsqlite_autoindex_society_degrees_1society_degrees �B�bU/ indexsqlite_autoindex_lodge_memberships_1lodge_memberships ���a//�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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "lodge_memberships_lodgeId_fkey" FOREIGN KEY ("lodgeId") REFERENCES "lodges" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)
; �
� � �
; �J ?; �I� � cmcgvz21n000fvjx86z6jbsro!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���� � ?' ��# o cmcgvz21n000dvjx8f8t740b9Master 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����� ? 3 �3O � cmcgvz21n000cvjx8ugh0ditqInitiate 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 � cmcgvz21n000bvjx8td32907hSeeker 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�����" ?1 �� � cmcgvz21n000evjx8aczg57wdGuardian 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����
� ���[�� � �;D?C'� 'O�eAg / ?cmcgtclj00009vjq0cyr0bfk7sophie.dubois@adwavocats.caSophie Dubois$2a$12$/r9KZ68VkpLb3jKftCu1UuRMMCeSVgYWGNa2U6DuS/EN4qGYszKYaLAWYER����������sophie.dubois/images/lawyers/sophie-dubois.jpgSophie Dubois se spécialise en droit civil et en droit des successions. Elle aide ses clients à planifier leur succession et à résoudre des litiges familiaux complexes.AvocateDroit civil et successions12349Université de Sherbrooke - Faculté de droitMontréal+1 (514) 555-0105lightfrcmcgr3oqq0000vjcg8m4ltykh�D?=!� !I�S-e / ?cmcgtcl5x0007vjq0ra2x2m70david.chen@adwavocats.caDavid Chen$2a$12$TnkvUprPAoNO4Fp/15jtVeJAIzgkaFxFzTbGQtYFe6IiGq7Ym2LBiLAWYER����%����%david.chen/images/lawyers/david-chen.jpgDavid Chen se spécialise en droit du travail. Il représente tant les employeurs que les employés dans des litiges complexes en matière de relations de travail.AvocatDroit du travail12348Université de Montréal - Faculté de droitMontréal+1 (514) 555-0104lightfrcmcgr3oqq0000vjcg8m4ltykh�[D?S7� 7_�3W / ?cmcgtcksz0005vjq04hjtch8fmarie-claude.tremblay@adwavocats.caMarie-Claude Tremblay$2a$12$llf5UMgg.Qk0QnPUyK66VudJ7AVtgofc156FUujX6mvHRy7EJEfsmLAWYER����R����Rmarie-claude.tremblay/images/lawyers/marie-claude-tremblay.jpgMarie-Claude Tremblay se spécialise en droit de la famille. Elle accompagne ses clients avec empathie dans des situations souvent difficiles, en privilégiant les solutions à l'amiable.AvocateDroit de la famille12347Université Laval - Faculté de droitMontréal+1 (514) 555-0103lightfrcmcgr3oqq0000vjcg8m4ltykh�=D?=!� !I� IY / ?cmcgtckg20003vjq0m05v47ymjustin.wee@adwavocats.caJustin Wee$2a$12$cpCU7V8i/0/D0MfOdpb5BuuEk2EAFmh1qN4qiaiP6y45jTb4Zfl7SLAWYER����������justin.wee/images/lawyers/justin-wee.jpgJustin Wee est associé chez ADW Avocats, spécialisé en droit immobilier et commercial. Il conseille des clients dans des transactions immobilières complexes et des litiges commerciaux.AssociéDroit immobilier et commercial12346Université McGill - Faculté de droitMontréal+1 (514) 555-0102lightfrcmcgr3oqq0000vjcg8m4ltykh�D?I-� -U�e5?e / ?cmcgtcjzc0001vjq0gqs732claudrey.labrecque@adwavocats.caAudrey Labrecque$2a$12$FR7DX4a3OS2333TxFAKqDOt2lfnQQ7HprSQGakT6Lq8zIZZjaLVjuLAWYER����'����'audrey.labrecque/images/lawyers/audrey-labrecque.jpgAudrey Labrecque est associée principale chez ADW Avocats. Elle se spécialise en droit civil et commercial avec plus de 12 ans d'expérience. Elle a plaidé avec succès de nombreux dossiers complexes devant les tribunaux québécois.Associée principaleDroit civil et commercial12345 Université de Montréal - Faculté de droitMontréal+1 (514) 555-0101lightfrcmcgr3oqq0000vjcg8m4ltykh�C?1 � += ! cmcgk36ee0001vjxw6rfrkd2kclient@example.comJane Doe$2a$10$VrvDVfFRrpzC4/sMvF/vs.k.WNxccIlk60iIFTg7y6S810dLQ3NrmCLIENT���W&���1%lightfemale+1-438-555-9876456 Elm St, Montreal, QC �=�� Accountanten�&C?1!� % 1O?+UQ +?!+ cmcgk36ax0000vjxwf93zgfwilawyer@example.comJohn Smith$2a$10$z08cjJKgTBjUHyKZvu9glOvCfjySTcXSw5Z9Y47/vckDDv9gF5ZoaLAWYER���V����V�Criminal LawBAR123456 Harvard Law SchoolCertified Criminal Law Specialist123 Main St, Montreal, QC+1-514-555-1234https://linkedin.com/in/johnsmithlawhttps://adw-lawyers.com/john-smith �@������@������?�p��
=qxn
@333333� @^ @ @ffffff.��PREMIUMlightmale+1-514-555-1234123 Main St, Montreal, QCJane Smith+1-514-555-5678 L.r� Lawyeren�B?/!# cmcgj2ax40000vjlkn95vza40admin@example.comAdmin Userpassword123ADMIN������ � �
} ����kM/����{]?
�!
�
�
�
m
O
1
� � � � } ?cmcgx0r7z0000vjcghrbty6il ?cmcgwbmi50004vjbsodualz0j ?cmcgwbm4r0003vjbswoy2zxrz ?cmcgwblrj0002vjbsp9mq6vca ?cmcgwblck0001vjbsadc46bi0 ?cmcgwbkyj0000vjbsv0glcola ?cmcgw0bbf0004vj9kpj52nge7 ?cmcgw0bb40003vj9k7ujybngt ?cmcgw0bau0002vj9kt3sprq4e ?cmcgw0baj0001vj9k49sksc1k ?cmcgw0b9y0000vj9kmuqzux5m ?cmcgvzvyt0000vjx81k9vbo5q ?cmcgvzvyu0003vjx878qe6kd7 ?cmcgvzvyu0001vjx8bgd56xci ?cmcgvzvyu0002vjx8cm1h0307 ?cmcgvz79u0001vj94w8ytx52x ?cmcgvz6ws0000vj94x9t55dmu ?cmcgvz1ww0001vjx8aacytjwt
?cmcgvz1ww0000vjx82ysl0nem ?cmcgtcmmo000fvjq0bxls2vfw ?cmcgtcm9p000dvjq0bcl0k8l6
?cmcgtclw7000bvjq0qp9ay77y ?cmcgtclj00009vjq0cyr0bfk7 ?cmcgtcl5x0007vjq0ra2x2m70 ?cmcgtcksz0005vjq04hjtch8f ?cmcgtckg20003vjq0m05v47ym ?cmcgtcjzc0001vjq0gqs732cl ?cmcgk36ee0001vjxw6rfrkd2k ?cmcgk36ax0000vjxwf93zgfwi ? cmcgj2ax40000vjlkn95vza40
� � ��G[P,
��r �=== �,�rY+�aindexsociety_degrees_degreeNumber_track_keysociety_degrees}CREATE UNIQUE INDEX "society_degrees_degreeNumber_track_key" ON "society_degrees"("degreeNumber", "track")�)�lU/�Yindexlodge_memberships_userId_lodgeId_keylodge_memberships �CREATE UNIQUE INDEX "lodge_memberships_userId_lodgeId_key" ON "lodge_memberships"("userId", "lodgeId")� /+indexlodges_name_keylodges �C�s ,�n? indexsqlite_autoindex_lodges_1lodges ��h�jy;�'indexbrotherhood_mentorships_mentorId_menteeId_degreeId_keybrotherhood_mentorships �CREATE UNIQUE INDEX "brotherhood_mentorships_mentorId_menteeId_degreeId_key" ON "brotherhood_mentorships"("mentorId", "menteeId", "degreeId")� �iQ/�Kindexdegree_ceremonies_userDegreeId_keydegree_ceremonies �CREATE UNIQUE INDEX "degree_ceremonies_userDegreeId_key" ON "degree_ceremonies"("userDegreeId")��hM%�Iindexuser_degrees_userId_degreeId_keyuser_degreesCREATE UNIQUE INDEX "user_degrees_userId_degreeId_key" ON "user_degrees"("userId", "degreeId")�%%�#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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_degrees_degreeId_fkey" FOREIGN KEY ("degreeId") REFERENCES "society_degrees" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)� S-�m 8�gK% indexsqlite_autoindex_user_degrees_1user_degrees �
] �M+�Cindexsociety_degrees_degreeNumber_keysociety_degrees}CREATE UNIQUE INDEX "society_degrees_degreeNumber_key" 2�tE indexsqlite_autoindex_new_users_1new_users �>�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
) IY3 indexsqlite_autoindex_new_society_degrees_1new_society_degrees �[�o+indexlodges_name_keylodges �CREATE UNIQUE INDEX "lodges_name_key" ON "lodges"("name")�x�m�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
)
k ����k ?cmcgvz21n000fvjx86z6jbsro ?cmcgvz21n000dvjx8f8t740b9 ?cmcgvz21n000cvjx8ugh0ditq ?cmcgvz21n000bvjx8td32907h ? cmcgvz21n000evjx8aczg57wd
� ��,��} >�zQ+ indexsqlite_autoindex_escrow_releases_1escrow_releases �� �w++�qtableescrow_accountsescrow_accountsWCREATE TABLE "escrow_accou� �w++�qtableescrow_accountsescrow_accountsWCREATE 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,
CONSTRAINT "escrow_accounts_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("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_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)c�v1� indexusers_username_keyusers&CREATE UNIQUE INDEX "users_username_key" ON "users"("username")Y�u+indexusers_email_keyusersCREATE UNIQUE INDEX "users_email_key" ON "users"("email")*�t= indexsqlite_autoindex_users_1users ��G�s�ktableusersusers �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,
"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,
CONSTRAINT "users_lawFirmId_fkey" FOREIGN KEY ("lawFirmId") REFERENCES "law_firms" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
2
����D 2�
$� � � �^�}++�qtablepayment_refundspayment_refunds �CREATE 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_paymentId_fkey" FOREIGN KEY ("paymentId") REFERENCES "payments" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "payment_refunds_requestedBy_fkey" FOREIGN KEY ("requestedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "payment_refunds_approvedBy_fkey" FOREIGN KEY ("approvedBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)>�~Q+ indexsqlite_autoindex_payment_refunds_1payment_refunds ��k�{%%�tabletransactionstransactions �CREATE 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_paymentId_fkey" FOREIGN KEY ("paymentId") REFERENCES "payments" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "transactions_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)8�|K% indexsqlite_autoindex_transactions_1transactions �
� >�zQ+ indexsqlite_autoindex_escrow_releases_1escrow_releases ��c�y++�{tableescrow_releasesescrow_releases �CREATE 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_escrowId_fkey" FOREIGN KEY ("escrowId") REFERENCES "escrow_accounts" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "escrow_releases_approvedBy_fkey" FOREIGN KEY ("approvedBy") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)=�xQ+ indexsqlite_autoindex_escrow_accounts_1escrow_accounts_ 4++�qtableescrow_accountsescrow_accountsWCREATE 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,
"autoReleaseDaF�Y3 indexsqlite_autoindex_financial_summaries_1financial_summaries ��X�77�Mtablesociety_pricing_tierssociety_pricing_tiers �CREATE TABLE "soc�X�77�Mtablesociety_pricing_tierssociety_pricing_tiers �CREATE 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
)
� �A�
� ��� �'�11�wtableuser_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,
"metadata" TEXT,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "user_subscriptions_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "user_subscriptions_planId_fkey" FOREIGN KEY ("planId") REFERENCES "subscription_plans" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)D�W1 indexsqlite_autoindex_user_subscriptions_1user_subscriptions ���11�Wtablesubscription_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,
"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
)D�W1 indexsqlite_autoindex_subscription_plans_1subscription_plans � � F�Y3 indexsqlite_autoindex_financial_summaries_1financial_summaries ��Q�33�Gtablefinancial_summariesfinancial_summaries �CREATE 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
)J� ]7 indexsqlite_autoindex_society_pricing_tiers_1society_pricing_tiers � 77�Mtablesociety_pricing_tierssociety_pricing_tiers �CREATE 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
)>�~Q8�K% indexsqlite_autoindex_new_payments_1new_payments �
� �
�
� � x�L����V� J�]7 indexsqlite_autoindex_consultation_bookings_1consultation_bookings džu�++�!tableBusinessProfileBusinessProfilenCREATE TABLE "BusinessProf�u�++�!tableBusinessProfileBusinessProfilenCREATE TABLE "BusinessProfile" (
"id" TEXT NOT NULL PRIMARY KEY,
"userId" 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)�*�U1�Yindexuser_subscriptions_userId_planId_keyuser_subscriptions �CREATE UNIQUE INDEX "user_subscriptions_userId_planId_key" ON "user_subscriptions"("userId", "planId")�<�c1�oindexuser_subscriptions_stripeSubscriptionId_keyuser_subscriptions �CREATE UNIQUE INDEX "user_subscriptions_stripeSubscriptionId_key" ON "user_subscriptions"("stripeSubscriptionId")� �C1�/indexsubscription_plans_name_keysubscription_plans �CREATE UNIQUE INDEX "subscription_plans_name_key" ON "subscription_plans"("name")��I3�;indexfinancial_summaries_userId_keyfinancial_summaries �CREATE UNIQUE INDEX "financial_summaries_userId_key" ON "financial_summaries"("userId")��
I7�;indexsociety_pricing_tiers_name_keysociety_pricing_tiers �CREATE UNIQUE INDEX "society_pricing_tiers_name_key" ON "society_pricing_tiers"("name")� � Q+�Kindexpayment_refunds_stripeRefundId_keypayment_refunds �CREATE UNIQUE INDEX "payment_refunds_stripeRefundId_key" ON "payment_refunds"("stripeRefundId")�� A+�+indexescrow_accounts_caseId_keyescrow_accounts �CREATE UNIQUE INDEX "escrow_accounts_caseId_key" ON "escrow_accounts"("caseId")��
C �/indexpayments_stripeChargeId_keypaymentssCREATE UNIQUE INDEX "payments_stripeChargeId_key" ON "payments"("stripeChargeId")�� Q �Kindexpayments_stripePaymentIntentId_keypaymentsrCREATE UNIQUE INDEX "payments_stripePaymentIntentId_key" ON "payments"("stripePaymentIntentId")0�C indexsqlite_autoindex_payments_1payments ��k� �'tablepaymentspayments �CREATE 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "payments_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "payments_escrowId_fkey" FOREIGN KEY ("escrowId") REFERENCES "escrow_accounts" ("id") ON DELETE SET NULL ON UPDATE CASCADE
) GW1 indexsqlite_autoindex_user_subscriptions_1user_subscriptions �
�
, -�/ �
???# �s cmcgw3hhy0009vj4won64miq6cmcgk36ax0000vjxwf93zgfwicmcgw0b9y0000vj9kmuqzux5m��b/309:00xREAL_ESTATECONFIRMEDReal estate transaction consultation. Need help with contract review. ��https://teams.microsoft.com/l/meetup-join/123456789TEAMS���V���V�I ??? � cmcgw3hhq0007vj4wyh43242jcmcgk36ax0000vjxwf93zgfwicmcgw0b9y0000vj9kmuqzux5m���311:30-CORPORATEPENDINGNeed advice on corporate restructuring and legal compliance., ����O���O�/??? y �s cmcgw3hhj0005vj4wbsm93p79cmcgk36ax0000vjxwf93zgfwicmcgw0b9y0000vj9kmuqzux5m��ȿ316:00<FAMILYCOMPLETEDFamily law consultation regarding divorce proceedings. � �Client was very cooperative. Discussed settlement options.Good potential for mediation. Follow up in 2 weeks.���G���G�|??? �1C cmcgw3hhc0003vj4wl94q3lqccmcgk36ax0000vjxwf93zgfwicmcgw0b9y0000vj9kmuqzux5m��;�314:00ZCIVILCONFIRMEDI have a civil dispute that I need help resolving. Looking forward to our meeting. �whttps://zoom.us/j/123456789ZOOM���@���@�`??? �5 cmcgw3hh30001vj4wtc9q7t9mcmcgk36ax0000vjxwf93zgfwicmcgw0b9y0000vj9kmuqzux5m��w310:00<CRIMINALPENDINGI need legal advice regarding a criminal case. Please help me understand my options. � ����7���7�???# �s cmcgk36fn000bvjxwtcb70gtwcmcgk36ax0000vjxwf93zgfwicmcgk36ee0001vjxw6rfrkd2k��.k-09:00xREAL_ESTATECONFIRMEDReal estate transaction consultation. Need help with contract review. ��https://teams.microsoft.com/l/meetup-join/123456789TEAMS���WS���WS�I??? � cmcgk36fd0009vjxwc9vcibsjcmcgk36ax0000vjxwf93zgfwicmcgk36ee0001vjxw6rfrkd2k����-11:30-CORPORATEPENDINGNeed advice on corporate restructuring and legal compliance., ����WI���WI�/??? y �s cmcgk36f40007vjxwsftuy887cmcgk36ax0000vjxwf93zgfwicmcgk36ee0001vjxw6rfrkd2k����-16:00<FAMILYCOMPLETEDFamily law consultation regarding divorce proceedings. � �Client was very cooperative. Discussed settlement options.Good potential for mediation. Follow up in 2 weeks.���WA���WA�|??? �1C cmcgk36ew0005vjxwzedaoawkcmcgk36ax0000vjxwf93zgfwicmcgk36ee0001vjxw6rfrkd2k��-14:00ZCIVILCONFIRMEDI have a civil dispute that I need help resolving. Looking forward to our meeting. �whttps://zoom.us/j/123456789ZOOM���W8���W8�`??? �5 cmcgk36en0003vjxwzuzcr1gpcmcgk36ax0000vjxwf93zgfwicmcgk36ee0001vjxw6rfrkd2k���-10:00<CRIMINALPENDINGI need legal advice regarding a criminal case. Please help me understand my options. � ����W0���W0
� ����kM/�� ?cmcgw3hhy0009vj4won64miq6
?cmcgw3hhq0007vj4wyh43242j ?cmcgw3hhj0005vj4wbsm93p79 ?cmcgw3hhc0003vj4wl94q3lqc ?cmcgw3hh30001vj4wtc9q7t9m ?cmcgk36fn000bvjxwtcb70gtw ?cmcgk36fd0009vjxwc9vcibsj ?cmcgk36f40007vjxwsftuy887 ?cmcgk36ew0005vjxwzedaoawk ? cmcgk36en0003vjxwzuzcr1gp
M � � h�{�M�� N�a; indexsqlite_autoindex_document_collaborations_1document_collaborations � J >�Q+ indexsqlite_autoindex_calendar_events_1calendar_events ̉i�++�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,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL,
CONSTRAINT "calendar_events_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "calendar_events_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "calendar_events_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT 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_assignedTo_fkey" FOREIGN KEY ("assignedTo") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "tasks_assignedBy_fkey" FOREIGN KEY ("assignedBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "tasks_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)J�]7 indexsqlite_autoindex_consultation_bookings_1consultation_bookings Lj�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_lawyerId_fkey" FOREIGN KEY ("lawyerId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "consultation_bookings_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)=�Q+ indexsqlite_autoindex_BusinessProfile_1BusinessProfileo
� ��
R �q����2 �_?1[1 ? ? cmcgvzljz000dvjic4cqrqopwDiscovery DeadlineDeadline for completing discovery phaseDISCOVERY_DEADLINE�^�17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED���V����V�`?/U ? ?- cmcgvzljs000bvjichpmx55nzMediation SessionMediation session to resolve disputeMEDIATION��k�14:0016:00xMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiMediation CenterSCHEDULED���V����V
?Cu!? ?E cmcgvzljj0009vjiccukl784uDeposition - Expert WitnessDeposition of expert witness in personal injury caseDEPOSITION�Ҭ"�10:0012:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiLaw Office - Deposition RoomCONFIRMED���V����VЁy ?Ym+ ? ? cmcgvzljb0007vjic5562bsx2Filing Deadline - Motion for DiscoveryDeadline to file motion for additional discoveryFILING_DEADLINE��_j�17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED���V����VȂ ?Cg)? ?= cmcgvzlj10005vjicrlhcp6sqClient Meeting - Jane SmithFollow-up meeting to discuss settlement offerCLIENT_MEETING��ڣ13:0014:30ZMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiClient Office - DowntownSCHEDULED���V����V��
?WS'? ?M 7 cmcgvzliu0003vjictqgw7nb7Court Hearing - Smith vs. CorporationMotion hearing for summary judgmentCOURT_HEARING����09:0011:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiQuebec Superior Court - Room 301Quebec Superior CourtCONFIRMED���V����V��S ?I� %???A U cmcgvzlil0001vjicqstpk53tClient Consultation - John DoeInitial consultation with client regarding personal injury caseCONSULTATION��Z3�14:0015:00<MEDIUMcmcgvz1y70004vjx8hl4gu8q0cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwiOffice - Conference Room Ahttps://meet.google.com/abc-defg-hijSCHEDULED���V����V�� ?;�% ?A U cmcgl0dmp000fvjk4uayr0q4qNew Client ConsultationInitial consultation for potential new employment law caseCONSULTATION���I�15:0017:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Consultation Roomhttps://meet.google.com/new-case-123SCHEDULED�������F?1[1 ? cmcgl0dmf000dvjk4yirmdwagDiscovery DeadlineDeadline for completing discovery phaseDISCOVERY_DEADLINE����17:0018:00<CRITICALcmcgk36ax0000vjxwf93zgfwiSCHEDULED���������G?/U ?- cmcgl0dm5000bvjk4v4cb9v0jMediation SessionMediation session to resolve disputeMEDIATION��R��14:0016:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiMediation CenterSCHEDULED��������l?Cu! ?E cmcgl0dlu0009vjk4pyww9me0Deposition - Expert WitnessDeposition of expert witness in personal injury caseDEPOSITION�ђŹ10:0012:00xHIGHcmcgk36ax0000vjxwf93zgfwiLaw Office - Deposition RoomCONFIRMED��������`?Ym+ ? cmcgl0dll0007vjk4x98bno67Filing Deadline - Motion for DiscoveryDeadline to file motion for additional discoveryFILING_DEADLINE��F
�17:0018:00<CRITICALcmcgk36ax0000vjxwf93zgfwiSCHEDULED�������فg?Cg) ?= cmcgl0dlb0005vjk4etcgwi1bClient Meeting - Jane SmithFollow-up meeting to discuss settlement offerCLIENT_MEETING���}�13:0014:30ZMEDIUMcmcgk36ax0000vjxwf93zgfwiClient Office - DowntownSCHEDULED�������Ђ?WS' ?M 7 cmcgl0dl40003vjk4xd945azkCourt Hearing - Smith vs. CorporationMotion hearing for summary judgmentCOURT_HEARING���U�09:0011:00xHIGHcmcgk36ax0000vjxwf93zgfwiQuebec Superior Court - Room 301Quebec Superior CourtCONFIRMED�������Ȃ! ?I� % ?A U cmcgl0dkv0001vjk4ladytpz5Client Consultation - John DoeInitial consultation with client regarding personal injury caseCONSULTATION��@ֹ14:0015:00<MEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Conference Room Ahttps://meet.google.com/abc-defg-hijSCHEDULED���� �
1 ����kM/����{]?!
�
�
�
�
m
O
1 ?cmcgw3glw000fvj38mhgttxih ?cmcgw3glo000dvj38o49ura6g ?cmcgw3glg000bvj385z8zc37a ?cmcgw3gl40009vj38a67qy7kt ?cmcgw3gku0007vj38ku5amzw5 ?cmcgw3gkn0005vj38b4h30m6j ?cmcgw3gke0003vj38k2zooso5 ?cmcgw3gk40001vj38028wls7h ?cmcgvzlk9000fvjicucewi1al ?cmcgvzljz000dvjic4cqrqopw ?cmcgvzljs000bvjichpmx55nz ?cmcgvzljj0009vjiccukl784u
?cmcgvzljb0007vjic5562bsx2 ?cmcgvzlj10005vjicrlhcp6sq ?cmcgvzliu0003vjictqgw7nb7
?cmcgvzlil0001vjicqstpk53t ?cmcgl0dmp000fvjk4uayr0q4q ?cmcgl0dmf000dvjk4yirmdwag ?cmcgl0dm5000bvjk4v4cb9v0j ?cmcgl0dlu0009vjk4pyww9me0 ?cmcgl0dll0007vjk4x98bno67 ?cmcgl0dlb0005vjk4etcgwi1b ?cmcgl0dl40003vjk4xd945azk ? cmcgl0dkv0001vjk4ladytpz5
� � 5�Wh+� � 4 4 @�&S- indexsqlite_autoindex_automation_tasks_1automation_tasks � � ��$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")��"A+�+indexBusinessProfile_userId_keyBusinessProfile �CREATE UNIQUE INDEX "BusinessProfile_userId_key" ON "BusinessProfile"("userId"):�!M' indexsqlite_autoindex_notifications_1notifications Յ$� ''�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
)D� W1 indexsqlite_autoindex_analytics_tracking_1analytics_tracking ӄ}� 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_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "analytics_tracking_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)<� O) indexsqlite_autoindex_client_portals_1client_portals ц� ))�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_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "client_portals_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)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_createdBy_fkey" FOREIGN KEY ("createdBy") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT "document_collaborations_assignedTo_fkey" FOREIGN KEY ("assignedTo") REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT "document_collaborations_caseId_fkey" FOREIGN KEY ("caseId") REFERENCES "legal_cases" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)
� � ? cmcgtcjzc0001vjq0gqs732cl
g ' � A��w�6 ��! g �6�0]1�iindexDocumentPermission_documentId_userId_keyDocumentPermission �CREATE UNIQUE INDEX "DocumentPermission_documentId_userId_key" ON "DocumentPermission"("documentId", "userId")�-�/Y+�aindexDocumentVersion_documentId_version_keyDocumentVersion �CREATE UNIQUE INDEX "DocumentVersion_documentId_version_key" ON "DocumentVersion"("documentId", "version")D�.W1 indexsqlite_autoindex_DocumentPermission_1DocumentPermission ��+++�gtableDocumentCommentDocumentComment �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 "Document" ("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_DocumentComment_1DocumentComment �H�)++�EtableDocumentVersionDocumentVersion �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 "Document" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "DocumentVersion_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "users" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)>�*Q+ indexsqlite_autoindex_DocumentVersion_1DocumentVersion ߃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
)>�(Q+ indexsqlite_autoindex_automation_logs_1automation_logs �@�&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
)��$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")�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 "Document" ("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
)
� d
; 0 �[�� � �;D?C'� 'O�eAg / ?cmcgtclj00009vjq0cyr0bfk7sophie.dubois@adwavocats.caSophie Dubois$2a$12$/r9KZ68VkpLb3jKftCu1UuRMMCeSVgYWGNa2U6DuS/EN4qGYszKYaLAWYER����������sophie.dubois/images/lawyers/sophie-dubois.jpgSophie Dubois se spécialise en droit civil et en droit des successions. Elle aide ses clients à planifier leur succession et à résoudre des litiges familiaux complexes.AvocateDroit civil et successions12349Université de Sherbrooke - Faculté de droitMontréal+1 (514) 555-0105lightfrcmcgr3oqq0000vjcg8m4ltykh�D?=!� !I�S-e / ?cmcgtcl5x0007vjq0ra2x2m70david.chen@adwavocats.caDavid Chen$2a$12$TnkvUprPAoNO4Fp/15jtVeJAIzgkaFxFzTbGQtYFe6IiGq7Ym2LBiLAWYER����%�����david.chen/images/lawyers/david-chen.jpgDavid Chen se spécialise en droit du travail. Il représente tant les employeurs que les employés dans des litiges complexes en matière de relations de travail.AvocatDroit du travail12348Université de Montréal - Faculté de droitMontréal+1 (514) 555-0104lightfrcmcgr3oqq0000vjcg8m4ltykh�[D?S7� 7_�3W / ?cmcgtcksz0005vjq04hjtch8fmarie-claude.tremblay@adwavocats.caMarie-Claude Tremblay$2a$12$llf5UMgg.Qk0QnPUyK66VudJ7AVtgofc156FUujX6mvHRy7EJEfsmLAWYER����R�����marie-claude.tremblay/images/lawyers/marie-claude-tremblay.jpgMarie-Claude Tremblay se spécialise en droit de la famille. Elle accompagne ses clients avec empathie dans des situations souvent difficiles, en privilégiant les solutions à l'amiable.AvocateDroit de la famille12347Université Laval - Faculté de droitMontréal+1 (514) 555-0103lightfrcmcgr3oqq0000vjcg8m4ltykh�=D?=!� !I� IY / ?cmcgtckg20003vjq0m05v47ymjustin.wee@adwavocats.caJustin Wee$2a$12$cpCU7V8i/0/D0MfOdpb5BuuEk2EAFmh1qN4qiaiP6y45jTb4Zfl7SLAWYER����������justin.wee/images/lawyers/justin-wee.jpgJustin Wee est associé chez ADW Avocats, spécialisé en droit immobilier et commercial. Il conseille des clients dans des transactions immobilières complexes et des litiges commerciaux.AssociéDroit immobilier et commercial12346Université McGill - Faculté de droitMontréal+1 (514) 555-0102lightfrcmcgr3oqq0000vjcg8m4ltykh�D?I-� -U�e5?e / ?cmcgtcjzc0001vjq0gqs732claudrey.labrecque@adwavocats.caAudrey Labrecque$2a$12$FR7DX4a3OS2333TxFAKqDOt2lfnQQ7HprSQGakT6Lq8zIZZjaLVjuLAWYER����'�����audrey.labrecque/images/lawyers/audrey-labrecque.jpgAudrey Labrecque est associée principale chez ADW Avocats. Elle se spécialise en droit civil et commercial avec plus de 12 ans d'expérience. Elle a plaidé avec succès de nombreux dossiers complexes devant les tribunaux québécois.Associée principaleDroit civil et commercial12345 Université de Montréal - Faculté de droitMontréal+1 (514) 555-0101lightfrcmcgr3oqq0000vjcg8m4ltykh�C?1 � += ! cmcgk36ee0001vjxw6rfrkd2kclient@example.comJane Doe$2a$10$VrvDVfFRrpzC4/sMvF/vs.k.WNxccIlk60iIFTg7y6S810dLQ3NrmCLIENT���W&�����lightfemale+1-438-555-9876456 Elm St, Montreal, QC �=�� Accountanten�&C?1!� % 1O?+UQ +?!+ cmcgk36ax0000vjxwf93zgfwilawyer@example.comJohn Smith$2a$10$z08cjJKgTBjUHyKZvu9glOvCfjySTcXSw5Z9Y47/vckDDv9gF5ZoaLAWYER���V������Criminal LawBAR123456 Harvard Law SchoolCertified Criminal Law Specialist123 Main St, Montreal, QC+1-514-555-1234https://linkedin.com/in/johnsmithlawhttps://adw-lawyers.com/john-smith �@������@������?�p��
=qxn
@333333� @^ @ @ffffff.��PREMIUMlightmale+1-514-555-1234123 Main St, Montreal, QCJane Smith+1-514-555-5678 L.r� Lawyeren�B?/!# cmcgj2ax40000vjlkn95vza40admin@example.comAdmin Userpassword123ADMIN���������lighten
�
� >����t� � �uC?;+� + % cmcgvzvyu0001vjx8bgd56xcilegal.secretary@lmep.caIsabelle Gagnon$2a$10$L6ZD.9GFwC35fiwW6YSxkOmXIgw8zxduVQL.SZl7lUkfiIZAQ6qLKSECRETARY��싓��싓Legal Secretarylight514-555-0104en�eC?/+� % cmcgvzvyu0002vjx8cm1h0307law.clerk@lmep.caSophie Tremblay$2a$10$L6ZD.9GFwC35fiwW6YSxkOmXIgw8zxduVQL.SZl7lUkfiIZAQ6qLKCLERK��싓��싓Law Clerklight514-555-0103en�C??'� 1 E cmcgvz79u0001vj94w8ytx52xdavid.justice@example.comDavid Justice$2a$12$he57p3ROP6b7C/Syfys4WOxIkuVvlHHHWS1dgyugEkc4j9iEJRXHmLAWYER��������david-justice-demoCriminal Law & Prison Rights|2(@������blighten�C?A)� 3 I cmcgvz6ws0000vj94x9t55dmumarie.champion@example.comMarie Champion$2a$12$zbMCciiyIaNlfDWZ.kR66eHXzycjNecFpm9nJDftvM4cmDFTVrASmLAWYER��� ���� �marie-champion-demoHuman Rights & Civil Liberties�2(@������ �lighten�&
F?A)� )��-)I � %) cmcgvz1ww0001vjx8aacytjwtmarie.champion@lawfirm.comMarie Champion$2a$12$CLSTA7z1oZkcVxp4hLZrj.7m5/HwSTvzIJN9ij.ajTrjUnfYwnCm.LAWYER����o����omarie-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@ �lighten� E?A'� '��/-E W #) cmcgvz1ww0000vjx82ysl0nemdavid.justice@advocates.caDavid Justice$2a$12$BycpplzPtkM0jORFuyTth.dvBdUaidbo1pubC7xQxXuMnar2TQfd.LAWYER����o����odavid-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@������blighten�\ D?E)� )Q�WW / ?cmcgtcmmo000fvjq0bxls2vfwthomas.leblanc@adwavocats.caThomas Leblanc$2a$12$mkEmJYgOa1Y9wMkq78wYt.Mq7lVmOPDgNZsuJFOAkiX5doSNNp8O6LAWYER����������thomas.leblanc/images/lawyers/thomas-leblanc.jpgThomas Leblanc se spécialise en droit administratif et réglementaire. Il aide ses clients à naviguer dans les complexités des procédures administratives et des réglementations gouvernementales.AvocatDroit administratif et réglementaire12352Université Laval - Faculté de droitMontréal+1 (514) 555-0108lightfrcmcgr3oqq0000vjcg8m4ltykh�f
D?M1� 1Y� Me / ?cmcgtcm9p000dvjq0bcl0k8l6isabella.rodriguez@adwavocats.caIsabella Rodriguez$2a$12$s4Utxo.upVypN5d2iQs8aOFSk/0MFHOdSyUrBV0GR2EPs4BAKb70aLAWYER����������isabella.rodriguez/images/lawyers/isabella-rodriguez.jpgIsabella Rodriguez se spécialise en droit immobilier et en droit de la construction. Elle représente des promoteurs, entrepreneurs et propriétaires dans des projets immobiliers complexes.AvocateDroit immobilier et construction12351Université de Montréal - Faculté de droitMontréal+1 (514) 555-0107lightfrcmcgr3oqq0000vjcg8m4ltykh�V D?O5� 5[�wAY / ?cmcgtclw7000bvjq0qp9ay77ymarc-andre.bouchard@adwavocats.caMarc-André Bouchard$2a$12$R1SdfmpFgaHnLloTV420yOkRks792bA8ZUbkLuSZXBsdqSRPWe6MKLAWYER����������marc-andré.bouchard/images/lawyers/marc-andre-bouchard.jpgMarc-André Bouchard se spécialise en droit commercial et fiscal. Il conseille des entreprises de toutes tailles dans leurs transactions commerciales et leurs obligations fiscales.AvocatDroit commercial et fiscal12350Université McGill - Faculté de droitMontréal+1 (514) 555-0106lightfrcmcgr3oqq0000vjcg8m4ltykh
2 �
� �
R �q����2 �_?1[1 ? ? cmcgvzljz000dvjic4cqrqopwDiscovery DeadlineDeadline for completing discovery phaseDISCOVERY_DEADLINE�^�17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED���V����V�`?/U ? ?- cmcgvzljs000bvjichpmx55nzMediation SessionMediation session to resolve disputeMEDIATION��k�14:0016:00xMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiMediation CenterSCHEDULED���V����V
?Cu!? ?E cmcgvzljj0009vjiccukl784uDeposition - Expert WitnessDeposition of expert witness in personal injury caseDEPOSITION�Ҭ"�10:0012:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiLaw Office - Deposition RoomCONFIRMED���V����VЁy ?Ym+ ? ? cmcgvzljb0007vjic5562bsx2Filing Deadline - Motion for DiscoveryDeadline to file motion for additional discoveryFILING_DEADLINE��_j�17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED���V����VȂ ?Cg)? ?= cmcgvzlj10005vjicrlhcp6sqClient Meeting - Jane SmithFollow-up meeting to discuss settlement offerCLIENT_MEETING��ڣ13:0014:30ZMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiClient Office - DowntownSCHEDULED���V����V��
?WS'? ?M 7 cmcgvzliu0003vjictqgw7nb7Court Hearing - Smith vs. CorporationMotion hearing for summary judgmentCOURT_HEARING����09:0011:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiQuebec Superior Court - Room 301Quebec Superior CourtCONFIRMED���V����V��S ?I� %???A U cmcgvzlil0001vjicqstpk53tClient Consultation - John DoeInitial consultation with client regarding personal injury caseCONSULTATION��Z3�14:0015:00<MEDIUMcmcgvz1y70004vjx8hl4gu8q0cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwiOffice - Conference Room Ahttps://meet.google.com/abc-defg-hijSCHEDULED���V����V�� ?;�% ?A U cmcgl0dmp000fvjk4uayr0q4qNew Client ConsultationInitial consultation for potential new employment law caseCONSULTATION���I�15:0017:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Consultation Roomhttps://meet.google.com/new-case-123SCHEDULED�������F?1[1 ? cmcgl0dmf000dvjk4yirmdwagDiscovery DeadlineDeadline for completing discovery phaseDISCOVERY_DEADLINE����17:0018:00<CRITICALcmcgk36ax0000vjxwf93zgfwiSCHEDULED���������G?/U ?- cmcgl0dm5000bvjk4v4cb9v0jMediation SessionMediation session to resolve disputeMEDIATION��R��14:0016:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiMediation CenterSCHEDULED��������l?Cu! ?E cmcgl0dlu0009vjk4pyww9me0Deposition - Expert WitnessDeposition of expert witness in personal injury caseDEPOSITION�ђŹ10:0012:00xHIGHcmcgk36ax0000vjxwf93zgfwiLaw Office - Deposition RoomCONFIRMED��������`?Ym+ ? cmcgl0dll0007vjk4x98bno67Filing Deadline - Motion for DiscoveryDeadline to file motion for additional discoveryFILING_DEADLINE��F
�17:0018:00<CRITICALcmcgk36ax0000vjxwf93zgfwiSCHEDULED�������فg?Cg) ?= cmcgl0dlb0005vjk4etcgwi1bClient Meeting - Jane SmithFollow-up meeting to discuss settlement offerCLIENT_MEETING���}�13:0014:30ZMEDIUMcmcgk36ax0000vjxwf93zgfwiClient Office - DowntownSCHEDULED�������Ђ?WS' ?M 7 cmcgl0dl40003vjk4xd945azkCourt Hearing - Smith vs. CorporationMotion hearing for summary judgmentCOURT_HEARING���U�09:0011:00xHIGHcmcgk36ax0000vjxwf93zgfwiQuebec Superior Court - Room 301Quebec Superior CourtCONFIRMED�������Ȃ! ?I� % ?A U cmcgl0dkv0001vjk4ladytpz5Client Consultation - John DoeInitial consultation with client regarding personal injury caseCONSULTATION��@ֹ14:0015:00<MEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Conference Room Ahttps://meet.google.com/abc-defg-hijSCHEDULED��������
� �
� u r
v n��� � ?;�% ?A U cmcgw3glw000fvj38mhgttxihNew Client ConsultationInitial consultation for potential new employment law caseCONSULTATION���f�15:0017:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Consultation Roomhttps://meet.google.com/new-case-123SCHEDULED�������Ձ_?1[1 ? ? cmcgw3glo000dvj38o49ura6gDiscovery DeadlineDeadline for completing discovery phaseDISCOVERY_DEADLINE� �17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED�������́`?/U ? ?- cmcgw3glg000bvj385z8zc37aMediation SessionMediation session to resolve disputeMEDIATION��n��14:0016:00xMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiMediation CenterSCHEDULED�������Ă?Cu!? ?E cmcgw3gl40009vj38a67qy7ktDeposition - Expert WitnessDeposition of expert witness in personal injury caseDEPOSITION�Ү�10:0012:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiLaw Office - Deposition RoomCONFIRMED���������y?Ym+ ? ? cmcgw3gku0007vj38ku5amzw5Filing Deadline - Motion for DiscoveryDeadline to file motion for additional discoveryFILING_DEADLINE��b*�17:0018:00<CRITICALcmcgvz1y70004vjx8hl4gu8q0cmcgk36ax0000vjxwf93zgfwiSCHEDULED��������� ?Cg)? ?= cmcgw3gkn0005vj38b4h30m6jClient Meeting - Jane SmithFollow-up meeting to discuss settlement offerCLIENT_MEETING����13:0014:30ZMEDIUMcmcgvz7a70003vj946t0ujejdcmcgk36ax0000vjxwf93zgfwiClient Office - DowntownSCHEDULED���������?WS'? ?M 7 cmcgw3gke0003vj38k2zooso5Court Hearing - Smith vs. CorporationMotion hearing for summary judgmentCOURT_HEARING��r�09:0011:00xHIGHcmcgvz1y70005vjx818yw9sv1cmcgk36ax0000vjxwf93zgfwiQuebec Superior Court - Room 301Quebec Superior CourtCONFIRMED���������S ?I� %???A U cmcgw3gk40001vj38028wls7hClient Consultation - John DoeInitial consultation with client regarding personal injury caseCONSULTATION��\�14:0015:00<MEDIUMcmcgvz1y70004vjx8hl4gu8q0cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwiOffice - Conference Room Ahttps://meet.google.com/abc-defg-hijSCHEDULED��������� ?;�% ?A U cmcgvzlk9000fvjicucewi1alNew Client ConsultationInitial consultation for potential new employment law caseCONSULTATION�����15:0017:00xMEDIUMcmcgk36ax0000vjxwf93zgfwiOffice - Consultation Roomhttps://meet.google.com/new-case-123SCHEDULED���V����V�
� � �
� \5$
��� �T C?3#�# cmcgx0r7z0000vjcghrbty6ildannywperez@msn.comDanny PEREZ$2a$12$xR8RFSIToeRS0BXINOgm7elOLq8.VTXKLyElmjfO0RcpXqHhBLsCCSUPER_ADMIN��������lighten�
C?;#� %I ' cmcgwbmi50004vjbsodualz0jlucie.morin@example.comLucie Morin$2a$12$vdHt1tVuqMuvCcr4gL7s/uZW7ceIC9mZW1cdJpknTOEpmDuCXYvNqCLIENT��������light514-555-0105654 Rue Ontario, Montréal, QCSocial Workerfr� C?;#� %O cmcgwbm4r0003vjbswoy2zxrzmarc.dubois@example.comMarc Dubois$2a$12$8Uv5Lpa20YISJgwN9HiZkeOHFyesiMwTSl/O3bsC1hmWHvdJ2QYLuCLIENT����������light514-555-0104321 Rue Sherbrooke, Montréal, QCStudenten�C?C-� %e cmcgwblrj0002vjbsp9mq6vcasophie.levesque@example.comSophie Lévesque$2a$12$SI7horc26ToDHdvGxcpNyOQQl1qZak6GTAsGmE6cT/Ht3SLZ.xBiSCLIENT����������light514-555-0103789 Boulevard René-Lévesque, Montréal, QCNursefr�C??'� %O 3 cmcgwblck0001vjbsadc46bi0jean.bouchard@example.comJean Bouchard$2a$12$i0qJNDX3qYh4pKTZJlYCJePRPoutZ8F1iP9MEDTu3Ie8Y7IxWoVQiCLIENT����������light514-555-0102456 Avenue du Parc, Montréal, QCConstruction Workerfr�C?A)� %Q cmcgwbkyj0000vjbsv0glcolamarie.tremblay@example.comMarie Tremblay$2a$12$lOE1sATt.x.2vZOhyiHyY.p7O.uuBQtXqTx2EcwJGusCB9msbBR.KCLIENT����������light514-555-0101123 Rue Saint-Denis, Montréal, QCTeacherfr�$C??+� a +' cmcgw0bbf0004vj9kpj52nge7sofia.rodriguez@email.comSofia Rodriguez$2a$10$NEj6NHtEWS.RxKWr2GL8puu9k0rk/H9fkuWZohgeM3vq0O918YaASUSER����K����KTeacher seeking help with landlord disputelight+1-416-555-0105Etobicoke, ONTeacheren�#C?7#� ] +# 1 cmcgw0bb40003vj9k7ujybngtrobert.chen@email.comRobert Chen$2a$10$GCD/F0rJI9uYHaSfosZoBOpKIIUHW1MaKuky1tgNxUjZCMzKyFiuiUSER����@����@Software developer wrongfully terminatedlight+1-416-555-0104Markham, ONSoftware Developeren�$C?7#� e +% ) cmcgw0bau0002vj9kt3sprq4eaisha.patel@email.comAisha Patel$2a$10$vaQzcOx3wtYJh9dLZeDaVOd7/wDVWpleGFJC4SPk.9wsYaC5BgoveUSER����7����7Small business owner fighting discriminationlight+1-416-555-0103Brampton, ONBusiness Owneren�(C?9%� Y ++ 3 cmcgw0baj0001vj9k49sksc1kjames.wilson@email.comJames Wilson$2a$10$qovnkTIpATS6UuVEMj.6nevXUfsNV4AcUJxB5pm3KNeRyGXkcLKcGUSER����+����+Construction worker injured on the joblight+1-416-555-0102Mississauga, ONConstruction Workeren� C?=)� c +# cmcgw0b9y0000vj9kmuqzux5mmaria.gonzalez@email.comMaria Gonzalez$2a$10$4HFF/lVgBpU157dud8IwNOndopScnr5viQfgVgKFhy3wGsTmHqVfuUSER��������Single mother seeking justice for my familylight+1-416-555-0101Toronto, ONNurseen�C?=1� 1) % cmcgvzvyt0000vjx81k9vbo5qassistant.lawyer@lmep.caJean-Pierre Martin$2a$10$L6ZD.9GFwC35fiwW6YSxkOmXIgw8zxduVQL.SZl7lUkfiIZAQ6qLKLAWYER��싓��싓Associate AttorneyLegal Researchlight514-555-0102en�}C?7%� +- % cmcgvzvyu0003vjx878qe6kd7lead.attorney@lmep.caMarie Dubois$2a$10$L6ZD.9GFwC35fiwW6YSxkOmXIgw8zxduVQL.SZl7lUkfiIZAQ6qLKLAWYER��싓��싓Senior AttorneyCriminal Defenselight514-555-0101en
,
� � �
r tx}QS7<?5 , � ? A%W ?? ?cmcgwbmjf000avjbsrwe0gdrwMarieTremblaymarie.tremblay@example.com514-555-0101 ��< OtherCLIENTfremailDemo registration for case ENV2024001PENDING����������cmcgwbkyj0000vjbsv0glcolacmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd� ? A%Y ?? ?cmcgwbmit0006vjbsk1kwtvj8MarieTremblaymarie.tremblay@example.com514-555-0101 ��< OtherCLIENTfremailDemo registration for case PRIV2024002PENDING����������cmcgwbkyj0000vjbsv0glcolacmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4�z
?1%[ ?? ?cmcgwart30005vj9spp80pfk8JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case 2024QCCS4540PENDING���KG���KGcmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70005vjx818yw9sv1�x ?1%W ?? ?cmcgwarsn0001vj9sgtjepgp5JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case ENV2024001PENDING���K7���K7cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd� ?=%{ e O cmcgwaq4s0004vjbs05zudlt2PierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING���B����B�[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�{
?9%] Y A cmcgwaq4s000avjbsjvrslqgtRobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED���B����B�[]Sentence seems excessive for the crimeAppeal deadline in 60 days�) ? =%i 9 s M cmcgwaq4s0005vjbsw8kfjap1MarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW���B����B�[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week�x ?1%W ?? ?cmcgwa52j0005vj6caca6ind9JaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case ENV2024001PENDING����+����+cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd�y ?1%Y ?? ?cmcgwa51x0001vj6c6sfx11dxJaneDoeclient@example.com514-555-0123 ��< OtherCLIENTenemailDemo registration for case PRIV2024002PENDING��������cmcgk36ee0001vjxw6rfrkd2kcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4�{ ?9%] Y A cmcgw396a0007vjc4hz2a39t2RobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED����3����3[]Sentence seems excessive for the crimeAppeal deadline in 60 days� ?=%{ e O cmcgw396a0005vjc43teicejpPierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING����3����3[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�) ? =%i 9 s M cmcgw396a0004vjc4f1043uedMarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW����3����3[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week�) ? =%i 9 s M cmcgvzw0x0006vjx8thw6qeifMarieBouchardmarie.bouchard@email.com514-555-0202 AQ�� FemaleMotherFrenchPhoneMy son needs legal representation for his caseDOCUMENTS_UNDER_REVIEW��������[]Son facing serious charges, need experienced lawyerBail hearing scheduled next week� ?=%{ e O cmcgvzw0x0005vjx849zfwaxmPierreLeblancpierre.leblanc@email.com438-555-0201 o��@ MaleSelfFrenchEmailSeeking legal assistance for wrongful conviction appealPENDING��������[]Wrongful conviction - need appeal assistanceCourt date approaching in 30 days�{ ?9%] Y A cmcgvzw0x0004vjx8t0f7kd33RobertCaronrobert.caron@email.com450-555-0203 �pK� MaleSelfEnglishEmailNeed help with sentence reduction appealAPPROVED��������[]Sentence seems excessive for the crimeAppeal deadline in 60 days
� �
� � �
� ���� � ?;%W ?? ?cmcgwbmog001avjbsug1zzv8qLucieMorinlucie.morin@example.com514-555-0105 ��< OtherCLIENTfremailDemo registration for case ENV2024001PENDING��������cmcgwbmi50004vjbsodualz0jcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7a70003vj946t0ujejd� ?;%Y ?? ?cmcgwbmnx0016vjbsrjyj8ohqLucieMorinlucie.morin@example.com514-555-0105 ��< OtherCLIENTfremailDemo registration for case PRIV2024002PENDING����~����~cmcgwbmi50004vjbsodualz0jcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4�z ?;%K ?? ?cmcgwbmne0012vjbs6z38vq4dLucieMorinlucie.morin@example.com514-555-0105 ��< OtherCLIENTfremailDemo registration for case nullPENDING����j����jcmcgwbmi50004vjbsodualz0jcmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70004vjx8hl4gu8q0�z ?;%K ?? ?cmcgwbmms000yvjbsfl39ecpwMarcDuboismarc.dubois@example.com514-555-0104 ��< OtherCLIENTenemailDemo registration for case nullPENDING����T����Tcmcgwbm4r0003vjbswoy2zxrzcmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70004vjx8hl4gu8q0� ?;%Y ?? ?cmcgwbmm7000uvjbsm7pcfg4cMarcDuboismarc.dubois@example.com514-555-0104 ��< OtherCLIENTenemailDemo registration for case PRIV2024002PENDING����?����?cmcgwbm4r0003vjbswoy2zxrzcmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4� ?;%[ ?? ?cmcgwbmlj000qvjbstx5y1qr2MarcDuboismarc.dubois@example.com514-555-0104 ��< OtherCLIENTenemailDemo registration for case 2024QCCS4540PENDING����'����'cmcgwbm4r0003vjbswoy2zxrzcmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70005vjx818yw9sv1� ? C%K ?? ?cmcgwbmky000mvjbs7rle8l9mSophieLévesquesophie.levesque@example.com514-555-0103 ��< OtherCLIENTfremailDemo registration for case nullPENDING��������cmcgwblrj0002vjbsp9mq6vcacmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70004vjx8hl4gu8q0� ? ?%Y ?? ?cmcgwbmkf000ivjbsu969m114JeanBouchardjean.bouchard@example.com514-555-0102 ��< OtherCLIENTfremailDemo registration for case PRIV2024002PENDING��������cmcgwblck0001vjbsadc46bi0cmcgk36ax0000vjxwf93zgfwi[]cmcgvz7af0005vj94ujm1qwo4� ? A%[ ?? ?cmcgwbmjw000evjbscolzgi52MarieTremblaymarie.tremblay@example.com514-555-0101 ��< OtherCLIENTfremailDemo registration for case 2024QCCS4540PENDING����������cmcgwbkyj0000vjbsv0glcolacmcgk36ax0000vjxwf93zgfwi[]cmcgvz1y70005vjx818yw9sv1
W ��z
�
n � d � \
�
X � ?�$�"���j�@�� � W � ???? ?cmcgwbmmi000wvjbsllb2qsnwcmcgwbmm7000uvjbsm7pcfg4ccmcgwbm4r0003vjbswoy2zxrzCLIENT����Kcmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwbmlw000svjbst23t5ieycmcgwbmlj000qvjbstx5y1qr2cmcgwbm4r0003vjbswoy2zxrzCLIENT����4cmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwbml9000ovjbszhoj7eyxcmcgwbmky000mvjbs7rle8l9mcmcgwblrj0002vjbsp9mq6vcaCLIENT���� cmcgk36ax0000vjxwf93zgfwicmcgvz1y70004vjx8hl4gu8q0� ???? ?cmcgwbmkp000kvjbsk0kgfrdycmcgwbmkf000ivjbsu969m114cmcgwblck0001vjbsadc46bi0CLIENT����
cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwbmk6000gvjbsge17x8ancmcgwbmjw000evjbscolzgi52cmcgwbkyj0000vjbsv0glcolaCLIENT����cmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwbmjo000cvjbs171eo2pgcmcgwbmjf000avjbsrwe0gdrwcmcgwbkyj0000vjbsv0glcolaCLIENT�����cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd� ???? ?cmcgwbmj60008vjbshxmjkvfycmcgwbmit0006vjbsk1kwtvj8cmcgwbkyj0000vjbsv0glcolaCLIENT�����cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwarta0007vj9sx0h2xwr5cmcgwart30005vj9spp80pfk8cmcgk36ee0001vjxw6rfrkd2kCLIENT���KNcmcgk36ax0000vjxwf93zgfwicmcgvz1y70005vjx818yw9sv1� ???? ?cmcgwarsw0003vj9sz7qyr7gwcmcgwarsn0001vj9sgtjepgp5cmcgk36ee0001vjxw6rfrkd2kCLIENT���K@cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd� ???-? cmcgwaq5t000ovjbs0ofdwf6scmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0002vjx8cm1h0307assistant_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5t000nvjbsglbximb7cmcgwaq4s000avjbsjvrslqgtcmcgvzvyt0000vjx81k9vbo5qprimary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5p000ivjbs7r5m9cgjcmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0003vjx878qe6kd7primary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgwaq5p000hvjbsxxwtqy5jcmcgwaq4s0005vjbsw8kfjap1cmcgvzvyu0003vjx878qe6kd7primary_lawyer���B�cmcgvzvyu0003vjx878qe6kd7| ??? ? cmcgwaq5p000jvjbswgmr17ricmcgwaq4s0004vjbs05zudlt2cmcgvzvyu0001vjx8bgd56xcisecretary���B�cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgwaq5p000kvjbsi22409lzcmcgwaq4s0004vjbs05zudlt2cmcgvzvyt0000vjx81k9vbo5qassistant_lawyer���B�cmcgvzvyu0003vjx878qe6kd7� ???? ?cmcgwa52q0007vj6chr3332ugcmcgwa52j0005vj6caca6ind9cmcgk36ee0001vjxw6rfrkd2kCLIENT����2cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd�
???? ?cmcgwa52a0003vj6c9veynx40cmcgwa51x0001vj6c6sfx11dxcmcgk36ee0001vjxw6rfrkd2kCLIENT����"cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???)? cmcgw397m000ovjc4av1f8wn1cmcgw396a0007vjc4hz2a39t2cmcgvzvyt0000vjx81k9vbo5qprimary_lawyer����_cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgw397m000nvjc4k183h790cmcgw396a0004vjc4f1043uedcmcgvzvyu0002vjx8cm1h0307assistant_lawyer����_cmcgvzvyu0003vjx878qe6kd7|
??? ? cmcgw397i000ivjc4hz3k56macmcgw396a0005vjc43teicejpcmcgvzvyu0001vjx8bgd56xcisecretary����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgw397i000kvjc4brc9s1tzcmcgw396a0005vjc43teicejpcmcgvzvyu0003vjx878qe6kd7primary_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgw397i000hvjc4nlajc73pcmcgw396a0004vjc4f1043uedcmcgvzvyu0003vjx878qe6kd7primary_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgw397i000jvjc4gsobofn3cmcgw396a0005vjc43teicejpcmcgvzvyt0000vjx81k9vbo5qassistant_lawyer����^cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw25000ovjx84brbin5xcmcgvzw0x0004vjx8t0f7kd33cmcgvzvyt0000vjx81k9vbo5qprimary_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgvzw25000nvjx8d2zykmg7cmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0002vjx8cm1h0307assistant_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???-? cmcgvzw22000jvjx8o86z80l3cmcgvzw0x0005vjx849zfwaxmcmcgvzvyt0000vjx81k9vbo5qassistant_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw22000kvjx8obcnm03ucmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0003vjx878qe6kd7primary_lawyer���
cmcgvzvyu0003vjx878qe6kd7� ???)? cmcgvzw22000hvjx8kioglk2lcmcgvzw0x0006vjx8thw6qeifcmcgvzvyu0003vjx878qe6kd7primary_lawyer���
cmcgvzvyu0003vjx878qe6kd7| ??? ? cmcgvzw22000ivjx8xpcluv41cmcgvzw0x0005vjx849zfwaxmcmcgvzvyu0001vjx8bgd56xcisecretary���
cmcgvzvyu0003vjx878qe6kd7
� k�A
� �! ???? ?cmcgwbmoo001cvjbs5m561asocmcgwbmog001avjbsug1zzv8qcmcgwbmi50004vjbsodualz0jCLIENT����cmcgk36ax0000vjxwf93zgfwicmcgvz7a70003vj946t0ujejd� ???? ?cmcgwbmo40018vjbsfpzcjhtucmcgwbmnx0016vjbsrjyj8ohqcmcgwbmi50004vjbsodualz0jCLIENT����cmcgk36ax0000vjxwf93zgfwicmcgvz7af0005vj94ujm1qwo4� ???? ?cmcgwbmnl0014vjbslbxnhvwucmcgwbmne0012vjbs6z38vq4dcmcgwbmi50004vjbsodualz0jCLIENT����qcmcgk36ax0000vjxwf93zgfwicmcgvz1y70004vjx8hl4gu8q0� ???? ?cmcgwbmn10010vjbsb6d5zqe4cmcgwbmms000yvjbsfl39ecpwcmcgwbm4r0003vjbswoy2zxrzCLIENT����^cmcgk36ax0000vjxwf93zgfwicmcgvz1y70004vjx8hl4gu8q0