sweatier
Tables (9)
Untitled (Profile)
- Key (userId) — Foreign key → User.Key — NOT NULL
- Field (img) — NOT NULL
- Field (gender) — enum — NOT NULL
- Field (nickName) — NOT NULL
- Field (oneLiner)
- Field (accountNumber) — NOT NULL
- Field (createdAt) — NOT NULL
- Field (updatedAt) — NOT NULL
Untitled (Match)
- Key (id) — string — Primary key — NOT NULL
- Key (rankId) — Foreign key → Untitled.Key — NOT NULL
- Key (sportsTypeId) — Foreign key → Untitled.Key — NOT NULL
- Field2 (title) — NOT NULL
- Field (content) — NOT NULL
- Field (capability) — NOT NULL
- Field (applicant) — NOT NULL
- Field3 (address) — NOT NULL
- Field (matchDay) — NOT NULL
- Field (expired) — boolean — NOT NULL
- Field (gender) — enum — NOT NULL
- Field (createdAt) — NOT NULL
- Field (updatedAt) — NOT NULL
Untitled (Tier)
- Key (rankId) — Primary key — NOT NULL
- Key (tierTypeId) — Foreign key → Untitled.Key — NOT NULL
- Field (value) — NOT NULL
- Field (description) — NOT NULL
Untitled (Score)
- Key (scoreId) — Primary key — NOT NULL
- Key (userId) — Foreign key → User.Key — NOT NULL
- Key (sportsTypeId) — Foreign key → Untitled.Key — NOT NULL
- Key (matchId) — Foreign key → Untitled.Key — NOT NULL
- Field (value) — NOT NULL
- Field (createdAt) — NOT NULL
Untitled (SportsType)
- Key (sportsTypeId) — Primary key — NOT NULL
- Field (name) — NOT NULL
Untitled (User_Match)
- Key (userId) — Foreign key → User.Key — NOT NULL
- Key (matchId) — Foreign key → Untitled.Key — NOT NULL
Untitled (User_SportsType)
- Key (userId) — Foreign key → User.Key — NOT NULL
- Key (sportsTypeId) — Foreign key → Untitled.Key — NOT NULL
Untitled (User_Tier)
- Key (userId) — Foreign key → User.Key — NOT NULL
- Key (rankId) — Foreign key → Untitled.Key — NOT NULL
User
- Key (id) — Primary key — NOT NULL
- Field (email) — NOT NULL
- Field (encryptedPassword)
- Field (createdAt) — NOT NULL
- Field (updatedAt) — NOT NULL