test

Tables (7)

chat (Untitled)

  • id (Key3) — Primary key — NOT NULL
  • author (Key) — Foreign key → user.id — NOT NULL
  • post_Id (Key2) — Foreign key → post.id — NOT NULL
  • content (Field) — string — NOT NULL
  • created_At (Field2) — string — NOT NULL

like (Untitled2)

  • id (Key4) — Primary key — NOT NULL
  • author (Key2) — Foreign key → user.id — NOT NULL
  • post_id (Key) — Foreign key → post.id — NOT NULL
  • chat_id (Key3) — Foreign key → chat.id — NOT NULL
  • type (Field) — int — NOT NULL

post

  • id (Key) — Primary key — NOT NULL
  • team_data (Key3) — Foreign key → team.id
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field) — string — NOT NULL
  • content (Field2) — string — NOT NULL
  • team (Field3) — string — NOT NULL
  • category (Field4) — string
  • tag (Field5) — string[]
  • created_At (Field6) — string — NOT NULL

seanson_hitter (season_hitter)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → team.id — NOT NULL
  • seanson_year (Field7) — string — NOT NULL
  • ab (Field11) — int
  • avg (Field) — int
  • homerun (Field3) — int
  • rbi (Field4) — int
  • fpct (Field5) — int
  • error (Field6) — int
  • ops (Field8) — int
  • slg (Field9) — int
  • obp (Field10) — int
  • game (Field2) — int

season_pitcher

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → team.id — NOT NULL
  • season_year (Field9) — string — NOT NULL
  • era (Field) — double
  • win (Field3) — int
  • loss (Field4) — int
  • hold (Field5) — int
  • save (Field6) — int
  • inning (Field7) — int — * 10
  • strikeout (Field8) — int
  • game (Field2) — int

team

  • id (Key) — Primary key — NOT NULL
  • name (Field) — stirng — NOT NULL
  • rank (Field2) — int
  • avg (Field3) — int
  • era (Field4) — double

user

  • id (Key) — Primary key — NOT NULL
  • username (Field3) — string — NOT NULL
  • email (Field4) — string — NOT NULL
  • password (Field5) — string — NOT NULL
  • image (Field) — string
  • introduce (Field2) — string
  • team (Field6) — string — NOT NULL
  • is_deleted (Field7) — boolean — NOT NULL
  • is_admin (Field8) — boolean — NOT NULL