SQL

CREATE TABLE light_measurements  (
  reading_id INTEGER PRIMARY KEY AUTOINCREMENT,
  identifier TEXT NOT NULL,
  lx_measure INTEGER NOT NULL,
  time TEXT NOT NULL,
  date TEXT NOT NULL
)

Columns

Column Data type Allow null Primary key Actions
reading_id INTEGER ✓ ✓ read-only
identifier TEXT read-only
lx_measure INTEGER read-only
time TEXT read-only
date TEXT read-only

Indexes

Name Columns Unique SQL Drop?