Query

keys.db — Logs

SQL

CREATE TABLE "Logs"  (
  "ID" INTEGER NOT NULL,
  id_usuario INTEGER,
  "CUIT" VARCHAR NOT NULL,
  "Timestamp" DATETIME,
  PRIMARY KEY ("ID"),
  FOREIGN KEY(id_usuario) REFERENCES "Users" (id_usuario)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
ID INTEGER ✓ Rename | Drop
id_usuario INTEGER ✓ Rename | Drop
CUIT VARCHAR Rename | Drop
Timestamp DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
id_usuario Users.id_usuario

+ Add index

Indexes

Name Columns Unique SQL Drop?