
🎓 Student Projects (College Reports) · Database ERD
The database of an online food ordering system: customers and addresses, restaurants, menu categories and items, carts, orders, payments, delivery partners, coupons and ratings.
Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.
Drawing diagram…
ER diagram for an online food ordering system: customers with addresses, restaurants with menu items in categories, carts with cart items, orders with order items, status and delivery address, payments, delivery partners assigned to orders, coupons applied to orders, and ratings by customers for orders and restaurants.
erDiagram
CUSTOMER {
uuid id PK
string full_name
string email
string phone
timestamp created_at
}
ADDRESS {
uuid id PK
uuid customer_id FK
string street_address
string city
string postal_code
timestamp created_at
}
RESTAURANT {
uuid id PK
string name
string phone
boolean is_active
timestamp created_at
}
CATEGORY {
uuid id PK
uuid restaurant_id FK
string name
integer display_order
timestamp created_at
}
MENU_ITEM {
uuid id PK
uuid category_id FK
string name
decimal price
boolean is_available
}
CART {
uuid id PK
uuid customer_id FK
decimal total_amount
timestamp updated_at
timestamp created_at
}
CART_ITEM {
uuid id PK
uuid cart_id FK
uuid menu_item_id FK
integer quantity
decimal unit_price
}
COUPON {
uuid id PK
string code
decimal discount_amount
date valid_until
boolean is_active
}
DELIVERY_PARTNER {
uuid id PK
string name
string phone
string vehicle_type
boolean is_available
}
ORDER {
uuid id PK
uuid customer_id FK
uuid restaurant_id FK
uuid delivery_address_id FK
uuid delivery_partner_id FK
uuid coupon_id FK
string status
decimal total_amount
timestamp created_at
}
ORDER_ITEM {
uuid id PK
uuid order_id FK
uuid menu_item_id FK
integer quantity
decimal unit_price
}
PAYMENT {
uuid id PK
uuid order_id FK
string payment_method
string payment_status
decimal amount
timestamp created_at
}
RATING {
uuid id PK
uuid order_id FK
uuid customer_id FK
uuid restaurant_id FK
integer score
string review_text
timestamp created_at
}
CUSTOMER ||--o{ ADDRESS : "has"
CUSTOMER ||--o{ CART : "owns"
CUSTOMER ||--o{ ORDER : "places"
CUSTOMER ||--o{ RATING : "writes"
RESTAURANT ||--o{ CATEGORY : "offers"
RESTAURANT ||--o{ ORDER : "fulfills"
RESTAURANT ||--o{ RATING : "receives"
CATEGORY ||--o{ MENU_ITEM : "contains"
CART ||--o{ CART_ITEM : "contains"
MENU_ITEM ||--o{ CART_ITEM : "added_to"
MENU_ITEM ||--o{ ORDER_ITEM : "ordered_in"
ADDRESS ||--o{ ORDER : "used_as_delivery"
DELIVERY_PARTNER ||--o{ ORDER : "assigned_to"
COUPON ||--o{ ORDER : "applied_to"
ORDER ||--o{ ORDER_ITEM : "includes"
ORDER ||--o{ PAYMENT : "paid_via"
ORDER ||--o{ RATING : "rated_in"An entity relationship diagram with 13 tables, 73 columns and 17 relationships.
Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.
Who uses a college library system and what each of them can do: members, the librarian and the system administrator.
The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.
How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.
The main classes of a library system with attributes, methods and UML relationships.
The steps when a member borrows a book: checks, loan record and the copy status update.
What students, examiners and the administrator do in an online examination system.