github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/transactional/20191100000001000004_identities.sqlite3.up.sql (about)

     1  CREATE TABLE "identity_credential_identifiers" (
     2  "id" TEXT PRIMARY KEY,
     3  "identifier" TEXT NOT NULL,
     4  "identity_credential_id" char(36) NOT NULL,
     5  "created_at" DATETIME NOT NULL,
     6  "updated_at" DATETIME NOT NULL,
     7  FOREIGN KEY (identity_credential_id) REFERENCES identity_credentials (id) ON DELETE cascade
     8  )