erDiagram

Customer {
id int PK
name string
address string
contact_num string
password string
email_addr string
}
Order {
id int PK
order_date date
order_time time
total_price decimal
deliver_status string
delivery_addr string
}
Payment {
id string PK
payment_method string
total_amount decimal
result bool
}
Restaurant {
id string PK
name string
menu text
address string
contact_details string
opening_hours string
password string
email_addr string
}
Delivery_Person {
id string PK
name string
address string
contact_num string
password string
rating decimal
}
Employee {
id string PK
name string
address string
contact_num string
employee_id string
password string
}
Item {
id string PK
name string
quantity int
price decimal
icon_url string
}
Order_Items {
quantity int
}
Order_Delivery {
}

Customer }|--|| Order
Customer ||--|| Payment
Order }|--|| Order_Items
Order }|--|| Order_Delivery
Restaurant }|--|| Order
Restaurant }|--|| Item
Delivery_Person }|--|| Order_Delivery
Employee }|--|| Restaurant
Restaurant }|--|| Item
Employee }|--|{ Order
Employee }|--|| Item