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