Query

database.db — feedbacks

SQL

CREATE TABLE feedbacks  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  question_ids TEXT,
  question_id INTEGER,
  user_question TEXT,
  expected_answer TEXT,
  created_at TEXT NOT NULL,
  is_positive INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
question_ids TEXT ✓ Rename | Drop
question_id INTEGER ✓ Rename | Drop
user_question TEXT ✓ Rename | Drop
expected_answer TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
is_positive INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?