Query

interns.db — timesheet

SQL

CREATE TABLE "timesheet"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "last" TEXT,
  "date" TEXT,
  "task" TEXT,
  "total_time" INTEGER,
  "correct_time" REAL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
last TEXT ✓ Rename | Drop
date TEXT ✓ Rename | Drop
task TEXT ✓ Rename | Drop
total_time INTEGER ✓ Rename | Drop
correct_time REAL ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?