MatchRun

Tables (17)

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
  • INDEX — `m_l_sendUserId_idx`
  • INDEX — `m_l_receveUserId_idx`

likes

  • id — INT — Foreign key → user.id — NOT NULL
  • userId — INT
  • postingId — INT — Foreign key → posting.id
  • INDEX — `m_l_postingId_idx`

matchApply

  • id — INT — Primary key — NOT NULL
  • matchFollowerTeamId — INT
  • matchFolloweeTeamId — INT
  • matchDay — DATETIME

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
  • INDEX — `m_mp_userId_idx`
  • INDEX — `m_mp_teamId_idx`

matchReple

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → user.id
  • content — VARCHAR(100) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • matchPostingId — INT
  • INDEX — `m_mr_userId_idx`

matchReview

  • id — INT — Primary key — NOT NULL
  • matchReviewerTeamId — INT — Foreign key → team.id
  • matchRevieweeTeamId — INT — Foreign key → team.id
  • mannerRating — TINYINT — NOT NULL
  • skillRating — TINYINT — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • INDEX — `m_r_userId_idx`
  • INDEX — `m_r_teamId_idx`

matching

  • id — INT — Primary key — NOT NULL
  • matchFollowerTeamId — INT
  • matchFolloweeTeamId — INT
  • matchDay — DATETIME
  • reviewResult — TINYINT
  • INDEX — `m_m_userId_idx`

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
  • INDEX — `m_n_userId_idx`
  • INDEX — `m_n_teamId_idx`

posting

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → user.id
  • imgUrl — VARCHAR(100)
  • content — VARCHAR(1000)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • teamId — INT — Foreign key → team.id
  • INDEX — `m_userId_idx`
  • INDEX — `m_p_teamId_idx`

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
  • INDEX — `m_pr_userId_idx`
  • INDEX — `m_pr_postingId_idx`

sportsCenter

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • lat — DOUBLE
  • long — DOUBLE
  • postNum — INT
  • roadAddr — VARCHAR(200)
  • tel — VARCHAR(45)

tag

  • id — INT — Primary key — NOT NULL
  • tagId — INT
  • postingId — INT — Foreign key → posting.id
  • INDEX — `t_postingId`

tagName

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • FULLTEXT — INDEX

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
  • INDEX — `m_userId_idx`
  • INDEX — `m_t_userId_idx`

teamFollow

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → user.id
  • teamId — INT — Foreign key → team.id
  • INDEX — `m_tf_userId_idx`
  • INDEX — `m_tf_teamId_idx`

teamFollowApply

  • Id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → user.id
  • teamId — INT — Foreign key → team.id
  • INDEX — `m_ja_userId_idx`
  • INDEX — `m_ja_teamId_idx`

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)
  • subEmail — VARCHAR(45)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP