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