Database Design Document
1. Introduction
This document describes the design of the database for the system.
2. Schema
This section should include a diagram of the database schema.
(Insert schema diagram here)
3. Tables
3.1. Users
| Column | Data Type | Constraints |
|---|---|---|
| id | INT | PRIMARY KEY |
| username | VARCHAR(255) | NOT NULL, UNIQUE |
| password | VARCHAR(255) | NOT NULL |
| VARCHAR(255) | NOT NULL, UNIQUE |
3.2. Products
| Column | Data Type | Constraints |
|---|---|---|
| id | INT | PRIMARY KEY |
| name | VARCHAR(255) | NOT NULL |
| description | TEXT | |
| price | DECIMAL(10, 2) | NOT NULL |