단짝

테이블 (8)

hashtag (일지 오늘의 해시태그)

  • hashtag_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • log_index (Key2) — small serial — 외래 키 → log.log_index — NOT NULL
  • hospital_index (Key32) — small serial, primary key — 외래 키 → log.hospital_index — NOT NULL
  • user_index (Key22) — small serial, primary key — 외래 키 → log.user_index — NOT NULL
  • name (Field) — VARCHAR(255)

hospital (요양원)

  • hospital_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(255)
  • address (Field2) — VARCHAR(255)
  • rating (Field3) — DOUBLE

log (일지)

  • log_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — small serial — 외래 키 → users.user_index — NOT NULL
  • patient_index (Key3) — small serial — 외래 키 → patient.patient_index — NOT NULL
  • hospital_index (Key32) — small serial, primary key — 외래 키 → patient.hospital_index — NOT NULL
  • user_index (Key22) — small serial, primary key — 외래 키 → patient.user_index — NOT NULL
  • breakfast (Field) — VARCHAR(255)
  • lunch (Field2) — VARCHAR(255)
  • dinner (Field3) — VARCHAR(255)
  • activity (Field4) — VARCHAR(255)
  • comment (Field5) — VARCHAR(255)
  • created_at (Field6) — TIMESTAMP

medicine (약)

  • medicine_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(255)
  • img_url (Field2) — VARCHAR(255)

medicine_at_log (일지에 매핑된 약)

  • medicine_at_log_index (Key3) — small serial, primary key — 기본 키 — NOT NULL
  • log_index (Key) — small serial — 외래 키 → log.log_index — NOT NULL
  • medicine_index (Key2) — small serial — 외래 키 → medicine.medicine_index — NOT NULL
  • hospital_index (Key32) — small serial, primary key — 외래 키 → log.hospital_index — NOT NULL
  • user_index (Key22) — small serial, primary key — 외래 키 → log.user_index — NOT NULL

patient (환자)

  • patient_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • hospital_index (Key3) — small serial, primary key — 외래 키 → hospital.hospital_index — NOT NULL
  • user_index (Key2) — small serial, primary key — 외래 키 → users.user_index — NOT NULL
  • name (Field) — VARCHAR(255)

users (회원정보)

  • user_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • id (Field2) — VARCHAR(255)
  • password (Field) — VARCHAR(255)

visit (면회)

  • visit_index (Key) — small serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — small serial, primary key — 외래 키 → users.user_index — NOT NULL
  • patient_index (Key3) — small serial, primary key — 외래 키 → patient.patient_index — NOT NULL
  • hospital_index (Key32) — small serial, primary key — 외래 키 → patient.hospital_index — NOT NULL
  • user_index (Key22) — small serial, primary key — 외래 키 → patient.user_index — NOT NULL
  • visit_date (Field) — TIMESTAMP
  • requirements (Field2) — TEXT
  • created_at (Field3) — TIMESTAMP