sweatier_new
Tables (6)
Match
- id — TEXT — Primary key — NOT NULL
- hostId — TEXT — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- capability — INTEGER — NOT NULL
- address — TEXT — NOT NULL
- matchDay — TIMESTAMP(3) — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
Rank
- id — TEXT — Primary key — NOT NULL
- value — TEXT — NOT NULL
- sportsTypeId — TEXT — NOT NULL
Score
- id — TEXT — Primary key — NOT NULL
- userId — TEXT — NOT NULL
- sportsTypeId — TEXT — NOT NULL
- matchId — TEXT — NOT NULL
- value — INTEGER — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
SportsType
- id — TEXT — Primary key — NOT NULL
- name — TEXT — NOT NULL
User
- id (userId) — TEXT — Primary key — NOT NULL
- rankId — TEXT — NOT NULL
- email — TEXT — NOT NULL
- encryptedPasswords — TEXT
- phoneNumber — TEXT — NOT NULL
- accountNumber — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
UserProfile
- id (userId) — TEXT — Foreign key → User.id — NOT NULL
- nickName — TEXT — NOT NULL
- oneLiner — TEXT
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL