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