ss

Tables (38)

BATCH_JOB_EXECUTION

  • JOB_EXECUTION_ID — BIGINT — NOT NULL
  • VERSION — BIGINT
  • JOB_INSTANCE_ID — BIGINT — Foreign key → BATCH_JOB_INSTANCE.JOB_INSTANCE_ID — 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)

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
  • PARAMETER_NAME — VARCHAR(100) — NOT NULL
  • PARAMETER_TYPE — VARCHAR(100) — NOT NULL
  • PARAMETER_VALUE — VARCHAR(2500)
  • IDENTIFYING — CHAR — NOT NULL

BATCH_JOB_EXECUTION_SEQ

  • ID — BIGINT — NOT NULL
  • UNIQUE_KEY — CHAR — NOT NULL

BATCH_JOB_INSTANCE

  • JOB_INSTANCE_ID — BIGINT — 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 — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — BIGINT — 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
  • CREATE_TIME — DATETIME(6) — NOT NULL
  • START_TIME — DATETIME(6)
  • 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 — NOT NULL

admin

  • id — BIGINT
  • puid — BINARY(16)
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • encode_password — VARCHAR(128) — NOT NULL
  • phone_number — VARCHAR(15)
  • status — VARCHAR(15) — NOT NULL
  • registered_at — DATETIME(6) — 가입일시
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(50)
  • last_modified_by — VARCHAR(50)
  • role_id — BIGINT

admin_company

  • id — BIGINT — 고유 식별자' PRIMARY KE
  • admin_id — BIGINT — Foreign key → admin.id — NOT NULL — 관리자 ID
  • company_id — BIGINT — NOT NULL — 회사 ID
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 수정일시
  • name — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(255)
  • description — JSON
  • company_id — BIGINT
  • condition_todo_group_key — VARCHAR(50)
  • shared_goal — BIGINT

admin_permission

  • id — BIGINT
  • code — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL

admin_role

  • id — BIGINT
  • code — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(50)
  • last_modified_by — VARCHAR(50)
  • role_version — BIGINT — NOT NULL — 버전 (로컬 캐시 용도)

admin_role_permission_mapping

  • id — BIGINT
  • role_id — BIGINT — NOT NULL
  • permission_id — BIGINT — NOT NULL

admin_terms

  • id — BIGINT — 관리자 약관 id' PRIMARY KE
  • effective_date — DATE — NOT NULL — 시행일
  • required — BIT — NOT NULL — 필수 동의 여부
  • active — BIT — NOT NULL — 활성화 여부
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • version — VARCHAR(50) — NOT NULL — 약관 버전
  • title — VARCHAR(255) — NOT NULL — 약관 제목
  • terms_group — VARCHAR(255) — NOT NULL — 약관 그룹
  • created_by — VARCHAR(255)
  • last_modified_by — VARCHAR(255)
  • url — VARCHAR(500) — NOT NULL — 약관 URL

admin_terms_agreement_history

  • id — BIGINT — 관리자 약관 동의 이력 id' PRIMARY KE
  • admin_id — BIGINT — Foreign key → admin.id — NOT NULL — 관리자
  • terms_id — BIGINT — Foreign key → admin_terms.id — NOT NULL — 약관
  • agreed — BIT — NOT NULL — 동의 여부
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(255)
  • last_modified_by — VARCHAR(255)

android_step_logs

  • id — BIGINT
  • puid — BINARY(16)
  • accumulated_step_count — BIGINT — 누적 걸음수
  • standard_time — DATETIME(6) — 기준 시각
  • created_at — DATETIME(6) — 생성일시

banners

  • id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • description — VARCHAR(255)
  • image_name — VARCHAR(255)
  • link_url — VARCHAR(255)
  • type — ENUM
  • action_image_url — VARCHAR(255)
  • closeable — BIT — NOT NULL
  • color — ENUM
  • exposure_day — INT
  • location — ENUM
  • banner_character — ENUM
  • screen_id — BIGINT
  • exposure_end_date — DATE

batch_error_log

  • id — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • error_type — VARCHAR(20) — NOT NULL
  • job_name — VARCHAR(100)
  • step_name — VARCHAR(100)
  • class_name — VARCHAR(255) — NOT NULL
  • row_id — VARCHAR(128)
  • profile — VARCHAR(32)
  • message — TEXT — NOT NULL
  • payload — TEXT

care_admin_memo

  • id — BIGINT — 메모 ID' PRIMARY KE
  • uid — BINARY(16) — NOT NULL — 환자 고유 식별자 (UUID)
  • content — VARCHAR(1000) — NOT NULL — 메모 내용
  • created_at — DATETIME — NOT NULL — 생성일
  • updated_at — DATETIME — NOT NULL — 수정일' ) COMMENT '환자 메모 정보' COLLATE = utf8mb4_unicode_ci; CREATE TABLE company ( id BIGINT AUTO_INCREMENT PRIMARY KE
  • name — VARCHAR(255) — NOT NULL
  • check_company_id — BIGINT
  • created_at — DATETIME(6) — NOT NULL — 생성 일시
  • updated_at — DATETIME(6) — NOT NULL — 수정 일시
  • membership_id — BIGINT — 맴버십 id
  • created_by — VARCHAR(50)
  • last_modified_by — VARCHAR(50)

