Store_Reservation
Tables (4)
Reservation
- id — INT
- store_id — INT — NOT NULL
- user_id — INT — NOT NULL
- reservationTime — DATETIME — NOT NULL
- status — ENUM('PENDING', 'CONFIRMED', 'CANCELLED') — NOT NULL
Review
- id — INT
- reservation_id — INT — NOT NULL
- user_id — INT — NOT NULL
- store_id — INT — NOT NULL
- rating — INT
- reviewText — TEXT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
Store
- id — INT
- name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- owner_id — INT — NOT NULL
- UNIQUE(name, — location)
User
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- role — ENUM('USER', 'OWNER')