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