Care Bridge
Tables (9)
Chart (간호 차트)
- chartId (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- patientId (id2) — Long — Foreign key → Patient.patientId — NOT NULL — Auto Increament
- 관리요양등급 (level) — Integer
- 장기요양번호 (nursingNum) — Long
- 입소일 (startDate) — DATE — NOT NULL
Cognitive_Management (인지 관리)
- cognitiveld (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- chartId (id2) — Long — Foreign key → Chart.chartId — NOT NULL — Auto Increament
- 인지관리 지원 (cognitiveHelp) — Boolean — NOT NULL
- 의사소통 도움 (talk) — Boolean — NOT NULL
- 특이사항 (significant) — Varchar(500)
Guardian (보호자)
- guardianId (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- 이름 (name) — VARCHAR(500)
- 전화번호 (phoneNumber) — VARCHAR(500)
Institution (요양기관)
- institutionId (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- 기괸 이름 (name) — VARCHAR(500) — NOT NULL
Patient (돌봄 대상자)
- patientId (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- workerId (id2) — Long — Foreign key → Worker.workerId — NOT NULL — Auto Increament
- guardianId (id3) — Long — Foreign key → Guardian.guardianId — NOT NULL — Auto Increament
- 이름 (name) — VARCHAR(500) — NOT NULL
- 전화번호 (phoneNumber) — VARCHAR(100)
- 나이 (age) — Integer — NOT NULL
- 성별 (gender) — VARCHAR(50) — NOT NULL
- institutionId (id4) — Long — Foreign key → Institution.institutionId — NOT NULL — Auto Increament
Physical_Activity (신체 활동)
- physicald (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- chartId (id2) — Long — Foreign key → Chart.chartId — NOT NULL — Auto Increament
- 청결 (wash) — Boolean — NOT NULL
- 목욕 (bath) — Varchar(500) — NOT NULL
- 식사 (meal) — Varchar(500) — NOT NULL
- 체위변경 (positionChange) — Boolean — NOT NULL
- 이동 (move) — Boolean — NOT NULL
- 외출 동행 (goingOut) — Varchar(500) — NOT NULL
- 특이사항 (significant) — Varchar(500)
Worker (요양사)
- workerId (id) — Long — Primary key — NOT NULL — Auto Increament
- createAt — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP
- institutionId (id2) — Long — Foreign key → Institution.institutionId — NOT NULL — Auto Increament
- 이름 (name) — VARCHAR(500) — NOT NULL
- 전화번호 (phoneNumber) — VARCHAR(100) — NOT NULL
- 비밀번호 (password) — VARCHAR(1000) — NOT NULL
nursing_management
- id — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- is_active — BOOLEAN
- health_blood_pressure_systolic — INT
- health_blood_pressure_diastolic — INT
- health_temperature — VARCHAR(255)
- health_note — VARCHAR(1000)
- X — INT — NOT NULL
- chartId (id2) — Long — Foreign key → Chart.chartId — NOT NULL — Auto Increament
recovery_training
- id — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- is_active — BOOLEAN
- recovery_program — VARCHAR(255)
- recovery_training — BOOLEAN
- recovery_note — VARCHAR(1000) — NOT NULL
- chartId (id2) — Long — Foreign key → Chart.chartId — NOT NULL — Auto Increament