Social Login Provider
Tables (3)
App
- Id — INT — Primary key — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- ClientId — VARCHAR(255) — NOT NULL
- ClientSecret — VARCHAR(255) — NOT NULL
- RedirectUri — VARCHAR(500) — NOT NULL
- OwnerUserId — INT — Foreign key → User.Id — NOT NULL
- Created — DATETIME — NOT NULL
- INDEX — `IX_App_OwnerUserId`
RefreshToken
- Token — CHAR(32) — Primary key — NOT NULL
- UserId — INT — Foreign key → User.Id — NOT NULL
- ExpiresAt — DATETIME — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- INDEX — `IX_RefreshToken_UserId`
User
- Id — INT — Primary key — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Created — DATETIME — NOT NULL