+/- table definition

Query 

CREATE TABLE messages  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  booking_id INTEGER,
  property_id TEXT NOT NULL,
  external_id TEXT UNIQUE,
  sender TEXT NOT NULL,
  content_message TEXT NOT NULL,
  sent_at DATE NOT NULL,
  status TEXT DEFAULT 'sent',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (booking_id) REFERENCES bookings(id)
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop