test

Tables (52)

admin

  • id — bigint — Primary key — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • contact1 — varchar(255) — NOT NULL
  • contact2 — varchar(255) — NOT NULL
  • contact3 — varchar(255) — NOT NULL
  • department — varchar(255) — NOT NULL
  • duties — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • enabled — bit
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — varchar(255) — NOT NULL
  • user_id — varchar(15)
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint — Foreign key → museum.id — NOT NULL

admin_login_history

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • admin_id — bigint
  • ip — varchar(255)
  • user_id — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint

applicant_form_adult

  • id — bigint — Primary key — NOT NULL
  • address — varchar(255)
  • address_sub — varchar(255)
  • age — int
  • cellphone — varchar(255)
  • contact — varchar(255)
  • corona_vaccine — bit
  • email — varchar(255)
  • etc — varchar(255)
  • name — varchar(255)
  • zip_code — varchar(255)

applicant_form_child

  • id — bigint — Primary key — NOT NULL
  • child_name_age — varchar(255)
  • conductor_address — varchar(255)
  • conductor_address_sub — varchar(255)
  • conductor_cellphone — varchar(255)
  • conductor_contact — varchar(255)
  • conductor_corona_vaccine — bit
  • conductor_email — varchar(255)
  • conductor_etc — varchar(255)
  • conductor_name — varchar(255)
  • conductor_role — varchar(255)
  • conductor_zip_code — varchar(255)

applicant_form_disabled

  • id — bigint — Primary key — NOT NULL
  • conductors — int
  • group_address — varchar(255)
  • group_address_sub — varchar(255)
  • group_age — varchar(255)
  • group_class — varchar(255)
  • group_contact — varchar(255)
  • group_etc — varchar(255)
  • group_fax — varchar(255)
  • group_grade — varchar(255)
  • group_name — varchar(255)
  • group_nation — varchar(255)
  • group_zip_code — varchar(255)
  • lecturer_address — varchar(255)
  • lecturer_address_sub — varchar(255)
  • lecturer_birth1 — varchar(255)
  • lecturer_birth2 — varchar(255)
  • lecturer_birth3 — varchar(255)
  • lecturer_cellphone — varchar(255)
  • lecturer_contact — varchar(255)
  • lecturer_corona_vaccine — bit
  • lecturer_email — varchar(255)
  • lecturer_job_role — varchar(255)
  • lecturer_job_title — varchar(255)
  • lecturer_name — varchar(255)
  • lecturer_school_grade — varchar(255)
  • lecturer_subject — varchar(255)
  • lecturer_zip_code — varchar(255)
  • school_type — varchar(255)
  • members — bigint
  • volunteers — int

applicant_form_family

  • id — bigint — Primary key — NOT NULL
  • conductor_address — varchar(255)
  • conductor_address_sub — varchar(255)
  • conductor_cellphone — varchar(255)
  • conductor_contact — varchar(255)
  • conductor_corona_vaccine — bit
  • conductor_email — varchar(255)
  • conductor_etc — varchar(255)
  • conductor_name — varchar(255)
  • conductor_role — varchar(255)
  • conductor_zip_code — varchar(255)
  • family_members — longtext

applicant_form_group

  • id — bigint — Primary key — NOT NULL
  • conductor_address — varchar(255)
  • conductor_address_sub — varchar(255)
  • conductor_cellphone — varchar(255)
  • conductor_contact — varchar(255)
  • conductor_corona_vaccine — bit
  • conductor_email — varchar(255)
  • conductor_etc — varchar(255)
  • conductor_name — varchar(255)
  • conductor_role — varchar(255)
  • conductor_zip_code — varchar(255)
  • conductors — int
  • group_address — varchar(255)
  • group_address_sub — varchar(255)
  • group_age — varchar(255)
  • group_class — varchar(255)
  • group_contact — varchar(255)
  • group_etc — varchar(255)
  • group_fax — varchar(255)
  • group_grade — varchar(255)
  • group_name — varchar(255)
  • group_nation — varchar(255)
  • group_zip_code — varchar(255)
  • members — bigint

