wellsy2

Tables (16)

AI_HEALTH_REPORT

  • REPORT_ID — INT — Primary key — NOT NULL — 건강리포트번호
  • REPORT_DATE — DATE — NOT NULL — 리포트작성일
  • REPORT_TITLE — VARCHAR(200) — NOT NULL — 리포트제목
  • HEALTH_SUMMARY — TEXT — 건강상태요약
  • EXERCISE_ANALYSIS — TEXT — 운동분석
  • SLEEP_ANALYSIS — TEXT — 수면분석
  • MEAL_ANALYSIS — TEXT — 식단분석
  • RECOMMENDATION — TEXT — AI종합추천
  • CREATED_AT — TIMESTAMP — NOT NULL — 생성일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번

CHAT_MESSAGE

  • CHAT_MESSAGE_ID — INT — Primary key — NOT NULL — 채팅메시지번호
  • SENDER_TYPE — VARCHAR(10) — NOT NULL — 발신자구분
  • MESSAGE_CONTENT — TEXT — NOT NULL — 메시지내용
  • CREATED_AT — TIMESTAMP — NOT NULL — 작성일시
  • CHAT_SESSION_ID — INT — Foreign key → CHAT_SESSION.CHAT_SESSION_ID — NOT NULL — 채팅방번호

CHAT_SESSION

  • CHAT_SESSION_ID — INT — Primary key — NOT NULL — 채팅방번호
  • TITLE — VARCHAR(200) — 상담제목
  • CONSULTATION_TYPE — VARCHAR(30) — NOT NULL — 상담유형
  • CREATED_AT — TIMESTAMP — NOT NULL — 상담시작일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번

CHECKUP_RESERVATION

  • RESERVATION_ID — INT — Primary key — NOT NULL — 검진예약번호
  • RESERVATION_DATE — DATETIME — NOT NULL — 검진예약일시
  • HOSPITAL_NAME — VARCHAR(100) — NOT NULL — 병원명
  • STATUS — VARCHAR(20) — NOT NULL — 예약상태
  • MEMO — VARCHAR(500) — 메모
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번

DEPARTMENT

  • DEPARTMENT_ID — INT — Primary key — NOT NULL — 부서번호
  • DEPARTMENT_NAME — VARCHAR(100) — NOT NULL — 부서명
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시

EMPLOYEE

  • EMPLOYEE_NO — INT — Primary key — NOT NULL — 사번
  • LOGIN_ID — VARCHAR(50) — NOT NULL — 로그인아이디
  • EMAIL — VARCHAR(100) — NOT NULL — 이메일
  • PASSWORD — VARCHAR(300) — NOT NULL — 비밀번호
  • NAME — VARCHAR(50) — NOT NULL — 직원명
  • PHONE — VARCHAR(20) — 전화번호
  • GENDER — VARCHAR(10) — 성별
  • BIRTH_DATE — DATE — 생년월일
  • POSITION_NAME — VARCHAR(50) — 직급
  • ROLE — VARCHAR(20) — NOT NULL — 권한
  • EMPLOYMENT_STATUS — VARCHAR(20) — NOT NULL — 재직상태
  • HIRE_DATE — DATE — NOT NULL — 입사일
  • RESIGN_DATE — DATE — 퇴사일
  • DEPARTMENT_ID — INT — Foreign key → DEPARTMENT.DEPARTMENT_ID — 부서번호

EXERCISE

  • EXERCISE_ID — INT — Primary key — NOT NULL — 운동번호
  • EXERCISE_NAME — VARCHAR(100) — NOT NULL — 운동명
  • EXERCISE_TYPE — VARCHAR(50) — 운동유형
  • DESCRIPTION — VARCHAR(1000) — 운동방법
  • IMAGE_URL — VARCHAR(1000) — 운동이미지
  • VIDEO_URL — VARCHAR(1000) — 운동영상
  • DIFFICULTY — VARCHAR(20) — 난이도
  • CALORIES_PER_MINUTE — DECIMAL(6, 2) — 분당소모칼로리
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시

EXERCISE_RECORD

  • EXERCISE_RECORD_ID — INT — Primary key — NOT NULL — 운동기록번호
  • EXERCISE_DATE — DATE — NOT NULL — 운동일
  • TARGET_DURATION — INT — 목표운동시간
  • ACTUAL_DURATION — INT — 실제운동시간
  • TARGET_COUNT — INT — 목표운동횟수
  • ACTUAL_COUNT — INT — 실제운동횟수
  • ACHIEVEMENT_RATE — DECIMAL(5, 2) — 달성률
  • STATUS — VARCHAR(20) — NOT NULL — 운동상태
  • FAILURE_REASON — VARCHAR(500) — 미달성사유
  • MEMO — VARCHAR(1000) — 메모
  • AI_FEEDBACK — VARCHAR(4000) — AI피드백
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번
  • EXERCISE_ID — INT — Foreign key → EXERCISE.EXERCISE_ID — NOT NULL — 운동번호

