MatchUp
Tables (5)
Comment
- comment_id — INT
- content — TEXT
- user_id — INT — Foreign key → User.user_id
- match_id — INT — Foreign key → Match.match_id
Match
- match_id — INT
- title — VARCHAR(100)
- date — DATE
- place — VARCHAR(100)
- max_player — INT
- user_id — INT — Foreign key → User.user_id
Participation
- participation_id — INT
- user_id — INT — Foreign key → User.user_id
- match_id — INT — Foreign key → Match.match_id
- status — VARCHAR(30)
SoccerMatch
- match_id — INT
- title — VARCHAR(100)
- match_date — DATE
- place — VARCHAR(100)
- max_player — INT
- user_id — INT — Foreign key
User
- user_id — INT
- name — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(100)
- location — VARCHAR(100)