devcamp
Tables (9)
AccessToken
- id — uuid — Primary key — NOT NULL — PK
- jti — varchar — NOT NULL
- token — varchar — NOT NULL
- expiredAt — Timestamp — NOT NULL
- isRevoked — bool — NOT NULL
- createdAt — Timestamp — NOT NULL
- updatedAt (updatedAT) — Timestamp — NOT NULL
RefreshToken
- id — uuid — Primary key — NOT NULL — PK
- jti — varchar — NOT NULL
- token — varchar — NOT NULL
- expiredAt — Timestamp — NOT NULL
- isRevoked — bool — NOT NULL
- createdAt — Timestamp — NOT NULL
- updatedAt (updatedAT) — Timestamp — NOT NULL
TokenBlackList
- id — uuid — Primary key — NOT NULL — PK
- createdAt — Timestamp — NOT NULL
- updatedAt (updatedAT) — Timestamp — NOT NULL
- jti — varchar — NOT NULL
- token — varchar — NOT NULL
User
- id — uuid — Primary key — NOT NULL — PK
- userName — varchar — NOT NULL
- password — varchar — NOT NULL
- phone — varchar — NOT NULL
- role — varchar — NOT NULL — Admin | User