ㄷㄷㄷ

Tables (32)

account

  • account_id — BIGINT — Primary key — NOT NULL — 계좌ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • account_number — VARCHAR(30) — NOT NULL — 계좌번호(가상)
  • account_type — VARCHAR(20) — NOT NULL — 계좌유형(CHECKING:입출금/SAVINGS:예적금/INVESTMENT:투자/LOAN:대출·부채)
  • balance — DECIMAL(15, 2) — NOT NULL — 잔액(LOAN은 대출잔액)
  • institution_name — VARCHAR(50) — 기관명
  • sync_status — VARCHAR(20) — NOT NULL — 동기화상태(WAIT/PROCESSING/SUCCESS/FAIL)
  • linked_at — DATETIME — 연동일시
  • last_synced_at — DATETIME — 마지막 동기화 시각

auth_log

  • log_id — BIGINT — Primary key — NOT NULL — 인증이력ID
  • member_id — BIGINT — Foreign key → member.member_id — 회원ID
  • event_type — VARCHAR(30) — NOT NULL — 이벤트유형(LOGIN_SUCCESS/LOGIN_FAIL/LOGOUT/TOKEN_REFRESH_FAIL/INVALID_TOKEN)
  • success_yn — TINYINT(1) — NOT NULL — 성공여부
  • fail_code — VARCHAR(30) — 실패코드
  • ip_address — VARCHAR(45) — 요청 IP
  • user_agent — VARCHAR(255) — 유저에이전트
  • occurred_at — DATETIME — NOT NULL — 발생시각

consumption_summary

  • summary_id — BIGINT — Primary key — NOT NULL — 소비집계ID
  • diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
  • category_code — VARCHAR(20) — NOT NULL — 소비카테고리
  • amount — DECIMAL(15, 2) — NOT NULL — 카테고리별 지출금액
  • ratio — DECIMAL(5, 2) — NOT NULL — 전체소비 대비 비중(%)

defense_checklist_master

  • checklist_master_id — BIGINT — Primary key — NOT NULL — 체크리스트마스터ID
  • cause_code — VARCHAR(20) — NOT NULL — 원인코드(ACCIDENT/ILLNESS/ACCOUNT_SUSPENDED/OTHER)
  • job_category — VARCHAR(30) — 직종군(사고 원인만 구분)
  • item_name — VARCHAR(100) — NOT NULL — 체크리스트 항목명
  • sort_order — TINYINT — NOT NULL — 정렬순서

defense_fixed_expense_check

  • id — BIGINT — Primary key — NOT NULL — 고정지출점검ID
  • defense_id — BIGINT — Foreign key → defense_mode.defense_id — NOT NULL — 방어모드ID
  • expense_name — VARCHAR(50) — NOT NULL — 지출항목명
  • amount — DECIMAL(15, 2) — NOT NULL — 금액
  • cycle — VARCHAR(20) — 납입주기
  • next_payment_date — DATE — 다음 이체일
  • maintain_status — VARCHAR(20) — NOT NULL — 유지가능상태(NORMAL/DIFFICULT_THIS_MONTH/REVIEW_NEEDED)

defense_mode

  • defense_id — BIGINT — Primary key — NOT NULL — 방어모드ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 대상 잡ID
  • cause_code — VARCHAR(20) — NOT NULL — 원인코드(ACCIDENT/ILLNESS/ACCOUNT_SUSPENDED/OTHER)
  • job_category_snapshot — VARCHAR(30) — 진입시점 직종군 스냅샷
  • start_date — DATE — NOT NULL — 근무불가 시작일
  • expected_return_date — DATE — NOT NULL — 예상 복귀일
  • actual_return_date — DATE — 실제 복귀일
  • status — VARCHAR(20) — NOT NULL — 상태(ACTIVE/RESOLVED)
  • available_assets_snapshot — DECIMAL(15, 2) — 진입시점 가용자산 스냅샷(diagnosis_result.liquid_assets, 입출금+예적금)
  • daily_fixed_cost — DECIMAL(15, 2) — 일평균 고정지출
  • d_day — INT — 생존가능일수
  • expected_loss_income — DECIMAL(15, 2) — 이번달 예상 손실소득
  • free_memo — VARCHAR(500) — 기타 원인 자유메모
  • created_at — DATETIME — NOT NULL — 진입일시
  • resolved_at — DATETIME — 해제일시

