pittalk

Tables (5)

comment

  • id — BIGINT(20) — Primary key — NOT NULL
  • post_id — BIGINT(20)
  • user_id — BIGINT(20)
  • content — VARCHAR(255)
  • created_at — DATETIME

post

  • id — BIGINT(20) — Primary key — NOT NULL
  • team_id — BIGINT(20)
  • user_id — BIGINT(20)
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • like_count — INT(11)
  • created_at — DATETIME

team

  • id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(255)
  • intro_text — VARCHAR(255)

team_trait

  • id — BIGINT(20) — Primary key — NOT NULL
  • team_name — VARCHAR(255)
  • performance — INT(11)
  • tradition — INT(11)
  • tech_vs_emotion — INT(11)
  • underdog — INT(11)
  • budget — INT(11)
  • driver — INT(11)

user

  • id — BIGINT(20) — Primary key — NOT NULL
  • userid — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255)
  • favorite_team_id — BIGINT(20)