Project Requirements: Simple Registration System
Stack: Express.js + Drizzle ORM + PostgreSQL

📌 1. Overview
Develop a simple full-stack web application using Express.js, Drizzle ORM, and PostgreSQL to support:

User registration with basic contact details

Admin dashboard to view all registered users

Public index page with login and registration options

User profile display after login

🧾 2. Functional Requirements
2.1. Public Interface
Index Page (GET /)

Displays two buttons:

Login → navigates to /login

Sign Up → navigates to /register

2.2. User Registration
Route: POST /register

Form Fields:

name (string, required)

mobile (string, required, unique)

email (string, optional, must be unique if provided)

password (string, required, hashed)

Validation:

Ensure mobile is unique

Validate email format if provided

Store in PostgreSQL using Drizzle ORM

2.3. User Login
Route: POST /login

Login with:

mobile

password

On success:

Create a session or return JWT

Redirect to or fetch /profile

2.4. User Profile
Route: GET /profile

Requires authentication

Displays:

Name

Mobile

Email

Logout button

2.5. Admin Dashboard
Route: GET /admin

Admin login required

Displays list of all users with:

Name

Mobile

Email

Registration Date

🧱 3. Database Schema (Drizzle ORM + PostgreSQL)
Table: users
Column	Type	Constraints
id	SERIAL	Primary Key
name	TEXT	NOT NULL
mobile	TEXT	NOT NULL, UNIQUE
email	TEXT	UNIQUE
password	TEXT	NOT NULL (hashed)
created_at	TIMESTAMP	DEFAULT now()

Table: admins
Column	Type	Constraints
id	SERIAL	Primary Key
username	TEXT	NOT NULL, UNIQUE
password	TEXT	NOT NULL (hashed)

⚙️ 4. Technologies & Tools
Backend: Node.js + Express.js

ORM: Drizzle ORM

Database: PostgreSQL

Authentication: Session-based or JWT

Password Hashing: bcrypt

Dev Tools: dotenv, nodemon, express-session / passport or JWT

📦 5. Project Structure Suggestion
bash
Copy
Edit
/project-root
│
├── /src
│   ├── /routes
│   │   ├── auth.js
│   │   ├── user.js
│   │   └── admin.js
│   ├── /controllers
│   ├── /models (Drizzle ORM schema definitions)
│   ├── /middleware
│   └── server.js
├── /config (db connection, env)
├── /public (static assets if needed)
└── .env
🧪 6. Optional Enhancements
Email/mobile verification via OTP

Admin search and filter

Export users to CSV or PDF

Pagination in admin dashboard

Role-based access control

Docker support for local development

Would you like help scaffolding this project (with Drizzle and Express boilerplate), or generating specific code such as registration logic, routes, or schema setup?