foods

77 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: saturated_fat_g, polyunsaturated_fat_g, monounsaturated_fat_g, cholesterol_mg, fiber_g, sugars_g, owner_user_id, is_shared, created_at (date), updated_at (date)

CREATE TABLE foods (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    calories REAL NOT NULL,
    protein_g REAL NOT NULL,
    carbs_g REAL NOT NULL,
    fat_g REAL NOT NULL,
    created_at TEXT NOT NULL DEFAULT (datetime('now')),
    updated_at TEXT NOT NULL DEFAULT (datetime('now'))
  , saturated_fat_g REAL DEFAULT 0, trans_fat_g REAL DEFAULT 0, polyunsaturated_fat_g REAL DEFAULT 0, monounsaturated_fat_g REAL DEFAULT 0, cholesterol_mg REAL DEFAULT 0, sodium_mg REAL DEFAULT 0, fiber_g REAL DEFAULT 0, sugars_g REAL DEFAULT 0, owner_user_id INTEGER, is_shared INTEGER NOT NULL DEFAULT 1);