Integrated Web Database with Customer Portal

Job Title:
Development of a Web Database with Customer Portal, Transporter Mobile Interface, Barcode/QR Code Integration, and Admin Backend
Project Description:
I am looking for an experienced freelancer to develop a web-based database solution with mobile access, a customer portal, transporter interface, and an administrative backend.
The system will be used to manage customers, contracts, and deliveries, including document uploads, status tracking, and automatic generation of delivery note numbers and QR or barcodes.
The solution must be accessible via web browser and mobile devices.
Scope of Work
1. Database Structure
At least three main tables are required:
Table 1: Customers
Fields:
Company name
Contact person 1
Contact person 2
Phone number
Email
Unique Customer ID
Table 2: Contracts
Fields:
Customer ID
Customer name
Articles (multiple possible)
Status (Active / Inactive)
Cost per article
Upload function for:
Contract (PDF)
NDA (PDF)
Table 3: Deliveries
Fields:
Customer ID
Customer delivery note number
Date
Delivered quantity per article
Delivery status:
In transport
In processing
Completed
Return transport
Automatically generated delivery note number (our internal number)
Format:
CustomerID + RecordID
Example:
K10023-00015
Additional functions:
Automatic generation of a unique QR code or barcode per delivery
Upload function for:
Customer documents
Internal documents
Automatic price calculation based on contract data if contract is active
Payment status:
Invoice issued
Open
Paid
Complaint status:
Open
In progress
Completed and validated
Frontends / User Roles
Three user interfaces are required:
1. Customer Portal
Access:
Web browser and mobile devices
Login:
Email
Password
Two-factor authentication (Authenticator App)
Functions:
Table view similar to Excel showing:
Customer delivery note number
Our delivery note number
Date
Status
Total cost
Download links for documents
Upload function for documents
Filters:
Date
Delivery note number
Status
Important:
Customers must only be able to view their own data.
2. Transporter / Operator Interface
Mobile-optimized interface
Functions:
Create new delivery:
Input:
Select customer
Enter customer delivery note number
Upload scanned delivery note (photo or PDF)
Automatically generated:
Our internal delivery note number
QR code or barcode
Additional functions:
Change delivery status
Print barcode on label printer
3. Administrator Interface
Functions:
Create and manage customers
Create and manage contracts
Full delivery management
Export data to CSV for invoicing
Filters:
Customer
Payment status
Date range
Security
Important:
Role-based access system:
Administrator
Customer
Transporter
Strict access separation required.
Login with:
Email
Password
Two-factor authentication (Authenticator App)
Technical Requirements
Open technology choice, preferred:
Backend:
PostgreSQL or MySQL
Frontend:
Web application
Mobile optimized or Progressive Web App
Cloud hosting possible.
Barcode and QR code integration required.
Deliverables
Fully functional system including:
Database
Frontend
Backend
Deployment and setup
Optional
Please also provide:
Hosting recommendation
Maintenance costs
Budget
Please provide:
Fixed price or hourly rate
Application
Please include:
References
Example projects
Proposed technology stack
Timeline
Price
Project start:
Immediately possible
I look forward to your proposals.