MatchRun

Tables (15)

joinApply

  • Id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • teamId — int — Foreign key → team.id

letter

  • id — int — Primary key — NOT NULL
  • sendUserId — int — Foreign key → user.id
  • receiveUserId — int — Foreign key → user.id
  • content — varchar(500) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

likes (like)

  • id — int — Foreign key → user.id — NOT NULL
  • userId — int
  • postingId — int — Foreign key → posting.id

matchApply

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • teamId — int — Foreign key → team.id
  • homeTeamId — int — Foreign key → team.id
  • awayTeamId — int — Foreign key → team.id
  • matchDate — timestamp
  • createdAt — timestamp
  • updatedAt — timestamp

matchPosting

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • teamId — int — Foreign key → team.id
  • title — varchar(100) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

matchReple

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • content — varchar(100) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp
  • matchPostingId — int — Foreign key → matchPosting.id

notice

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • teamId — int — Foreign key → team.id
  • title — varchar(50) — NOT NULL
  • imgUrl — varchar(100)
  • content — varchar(1000)
  • createdAt — timestamp
  • updatedAt — timestamp

posting

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • imgUrl — varchar(100)
  • content — varchar(1000)
  • createdAt — timestamp
  • updatedAt — timestamp
  • teamId (Field) — int

postingReple

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • postingId — int — Foreign key → posting.id
  • content — varchar(100) — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

review

  • id — int — Primary key — NOT NULL
  • teamId — int — Foreign key → team.id
  • userId — int — Foreign key → user.id
  • mannerRating — tinyint — NOT NULL
  • skillRating — tinyint — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

tag

  • id — int — Primary key — NOT NULL
  • tagId — int
  • postingId — int — Foreign key → posting.id

tagName

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • FULLTEXT — KEY

team

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • imgUrl — varchar(200)
  • name — varchar(45)
  • sports — varchar(45)
  • address — varchar(100) — NOT NULL
  • addrDetail — varchar(100) — NOT NULL
  • introduce — varchar(500)
  • createdAt — timestamp
  • updatedAt — timestamp

teamFollow

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.id
  • teamId — int — Foreign key → team.id

user

  • id — int — Primary key — NOT NULL
  • email — varchar(45) — NOT NULL
  • password — varchar(200) — NOT NULL
  • imgUrl — varchar(200)
  • question — varchar(45) — NOT NULL
  • questionAn — varchar(45) — NOT NULL
  • name — varchar(45)
  • nickname — varchar(45) — NOT NULL
  • address — varchar(100) — NOT NULL
  • addrDetail — varchar(100) — NOT NULL
  • introduce — varchar(500)
  • createdAt — timestamp
  • updatedAt — timestamp