단짝
테이블 (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