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