applicant_form_multicultural

  • id — bigint — Primary key — NOT NULL
  • conductor_address — varchar(255)
  • conductor_address_sub — varchar(255)
  • conductor_cellphone — varchar(255)
  • conductor_contact — varchar(255)
  • conductor_corona_vaccine — bit
  • conductor_email — varchar(255)
  • conductor_etc — varchar(255)
  • conductor_name — varchar(255)
  • conductor_role — varchar(255)
  • conductor_zip_code — varchar(255)
  • conductors — int
  • group_address — varchar(255)
  • group_address_sub — varchar(255)
  • group_age — varchar(255)
  • group_class — varchar(255)
  • group_contact — varchar(255)
  • group_etc — varchar(255)
  • group_fax — varchar(255)
  • group_grade — varchar(255)
  • group_name — varchar(255)
  • group_nation — varchar(255)
  • group_zip_code — varchar(255)
  • members — bigint
  • volunteers — int

banner

  • id — bigint
  • created_date_time — datetime
  • modified_date_time — datetime
  • display_end_date_time — datetime(6)
  • link — varchar(255)
  • open — bit
  • removed — bit
  • title — varchar(255) — NOT NULL
  • creator_id — bigint
  • modifier_id — bigint
  • image_file_id — varchar(255) — NOT NULL
  • image_file_mobile_id — varchar(255) — NOT NULL
  • manager_id — bigint — NOT NULL

board

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • content — longtext — NOT NULL
  • display — bit — NOT NULL
  • fixed — bit
  • language — char(2)
  • license — varchar(255)
  • removed — bit
  • title — varchar(100) — NOT NULL
  • type — varchar(255) — NOT NULL
  • view_count — int — NOT NULL
  • creator_id — bigint
  • modifier_id — bigint
  • content_type_id — bigint
  • manager_id — bigint
  • museum_id — bigint

board_upload_file

  • board_id — bigint — NOT NULL
  • upload_files_id — varchar(255) — NOT NULL

category

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • display — bit — NOT NULL
  • init — bit — NOT NULL
  • name — varchar(255)
  • name_en — varchar(255)
  • order_number — bigint
  • removed — bit
  • type — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint

collection_contents_collection_story

  • id — bigint
  • contents_id — bigint
  • story_id — bigint

collection_story

  • id — bigint — Primary key — NOT NULL
  • image_url — varchar(255)
  • name — varchar(255)
  • order_number — bigint

contents

  • type — varchar(31) — NOT NULL
  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • description — longtext
  • language — char(2) — NOT NULL
  • license — varchar(10)
  • open — bit — NOT NULL
  • removed — bit
  • view_count — bigint
  • title — varchar(255) — NOT NULL
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint — NOT NULL
  • thumbnail_id — varchar(255) — NOT NULL

contents_activity

  • id — bigint — Primary key — NOT NULL

contents_activity_upload_file

  • activity_contents_id — bigint — NOT NULL
  • upload_files_id — varchar(255) — NOT NULL

contents_collection

  • id — bigint — Primary key — NOT NULL
  • collection_description — longtext
  • collection_id — varchar(255)
  • material_name1 — varchar(255)
  • material_name2 — varchar(255)
  • name — varchar(255)
  • name_cn — varchar(255)
  • nationality_name1 — varchar(255)
  • nationality_name2 — varchar(255)
  • purpose_name1 — varchar(255)
  • purpose_name2 — varchar(255)
  • purpose_name3 — varchar(255)
  • relic_no — varchar(255)
  • size_info — varchar(255)

contents_collection_upload_file

  • collection_contents_id — bigint — NOT NULL
  • upload_files_id — varchar(255) — NOT NULL

contents_like_user

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • user_id — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint
  • contents_id — bigint

