myfood222

Tables (13)

addresses

  • id — Primary key — NOT NULL
  • lat
  • lng
  • name

customer_profiles (Untitled3)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • address_id — Foreign key → addresses.id — NOT NULL
  • avatar
  • phone_number
  • first_name
  • last_name
  • notification_push
  • email_push

identities

  • id — Primary key — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • provider
  • provider_id
  • password_hash

menu_item_slots

  • id — Primary key — NOT NULL
  • slot_date
  • start_time
  • end_time
  • max_capacity
  • reserved_count
  • slot_type
  • menu_item_id — Foreign key → menu_items.id — NOT NULL

menu_items

  • id — Primary key — NOT NULL
  • restaurant_id
  • name
  • description
  • price
  • image_url (Field)

orders

  • id — Primary key — NOT NULL
  • customer_profile_id
  • restaurant_profile_id
  • status
  • sub_total
  • service_charge
  • shipping_fee
  • total_amount
  • net_amount
  • payment_status
  • stripe_transactions

otps

  • email — Primary key — NOT NULL
  • code
  • expires_at
  • verified_at
  • type

ratings

  • id — Primary key — NOT NULL
  • user_id
  • order_id
  • comment
  • star

restaurant_operating_hours

  • id — Primary key — NOT NULL
  • restaurant_id
  • day_of_week
  • open_time
  • close_time
  • is_active

restaurant_profiles

  • id — Primary key — NOT NULL
  • address_id — Foreign key → addresses.id — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • name
  • thumbnail
  • is_pickup
  • is_delivery
  • shipping_fee
  • phone_number
  • email_push
  • notification_push

stripe_transactions

  • id — Primary key — NOT NULL
  • order_id
  • stripe_pi_id
  • transaction_type
  • amount
  • application_fee
  • stripe_fee
  • status
  • raw_response

user_devices

  • id — Primary key — NOT NULL
  • user_id
  • fcm_token
  • device_type

users

  • id — Primary key — NOT NULL
  • email
  • active_role