quantity_survey_company - Laravel Schema Designer

admins

id smallIncrements
username string (100)
password string (60)
email string (100)
account string (40)
timestamps timestamps
created_user string
updated_user string

company_offices

company_id string (7)
email string
password string
firstname string
lastname string
timestamps timestamps
created_user string
updated_user string

companies

company_id string (7)
email string
password string (6)
first_login_flag tinyInteger
last_date_do_survey datetime
additional_flag tinyInteger
sale_staff_id string (20)
company_name string
business_type_id tinyInteger
charter_capital integer
number_employee integer
is_stock_exchange tinyInteger
core_value text
note text
timestamps timestamps
created_user string
updated_user string

respondents

email string
company_id string (7)
active_flag tinyInteger
staff_code string (10)
firstname string (40)
lastname string (40)
affiliation_name_large string (200)
affiliation_name_medium string (200)
affiliation_name_small string (200)
hierarchy string (200)
position string (200)
date_start datetime
gender tinyInteger
created_user string
updated_user string
timestamps timestamps

operation_logs

operation_log_id increments
timestamps timestamps
operator_role tinyInteger
operator_email string
operator_id string
operator_first_name string (40)
operator_last_name string (40)
company_id string (7)
operation_time datetime
screen string
screen_action string
operation_type string
operation_detail text
created_user string
updated_user string

survey_schedules

company_id string (7)
schedule_number integer
first_send_at datetime
remind_at datetime
deadline_at datetime
survey_type tinyInteger
qc_survey_number integer
cycle_handle_priority_task tinyInteger
priority_task_schedule_number integer
priority_task_question_code string (7)
sending_status tinyInteger
total_send integer
total_answer integer
answer_rate float (5,2)
price integer
payment_money integer
score float (5,2)
evaluation_rank string (2)
timestamps timestamps
created_user string
updated_user string

survey_answer_states

company_id string (7)
schedule_number integer
aggregated_unit_classify tinyInteger
aggregated_unit_name string (200)
total_send integer
total_answer integer
timestamps timestamps
answer_rate float (5,2)
created_user string
updated_user string

evaluation_surveys_by_evaluation_subclass

company_id string (7)
schedule_number integer
evaluation_subclass_code string (20)
aggregated_unit_classify tinyInteger
aggregated_unit_name string (200)
evaluation_subclass_name string (100)
score float (5,2)
average_point float (5,2)
evaluation_class_code string (20)
timestamps timestamps
deleted_at datetime
created_user string
updated_user string

evaluation_surveys_by_evaluation_class

company_id string (7)
schedule_number integer
evaluation_class_code string (20)
evaluation_class_name string (100)
score float (5,2)
average_point float (5,2)
evaluation_rank string (2)
evaluation_comment text
evaluation_comment_graph text
timestamps timestamps
created_user string
updated_user string

evaluation_class_evaluation_ranks

evaluation_class_code string (20)
evaluation_main_rank string (1)
evaluation_comment text
timestamps timestamps
created_user string
updated_user string

evaluation_class_graph_evaluation_comments

evaluation_class_code string (20)
graph_quadrant tinyInteger
evaluation_comment text
timestamps timestamps
created_user string
updated_user string

evaluation_ranks

evaluation_rank string (2)
evaluation_main_rank string (1)
min_score float (5,2)
max_score float (5,2)
emphasized_display_flag tinyInteger
timestamps timestamps
created_user string
updated_user string

question_evaluation_surveys

company_id string (7)
schedule_id integer
question_code string (20)
aggregated_unit_classify tinyInteger
aggregated_unit_name string (200)
question_subclass_code string (20)
evaluation_subclass_code string (20)
score float (5,2)
average_point float (5,2)
count_five_point_answer integer
count_four_point_answer integer
count_three_point_answer integer
count_two_point_answer integer
count_one_point_answer integer
rate_five_point_answer float (5,2)
rate_four_point_answer float (5,2)
rate_three_point_answer float (5,2)
rate_two_point_answer float (5,2)
rate_one_point_answer float (5,2)
timestamps timestamps
created_user string
updated_user string

ax_companies

timestamps timestamps
company_id string (7)
name string (80)
business_type integer
charter_capital integer
number_employee integer
is_stock_exchange tinyInteger
core_value text
note text
created_user string
updated_user string

