Pharmacy

Tables (8)

Billing (Untitled8)

  • Key — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Lotion.ID — NOT NULL
  • ID (Name) — Foreign key → Injection.ID — NOT NULL
  • ID (Name2) — Foreign key → Cream.ID — NOT NULL
  • ID (Name3) — Foreign key → Tablets.ID — NOT NULL
  • ID (Name4) — Foreign key → Vaccines.ID — NOT NULL
  • Field
  • Field2

Cream (Untitled4)

  • ID (Name) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Injection (Untitled5)

  • ID (Name) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Inventories (Untitled)

  • ID (Name) — Primary key — NOT NULL
  • Lotioin_ID (Key2) — Foreign key → Lotion.ID — NOT NULL
  • Key (Key3) — Foreign key → Cream.ID — NOT NULL
  • Key (Key4) — Foreign key → Injection.ID — NOT NULL
  • Key (Key5) — Foreign key → Tablets.ID — NOT NULL
  • Key (Key6) — Foreign key → Vaccines.ID — NOT NULL
  • Field

Lotion (Untitled3)

  • ID (Name) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Reports (Untitled2)

  • ID (Name) — Primary key — NOT NULL
  • Key — Foreign key → Billing.Key — NOT NULL
  • ID (Key2) — Foreign key → Billing.ID — NOT NULL
  • ID (Name2) — Foreign key → Billing.ID — NOT NULL
  • ID (Name22) — Foreign key → Billing.ID — NOT NULL
  • ID (Name3) — Foreign key → Billing.ID — NOT NULL
  • ID (Name4) — Foreign key → Billing.ID — NOT NULL
  • Field

Tablets (Untitled6)

  • ID (Name) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Vaccines (Untitled7)

  • ID (Name) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4