thomsonbiketours - Laravel Schema Designer

baskets

id increments
customer_id integer
contact_id string
booking_id bigInteger
tour_id string
currency_code string
total_passenger_count integer
deposit_amount bigInteger
promo_code string
reservation_id string
sugati_response longText
timestamps timestamps

basket_bikes

id increments
bike_id string
basket_id bigInteger
name string
price integer
quantity integer
timestamps timestamps

basket_rooms

id increments
room_type_id string
basket_id bigInteger
name string
price integer
quantity integer
product_id smallInteger
timestamps timestamps

payments

id increments
payment_intent_id string
basket_id bigInteger
amount decimal
status string
booking_id smallInteger
timestamps timestamps

bookings

id increments
booking_id string
contact_id string
tour_id string
total_price decimal
total_paid decimal
sugati_confirmed boolean
sugati_response longText
timestamps timestamps

products

id increments
sugati_id string
product string
type string
timestamps timestamps

customers

id increments
sugati_id string
email_address string
password string
billing_address longText
card_token longText
timestamps timestamps

basket_guests

id increments
lead_passenger_id smallInteger
basket_id smallInteger
rider boolean
timestamps timestamps

rooms

id increments
product_id smallInteger
sugati_id string
product string
type string
occupancy_limit smallInteger
timestamps timestamps
additional_fields longText

extras

id increments
product_id smallInteger
sugati_id string
product string
type string
additional_fields longText
timestamps timestamps

basket_extras

id increments
basket_id smallInteger
type string
timestamps timestamps

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