3meals
Tables (9)
cart
- id — BIGINT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
menu
- id — BIGINT
- store_id — BIGINT — NOT NULL
- menu_name — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- menu_img_url — VARCHAR(255)
- price — INT — NOT NULL
- is_deleted — BIT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
menu_option
- id — BIGINT
- menu_id — BIGINT — NOT NULL
- option_name — VARCHAR(255) — NOT NULL
- menu_option_img_url — VARCHAR(255)
- option_price — INT — NOT NULL
- is_deleted — BIT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
orders
- id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- delivery_address — VARCHAR(255) — NOT NULL
- total_price — INT — NOT NULL
- status — ENUM('DELIVERED', 'DELIVERING', 'PENDING', 'PREPARING') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
review
- id — BIGINT
- order_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — VARCHAR(500)
- review_image_url — VARCHAR(255)
- rating — INT — NOT NULL
- is_deleted — BIT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
review_comment
- id — BIGINT
- review_id — BIGINT — NOT NULL
- owner_id — BIGINT — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_deleted — BIT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
store
- id — BIGINT
- store_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- opening_time — TIME(6) — NOT NULL
- closing_time — TIME(6) — NOT NULL
- minimum_order_price — INT — NOT NULL
- delivery_tip — INT — NOT NULL
- is_closed — BIT
- store_profile_img_url — VARCHAR(255)
- owner_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
store_like
- id — BIGINT
- is_active — BIT — NOT NULL
- store_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
users
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- role — TINYINT — NOT NULL
- is_deleted — BIT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL