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