2nd-generation

Tables (5)

Article (article)

  • id (pk) — Primary key — NOT NULL
  • category (News, Event, Recuit)
  • title (SGEA 아카데미 오픈 기념...)
  • sub_title (아카데미 런칭 기념...)
  • content (본문(상세) 내용)
  • thumbnail_url (포스터, 썸네일 이미지)
  • createdAt (생성된 날짜)
  • updatedAt (수정된 날짜)
  • start_date (시작 날짜 (nullable))
  • end_date (종료 날짜 (nullable))

careerHistory

  • id (pk) — Primary key — NOT NULL
  • instructor_id (fk) — Foreign key → instructor.id — NOT NULL
  • period (2018-2019...)
  • team_name (SkyFoxes)
  • role_title (Head Coach, Coach, Player)
  • logo_img_url (팀 로고 링크)
  • createdAt (생성된 시간)
  • updatedAt (수정된 시간)

game

  • id (pk) — Primary key — NOT NULL
  • name (오버워치, 리그오브레전드, 발로란트)
  • game_logo_url (게임 로고 이미지 링크)

instructor

  • id (pk) — Primary key — NOT NULL
  • name (서재원)
  • profile_img_url (프로필 이미지 링크)
  • inActiveAt (비활성화 시간)
  • createdAt (생성된 시간)
  • updatedAt (수정된 시간)
  • sgea_logo_img_url (sgea 로고 url)
  • content (소개글)

instructor_game

  • id (pk) — Primary key — NOT NULL
  • instructor_id (fk) — Foreign key → instructor.id — NOT NULL
  • game_id (fk2) — Foreign key → game.id — NOT NULL