test
Tables (30)
admin
- id — varchar(40) — NOT NULL
- role_id — varchar(40) — NOT NULL
- dept_id — varchar(40) — NOT NULL
- name — varchar(10) — NOT NULL
- account — varchar(30) — NOT NULL
- password — varchar(127) — NOT NULL
answer
- id — varchar(40) — NOT NULL
- title — varchar(128) — NOT NULL
- admin_id — varchar(40) — NOT NULL
- question_id — varchar(40) — NOT NULL
- content — mediumtext — NOT NULL
- created_at — timestamp — NOT NULL
attachment
- url — varchar(768) — NOT NULL
- origin_name — varchar(60) — NOT NULL
- origin_mb — smallint — NOT NULL
- question_id — varchar(40)
- notice_id — varchar(40)
- answer_id — varchar(40)
department
- id — varchar(40) — NOT NULL
- name — varchar(10) — NOT NULL
event
- id — varchar(40) — NOT NULL
- name_kr — varchar(50) — NOT NULL
- name_eng — varchar(50)
- start_date — datetime — NOT NULL
- region — varchar(20) — NOT NULL
- event_type — varchar(20) — NOT NULL
- host — varchar(20) — NOT NULL
- organizer — varchar(20) — NOT NULL
- regist_maximum — int — NOT NULL
- main_banner_color — varchar(30) — NOT NULL
- main_banner_pc_image_url — text — NOT NULL
- main_banner_mobile_image_url — text — NOT NULL
- main_outline_pc_image_url — text — NOT NULL
- main_outline_mobile_image_url — text — NOT NULL
- promotion_banner — text — NOT NULL
- event_outline_page_image_url — text — NOT NULL
- notice_page_image_url — text — NOT NULL
- souvenir_page_image_url — text — NOT NULL
- meeting_place_page_image_url — text — NOT NULL
- result_image_url — text — NOT NULL
- course_page_image_url — text — NOT NULL
- events_page_url — text — NOT NULL
- event_status — varchar(10) — NOT NULL
- visible_status — tinyint(1) — NOT NULL
- bank — varchar(50)
- virtual_account — varchar(255)
- regist_deadline — datetime — NOT NULL
- payment_deadline — datetime — NOT NULL
- side_menu_banner_image_url — text — NOT NULL
- regist_start_date — datetime
event_banner
- image_url — varchar(768) — NOT NULL
- event_id — varchar(40) — NOT NULL
- url — varchar(768)
- banner_type — varchar(10) — NOT NULL
- provider_name — varchar(20) — NOT NULL
- is_static — tinyint(1) — NOT NULL
event_category
- id — varchar(40) — NOT NULL
- event_id — varchar(40) — NOT NULL
- name — varchar(50) — NOT NULL
- amount — decimal(12, 2) — NOT NULL
event_category_souvenir
- id — varchar(40) — NOT NULL
- event_category_id — varchar(40) — NOT NULL
- souvenir_id — varchar(40) — NOT NULL
- created_at — timestamp
faq
- id — varchar(40) — NOT NULL
- problem — varchar(100) — NOT NULL
- solution — text — NOT NULL
- event_id — varchar(40)
- created_at — datetime — NOT NULL
gallery
- id — varchar(40) — NOT NULL
- thumbnail_url — text — NOT NULL
- google_url — varchar(255) — NOT NULL
- event_name — varchar(255) — NOT NULL
- event_start_date — date — NOT NULL
- tag_name — varchar(100)
main_banner
- id — varchar(40) — NOT NULL
- title — varchar(100) — NOT NULL
- sub_title — varchar(100) — NOT NULL
- date — varchar(30) — NOT NULL
- image_url — text — NOT NULL
- order_no — int — NOT NULL
- event_id — varchar(40) — NOT NULL
notice
- id — varchar(40) — NOT NULL
- category_id — varchar(40) — NOT NULL
- admin_id — varchar(40) — NOT NULL
- event_id — varchar(40)
- title — varchar(50) — NOT NULL
- content — mediumtext — NOT NULL
- created_at — timestamp — NOT NULL
- view_count — bigint — NOT NULL
notice_category
- id — varchar(40) — NOT NULL
- name — varchar(20) — NOT NULL
organization
- id — varchar(40) — NOT NULL
- account — varchar(30) — NOT NULL
- account_password — varchar(127) — NOT NULL
- group_name — varchar(30) — NOT NULL
- leader_name — varchar(30) — NOT NULL
- leader_birth — varchar(10) — NOT NULL
- leader_ph_num — varchar(14) — NOT NULL
- email — varchar(320) — NOT NULL
- event_id — varchar(40) — NOT NULL
- created_at — datetime
payment
- id — varchar(40) — NOT NULL
- registrations_id — varchar(40) — NOT NULL
- payment_method_id — varchar(40) — NOT NULL
- amount — decimal(12, 2) — NOT NULL
- deposit_date — timestamp
- virtual_account_number — varchar(14)
- paymenter_name — varchar(30) — NOT NULL
- status — varchar(40) — NOT NULL
payment_method
- id — varchar(40) — NOT NULL
- payment_method — varchar(20) — NOT NULL
pickup_place
- id — varchar(40) — NOT NULL
- shuttle_id — varchar(40) — NOT NULL
- place_name — varchar(50) — NOT NULL
- pickup_time — timestamp — NOT NULL
popup
- id — varchar(40) — NOT NULL
- url — text — NOT NULL
- imageUrl — text — NOT NULL
- device — varchar(40) — NOT NULL
- start_at — datetime — NOT NULL
- end_at — datetime — NOT NULL
- order_no — int — NOT NULL
- event_id — varchar(40)
question
- id — varchar(40) — NOT NULL
- user_id — varchar(40)
- event_id — varchar(40)
- title — varchar(128) — NOT NULL
- content — mediumtext — NOT NULL
- created_at — datetime — NOT NULL
- password — varchar(127)
- is_secret — tinyint(1) — NOT NULL
- is_answered — tinyint(1) — NOT NULL
- author_name — varchar(20)
registration
- id — varchar(40) — NOT NULL
- user_id — varchar(40)
- event_id — varchar(40) — NOT NULL
- event_category_id — varchar(40) — NOT NULL
- organization_id — varchar(40)
- deposit_flag — tinyint(1) — NOT NULL
- shuttle_flag — tinyint(1) — NOT NULL
- email — varchar(320) — NOT NULL
- password — varchar(127) — NOT NULL
- address — varchar(300)
- address_detail — varchar(255)
- registration_date — datetime — NOT NULL
- modified_at — datetime
- name — varchar(50) — NOT NULL
- ph_num — varchar(14) — NOT NULL
- birth — varchar(10) — NOT NULL
- gender — varchar(2) — NOT NULL
- is_del — tinyint(1) — NOT NULL
- souvenir_json — json
- note — text
- memo — text
- matching_log — text — 매칭 로그
- detail_memo — text — 디테일 메모
- paymenter_bank — varchar(50)
- account_number — varchar(255)
reserve_fund
- id — varchar(40) — NOT NULL
- user_id — varchar(40) — NOT NULL
- fund — int — NOT NULL
- limit_date — timestamp
result
- id — varchar(40) — NOT NULL
- reg_id — varchar(40) — NOT NULL
- record — time
- ranking — smallint
- url — varchar(255)
- number — smallint — NOT NULL
- title_image_url — text
role
- id — varchar(40) — NOT NULL
- name — varchar(30) — NOT NULL
shuttle
- id — varchar(40) — NOT NULL
- event_id — varchar(40) — NOT NULL
- seats — int — NOT NULL
- amount — decimal(12, 2) — NOT NULL
shuttle_reservation
- id — varchar(40) — NOT NULL
- shuttle_id — varchar(40) — NOT NULL
- place_id — varchar(40) — NOT NULL
- name — varchar(50) — NOT NULL
- birth — varchar(10) — NOT NULL
- password — varchar(127) — NOT NULL
- status — varchar(10) — NOT NULL
souvenir
- id — varchar(40) — NOT NULL
- event_id — varchar(40)
- name — varchar(30) — NOT NULL
- sizes — varchar(100)
- event_category_id — varchar(40)
sponsor
- id — varchar(40) — NOT NULL
- order_no — int — NOT NULL
- url — varchar(255) — NOT NULL
- image_url — text — NOT NULL
- visible — tinyint(1) — NOT NULL
user
- id — varchar(40) — NOT NULL
- name — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- ph_num — varchar(14) — NOT NULL
- birth — varchar(10) — NOT NULL
- account — varchar(30) — NOT NULL
- account_password — varchar(127) — NOT NULL
- address — varchar(255) — NOT NULL
- address_detail — varchar(255) — NOT NULL
- auth — varchar(10) — NOT NULL
- email — varchar(40) — NOT NULL
- gender — varchar(2) — NOT NULL
user_consent
- id — varchar(40) — NOT NULL
- consent_to_terms_of_service — tinyint(1) — NOT NULL
- consent_to_privacy_policy — tinyint(1) — NOT NULL
- consent_to_personal_info_collection_and_use — tinyint(1) — NOT NULL
- consent_to_marketing_and_advertising_SMS — tinyint(1) — NOT NULL
- consent_to_marketing_and_advertising_email — tinyint(1) — NOT NULL
user_setting
- id — varchar(40) — NOT NULL
- push_alarm_toggle — tinyint(1) — NOT NULL