contents_recommend_activity

  • contents_id — bigint — Primary key — NOT NULL
  • recommend_activity_contents_id — bigint — Primary key — NOT NULL

contents_recommend_research

  • research_contents_id — bigint — Primary key — NOT NULL
  • recommend_research_contents_id — bigint — Primary key — NOT NULL

contents_recommend_video

  • contents_id — bigint — Primary key — NOT NULL
  • recommend_video_contents_id — bigint — Primary key — NOT NULL

contents_research

  • id — bigint — Primary key — NOT NULL

contents_research_upload_file

  • research_contents_id — bigint — NOT NULL
  • upload_files_id — varchar(255) — NOT NULL

contents_theme_category

  • id — bigint
  • category_id — bigint
  • contents_id — bigint

contents_video

  • id — bigint — Primary key — NOT NULL
  • audio_file_id — varchar(255)
  • video_file_id — varchar(255)

contents_view_user

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • user_id — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint
  • contents_id — bigint

education

  • id — bigint
  • created_date_time — datetime
  • modified_date_time — datetime
  • applicant_form_type — varchar(255)
  • applicant_type — varchar(255)
  • apply_date_type — varchar(255)
  • apply_end_date_time — datetime(6)
  • apply_end_days_before — int
  • apply_end_hours — int
  • apply_group — bit
  • apply_link — varchar(255)
  • apply_start_date_time — datetime(6)
  • apply_start_days_before — int
  • apply_start_hours — int
  • apply_type — varchar(255)
  • cancel_date_type — varchar(255)
  • cancel_days_before — int
  • cancel_end_date_time — datetime(6)
  • cancel_hours — int
  • capacity — bigint
  • group_capacity — bigint
  • round_days — varchar(255)
  • use_round — bit
  • description — longtext
  • education_fee — varchar(255)
  • manager_contact — varchar(255)
  • manager_department — varchar(255)
  • manager_name — varchar(255)
  • subject — varchar(300)
  • end_date — date
  • location — varchar(150)
  • name — varchar(250)
  • start_date — date
  • target_description — varchar(255)
  • open — bit
  • open_date_time — datetime(6)
  • removed — bit
  • auto_display — bit
  • except_no_show — bit
  • selection_message — varchar(1500)
  • selection_method_type — varchar(255)
  • waiting — bit
  • waiting_auto_display — bit
  • waiting_auto_selection — bit
  • waiting_maximum_count — int
  • view_count — bigint
  • status — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint
  • target_id — bigint
  • thumbnail_id — varchar(255)

education_apply_method_types

  • education_id — bigint — NOT NULL
  • apply_method_types — varchar(255)

education_contents

  • education_id — bigint — NOT NULL
  • related_contents_id — bigint — NOT NULL

education_like_user

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • user_id — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint
  • education_id — bigint

education_round

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • applicant_limit — bigint
  • display — bit
  • end_date_time — datetime(6)
  • round — bigint
  • selection_open — bit
  • start_date_time — datetime(6)
  • title — varchar(300)
  • creator_id — bigint
  • modifier_id — bigint
  • education_id — bigint

education_round_applicant

  • type — varchar(31) — NOT NULL
  • id — bigint
  • cancel_date_time — datetime(6)
  • created_date_time — datetime
  • display_state — varchar(255)
  • etc_info_agree — tinyint(1)
  • modified_date_time — datetime
  • photo — tinyint(1)
  • request_date — date
  • selection_message — varchar(1500)
  • sent_selection_message — bit — NOT NULL
  • state — varchar(255)
  • total_participant_admin — bigint
  • user_id — varchar(255)
  • waiting_number — bigint
  • modifier_id — bigint
  • round_id — bigint

emuseum_collection

  • id — bigint
  • collection_id — varchar(255)
  • story_id — bigint — NOT NULL