business_types

business_type_id integer
business_name string (100)
timestamps timestamps
created_user string
updated_user string

business_type_infos

year smallInteger
business_type_id integer
min_number_employee integer
max_number_employee integer
revenue float (5,2)
operating_profit_graph_max_value bigInteger
operating_profit_graph_min_value bigInteger
operating_profit_avg bigInteger
normal_profit_graph_max_value bigInteger
normal_profit_graph_min_value bigInteger
normal_profit_avg bigInteger
cf_matrix_max_value bigInteger
cf_matrix_min_value bigInteger
cf_operation bigInteger
cf_investment bigInteger
cf_finance bigInteger
cf_free bigInteger
timestamps timestamps
created_user string
updated_user string

company_usage_status_of_systems

timestamps timestamps
company_id string (7)
usage_time smallInteger
do_qc_survey_flag tinyInteger
total_send integer
total_answer integer
answer_rate float (5,2)
amount_request float (5,2)
expected_time_payment datetime
payment_confirmation_flag tinyInteger
created_user string
updated_user string

company_infos

timestamps timestamps
company_id string (7)
year smallInteger
revenue bigInteger
operating_income bigInteger
ordinary_income bigInteger
cf_operation bigInteger
cf_investment bigInteger
cf_finance bigInteger
cf_free bigInteger
ceo_name string (80)
core_value text
created_user string
updated_user string

improvement_activities

company_id string (7)
schedule_number integer
improvement_activity_status tinyInteger
before_plus_comment_posi text
before_plus_comment_nega text
before_minus_comment_posi text
before_minus_comment_nega text
before_solution_posi text
before_solution_nega text
after_plus_comment_posi text
after_plus_comment_nega text
after_minus_comment_posi text
after_minus_comment_nega text
after_solution_posi text
after_solution_nega text
timestamps timestamps
created_user string
updated_user string

improvement_activity_themes

timestamps timestamps
company_id string (7)
schedule_number integer
theme_number tinyInteger
theme_name string (200)
complete_date datetime
remind_date datetime
plan text
do text
check text
action text
created_user string
updated_user string

improvement_activity_scores

company_id string (7)
schedule_number integer
aggregated_unit_classify tinyInteger
aggregated_unit_name string (200)
qc_survey_score float (5,2)
qc_survey_average_point float (5,2)
before_score float (5,2)
before_average_point float (5,2)
after_score float (5,2)
after_average_point float (5,2)
timestamps timestamps
created_user string
updated_user string

respondent_surveys

company_id string (7)
schedule_number integer
email string
answer_status tinyInteger
answer_screen_url text
timestamps timestamps
created_user string
updated_user string

question_lists_surveys

timestamps timestamps
company_id string (7)
schedule_number integer
email_address string
question_code string (20)
question_subclass_code string (20)
evaluation_subclass_code string (20)
question_content string (200)
question_type string (20)
answer_result text
created_user string
updated_user string

questions

timestamps timestamps
question_code string (20)
question_subclass_code string (20)
evaluation_subclass_code string (20)
survey_type tinyInteger
qc_survey_question_code string (20)
question_content string (200)
question_type string (20)
created_user string
updated_user string

question_classes

timestamps timestamps
question_class_code string (20)
question_class_name string (100)
answer_title string (100)
answer_subtitle string (100)
created_user string
updated_user string

question_subclasses

question_subclass_code string (20)
question_subclass_name string (100)
question_class_code string (20)
timestamps timestamps
created_user string
updated_user string

evaluation_classes

evaluation_class_code string (20)
evaluation_class_name string (100)
report_title_alphabet string (100)
report_title string (100)
timestamps timestamps
created_user string
updated_user string

evaluation_subclasses

timestamps timestamps
evaluation_subclass_code string (20)
evaluation_subclass_name string (100)
evaluation_class_code string (20)
created_user string
updated_user string

survey_type_priority_process_periods

timestamps timestamps
survey_type tinyInteger
cycle_handle_priority_task tinyInteger
payment_type tinyInteger
price integer
created_user string
updated_user string

survey_types

survey_type tinyInteger
survey_name string (100)
survey_short_name string (100)
timestamps timestamps
created_user string
updated_user string