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