Welcome to our Ecommerce project! Our platform consists of several interconnected systems, each serving a specific purpose to create a robust and efficient Ecommerce experience. Below is an overview of the systems integrated into our project:
Experience intuitive banking with our user-friendly interface.
Immerse yourself in a visually stunning user interface designed to streamline navigation and enhance user engagement.
- Functionality:
- Account Management: Handles creation and management of customer accounts.
- Transaction Processing: Facilitates financial transactions such as deposits, withdrawals, and balance inquiries.
- Security: Ensures secure authentication and authorization mechanisms for user accounts.
erDiagram
ACCOUNTS {
Long id PK
String card_number "Unique"
String name
String email
String password
double balance
boolean enable "Active or Not"
}
ACCOUNTS ||--o{ TRANSACTIONS : have
TRANSACTIONS {
Long id PK
Long account_id FK "fk referencing ACCOUNTS.id"
double amount
String transaction_type
LocalDateTime created_at
String payment_method "credit card"
}
- Functionality:
- Coupon Generation: Generates unique discount codes with configurable usage limits and expiration dates.
- Coupon Redemption: Allows customers to apply coupons during checkout to receive discounts on their orders.
- Tracking: Logs coupon usage and provides reports on coupon effectiveness.
erDiagram
COUPONS {
long id PK
string code "Unique"
string discount_type "e.g., percentage, fixed amount"
double discount_value
datetime valid_from
datetime valid_to
int usage_limit
int remaining_count
datetime created_at
}
COUPONS ||--o{ CONSUMPTION_HISTORY : has
CONSUMPTION_HISTORY {
long id PK
datetime consumption_date
float discount_value
long order_id
string customer_email
long coupon_id FK "fk referencing COUPONS.id"
}
-
Functionality:
- Order Management: Manages the lifecycle of orders from creation to fulfillment.
- Inventory Control: Tracks product availability and updates inventory levels upon order placement.
- Payment Processing: Handles payment transactions securely and ensures order completion upon successful payment.
erDiagram
ORDERS {
long id PK
long product_code
string customer_email
datetime order_date
double price
string payment_method "(credit)"
datetime created_at
string coupon_code
}
-
Functionality:
- Product Catalog: Maintains a comprehensive catalog of products available for sale.
- Product Information: Stores detailed product information including descriptions, prices, and images.
- Product Management: Supports CRUD operations for managing products within the catalog.
erDiagram
PRODUCTS {
long id pk
string code "unique"
string name
string description
double price
long category_id "fk referencing CATEGORIES.id"
string brand
string image_url
datetime created_at
datetime updated_at
boolean active
}
PRODUCTS }o--|| CATEGORIES : belong_to
CATEGORIES{
long id pk
string name
string description
}
-
Functionality:
- Store Management: Allows creation and management of storefronts or warehouses.
- Product Display: Displays products within the store and enables browsing and search functionalities.
- Inventory Management: Tracks stock levels and handles stock replenishment and adjustments.
erDiagram
STORE {
long id PK
string name
string address
}
STORE ||--|{ STOCK : has
STOCK {
long id PK
int quantity
long product_code
long store_id FK "fk referencing STORE.id"
datetime created_at
datetime updated_at
}
STOCK ||--|{ STOCK_CONSUMPTION_HISTORY : has
STOCK_CONSUMPTION_HISTORY {
Long id pk
Long store_id
Long stock_id FK "fk referencing STOCK.id"
int quantity_before_update
int quantity_after_update
LocalDateTime created_at
}
-
Functionality:
- Notification Handling: Sends notifications to users regarding order status updates, promotions, and other relevant information.
- Event Listening: Listens for events such as order placement, payment confirmation, and coupon redemption to trigger notifications.
erDiagram
EMAILS {
Long id PK
String to
String from
String subject
String product
String price
LocalDate creation
Status status "success,faild"
}
- Functionality:
- Manage Admin Users: Provides functionality to add, activate, and deactivate admin users.
- View List of Users: Allows administrators to view a list of users for administrative purposes.
erDiagram
USERS {
long id PK
string email "Unique"
string password
boolean enabled "Active or Not"
}
 Sameh Tarek |
 Abdelrahman Reda |
 Abdulrahman Naqeb |
 Esraa Mabrouk |
 Fouad Abdelhalim |
 Hajar Refaat |