PickFA

Tables (12)

collection (선수 수집)

  • user_id (유저 아이디) — INT — Foreign key → user.id — NOT NULL
  • id (선수 아이디) — Int — Foreign key → spids.id — NOT NULL
  • rating (강화) — INT

comment (댓글)

  • id (pk) — INT — Primary key — NOT NULL
  • id (pk3) — INT — Foreign key → post.id — NOT NULL
  • name (이름) — string
  • content (내용) — string
  • role (역할) — boolean
  • createdAt (생성 시간) — Date
  • groupNum (댓글 인덱스) — INT
  • order (순서) — INT
  • class (계층) — enum

nations (나라)

  • id (pk) — INT — Primary key — NOT NULL
  • name (나라 이름) — string

player_cards (선수 카드)

  • id (pk) — Int — Foreign key → spids.id — NOT NULL
  • nation (나라 이미지) — string
  • salary (급여) — INT
  • image (선수 얼굴 이미지) — string
  • border (테두리 이미지) — string
  • bigSeason (시즌이미지2) — string

post (게시글)

  • id (pk) — INT — Primary key — NOT NULL
  • name (게시글 종류) — string

postion (포지션)

  • id (positionid) — int — Primary key — NOT NULL
  • desc — string
  • part — string

rank (선수 경기 데이터)

  • id (pk) — int — Primary key — NOT NULL
  • name (Field) — string
  • po (Field2)
  • assist (Field3)
  • drrible (Field4)
  • drribleSucceed (Field5)
  • spid (선수 아이디) — Int — Foreign key → spids.id — NOT NULL
  • saving (선방) — string

season (시즌)

  • seasonId (pk) — int — Primary key — NOT NULL
  • classname — string
  • seasonImg (img) — string

spids (선수)

  • id (pk) — Int — Primary key — NOT NULL
  • name — string
  • seasonId (시즌아이디) — int — Foreign key → season.seasonId — NOT NULL
  • post_id (게시글 아이디) — INT — Foreign key → post.id — NOT NULL
  • postion_id (포지션 아이디) — int — Foreign key → postion.id — NOT NULL
  • ovr (총 능력치) — INT
  • nation_id (나라 아이디) — INT — Foreign key → nations.id — NOT NULL

teams (팀)

  • id (pk) — INT — Primary key — NOT NULL
  • spid (선수id) — Int — Foreign key → spids.id — NOT NULL
  • name (팀 이름) — INT

user (사용자)

  • id (pk) — INT — Primary key — NOT NULL
  • username (이름) — string
  • role (역할) — string
  • email (이메일) — string
  • uid (아이디) — string
  • password (비밀번호) — string
  • Field

values (선수 가치)

  • id (primary) — INT — Primary key — NOT NULL
  • rating (row) — INT
  • price (string) — VARCHAR(64)
  • spid (선수 아이디) — Int — Foreign key → spids.id — NOT NULL