Query

mira.db — room_boardings

SQL

CREATE TABLE room_boardings  (
  id         TEXT PRIMARY KEY,
  room_id    TEXT NOT NULL REFERENCES rooms(id),
  user_id    TEXT NOT NULL UNIQUE REFERENCES users(id),
  created_at INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
room_id TEXT Rename | Drop
user_id TEXT Rename | Drop
created_at INTEGER Rename | Drop

Foreign Keys

Column Destination
user_id users.id
room_id rooms.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_room_boardings_room room_id SQL 
CREATE INDEX idx_room_boardings_room
ON room_boardings(room_id)
Drop
sqlite_autoindex_room_boardings_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_room_boardings_2 user_id ✓ SQL
-- no sql found --
 Drop