myfood

Tables (13)

address (CopyOfUntitled2)

  • 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 → address.id — NOT NULL
  • avatar
  • phone_number
  • first_name
  • last_name
  • notification_push
  • email_push

identities (Untitled)

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

menu_item_slots (Untitled7)

  • 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 (Untitled8)

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

orders (Untitled4)

  • 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 (Untitled10)

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

restaurant_operating_hours (Untitled6)

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

restaurant_profiles (CopyOfUntitled3)

  • id — Primary key — NOT NULL
  • address_id — Foreign key → address.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 (Untitled5)

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

user_devices (Untitled9)

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

users (Untitled2)

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