diagnosis_result

  • diagnosis_id — BIGINT — Primary key — NOT NULL — 재무진단ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • year_month — CHAR(7) — NOT NULL — 기준연월(YYYY-MM)
  • total_income — DECIMAL(15, 2) — NOT NULL — 총소득
  • total_expense — DECIMAL(15, 2) — NOT NULL — 총소비
  • available_funds — DECIMAL(15, 2) — NOT NULL — 가용자금
  • income_regularity_score — DECIMAL(5, 2) — 소득 규칙성 지표
  • income_volatility — DECIMAL(5, 2) — 소득 변동성 지표
  • income_change_rate — DECIMAL(5, 2) — 전월대비 소득 증감률(%)
  • income_change_amount — DECIMAL(15, 2) — 전월대비 소득 증감액
  • primary_income_job_id — BIGINT — Foreign key → job.job_id — 주 소득원 잡ID
  • fixed_cost_ratio — DECIMAL(5, 2) — 고정비 부담률(%)
  • liquid_assets — DECIMAL(15, 2) — 가용자산 = account의 CHECKING+SAVINGS 잔액 합계(투자자산 제외)
  • total_financial_assets — DECIMAL(15, 2) — 총 금융자산 = CHECKING+SAVINGS+INVESTMENT 전체 합계
  • ai_summary_content — TEXT — AI 총평
  • created_at — DATETIME — NOT NULL — 진단 실행일시

fatigue_log

  • fatigue_log_id — BIGINT — Primary key — NOT NULL — 피로도기록ID
  • work_log_id — BIGINT — Foreign key → work_log.work_log_id — NOT NULL — 근무일지ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • fatigue_date — DATE — NOT NULL — 피로도 기준일
  • fatigue_value — TINYINT — NOT NULL — 피로도 값(1~5)
  • is_default_value_yn — TINYINT(1) — NOT NULL — 미입력 기본값 적용여부
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

fatigue_summary

  • summary_id — BIGINT — Primary key — NOT NULL — 누적피로도ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • calc_date — DATE — NOT NULL — 계산 기준일
  • cumulative_fatigue — DECIMAL(5, 2) — NOT NULL — 최근7일 가중평균 피로도
  • warning_status — VARCHAR(20) — NOT NULL — 경고상태(NORMAL/CAUTION/WARNING)
  • created_at — DATETIME — NOT NULL — 계산일시

financial_product

  • product_id — BIGINT — Primary key — NOT NULL — 금융상품ID
  • product_name — VARCHAR(100) — NOT NULL — 상품명
  • product_type — VARCHAR(30) — 상품유형(예금/적금/투자 등)
  • interest_rate — DECIMAL(5, 2) — 금리(%)
  • min_join_period — INT — 최소 가입기간(개월)
  • min_amount — DECIMAL(15, 2) — 최소 가입금액
  • join_condition — VARCHAR(255) — 가입조건
  • subscriber_only_yn — TINYINT(1) — NOT NULL — 구독자 전용 여부
  • created_at — DATETIME — NOT NULL — 등록일시

job

  • job_id — BIGINT — Primary key — NOT NULL — 잡ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • platform_id — BIGINT — Foreign key → platform.platform_id — 플랫폼ID
  • job_name — VARCHAR(50) — NOT NULL — 잡 이름
  • compensation_type — VARCHAR(10) — NOT NULL — 보상방식(HOURLY/PER_CASE)
  • wage_amount — DECIMAL(15, 2) — NOT NULL — 시급 또는 건당 금액
  • schedule_type — VARCHAR(10) — NOT NULL — 일정유형(REGULAR/IRREGULAR)
  • base_fatigue_index — TINYINT — NOT NULL — 기본 피로도(1~5)
  • job_category — VARCHAR(30) — 직종군(방어모드 체크리스트 매핑용)
  • settlement_cycle — VARCHAR(20) — 정산주기
  • settlement_day — VARCHAR(20) — 정산 기준일
  • active_yn — TINYINT(1) — NOT NULL — 활성여부
  • deactivated_at — DATETIME — 비활성화 시각
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

job_income_summary

  • summary_id — BIGINT — Primary key — NOT NULL — 잡별소득집계ID
  • diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
  • job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
  • job_income_amount — DECIMAL(15, 2) — NOT NULL — 잡별 소득금액
  • job_income_ratio — DECIMAL(5, 2) — NOT NULL — 전체소득 대비 비중(%)

job_recurring_rule

  • rule_id — BIGINT — Primary key — NOT NULL — 반복규칙ID
  • job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
  • day_of_week — TINYINT — NOT NULL — 요일(0=일~6=토)
  • start_time — TIME — NOT NULL — 시작시간
  • end_time — TIME — NOT NULL — 종료시간
  • apply_start_date — DATE — NOT NULL — 적용 시작일
  • apply_end_date — DATE — 적용 종료일

