DB

Tables (9)

CONSISTS_OF

  • Fnum (Key) — INTEGER — Primary key — NOT NULL
  • Inum (Field) — TEXT — Primary key

FOOD

  • Fnumber (Key) — INTEGER — Primary key — NOT NULL
  • Fname (Field) — TEXT

FOOD_POISONING

  • FPnumber (Key) — INTEGER — Primary key — NOT NULL
  • CAname (Field) — TEXT
  • Time (Field3) — INTEGER
  • Min_IP (Field4) — INTEGER
  • Max_IP (Field5) — INTEGER

FREQUENCY_OF_MONTH

  • FPnum (Key) — INTEGER — Primary key — NOT NULL
  • Year (Field) — INTEGER
  • Month (Field3) — INTEGER
  • Frequency (Field4) — INTEGER

HAS

  • FPnum (Key) — Primary key — NOT NULL
  • Snum (Key2) — Primary key — NOT NULL

INGREDIENT

  • Inumber (Key) — INTEGER — Primary key — NOT NULL
  • Iname (Field) — TEXT
  • Icondition (Field3) — INTEGER

RELATED_DISEASE

  • FPnum (Key) — INTEGER — Primary key — NOT NULL
  • Dname (Field) — TEXT

SYMPTOM

  • Snumber (Key) — INTEGER — Primary key — NOT NULL
  • Sname (Field) — TEXT

TRIGGERS

  • Inum (Key) — Primary key — NOT NULL
  • FPnum (Key2) — Primary key — NOT NULL