judge.gg

Tables (5)

comment (Untitled2)

  • id (아이디) — Primary key — NOT NULL
  • post_id (게시글)
  • member_id (작성자)
  • username (닉네임)
  • comment (댓글)
  • created_at (작성일)

member (Untitled4)

  • id — Primary key — NOT NULL
  • username (닉네임)
  • password (비밀번호)
  • role (역할)
  • email (이메일)
  • name (이름)
  • created_at (생성일)
  • updated_at (업데이트일)
  • lol_tier (롤티어)
  • lol_nickname (롤닉네임)
  • lol_usernum (롤유저넘버)
  • val_tier (발티어)
  • val_nickname (발닉네임)
  • val_usernum (발유저넘버)

mentor (Untitled5)

  • id — Primary key — NOT NULL
  • member_id (멤버)
  • game (게임)
  • profile_image (프로필사진)
  • nickname (닉네임)
  • one_line_intro (한줄소개)
  • accounts (계정)
  • characterTags (특징태그)
  • lineTags (라인태그)
  • experienceTags (경력태그)
  • experienceTags (상세경력)
  • detailedIntro (상세소개)
  • rating (평점)
  • reviewCount (리뷰수)
  • responseRate (응답률)
  • totalAnswers (응답수)
  • isOnline (온라인여부)
  • isVerified (승인여부)
  • contact (연락처)
  • gameTag (게임태그)
  • championTags (챔피온태그)
  • experienceDetails (경력상세)
  • curriculum_title (커리큘럼제목)
  • curriculum_description (커리큘럼설명)
  • curriculum_sessions (커리큘럼세션들)

post_lol (Untitled)

  • id (아이디) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • member_id (작성자)
  • username (닉네임)
  • tier (티어)
  • created_at (작성일)
  • comments_count (댓글수)
  • views (조회수)
  • votes (투표)

post_tag (Untitled3)

  • id (아이디) — Primary key — NOT NULL
  • post_id (게시글)
  • tag_id (태그)
  • tag_name (태그명)
  • tag_sort (태그종류)