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 (태그종류)