member

  • member_id — BIGINT — Primary key — NOT NULL — 회원ID
  • email — VARCHAR(255) — 이메일
  • nickname — VARCHAR(50) — 닉네임
  • name — VARCHAR(50) — 이름
  • role — VARCHAR(20) — NOT NULL — 시스템 접근권한(ROLE_USER/ROLE_ADMIN)
  • status — VARCHAR(20) — NOT NULL — 회원상태(PENDING/ACTIVE/SUSPENDED/WITHDRAWN)
  • notification_agree_yn — TINYINT(1) — NOT NULL — 알림수신 동의여부
  • location_agree_yn — TINYINT(1) — NOT NULL — 위치정보 수집 동의여부
  • marketing_agree_yn — TINYINT(1) — NOT NULL — 마케팅 수신 동의여부
  • onboarding_completed_yn — TINYINT(1) — NOT NULL — 온보딩 완료여부
  • last_login_at — DATETIME — 최근 로그인 시각
  • withdrawal_reason — VARCHAR(255) — 탈퇴 사유
  • withdrawn_at — DATETIME — 탈퇴 시각
  • created_at — DATETIME — NOT NULL — 가입일시
  • updated_at — DATETIME — NOT NULL — 수정일시

member_oauth

  • oauth_id — BIGINT — Primary key — NOT NULL — 소셜연동ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • provider — VARCHAR(20) — NOT NULL — 제공자(KAKAO/GOOGLE/EMAIL)
  • provider_user_id — VARCHAR(255) — NOT NULL — 제공자측 사용자 식별자
  • connected_at — DATETIME — NOT NULL — 연동일시

notification

  • notification_id — BIGINT — Primary key — NOT NULL — 알림ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • source_domain — VARCHAR(30) — 트리거 발생 도메인
  • notification_type — VARCHAR(30) — NOT NULL — 알림유형(REPORT_READY/WORK_LOG_REMIND/DEFENSE_ALERT 등)
  • channel — VARCHAR(20) — NOT NULL — 발송채널(KAKAO/PUSH)
  • template_id — VARCHAR(30) — 템플릿ID
  • message_content — VARCHAR(500) — 메시지 내용
  • related_report_id — BIGINT — Foreign key → report.report_id — 관련 리포트ID
  • status — VARCHAR(20) — NOT NULL — 발송상태(PENDING/SENT/FAILED/RETRY)
  • retry_count — TINYINT — NOT NULL — 재시도 횟수
  • read_yn — TINYINT(1) — NOT NULL — 읽음 여부
  • deleted_yn — TINYINT(1) — NOT NULL — 삭제 여부
  • scheduled_at — DATETIME — 발송예정시각
  • sent_at — DATETIME — 발송완료시각
  • created_at — DATETIME — NOT NULL — 등록일시

notification_trigger

  • trigger_id — BIGINT — Primary key — NOT NULL — 알림트리거ID
  • trigger_type — VARCHAR(30) — NOT NULL — 트리거유형
  • source_domain — VARCHAR(30) — NOT NULL — 발생 도메인
  • condition_expression — VARCHAR(255) — 발생조건
  • evaluation_cycle — VARCHAR(20) — 평가주기
  • active_yn — TINYINT(1) — NOT NULL — 활성여부

payment

  • payment_id — BIGINT — Primary key — NOT NULL — 결제ID
  • subscription_id — BIGINT — Foreign key → subscription.subscription_id — NOT NULL — 구독ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • merchant_uid — VARCHAR(50) — NOT NULL — 주문번호(중복결제 방지용 UNIQUE)
  • customer_uid — VARCHAR(50) — NOT NULL — 빌링키(정기결제용)
  • imp_uid — VARCHAR(50) — 포트원 결제고유번호
  • amount — DECIMAL(10, 2) — NOT NULL — 결제금액
  • payment_method — VARCHAR(20) — 결제수단(CARD/KAKAOPAY)
  • payment_status — VARCHAR(20) — NOT NULL — 결제상태(SUCCESS/FAILED/CANCELLED/RETRY)
  • is_first_payment_yn — TINYINT(1) — NOT NULL — 최초결제 여부
  • scheduled_at — DATETIME — 재결제 예정일시
  • retry_count — TINYINT — NOT NULL — 재시도 횟수
  • fail_reason_code — VARCHAR(30) — 실패사유코드
  • created_at — DATETIME — NOT NULL — 결제일시

