TransportCard - Laravel Schema Designer

tc_stages

id increments
timestamps timestamps
softDeletes softDeletes
name string

tc_questions

id increments
timestamps timestamps
softDeletes softDeletes
tc_question_type_id ^FK integer
name string

tc_forms

id increments
timestamps timestamps
softDeletes softDeletes
tc_question_id ^FK integer
tc_form_type_id ^FK integer

tc_form_types

id increments
timestamps timestamps
softDeletes softDeletes
tc_stages_id ^FK integer
name string

tc_question_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
is_path boolean
is_multiple boolean
is_trip boolean

tc_question_answers

id increments
timestamps timestamps
softDeletes softDeletes
tc_establishment_id ^FK integer
tc_form_id ^FK integer
tc_question_id ^FK integer
answer string

tc_path

id increments
timestamps timestamps
softDeletes softDeletes
name string

tc_establishment

id increments
timestamps timestamps
softDeletes softDeletes

tc_option_lockup

id increments
timestamps timestamps
softDeletes softDeletes
tc_establishment_id ^FK integer
tc_path_id ^FK integer
tc_form_id ^FK integer
order integer

tc_trips

id increments
timestamps timestamps
softDeletes softDeletes
time_from integer
time_to integer
pilgrim_count integer
tc_form_id ^FK integer
tc_establishment_id ^FK integer

tc_operations

id increments
timestamps timestamps
softDeletes softDeletes
tc_stages_id ^FK integer
operation_sign string
starting_point string
arrival_point string

arrival_answers

id increments
timestamps timestamps
softDeletes softDeletes
arrival_form_name string
stage string
time_range string
number_of_pilgrims_coming_to_this_port integer
access_port string
port_name string
port_code string
starting_point string
arrival_point string
operation_code string
time_period_for_the_arrival_of_pilgrims_from integer
time_period_for_the_arrival_of_pilgrims_to integer
target_number_of_pilgrims_per_day_percentage integer
target_number_of_pilgrims_per_day_number integer
transfer_pattern string
operating_requirements string
number_of_daily_buses integer
number_of_drivers integer
regimental_commanders_for_the_target_setting integer
number_of_guides integer
assistant_regimental_commanders integer
Operation_capabilities string
manpower integer
devices integer
cars integer
supervision_capabilities string
manpower_supervision integer
devices_supervision integer
cars_supervision integer
challenges string
solutions string

moving_between_cities_answers

id increments
timestamps timestamps
softDeletes softDeletes
moving_between_cities_form_name string
stage string
starting_point string
arrival_point string
operation_code string
time_range_from integer
time_range_to integer
number_of_pilgrims_coming_to_mecca integer
percent_of_pilgrims_coming_to_mecca integer
time_period_for_the_arrival_of_pilgrims_from integer
time_period_for_the_arrival_of_pilgrims_to integer
target_number_of_pilgrims_per_day integer
daily_departure_time_limit_from integer
daily_departure_time_limit_to string
daily_departure_pilgrims_number integer
operating_requirements string
number_of_daily_buses string
number_of_drivers string
regimental_commanders_for_the_target_setting string
number_of_responses_to_the_bus integer
number_of_guides integer
assistant_regimental_commanders integer
Operation_capabilities string
manpower integer
devices string
supervision_capabilities string
manpower_supervision string
devices_supervision integer
challenges string
solutions string

performing_rituals_answers

id increments
timestamps timestamps
softDeletes softDeletes
performing_rituals_form_name string
stage string
starting_point string
arrival_point string
operation_code string
time_range_from integer
time_range_to integer
time_for_performing_the_tawaf_from integer
time_for_performing_the_tawaf_to integer
operating_requirements string
number_of_daily_buses integer
number_of_drivers string
regimental_commanders_for_the_target_setting integer
number_of_responses_to_the_bus integer
number_of_guides integer
assistant_regimental_commanders integer
Operation_capabilities string
manpower integer
devices string
cars integer
supervision_capabilities string
manpower_supervision integer
devices_supervision integer
cars_supervision integer
challenges string
solutions string

sacred_sites_answers

id increments
timestamps timestamps
softDeletes softDeletes

moving_between_cities_2_answers

id increments
timestamps timestamps
softDeletes softDeletes

leaving_answers

id increments
timestamps timestamps
softDeletes softDeletes

arrival_paths

id increments
timestamps timestamps
softDeletes softDeletes
arrival_answer_id ^FK integer
name integer
order integer
number integer

moving_between_cities_paths

id increments
timestamps timestamps
softDeletes softDeletes
name string
order integer
moving_between_cities_answer_id ^FK integer

transfer_pattern

id increments
timestamps timestamps
softDeletes softDeletes
name string
moving_between_cities_answer_id ^FK integer
number_of_pilgrims integer

performing_rituals_answer_paths

id increments
timestamps timestamps
softDeletes softDeletes
name string
order integer
performing_rituals_answer_id ^FK integer

performing_rituals_answer_transfer_patterns

id increments
timestamps timestamps
softDeletes softDeletes
name string
number_of_pilgrims integer
performing_rituals_answer_id ^FK integer

performing_rituals_answer_trips

id increments
timestamps timestamps
softDeletes softDeletes
name integer
date integer
number_of_pilgrims integer
performing_rituals_answer_id ^FK integer

arrival_transfer_pattern

id increments
timestamps timestamps
softDeletes softDeletes
arrival_answer_id ^FK integer
name string
number_of_pilgrim integer

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