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