Rehal - Laravel Schema Designer

Users

id increments
name string
email string
password string
rule enum
phone_number string
profile_picture string

Merchants

id increments
user_id ^FK bigInteger
store_name string
store_address string

Products

id increments
merchant_id ^FK bigInteger
product_name string
description text
price decimal
image_url string

Guides

id increments
user_id ^FK bigInteger
guide_bio text
languages string

Tours

id increments
guide_id ^FK bigInteger
tour_name string
description text
price decimal
location string
available_dates date
max_capacity integer

Bookings

id increments
user_id ^FK bigInteger
tour_id ^FK bigInteger
booking_date date
number_of_guests integer
total_price decimal
payment_status enum

Landmarks

id increments
namr string
description text
location string
category string
image_url string

PaymentTransactions

id increments
booking_id ^FK bigInteger
transaction_id string
amount decimal
payment_status enum

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01