SQL
CREATE TABLE "auth_identity" (
"userId" VARCHAR(36) REFERENCES "user" (id),
"providerId" VARCHAR(64) NOT NULL,
"providerType" VARCHAR(32) NOT NULL,
"createdAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY("providerId", "providerType")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
userId |
VARCHAR(36) |
✓ | Rename | Drop | |
providerId |
VARCHAR(64) |
✓ | Rename | Drop | |
providerType |
VARCHAR(32) |
✓ | Rename | Drop | |
createdAt |
timestamp |
Rename | Drop | ||
updatedAt |
timestamp |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
userId |
user.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_auth_identity_1 |
|
✓ | SQL | Drop |