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