Bigwalk
Tables (82)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_INSTANCE_ID — bigint — Foreign key — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
- JOB_CONFIGURATION_LOCATION — varchar(2500)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- TYPE_CD — varchar(6) — NOT NULL
- KEY_NAME — varchar(100) — NOT NULL
- STRING_VAL — varchar(250)
- DATE_VAL — datetime(6)
- LONG_VAL — bigint
- DOUBLE_VAL — double
- IDENTIFYING — char(1) — NOT NULL
BATCH_JOB_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
- VERSION — bigint
- JOB_NAME — varchar(100) — NOT NULL
- JOB_KEY — varchar(32) — NOT NULL
BATCH_JOB_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
- VERSION — bigint — NOT NULL
- STEP_NAME — varchar(100) — NOT NULL
- JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
- START_TIME — datetime(6) — NOT NULL
- END_TIME — datetime(6)
- STATUS — varchar(10)
- COMMIT_COUNT — bigint
- READ_COUNT — bigint
- FILTER_COUNT — bigint
- WRITE_COUNT — bigint
- READ_SKIP_COUNT — bigint
- WRITE_SKIP_COUNT — bigint
- PROCESS_SKIP_COUNT — bigint
- ROLLBACK_COUNT — bigint
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — bigint — Foreign key → BATCH_STEP_EXECUTION.STEP_EXECUTION_ID — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_STEP_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char(1) — NOT NULL
action_donation_history
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- campaign_id — bigint — NOT NULL
- action_id — bigint — NOT NULL
- point — int — NOT NULL
- image_path — varchar(255) — NOT NULL
- image_path2 — varchar(255)
- image_path3 — varchar(255)
- comment — varchar(1000)
- created_time — datetime — NOT NULL
- modified_time — datetime
- deleted_time — datetime
action_mission
- id — bigint — Primary key — NOT NULL
- service_link_id — bigint — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- title — varchar(50) — NOT NULL
- content — varchar(1000) — NOT NULL
- main_image_path — varchar(255)
- point — int — NOT NULL
- first_how_to_image_path — varchar(255) — NOT NULL
- second_how_to_image_path — varchar(255) — NOT NULL
- first_invalid_image_path — varchar(255) — NOT NULL
- second_invalid_image_path — varchar(255) — NOT NULL
- first_how_to_description — varchar(255) — NOT NULL
- second_how_to_description — varchar(255) — NOT NULL
- first_invalid_description — varchar(255) — NOT NULL
- second_invalid_description — varchar(255) — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime
- open — tinyint(1)
admin
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- enabled — bit(1) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — varchar(20)
- admin_info_id — bigint
- group_id — bigint
admin_info
- id — bigint — Primary key — NOT NULL
- data_extract_count — int — NOT NULL
blame
- id — bigint — Primary key — NOT NULL
- blame_id — bigint — NOT NULL
- blame_type — varchar(255)
- blame_ip — varchar(255)
- created_time — datetime
- modified_time — datetime
- blame_message — varchar(1000)
- reporter_id — bigint
- deleted_by — datetime
campaign
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- beneficiary — varchar(255)
- beneficiary_link — varchar(255)
- detail_thumbnail_image_path — varchar(255)
- donated_steps — bigint
- enabled — bit(1) — NOT NULL
- end_date — datetime(6)
- goal_point — bigint
- large_list_thumbnail_image_path — varchar(255)
- main_image_path — varchar(255)
- medium_list_thumbnail_image_path — varchar(255)
- name — varchar(255) — NOT NULL
- participant_count — bigint
- small_list_thumbnail_image_path — varchar(255)
- start_date — datetime(6)
- campaign_promoter_id — bigint — Foreign key
- category_id — int
- category_name — varchar(45)
- push_btn — varchar(255)
- beneficiary_btn — varchar(45)
- stats_btn — varchar(45)
- service_on_time — bit(1) — NOT NULL
- group — bit(1)
- sms_id — bigint — NOT NULL
- sms_title — varchar(255)
- event_id — bigint
- additional_service_id — bigint
- max_donation_per_day — bigint
- campaign_group_id — bigint
campaign_additional_service
- id — bigint — Primary key — NOT NULL
- service_id — bigint
- event_id — bigint
- sms_id — bigint
- created_time — datetime — NOT NULL
- modified_time — datetime
campaign_campaign_contents
- campaign_id — bigint — Foreign key → campaign.id — NOT NULL
- campaign_contents_id — bigint — Foreign key → campaign_content.id — NOT NULL
campaign_category
- id — int — Primary key — NOT NULL
- seq — int — NOT NULL
- name — varchar(45) — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- character_id — int
campaign_content
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- campaign_content_type — varchar(255)
- description — varchar(800)
- enabled — bit(1) — NOT NULL
- title — varchar(255)
- video_path — varchar(255)
- campaign_id — bigint — Foreign key → campaign.id
campaign_content_content_images
- campaign_content_id — bigint — Foreign key → campaign_content.id — NOT NULL
- content_images_id — bigint — Foreign key → campaign_content_image.id — NOT NULL
campaign_content_image
- id — bigint — Primary key — NOT NULL
- image_path — varchar(255)
- campaign_content_id — bigint — Foreign key → campaign_content.id
campaign_event
- id — bigint — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- description — varchar(1000)
- extra1 — varchar(1000)
- extra2 — varchar(1000)
- created_time — datetime — NOT NULL
- modified_time — datetime
campaign_group
- id — bigint — Primary key — NOT NULL
- group_id — bigint — NOT NULL
campaign_organization
- campaign_id — bigint — Foreign key → campaign.id — NOT NULL
- organization_id — bigint — Foreign key — NOT NULL
campaign_promoter
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- name — varchar(255) — NOT NULL
campaign_rank
- id — bigint — Primary key — NOT NULL
- campaign_id — bigint
- score — bigint
- user_id — bigint
campaign_recommend
- id — int — Primary key — NOT NULL
- seq — int — NOT NULL
- campaign_id — int — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- start_time — datetime
- end_time — datetime
campaign_service_link
- id — bigint — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime
campaign_sms
- id — bigint — Primary key — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime
- number — varchar(50)
- text — varchar(2000)
- title — varchar(255)
- amount — bigint
- heading — varchar(255)
- content — varchar(2000)
- privacy_policy — varchar(2000)
certification_record
- id — bigint — Primary key — NOT NULL
- phone_number — varchar(30) — NOT NULL
- created_time — datetime
- modified_time — datetime
- certification_success — tinyint(1)
competition
- id — bigint — Primary key — NOT NULL
- title — varchar(100)
- description — varchar(255)
- start_date — datetime
- end_date — datetime
- enable — tinyint(1)
- created_time — datetime
- modified_time — datetime
- recruitment_start_time — datetime
- recruitment_end_time — datetime
- reward_end_date — datetime
- promoter_id — bigint
competition_detail
- id — bigint — Primary key — NOT NULL
- detail_logo_image_path — varchar(255)
- logo_image_path — varchar(255)
- main_image_path — varchar(255)
- main_color — varchar(255)
- font_color — varchar(255)
- campaign_start_date — datetime
- campaign_end_date — datetime
- competition_id — bigint — Foreign key
- poster_image — varchar(255)
- detail_image — varchar(255)
crew_campaign
- id — bigint — Primary key — NOT NULL
- title — varchar(20) — NOT NULL
- category_id — int — NOT NULL
- small_list_thumbnail_image_path — varchar(255)
- detail_thumbnail_image_path — varchar(255)
- register_status — varchar(40) — NOT NULL
- additional_service_id — bigint — Foreign key
- created_time — datetime
- modified_time — datetime
- deleted_by — datetime
- question — varchar(255)
- crew_campaign_sign_up_method — varchar(100)
- competition_id — bigint
- group_crew_campaign_id — bigint — Foreign key
- last_modified_by — varchar(100)
- preview_id — bigint
- campaign_id — bigint
crew_campaign_comment
- id — bigint — Primary key — NOT NULL
- crew_campaign_id — bigint — Foreign key → crew_campaign.id
- user_id — bigint
- comment — varchar(255)
- parent_id — bigint
- created_time — datetime
- modified_time — datetime
- deleted_time — datetime
crew_campaign_content
- id — bigint — Primary key — NOT NULL
- crew_campaign_id — bigint — Foreign key → crew_campaign.id
- title — varchar(100)
- description — varchar(800)
- video_path — varchar(255)
- campaign_content_image — varchar(255)
- campaign_content_type — varchar(400)
- created_time — datetime — NOT NULL
- modified_time — datetime
- sequence — int
crew_funding_info
- id — bigint — Primary key — NOT NULL
- target_funding_steps — bigint
- max_funding_steps — bigint
- early_bird_count — bigint
- reward — bigint
- member_benefit — int
- early_accessor_reward — bigint
- competition_id — bigint
- funding_info_image_path — varchar(255)
- early_funding_info_image_path — varchar(255)
- achieved_info_image_path — varchar(255)
data_statistics
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- measurement_date — date
- total_donated_count — bigint
- total_donated_steps — bigint
- total_user_apple_count — bigint
- total_user_count — bigint
- total_user_facebook_count — bigint
- total_user_kakao_count — bigint
- total_user_naver_count — bigint
department
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- enabled — bit(1) — NOT NULL
- name — varchar(255) — NOT NULL
- organization_id — bigint — Foreign key
donation_history
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- steps — int
- campaign_id — bigint — Foreign key → campaign.id
- user_id — bigint — Foreign key → user.id
- deleted_time — datetime(6)
- category_id — int — 캠페인 카테고리 아이디 추가(비정규화)
donation_report_by_category
- id — bigint — Primary key — NOT NULL — Primary Key
- user_id — bigint — NOT NULL — 유저 ID
- environment_donation_steps — int — 환경 기부 걸음 수
- animal_donation_steps — int — 동물 기부 걸음 수
- child_donation_steps — int — 아동 기부 걸음 수
- disabled_donation_steps — int — 장애인 기부 걸음 수
- senile_donation_steps — int — 노인 기부 걸음 수
- global_donation_steps — int — 글로벌 기부 걸음 수
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
feed_comment
- id — bigint — Primary key — NOT NULL
- action_donation_history_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- comment — varchar(255) — NOT NULL
- connected_feed_id — bigint
- created_time — datetime — NOT NULL
- modified_time — datetime
- deleted_time — datetime
feed_notification
- id — bigint — Primary key — NOT NULL
- campaign_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- action_donation_history_id — bigint — NOT NULL
- noti_type — int — NOT NULL
- created_by — varchar(10) — NOT NULL
- value — varchar(255)
- image_path — varchar(255) — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
group_category
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
group_concern
- id — bigint — Primary key — NOT NULL
- group_id — bigint — NOT NULL
- tag_id — bigint — NOT NULL
group_crew_campaign
- id — bigint — Primary key — NOT NULL
- group_id — bigint
- sequence — int
group_detail
- id — bigint — Primary key — NOT NULL
- group_id — bigint — NOT NULL
- description — varchar(100) — NOT NULL
- main_image_path — varchar(255)
- propensity — varchar(50) — NOT NULL
- max_member_count — bigint — NOT NULL
- max_goal_point — bigint — NOT NULL
- goal_type — varchar(50) — NOT NULL
- goal_point — bigint — NOT NULL
- donated_step — bigint — NOT NULL
- end_date — datetime — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime(6)
- first_depth_region — varchar(100)
- second_depth_region — varchar(100)
group_detail_legacy
- id — bigint — Primary key — NOT NULL
- organization_id — bigint — LEGACY
- department_id — bigint — LEGACY
- value1 — varchar(100) — LEGACY
- value2 — varchar(100) — LEGACY
- value3 — varchar(100) — LEGACY
- value4 — varchar(100) — LEGACY
- value5 — varchar(100) — LEGACY
- group_id — bigint — NOT NULL
- description — varchar(100) — NOT NULL
- main_image_path — varchar(255) — NOT NULL
- propensity — varchar(50) — NOT NULL
- max_member_count — bigint — NOT NULL
- max_goal_point — bigint — NOT NULL
- goal_type — varchar(50) — NOT NULL
- goal_point — bigint — NOT NULL
- donated_step — bigint — NOT NULL
- end_date — datetime
- created_time — datetime
- modified_time — datetime(6)
group_join_requests
- id — bigint — Primary key — NOT NULL
- created_time — datetime
- crew_campaign_id — bigint
- group_id — bigint
- group_role — varchar(100)
- is_approved — tinyint(1)
- is_rejected — tinyint(1)
- modified_time — datetime
- answer — varchar(255)
- user_id — bigint
group_option
- id — bigint — Primary key — NOT NULL
- content1 — varchar(100)
- content2 — varchar(100)
- content3 — varchar(100)
- content4 — varchar(100)
- content5 — varchar(100)
- placeholder1 — varchar(100)
- placeholder2 — varchar(100)
- placeholder3 — varchar(100)
- placeholder4 — varchar(100)
- placeholder5 — varchar(100)
- created_time — datetime — NOT NULL
- modified_time — datetime
group_sticker
- id — bigint — Primary key — NOT NULL
- group_id — bigint — Foreign key
- sticker_id — bigint — Foreign key
- created_time — datetime — NOT NULL
- modified_time — datetime(6)
group_tag
- id — bigint — Primary key — NOT NULL
- name — varchar(100)
- group_tag_characteristic — varchar(100) — NOT NULL
mission
- id — bigint — Primary key — NOT NULL
- type — varchar(100) — NOT NULL
- duration_day — int — NOT NULL
- reward — varchar(100) — NOT NULL
- description — varchar(255) — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime(6)
mission_detail
- id — bigint — Primary key — NOT NULL
- mission_id — bigint — NOT NULL
- sequence — int — NOT NULL
- mission — varchar(100) — NOT NULL
- created_time — datetime
notice
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(1000) — NOT NULL
- target — varchar(50) — NOT NULL
- target_id — bigint — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime(6)
notification_history
- id — int — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- campaign_id — bigint
- type — varchar(40) — NOT NULL
notification_schedule
- id — int — Primary key — NOT NULL
- target — varchar(255) — NOT NULL
- service_id — int — NOT NULL
- noti_type — int — NOT NULL
- reservation_time — datetime(6)
- status — int — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(1000) — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime
organization
- id — bigint — Primary key — NOT NULL
- enabled — bit(1)
- name — varchar(255) — NOT NULL
- type — varchar(20) — NOT NULL — MEGA, MEDIUM, SMALL
- organization_id_type — varchar(255)
- person_in_charge_name — varchar(255)
- person_in_charge_phone_number — varchar(255)
- organization_etc_text — varchar(255)
- expired_date — datetime
- group_option_id — bigint
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
- group_category_id — bigint
phrase
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- summary_content — varchar(255) — NOT NULL
- summary_title — varchar(255) — NOT NULL
- time — int — NOT NULL
rank_system
- id — bigint — Primary key — NOT NULL
- type_id — int — NOT NULL
- level — int — NOT NULL
- start_point — bigint — NOT NULL
- end_point — bigint — NOT NULL
- rank — varchar(100) — NOT NULL
- reward — bigint
- description — varchar(100)
- created_time — datetime — NOT NULL
rank_type
- id — bigint — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- key — varchar(100) — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime
- report_end_date — datetime
- created_time — datetime
report_effect
- id — bigint — Primary key — NOT NULL
- description — varchar(500)
- image_path — varchar(255)
- type — varchar(100)
- start_point — bigint
- end_point — bigint
statistics
- regdate — varchar(10) — Primary key — NOT NULL
- campaign_id — int — Primary key — NOT NULL
- type — varchar(20) — Primary key — NOT NULL
- post_id — int — NOT NULL
- count — int
sticker
- id — bigint — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- image_path — varchar(255) — NOT NULL
- expired_date — datetime
- created_time — datetime
- modified_time — datetime(6)
story
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- description — varchar(255) — NOT NULL
- enabled — bit(1) — NOT NULL
- story_content_type — varchar(255)
- title — varchar(255) — NOT NULL
- video_path — varchar(255)
- campaign_id — bigint — Foreign key → campaign.id
- reservation_enabled — bit(1)
- thumbnail_image_path — varchar(255)
- push_btn — varchar(255)
story_content_image
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- enabled — bit(1) — NOT NULL
- url — varchar(255) — NOT NULL
- story_id — bigint — Foreign key → story.id
user
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- age_range — int
- birthday — varchar(255)
- donable_steps — int
- email — varchar(255)
- fcm_token — varchar(255)
- gender — varchar(255)
- marketing_agreement — bit(1)
- name — varchar(10) — NOT NULL
- notification_agreement — bit(1) — NOT NULL
- organization_email — varchar(255)
- organization_employee_number — varchar(255)
- password — varchar(255)
- profile_path — varchar(255)
- withdraw — bit(1) — NOT NULL
- department_id — bigint — Foreign key → department.id
- organization_id — bigint — Foreign key
- campaign_noti_agreement — bit(1)
- ranking_noti_agreement — bit(1)
- story_noti_agreement — bit(1)
- walk_noti_agreement — bit(1) — NOT NULL
- character_id — int
- withdraw_time — datetime
- organization_etc — varchar(255)
- blocked — bit(1)
- group_id — bigint — organization v2
- phone_number — varchar(30)
- first_depth_region — varchar(255)
- second_depth_region — varchar(255)
user_block
- id — bigint — Primary key — NOT NULL
- blocker_id — bigint — NOT NULL
- blocked_id — bigint — NOT NULL
user_campaign_history
- id — int — Primary key — NOT NULL
- campaign_id — int — NOT NULL
- story_id — int — NOT NULL
- type — int — NOT NULL
- user_id — int — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime
user_concern
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- tag_id — bigint — NOT NULL
user_funding_record
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- crew_campaign_id — bigint — Foreign key → crew_campaign.id
- funded_steps — bigint
- used_steps — bigint
- achieved_date — datetime
- is_early_accessor — tinyint(1)
- is_member_benefit — tinyint(1)
user_group
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- group_id — bigint — Foreign key — NOT NULL
- detail_id — bigint — Foreign key → user_group_detail.id — NOT NULL
- created_time — datetime — NOT NULL
user_group_detail
- id — bigint — Primary key — NOT NULL
- organization_id — bigint — Foreign key — NOT NULL
- department_id — bigint — Foreign key → department.id
- value1 — varchar(100)
- value2 — varchar(100)
- value3 — varchar(100)
- value4 — varchar(100)
- value5 — varchar(100)
- role — varchar(20) — NOT NULL
- created_time — datetime
- modified_time — datetime(6)
user_mission
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- mission_id — bigint — NOT NULL
- expired_date — datetime — NOT NULL
- rewarded — tinyint(1) — NOT NULL
- created_time — datetime
- modified_time — datetime
user_mission_detail
- id — bigint — Primary key — NOT NULL
- user_mission_id — bigint — NOT NULL
- mission_detail_id — bigint — NOT NULL
- completed — bigint — NOT NULL
- created_time — datetime
- modified_time — datetime
user_notification
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- noti_type — int — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(1000) — NOT NULL
- noti_type_name — varchar(45)
- data — varchar(255)
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
user_provider
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6) — NOT NULL
- modified_time — datetime(6)
- service_provider — varchar(255) — NOT NULL
- unique_id — varchar(255) — NOT NULL
- user_id — bigint — Foreign key → user.id
user_rank
- user_id — int — Primary key — NOT NULL
- last_rank — int
- today_rank — int
- created_time — datetime
- modified_time — datetime
- send_date — varchar(20)
user_sticker
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- sticker_id — bigint — Foreign key — NOT NULL
- created_time — datetime
- modified_time — datetime(6)
user_tag
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- user_tag_characteristic — varchar(100) — NOT NULL
value_consumption_commerce
- id — bigint — Primary key — NOT NULL
- service_link_id — bigint — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(1000) — NOT NULL
- important_content — varchar(1000)
- point — int — NOT NULL
- reward — varchar(100)
- purchase_url — varchar(1000)
- image_path — varchar(255) — NOT NULL
- extra1 — varchar(100)
- extra2 — varchar(100)
- extra3 — varchar(100)
- created_time — datetime — NOT NULL
- modified_time — datetime
- deleted_time — datetime
and 2 more tables