CREATE TABLE "identity_credential_identifiers" ( "id" TEXT PRIMARY KEY, "identifier" TEXT NOT NULL, "identity_credential_id" char(36) NOT NULL, "created_at" DATETIME NOT NULL, "updated_at" DATETIME NOT NULL, FOREIGN KEY (identity_credential_id) REFERENCES identity_credentials (id) ON DELETE cascade )