ACE

Tables (3)

MEDICINE (Untitled2)

  • ID (Key) — NOTNULL — Primary key — NOT NULL
  • PRODUCT_ID (Key22) — NOTNULL — Foreign key → USER.PRODUCT_ID — NOT NULL
  • TIME (Field) — NOTNULL
  • MEDICINE_NAME (Field2) — NULLABLE

STATUS (Untitled3)

  • ID (Key) — NOTNULL — Primary key — NOT NULL
  • PRODUCT_ID (Key22) — NOTNULL — Foreign key → USER.PRODUCT_ID — NOT NULL
  • DATE (Field) — NOTNULL
  • TIME (Field6) — NOTNULL
  • INTAKE_CHK (Field2) — NOTNULL
  • CONDITION (Field5) — NOTNULL

USER (Untitled)

  • PRODUCT_ID (Key2) — NOTNULL — Primary key — NOT NULL
  • PHARMACY (Field5) — NULLABLE
  • USERNAME (Field) — NOTNULL
  • SEX (Field2) — NOTNULL
  • AGE (Field3) — NOTNULL
  • HOSPITAL (Field4) — NULLABLE