-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
Qilin Xie edited this page May 24, 2024
·
1 revision
Our application uses a PostgreSQL database with the following schema:
- id (INTEGER, Primary Key): Unique identifier for each user.
- username (STRING, Unique, Not Null): The user's unique username.
- password (STRING, Not Null): The user's hashed password.
- createdAt (TIMESTAMP, Not Null): Timestamp of when the user was created.
- updatedAt (TIMESTAMP, Not Null): Timestamp of when the user was last updated.
- capabilities (ARRAY of STRINGs, Default: ['read']): Permissions assigned to the user.