icare
테이블 (4)
상세정보 (detail)
- medicine_id (PK) — bigint — 기본 키 — NOT NULL
- prescription_id (FK) — bigint — 외래 키 → 처방전.prescription_id — NOT NULL
- medicine_name (Field) — varchar
- dosage_count (Field2) — int
- duration_days (Field3) — int
유저 (user)
- user_id (PK) — bigint — 기본 키 — NOT NULL
- user_name (Field5) — varchar
- email (Field2) — varchar
- password (Field3) — varchar
- token (Field4) — varchar
- created_at (Field) — datetime
- latitude (Field6) — double
- longitude (Field7) — double
자녀 (children)
- children_id (PK) — bigint — 기본 키 — NOT NULL
- user_id (FK) — bigint — 외래 키 → 유저.user_id — NOT NULL
- children_name (Field) — varchar
처방전 (prescription)
- prescription_id (PK) — bigint — 기본 키 — NOT NULL
- children_id (FK) — bigint — 외래 키 → 자녀.children_id — NOT NULL
- pharmacy_name (Field) — varchar
- pharmacy_address (Field5) — varchar
- issue_date (Field2) — datetime
- total_amount (Field3) — int
- created_at_prescription (Field4) — varchar