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