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)