FingerPrint

Tables (3)

Paging (널스 콜)

  • Key — int — Primary key — NOT NULL
  • member_id (멤버 아이디) — int — Foreign key → Patient.Key — NOT NULL
  • reason (Field) — text
  • is_checked (Field2) — boolean
  • checked_at (Field3) — date
  • location (Field4) — varchar
  • occures_at (Field5) — date

Patient (환자)

  • Key — int — Primary key — NOT NULL
  • name (이름) — varchar
  • status (Field2) — num
  • room (Field3) — int
  • birth_date (Field4) — date
  • gender (Field5) — boolean
  • blood_type (Field6) — char
  • doctor (Field7) — varchar
  • Field

emergency (응급 콜)

  • Key — int — Primary key — NOT NULL
  • member_id (멤버 아이디) — int — Foreign key → Patient.Key — NOT NULL
  • reason (Field) — text
  • is_checked (Field2) — boolean
  • checked_at (Field3) — date
  • location (Field4) — vatchar
  • occures_at (Field5) — date