Overwatch2

Tables (25)

Esports_team (구단(팀) 정보)

  • team_id (팀 id) — Primary key — NOT NULL
  • team_name (팀 이름)
  • team_score (팀 전적)

admin (관리자)

  • admin_id (관리자 id) — Primary key — NOT NULL
  • admin_name (관리자이름)
  • admin_password (관리자비밀번호)
  • admin_level (관리자 등급)

admin_user_manage (유저관리)

  • manage_id (Key) — Primary key — NOT NULL
  • admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • admin_user_status (관리 상태(경고, 정지, 활동)))

blizzard_account (블리자드)

  • blizzard_id (블리자드 계정) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • battle_tag (배틀태그)
  • blizard_access_token (블리자드 토큰)
  • blizard_link (블리자드 연동 여부) — boolean

board (게시물)

  • board_id (게시글 id) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • board_title (제목)
  • board_cate (게시글 카테고리)
  • board_content (내용)
  • board_date (작성날짜)

board_coach (멘토멘티 모집)

  • coach_id (멘토 id) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • coach_title (글 제목)
  • coach_content (내용)
  • coach_career (멘토 커리어(스펙))
  • coach_date (멘토글 등록일)
  • coach_tier (멘토 티어)

bookmark (북마크)

  • book_date (북마크등록일)
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • board_id (게시글 id) — Foreign key → board.board_id — NOT NULL

coach_tag (멘토멘티 태그)

  • tag_id (태그 id) — Primary key — NOT NULL
  • tag_name (태그 이름)

coach_tag_map (멘토멘티 매핑 테이블)

  • coach_id (멘토 id) — Foreign key → board_coach.coach_id — NOT NULL
  • tag_id (태그 id) — Foreign key → coach_tag.tag_id — NOT NULL

comment (댓글)

  • com_id (댓글 id) — Primary key — NOT NULL
  • member_id (유저아이디(작성자)) — Foreign key → member.member_id — NOT NULL
  • board_id (게시글 id) — Foreign key → board.board_id — NOT NULL
  • com_content (내용)
  • com_date (작성일)
  • com_img (댓글 이미지)
  • com_parent_id (원댓글 id)

esports_player (선수 정보)

  • player_id (선수id) — Primary key — NOT NULL
  • team_id (팀 id) — Foreign key → Esports_team.team_id — NOT NULL
  • player_name (선수 이름)
  • player_position (포지션)
  • player_rank (플레이어 랭킹)
  • player_ability (플레이어 가중치(능력 ))

file (데이터 파일)

  • file_id (파일 id) — Primary key — NOT NULL
  • file_name (파일 명)
  • file_incode (인코딩 명)
  • file_size (파일 크기)

hero_information (영웅정보)

  • hero_id (영웅 id) — Primary key — NOT NULL
  • hero_name (영웅 이름)
  • hero_position (영웅 포지션)
  • hero_img (영웅 이미지)

member (회원)

  • member_id (유저아이디) — Primary key — NOT NULL
  • member_email (이메일)
  • member_name (닉네임)
  • member_password (비밀번호)
  • member_reg (가입일)
  • member_login_provider (SNS 연동 카테고리)
  • member_sns_id (SNS 계정 고유 아이디)

notice (공지사항)

  • notice_id (공지 id) — Primary key — NOT NULL
  • admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
  • notice_title (제목)
  • notice_content (내용)
  • notice_date (작성일)

preference (유저성향)

  • pref_id (성향 id) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • pref_style (플레이스타일)
  • pref_position (선호 포지션)

qna_answer (QnA 답변)

  • answer_id (답글 번호(질문글에 대한)) — Primary key — NOT NULL
  • Admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
  • question_id (질문글 번호) — Foreign key → qna_question.question_id — NOT NULL
  • answer_content (답글 내용)
  • answer_date (답글 작성일)

qna_question (QnA 질문)

  • question_id (질문글 번호) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • question_title (질문글 제목)
  • question_content (질문글 내용)
  • question_date (질문 작성일)

recommend (추천)

  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • like_id (좋아요 id)
  • like_cate (좋아요 카테고리)
  • like_status (좋아요 여부)
  • like_date (좋아요 누른 날짜)

recruit (팀원 모집)

  • rec_id (모집 아이디) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • rec_type (모집 타입)
  • rec_content (모집 내용(메모))
  • rec_position (포지션)
  • rec_tier (티어)
  • rec_date (모집글 등록일)
  • rec_img (이미지)
  • rec_hero_like (선호 영웅)

report (신고)

  • report_id (신고글 id) — Primary key — NOT NULL
  • member_id (유저아이디(신고자 id)) — Foreign key → member.member_id — NOT NULL
  • admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
  • report_cate (신고 카테고리)
  • report_reason (신고 사유)
  • report_date (신고 날짜)
  • report_status (신고 처리 상태)
  • report_end_date (신고 처리 완료 날짜)

review (멘토멘티 글 후기)

  • review_id (리뷰 번호) — Primary key — NOT NULL
  • coach_id (멘토 id) — Foreign key → board_coach.coach_id — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • review_rate (평점)
  • review_date (리뷰 작성일)
  • review_content (리뷰 내용)

sns (SNS 연동)

  • sns_id (SNS 계정 고유 ID) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • sns_cate (SNS 연동 카테고리)

subscription (구독)

  • sub_id (구독 아이디) — Primary key — NOT NULL
  • member_id (유저 아이디) — Foreign key → member.member_id — NOT NULL
  • sub_date (구독 시작일)
  • sub_end_date (구독 만료일)
  • sub_status (구독 활성 여부)
  • sub_renew (자동 연장 여부)
  • sub_cancel (구독 취소일)
  • sub_upgrade (구독 업데이트)

user_data (유저 게임 데이터)

  • user_data_id (데이터 id) — Primary key — NOT NULL
  • member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
  • user_tier (티어)
  • user_position (포지션)
  • user_rank (랭킹)