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