AA

Tables (50)

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_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_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_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_event

  • id — bigint — Primary key — NOT NULL
  • type — varchar(20) — NOT NULL
  • description — varchar(1000)
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • 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_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
  • recruitment_start_time — datetime
  • recruitment_end_time — datetime
  • enable — tinyint(1)
  • created_time — datetime
  • modified_time — datetime
  • reward_end_date — datetime
  • promoter_id — bigint

crew_funding_info

  • id — bigint — Primary key — NOT NULL
  • target_funding_steps — bigint
  • max_funding_steps — bigint — NOT NULL
  • 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

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_crew_campaign

  • id — bigint — Primary key — NOT NULL
  • group_id — bigint
  • sequence — int

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(6)

group_tag

  • id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • group_tag_characteristic — varchar(100) — NOT NULL

hibernate_sequence

  • next_val — bigint

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_clear_history

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • mission_id — bigint — NOT NULL
  • sequence — int — NOT NULL
  • value — varchar(100) — NOT NULL
  • created_time — datetime

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(6) — 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

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
  • created_time — datetime
  • report_end_date — 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) — NOT NULL
  • campaign_id — int — NOT NULL
  • post_id — int — NOT NULL
  • type — varchar(20) — 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)

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_daily_statistics

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • reg_date — datetime — NOT NULL
  • ranking — int — NOT NULL
  • donated_step — int — NOT NULL
  • walk_step — int — NOT NULL
  • created_time — datetime — NOT NULL
  • modified_time — datetime

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
  • created_time — datetime(6) — NOT NULL
  • modified_time — datetime(6)
  • noti_type_name — varchar(255)
  • data — varchar(255)

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_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)
  • extra2 — varchar(100)
  • extra1 — varchar(100)
  • created_time — datetime — NOT NULL
  • modified_time — datetime
  • deleted_time — datetime
  • extra3 — varchar(100)
  • purchase_url — varchar(100)
  • image_path — varchar(255) — NOT NULL