ddd
Tables (4)
Reservation
- id — BIGINT
- reservationTime — DATETIME — NOT NULL
- checkedIn — BOOLEAN — NOT NULL
- approved — BOOLEAN — NOT NULL
- store_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
Review
- id — BIGINT
- rating — INT — NOT NULL
- comment — VARCHAR(1000) — ARCHAR(1000
- store_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
Store
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- address — VARCHAR(255)
- manager_id — BIGINT
User
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL