commit f95d22

2025-10-09 10:40:08 Switi Patel: DB updated

0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9

`Projects/OptiQA/Technical Documents (LLD+HLD).md` ..
@@ 43,3 43,38 @@

	### LLD Diagram
	![](./image-1760006122665.png)
+
+	## 🗄️ Database Design
+
+	### Tables
+
+	#### users
+
+	\| Column \| Type \| Description \|
+	\|--------\|------\|-------------\|
+	\| id \| UUID (PK) \| Unique user identifier \|
+	\| name \| VARCHAR \| User’s full name \|
+	\| email \| VARCHAR \| Unique email address \|
+	\| password_hash \| TEXT \| Encrypted password \|
+	\| created_at \| TIMESTAMP \| Timestamp of registration \|
+
+	#### prompts
+
+	\| Column \| Type \| Description \|
+	\|--------\|------\|-------------\|
+	\| id \| UUID (PK) \| Unique prompt identifier \|
+	\| user_id \| UUID (FK → users.id) \| Owner of the prompt \|
+	\| prompt_text \| TEXT \| User-entered prompt \|
+	\| generated_code \| TEXT \| AI-generated Playwright test code \|
+	\| created_at \| TIMESTAMP \| Date/time of prompt creation \|
+
+	#### test_results
+
+	\| Column \| Type \| Description \|
+	\|--------\|------\|-------------\|
+	\| id \| UUID (PK) \| Unique test result identifier \|
+	\| prompt_id \| UUID (FK → prompts.id) \| Related prompt \|
+	\| status \| VARCHAR \| Test status (e.g., PASSED, FAILED, ERROR) \|
+	\| execution_log \| TEXT \| Execution logs \|
+	\| screenshot_url \| TEXT \| Optional screenshot of result \|
+	\| created_at \| TIMESTAMP \| Timestamp of execution \|