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