Query

assessment_data.db — assessments

SQL

CREATE TABLE assessments  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
  name TEXT NOT NULL,
  email TEXT NOT NULL,
  company TEXT,
  employees TEXT,
  market TEXT,
  it_department TEXT,
  documentation TEXT,
  media_breaks TEXT,
  pain_point TEXT,
  decision_making TEXT,
  automation TEXT,
  budget TEXT,
  change_readiness TEXT,
  calculated_level INTEGER,
  level_title TEXT,
  score_detail TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
timestamp DATETIME ✓ Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
company TEXT ✓ Rename | Drop
employees TEXT ✓ Rename | Drop
market TEXT ✓ Rename | Drop
it_department TEXT ✓ Rename | Drop
documentation TEXT ✓ Rename | Drop
media_breaks TEXT ✓ Rename | Drop
pain_point TEXT ✓ Rename | Drop
decision_making TEXT ✓ Rename | Drop
automation TEXT ✓ Rename | Drop
budget TEXT ✓ Rename | Drop
change_readiness TEXT ✓ Rename | Drop
calculated_level INTEGER ✓ Rename | Drop
level_title TEXT ✓ Rename | Drop
score_detail TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?