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)