event

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • bummer_count — int
  • contents — longtext — NOT NULL
  • interesting_count — int
  • language — char(2) — NOT NULL
  • open — bit — NOT NULL
  • removed — bit
  • title — varchar(100) — NOT NULL
  • useful_count — int
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint — NOT NULL

event_emoji_user

  • id — bigint
  • created_date_time — datetime(6)
  • emoji_type — varchar(255)
  • user_id — varchar(255) — NOT NULL
  • event_id — bigint

extern_whitelist

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • ip — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint

lecturer

  • id — bigint
  • created_date_time — datetime
  • modified_date_time — datetime
  • contact — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • total_education_minutes — bigint
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint

museum

  • id — bigint — Primary key — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • name — varchar(255) — NOT NULL
  • name_en — varchar(255) — NOT NULL
  • order_number — bigint
  • creator_id — bigint
  • modifier_id — bigint

quiz

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • bummer_count — int
  • event_end_date — date
  • event_start_date — date
  • interesting_count — int
  • language — char(2) — NOT NULL
  • lottery_numbers — bigint
  • open — bit — NOT NULL
  • removed — bit — NOT NULL
  • select_winners — bit
  • title — varchar(500) — NOT NULL
  • type — varchar(255) — NOT NULL
  • useful_count — int
  • creator_id — bigint
  • modifier_id — bigint
  • museum_id — bigint — NOT NULL

quiz_participant

  • quiz_id — bigint — Primary key — NOT NULL
  • user_id — varchar(255) — Primary key — NOT NULL
  • completed — bit
  • created_date_time — datetime
  • emoji_type — varchar(255)
  • address — varchar(255)
  • contact — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • zip_code — varchar(255)
  • modified_date_time — datetime(6)
  • sent_winner_message — bit — NOT NULL
  • winner — bit

quiz_theme_category

  • id — bigint
  • category_id — bigint — NOT NULL
  • quiz_id — bigint — NOT NULL

statistics_daily_site_access

  • date — date — Primary key — NOT NULL
  • created_date_time — datetime
  • page_views — bigint
  • visitors — bigint

statistics_page_view

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • locale — varchar(255)
  • title — varchar(255)
  • uri — varchar(255)
  • views — bigint

survey

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • description — longtext — NOT NULL
  • end_date_time — datetime(6) — NOT NULL
  • removed — bit
  • start_date_time — datetime(6) — NOT NULL
  • status — varchar(255)
  • title — varchar(255) — NOT NULL
  • creator_id — bigint
  • modifier_id — bigint
  • manager_id — bigint — NOT NULL

survey_participant

  • id — bigint
  • created_date_time — datetime
  • modified_date_time — datetime
  • contact — varchar(255)
  • sent_message — varchar(255)
  • sent_message_date_time — datetime(6)
  • user_id — varchar(255)
  • survey_id — bigint

survey_participant_answer

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • answer — varchar(255)
  • order_number — bigint
  • score — int
  • participant_id — bigint — NOT NULL
  • question_id — bigint — NOT NULL

survey_participant_answer_option

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • order_number — int — NOT NULL
  • answer_id — bigint
  • question_option_id — bigint

survey_question

  • id — bigint — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • order_number — bigint
  • question — varchar(255) — NOT NULL
  • end_label — varchar(255)
  • score_end — bigint
  • score_start — bigint
  • start_label — varchar(255)
  • type — varchar(255)
  • creator_id — bigint
  • modifier_id — bigint
  • survey_id — bigint

survey_question_option

  • id — bigint
  • order_number — bigint
  • text — varchar(255) — NOT NULL
  • question_id — bigint

upload_file

  • id — varchar(255) — Primary key — NOT NULL
  • type — varchar(31) — NOT NULL
  • created_date_time — datetime
  • modified_date_time — datetime
  • file_type — varchar(255)
  • name — varchar(255)
  • size — bigint
  • url — varchar(255) — NOT NULL
  • alt_text — varchar(255)
  • play_time — bigint
  • creator_id — bigint
  • modifier_id — bigint