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