1
Tables (9)
Cafeteria
- cafeId — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
Cart
- cartId — bigint(20) — Primary key — NOT NULL
- userId — bigint(20) — NOT NULL
- createdDate — timestamp
- updatedDate — timestamp
CartItems
- CartItemId — bigint(20) — Primary key — NOT NULL
- cartId — bigint(20) — NOT NULL
- menuId — bigint(20) — NOT NULL
- quantity — int
- menuPrice — int(11)
Menu
- menuId — bigint(20) — Primary key — NOT NULL
- cafeId — bigint(20) — NOT NULL
- name — varchar(255)
- price — int(11)
- category — varchar(100)
- menuPrictureUrl — text
- status — varchar(255)
OrderItems
- orderItemId — bigint(20) — Primary key — NOT NULL
- orderId — bigint(20) — NOT NULL
- menuId — bigint(20) — NOT NULL
- quantity — int
- menuPrice — int(11)
Orders
- orderId — bigint(20) — Primary key — NOT NULL
- userId — bigint(20) — NOT NULL
- orderDate — timestamp
- totalPrice — int(11)
- status — varchar(20)
Payment
- paymentId — bigint(20) — Primary key — NOT NULL
- orderId — bigint(20) — NOT NULL
- paymentMethod — varchar(255)
- paymentAmount — bigint(20)
- paymentStatus — varchar(20)
Users
- userId — bigint(20) — Primary key — NOT NULL
- password — varchar(255)
- name — varchar(100)
- phone — varchar(11)
- email — varchar(100)
- role — varchar(100)
review
- reviewId — bigint(20) — Primary key — NOT NULL
- userId — bigint(20) — NOT NULL
- menuId — bigint(20) — NOT NULL
- reviewScore — int
- reviewComment — varchar(255)
- createdDate — timestamp
- updatedDate — timestamp