hmmi_factory_tour_db - Laravel Schema Designer

user

id increments
timestamps timestamps
softDeletes softDeletes

tour_type

id increments
name string
description text
minimum_participant smallInteger
maximum_participant smallInteger
timestamps timestamps
softDeletes softDeletes

group_type

id increments
name string
description text
timestamps timestamps
softDeletes softDeletes

tour

id increments
tour_type_id ^FK bigInteger
group_type_id ^FK bigInteger
tour_number string
name string
tour_date datetime
reschedule_reason text
vehicle_type enum
vehicle_plate_number string
timestamps timestamps
softDeletes softDeletes

tour_participant

id increments
tour_id ^FK bigInteger
name string
age string
sex enum
email string
city string
is_leader tinyInteger
is_special_need tinyInteger
verification_code string
verified_at timestamp
timestamps timestamps
softDeletes softDeletes

tour_feedback

id increments
rating float
description string
timestamps timestamps
softDeletes softDeletes

banner

id increments
name string
description text
image_path string
link_url string
is_active tinyInteger
timestamps timestamps
softDeletes timestamp

article

id increments
name string
content longText
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

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