raf
Tables (9)
Favorites
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- restaurant_id — INT — Foreign key → Restaurant.id
Raffle
- id — INT — Primary key
- restaurant_id — INT — Foreign key → Restaurant.id
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME — NOT NULL
- available_seats — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
Raffle_Participant
- id — INT — Primary key
- user_id — INT — Foreign key → User.id — NOT NULL
- raffle_id — INT — Foreign key → Raffle.id
- entry_datetime — DATETIME — NOT NULL
- is_winner — BOOLEAN
- notification_sent — BOOLEAN
Reservation
- id — INT — Primary key
- raffle_id — INT — Foreign key → Raffle.id
- raffle_participant_id — INT — Foreign key → Raffle_Participant.id
- reservation_datetime — DATETIME — NOT NULL
- party_size — INT — NOT NULL
- special_requests — TEXT
- status — VARCHAR(20) — NOT NULL
Restaurant
- id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- address — TEXT — NOT NULL
- description — TEXT
- cuisine_type — VARCHAR(50)
- opening_hours — TIME — NOT NULL
- closing_hours — TIME — NOT NULL
- max_capacity — INT — NOT NULL
Restaurant_Image
- id — INT — Primary key
- id (id2) — INT — Foreign key → Restaurant.id
- restaurant_id — INT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- image_description — TEXT
- is_primary — BOOLEAN
Reviews
- id — INT — Primary key
- user_id — INT — Foreign key → User.id — NOT NULL
- restaurant_id — INT — Foreign key → Restaurant.id
- rating — INT — NOT NULL
- comment — TEXT — EX
- review_date — DATE — NOT NULL
Reviews_Image
- id — INT — Primary key — NOT NULL
- id (id2) — INT — Foreign key → Reviews.id
- image_rul (image_url) — VARCHAR(255)
User
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)