HEALTH_ALERT

  • ALERT_ID — INT — Primary key — NOT NULL — 건강알림번호
  • ALERT_TYPE — VARCHAR(50) — NOT NULL — 알림유형
  • SEVERITY — VARCHAR(20) — NOT NULL — 위험도
  • MESSAGE — VARCHAR(1000) — 알림내용
  • IS_READ — CHAR(1) — NOT NULL — 읽음여부
  • CREATED_AT — TIMESTAMP — NOT NULL — 알림발생일시
  • CHECKUP_ID — INT — Foreign key → HEALTH_CHECKUP.CHECKUP_ID — NOT NULL — 건강검진번호

HEALTH_CHECKUP

  • CHECKUP_ID — INT — Primary key — NOT NULL — 건강검진번호
  • RESULT_GRADE — VARCHAR(20) — NOT NULL — 검진등급
  • SYSTOLIC_BP — INT — 수축기혈압
  • DIASTOLIC_BP — INT — 이완기혈압
  • BLOOD_SUGAR — DECIMAL(6, 2) — 혈당
  • TOTAL_CHOLESTEROL — DECIMAL(6, 2) — 총콜레스테롤
  • WEIGHT — DECIMAL(5, 2) — 체중
  • HEIGHT — DECIMAL(5, 2) — 키
  • RESULT_DETAIL — VARCHAR(2000) — 검진상세내용
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • RESERVATION_ID — INT — Foreign key → CHECKUP_RESERVATION.RESERVATION_ID — NOT NULL — 검진예약번호

HEALTH_RECORD

  • HEALTH_RECORD_ID — INT — Primary key — NOT NULL — 건강기록번호
  • RECORD_DATE — DATE — NOT NULL — 기록일
  • HEIGHT — DECIMAL(5, 2) — 키
  • WEIGHT — DECIMAL(5, 2) — 체중
  • BMI — DECIMAL(5, 2) — BMI
  • SYSTOLIC_BP — INT — 수축기혈압
  • DIASTOLIC_BP — INT — 이완기혈압
  • BLOOD_SUGAR — DECIMAL(6, 2) — 혈당
  • CAFFEINE_CUP_COUNT — DECIMAL(4, 1) — 카페인섭취량
  • SMOKING_COUNT — INT — 흡연량
  • ALCOHOL_BOTTLE_COUNT — DECIMAL(4, 1) — 음주량
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번

HEALTH_STANDARD

  • STANDARD_ID — INT — Primary key — NOT NULL — 건강기준번호
  • METRIC_TYPE — VARCHAR(50) — NOT NULL — 건강지표
  • GENDER — VARCHAR(10) — 성별
  • MIN_AGE — INT — 최소나이
  • MAX_AGE — INT — 최대나이
  • MIN_VALUE — DECIMAL(8, 2) — 최소기준값
  • MAX_VALUE — DECIMAL(8, 2) — 최대기준값
  • GRADE — VARCHAR(20) — NOT NULL — 건강등급
  • DESCRIPTION — VARCHAR(500) — 기준설명

MEAL_RECORD

  • MEAL_RECORD_ID — INT — Primary key — NOT NULL — 식사기록번호
  • MEAL_DATE — DATE — NOT NULL — 식사일
  • MEAL_TYPE — VARCHAR(20) — NOT NULL — 식사유형
  • MEAL_CONTENT — VARCHAR(2000) — 식사내용
  • MEAL_AMOUNT_GRAM — DECIMAL(7, 2) — 식사량
  • MEAL_AMOUNT_DESCRIPTION — VARCHAR(100) — 식사량설명
  • CALORIES — DECIMAL(7, 2) — 칼로리
  • CARBOHYDRATE — DECIMAL(7, 2) — 탄수화물
  • PROTEIN — DECIMAL(7, 2) — 단백질
  • FAT — DECIMAL(7, 2) — 지방
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번

NOTICE

  • NOTICE_ID — INT — Primary key — NOT NULL — 공지사항번호
  • TITLE — VARCHAR(200) — NOT NULL — 공지제목
  • CONTENT — TEXT — NOT NULL — 공지내용
  • IS_PINNED — CHAR(1) — NOT NULL — 상단고정여부
  • VIEW_COUNT — INT — NOT NULL — 조회수
  • IS_DELETED — CHAR(1) — NOT NULL — 삭제여부
  • CREATED_AT — TIMESTAMP — NOT NULL — 작성일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 작성자사번

NOTICE_COMMENT

  • COMMENT_ID — INT — Primary key — NOT NULL — 댓글번호
  • CONTENT — VARCHAR(2000) — NOT NULL — 댓글내용
  • IS_DELETED — CHAR(1) — NOT NULL — 삭제여부
  • CREATED_AT — TIMESTAMP — NOT NULL — 작성일시
  • NOTICE_ID — INT — Foreign key → NOTICE.NOTICE_ID — NOT NULL — 공지사항번호
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 작성자사번

SLEEP_RECORD

  • SLEEP_RECORD_ID — INT — Primary key — NOT NULL — 수면기록번호
  • SLEEP_DATE — DATE — NOT NULL — 수면기준일
  • SLEEP_START — DATETIME — NOT NULL — 취침일시
  • SLEEP_END — DATETIME — NOT NULL — 기상일시
  • SLEEP_QUALITY — TINYINT — 수면품질
  • MEMO — VARCHAR(1000) — 메모
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록일시
  • EMPLOYEE_NO — INT — Foreign key → EMPLOYEE.EMPLOYEE_NO — NOT NULL — 사번