spots - Laravel Schema Designer

customers

id increments
timestamps timestamps
softDeletes softDeletes
code string (50)
name string (500)
customer_type_id ^FK integer
vat_required tinyInteger
vat_number string (50)
is_key_account tinyInteger
street string (500)
housenr string (20)
box string (20)
postal_code string (50)
city string (200)
country string (5)
invoice_street string (500)
invoice_housenr string (20)
invoice_box string (20)
invoice_postal_code string (50)
invoice_city string (200)
invoice_country string (5)
phone string (50)
mobile string (50)
email string (200)
website string (200)

customer_types

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)

contacts

id increments
timestamps timestamps
softDeletes softDeletes
firstname string (200)
surname string (200)
street string (200)
housenr string (20)
box string (20)
postal_code string (50)
city string (200)
country string (5)
email string (500)
phone string (50)
mobile string (50)

customer_contacts

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
contact_id ^FK integer
is_representative tinyInteger

customer_remarks

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
user_id ^FK integer
remark longText

tags

id increments
timestamps timestamps
softDeletes softDeletes
description string (50)

customer_tags

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
tag_id ^FK integer

bookings

id increments
timestamps timestamps
softDeletes softDeletes
center_id ^FK integer
customer_id ^FK integer
description string (200)
status_id string
expires_at datetime
alert_expiration tinyInteger
date_from datetime
date_to datetime
nbr_adults integer
nbr_children integer
nbr_groups integer
discount_pct decimal
discount_amount decimal
meal_provision_id ^FK integer
code string (50)
password string (50)

booking_statuses

id string (5)
timestamps timestamps
softDeletes softDeletes
description string (50)

users

id increments
timestamps timestamps
softDeletes softDeletes

centers

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)

rooms

id increments
timestamps timestamps
softDeletes softDeletes
code string (50)
description string (200)
capacity integer
comfort_type_id ^FK integer
floor integer
block_id ^FK integer

materials

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)

booking_rooms

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
room_id ^FK integer
room_type_id ^FK integer
date_from datetime
date_to datetime
nbr_people integer

booking_materials

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
material_id ^FK integer
date_from datetime
date_to datetime

booking_presences

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
room_id ^FK integer
firstname string (200)
surname string (200)
nationality string (5)
gender string (5)
date_from datetime
date_to datetime

locations

id increments
timestamps timestamps
softDeletes softDeletes
center_id ^FK integer
block_id ^FK integer
code string (50)
description string (200)
parent_id ^FK integer
location_type_id ^FK integer
capacity integer

comfort_types

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)

location_types

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)

room_types

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)
capacity integer

booking_locations

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
location_id ^FK integer
date_from datetime
date_to datetime

room_room_types

id increments
timestamps timestamps
softDeletes softDeletes
room_id ^FK integer
room_type_id ^FK integer
capacity integer
is_default tinyInteger

consumptions

id increments
timestamps timestamps
softDeletes softDeletes
center_id ^FK integer
description string (200)
unit string (20)
qty_bulk integer
category string (100)
sort_order integer

booking_consumptions

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
location_id ^FK integer
consumption_id ^FK integer
qty_start integer
qty_final integer
qty_start_bulk integer
qty_final_bulk integer

activities

id increments
timestamps timestamps
softDeletes softDeletes
description string (200)
monitor_required tinyInteger
duration integer
max_people integer

location_activities

id increments
timestamps timestamps
softDeletes softDeletes
location_id ^FK integer
activity_id ^FK integer

booking_activities

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
activity_id ^FK integer
monitor_required tinyInteger

booking_remarks

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
user_id ^FK integer
remark longText

meal_provisions

id increments
timestamps timestamps
softDeletes softDeletes
description string (50)
is_default tinyInteger

meal_types

id increments
timestamps timestamps
softDeletes softDeletes
center_id ^FK integer
description string (50)
timing_default time
timing_start time
timing_end time

meal_provision_types

id increments
timestamps timestamps
softDeletes softDeletes
meal_provision_id ^FK integer
meal_type_id ^FK integer
is_default tinyInteger

booking_meals

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
meal_type_id ^FK integer
date_meal date
timing time
nbr_adults integer
nbr_children integer

blocks

id increments
timestamps timestamps
softDeletes softDeletes
block_type_id ^FK integer
center_id ^FK integer
code string (50)
description string (50)

block_type

id increments
timestamps timestamps
softDeletes softDeletes
description string (50)

diets

id increments
timestamps timestamps
softDeletes softDeletes
description string (100)

booking_diets

id increments
timestamps timestamps
softDeletes softDeletes
booking_id ^FK integer
diet_id ^FK integer
nbr_adults integer
nbr_children integer

user_centers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
center_id ^FK integer
is_default tinyInteger