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