payment_webhook_log

  • log_id — BIGINT — Primary key — NOT NULL — 웹훅이력ID
  • payment_id — BIGINT — Foreign key → payment.payment_id — 결제ID
  • imp_uid — VARCHAR(50) — 포트원 결제고유번호
  • received_status — VARCHAR(20) — 수신된 결제상태
  • received_at — DATETIME — NOT NULL — 수신일시

platform

  • platform_id — BIGINT — Primary key — NOT NULL — 플랫폼ID
  • platform_name — VARCHAR(50) — NOT NULL — 플랫폼명
  • representative_merchant_name — VARCHAR(100) — 대표 입금처명
  • settlement_cycle — VARCHAR(20) — 정산주기(DAILY/WEEKLY/MONTHLY)
  • settlement_day — VARCHAR(20) — 정산 기준일
  • weather_sensitive_yn — TINYINT(1) — NOT NULL — 날씨 영향 여부
  • default_job_category — VARCHAR(30) — 기본 직종군(이륜차배달군/차량운행군/비이동사무형군)
  • created_at — DATETIME — NOT NULL — 등록일시

recommendation

  • recommendation_id — BIGINT — Primary key — NOT NULL — 추천ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
  • product_id — BIGINT — Foreign key → financial_product.product_id — NOT NULL — 금융상품ID
  • recommend_reason — TEXT — AI 생성 추천사유
  • proposed_saving_amount — DECIMAL(15, 2) — 제안 저축액
  • expected_return_simple — DECIMAL(15, 2) — 기대수익(단리)
  • expected_return_compound — DECIMAL(15, 2) — 기대수익(복리)
  • year_month — CHAR(7) — NOT NULL — 기준연월
  • created_at — DATETIME — NOT NULL — 생성일시

refresh_token

  • token_id — BIGINT — Primary key — NOT NULL — 토큰ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • token_hash — VARCHAR(255) — NOT NULL — 토큰 해시값
  • issued_at — DATETIME — NOT NULL — 발급시각
  • expired_at — DATETIME — NOT NULL — 만료시각
  • revoked_yn — TINYINT(1) — NOT NULL — 폐기여부

report

  • report_id — BIGINT — Primary key — NOT NULL — 리포트ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
  • year_month — CHAR(7) — NOT NULL — 기준연월
  • report_content — TEXT — 리포트 본문(JSON/HTML)
  • recommended_product_id — BIGINT — Foreign key → financial_product.product_id — 추천 금융상품ID
  • status — VARCHAR(20) — NOT NULL — 상태(GENERATED/SENT_PENDING/SENT/FAILED)
  • created_at — DATETIME — NOT NULL — 생성일시

saving_goal

  • goal_id — BIGINT — Primary key — NOT NULL — 저축목표ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • year_month — CHAR(7) — NOT NULL — 기준연월(YYYY-MM)
  • target_income — DECIMAL(15, 2) — NOT NULL — 목표 소득치
  • target_labor_intensity — VARCHAR(10) — NOT NULL — 희망 노동강도(EASY/NORMAL/TIGHT)
  • target_fatigue — TINYINT — NOT NULL — 적정 피로도
  • achieved_amount — DECIMAL(15, 2) — NOT NULL — 누적 달성 금액
  • achievement_rate — DECIMAL(5, 2) — NOT NULL — 목표 달성률(%)
  • is_default_applied_yn — TINYINT(1) — NOT NULL — 기본값 적용여부
  • growth_mode_paused_yn — TINYINT(1) — NOT NULL — 성장모드 일시정지 여부
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

subscription

  • subscription_id — BIGINT — Primary key — NOT NULL — 구독ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • plan_code — VARCHAR(20) — Foreign key → subscription_plan.plan_code — NOT NULL — 플랜코드
  • status — VARCHAR(20) — NOT NULL — 구독상태(ACTIVE/CANCEL_SCHEDULED/EXPIRED)
  • start_date — DATE — NOT NULL — 이용 시작일
  • end_date — DATE — NOT NULL — 이용 만료일
  • auto_renew_yn — TINYINT(1) — NOT NULL — 자동연장 여부
  • cancel_requested_at — DATETIME — 해지신청일시
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

subscription_plan

  • plan_code — VARCHAR(20) — Primary key — NOT NULL — 플랜코드(FREE/PREMIUM)
  • plan_name — VARCHAR(50) — NOT NULL — 플랜명
  • price — DECIMAL(10, 2) — NOT NULL — 가격
  • billing_cycle — VARCHAR(20) — NOT NULL — 결제주기