conditional_todo_group

  • id — BIGINT
  • lifelog_type — VARCHAR(50)
  • lifelog_sub_type — VARCHAR(50)
  • triggered_todo_id — BIGINT — Foreign key
  • after_time_type — VARCHAR(50) — NOT NULL
  • trigger_type — VARCHAR(50)
  • cool_time_minute — INT
  • condition_todo_group_key — VARCHAR(50)
  • apply_type — VARCHAR(50) — NOT NULL
  • condition_lifelog_type — VARCHAR(100)
  • description — VARCHAR(1000)

config_todo_extra

  • property — VARCHAR(255) — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • description — VARCHAR(1024) — NOT NULL
  • required — BIT — NOT NULL

config_todo_extra_code

  • id — BIGINT
  • code — VARCHAR(255) — NOT NULL
  • text — VARCHAR(255) — NOT NULL
  • config_todo_extra_property — VARCHAR(255) — Foreign key → config_todo_extra.property — NOT NULL

config_todo_extra_default

  • id — BIGINT — NOT NULL
  • todo_type — VARCHAR(255)
  • default_value — VARCHAR(255) — NOT NULL
  • config_todo_extra_property — VARCHAR(255) — Foreign key → config_todo_extra.property

daily_reports

  • id — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • perform_count — INT — NOT NULL
  • not_performed_count — INT — NOT NULL
  • puid — BINARY(16) — NOT NULL
  • date — DATE — NOT NULL
  • is_read — BIT — NOT NULL

department

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL — 부서명
  • company_id — BIGINT — NOT NULL — 회사 id
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시
  • image_name — VARCHAR(255)
  • title — VARCHAR(255)
  • link_url — VARCHAR(255)

feed

  • id — BIGINT
  • type — VARCHAR(255)
  • puid — BINARY(16) — NOT NULL
  • content — JSON
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • lifelog_id — BIGINT
  • perform_status — VARCHAR(50)
  • perform_at — DATETIME
  • selected_answer_idx — INT
  • perform_lifelog_id — BIGINT
  • task_type — VARCHAR(255)
  • completion_status — VARCHAR(50)
  • energy — INT
  • energy_received — TINYINT(1)
  • feedback — TINYINT(1)
  • performed_count — BIGINT
  • goal_count — BIGINT
  • published_todo_id — BIGINT — 발행된 Todo ID
  • article_id — VARCHAR(255)
  • hpc_no — BIGINT

fixed_todo_set

  • id — BIGINT
  • todo_set_id — BIGINT

flyway_schema_history

  • installed_rank — INT — NOT NULL
  • version — VARCHAR(50)
  • description — VARCHAR(200) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • script — VARCHAR(1000) — NOT NULL
  • checksum — INT
  • installed_by — VARCHAR(100) — NOT NULL
  • installed_on — TIMESTAMP — NOT NULL
  • execution_time — INT — NOT NULL
  • success — TINYINT(1) — NOT NULL

food_factors

  • category_id — BIGINT — NOT NULL
  • major_category — ENUM — NOT NULL
  • score — BIGINT

health_kit_sleep_log_groups

  • id — BIGINT
  • group_id — VARCHAR(255)
  • start_at — DATETIME(6)
  • end_at — DATETIME(6)

health_promotion_content

  • id — BIGINT — NOT NULL
  • fields — JSON — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • task — JSON — NOT NULL

health_record_card_feedback

  • id — BIGINT
  • feedback_message — VARCHAR(255)
  • max — INT
  • min — INT
  • type — ENUM
  • extra — VARCHAR(255)
  • image_url — VARCHAR(255)

health_record_list_image

  • id — BIGINT
  • image_url — VARCHAR(255)
  • name — VARCHAR(255)

health_report_feedbacks

  • id — BIGINT
  • content — VARCHAR(255)
  • report_feedback_type — ENUM
  • tip — VARCHAR(255)
  • title — VARCHAR(255)
  • health_report_id — BIGINT — Foreign key → health_reports.health_report_id
  • is_read — BIT

health_reports

  • health_report_id — BIGINT
  • date — DATE
  • puid — BINARY(16)
  • score — INT

health_tip

  • id — BIGINT
  • contents — VARCHAR(255)
  • title — VARCHAR(255)
  • type — ENUM

images

  • image_id — BIGINT
  • image_name — VARCHAR(255)
  • image_url — VARCHAR(255)