Query

app.db — chatbot_user_assignments

SQL

CREATE TABLE chatbot_user_assignments  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  user_id INTEGER NOT NULL,
  assigned_by INTEGER NOT NULL,
  assigned_at TEXT NOT NULL,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
  FOREIGN KEY (assigned_by) REFERENCES users(id),
  UNIQUE(chatbot_id, user_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
user_id INTEGER Rename | Drop
assigned_by INTEGER Rename | Drop
assigned_at TEXT Rename | Drop

Foreign Keys

Column Destination
assigned_by users.id
user_id users.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_chatbot_user_assignments_1
  • chatbot_id
  • user_id
 ✓ SQL
-- no sql found --
 Drop