subscription_plan_feature

  • id — BIGINT — Primary key — NOT NULL — 플랜기능매핑ID
  • plan_code — VARCHAR(20) — Foreign key → subscription_plan.plan_code — NOT NULL — 플랜코드
  • feature_code — VARCHAR(30) — NOT NULL — 기능코드(AGENT_REPORT/PRODUCT_RECOMMEND/KAKAO_REPORT 등)
  • access_yn — TINYINT(1) — NOT NULL — 접근 허용여부

sync_history

  • sync_id — BIGINT — Primary key — NOT NULL — 동기화이력ID
  • account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 계좌ID
  • status — VARCHAR(20) — NOT NULL — 처리상태(WAIT/PROCESSING/SUCCESS/FAIL)
  • trigger_type — VARCHAR(20) — NOT NULL — 실행방식(MANUAL/SCHEDULED)
  • synced_count — INT — NOT NULL — 처리건수
  • started_at — DATETIME — 시작시각
  • finished_at — DATETIME — 종료시각

terms_agreement

  • agreement_id — BIGINT — Primary key — NOT NULL — 약관동의ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • terms_type — VARCHAR(30) — NOT NULL — 약관유형(SERVICE/PRIVACY/MARKETING/MYDATA)
  • terms_version — VARCHAR(20) — NOT NULL — 약관버전
  • is_required — TINYINT(1) — NOT NULL — 필수여부
  • agreed_yn — TINYINT(1) — NOT NULL — 동의여부
  • agreed_at — DATETIME — 동의시각

transaction_history

  • transaction_id — BIGINT — Primary key — NOT NULL — 거래ID
  • account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 계좌ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • transaction_type — VARCHAR(10) — NOT NULL — 거래유형(DEPOSIT/WITHDRAW)
  • amount — DECIMAL(15, 2) — NOT NULL — 거래금액
  • balance_after — DECIMAL(15, 2) — NOT NULL — 거래후 잔액
  • merchant_name — VARCHAR(100) — 거래처명/입금처명
  • transaction_detail — VARCHAR(255) — 거래내용/적요
  • transaction_date — DATETIME — NOT NULL — 거래일시
  • platform_id — BIGINT — Foreign key → platform.platform_id — 추정/확정 플랫폼ID
  • job_id — BIGINT — Foreign key → job.job_id — 연결된 잡ID
  • label_status — VARCHAR(20) — NOT NULL — 라벨상태(AUTO_ESTIMATED/APPROVED/CORRECTED/UNCLASSIFIED)
  • category_code — VARCHAR(20) — 소비카테고리(식비/교통비/정주비/쇼핑/여가/구독)
  • category_confirmed_yn — TINYINT(1) — NOT NULL — 카테고리 사용자 확정여부
  • created_at — DATETIME — NOT NULL — 적재일시

work_log

  • work_log_id — BIGINT — Primary key — NOT NULL — 근무일지ID
  • schedule_id — BIGINT — Foreign key → work_schedule.schedule_id — 근무계획ID(계획외 근무는 NULL)
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
  • work_date — DATE — NOT NULL — 근무일
  • actual_start_time — DATETIME — NOT NULL — 실제 시작시각
  • actual_end_time — DATETIME — NOT NULL — 실제 종료시각
  • actual_income — DECIMAL(15, 2) — 실제 소득(재계산 결과)
  • confirm_status — VARCHAR(20) — NOT NULL — 확정상태(CONFIRMED/MODIFIED)
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

work_schedule

  • schedule_id — BIGINT — Primary key — NOT NULL — 근무계획ID
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
  • job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
  • work_date — DATE — NOT NULL — 근무예정일
  • planned_start_time — DATETIME — NOT NULL — 계획 시작시각
  • planned_end_time — DATETIME — NOT NULL — 계획 종료시각
  • expected_income — DECIMAL(15, 2) — 예상 소득
  • expected_fatigue — DECIMAL(5, 2) — 예상 피로도
  • weather_condition — VARCHAR(20) — 날씨상태(캐시)
  • precipitation_probability — TINYINT — 강수확률(%)
  • fatigue_warning_yn — TINYINT(1) — NOT NULL — 적정피로도 초과 경고여부
  • is_ai_recommended_yn — TINYINT(1) — NOT NULL — AI추천 근무시간 여부
  • status — VARCHAR(20) — NOT NULL — 상태(PLANNED/CONFIRMED/CANCELLED/NO_SHOW)
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시