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 — 사번