game-pot
Tables (9)
COMMENTS
- comment_id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → POSTS.post_id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- comment — TEXT
- comment_date — TIMESTAMP — NOT NULL
FAVORITES
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- game_id — INT — Foreign key → Games.game_id — NOT NULL
Games (GAMES)
- game_id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- min_spec — TEXT — NOT NULL
- rec_spec — TEXT — NOT NULL
MatchParty (MATCHPARTY)
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- match_id — INT — Foreign key → Matches.match_id — NOT NULL
Matches (MATCHES)
- match_id — INT — Primary key — NOT NULL
- game_id — INT — Foreign key → Games.game_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_match — TIMESTAMP — NOT NULL
- discord_channel — VARCHAR(255)
PLAYLOGS
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- game_id — INT — Foreign key → Games.game_id — NOT NULL
- game_total_play — INT
POSTS
- post_id — INT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_date — TIMESTAMP — NOT NULL
- recommend — INT
RECOMMENDS
- user_id — BIGINT — Foreign key → USERS.user_id — NOT NULL
- post_id — INT — Foreign key → POSTS.post_id — NOT NULL
USERS
- user_id — BIGINT — Primary key — NOT NULL
- nick_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- level — INT — NOT NULL
- experience — INT — NOT NULL
- steam_id — VARCHAR(255)
- discord_id — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- create_date — TIMESTAMP — NOT NULL