SQL

CREATE TABLE food  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  date TEXT NOT NULL,
  name TEXT NOT NULL,
  weight REAL,
  calories REAL,
  protein REAL,
  fat REAL,
  carbs REAL,
  comment TEXT
)

Columns

+ Add column
Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
date TEXT Rename | Drop
name TEXT Rename | Drop
weight REAL ✓ Rename | Drop
calories REAL ✓ Rename | Drop
protein REAL ✓ Rename | Drop
fat REAL ✓ Rename | Drop
carbs REAL ✓ Rename | Drop
comment TEXT ✓ Rename | Drop

Indexes

+ Add index
Name Columns Unique SQL Drop?